CML_TROP_CHARGE_TO_SHIP_LINES
This table stores the Transfer Order Shipment lines associated to a Trade Operation Charge.
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CML_TROP_CHARGE_TO_SHIP_PK |
TROP_CHARGE_TO_SHIP_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TROP_CHARGE_TO_SHIP_LINE_ID | NUMBER | 18 | Yes | Surrogate identifier for this table. | |
| TRADE_OPERATION_CHARGE_ID | NUMBER | 18 | Yes | Surrogate ID identifying trade operation charge line to which this transfer order shipment line is associated. | |
| SHIPMENT_LINE_ID | NUMBER | 18 | Yes | Shipment line identifier in RCV_SHIPMENT_LINES table. | |
| SHIPPED_QTY | NUMBER | Yes | This column stores the quantity shipped for the transfer order shipment line. | ||
| SHIPMENT_UOM_CODE | VARCHAR2 | 3 | Yes | Transfer order shipment line UOM code. | |
| TRACKED_QTY | NUMBER | Yes | This is the quantity considered by allocation processor, defaulted from the transfer order shipment line quantity. | ||
| UOM_CODE | VARCHAR2 | 3 | Yes | This is the UOM considered by allocation processor, defaulted from the transfer order shipment line UOM code. | |
| SHIPPED_QTY_IN_TO_UOM | NUMBER | Yes | This column stores the quantity shipped for the transfer order shipment line in transfer order unit of measure. | ||
| TO_UOM_CODE | VARCHAR2 | 3 | Yes | This column stores the unit of measure code of the transfer order. | |
| SHIPPED_QTY_IN_PRIMARY_UOM | NUMBER | Yes | This column stores the quantity shipped for the transfer order shipment line in item's primary unit of measure. | ||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Yes | This column stores the primary unit of measure code of the item in the receiving organization. | |
| SHIPPED_QTY_IN_SECONDARY_UOM | NUMBER | This column stores the quantity shipped for the transfer order shipment line in the item's secondary unit of measure. | |||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | This column stores the secondary unit of measure code of the inventory item in the receiving organization. | ||
| ESTIMATED_TRANSFER_PRICE | NUMBER | This is the estimated unit price from source organization in destination organization functional currency. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | The functional currency of the destination organization. | ||
| 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 transfer order shipment 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 back end. | ||
| MAT_REQ_BU_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Functional currency code of the business unit of receiving organization in the transfer order. | |
| MAT_REQ_BU_CURR_CONV_RATE | NUMBER | Currency conversion rate to convert from charge currency to receiving organization BU functional currency. | |||
| CHARGE_BU_CURR_CONV_RATE | NUMBER | Currency conversion rate to convert from charge currency to charge BU functional currency. | |||
| TROP_DOC_CURRENCY_CONV_RATE | NUMBER | Currency conversion rate to convert from charge currency 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. | |||
| 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. | ||
| FROM_ORGANIZATION_ID | NUMBER | 18 | This column stores the source inventory organization identifier for transfer order shipment lines. | ||
| TO_ORGANIZATION_ID | NUMBER | 18 | This column stores the receiving inventory organization identifier where the transfer order receipt is created. | ||
| DESTINATION_LOCATION_ID | NUMBER | 18 | This column stores the deliver to location unique identifier. | ||
| ITEM_ID | NUMBER | 18 | Identifies the item on the transfer order line. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CML_TROP_CHARGE_TO_SHIP_U1 | Unique | Default | TROP_CHARGE_TO_SHIP_LINE_ID |
| CML_TROP_CHARGE_TO_SHIP_U2 | Unique | default | TRADE_OPERATION_CHARGE_ID, SHIPMENT_LINE_ID |