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_SELECT_ACCOUNTS_ALL

Object Details

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

JL_BR_AR_SELECT_ACCOUNTS_ALL stores criteria used for distributing selected trade notes to bank accounts. All trade notes in a bank account form a Bank Transfer Batch.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JL_BR_AR_SELECT_ACCOUNTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SELECT_ACCOUNT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SELECT_ACCOUNT_ID	NUMBER		Yes	Account Selection Control identifier
SELECTION_CONTROL_ID	NUMBER		Yes	Selection Control identifier
BANK_ACCOUNT_ID	NUMBER			Bank Account identifier
GL_DATE	DATE			General Ledger Date
SELECTION_DATE	DATE			Selection Date
CANCELLATION_DATE	DATE			Cancellation Date
FORMAT_DATE	DATE			Format date of the first formatted batch in this selection
REMITTANCE_DATE	DATE			Sent Date
PORTFOLIO_CODE	NUMBER			Portfolio Code
MIN_DOCUMENT_AMOUNT	NUMBER			Minimum amount for a document in a Remittance batch
MAX_DOCUMENT_AMOUNT	NUMBER			Maximum amount for a document in a Remittance batch
MIN_REMITTANCE_AMOUNT	NUMBER			Minimum amount for a Remittance batch
MAX_REMITTANCE_AMOUNT	NUMBER			Maximum amount for a Remittance batch
BANK_INSTRUCTION_CODE1	NUMBER			Bank Instruction 1
BANK_INSTRUCTION_CODE2	NUMBER			Bank Instruction 2
BANK_CHARGE_AMOUNT	NUMBER			Bank charges
BATCH_SOURCE_ID	NUMBER			Used in bank return to create a batch for interim cash receipts. Default from JL_BR_AR_REC_MET_ACCTS_EXT.
PERCENTAGE_DISTRIBUTION	NUMBER			Percentage amount distribution to accounts
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)	Yes	Uniquely identifies the bank account uses

Query Text

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


SELECT SELECT_ACCOUNT_ID
,      SELECTION_CONTROL_ID
,      BANK_ACCOUNT_ID
,      GL_DATE
,      SELECTION_DATE
,      CANCELLATION_DATE
,      FORMAT_DATE
,      REMITTANCE_DATE
,      PORTFOLIO_CODE
,      MIN_DOCUMENT_AMOUNT
,      MAX_DOCUMENT_AMOUNT
,      MIN_REMITTANCE_AMOUNT
,      MAX_REMITTANCE_AMOUNT
,      BANK_INSTRUCTION_CODE1
,      BANK_INSTRUCTION_CODE2
,      BANK_CHARGE_AMOUNT
,      BATCH_SOURCE_ID
,      PERCENTAGE_DISTRIBUTION
,      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
FROM JL.JL_BR_AR_SELECT_ACCOUNTS_ALL;

Dependencies

[top of page]

JL.JL_BR_AR_SELECT_ACCOUNTS_ALL does not reference any database object

JL.JL_BR_AR_SELECT_ACCOUNTS_ALL is referenced by following:

APPS: JL_BR_AR_SELECT_ACCOUNTS; JL_BR_AR_SELECT_ACCOUNTS_ALL