JL_BR_AR_REC_MET_ACCTS_EXT_ALL
This table stores the receipt method accounts.
Details
-
Schema: FUSION
-
Object owner: JL
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
Name | Columns |
---|---|
JL_BR_AR_REC_MET_ACC_EXT_PK |
REC_MET_ACCTS_EXT_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
BANK_ACCOUNT_ID | NUMBER | 18 | Identifier for the bank account used by the deploying company or by the supplier or supplier site. | Active | ||
RECEIPT_METHOD_ID | NUMBER | 18 | Yes | Receipt method identifier for receipt method account. | Active | |
BANK_CHARGES_CCID | NUMBER | 18 | No longer used. | Active | ||
COLL_ENDORSEMENT_CCID | NUMBER | 18 | No longer used. | Active | ||
BILLS_COLLECTION_CCID | NUMBER | 18 | No longer used. | Active | ||
OTHER_CREDITS_CCID | NUMBER | 18 | No longer used. | Active | ||
FACTORING_DOCS_CCID | NUMBER | 18 | No longer used. | Active | ||
PORTFOLIO_CODE | NUMBER | Portfolio code assigned by the bank for the account. | Active | |||
MIN_DOCUMENT_AMOUNT | NUMBER | Minimum amount for a document in a remittance batch. | Active | |||
MAX_DOCUMENT_AMOUNT | NUMBER | Maximum amount for a document in a remittance batch. | Active | |||
MIN_REMITTANCE_AMOUNT | NUMBER | Minimum amount for a remittance batch. | Active | |||
MAX_REMITTANCE_AMOUNT | NUMBER | Maximum amount for a remittance batch. | Active | |||
BANK_INSTRUCTION_CODE1 | NUMBER | Bank instruction code 1 of receipt method account. | Active | |||
BANK_INSTRUCTION_CODE2 | NUMBER | Bank instruction code 2 of receipt method account. | Active | |||
BANK_CHARGE_AMOUNT | NUMBER | No longer used. | Active | |||
FACTORING_RATE | NUMBER | No longer used. | Active | |||
FACTORING_RATE_PERIOD | NUMBER | No longer used. | Active | |||
BATCH_SOURCE_ID | NUMBER | 18 | Batch source identifier of receipt method account. | Active | ||
CALCULATED_INTEREST_CCID | NUMBER | 18 | No longer used. | Active | ||
INTEREST_WRITEOFF_CCID | NUMBER | 18 | No longer used. | Active | ||
FACTORING_INTEREST_CCID | NUMBER | 18 | No longer used. | Active | ||
ABATEMENT_WRITEOFF_CCID | NUMBER | 18 | No longer used. | Active | ||
ABATEMENT_REVENUE_CCID | NUMBER | 18 | No longer used. | Active | ||
INTEREST_REVENUE_CCID | NUMBER | 18 | No longer used. | Active | ||
CALCULATED_INTEREST_RECTRX_ID | NUMBER | 18 | No longer used. | Active | ||
INTEREST_WRITEOFF_RECTRX_ID | NUMBER | 18 | No longer used. | Active | ||
INTEREST_REVENUE_RECTRX_ID | NUMBER | 18 | No longer used. | Active | ||
ABATEMENT_WRITEOFF_RECTRX_ID | NUMBER | 18 | No longer used. | Active | ||
ABATEMENT_REVENUE_RECTRX_ID | NUMBER | 18 | No longer used. | Active | ||
WRITEOFF_PERC_TOLERANCE | NUMBER | Tolerance limit for automatic interest write-off, expressed as a percentage. | Active | |||
WRITEOFF_AMOUNT_TOLERANCE | NUMBER | Tolerance limit for automatic interest write-off, expressed as an amount. | Active | |||
GL_DATE_BANK_RETURN | VARCHAR2 | 15 | Accounting date for receipts generated by bank return. | Active | ||
FLOATING | NUMBER | 3 | Bank floating days to calculate the accounting date for receipts generated by bank return. | Active | ||
ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | Active | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
DISC_ENDORSEMENT_CCID | NUMBER | 18 | No longer used. | Active | ||
BILLS_DISCOUNT_CCID | NUMBER | 18 | No longer used. | Active | ||
FACTORING_CHARGES_CCID | NUMBER | 18 | No longer used. | Active | ||
DISCOUNTED_BILLS_CCID | NUMBER | 18 | No longer used. | Active | ||
BANK_ACCT_USE_ID | NUMBER | 18 | Yes | Unique identifier for the bank account use. | Active | |
COLL_REMITTANCE_MEDIA | VARCHAR2 | 30 | Collection remittance media of receipt method account. | Active | ||
COLL_FORMAT_PGM_ID | NUMBER | 18 | No longer used. | Active | ||
FACTOR_REMITTANCE_MEDIA | VARCHAR2 | 30 | No longer used. | Active | ||
FACTOR_FORMAT_PGM_ID | NUMBER | 18 | No longer used. | Active | ||
OCC_REP_FORMAT_PGM_ID | NUMBER | 18 | No longer used. | Active | ||
OCC_FILE_FORMAT_PGM_ID | NUMBER | 18 | No longer used. | Active | ||
MAX_COLLECTION_DOCS | NUMBER | Maximum number of bank collection documents. | 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. | Active | |
REC_MET_ACCTS_EXT_ID | NUMBER | 18 | Yes | Receipt method accounts unique identifier on the extension entity. | Active | |
PRINT_COLL_DOC_FOR_CUST_FLAG | VARCHAR2 | 1 | Flag to indicate whether collection documents should be printed for customers. | Active | ||
COLL_DOC_CUST_PRINT_PGM_ID | NUMBER | 18 | No longer used. | Active | ||
BANK_SERVICE_CODE | VARCHAR2 | 30 | Code to indicate the service agreement with the bank. | Active | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
COLL_FORMAT_PGM | VARCHAR2 | 100 | Collection Remittance Batch Format program. | |||
OCC_REP_FORMAT_PGM | VARCHAR2 | 100 | Occurrence Report Format Program. | |||
OCC_FILE_FORMAT_PGM | VARCHAR2 | 100 | Occurrence File Format Program. | |||
COLL_DOC_CUST_PRINT_PGM | VARCHAR2 | 100 | Yes | Collection Document Print for Customer prgram. | ||
PIX_PROCESSING_FLAG | VARCHAR2 | 1 | Indicates whether the transactions are processed through the Brazilian Central Bank instant payment system. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
JL_BR_AR_REC_MET_ACCTS_EXT_ALL | ar_receipt_method_accounts_all | RECEIPT_METHOD_ID, BANK_ACCOUNT_ID |
JL_BR_AR_REC_MET_ACCTS_EXT_ALL | ar_batch_sources_all | BATCH_SOURCE_ID |
JL_BR_AR_REC_MET_ACCTS_EXT_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 |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
JL_BR_AR_REC_MET_ACC_EXT_U1 | Unique | FUSION_TS_TX_IDX | REC_MET_ACCTS_EXT_ID | Active |
JL_BR_AR_REC_MET_ACC_EXT_U2 | Unique | FUSION_TS_TX_IDX | ORG_ID, BANK_ACCT_USE_ID, RECEIPT_METHOD_ID | Active |