| 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 |
|
