CST_PLANNING_PURCHASE_ORDERS
This table contains the list of CTO purchase orders which have been interfaced into cost planning for processing by cost rollup process.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
PLANNING_PURCHASE_ORDER_ID | NUMBER | 18 | Yes | Indicates the surrogate key for the planning purchase orders table. | |
PO_HEADER_ID | NUMBER | 18 | Yes | Indicates the CTO purchase order identifier which is being interfaced for processing by cost rollup processor. | |
PO_NUMBER | VARCHAR2 | 30 | Yes | Indicates the CTO purchase order number which is being interfaced for processing by cost rollup processor. | |
APPROVED_DATE | DATE | Yes | Indicates the date on which the interfaced CTO purchased order was last approved | ||
PO_LINE_ID | NUMBER | 18 | Yes | Indicates the CTO purchase order line identifier which is being interfaced for processing by cost rollup processor. | |
PO_LINE_NUMBER | NUMBER | Indicates the CTO purchase order line number which is being interfaced for processing by cost rollup processor. | |||
INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Item unique identifier | |
PO_LINE_LOCATION_ID | NUMBER | 18 | Yes | Indicates the CTO purchase order schedule identifier which is being interfaced for processing by cost rollup processor. | |
SHIPMENT_NUMBER | NUMBER | Indicates the CTO purchase order shipment number which is being interfaced for processing by cost rollup processor. | |||
QUANTITY | NUMBER | Indicates the quantity ordered for the CTO item in purchase order. | |||
ORGANIZATION_ID | NUMBER | 18 | Yes | Indicates the inventory organization for which the CTO purchase order was created. | |
STATUS_CODE | VARCHAR2 | 30 | Yes | Indicates the status of the interfaced CTO purchaseorder. It is used internally by costing for knowing the status of processing for the CTO 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. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CST_PLANNING_PO_N1 | Non Unique | Default | PO_HEADER_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID |
CST_PLANNING_PO_PK | Unique | Default | PLANNING_PURCHASE_ORDER_ID |
CST_PLANNING_PO_U1 | Unique | Default | PO_LINE_LOCATION_ID |