[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JL_BR_AR_RET_INTERFACE_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | JL |
| FND Design Data: |  JL.JL_BR_AR_RET_INTERFACE_ALL
|
| Subobject Name: | |
| Status: | VALID |
JL_BR_AR_RET_INTERFACE_ALL is the interface table for bank return documents. Before running the Import Bank Return Documents concurrent program, the user must load the bank returns document file sent by the bank into this table. Import Bank will validate each of these rows. REGISTER_TYPE will store a value 9 for Trailer record, 0 for Header record, 1 for detail records. Entry Sequential Number should be 1 for header record. There will be one header and one trailer record for a given file contol. Entry sequential number of trailer record will store the number of records in the file, which includes the header, details and trailer for a given file control.
Scope: public
Product: JL
Display Name: Brazilian Accounts Receivables Bank Return Document
Lifecycle: active
Category: BUSINESS_ENTITY JL_BR_AR_BANK_RETURN_DOC
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| JL_BR_AR_RET_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 FILE_CONTROL
ENTRY_SEQUENTIAL_NUMBER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| FILE_CONTROL | VARCHAR2 | (20) | Yes | Bank control file name |
| ENTRY_SEQUENTIAL_NUMBER | NUMBER | (6) | Yes | Register Sequence Number |
| REGISTER_TYPE | NUMBER | (2) | Yes | Identifier for header, detail and trailer records |
| TRADE_NOTE_AMOUNT | NUMBER | Yes | Amount due remaining of the payment schedule | |
| FILE_GENERATION_NUMBER | NUMBER | (3) | No longer used | |
| COMPANY_CODE | NUMBER | Yes | Company Code | |
| COMPANY_NAME | VARCHAR2 | (80) | Company_name column length should be increased. | |
| GENERATION_DATE | DATE | Yes | Generation Date | |
| REMITTANCE_CODE | NUMBER | (1) | Yes | Bank Remittance Code |
| BANK_NUMBER | VARCHAR2 | (30) | Yes | Bank Number to identify bank |
| BANK_OCCURRENCE_CODE | NUMBER | (2) | Yes | Bank Occurrence Code |
| OCCURRENCE_DATE | DATE | Yes | Bank Occurrence Date | |
| INSCRIPTION_NUMBER | NUMBER | (15) | Inscription Number | |
| COMPANY_USE | NUMBER | Yes | Collection Document identifier | |
| OUR_NUMBER | VARCHAR2 | (20) | Collection Document identifier at bank | |
| PORTFOLIO_CODE | NUMBER | Portfolio Code | ||
| YOUR_NUMBER | VARCHAR2 | (46) | Trade note number related to the document given by the company | |
| DUE_DATE | DATE | Document Due Date | ||
| COLLECTOR_BANK_NUMBER | VARCHAR2 | (30) | Bank Number of the collecting bank | |
| COLLECTOR_BRANCH_NUMBER | VARCHAR2 | (25) | Collection Bank Branch Number | |
| TRADE_NOTE_TYPE | VARCHAR2 | (3) | No longer used | |
| BANK_CHARGE_AMOUNT | NUMBER | Collection Expense Amount | ||
| ABATEMENT_AMOUNT | NUMBER | Abatement Amount | ||
| DISCOUNT_AMOUNT | NUMBER | Discount Amount | ||
| CREDIT_AMOUNT | NUMBER | Credit Amount | ||
| INTEREST_AMOUNT_RECEIVED | NUMBER | Paid Arrears Interest Amount | ||
| CUSTOMER_NAME | VARCHAR2 | (50) | Customer Name | |
| RETURN_INFO | VARCHAR2 | (50) | Return information comment | |
| BANK_USE | VARCHAR2 | (25) | For Bank use | |
| ORG_ID | NUMBER | (15) | Operating Unit 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 |
Cut, paste (and edit) the following text to query this object:
SELECT FILE_CONTROL
, ENTRY_SEQUENTIAL_NUMBER
, REGISTER_TYPE
, TRADE_NOTE_AMOUNT
, FILE_GENERATION_NUMBER
, COMPANY_CODE
, COMPANY_NAME
, GENERATION_DATE
, REMITTANCE_CODE
, BANK_NUMBER
, BANK_OCCURRENCE_CODE
, OCCURRENCE_DATE
, INSCRIPTION_NUMBER
, COMPANY_USE
, OUR_NUMBER
, PORTFOLIO_CODE
, YOUR_NUMBER
, DUE_DATE
, COLLECTOR_BANK_NUMBER
, COLLECTOR_BRANCH_NUMBER
, TRADE_NOTE_TYPE
, BANK_CHARGE_AMOUNT
, ABATEMENT_AMOUNT
, DISCOUNT_AMOUNT
, CREDIT_AMOUNT
, INTEREST_AMOUNT_RECEIVED
, CUSTOMER_NAME
, RETURN_INFO
, BANK_USE
, ORG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM JL.JL_BR_AR_RET_INTERFACE_ALL;
JL.JL_BR_AR_RET_INTERFACE_ALL does not reference any database object
JL.JL_BR_AR_RET_INTERFACE_ALL is referenced by following:
APPS
JL_BR_AR_BANK_TRANS_GET_VARS
JL_BR_AR_BANK_TRANS_STORE_VARS
JL_BR_AR_RET_INTERFACE
JL_BR_AR_RET_INTERFACE_ALL
|
|
|
|