Order and Inventory Management Data Dictionary

Sales_Order_Line_Item__c

Label: Sales Order Line Item

This Object describes a Sales Order Line Item. A Sales Order may have multiple line items. Line items facilitate delivery of multiple items or services to customers on one Sales order. They contain the required information for pricing and delivery of goods (i.e., parts, facility supplies (MRO)) or services and are subject to a formal process of approval. This information is used in Sales, Quality, and Finance processes

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
AP_Voucher_Line__c AP Voucher Line Pre-Spring 2018 Looks up to: AP_Voucher_Line__c
Lookup
Advance_Core_Receipt__c Advance Core Receipt? Pre-Spring 2018 The core must be received before the new part is shipped out.

Checkbox false
Allocate_Message__c Allocate Message Pre-Spring 2018 LongTextArea(32768)
Already_Returned__c Already Returned Spring 2019 The current quantity that has already been returned by the customer.

Number(18,4) 0
Applied_Customer_Rebate_Discount__c Applied Customer Rebate Discount Pre-Spring 2018 Currency(18,2) 0
Applied_Rebate_Amount__c Applied Rebate Amount Pre-Spring 2018 Total amount of applied rebate for the sales order line.

Currency(18,2) 0
Avalara_Tax_Code__c Avalara Tax Code Winter 2023 Avalara tax code used to calculate tax for the line item in AvaTax. This value is populated from the relevant AvaTax code to product group mapping, depending on the product group, item type, and delivery method.

Text(20)
Based_on_Customer_Price_List__c Based on Customer Price List Pre-Spring 2018 Is there a published customer price list

Checkbox false
Condition_Code__c Condition Pre-Spring 2018 The condition code of the requested part.

Looks up to: Condition_Code__c
Lookup
Core_Item_Number__c Core Item Number Pre-Spring 2018 This is the expected part number to be returned by customer

Text(32)
Core_Return_Date__c Core Return Date Pre-Spring 2018 Tracks core return requirement dates

Date Today() + 30
Core_Return_Warehouse__c Core Return Warehouse Pre-Spring 2018 The warehouse to which the customer is going to return the core.

Looks up to: Warehouse__c
Lookup
Core_Valuation__c Core Valuation Pre-Spring 2018 The value of the core. The customer will be invoiced this amount if the core is not received.

Currency(14,2)
Cost_With_Options__c Cost With Options Pre-Spring 2018 Formula:
Item_Cost__c + Option_Cost_Per_Unit__c
Currency(18,9)
Customer_Commitment_Date__c Commitment Date Pre-Spring 2018 Date
Customer_Current_Promise_Date__c Current Promise Date Pre-Spring 2018 Date
Customer_Quotation_Line__c Customer Quotation Line Pre-Spring 2018 Reference to customer quotation line item that is associated with this Sales Order line item.

Looks up to: Customer_Quotation_Line__c
Lookup
Customer_Rebate_Discount__c Customer Rebate Discount Pre-Spring 2018 Applied Rebate Amount deducted from the Customer Price

Currency(18,2) 0
Customer_Requested_Date__c Requested Delivery Date Pre-Spring 2018 Date
Delivery_Method__c Delivery Method Pre-Spring 2018 Picklist:
ASP Delivery
Electronic Delivery
Load and Leave
Physical Delivery
Editable_Name__c Editable Sales Order Line Item Name Summer 2023 For system use. Used to enable the Foundations Transform service to edit the record.

Text(255)
Ext_Price_After_Rebate_Discounts__c Ext. Price After Rebate Discounts Pre-Spring 2018 Extended price the customer pays after rebates.

Formula:
Extended_Price__c - Customer_Rebate_Discount__c
Currency(18,2)
Extended_Item_Cost__c Ext. Item Cost Pre-Spring 2018 Formula:
Cost_With_Options__c * Quantity__c
Currency(18,2)
Extended_Price__c Ext. Price Pre-Spring 2018 Extended Price for Sales Order Line Item

