AP_BROKER_COMMISSIONS

Description: |
This table contains data related to broker commission transactions.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
TX_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
The unique identifier (.1 item) for the transaction record.
2 | AP_CYCLE_STATUS_C_NAME | VARCHAR | No |
The AP Cycle status of transactions for NUR based transactions.
May contain organization-specific values: No
Category Entries:
Not in AP
Ready To Batch
Batched
3 | EFF_DATE | DATETIME | No |
Contains first of month as the date for which the batch containing this transaction is filed.
4 | TX_STATUS_C_NAME | VARCHAR | No |
The status of the transaction.
May contain organization-specific values: No
Category Entries:
Loaded
Reconciled
Calculated
AP Batched
Paid
Void
New
Fully Invoiced