JL_BR_AR_REC_MET_ACCTS_DTL_ALL
This is an obsolete table and not in use.
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 |