# report_ar_documents

<!-- Generated from apps/irrigation/dbt_redshift/models/client_data/sources.yml. Do not edit by hand — run `make generate-client-data-dictionary`. -->

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 |