JL_BR_AP_COLLECTION_DOCS_ALL
This table stores the details of Brazilian bank collection document records.
Details
-
Schema: FUSION
-
Object owner: JL
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
Name | Columns |
---|---|
JL_BR_AP_COLLEC_DOC_PK |
BANK_COLLECTION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
BANK_COLLECTION_ID | NUMBER | 18 | Yes | Identifier for a bank collection document. | Active | |
INVOICE_ID | NUMBER | 18 | No longer used. | Active | ||
PAYMENT_NUM | NUMBER | 18 | No longer used. | Active | ||
HOLD_FLAG | VARCHAR2 | 1 | Yes or No indicates whether a bank collection document is on hold. | 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 bank collection document. | Active | ||
INSTRUCTION_1 | VARCHAR2 | 40 | Bank instruction on a bank collection document. | Active | ||
INSTRUCTION_2 | VARCHAR2 | 40 | Bank instruction on a bank collection document. | Active | ||
CURRENCY_CODE | VARCHAR2 | 15 | Yes | The three-letter ISO code associated with a currency. | Active | |
DUE_DATE | DATE | Due date on a bank collection document. | Active | |||
AMOUNT | NUMBER | Amount on a bank collection document. | Active | |||
DISCOUNT_DATE | DATE | Discount date on a bank collection document. | Active | |||
DISCOUNT_AMOUNT | NUMBER | Amount eligible for discount on discount date on a bank collection document. | Active | |||
ARREARS_DATE | DATE | Arrears interest date on a bank collection document. | Active | |||
ARREARS_CODE | VARCHAR2 | 1 | Arrears interest code on a bank collection document. | Active | ||
ARREARS_INTEREST | NUMBER | Arrears interest amount on a bank collection document. | Active | |||
ABATE_AMOUNT | NUMBER | Bank collection abate amount on a bank collection document. | Active | |||
PAID_AMOUNT | NUMBER | Paid amount on a bank collection document. | Active | |||
PAYMENT_LOCATION | VARCHAR2 | 30 | Payment location on a bank collection document. | Active | ||
DOCUMENT_TYPE | VARCHAR2 | 2 | Bank collection document type on a bank collection document. | Active | ||
ACCEPTANCE | VARCHAR2 | 1 | Acceptance for a bank collection document. | Active | ||
PROCESSING_DATE | DATE | Date the bank collection document was processed. | Active | |||
BANK_USE | VARCHAR2 | 25 | Operation identifier on a bank collection document. | Active | ||
PORTFOLIO | VARCHAR2 | 3 | Portfolio code in the bank on a bank collection document. | Active | ||
PENALTY_FEE_AMOUNT | NUMBER | Penalty fee amount on a bank collection document. | Active | |||
PENALTY_FEE_DATE | DATE | Penalty fee date on a bank collection document. | Active | |||
OTHER_ACCRETIONS | NUMBER | Other accretions on a bank collection document. | Active | |||
OUR_NUMBER | VARCHAR2 | 20 | Collection document identifier at a particular bank. | Active | ||
TRANSFEROR_CODE | VARCHAR2 | 10 | Code of transferring party on an imported bank collection document. | Active | ||
VENDOR_SITE_ID | NUMBER | 18 | Yes | Unique identifier for a supplier site on a bank collection document. | Active | |
FILE_CONTROL | VARCHAR2 | 20 | Bank control file name received from the bank. | Active | ||
STATUS_LOOKUP_CODE | VARCHAR2 | 30 | Current status of a bank collection document. | 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 | ||
ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Active | ||
ATTRIBUTE30 | 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. | ||||
ENTRY_SEQUENTIAL_NUMBER | NUMBER | 6 | Entry sequential number on an imported bank collection document. | Active | ||
SET_OF_BOOKS_ID | NUMBER | 18 | Yes | No longer used. | Active | |
VENDOR_ID | NUMBER | 18 | Yes | Unique identifier for a supplier on a bank collection document. | Active | |
BANK_BRANCH_ID | NUMBER | 18 | No longer used. | Active | ||
ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | Active | |
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
BRANCH_PARTY_ID | NUMBER | 18 | Yes | Bank branch identifier on a bank collection document. | Active | |
BANK_PARTY_ID | NUMBER | 18 | Bank identifier on a bank collection document. | 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. | ||
INVOICE_NUM | VARCHAR2 | 50 | Invoice number for a Brazilian payables collection document. | |||
BARCODE_TYPE_CODE | VARCHAR2 | 30 | Yes | Type of barcode used for a Brazilian payables collection document. | ||
PARTY_ID | NUMBER | 18 | Unique identifier for a party that does business with other entities. This identifier is used for submitting invoice and other payment requests. | |||
PARTY_SITE_ID | NUMBER | 18 | Unique identifier for a party site on a bank collection document. | |||
REGISTRATION_NUMBER | VARCHAR2 | 30 | Registration number of the legal reporting unit. | |||
REGISTRATION_ID | NUMBER | 18 | Registration identifier of the legal reporting unit. | |||
LEGAL_ENTITY_ID | NUMBER | 18 | Legal entity identifier for the bank collection document. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
ap_selected_invoices_all | jl_br_ap_collection_docs_all | BANK_COLLECTION_ID |
jl_br_ap_coll_docs_det_all | jl_br_ap_collection_docs_all | BANK_COLLECTION_ID |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
JL_BR_AP_COLLECTION_DOCS_N1 | Non Unique | Default | ORG_ID, VENDOR_ID, DUE_DATE, VENDOR_SITE_ID | |
JL_BR_AP_COLLECTION_DOCS_N2 | Non Unique | JL_BR_AP_COLLECTION_DOCS_N2 | DOCUMENT_NUMBER, PARTY_ID | |
JL_BR_AP_COLLECTION_DOCS_U1 | Unique | FUSION_TS_TX_DATA | BANK_COLLECTION_ID | Active |