Order and Inventory Management Data Dictionary

Backorder__c

Label: Backorder

This object contains information about any Backorders that exist at the current point in time as a result of a sales process (a Sales Order being completed for an item that is not in inventory). As the Backorder is filled, the instance is deleted. This information is used in Acquisition, Inventory Management, and Order Fulfillment processes.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Customer_Site_Sold_To__c Customer Site Sold To Pre-Spring 2018 Formula:
Sales_Order_Line_Item__r.Sales_Order__r.Customer_Account__r.Name
Text
Fill_Order__c Fill Order Pre-Spring 2018 The order to fill Backorders. When there are multiple Backorders for the same item, the Fill Order specifies which order to fill first.

Number(18,0) 9999
Item_Description__c Item Description Pre-Spring 2018 Formula:
if(Sales_Order_Line_Item__c!=null, Sales_Order_Line_Item__r.Item_Master__r.Item_Description__c, Production_Order_Line__r.Item_Master__r.Item_Description__c)
Text
Item__c Item Pre-Spring 2018 Formula:
if(Sales_Order_Line_Item__c!=null, Sales_Order_Line_Item__r.Item_Master__r.Name, Production_Order_Line__r.Item_Master__r.Name)
Text
Kit_Type__c Kit Type Pre-Spring 2018 Formula:
if(Sales_Order_Line_Item__c!=null, TEXT(Sales_Order_Line_Item__r.Item_Master__r.Kit__c), TEXT(Production_Order_Line__r.Item_Master__r.Kit__c))
Text
Ownership_Code__c Ownership Code Pre-Spring 2018 Ownership code associated with the sales order.

Looks up to: Ownership_Code__c
Lookup
Production_Order_Line__c Production Order Line Pre-Spring 2018 Looks up to: Production_Order_Line__c
Lookup
Quantity_Ordered__c Quantity Ordered Pre-Spring 2018 Formula:
if(Sales_Order_Line_Item__c!=null,Sales_Order_Line_Item__r.Quantity__c, Production_Order_Line__r.Quantity__c)
Number(18,4)
Quantity_on_Backorder__c Quantity on Backorder Pre-Spring 2018 Formula:
IF( ISPICKVAL(Status__c, "Reversed"), 0, IF(Sales_Order_Line_Item__c!=null, Sales_Order_Line_Item__r.Quantity_Backordered__c, Production_Order_Line__r.Quantity_Backordered__c ) )
Number(18,4)
Required_Date__c Required Date Pre-Spring 2018 Formula:
IF(Sales_Order_Line_Item__c != null, Sales_Order_Line_Item__r.Customer_Current_Promise_Date__c, Production_Order_Line__r.Production_Order__r.Start_Date__c)
Date
Sales_Order_Line_Item__c Sales Order Line Item Pre-Spring 2018 The Sales Order line item that is associated with the Backorder.

Looks up to: Sales_Order_Line_Item__c
Lookup
Selected_Option_Count__c Selected Option Count Pre-Spring 2018 Formula:
if(Sales_Order_Line_Item__c!=null,Sales_Order_Line_Item__r.Selected_Option_Count__c,0)
Number(18,0)
Status__c Status Pre-Spring 2018 The status of the Backorder. This field cannot be updated by the user.

Picklist:
New
Partially Resolved
Resolved
Reversed
Warehouse__c Warehouse Pre-Spring 2018 Warehouse where backorder can be resolved. This is set based on the sales order.

Looks up to: Warehouse__c
Lookup


© Copyright 2009–2023 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.