AR_AUTOREC_INTERIM

The AR_AUTOREC_INTERIM table is a temporary table used for parallel processing of automatic receipts.

Details

Name	Datatype	Length	Precision	Not-null	Comments
BATCH_ID	NUMBER		18		Batch Identifier
PAYMENT_SCHEDULE_ID	NUMBER		18		Payment schedule identifier
CUSTOMER_TRX_ID	NUMBER		18		Transaction identifier
CASH_RECEIPT_ID	NUMBER		18		Cash receipt identifier.
PAYING_CUSTOMER_ID	NUMBER		18		Customer identifier
PAYING_SITE_USE_ID	NUMBER		18		Site use identifier
PAYMENT_TRXN_EXTENSION_ID	NUMBER		18		Payment transaction extension identifier
DUE_DATE	DATE				Date payment is due on a transaction without incurring extra charges.
AMOUNT_DUE_REMAINING	NUMBER				Remaining amount
CUSTOMER_BANK_ACCOUNT_ID	NUMBER		18		Customer bank account identifier
CUST_MIN_AMOUNT	NUMBER				Minimum amount
PAYMENT_CHANNEL_CODE	VARCHAR2	30			Payment channel code
PAYMENT_INSTRUMENT	VARCHAR2	30			Payment instrument
WORKER_ID	NUMBER		18		Worker number
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.