Skip to content

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