app.integration_ledger_queue
Vista
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.
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| integration_connection_id | uuid | Sí | Accounting connection to export to. |
| org_id | uuid | Sí | Org of the posting. |
| journal_entry_id | uuid | Sí | Journal entry the line belongs to; the unit of export. |
| memo | text | Sí | Journal entry memo. |
| posting_line_id | uuid | Sí | Journal line. |
| line_number | integer | Sí | Line number within the entry. |
| date | date | Sí | Recognition date. |
| project_id | uuid | Sí | Project of the entry, when it has one. |
| account_code | text | Sí | GL account from the fixed chart. |
| cost_center_code | text | Sí | Dimension 1 cost center code. |
| urid | text | Sí | Dimension 2 discipline or category. |
| counterparty_id | uuid | Sí | Counterparty of the line. |
| description | text | Sí | Line description. |
| quantity | numeric | Sí | Quantity. |
| unit_basis | text | Sí | Unit. |
| amount_minor | bigint | Sí | Signed amount in minor units: debits positive, credits negative. |
| currency_code | character(3) | Sí | ISO 4217 currency of the line. |
| minor_unit_exponent | smallint | Sí | Decimal places of the currency's minor unit. |
| tax_type | xpms.canon_text | Sí | Tax type of the account. |