app.integration_ledger_queue
View
Universal Posting Lines (Section 3.11) of posted journal entries that a Connected accounting connection has not exported yet. The connector exports each journal entry whole, then maps it in app.integration_external_ids, which removes its lines from the queue.
| Column | Type | Nullable | Description |
|---|---|---|---|
| integration_connection_id | uuid | Yes | Accounting connection to export to. |
| org_id | uuid | Yes | Org of the posting. |
| journal_entry_id | uuid | Yes | Journal entry the line belongs to; the unit of export. |
| memo | text | Yes | Journal entry memo. |
| posting_line_id | uuid | Yes | Journal line. |
| line_number | integer | Yes | Line number within the entry. |
| date | date | Yes | Recognition date. |
| project_id | uuid | Yes | Project of the entry, when it has one. |
| account_code | text | Yes | GL account from the fixed chart. |
| cost_center_code | text | Yes | Dimension 1 cost center code. |
| urid | text | Yes | Dimension 2 discipline or category. |
| counterparty_id | uuid | Yes | Counterparty of the line. |
| description | text | Yes | Line description. |
| quantity | numeric | Yes | Quantity. |
| unit_basis | text | Yes | Unit. |
| amount_minor | bigint | Yes | Signed amount in minor units: debits positive, credits negative. |
| currency_code | character(3) | Yes | ISO 4217 currency of the line. |
| minor_unit_exponent | smallint | Yes | Decimal places of the currency's minor unit. |
| tax_type | xpms.canon_text | Yes | Tax type of the account. |