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