CST_ACQ_COST_ADJUSTMENTS

This table along with the related details table stores the acquisition cost adjustment details for a delivery. This header table stores the currency information and the quantity details. The detail table CST_ACQ_COST_ADJUSTMENT_DTLS stores the new and old unit cost by cost component.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
CST_ACQ_COST_ADJUSTMENTS_PK	ADJUSTMENT_TRANSACTION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ADJUSTMENT_TRANSACTION_ID	NUMBER		18	Yes	Single column FK: Identifies the cost adjustment.
CST_INV_TRANSACTION_ID	NUMBER		18	Yes	Single column FK: Identifies the Inventory transaction.
PRIMARY_ADJ_QTY	NUMBER				The quantity (in primary UOM of the item) to which the cost adjustment applies
PRIMARY_UOM	VARCHAR2	25			Primary unit of measure of the item
SECONDARY_ADJ_QTY	NUMBER				The quantity (in secondary UOM of the item) to which the cost adjustment applies
SECONDARY_UOM	VARCHAR2	25			Secondary unit of measure of the item
SOURCE_DOC_NET_DEL_QTY	NUMBER				Net Transaction Quantity in source document unit of measure.
SOURCE_DOC_UOM	VARCHAR2	25			Source document unit of measure.
PO_RCPT_QTY	NUMBER				Root receipt delivered quantity in purchase order unit of measure.
PRIMARY_RCPT_QTY	NUMBER				Root receipt delivered quantity in item primary unit of measure.
SECONDARY_RCPT_QTY	NUMBER				Root receipt delivered quantity in item secondary unit of measure.
CURRENCY_CODE	VARCHAR2	15			Identifies the currency of the transaction / cost.
CURRENCY_CONVERSION_TYPE	VARCHAR2	30			Obsolete Column : Currency Conversion Type of the item for the Adjustment
CURRENCY_CONVERSION_DATE	TIMESTAMP				Obsolete Column : Currency Conversion Date of the item for the Adjustment
CURRENCY_CONVERSION_RATE	NUMBER				Obsolete Column : Currency Conversion Rate of the item for the Adjustment
PREPROCESSED_FLAG	VARCHAR2	5			Indicates Preprocessed Status of the Adjustment record
CMR_PO_LINE_LOCATION_ID	NUMBER		18		Identifies the PO Schedule. Used to easily identify acquisition cost adjustments for global procurement trade intransit receipt transactions.
ACCOUNTING_DATE	TIMESTAMP				Date when the invoice was accounted.
ADJUSTMENT_DATE	TIMESTAMP				Indicates the adjustment date derived in preprocessing to be used in cost processing acquisition cost adjustments.
EFF_DATE	TIMESTAMP				This indicates the effective date of the acquisition cost.
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.
INVENTORY_ITEM_ID	NUMBER		18		Identifies the inventory item associated with the acquisition cost adjustment.
INVENTORY_ORG_ID	NUMBER		18		Indicates the inventory organization to which the item belongs.

Foreign Keys

Table	Foreign Table	Foreign Key Column
cst_acq_cost_adj_sources	cst_acq_cost_adjustments	ADJUSTMENT_TRANSACTION_ID
cst_acq_adj_txn_costs	cst_acq_cost_adjustments	ADJUSTMENT_TRANSACTION_ID
cst_transaction_costs	cst_acq_cost_adjustments	ADJUSTMENT_TRANSACTION_ID
cst_acq_cost_adjustment_dtls	cst_acq_cost_adjustments	ADJUSTMENT_TRANSACTION_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CST_ACQ_COST_ADJUSTMENTS_N1	Non Unique	FUSION_TS_TX_DATA	REQUEST_ID
CST_ACQ_COST_ADJUSTMENTS_N2	Non Unique	FUSION_TS_TX_DATA	PREPROCESSED_FLAG, CST_INV_TRANSACTION_ID
CST_ACQ_COST_ADJUSTMENTS_PK	Unique	FUSION_TS_TX_DATA	ADJUSTMENT_TRANSACTION_ID