1. Tables and Views for Financials
  2. JL_BR_AR_COLLECTION_DOCS_ALL

JL_BR_AR_COLLECTION_DOCS_ALL

This table stores the collection documents.

Details

  • Schema: FUSION

  • Object owner: JL

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

JL_BR_AR_COLLEC_DOCS_ALL_PK

DOCUMENT_ID

Columns

Name Datatype Length Precision Not-null Comments Status
DOCUMENT_ID NUMBER 18 Yes Bank collection document identifier. Active
BORDERO_ID NUMBER 18 No longer used. Active
PAYMENT_SCHEDULE_ID NUMBER 18 No longer used. Active
DOCUMENT_STATUS VARCHAR2 30 Yes Document status. Values are from the lookup JLBR_AR_COLLECTION_DOCS_STATUS. Active
ORIGIN_TYPE VARCHAR2 30 Yes Origin type on a bank collection document. Active
DUE_DATE DATE Yes Due date on a bank collection document. Active
SELECTION_DATE DATE Yes Date on which a bank collection document was selected in a remittance batch. Active
PORTFOLIO_CODE NUMBER Portfolio code on a bank collection document. Active
BATCH_SOURCE_ID NUMBER 18 Yes Batch source identifier of a bank collection document. Active
RECEIPT_METHOD_ID NUMBER 18 Yes Receipt method identifier of a bank collection document. Active
CUSTOMER_TRX_ID NUMBER 18 Customer transaction identifier on a bank collection document. Active
TERMS_SEQUENCE_NUMBER NUMBER 18 Terms sequence number on a payment schedule. Active
DOCUMENT_TYPE VARCHAR2 30 Yes Bank collection document type on an imported bank collection document. Active
BANK_ACCOUNT_ID NUMBER 18 Identifier for the bank account used by the deploying company or by the supplier or supplier site. Active
PREVIOUS_DOC_STATUS VARCHAR2 30 Previous document status of a bank collection document. Active
OUR_NUMBER VARCHAR2 20 Collection document identifier at a particular bank. Active
BANK_USE VARCHAR2 25 Operation identifier by bank on a bank collection document. Active
COLLECTOR_BANK_NUMBER VARCHAR2 30 Numeric identifier for collecting bank. Active
COLLECTOR_BRANCH_NUMBER VARCHAR2 25 Numeric identifier for collecting bank branch. Active
FACTORING_RATE NUMBER No longer used. Active
FACTORING_RATE_PERIOD NUMBER No longer used. Active
FACTORING_AMOUNT NUMBER No longer used. Active
FACTORING_DATE DATE No longer used. Active
CANCELLATION_DATE DATE Date on which a transaction was canceled. Active
BANK_INSTRUCTION_CODE1 NUMBER 2 Bank instruction code 1 on a bank collection document. Active
BANK_INSTRUCTION_CODE2 NUMBER 2 Bank instruction code 2 on a bank collection document. Active
NUM_DAYS_INSTRUCTION NUMBER 3 Maximum number of days allowed for protest or write off on a bank collection document. Active
BANK_CHARGE_AMOUNT NUMBER No longer used. Active
CASH_CCID NUMBER 18 Identifier for the account associated with cash amounts. Active
EARNED_CCID NUMBER 18 Identifier for the account associated with earned amounts. Active
ON_ACCOUNT_CCID NUMBER 18 Identifier for the account associated with on account amounts. Active
UNAPPLIED_CCID NUMBER 18 Identifier for the account associated with amounts that have not been applied. Active
UNEARNED_CCID NUMBER 18 Identifier for the account associated with unearned amounts. Active
UNIDENTIFIED_CCID NUMBER 18 Identifier for the account associated with unidentified amounts. Active
BANK_CHARGES_CCID NUMBER 18 No longer used. Active
COLL_ENDORSEMENTS_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
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
ABATE_REVENUE_RECTRX_ID NUMBER 18 No longer used. Active
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
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.
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
BANK_ACCT_USE_ID NUMBER 18 Unique identifier for the bank account use. Active
COLLECTOR_BANK_PARTY_ID NUMBER 18 Party identifier for collecting bank. Active
COLLECTOR_BRANCH_PARTY_ID NUMBER 18 Party identifier for collecting bank branch. Active
CASH_RECEIPT_ID NUMBER 18 Receipt identifier for a receipt that has not been applied. 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.
COLL_BATCH_ID NUMBER 18 Brazilian receivables collection document batch unique identifier.
BILL_TO_SITE_ID NUMBER 18 Yes Bill-to site unique identifier in the selection criteria of a remittance batch.
PARTY_ID NUMBER 18 Yes Party identifier associated with the customer account.
INTEREST_TYPE VARCHAR2 30 Method used to calculate interest.
INTEREST_RATE_AMOUNT NUMBER Interest to be applied in terms of percentage rate or amount.
INTEREST_PERIOD NUMBER Interest period number of days for calculating interest.
INTEREST_FORMULA VARCHAR2 30 Type of formula used for calculating interest.
GRACE_DAYS NUMBER Number of days to be excluded while calculating interest.
PENALTY_TYPE VARCHAR2 30 Type of method used for applying penalty.
PENALTY_RATE_AMOUNT NUMBER Penalty value to be applied in terms of percentage rate or amount.
LEGAL_ENTITY_ID NUMBER 18 Yes Legal Entity unique identifier in the Brazilian receivables invoice.
REMIT_TO_ADDRESS_SEQ_ID NUMBER 18 Yes Remit to address sequence unique identifier.
COLLECTION_DOCUMENT_NUMBER VARCHAR2 80 Yes Indicates the collection document number.
PAYMENT_TERM_ID NUMBER 18 Yes Unique payment terms identifier.
PIX_QR_CODE_EMV VARCHAR2 600 QR Code in smart payment format returned by the bank that's associated with a collection document.
PIX_QR_CODE_URL VARCHAR2 120 QR Code URL returned by the bank that's associated with a collection document.

