CML_TROP_CHARGE_PO

Details

Schema: FUSION
Object owner: CML
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
CML_TROP_CHARGE_PO_SCHED_PK	TROP_CHARGE_PO_SCHEDULE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TROP_CHARGE_PO_SCHEDULE_ID	NUMBER		18	Yes	Surrogate identifier for this table.
TRADE_OPERATION_CHARGE_ID	NUMBER		18	Yes	Foreign key to CML_TRADE_OPERATION_CHARGES.
CMR_PO_LINE_LOCATION_ID	NUMBER		18	Yes	The purchase order line location identifier.
EVENT_DATE	TIMESTAMP			Yes	Event Date when the event happened on the PO.
REJECT_EVENT_DATE	TIMESTAMP				Event Date when the Data Updates from PO is rejected.
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.
UOM_TYPE_CODE	VARCHAR2	30		Yes	Unit of Measure Type - Primary or Secondary or in case shipment is used to create a trade operation, the UOM for the shipment quantity.
UOM_CODE	VARCHAR2	3		Yes	UOM code from the PO based on the UOM Type selected.
CURRENCY_CODE	VARCHAR2	15		Yes	Currency Code on the Purchase Order.
ORDERED_QTY	NUMBER			Yes	Ordered quantity on the PO - Primary or secondary quantity depending on the UOM Type selected.
TRACKED_QTY	NUMBER			Yes	Tracked quantity, defaulted from the PO ordered quantity which the user can override.
PRICE	NUMBER			Yes	Purchase price (per unit) specified by the buyer on the purchase order.
RATE	NUMBER				Rate defined in case the charge basis is Per Unit Variable or Percentage of Item Price Variable.
ALLOCATION_FACTOR	NUMBER				The allocation factor existing on the PO schedule line. Can be calculated by the system based on the allocation basis or manually entered by the user.
ALLOCATION_PERCENTAGE	NUMBER				Allocation percentage calculated by the system based on the allocation factor.
DELETED_FLAG	VARCHAR2	1			Flag to indicate that the record has been deleted by the user but maintained in the backend.
MAT_REQ_BU_CURRENCY_CODE	VARCHAR2	15		Yes	Currency Code of the material requisitioning business unit for the purchase order.
MAT_REQ_BU_CURR_CONV_RATE	NUMBER				Currency conversion rate to convert from Charge currency to Material Requisitioning BU functional currency.
CHARGE_REQ_BU_CURR_CONV_RATE	NUMBER				Currency conversion rate to convert from charge currency to charge requisitioning BU currency.
TROP_DOC_CURRENCY_CONV_RATE	NUMBER				Currency conversion rate to convert to Trade Operation Document currency.
ACT_MAT_BU_CURR_CONV_RATE	NUMBER				Currency conversion rate from invoice functional currency to material requisitioning BU currency.
ACT_TROP_DOC_CURR_CONV_RATE	NUMBER				Currency conversion rate from invoice functional currency to trade operation document currency.
PO_PRICE_IN_FUNC_CURRENCY	NUMBER			Yes	Price on PO Schedule in functional currency.
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.
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.
CML_RECONCILIATION_STATUS	NUMBER				This column would store the reconciliation status info.
SHIPMENT_UOM_CODE	VARCHAR2	3			This column stores the unit of measure code for the receiving shipment receipt line.
PO_LINE_LOCATION_ID	NUMBER		18		Purchase order schedule unique identifier.
SHIPMENT_QTY	NUMBER				This column stores the net quantity shipped for the receiving shipment receipt line.
PO_UOM_CONV_FACTOR	NUMBER				Conversion factor from ASN UOM to PO UOM.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CML_TROP_CHARGE_PO_SCHEDULES	cml_trade_operation_charges	TRADE_OPERATION_CHARGE_ID
cml_posched_charge_actuals	cml_trop_charge_po_schedules	TROP_CHARGE_PO_SCHEDULE_ID
cml_posched_charge_estimates	cml_trop_charge_po_schedules	TROP_CHARGE_PO_SCHEDULE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CML_TROP_CHARGE_PO_SCHED_N1	Non Unique	Default	CMR_PO_LINE_LOCATION_ID
CML_TROP_CHARGE_PO_SCHED_PK	Unique	Default	TROP_CHARGE_PO_SCHEDULE_ID
CML_TROP_CHARGE_PO_SCHED_U1	Unique	Default	TRADE_OPERATION_CHARGE_ID, CMR_PO_LINE_LOCATION_ID