JL_BR_AP_INT_COLLECT_EXT_ALL
This table stores the invalid records from the JL_BR_AP_INT_COLLECT_ALL table.
Details
-
Schema: FUSION
-
Object owner: JL
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
Name | Columns |
---|---|
JL_BR_AP_COLLECT_EXT_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 an 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 | Payer name on 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 an imported 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 | Error code on an imported bank collection document. | 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 on an imported bank collection document. | 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 | ||
VALIDATION_STATUS_CODE | VARCHAR2 | 30 | Validation status of the imported collection document record. | Active | ||
INVOICE_NUM | VARCHAR2 | 50 | Invoice number 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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
jl_br_ap_collect_ext_errors | jl_br_ap_int_collect_ext_all | FILE_CONTROL, ENTRY_SEQUENTIAL_NUMBER |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
JL_BR_AP_COLLECT_EXT_U1 | Unique | FUSION_TS_TX_IDX | FILE_CONTROL, ENTRY_SEQUENTIAL_NUMBER | Active |
JL_BR_AP_INT_COLLECT_EXT_N1 | Non Unique | Default | ORG_ID, TRANSFEROR_INSCRIPTION_NUMBER, TRANSFEROR_INSCRIPTION_TYPE |