Formula:
Price_With_Options__c * Quantity__c
Currency(18,2)
Intangible__c Intangible? Pre-Spring 2018 Formula:
IF(Item_Master__c != null && Item_Master__r.Intangible__c, $Label.Yes, $Label.No)
Text
Item_Cost__c Item Cost Pre-Spring 2018 What we are paying a supplier for this item

Currency(18,9) 0
Item_Description__c Item Description Pre-Spring 2018 Formula:
Item_Master__r.Item_Description__c
Text
Item_Master__c Item Master Pre-Spring 2018 Use this Item Number field for Items that are currently in the system

Looks up to: Item__c
Lookup
Line_Number__c Line Number Pre-Spring 2018 Number(5,0)
Line_Type__c Line Type Pre-Spring 2018 Formula:
$RecordType.Name
Text
Open_Value__c Open Value Pre-Spring 2018 The sum of the amounts of the units that are pending to be shipped for this sales order line item. This amount is considering the price with options and the rebate discount.

Formula:
IF( ISPICKVAL( Status__c , 'Cancelled') ,0 , ( Quantity__c - Quantity_Shipped__c ) * Price_With_Options__c ) - Customer_Rebate_Discount__c
Currency(18,2)
Option_Cost_Per_Unit__c Option Cost Per Unit Pre-Spring 2018 Currency(18,9) 0
Option_Price_Per_Unit__c Option Price Per Unit Pre-Spring 2018 Currency(18,9) 0
Original_Customer_Rebate_Discount__c Original Customer Rebate Discount Pre-Spring 2018 Currency(18,2) 0
Original_Sales_Order_Line_Item__c Original Sales Order Line Item Pre-Spring 2018 Lookup to the original sales order line from which the line was split.

Looks up to: Sales_Order_Line_Item__c
Lookup
Override_Avalara_Tax_Code__c Override Avalara Tax Code Winter 2023 Avalara tax code used for the line item. When defined, the value is used to calculate tax for the line in AvaTax. When this is not defined, the tax code is determined from AvaTax code to product group mappings.

Text(20)
Price_With_Options__c Price With Options Pre-Spring 2018 Formula:
Price__c + Option_Price_Per_Unit__c
Currency(18,9)
Price__c Price Pre-Spring 2018 Selling Price for one UOM

Currency(18,9) 0
Purchase_Order_Line_Item__c Purchase Order Line Item Pre-Spring 2018 Looks up to: Purchase_Order_Line_Item__c
Lookup
Quantity_Allocated__c Quantity Allocated Pre-Spring 2018 The number of units allocated to this sales order line item. This field is automatically set by a background process.

Number(18,4) 0
Quantity_Backordered__c Quantity Backordered Pre-Spring 2018 The number of units that are backordered for this sales order line item. This field is automatically populated by a background process.

Number(18,4) 0
Quantity_Billed__c Quantity Billed Pre-Spring 2018 The number of units that have already been billed for this sales order line item. Normally this is a whole number but when billing against a fixed amount in sections this can be a decimal number.

Number(18,4) 0
Quantity_Packed__c Quantity Packed Pre-Spring 2018 The quantity of serial numbers that have been packed per item with inbound/outbound serial number control in this sales order line item. This field is automatically populated by a background process.

Number(18,4) 0
Quantity_Shipped__c Quantity Shipped Pre-Spring 2018 The number of units that have already been shipped for this sales order line item. This field is automatically populated by a background process.

Number(18,4) 0
Quantity__c Quantity Pre-Spring 2018 The total number of units to include in this sales order line item.

Number(18,4)
Quantity_to_Bill__c Quantity to Bill Pre-Spring 2018 The number of units to bill on the invoice you are reviewing.

Number(18,4) 0
Remaining_Quantity_To_Bill__c Remaining Quantity to Bill Fall 2020 The number of units that have not been billed for this sales order line item yet. This field is automatically populated by a background process.

Formula:
Quantity__c - Quantity_Billed__c
Number(18,4)
Sales_Order__c Sales Order Pre-Spring 2018 A Sales Order may have multiple line items. Line items facilitate delivery to customer sites, multiple items or services on one Sales order and the required information for pricing and delivery of goods or services.

