[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JL_BR_AP_INT_COLLECT_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | JL |
| FND Design Data: |  JL.JL_BR_AP_INT_COLLECT_ALL
|
| Subobject Name: | |
| Status: | VALID |
The JL_BR_AP_INT_COLLECT_ALL table contains records for bank collection documents that you enter. A Bank Collection Document is a form sent by banks and used to do payments of titles
registered in a collection portfolio.
This is the open interface table for Brazilian Accounts Payables Bank collection Document Open Interface
Scope: public
Product: JL
Display Name: Brazilian Accounts Payables Bank collection Document
Lifecycle: active
Category: BUSINESS_ENTITY JL_BR_AP_BANK_COLLECTION_DOC
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| JL_BR_AP_INT_COLLECT_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) | Bank Collection Interface 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_ALL;
JL.JL_BR_AP_INT_COLLECT_ALL does not reference any database object
JL.JL_BR_AP_INT_COLLECT_ALL is referenced by following:
APPS
JL_BR_AP_INT_COLLECT
JL_BR_AP_INT_COLLECT_ALL
|
|
|
|