CST_PO_SCHEDULE_ACQ_COST

This table along with the related details table stores the acquisition cost history of a PO Schedule for global procurement scenarios. This header table stores the quantity history through all the trade intransit receipts and returns. The detail table CST_PO_SCHEDULE_ACQ_COST_DTLS stores the acquisition cost by cost component.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
CST_PO_SCHEDULE_ACQ_COST_PK	CMR_PO_LINE_LOCATION_ID, EFFECTIVE_DATE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CMR_PO_LINE_LOCATION_ID	NUMBER		18	Yes	Po line location identifier in receipt accounting.
EFFECTIVE_DATE	TIMESTAMP			Yes	Indicates the effective date of the acquisition cost.
ACTIVE_FLAG	VARCHAR2	1			Indicates whether this is the latest acquisition cost computed for the PO schedule.
PRIMARY_NET_TIR_QTY	NUMBER				The net trade instransit receipt quantity (including all the trade intransit returns against the PO schedule) in the primary UOM of the item.
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.
NET_TIR_QTY	NUMBER				Source document quantity. e.g. Purchase Order Quantity or ASN Quantity
INVOICE_QTY	NUMBER				Net invoiced quantity for each PO schedule of global pruchase order.
SECONDARY_NET_TIR_QTY	NUMBER				The net trade instransit receipt quantity (including all the trade intransit returns against the PO schedule) in the secondary UOM of the item.

Indexes

Index	Uniqueness	Tablespace	Columns
CST_PO_SCHEDULE_ACQ_COST_PK	Unique	FUSION_TS_TX_DATA	CMR_PO_LINE_LOCATION_ID, EFFECTIVE_DATE