Foreign Keys

Table Foreign Table Foreign Key Column
JL_BR_AR_COLLECTION_DOCS_ALL jl_br_ar_coll_batches_all COLL_BATCH_ID
JL_BR_AR_COLLECTION_DOCS_ALL gl_code_combinations CALCULATED_INTEREST_CCID
JL_BR_AR_COLLECTION_DOCS_ALL gl_code_combinations INTEREST_WRITEOFF_CCID
JL_BR_AR_COLLECTION_DOCS_ALL ar_receipt_method_accounts_all RECEIPT_METHOD_ID, BANK_ACCOUNT_ID
JL_BR_AR_COLLECTION_DOCS_ALL gl_code_combinations ABATEMENT_WRITEOFF_CCID
JL_BR_AR_COLLECTION_DOCS_ALL gl_code_combinations ABATEMENT_REVENUE_CCID
JL_BR_AR_COLLECTION_DOCS_ALL gl_code_combinations INTEREST_REVENUE_CCID
JL_BR_AR_COLLECTION_DOCS_ALL gl_code_combinations CALCULATED_INTEREST_RECTRX_ID
JL_BR_AR_COLLECTION_DOCS_ALL gl_code_combinations INTEREST_WRITEOFF_RECTRX_ID
JL_BR_AR_COLLECTION_DOCS_ALL gl_code_combinations INTEREST_REVENUE_RECTRX_ID
JL_BR_AR_COLLECTION_DOCS_ALL gl_code_combinations ABATEMENT_WRITEOFF_RECTRX_ID
JL_BR_AR_COLLECTION_DOCS_ALL gl_code_combinations ABATE_REVENUE_RECTRX_ID
JL_BR_AR_COLLECTION_DOCS_ALL ce_bank_acct_uses_all BANK_ACCT_USE_ID
JL_BR_AR_COLLECTION_DOCS_ALL hz_parties COLLECTOR_BANK_PARTY_ID
JL_BR_AR_COLLECTION_DOCS_ALL hz_parties COLLECTOR_BRANCH_PARTY_ID
JL_BR_AR_COLLECTION_DOCS_ALL hz_parties PARTY_ID
JL_BR_AR_COLLECTION_DOCS_ALL ar_batch_sources_all BATCH_SOURCE_ID
jl_br_ar_occurrence_docs_all jl_br_ar_collection_docs_all DOCUMENT_ID
jl_br_ar_bank_returns_all jl_br_ar_collection_docs_all DOCUMENT_ID
jl_br_ar_coll_docs_det_all jl_br_ar_collection_docs_all DOCUMENT_ID

Indexes

Index Uniqueness Tablespace Columns Status
JL_BR_AR_COLLECTION_DOCS_N1 Non Unique Default COLL_BATCH_ID
JL_BR_AR_COLLECTION_DOCS_N2 Non Unique FUSION_TS_TX_DATA BANK_ACCOUNT_ID Active
JL_BR_AR_COLLECTION_DOCS_N3 Non Unique FUSION_TS_TX_DATA BANK_ACCT_USE_ID, PARTY_ID, ORG_ID, DUE_DATE, DOCUMENT_ID Active
JL_BR_AR_COLLECT_DOCS_U1 Unique FUSION_TS_TX_DATA DOCUMENT_ID Active