AR_RECEIPT_METHOD_ACCOUNTS_ALL
The AR_RECEIPT_METHOD_ACCOUNTS_ALL table is an intersection of payment methods and bank accounts. For each receipt method, every bank account that can handle this payment method is defined as a row in this table. The accounting entries that are used for each step of the life cycle of the receipt are also defined at this level, so they can vary by payment method and bank accounts. . The primary keys for this table are BANK_ACCOUNT_ID and RECEIPT_METHOD_ID.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
AR_RECEIPT_METHOD_ACCOUNTS_PK |
RECEIPT_METHOD_ID, REMIT_BANK_ACCT_USE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
---|---|---|---|---|---|---|
BANK_ACCOUNT_ID | NUMBER | 18 | Remittance bank account identifier. | |||
BANK_ACCT_CREATION_SRC_CODE | VARCHAR2 | 30 | Lookup codes under the ORA_CE_ACCOUNT_CREATION_SOURCE lookup type that determines the source of bank onboarding | |||
RECEIPT_METHOD_ID | NUMBER | 18 | Yes | Identifier of the receipt method associated with this bank account | ||
BANK_ONBOARDING_REQUEST_ID | NUMBER | 18 | Request Identifier for Cash Management Bank Onboarding process | |||
CASH_CCID | NUMBER | 18 | Yes | Identifier of the Accounting Flexfield for the Cash Account | ||
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. | |||
EARNED_CCID | NUMBER | 18 | Identifier of the Accounting Flexfield for the Earned Account | |||
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. | |||
ON_ACCOUNT_CCID | NUMBER | 18 | Yes | Identifier of the Accounting Flexfield for the On Account Account | ||
START_DATE | DATE | Yes | Date this combination of receipt method and bank account is active | |||
UNAPPLIED_CCID | NUMBER | 18 | Yes | Identifier of the Accounting Flexfield for the Unapplied Account | ||
UNEARNED_CCID | NUMBER | 18 | Identifier of the Accounting Flexfield for the Unearned Account | |||
UNIDENTIFIED_CCID | NUMBER | 18 | Yes | Identifier of the Accounting Flexfield for the Unidentified Account | ||
BANK_CHARGES_CCID | NUMBER | 18 | Identifier of the Accounting Flexfield for the Bank Charges Account | |||
END_DATE | DATE | Date this combination of receipt method and bank account is inactive | ||||
FACTOR_CCID | NUMBER | 18 | Identifier of the Accounting Flexfield for the Factor Account | |||
FACTOR_PRINT_PROGRAM_ID | NUMBER | 18 | Identifier of the program that will be used to print receipt that are selected for factoring and which use these receipt method and bank account | |||
FACTOR_TRANSMISSION_PROGRAM_ID | NUMBER | 18 | Identifier of the program that will be used to transmit receipt that are selected for factoring and which use these receipt method and bank account | |||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
MIN_RECEIPT_AMOUNT | NUMBER | Indicates the minimum receipt amount in this currency that must be specified when an automatic receipt is created with this payment method | ||||
RECEIPT_CLEARING_CCID | NUMBER | 18 | Identifier of the Accounting Flexfield for the Receipt Confirmation Account | |||
REMITTANCE_CCID | NUMBER | 18 | Identifier of the Accounting Flexfield for the Remittance Account | |||
REMIT_PRINT_PROGRAM_ID | NUMBER | 18 | Identifier of the program that will be used to print automatic receipts that are selected for remittance and which use these receipt method and bank account | |||
REMIT_TRANSMISSION_PROGRAM_ID | NUMBER | 18 | Identifier of the program that will be used to transmit automatic receipts that are selected for remittance and which use these receipt method and bank account | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Remittance Bank (AR_RECEIPT_METHOD_ACCOUNTS) | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Remittance Bank (AR_RECEIPT_METHOD_ACCOUNTS) | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Remittance Bank (AR_RECEIPT_METHOD_ACCOUNTS) | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Remittance Bank (AR_RECEIPT_METHOD_ACCOUNTS) | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Remittance Bank (AR_RECEIPT_METHOD_ACCOUNTS) | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Remittance Bank (AR_RECEIPT_METHOD_ACCOUNTS) | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Remittance Bank (AR_RECEIPT_METHOD_ACCOUNTS) | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Remittance Bank (AR_RECEIPT_METHOD_ACCOUNTS) | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Remittance Bank (AR_RECEIPT_METHOD_ACCOUNTS) | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Remittance Bank (AR_RECEIPT_METHOD_ACCOUNTS) | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Remittance Bank (AR_RECEIPT_METHOD_ACCOUNTS) | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Remittance Bank (AR_RECEIPT_METHOD_ACCOUNTS) | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Remittance Bank (AR_RECEIPT_METHOD_ACCOUNTS) | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Remittance Bank (AR_RECEIPT_METHOD_ACCOUNTS) | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Remittance Bank (AR_RECEIPT_METHOD_ACCOUNTS) | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Remittance Bank (AR_RECEIPT_METHOD_ACCOUNTS) | ||
PRIMARY_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether this remittance bank is the primary bank account in this currency for this payment method | ||
CLEARING_DAYS | NUMBER | 5 | This stores the number of clearing days it takes for a bank account to clear a payment method. On a factored receipt, it is also the number of days after maturity date when customer risk of non-payment is eliminated. | |||
SHORT_TERM_DEBT_CCID | NUMBER | 18 | Stores the short term debt liability account that is credited when receipts are factored to the bank. The account is debited at risk elimination time. It is mandatory for receipt classes whose remit_method_code allows factoring. | |||
OVERRIDE_REMIT_ACCOUNT_FLAG | VARCHAR2 | 1 | This column will be used to default the OVERRIDE_REMIT_ACCOUNT_FLAG for receipts created with this payment method and bank account combination. It is considered Y when null. | |||
RISK_ELIMINATION_DAYS | NUMBER | 5 | Stores the number of days after the maturity date of a discounted receipt before the risk of non-payment of the receipt can be eliminated. The Automatic Clearing program uses this date. It is 0 when null. | |||
ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
EDISC_RECEIVABLES_TRX_ID | NUMBER | 18 | Foreign key to AR_RECEIVABLES_TRX. This indicates the Receivables Activity to use when accounting for tax on earned discounts. | |||
UNEDISC_RECEIVABLES_TRX_ID | NUMBER | 18 | Foreign key to AR_RECEIVABLES_TRX. This indicates the Receivables Activity to use when accounting for tax on unearned discounts. | |||
BR_COLLECTION_DAYS | NUMBER | 5 | Minimum number of days that the remittance bank uses to collect on a bill receivable that is remitted after the maturity date. | |||
BR_STD_RECEIVABLES_TRX_ID | NUMBER | 18 | Receivables activity identifer used for the short term debt of a remittance bank account. | |||
BR_REMITTANCE_CCID | NUMBER | 18 | Account identifier for recording remitted bills receivable. | |||
BR_FACTOR_CCID | NUMBER | 18 | Account identifier for recording factored bills receivable. | |||
CLAIM_RECEIVABLES_TRX_ID | NUMBER | 18 | Foreign key to AR_RECEIVABLES_TRX. Indicates the receivable activity to use for claim investigation accounting. | |||
REMIT_BANK_ACCT_USE_ID | NUMBER | 18 | Yes | Identifier of the bank account associated with this receipt method | ||
OLD_BANK_ACCOUNT_ID | NUMBER | 18 | Old Identifier of the bank account associated with this receipt method | |||
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 |
---|---|---|
AR_RECEIPT_METHOD_ACCOUNTS_ALL | gl_code_combinations | CASH_CCID |
AR_RECEIPT_METHOD_ACCOUNTS_ALL | gl_code_combinations | RECEIPT_CLEARING_CCID |
AR_RECEIPT_METHOD_ACCOUNTS_ALL | ar_receivables_trx_all | EDISC_RECEIVABLES_TRX_ID, ORG_ID |
AR_RECEIPT_METHOD_ACCOUNTS_ALL | ar_receivables_trx_all | UNEDISC_RECEIVABLES_TRX_ID, ORG_ID |
AR_RECEIPT_METHOD_ACCOUNTS_ALL | ce_bank_acct_uses_all | REMIT_BANK_ACCT_USE_ID |
AR_RECEIPT_METHOD_ACCOUNTS_ALL | ar_receipt_methods | RECEIPT_METHOD_ID |
AR_RECEIPT_METHOD_ACCOUNTS_ALL | gl_code_combinations | SHORT_TERM_DEBT_CCID |
AR_RECEIPT_METHOD_ACCOUNTS_ALL | gl_code_combinations | EARNED_CCID |
AR_RECEIPT_METHOD_ACCOUNTS_ALL | gl_code_combinations | ON_ACCOUNT_CCID |
AR_RECEIPT_METHOD_ACCOUNTS_ALL | gl_code_combinations | UNAPPLIED_CCID |
AR_RECEIPT_METHOD_ACCOUNTS_ALL | gl_code_combinations | UNEARNED_CCID |
AR_RECEIPT_METHOD_ACCOUNTS_ALL | gl_code_combinations | UNIDENTIFIED_CCID |
AR_RECEIPT_METHOD_ACCOUNTS_ALL | gl_code_combinations | BANK_CHARGES_CCID |
AR_RECEIPT_METHOD_ACCOUNTS_ALL | gl_code_combinations | FACTOR_CCID |
AR_RECEIPT_METHOD_ACCOUNTS_ALL | gl_code_combinations | REMITTANCE_CCID |
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_ext_all | ar_receipt_method_accounts_all | RECEIPT_METHOD_ID, BANK_ACCOUNT_ID |
jl_br_ar_collection_docs_all | ar_receipt_method_accounts_all | RECEIPT_METHOD_ID, BANK_ACCOUNT_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
AR_RECEIPT_METHOD_ACCOUNTS_U1 | Unique | Default | RECEIPT_METHOD_ID, REMIT_BANK_ACCT_USE_ID |