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_AR_COLLECTION_DOCS_ALL

Object Details

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

JL_BR_AR_COLLECTION_DOCS_ALL stores documents that are selected to be sent or that were sent to banks for collection. Each collection document corresponds to a payment schedule.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JL_BR_AR_COLLECT_DOCS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOCUMENT_ID
JL_BR_AR_COLLECTION_DOCS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_TRX_ID
JL_BR_AR_COLLECTION_DOCS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BANK_ACCOUNT_ID
JL_BR_AR_COLLECT_DOCS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_SCHEDULE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DOCUMENT_ID	NUMBER		Yes	Collection Document identifier
BORDERO_ID	NUMBER		Yes	Bank Transfer Batch identifier
PAYMENT_SCHEDULE_ID	NUMBER	(15)	Yes	Payment Schedule identifier
DOCUMENT_STATUS	VARCHAR2	(30)	Yes	Lookup Code for Lookup Type JLBR_AR_COLLECTION_DOCS_STATUS
ORIGIN_TYPE	VARCHAR2	(30)	Yes	Origin Type
DUE_DATE	DATE		Yes	Document Due Date
SELECTION_DATE	DATE		Yes	Document Selection Date
PORTFOLIO_CODE	NUMBER			Portfolio Code
BATCH_SOURCE_ID	NUMBER		Yes	Batch Source ID
RECEIPT_METHOD_ID	NUMBER	(15)	Yes	Receipt Method ID
CUSTOMER_TRX_ID	NUMBER	(15)	Yes	Customer Transaction ID
TERMS_SEQUENCE_NUMBER	NUMBER	(15)	Yes	Terms Sequence Number
DOCUMENT_TYPE	VARCHAR2	(30)	Yes	Lookup Code for Lookup Type JLBR_AR_DOCUMENT_TYPE
BANK_ACCOUNT_ID	NUMBER			Bank Account Identifier
PREVIOUS_DOC_STATUS	VARCHAR2	(30)		Previous Document Status
OUR_NUMBER	VARCHAR2	(20)		Collection document identifier at bank
BANK_USE	VARCHAR2	(25)		For Bank use
COLLECTOR_BANK_NUMBER	VARCHAR2	(30)		Bank Number of collecting bank
COLLECTOR_BRANCH_NUMBER	VARCHAR2	(25)		Collector Bank Branch number
FACTORING_RATE	NUMBER			Trade Note Discount Percentage
FACTORING_RATE_PERIOD	NUMBER			Trade Note Discount Period (number of days)
FACTORING_AMOUNT	NUMBER			Trade Note Discount Amount
FACTORING_DATE	DATE			Trade Note Discount Date
CANCELLATION_DATE	DATE			Cancellation Date
BANK_INSTRUCTION_CODE1	NUMBER	(2)		Bank Instruction 1
BANK_INSTRUCTION_CODE2	NUMBER	(2)		Bank Instruction 2
NUM_DAYS_INSTRUCTION	NUMBER	(3)		Protest or write off number of days
BANK_CHARGE_AMOUNT	NUMBER			Collection Expense Amount
CASH_CCID	NUMBER	(15)		Cash Account Code Combination
EARNED_CCID	NUMBER	(15)		Earned Account Code Combination
ON_ACCOUNT_CCID	NUMBER	(15)		On-account Account Code Combination
UNAPPLIED_CCID	NUMBER	(15)		Unapplied Account Code Combination
UNEARNED_CCID	NUMBER	(15)		Unearned Account Code Combination
UNIDENTIFIED_CCID	NUMBER	(15)		Unidentified Account Code Combination
BANK_CHARGES_CCID	NUMBER			Collection Expenses Account Code Combination
COLL_ENDORSEMENTS_CCID	NUMBER			Collection Endorsements Account Code Combination
BILLS_COLLECTION_CCID	NUMBER			Collection Titles Account Code Combination
OTHER_CREDITS_CCID	NUMBER			Other Credits Account Code Combination
FACTORING_DOCS_CCID	NUMBER			Discount Trade notes Account Code Combination
CALCULATED_INTEREST_CCID	NUMBER			Interest to receive Account Code Combination
INTEREST_WRITEOFF_CCID	NUMBER			Interest Write off Account Code Combination
FACTORING_INTEREST_CCID	NUMBER			Monetary Correction To Receive Account Code Combination
ABATEMENT_WRITEOFF_CCID	NUMBER	(15)		Abatement Writeoff Code Combination
ABATEMENT_REVENUE_CCID	NUMBER	(15)		Abatement Revenue Account Code Combination
INTEREST_REVENUE_CCID	NUMBER	(15)		Interest Revenue Account Code Combination
CALCULATED_INTEREST_RECTRX_ID	NUMBER	(15)		Interest to receive ID
INTEREST_WRITEOFF_RECTRX_ID	NUMBER	(15)		Interest to reverse ID
INTEREST_REVENUE_RECTRX_ID	NUMBER	(15)		Interest revenue ID
ABATEMENT_WRITEOFF_RECTRX_ID	NUMBER	(15)		Abatement ID
ABATE_REVENUE_RECTRX_ID	NUMBER	(15)		Abatement revenue ID
ORG_ID	NUMBER	(15)		Operating Unit identifier
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		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
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
BANK_ACCT_USE_ID	NUMBER	(15)		Uniquely identifies the bank account uses
COLLECTOR_BANK_PARTY_ID	NUMBER	(15)		Collecting bank's party ID
COLLECTOR_BRANCH_PARTY_ID	NUMBER	(15)		Collector bank's branch party ID
CASH_RECEIPT_ID	NUMBER	(15)		CASH_RECEIPT_ID is for storing the receipt id when an unapplied receipt is created.

