Order and Inventory Management Data Dictionary

Option_Item__c

Label: Option Item

This Object describes the business information for Items that have configured options. Populated from the quoting tool options are associated to a Item Master (Product SKU) on a Quotation Line. This configuration for a quotation line could be related to Sales and Purchase Order lines along with Invoice lines for Order fulfillment, Procurement and Invoicing processes There are workflow, and business intelligences dependent on this object.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Currency__c Currency Pre-Spring 2018 This Field denotes the currency that the Item Option was priced or costed at

Looks up to: Currency_Master__c
Lookup
Customer_Quotation_Line__c Customer Quotation Line Pre-Spring 2018 This Field denotes a reference to the Customer Quote Line used during the Sales process

Looks up to: Customer_Quotation_Line__c
Lookup
Ext_Item_Cost__c Ext. Item Cost Pre-Spring 2018 This Field describes an Option's exteded cost (QTY X cost) - Used for reporting and providing detailed information to the Supplier on the Purchase Order

Formula:
Item_Cost__c * Quantity__c
Currency(18,9)
Ext_List_Price__c Ext. List Price Pre-Spring 2018 This Field describes an Option's extended list price before discounting (QTY X Price) - Used for reporting and understanding the list price for Options sold to a customer

Formula:
List_Price__c * Quantity__c
Currency(18,9)
Ext_Price__c Ext. Price Pre-Spring 2018 This Field describes an Option's extended price after discounting (QTY X Price) - Used for reporting and understanding the discounted price for Options sold to a customer

Formula:
Price__c * Quantity__c
Currency(18,9)
Invoice_Line_Item__c Invoice Line Item Pre-Spring 2018 This Field denotes a reference to the Invoice Line item was was sold on the Sales Order Line - Used for reporting and providing detailed information on the customer invoice

Looks up to: Invoice_Line_Item__c
Lookup
Item_Cost__c Item Cost Pre-Spring 2018 This Field describes an Option's cost - Used for reporting and providing detailed information to the Supplier on the Purchase Order

Currency(18,9) 0
Item_Description_No_Item_Record__c Item Description - No Item Record Pre-Spring 2018 This Field denotes a reference to the Item Master Option description when no Itme master is used that was was sold on the Sales Order Line or purchaed on the Purchase Order Line- Used for reporting and providing detailed information on the customer invoice

TextArea
Item_Description__c Item Description Pre-Spring 2018 This Field denotes a reference to the Item Master description that was was sold on the Sales Order Line or purchaed on the Purchase Order Line- Used for reporting and providing detailed information on the customer invoice

Formula:
Item__r.Item_Description__c
Text
Item_No_Item_Record__c Item - No Item Record Pre-Spring 2018 This Field denotes a reference to the Item Master Option when no Itme master is used that was was sold on the Sales Order Line or purchaed on the Purchase Order Line- Used for reporting and providing detailed information on the customer invoice

Text(80)
Item_Option__c Item Option Pre-Spring 2018 Looks up to: Item_Option__c
Lookup
Item__c Item Pre-Spring 2018 This Field denotes a reference to the Item Master that was was sold on the Sales Order Line or purchaed on the Purchase Order Line- Used for reporting and providing detailed information on the customer invoice

Looks up to: Item__c
Lookup
Line_Number__c Line Number Pre-Spring 2018 Number(3,0) 0
List_Price__c List Price Pre-Spring 2018 This Field describes an Option's list price before discounting - Used for reporting and understanding the list price for Options sold to a customer

Currency(18,9) 0
Option_Description__c Option Description Pre-Spring 2018 Formula:
IF( Item__c != null, Item__r.Item_Description__c , Item_Description_No_Item_Record__c )
Text
Option_Name__c Option Name Pre-Spring 2018 Formula:
IF(Item__c != null, Item__r.Name, Item_No_Item_Record__c)
Text
Parent_Customer_Quotation_Line__c Parent Customer Quotation Line Pre-Spring 2018 Looks up to: Customer_Quotation_Line__c
Lookup
Price__c Price Pre-Spring 2018 This Field describes an Option's price after discounting - Used for reporting and understanding the discounted price for Options sold to a customer

Currency(18,9) 0
Purchase_Order_Line_Item__c Purchase Order Line Item Pre-Spring 2018 This Field denotes a reference to the Purchase Order Line item that is being purchased or was sold on the Sales Order Line (Drop Ship Fulfillment) - Used for reporting and providing detailed information to the Supplier on the Purchase Order

Looks up to: Purchase_Order_Line_Item__c
Lookup
Quantity__c Quantity Pre-Spring 2018 The quantity of the option being provided in the configuration

Number(14,4)
Sales_Order_Line_Item__c Sales Order Line Item Pre-Spring 2018 This Field denotes a reference to the Sales Order Line item that was was sold on the Quotation Line - Used for reporting and providing detailed information on the customer invoice

Looks up to: Sales_Order_Line_Item__c
Lookup
Service_Contract_Line_Option__c Service Contract Line Option Pre-Spring 2018 Looks up to: Service_Order_Line_Option__c
Lookup
Service_Contract_Line__c Service Contract Line Pre-Spring 2018 Looks up to: Service_Order_Line__c
Lookup
Sourcing_Request_Line__c Sourcing Request Line Pre-Spring 2018 This Field denotes a reference to the Sourcing Request line Line item that is was set out during a RFQ process - Used for reporting and providing detailed information to the Supplier on the Purchase Order

Looks up to: Sourcing_Request_Line__c
Lookup
Status__c Status Pre-Spring 2018 Picklist:
Cancelled
Current


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