report_ar_documents
Issued accounts receivable documents for client workspaces.
| Column | Description |
|---|---|
document_id |
Unique string identifier for the financial document |
display_document_number |
Human-readable document number |
booking_id |
Identifier of the booking the document was issued against |
workspace_id |
Identifier of the workspace that owns the document |
party_type |
Type of party associated with the document |
party_external_id |
External identifier of the party associated with the document |
document_type |
Type of financial document |
reconciliation_category |
Category used to reconcile the document in accounts receivable |
signed_value_minor_units |
Signed document value in the minor units of the paired currency |
currency |
ISO 4217 currency code paired with signed_value_minor_units |
issued |
Whether the document has been issued |
publishing_date |
Date the document was published, if published |
document_date |
Date associated with the document |
inserted_at |
Timestamp when the document was inserted into the source read model |
updated_at |
Timestamp when the document was last updated in the source read model |
external_crm_id |
External CRM identifier of the contact the document was issued to. NULL when the contact has no CRM link, and for historical documents issued before the CRM identifier was recorded |
workspace_name |
Name of the workspace that owns the document, recorded when the document is issued. Historical documents backfilled by Abacus carry the workspace’s current name. NULL when unavailable |
timestamp |
Date when the table was last synchronized |