PJB_INV_CONFIG_DISTS

An internal table used for storing the list of Invoice distributions used for creating Configurator Automatic Events when Configurator formula uses Run Sources.

Details

• Schema: FUSION

• Object owner: PJB

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
INV_CONFIG_DIST_ID	NUMBER		18	Yes	Invoice Configurator Distribution Identifier.
INVOICE_DIST_ID	NUMBER		18	Yes	Identifier of Invoice Distribution.
CONFIGURATION_ID	NUMBER		18	Yes	Identifier of Process Configurator.
TRANSACTION_ID	NUMBER		18		Transaction Identifier.
BILL_TRX_ID	NUMBER		18		Identifier of the Billing Transaction.
CONTRACT_ID	NUMBER		18	Yes	Identifier of Contract for which Configurator Event is being created.
CONTRACT_LINE_ID	NUMBER		18	Yes	Identifier of Contract Line for which Configurator Event is being created.
CONTRACT_PROJECT_LINKAGE_ID	NUMBER		18		Identifier of Associated Project Linkage for which Configurator Event is being created.
BILL_TRANSACTION_TYPE_CODE	VARCHAR2	30			Indicator of billing transaction type .
CONFIG_EVENT_ID	NUMBER		18		Identifier of Configurator Event.
CONFIG_EVENT_AMT	NUMBER				Configurator Event Amount corresponding to Configurator Event Identifier.
IDL_CONT_CURR_BILLED_AMT	NUMBER				Invoice Distribution Contract Currency Billed Amount
REVERSED_EVENT_ID	NUMBER		18		Identifier of Reversed Configurator Event.
REVERSED_FLAG	VARCHAR2	1			Indicator of whether the Invoice Distribution corresponding to Configurator Event has been reversed.
REVERSED_INV_CONFIG_DIST_ID	NUMBER		18		Reversed Invoice Configurator Distribution Identifier.
ALIAS1	VARCHAR2	80			Alias of first configurator source.
ALIAS2	VARCHAR2	80			Alias of second configurator source.
ALIAS3	VARCHAR2	80			Alias of third configurator source.
ALIAS4	VARCHAR2	80			Alias of fourth configurator source.
ALIAS5	VARCHAR2	80			Alias of fifth configurator source.
ALIAS6	VARCHAR2	80			Alias of sixth configurator source.
ALIAS7	VARCHAR2	80			Alias of seventh configurator source.
ALIAS8	VARCHAR2	80			Alias of eighth configurator source.
ALIAS9	VARCHAR2	80			Alias of ninth configurator source.
ALIAS10	VARCHAR2	80			Alias of tenth configurator source.
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_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
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.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
IDL_CONFIG_AMT	NUMBER				Configuration amount corresponding to invoice distribution.

Indexes

Index	Uniqueness	Tablespace	Columns
PJB_INV_CONFIG_DISTS_N1	Non Unique	Default	REQUEST_ID
PJB_INV_CONFIG_DISTS_N2	Non Unique	Default	CONTRACT_ID, CONFIG_EVENT_ID, REVERSED_FLAG
PJB_INV_CONFIG_DISTS_U1	Unique	Default	INV_CONFIG_DIST_ID
PJB_INV_CONFIG_DISTS_U2	Unique	Default	INVOICE_DIST_ID, CONFIGURATION_ID