TRM
project
17281b46b834719f
Normalized: trm
quickbooks_make
toggl
Entity Properties (gold project table)
project_id
17281b46b834719f
name
TRM
client_id
1bdaa35a4db47ba0
canonical_metadata
—
created_at
2026-04-27 16:47:04.101977+00:00
updated_at
2026-04-27 16:47:04.101977+00:00
status
—
billable
Yes
recurring
—
squad
—
qa_partner
—
project_manager
—
lead_dev
—
description
—
state
—
team_name
—
closedate
—
dealstage
—
deal_amount
—
contract_type
—
contract_hourly_rate
—
contract_estimated_hours
—
contract_total_fee
—
52%
Separation Confidence
How distinct this entity is from others. Higher means no close matches existed when it was created. Lower means a near-match was rejected just below the 80% threshold — worth reviewing.
Moderate — a somewhat similar entity exists
83%
Avg Match Confidence
The average confidence score across all active source mappings. Shows overall quality of linkage between source records and this canonical entity.
Good match quality
Source Mappings (12)
| Source | Source ID | Display Name | Confidence | Method | Status | Actions | |
|---|---|---|---|---|---|---|---|
| quickbooks_make | 18776 | Primrose - TRM | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
18776
balance
0
due_date
2024-05-30 04:00:00+00:00
txn_date
2024-04-30 04:00:00+00:00
total_amt
—
doc_number
22264
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
82
customer_ref__name
Digital Yalo (deleted)
private_note
Primrose - TRM
sales_term_ref__value
3
sales_term_ref__name
Net 30
total_amt__v_double
361.91
balance__v_double
—
|
|||||||
| quickbooks_make | 18310 | Primrose - TRM | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
18310
balance
0
due_date
2024-03-30 04:00:00+00:00
txn_date
2024-02-29 05:00:00+00:00
total_amt
—
doc_number
22204
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
82
customer_ref__name
Digital Yalo (deleted)
private_note
Primrose - TRM
sales_term_ref__value
3
sales_term_ref__name
Net 30
total_amt__v_double
416.17
balance__v_double
—
|
|||||||
| quickbooks_make | 20118 | Primrose - TRM | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
20118
balance
0
due_date
2024-10-30 04:00:00+00:00
txn_date
2024-09-30 04:00:00+00:00
total_amt
—
doc_number
22392
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
82
customer_ref__name
Digital Yalo (deleted)
private_note
Primrose - TRM
sales_term_ref__value
3
sales_term_ref__name
Net 30
total_amt__v_double
1158.32
balance__v_double
—
|
|||||||
| quickbooks_make | 19139 | Primrose - TRM | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
19139
balance
0
due_date
2024-06-30 04:00:00+00:00
txn_date
2024-05-31 04:00:00+00:00
total_amt
—
doc_number
22285
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
82
customer_ref__name
Digital Yalo (deleted)
private_note
Primrose - TRM
sales_term_ref__value
3
sales_term_ref__name
Net 30
total_amt__v_double
334.13
balance__v_double
—
|
|||||||
| quickbooks_make | 20427 | Primrose - TRM | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
20427
balance
0
due_date
2024-11-30 05:00:00+00:00
txn_date
2024-10-31 04:00:00+00:00
total_amt
—
doc_number
22412
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
82
customer_ref__name
Digital Yalo (deleted)
private_note
Primrose - TRM
sales_term_ref__value
3
sales_term_ref__name
Net 30
total_amt__v_double
385.62
balance__v_double
—
|
|||||||
| quickbooks_make | 19283 | Primrose - TRM | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
19283
balance
0
due_date
2024-07-30 04:00:00+00:00
txn_date
2024-06-30 04:00:00+00:00
total_amt
—
doc_number
22308
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
82
customer_ref__name
Digital Yalo (deleted)
private_note
Primrose - TRM
sales_term_ref__value
3
sales_term_ref__name
Net 30
total_amt__v_double
502.33
balance__v_double
—
|
|||||||
| quickbooks_make | 18089 | Primrose - TRM | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
18089
balance
0
due_date
2024-03-01 05:00:00+00:00
txn_date
2024-01-31 05:00:00+00:00
total_amt
—
doc_number
22189
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
82
customer_ref__name
Digital Yalo (deleted)
private_note
Primrose - TRM
sales_term_ref__value
3
sales_term_ref__name
Net 30
total_amt__v_double
411.19
balance__v_double
—
|
|||||||
| quickbooks_make | 19599 | Primrose - TRM | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
19599
balance
0
due_date
2024-08-30 04:00:00+00:00
txn_date
2024-07-31 04:00:00+00:00
total_amt
—
doc_number
22336
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
82
customer_ref__name
Digital Yalo (deleted)
private_note
Primrose - TRM
sales_term_ref__value
3
sales_term_ref__name
Net 30
total_amt__v_double
283.58
balance__v_double
—
|
|||||||
| quickbooks_make | 19840 | Primrose - TRM | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
19840
balance
0
due_date
2024-10-03 04:00:00+00:00
txn_date
2024-08-31 04:00:00+00:00
total_amt
—
doc_number
22364
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
82
customer_ref__name
Digital Yalo (deleted)
private_note
Primrose - TRM
sales_term_ref__value
3
sales_term_ref__name
Net 30
total_amt__v_double
292.77
balance__v_double
—
|
|||||||
| quickbooks_make | 18544 | Primrose - TRM | 0.80 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_quickbooks_make_qbo_invoices
id
18544
balance
0
due_date
2024-04-30 04:00:00+00:00
txn_date
2024-03-31 04:00:00+00:00
total_amt
—
doc_number
22240
currency_ref__value
USD
currency_ref__name
United States Dollar
customer_ref__value
82
customer_ref__name
Digital Yalo (deleted)
private_note
Primrose - TRM
sales_term_ref__value
3
sales_term_ref__name
Net 30
total_amt__v_double
928.45
balance__v_double
—
|
|||||||
| toggl | 171715022 | TRM | 1.00 | exact | Active |
|
|
|
Source Record
bronze_toggl_projects
id
171715022
workspace_id
5511582
client_id
56079378
name
TRM
is_private
—
active
No
updated_at
—
created_at
2021-07-16T17:17:21+00:00
color
#c7af14
billable
Yes
template
—
auto_estimates
—
rate
135.0
currency
USD
recurring
—
actual_hours
—
actual_seconds
—
client_name
—
status
—
|
|||||||
| toggl | 178978719 | TRM | 1.00 | fuzzy+embedding | Active |
|
|
|
Source Record
bronze_toggl_projects
id
178978719
workspace_id
5511582
client_id
56079378
name
TRM
is_private
—
active
No
updated_at
—
created_at
2022-01-31T16:53:07+00:00
color
#c9806b
billable
Yes
template
—
auto_estimates
—
rate
140.0
currency
USD
recurring
—
actual_hours
—
actual_seconds
—
client_name
—
status
—
|
|||||||