TRM

project 17281b46b834719f
Normalized: trm
quickbooks_make toggl
Entity Properties (gold project table)
project_id
17281b46b834719f
name
TRM
client_id
1bdaa35a4db47ba0
billable_rate
135.0
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
—
contract_type
—
contract_hourly_rate
—
contract_estimated_hours
—
contract_total_fee
—
alias_name
Pruitt Solutions - Cloud Migration
project_manager_alias
—
lead_dev_alias
—
qa_partner_alias
—
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
—