Supply Chain Management Core Fields
The Supply Chain Management Core dataset includes calculated and non-calculated fields from from the following objects in SCM: ICP, Warehouse, Inventory Location, Inventory Position, Inventory Transfer Perpetual Record, Item Master, Sales Order, Sales Order Line Item, Purchase Order, Purchase Order Line Item, Requisition, Requisition Line Item, and Backorder.
Here is a description of the included fields.
Key: C – Calculated field
|
Field |
|
Description |
|---|---|---|
| Currency Master Corporate Currency | Indicates whether the currency in a currency master record is the corporate currency. | |
| Currency Master Name | The ISO code of the currency in a currency master record. | |
| Fixed Order Quantity | Fixed order quantity for a requisition that is generated as a result of Reorder Point Control or Safety Stock Control. | |
| ICP Name | The inventory control point name. | |
| Inventory Position Quantity | The quantity stored in the inventory position. | |
| Item Name | The item name. | |
| Minimum Order Quantity | The minimum quantity of the supply requisition when the Reorder Point Level is reached. | |
| Product Group Name | The product group name. | |
| Purchase Order Buyer User Name | The buyer user name of the purchase order. | |
| Purchase Order Date | The date the purchase order version was created. | |
| Purchase Order Date Month | The month of the purchase order date. | |
| Purchase Order Date Month Number | The month number of the purchase order date. | |
| Purchase Order Date Year | The year of the purchase order date. | |
| Purchase Order Line Item Amount Vouchered | The vouchered amount of the purchase order. | |
| Purchase Order Line Item Line Type | The line type of the purchase order line item. | |
| Purchase Order Line Item Quantity | The number of units in the purchase order line item. | |
| Purchase Order Line Item Quantity Received | The received quantity of the purchase order line item. | |
| Purchase Order Line Item Quantity Vouchered | The vouchered quantity of the purchase order line item. | |
| Purchase Order Line Item Status | The status of the purchase order line item. | |
| Purchase Order Line Item Total Cost | The total cost of the purchase order line item. | |
| Purchase Order Line Item Unit Cost With Options | The unit cost with option of the purchase order line item. | |
| Purchase Order Line Item Unvouchered Amount | C | The value of all unvouchered goods and services in the purchase order line. |
| Purchase Order Line Requested Delivery Date | The requested delivery date of the purchase order line. | |
| Purchase Order Name | The name of the purchase order. | |
| Purchase Order Procured For Name | The name of the customer for which the goods and services on the purchase order are being procured. | |
| Purchase Order Received Unvouchered Amount | C | The value of all received unvouchered goods and services in purchase orders. |
| Purchase Order Record Type Name | The name of the purchase order record type. | |
| Purchase Order Recurring PO | Indicates whether the purchase order is a recurring purchase order. | |
| Purchase Order Status | The status of the purchase order. | |
| Purchase Order Supplier Site Name | The name of the supplier for the purchase order. | |
| Purchase Order Total Amount Vouchered | The total vouchered amount of the purchase order. | |
| Purchase Order Total Quantity Vouchered | The total vouchered quantity of the purchase order. | |
| Purchase Order Total Value of PO | The total value of the purchase order. | |
| Purchase Order Unreceived Unvouchered Amount | C | The value of all unreceived unvouchered goods and services in purchase orders. |
| Purchase Orders | C | The number of purchase orders containing unvouchered goods and services, either received or unreceived. |
| Reorder Point Level Value | The level that the inventory must reach before a supply requisition is created. | |
| Requisition Line Item Quantity | The number of units in the requisition line item. | |
| Safety Stock Level Value | The minimum level of stock to be kept when Safety Stock Control is selected on the reorder criteria record for an item master. | |
| Sales Order Line Item Quantity | The number of units in the sales order line item. | |
| Sales Order Line Item Quantity Allocated | The number of parts allocated to the sales order line item. | |
| Sales Order Line Item Quantity Backordered | The number of parts in the sales order line item that are backordered. | |
| Value of Items in Purchase Order Lines | C | The value of all goods and services in received and unreceived purchase order lines. |
| Warehouse Name | The name of the warehouse. |