app.posting_lines
Vista
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.
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| posting_line_id | uuid | Sí | Journal line the posting line is. |
| org_id | uuid | Sí | Org of the posting. |
| project_id | uuid | Sí | Project of the entry, when it has one. |
| date | date | Sí | ISO 8601 date the cost or revenue is recognized. |
| account_code | text | Sí | GL account from the fixed chart. |
| cost_center_id | text | Sí | Dimension 1 cost center code. |
| urid | text | Sí | Dimension 2 discipline or category. |
| vendor_id | uuid | Sí | Counterparty of the line, or NULL for revenue. |
| item_id | text | Sí | Catalog element, when one applies. |
| description | text | Sí | Sentence-case line description. |
| quantity | numeric | Sí | Quantity. |
| unit_basis | text | Sí | Unit from the controlled unit list. |
| amount_minor | bigint | Sí | Signed amount in minor units: debits positive, credits negative. |
| tax_type | xpms.canon_text | Sí | Tax type of the account. |
| currency | character(3) | Sí | ISO 4217 currency. |
| external_ref | uuid | Sí | Id of the source document, or of the entry when prepared by hand. |
| line_state | text | Sí | Shared state vocabulary value: posted lines are Complete. |