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_DISTRIBUTNS_ALL

Object Details

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

Stores distributions for a collection and occurrence document.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JL_BR_AR_DISTRIBUTNS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DISTRIBUTION_ID
JL_BR_AR_DISTRIBUTNS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	OCCURRENCE_ID DISTRIBUTION_TYPE ACCOUNTING_REVERSAL_OPTION
JL_BR_AR_DISTRIBUTNS_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOCUMENT_ID OCCURRENCE_ID DIST_LINE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_ID	NUMBER	(15)	Yes	Operating Unit
DISTRIBUTION_ID	NUMBER	(15)	Yes	Bank Occurrence Distribution Identifier
DOCUMENT_ID	NUMBER	(15)	Yes	Collection Document Identifier
DISTRIBUTION_LINK_TYPE	VARCHAR2	(30)	Yes	Distribution Link Type Code
DISTRIBUTION_TYPE	VARCHAR2	(30)	Yes	Bank Occurrence Distribution Type Code. Possible values are: 'JLBR_AR_ENDORSEMENT' for Endorsement Distributions, 'JLBR_AR_BANK_CHARGES' for Bank Charges Distributions, 'JLBR_AR_FACTORING_CHARGES' for Factoring Charges Distributions
GL_DATE	DATE		Yes	General Ledger Date
ENTERED_AMT	NUMBER		Yes	Distribution Amount. This is the endorsement amount if DISTRIBUTION_TYPE is 'JLBR_AR_ENDORSEMENT', bank charges amount if DISTRIBUTION_TYPE is 'JLBR_AR_BANK_CHARGES' and factoring charges amount if DISTRIBUTION_TYPE is 'JLBR_AR_FACTORING_CHARGES'
ENTERED_CURRENCY_CODE	VARCHAR2	(30)	Yes	Transaction Currency Code
ACCTD_AMT	NUMBER			Distribution Amount in the functional currency
CONVERSION_RATE	NUMBER			Exchange Rate used
CONVERSION_DATE	DATE			Exchange Rate Date used
CONVERSION_RATE_TYPE	VARCHAR2	(30)		Exchange Rate Type used
ACCOUNTING_REVERSAL_OPTION	VARCHAR2	(30)		Lookup code that indicates whether the distribution row reverses any other distribution row. Possible values are 'Y' and 'N'.
REVERSED_DIST_ID	NUMBER	(15)		Reversed Distribution Identifier
REVERSED_DIST_LINK_TYPE	VARCHAR2	(30)		Reversed Distribution Link Type Code
PRIOR_DIST_ID	NUMBER	(15)		Prior Distribution Identifier. This is the DISTRIBUTION_ID of the remittance occurrence corresponding to the return occurrence
PRIOR_DIST_LINK_TYPE	VARCHAR2	(30)		Prior Distribution Link Type Code
EVENT_ID	NUMBER	(15)		Subledger Accounting Event Identifier
EVENT_DATE	DATE			Subledger Accounting Event Occurrence Date
OCCURRENCE_ID	NUMBER	(15)		Bank Occurrence Identifier
BANK_OCCURRENCE_CODE	NUMBER			Bank occurrence code
STD_OCCURRENCE_CODE	VARCHAR2	(30)	Yes	Lookup Code for Lookup Type JLBR_AR_REMIT_BANK_OCCURENCE and JLBR_AR_RETURN_BANK_OCCURENCE
BORDERO_TYPE	VARCHAR2	(30)	Yes	Bank Transfer Batch Type
BANK_OCCURRENCE_TYPE	VARCHAR2	(30)	Yes	Lookup Code for Lookup Type JLBR_AR_BANK_OCCURENCE_TYPE
DIST_LINE_NUMBER	NUMBER			Bank Occurrence Distribution Number

Query Text

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


SELECT ORG_ID
,      DISTRIBUTION_ID
,      DOCUMENT_ID
,      DISTRIBUTION_LINK_TYPE
,      DISTRIBUTION_TYPE
,      GL_DATE
,      ENTERED_AMT
,      ENTERED_CURRENCY_CODE
,      ACCTD_AMT
,      CONVERSION_RATE
,      CONVERSION_DATE
,      CONVERSION_RATE_TYPE
,      ACCOUNTING_REVERSAL_OPTION
,      REVERSED_DIST_ID
,      REVERSED_DIST_LINK_TYPE
,      PRIOR_DIST_ID
,      PRIOR_DIST_LINK_TYPE
,      EVENT_ID
,      EVENT_DATE
,      OCCURRENCE_ID
,      BANK_OCCURRENCE_CODE
,      STD_OCCURRENCE_CODE
,      BORDERO_TYPE
,      BANK_OCCURRENCE_TYPE
,      DIST_LINE_NUMBER
FROM JL.JL_BR_AR_DISTRIBUTNS_ALL;

Dependencies

[top of page]

JL.JL_BR_AR_DISTRIBUTNS_ALL does not reference any database object

JL.JL_BR_AR_DISTRIBUTNS_ALL is referenced by following:

APPS: JL_BR_AR_DISTRIBUTNS; JL_BR_AR_DISTRIBUTNS_ALL