Workspace

Data Entities

The data objects that flow between systems and processes — system of origin, key fields, volume, and cardinality.

Entity

System of origin

Key fields

Volume

Cardinality

Vendor

NetSuite

vendor_id, name, terms, region, tax_id

~3,200 active

1:M to invoice

Invoice

NetSuite + Bill.com

invoice_id, vendor_id, po_id, amount, status

~3,000/month

M:1 to vendor

Purchase Order

NetSuite

po_id, vendor_id, lines, requester

~1,400/month

1:M to invoice

Customer

Salesforce → NetSuite

customer_id, terms, credit_limit, region

~1,800 active

1:M to bill

Customer Bill

NetSuite

bill_id, customer_id, amount, status

~2,200/month

M:1 to customer

Payment

Bank portal + NetSuite

payment_id, ref, amount, currency

~3,800/month

M:M

GL Entry

NetSuite

entry_id, account, period, entity, amount

~38,000/month

M:1 to period

Employee

Workday

emp_id, role, region, comp

~4,100

1:M to paystub