DBA Data[Home] [Help] [Dependency Information]

TABLE: JL.JL_BR_AR_RET_INTERFACE_EXT_ALL

Object Details
Object Name: JL_BR_AR_RET_INTERFACE_EXT_ALL
Object Type: TABLE
Owner: JL
FND Design Data: TableJL.JL_BR_AR_RET_INTERFACE_EXT_ALL
Subobject Name:
Status: VALID


JL_BR_AR_RET_INTERFACE_EXT_ALL stores invalid records rejected by the Import Bank Return program. Successfully validated records are inserted in the JL_BR_AR_BANK_RETURNS_ALL table.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JL_BR_AR_RET_INTERFACE_EXT_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnFILE_CONTROL
ColumnENTRY_SEQUENTIAL_NUMBER
Columns
Name Datatype Length Mandatory Comments
FILE_CONTROL VARCHAR2 (20) Yes Bank control file name
ENTRY_SEQUENTIAL_NUMBER NUMBER (6) Yes Register Sequence Number
COMPANY_CODE NUMBER

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)
Bank Number to identify bank
BANK_OCCURRENCE_CODE NUMBER (2) Yes Bank Occurrence Code
OCCURRENCE_DATE DATE
Yes Bank Occurrence Date
PROCESSING_DATE DATE
Yes Processing Date
LAST_VALIDATION_DATE DATE
Yes Last Validation 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
TRADE_NOTE_AMOUNT NUMBER

Trade Note Amount
COLLECTOR_BANK_NUMBER VARCHAR2 (30)
Bank Number of the Collecting Bank
COLLECTOR_BRANCH_NUMBER VARCHAR2 (25)
Collector Bank Branch number
TRADE_NOTE_TYPE VARCHAR2 (3)
Kind of title
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
ERROR_CODE VARCHAR2 (30)
Validation Error Code
CANCELLATION_CODE VARCHAR2 (1)
Cancellation Code
ORG_ID NUMBER (15)
Operating Unit identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
BANK_PARTY_ID NUMBER (15) Yes Bank's party identifier
COLLECTOR_BANK_PARTY_ID NUMBER (15)
Collecting bank's party ID
COLLECTOR_BRANCH_PARTY_ID NUMBER (15)
Collector bank's branch party ID
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FILE_CONTROL
,      ENTRY_SEQUENTIAL_NUMBER
,      COMPANY_CODE
,      COMPANY_NAME
,      GENERATION_DATE
,      REMITTANCE_CODE
,      BANK_NUMBER
,      BANK_OCCURRENCE_CODE
,      OCCURRENCE_DATE
,      PROCESSING_DATE
,      LAST_VALIDATION_DATE
,      INSCRIPTION_NUMBER
,      COMPANY_USE
,      OUR_NUMBER
,      PORTFOLIO_CODE
,      YOUR_NUMBER
,      DUE_DATE
,      TRADE_NOTE_AMOUNT
,      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
,      ERROR_CODE
,      CANCELLATION_CODE
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      BANK_PARTY_ID
,      COLLECTOR_BANK_PARTY_ID
,      COLLECTOR_BRANCH_PARTY_ID
FROM JL.JL_BR_AR_RET_INTERFACE_EXT_ALL;

Dependencies

[top of page]

JL.JL_BR_AR_RET_INTERFACE_EXT_ALL does not reference any database object

JL.JL_BR_AR_RET_INTERFACE_EXT_ALL is referenced by following:

SchemaAPPS
SynonymJL_BR_AR_RET_INTERFACE_EXT
SynonymJL_BR_AR_RET_INTERFACE_EXT_ALL