Order and Inventory Management Data Dictionary

SCMC__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 VersionDescriptionTypeRequiredDefault Value
SCMC__AP_Voucher_Line__c AP Voucher Line Pre-Spring 2018 Looks up to: SCMC__AP_Voucher_Line__c
Lookup false
SCMC__Advance_Core_Receipt__c Advance Core Receipt? Pre-Spring 2018 The core must be received before the new part is shipped out.

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

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

Currency(18,2) false 0
SCMC__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) false
SCMC__Based_on_Customer_Price_List__c Based on Customer Price List Pre-Spring 2018 Is there a published customer price list

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

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

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

Date false Today() + 30
SCMC__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: SCMC__Warehouse__c
Lookup false
SCMC__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) false
SCMC__Cost_With_Options__c Cost With Options Pre-Spring 2018 Formula:
SCMC__Item_Cost__c + SCMC__Option_Cost_Per_Unit__c
Currency(18,9) false
SCMC__Customer_Commitment_Date__c Commitment Date Pre-Spring 2018 Date false
SCMC__Customer_Current_Promise_Date__c Current Promise Date Pre-Spring 2018 Date false
SCMC__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: SCMC__Customer_Quotation_Line__c
Lookup false
SCMC__Customer_Rebate_Discount__c Customer Rebate Discount Pre-Spring 2018 Applied Rebate Amount deducted from the Customer Price

Currency(18,2) false 0
SCMC__Customer_Requested_Date__c Requested Delivery Date Pre-Spring 2018 Date false
SCMC__Delivery_Method__c Delivery Method Pre-Spring 2018 Picklist:
ASP Delivery
Electronic Delivery
Load and Leave
Physical Delivery
SCMC__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) false
SCMC__Ext_Price_After_Rebate_Discounts__c Ext. Price After Rebate Discounts Pre-Spring 2018 Extended price the customer pays after rebates.

Formula:
SCMC__Extended_Price__c - SCMC__Customer_Rebate_Discount__c
Currency(18,2) false
SCMC__Extended_Item_Cost__c Ext. Item Cost Pre-Spring 2018 Formula:
SCMC__Cost_With_Options__c * SCMC__Quantity__c
Currency(18,2) false
SCMC__Extended_Price__c Ext. Price Pre-Spring 2018 Extended Price for Sales Order Line Item

Formula:
SCMC__Price_With_Options__c * SCMC__Quantity__c
Currency(18,2) false
SCMC__Intangible__c Intangible? Pre-Spring 2018 Formula:
IF(SCMC__Item_Master__c != null && SCMC__Item_Master__r.SCMC__Intangible__c, $Label.Yes, $Label.No)
Text false
SCMC__Item_Cost__c Item Cost Pre-Spring 2018 What we are paying a supplier for this item

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

Looks up to: SCMC__Item__c
Lookup false
SCMC__Line_Number__c Line Number Pre-Spring 2018 Number(5,0) false
SCMC__Line_Type__c Line Type Pre-Spring 2018 Formula:
$RecordType.Name
Text false
SCMC__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( SCMC__Status__c , 'Cancelled') ,0 , ( SCMC__Quantity__c - SCMC__Quantity_Shipped__c ) * SCMC__Price_With_Options__c ) - SCMC__Customer_Rebate_Discount__c
Currency(18,2) false
SCMC__Option_Cost_Per_Unit__c Option Cost Per Unit Pre-Spring 2018 Currency(18,9) false 0
SCMC__Option_Price_Per_Unit__c Option Price Per Unit Pre-Spring 2018 Currency(18,9) false 0
SCMC__Original_Customer_Rebate_Discount__c Original Customer Rebate Discount Pre-Spring 2018 Currency(18,2) false 0
SCMC__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: SCMC__Sales_Order_Line_Item__c
Lookup false
SCMC__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) false
SCMC__Price_With_Options__c Price With Options Pre-Spring 2018 Formula:
SCMC__Price__c + SCMC__Option_Price_Per_Unit__c
Currency(18,9) false
SCMC__Price__c Price Pre-Spring 2018 Selling Price for one UOM

Currency(18,9) true 0
SCMC__Purchase_Order_Line_Item__c Purchase Order Line Item Pre-Spring 2018 Looks up to: SCMC__Purchase_Order_Line_Item__c
Lookup false
SCMC__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) false 0
SCMC__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) false 0
SCMC__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) false 0
SCMC__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) false 0
SCMC__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) false 0
SCMC__Quantity__c Quantity Pre-Spring 2018 The total number of units to include in this sales order line item.

Number(18,4) true
SCMC__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) false 0
SCMC__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:
SCMC__Quantity__c - SCMC__Quantity_Billed__c
Number(18,4) false
SCMC__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: SCMC__Sales_Order__c
MasterDetail
SCMC__Selected_Option_Count__c Selected Option Count Pre-Spring 2018 Number(18,0) false 0
SCMC__Serial_Numbers__c Serial Numbers Pre-Spring 2018 Used only if serial numbers are entered in bulk

LongTextArea(32768)
SCMC__Service_Being_Delivered__c Service Being Delivered Pre-Spring 2018 LongTextArea(32000)
SCMC__Service_Contract_Line__c Service Contract Line Pre-Spring 2018 Looks up to: SCMC__Service_Order_Line__c
Lookup false
SCMC__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
SCMC__Supplier_Formula__c Supplier Pre-Spring 2018 Customer Quotation Line Supplier

Formula:
if(SCMC__Supplier_Site__c != null, SCMC__Supplier_Site__r.Name, If(SCMC__Customer_Quotation_Line__c !=null & SCMC__Customer_Quotation_Line__r.SCMC__Supplier_Site__c != null, SCMC__Customer_Quotation_Line__r.SCMC__Supplier_Site__r.Name,''))
Text false
SCMC__Supplier_Site__c Supplier Site Pre-Spring 2018 Looks up to: SCMC__Supplier_Site__c
Lookup false
SCMC__Tax_Code__c Tax Code Pre-Spring 2018 Looks up to: SCMC__Tax_Code__c
Lookup false
SCMC__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) false
SCMC__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) false
SCMC__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) false
SCMC__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) false
SCMC__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) false
SCMC__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) false
SCMC__Tax_Rate__c Tax Rate Winter 2023 Total tax rate to use when calculating tax for this sales order line item.

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

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

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

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

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

Checkbox true
SCMC__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) false 0
SCMC__Unit_Cost__c Unit Cost Pre-Spring 2018 Formula:
SCMC__Purchase_Order_Line_Item__r.SCMC__Unit_Cost_With_Options__c
Currency(18,9) false
SCMC__Unit_of_Measure__c Unit of Measure Pre-Spring 2018 Formula:
SCMC__Item_Master__r.SCMC__Stocking_UOM__r.Name
Text false
SCMC__Warranty_Claim__c Warranty Claim Pre-Spring 2018 To be used as a reference on Warranty Claim replacement Items

Looks up to: SCMC__Return_Material_Authorization__c
Lookup false


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