eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: JL.JL_BR_AP_INT_COLLECT_EXT_ALL

Object Details

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.
.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JL_BR_AP_COLLECT_EXT_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	FILE_CONTROL ENTRY_SEQUENTIAL_NUMBER

Columns

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

Query Text

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;

Dependencies

[top of page]

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