Query Text

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


SELECT DOCUMENT_ID
,      BORDERO_ID
,      PAYMENT_SCHEDULE_ID
,      DOCUMENT_STATUS
,      ORIGIN_TYPE
,      DUE_DATE
,      SELECTION_DATE
,      PORTFOLIO_CODE
,      BATCH_SOURCE_ID
,      RECEIPT_METHOD_ID
,      CUSTOMER_TRX_ID
,      TERMS_SEQUENCE_NUMBER
,      DOCUMENT_TYPE
,      BANK_ACCOUNT_ID
,      PREVIOUS_DOC_STATUS
,      OUR_NUMBER
,      BANK_USE
,      COLLECTOR_BANK_NUMBER
,      COLLECTOR_BRANCH_NUMBER
,      FACTORING_RATE
,      FACTORING_RATE_PERIOD
,      FACTORING_AMOUNT
,      FACTORING_DATE
,      CANCELLATION_DATE
,      BANK_INSTRUCTION_CODE1
,      BANK_INSTRUCTION_CODE2
,      NUM_DAYS_INSTRUCTION
,      BANK_CHARGE_AMOUNT
,      CASH_CCID
,      EARNED_CCID
,      ON_ACCOUNT_CCID
,      UNAPPLIED_CCID
,      UNEARNED_CCID
,      UNIDENTIFIED_CCID
,      BANK_CHARGES_CCID
,      COLL_ENDORSEMENTS_CCID
,      BILLS_COLLECTION_CCID
,      OTHER_CREDITS_CCID
,      FACTORING_DOCS_CCID
,      CALCULATED_INTEREST_CCID
,      INTEREST_WRITEOFF_CCID
,      FACTORING_INTEREST_CCID
,      ABATEMENT_WRITEOFF_CCID
,      ABATEMENT_REVENUE_CCID
,      INTEREST_REVENUE_CCID
,      CALCULATED_INTEREST_RECTRX_ID
,      INTEREST_WRITEOFF_RECTRX_ID
,      INTEREST_REVENUE_RECTRX_ID
,      ABATEMENT_WRITEOFF_RECTRX_ID
,      ABATE_REVENUE_RECTRX_ID
,      ORG_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      BANK_ACCT_USE_ID
,      COLLECTOR_BANK_PARTY_ID
,      COLLECTOR_BRANCH_PARTY_ID
,      CASH_RECEIPT_ID
FROM JL.JL_BR_AR_COLLECTION_DOCS_ALL;

Dependencies

[top of page]

JL.JL_BR_AR_COLLECTION_DOCS_ALL does not reference any database object

JL.JL_BR_AR_COLLECTION_DOCS_ALL is referenced by following:

APPS: JL_BR_AR_COLLECTION_DOCS; JL_BR_AR_COLLECTION_DOCS_ALL