CMR_CONSIGNED_PO_PRICE_DTLS

This table holds the consigned purchase order price history information that came through the interface CMR_I_CONSIGNED_PO_PRICE_DTLS. Price change information will be used to perform accrual accounting and calculate acquisition costs.

Details

• Schema: FUSION

• Object owner: CMR

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
CMR_CONSIGNED_PO_PRICE_DT_PK	CMR_PO_DISTRIBUTION_ID, EFFECTIVE_DATE, TRANSFER_TO_OWNED_TXN_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CMR_PO_DISTRIBUTION_ID	NUMBER		18	Yes	Internal identifier of the purchase order distribution.
EFFECTIVE_DATE	TIMESTAMP			Yes	Date of effectivity of the consigned PO price.
TRANSFER_TO_OWNED_TXN_ID	NUMBER		18	Yes	Inventory transfer to owned transaction identifier with positive quantity to indicate quantity is moved inventory from consigned.
TAX_EXCLUSIVE_PRICE	NUMBER				Purchase order line price exclusive of all taxes.
PRICE	NUMBER				Transfer owned price with inclusive of taxes.
NONRECOVERABLE_EXCLUSIVE_TAX	NUMBER				Non recoverable exclusive tax (per unit) amount.
NONRECOVERABLE_INCLUSIVE_TAX	NUMBER				Non recoverable inclusive tax (per unit) amount.
EXTERNAL_SYSTEM_REFERENCE	VARCHAR2	60			Identifier of the source system that owns the purchase order entity.
EXTERNAL_SYSTEM_REF_ID	VARCHAR2	30			Identifier of the purchase order entity that determines the price in the source system.
REFERENCE_IDENTIFIER_LEVEL	VARCHAR2	20			Indicates the level of the purchase order entity identified by the EXTERNAL_SYSTEM_REF_ID. Valid values are 'LINE', 'SCHEDULE', 'DISTRIBUTION'.
PROCESSED_BY_CA_FLAG	VARCHAR2	5			Indicates whether the price change was picked up by the cost accounting processor.
PROCESSED_BY_RA_FLAG	VARCHAR2	5			Indicates whether the price change was picked up by the receipt accounting processor.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of 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.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
CMR_CONSIGNED_PO_PRICE_DTLS_N1	Non Unique	Default	TRANSFER_TO_OWNED_TXN_ID
CMR_CONSIGNED_PO_PRICE_DTLS_N2	Non Unique	DEFAULT	PROCESSED_BY_CA_FLAG
CMR_CONSIGNED_PO_PRICE_DTLS_U1	Unique	Default	CMR_PO_DISTRIBUTION_ID, EFFECTIVE_DATE, TRANSFER_TO_OWNED_TXN_ID