[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JL_BR_AP_INT_COLLECT_EXT_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | JL |
| FND Design Data: |  JL.JL_BR_AP_INT_COLLECT_EXT_ALL
|
| Subobject Name: | |
| Status: | VALID |
JL_BR_AP_INT_COLLECT_EXT is the extended table for the bank collection documents interface. To initiate Import Bank Collection Documents, the user must load the bank collection document file sent by the supplier's bank in the JL_BR_AP_INT_COLLECT table. Then, the system will validate each of the interface entries. The valid entries are inserted into the JL_BR_AP_COLLECTION_DOCS table and the invalid entries are inserted into the JL_BR_AP_INT_COLLECT_EXT table. If a few entries do not go through the validation during the import of collection documents, the user can load the collection document file to the JL_BR_AP_INT_COLLECT table again or correct the invalid data in the JL_BR_AP_INT_COLLECT_EXT table. If the option is to correct the interface, after this is done, Oracle Payables automatically transfers the corrected entries from the JL_BR_AP_INT_COLLECT_EXT table to the JL_BR_AP_COLLECTION_DOCS table.
This table corresponds to the Imported Collection Documents window.
.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| JL_BR_AP_COLLECT_EXT_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 FILE_CONTROL
ENTRY_SEQUENTIAL_NUMBER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| FILE_CONTROL | VARCHAR2 | (20) | Yes | Name of the file received from the bank |
| ENTRY_SEQUENTIAL_NUMBER | NUMBER | (6) | Yes | Entry Sequential Number from imported bank collection document |
| REGISTRY_CODE | VARCHAR2 | (1) | Registry Code | |
| RETURN_CODE | NUMBER | (1) | Return Code | |
| SERVICE_CODE | NUMBER | (2) | Service Code | |
| RECORDING_DATE | DATE | Date that indicates when the bank collection document was recorded | ||
| ISSUE_DATE | DATE | Date that indicates when the bank collection document was issued | ||
| DOCUMENT_NUMBER | VARCHAR2 | (10) | Bank Collection Document Number | |
| DRAWER_GUARANTOR | VARCHAR2 | (40) | Drawer or Guarantor Name | |
| INSTRUCTION_1 | VARCHAR2 | (30) | Bank Instruction | |
| INSTRUCTION_2 | VARCHAR2 | (30) | Bank Instruction | |
| CNAB_CODE | VARCHAR2 | (15) | CNAB Code | |
| DUE_DATE | DATE | Due Date | ||
| AMOUNT | NUMBER | (19) | Bank Collection Document Amount | |
| DISCOUNT_DATE | DATE | Date discount is available | ||
| DISCOUNT_AMOUNT | NUMBER | (19) | Discount Amount at Discount Date | |
| ARREARS_DATE | DATE | Arrears Interest Date | ||
| ARREARS_CODE | VARCHAR2 | (1) | Arrears Interest Code | |
| ARREARS_INTEREST | NUMBER | (19) | Arrears Interest Amount | |
| ABATE_AMOUNT | NUMBER | (19) | Bank Collection Abate Amount | |
| PAID_AMOUNT | NUMBER | (19) | Amount Paid | |
| PAYMENT_LOCATION | VARCHAR2 | (30) | Payment Location | |
| DOCUMENT_TYPE | VARCHAR2 | (2) | Bank Collection Document Type | |
| ACCEPTANCE | VARCHAR2 | (1) | Acceptance | |
| PROCESSING_DATE | DATE | Date the bank collection document was processed | ||
| BANK_USE | VARCHAR2 | (25) | Bank Use | |
| PORTFOLIO | VARCHAR2 | (3) | Portfolio Code in the bank | |
| PENALTY_FEE_AMOUNT | NUMBER | (19) | Penalty Fee Amount | |
| PENALTY_FEE_DATE | DATE | Penalty Fee Date | ||
| OTHER_ACCRETIONS | NUMBER | (19) | Other Accretions | |
| OUR_NUMBER | VARCHAR2 | (20) | Our Number | |
| TRANSFEROR_CODE | VARCHAR2 | (10) | Transferer Code | |
| OCCURRENCE | VARCHAR2 | (2) | Occurrence | |
| OCCURRENCE_DATE | DATE | Occurrence Date | ||
| DRAWEE_NAME | VARCHAR2 | (240) | Drawee Name | |
| DRAWEE_BANK_CODE | VARCHAR2 | (3) | Drawee Bank Code | |
| DRAWEE_BANK_NAME | VARCHAR2 | (60) | Drawee Bank Name | |
| DRAWEE_BRANCH_CODE | VARCHAR2 | (25) | Drawee Branch Code | |
| DRAWEE_ACCOUNT_NUMBER | VARCHAR2 | (30) | Drawee Account Number | |
| DRAWEE_INSCRIPTION_TYPE | NUMBER | (2) | Drawee Inscription Type | |
| DRAWEE_INSCRIPTION_NUMBER | VARCHAR2 | (15) | Drawee Inscription Number | |
| TRANSFEROR_NAME | VARCHAR2 | (240) | Transferer Name | |
| TRANSFEROR_BANK_CODE | VARCHAR2 | (3) | Transferer Bank Code | |
| TRANSFEROR_BRANCH_CODE | VARCHAR2 | (25) | Transferer Branch Code | |
| TRANSFEROR_ACCOUNT_NUMBER | VARCHAR2 | (30) | Transferer Account Number | |
| TRANSFEROR_INSCRIPTION_TYPE | NUMBER | (2) | Transferer Inscription Type | |
| TRANSFEROR_INSCRIPTION_NUMBER | VARCHAR2 | (15) | Transferer Inscription Number | |
| ACCOUNTING_BALANCING_SEGMENT | VARCHAR2 | (25) | Accounting Balancing Segment | |
| SET_OF_BOOKS_ID | NUMBER | (15) | Set of Books Identifier | |
| ERROR_CODE | VARCHAR2 | (2) | Error code | |
| ORG_ID | NUMBER | (15) | Organization Identifier | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| CREATION_DATE | DATE | Standard Who Column | ||
| CREATED_BY | NUMBER | (15) | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive Flexfield defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column |
Cut, paste (and edit) the following text to query this object:
SELECT FILE_CONTROL
, ENTRY_SEQUENTIAL_NUMBER
, REGISTRY_CODE
, RETURN_CODE
, SERVICE_CODE
, RECORDING_DATE
, ISSUE_DATE
, DOCUMENT_NUMBER
, DRAWER_GUARANTOR
, INSTRUCTION_1
, INSTRUCTION_2
, CNAB_CODE
, DUE_DATE
, AMOUNT
, DISCOUNT_DATE
, DISCOUNT_AMOUNT
, ARREARS_DATE
, ARREARS_CODE
, ARREARS_INTEREST
, ABATE_AMOUNT
, PAID_AMOUNT
, PAYMENT_LOCATION
, DOCUMENT_TYPE
, ACCEPTANCE
, PROCESSING_DATE
, BANK_USE
, PORTFOLIO
, PENALTY_FEE_AMOUNT
, PENALTY_FEE_DATE
, OTHER_ACCRETIONS
, OUR_NUMBER
, TRANSFEROR_CODE
, OCCURRENCE
, OCCURRENCE_DATE
, DRAWEE_NAME
, DRAWEE_BANK_CODE
, DRAWEE_BANK_NAME
, DRAWEE_BRANCH_CODE
, DRAWEE_ACCOUNT_NUMBER
, DRAWEE_INSCRIPTION_TYPE
, DRAWEE_INSCRIPTION_NUMBER
, TRANSFEROR_NAME
, TRANSFEROR_BANK_CODE
, TRANSFEROR_BRANCH_CODE
, TRANSFEROR_ACCOUNT_NUMBER
, TRANSFEROR_INSCRIPTION_TYPE
, TRANSFEROR_INSCRIPTION_NUMBER
, ACCOUNTING_BALANCING_SEGMENT
, SET_OF_BOOKS_ID
, ERROR_CODE
, ORG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM JL.JL_BR_AP_INT_COLLECT_EXT_ALL;
JL.JL_BR_AP_INT_COLLECT_EXT_ALL does not reference any database object
JL.JL_BR_AP_INT_COLLECT_EXT_ALL is referenced by following:
APPS
JL_BR_AP_INT_COLLECT_EXT
JL_BR_AP_INT_COLLECT_EXT_ALL
|
|
|
|