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_COLLECTION_DOCS_ALL

Object Details

Object Name:	JL_BR_AP_COLLECTION_DOCS_ALL
Object Type:	TABLE
Owner:	JL
FND Design Data:	JL.JL_BR_AP_COLLECTION_DOCS_ALL
Subobject Name:
Status:	VALID

JL_BR_AP_COLLECTION_DOCS contains records for bank collection documents you enter. A Bank Collection Document is a form sent by banks and used to do payments of titles registered in a collection portfolio.
A payment schedule is released for payment only after a bank collection document is associated to it.
There is one row in JL_BR_AP_COLLECTION_DOCS for each collection document you enter.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JL_BR_AP_COLLECTION_DOCS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BANK_COLLECTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BANK_COLLECTION_ID	NUMBER	(15)	Yes	Bank Collection Document Identifier
INVOICE_ID	NUMBER	(15)		Invoice Identifier
PAYMENT_NUM	NUMBER	(15)		Payment Number
HOLD_FLAG	VARCHAR2	(1)		Flag that indicates if bank collection document is on hold (Y or N)
ISSUE_DATE	DATE			Date that indicates when the bank collection document was issued
DOCUMENT_NUMBER	VARCHAR2	(15)		Bank Collection Document Number
DRAWER_GUARANTOR	VARCHAR2	(40)		Drawer or Guarantor Name
INSTRUCTION_1	VARCHAR2	(30)		Bank Instruction
INSTRUCTION_2	VARCHAR2	(30)		Bank Instruction
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency Code of Bank Collection Document
DUE_DATE	DATE			Bank Collection Document 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
VENDOR_SITE_ID	NUMBER	(15)	Yes	Supplier Site Identifier
FILE_CONTROL	VARCHAR2	(20)		Name of the file received from the bank
STATUS_LOOKUP_CODE	VARCHAR2	(25)		Current Status of the Bank Collection Document
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive Flexfield structure 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
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE21	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE22	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE23	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE24	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE25	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE26	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE27	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE28	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE29	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE30	VARCHAR2	(150)		Descriptive Flexfield segment column
ENTRY_SEQUENTIAL_NUMBER	NUMBER	(6)		Entry Sequential Number if bank collection document was imported from a bank
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books Identifier
VENDOR_ID	NUMBER	(15)	Yes	Supplier Identifier
BANK_BRANCH_ID	NUMBER	(15)		Bank Branch Identifier
ORG_ID	NUMBER	(15)		Organization Identifier
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)		Standard Who Column
CREATION_DATE	DATE			Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
BRANCH_PARTY_ID	NUMBER	(15)	Yes	Branch Party ID
BANK_PARTY_ID	NUMBER	(15)		Bank Party ID
BARCODE	VARCHAR2	(240)		Electronic Bank Collection Document Barcode
ELECTRONIC_FORMAT_FLAG	VARCHAR2	(1)		Electronic Bank Collection Indicator

Query Text

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


SELECT BANK_COLLECTION_ID
,      INVOICE_ID
,      PAYMENT_NUM
,      HOLD_FLAG
,      ISSUE_DATE
,      DOCUMENT_NUMBER
,      DRAWER_GUARANTOR
,      INSTRUCTION_1
,      INSTRUCTION_2
,      CURRENCY_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
,      VENDOR_SITE_ID
,      FILE_CONTROL
,      STATUS_LOOKUP_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ENTRY_SEQUENTIAL_NUMBER
,      SET_OF_BOOKS_ID
,      VENDOR_ID
,      BANK_BRANCH_ID
,      ORG_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      BRANCH_PARTY_ID
,      BANK_PARTY_ID
,      BARCODE
,      ELECTRONIC_FORMAT_FLAG
FROM JL.JL_BR_AP_COLLECTION_DOCS_ALL;

Dependencies

[top of page]

JL.JL_BR_AP_COLLECTION_DOCS_ALL does not reference any database object

JL.JL_BR_AP_COLLECTION_DOCS_ALL is referenced by following:

JL: JL_BR_AP_COLLECTION_DOCS_ALL#