JL_BR_AR_RET_INTERFACE_TMP

This is a temporary table which is used internally by Oracle.

Details

• Schema: FUSION

• Object owner: JL

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
JL_BR_AR_RET_INTERFACE_TMP_PK	RETURN_REQUEST_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
RETURN_REQUEST_ID	NUMBER		18	Yes	Return concurrent request identifier.	Active
ABATEMENT_TOTAL_NUMBER	NUMBER				Total number of abatement records in bank collection interface.	Active
ABATEMENT_TOTAL_EXPECTED	NUMBER				Total abatement amount expected in bank collection interface.	Active
ABATEMENT_TOTAL_RECEIVED	NUMBER				Total abatement amount received in bank collection interface.	Active
ABATEMENT_ADJ_AMOUNT	NUMBER				Total abatement adjustment amount in bank collection interface.	Active
INTEREST_TOTAL_NUMBER	NUMBER				Number of records with interest in bank collection interface.	Active
INTEREST_TOTAL_EXPECTED	NUMBER				Total calculated interest amount in bank collection interface.	Active
INTEREST_TOTAL_RECEIVED	NUMBER				Total interest amount received in bank collection interface.	Active
INTEREST_DM_AMOUNT	NUMBER				Total interest debit memos amount in bank collection interface.	Active
INTEREST_ADJ_AMOUNT	NUMBER				Total interest adjustment amount in bank collection interface.	Active
DISCOUNT_TOTAL_NUMBER	NUMBER				Number of records with discounts in bank collection interface.	Active
DISCOUNT_TOTAL_EXPECTED	NUMBER				Total calculated discount amount in bank collection interface.	Active
DISCOUNT_TOTAL_RECEIVED	NUMBER				Total discount amount received in bank collection interface.	Active
BANK_NUMBER	VARCHAR2	30			Unique numeric identifier for a bank.	Active
BANK_PARTY_ID	NUMBER		18		Party identifier for the bank associated with the first party.	Active
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.

Indexes

Index	Uniqueness	Tablespace	Columns	Status
JL_BR_AR_RET_INTERFACE_TMP_U1	Unique	FUSION_TS_TX_DATA	RETURN_REQUEST_ID	Active