JL_BR_AR_REC_MET_ACCTS_DTL

Details

Schema: FUSION
Object owner: JL
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
JL_BR_AR_REC_MET_ACCTS_DT_PK	REC_MET_ACCTS_DTL_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
REC_MET_ACCTS_DTL_ID	NUMBER		18	Yes	Receipt method accounts unique identifier.
REC_MET_ACCTS_EXT_ID	NUMBER		18	Yes	Receipt method accounts unique identifier on the extension entity.
BANK_ACCOUNT_ID	NUMBER		18		Bank account unique identifier associated with a receipt method.
RECEIPT_METHOD_ID	NUMBER		18	Yes	Receipt method unique identifier defined in receivables application.
BANK_ACCT_USE_ID	NUMBER		18	Yes	Bank account use unique identifier associated with a receipt method.
ORG_ID	NUMBER		18	Yes	Indicates the identifier of the business unit associated to the row.
LEDGER_ID	NUMBER		18	Yes	An unique identifier for ledger associated with billing business unit.
CALCULATED_INTEREST_CCID	NUMBER		18		Code combination unique identifier of accounting flexfield for calculated interest.
INTEREST_WRITEOFF_CCID	NUMBER		18		Code combination unique identifier of accounting flexfield for interest write-off.
ABATEMENT_WRITEOFF_CCID	NUMBER		18		Code combination unique identifier of accounting flexfield for negative adjustment write-off.
ABATEMENT_REVENUE_CCID	NUMBER		18		Code combination unique identifier of accounting flexfield for negative adjustment revenue.
INTEREST_REVENUE_CCID	NUMBER		18		Code combination unique identifier of accounting flexfield for interest revenue adjustment.
CALCULATED_INTEREST_RECTRX_ID	NUMBER		18		Adjustment activity unique identifier for calculated interest.
INTEREST_WRITEOFF_RECTRX_ID	NUMBER		18		Adjustment activity unique identifier for interest write-off.
INTEREST_REVENUE_RECTRX_ID	NUMBER		18		Adjustment activity unique identifier for interest revenue.
ABATEMENT_WRITEOFF_RECTRX_ID	NUMBER		18		Adjustment activity unique identifier for negative adjustment write-off.
ABATEMENT_REVENUE_RECTRX_ID	NUMBER		18		Adjustment activity unique identifier for negative adjustment revenue.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated 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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
JL_BR_AR_REC_MET_ACCTS_DTL_ALL	ar_receipt_method_accounts_all	RECEIPT_METHOD_ID, BANK_ACCOUNT_ID
JL_BR_AR_REC_MET_ACCTS_DTL_ALL	gl_code_combinations	INTEREST_REVENUE_CCID
JL_BR_AR_REC_MET_ACCTS_DTL_ALL	ce_bank_acct_uses_all	BANK_ACCT_USE_ID
JL_BR_AR_REC_MET_ACCTS_DTL_ALL	jl_br_ar_rec_met_accts_ext_all	REC_MET_ACCTS_EXT_ID
JL_BR_AR_REC_MET_ACCTS_DTL_ALL	gl_code_combinations	CALCULATED_INTEREST_CCID
JL_BR_AR_REC_MET_ACCTS_DTL_ALL	gl_code_combinations	INTEREST_WRITEOFF_CCID
JL_BR_AR_REC_MET_ACCTS_DTL_ALL	gl_code_combinations	ABATEMENT_WRITEOFF_CCID

Indexes

Index	Uniqueness	Tablespace	Columns
JL_BR_AR_REC_MET_ACC_DTL_U1	Unique	Default	REC_MET_ACCTS_DTL_ID
JL_BR_AR_REC_MET_ACC_DTL_U2	Unique	Default	BANK_ACCT_USE_ID, RECEIPT_METHOD_ID, ORG_ID