1. Tables and Views for Financials
  2. JL_BR_AP_INT_COLLECT_ALL

JL_BR_AP_INT_COLLECT_ALL

This table stores the bank collection document loaded from the file of supplier's bank.

Details

  • Schema: FUSION

  • Object owner: JL

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

JL_BR_AP_INT_COLLECT_PK

FILE_CONTROL, ENTRY_SEQUENTIAL_NUMBER

Columns

Name Datatype Length Precision Not-null Comments Status
FILE_CONTROL VARCHAR2 20 Yes Bank control file name received from the bank. Active
ENTRY_SEQUENTIAL_NUMBER NUMBER 6 Yes Entry sequential number on an imported bank collection document. Active
REGISTRY_CODE VARCHAR2 1 Registry code on an imported bank collection document. Active
RETURN_CODE NUMBER 1 Return code on an imported bank collection document. Active
SERVICE_CODE NUMBER 2 Service code on an imported bank collection document. Active
RECORDING_DATE DATE Date that indicates when a bank collection document was recorded. Active
ISSUE_DATE DATE Issue date of a bank collection document. Active
DOCUMENT_NUMBER VARCHAR2 40 Bank collection document number. Active
DRAWER_GUARANTOR VARCHAR2 40 Drawer of a payables imported bank collection document. Active
INSTRUCTION_1 VARCHAR2 40 Bank instruction on an imported bank collection document. Active
INSTRUCTION_2 VARCHAR2 40 Bank instruction on an imported bank collection document. Active
CNAB_CODE VARCHAR2 15 Code given by national center of banking automation on an imported bank collection document. Active
DUE_DATE DATE Due date on an imported bank collection document. Active
AMOUNT NUMBER Amount on a bank collection document. Active
DISCOUNT_DATE DATE Discount date on an imported bank collection document. Active
DISCOUNT_AMOUNT NUMBER Amount eligible for discount on discount date. Active
ARREARS_DATE DATE Arrears interest date on an imported bank collection document. Active
ARREARS_CODE VARCHAR2 1 Arrears interest code on an imported bank collection document. Active
ARREARS_INTEREST NUMBER Arrears interest amount on an imported bank collection document. Active
ABATE_AMOUNT NUMBER Bank collection abate amount on an imported bank collection document. Active
PAID_AMOUNT NUMBER Paid amount on an imported bank collection document. Active
PAYMENT_LOCATION VARCHAR2 30 Payment location on an imported bank collection document. Active
DOCUMENT_TYPE VARCHAR2 2 Bank collection document type on an imported bank collection document. Active
ACCEPTANCE VARCHAR2 1 Acceptance for an imported bank collection document. Active
PROCESSING_DATE DATE Date the bank collection document was processed. Active
BANK_USE VARCHAR2 25 Operation identifier on an imported bank collection document. Active
PORTFOLIO VARCHAR2 3 Portfolio code in the bank on an imported bank collection document. Active
PENALTY_FEE_AMOUNT NUMBER Penalty fee amount on an imported bank collection document. Active
PENALTY_FEE_DATE DATE Penalty fee date on an imported bank collection document. Active
OTHER_ACCRETIONS NUMBER Other accretions on an imported bank collection document. Active
OUR_NUMBER VARCHAR2 20 Our number on an imported bank collection document. Active
TRANSFEROR_CODE VARCHAR2 10 Code of transferring party on an imported bank collection document. Active
OCCURRENCE VARCHAR2 2 Correction reason on an imported bank collection document. Active
OCCURRENCE_DATE DATE Correction date on an imported bank collection document. Active
DRAWEE_NAME VARCHAR2 240 Payer name on an imported bank collection document. Active
DRAWEE_BANK_CODE VARCHAR2 3 Payer bank code on an imported bank collection document. Active
DRAWEE_BANK_NAME VARCHAR2 60 Payer bank name on an imported bank collection document. Active
DRAWEE_BRANCH_CODE VARCHAR2 25 Payer bank branch code on an imported bank collection document. Active
DRAWEE_ACCOUNT_NUMBER VARCHAR2 30 Payer account number on an imported bank collection document. Active
DRAWEE_INSCRIPTION_TYPE NUMBER 2 Payer inscription type on an imported bank collection document. Active
DRAWEE_INSCRIPTION_NUMBER VARCHAR2 30 Payer inscription number on an imported bank collection document. Active
TRANSFEROR_NAME VARCHAR2 240 Name of transferring party on an imported bank collection document. Active
TRANSFEROR_BANK_CODE VARCHAR2 3 Bank code of transferring party on an imported bank collection document. Active
TRANSFEROR_BRANCH_CODE VARCHAR2 25 Branch code of transferring party on an imported bank collection document. Active
TRANSFEROR_ACCOUNT_NUMBER VARCHAR2 30 Account number of transferring party on an imported bank collection document. Active
TRANSFEROR_INSCRIPTION_TYPE NUMBER 2 Inscription type of transferring party on an imported bank collection document. Active
TRANSFEROR_INSCRIPTION_NUMBER VARCHAR2 15 Inscription number of transferring party on an imported bank collection document. Active
ACCOUNTING_BALANCING_SEGMENT VARCHAR2 25 No longer used. Active
SET_OF_BOOKS_ID NUMBER 18 No longer used. Active
ERROR_CODE VARCHAR2 2 Bank collection interface error code. Active
ORG_ID NUMBER 18 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
ATTRIBUTE_CATEGORY VARCHAR2 150 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. Active
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
BARCODE VARCHAR2 240 Electronic bank collection document bar code. Active
ELECTRONIC_FORMAT_FLAG VARCHAR2 1 Electronic bank collection indicator. 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
BARCODE_TYPE_CODE VARCHAR2 30 Type of barcode used for a Brazilian payables collection document. Active
LOAD_REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
INVOICE_NUM VARCHAR2 50 Invoice number for a Brazilian payables collection document. Active

Indexes

Index Uniqueness Tablespace Columns Status
JL_BR_AP_INT_COLLECT_U1 Unique FUSION_TS_TX_IDX FILE_CONTROL, ENTRY_SEQUENTIAL_NUMBER Active