app.posting_lines
View
The Universal Posting Line (Section 3.11, Bible tab 36): every posted journal line in the one export shape projected to Xero, QuickBooks Online, NetSuite and Ramp. Derived, never stored.
| Column | Type | Nullable | Description |
|---|---|---|---|
| posting_line_id | uuid | Yes | Journal line the posting line is. |
| org_id | uuid | Yes | Org of the posting. |
| project_id | uuid | Yes | Project of the entry, when it has one. |
| date | date | Yes | ISO 8601 date the cost or revenue is recognized. |
| account_code | text | Yes | GL account from the fixed chart. |
| cost_center_id | text | Yes | Dimension 1 cost center code. |
| urid | text | Yes | Dimension 2 discipline or category. |
| vendor_id | uuid | Yes | Counterparty of the line, or NULL for revenue. |
| item_id | text | Yes | Catalog element, when one applies. |
| description | text | Yes | Sentence-case line description. |
| quantity | numeric | Yes | Quantity. |
| unit_basis | text | Yes | Unit from the controlled unit list. |
| amount_minor | bigint | Yes | Signed amount in minor units: debits positive, credits negative. |
| tax_type | xpms.canon_text | Yes | Tax type of the account. |
| currency | character(3) | Yes | ISO 4217 currency. |
| external_ref | uuid | Yes | Id of the source document, or of the entry when prepared by hand. |
| line_state | text | Yes | Shared state vocabulary value: posted lines are Complete. |