JL_BR_AR_DISTRIBUTNS_ALL

This is an obsolete table and not in use.

Details

• Schema: FUSION

• Object owner: JL

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
JL_BR_AR_DISTRIBUTNS_PK	DISTRIBUTION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
ORG_ID	NUMBER		18	Yes	Indicates the identifier of the business unit associated to the row.	Active
DISTRIBUTION_ID	NUMBER		18	Yes	Bank occurrence distribution identifier.	Active
DOCUMENT_ID	NUMBER		18	Yes	Bank collection document identifier.	Active
DISTRIBUTION_LINK_TYPE	VARCHAR2	30		Yes	Bank occurrence distribution link type code.	Active
DISTRIBUTION_TYPE	VARCHAR2	30		Yes	Bank occurrence distribution type code.	Active
GL_DATE	DATE			Yes	Accounting date on a bank occurrence distribution.	Active
ENTERED_AMT	NUMBER			Yes	Distribution amount. This is the endorsement amount if distribution type is receivables endorsement, bank charges amount if it is bank charges and factoring charges amount if it is receivables factoring.	Active
ENTERED_CURRENCY_CODE	VARCHAR2	30		Yes	Entered currency code on a bank occurrence distribution.	Active
ACCTD_AMT	NUMBER				Distribution amount in ledger currency.	Active
CONVERSION_RATE	NUMBER				Conversion rate at which the principal unit of one currency can be converted into another currency.	Active
CONVERSION_DATE	DATE				Date of the conversion rate for one currency to another currency.	Active
CONVERSION_RATE_TYPE	VARCHAR2	30			Conversion rate type for one currency to another currency.	Active
ACCOUNTING_REVERSAL_OPTION	VARCHAR2	30			Yes or No indicates whether the distribution row reverses any other distribution row.	Active
REVERSED_DIST_ID	NUMBER		18		Reversed distribution identifier on a bank occurrence distribution.	Active
REVERSED_DIST_LINK_TYPE	VARCHAR2	30			Reversed distribution link type code on a bank occurrence distribution.	Active
PRIOR_DIST_ID	NUMBER		18		Prior distribution identifier. This is the distribution identifier of a remittance occurrence corresponding to a return occurrence.	Active
PRIOR_DIST_LINK_TYPE	VARCHAR2	30			Prior distribution link type code on a bank occurrence distribution.	Active
EVENT_ID	NUMBER		18		Subledger accounting event identifier for a distribution.	Active
EVENT_DATE	DATE				Subledger accounting event occurrence date.	Active
OCCURRENCE_ID	NUMBER		18		Bank correction identifier on a bank occurrence distribution.	Active
BANK_OCCURRENCE_CODE	VARCHAR2	30			Bank occurrence code on a bank occurrence distribution.	Active
STD_OCCURRENCE_CODE	VARCHAR2	30		Yes	Standard occurrence code. Values are from the lookups JLBR_AR_REMIT_BANK_OCCURENCE and JLBR_AR_RETURN_BANK_OCCURENCE.	Active
BORDERO_TYPE	VARCHAR2	30		Yes	Bank transfer batch type on a bank occurrence distribution.	Active
BANK_OCCURRENCE_TYPE	VARCHAR2	30		Yes	Bank occurrence type. Values are from the lookup JLBR_AR_BANK_OCCURENCE_TYPE.	Active
DIST_LINE_NUMBER	NUMBER				Bank occurrence distribution number.	Active
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns	Status
JL_BR_AR_DISTRIBUTNS_U1	Unique	FUSION_TS_TX_DATA	DISTRIBUTION_ID	Active
JL_BR_AR_DISTRIBUTNS_U2	Unique	FUSION_TS_TX_DATA	OCCURRENCE_ID, DISTRIBUTION_TYPE, ACCOUNTING_REVERSAL_OPTION	Active
JL_BR_AR_DISTRIBUTNS_U3	Unique	FUSION_TS_TX_DATA	DOCUMENT_ID, OCCURRENCE_ID, DIST_LINE_NUMBER	Active