Looks up to: Sales_Order__c
MasterDetail
Selected_Option_Count__c Selected Option Count Pre-Spring 2018 Number(18,0) 0
Serial_Numbers__c Serial Numbers Pre-Spring 2018 Used only if serial numbers are entered in bulk

LongTextArea(32768)
Service_Being_Delivered__c Service Being Delivered Pre-Spring 2018 LongTextArea(32000)
Service_Contract_Line__c Service Contract Line Pre-Spring 2018 Looks up to: Service_Order_Line__c
Lookup
Status__c Status Pre-Spring 2018 The status of the Sales Order line item. This is automatically populated by the system as parts are allocated and shipped.

Picklist:
Allocated
Backordered
Cancelled
Completed
New
Partially Allocated
Partially Shipped
Pending Allocate
Revised
Shipped
Supplier_Formula__c Supplier Pre-Spring 2018 Customer Quotation Line Supplier

Formula:
if(Supplier_Site__c != null, Supplier_Site__r.Name, If(Customer_Quotation_Line__c !=null & Customer_Quotation_Line__r.Supplier_Site__c != null, Customer_Quotation_Line__r.Supplier_Site__r.Name,''))
Text
Supplier_Site__c Supplier Site Pre-Spring 2018 Looks up to: Supplier_Site__c
Lookup
Tax_Code__c Tax Code Pre-Spring 2018 Looks up to: Tax_Code__c
Lookup
Tax_Name_1__c Tax Name 1 Winter 2023 Name of the tax that applies to this sales order line item. You can use up to three fields to represent the state, county, and city tax authorities.

Text(100)
Tax_Name_2__c Tax Name 2 Winter 2023 Name of the tax that applies to this sales order line item. You can use up to three fields to represent the state, county, and city tax authorities.

Text(100)
Tax_Name_3__c Tax Name 3 Winter 2023 Name of the tax that applies to this sales order line item. You can use up to three fields to represent the state, county, and city tax authorities.

Text(100)
Tax_Rate_1__c Tax Rate 1 Winter 2023 Tax rate to use when calculating tax for this sales order line item.

Percent(7,4)
Tax_Rate_2__c Tax Rate 2 Winter 2023 Tax rate to use when calculating tax for this sales order line item.

Percent(7,4)
Tax_Rate_3__c Tax Rate 3 Winter 2023 Tax rate to use when calculating tax for this sales order line item.

Percent(7,4)
Tax_Rate__c Tax Rate Winter 2023 Total tax rate to use when calculating tax for this sales order line item.

Percent(7,4)
Tax_Value_1__c Tax Value 1 Winter 2023 Tax value calculated from the corresponding tax rate item.

Currency(9,2)
Tax_Value_2__c Tax Value 2 Winter 2023 Tax value calculated from the corresponding tax rate item.

Currency(9,2)
Tax_Value_3__c Tax Value 3 Winter 2023 Tax value calculated from the corresponding tax rate item.

Currency(9,2)
Tax__c Tax Winter 2023 Total tax for the sales order line item.

Currency(9,2)
Taxable__c Taxable Pre-Spring 2018 Check if this Line Item requires tax to be calculated and collected

Checkbox true
Total_Cost__c Total Cost Fall 2021 Total cost of the sales order line item. This is the sum of the values in the External Cost field of all picklist details associated with the sales order line item.

Currency(18,9) 0
Unit_Cost__c Unit Cost Pre-Spring 2018 Formula:
Purchase_Order_Line_Item__r.Unit_Cost_With_Options__c
Currency(18,9)
Unit_of_Measure__c Unit of Measure Pre-Spring 2018 Formula:
Item_Master__r.Stocking_UOM__r.Name
Text
Warranty_Claim__c Warranty Claim Pre-Spring 2018 To be used as a reference on Warranty Claim replacement Items

Looks up to: Return_Material_Authorization__c
Lookup


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