CML_TROP_DEFAULT_PO_SCHEDULES

This table stores the set of default purchase order schedules added to a trade operation. The default purchase order schedules apply to each and every charge line added to a trade operation.

Details

• Schema: FUSION

• Object owner: CML

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
CML_TROP_DEFAULT_POS_PK	TROP_DEFAULT_PO_SCHEDULE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TROP_DEFAULT_PO_SCHEDULE_ID	NUMBER		18	Yes	Surrogate key that identifies the trade operation default po schedules
TRADE_OPERATION_ID	NUMBER		18	Yes	Foreign key reference to the CML_TRADE_OPERATIONS table.
CMR_PO_LINE_LOCATION_ID	NUMBER		18	Yes	The purchase order line location identifier.
EVENT_DATE	TIMESTAMP			Yes	Date when the event happened on the PO.
PO_PRICE	NUMBER			Yes	Purchase price (per unit) specified by the buyer on the purchase order.
PO_PRICE_IN_FUNC_CURRENCY	NUMBER			Yes	Price on PO Schedule in functional currency
PO_CURRENCY_CODE	VARCHAR2	15		Yes	Currency Code on the Purchase Order
PO_QTY_IN_PRIMARY_UOM	NUMBER			Yes	Ordered quantity on PO Schedule in Primary UOM
PO_QTY_IN_SECONDARY_UOM	NUMBER				Ordered quantity on PO Schedule in Secondary UOM
PO_PRIMARY_UOM_CODE	VARCHAR2	3		Yes	Primary unit of measure code on the purchase order.
PO_SECONDARY_UOM_CODE	VARCHAR2	3			Secondary unit of measure code on the purchase order.
POSTED_FLAG	VARCHAR2	1			Flag to indicate if the transaction is processed.
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.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CML_TROP_DEFAULT_PO_SCHEDULES	cml_trade_operations	TRADE_OPERATION_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CML_TROP_DEFAULT_POS_N1	Non Unique	Default	CMR_PO_LINE_LOCATION_ID
CML_TROP_DEFAULT_POS_PK	Unique	Default	TROP_DEFAULT_PO_SCHEDULE_ID
CML_TROP_DEFAULT_POS_U1	Unique	Default	TRADE_OPERATION_ID, CMR_PO_LINE_LOCATION_ID