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.

Note: To use any analytics item that displays data from the Supply Chain Management Core dataset, you must have the Use Business Analytics for SCM permission set assigned in SCM. Contact your administrator if you require this SCM permission set.

Here is a description of the included fields.

Key: C – Calculated field

Supply Chain Management Core Fields

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.