Order and Inventory Management Data Dictionary

Customer_Return_Line__c

Label: Customer Return Line

The customer return line describes the items that are the subject of the customer return. Each line is associated with a sales order line and displays details of the item master, the return action for the item master, shipping data and credit, fees and warranty information.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Actual_Quantity_Returned__c Actual Quantity Returned Fall 2018 Total quantity received.

Number(18,4) 0
Actual_Value_of_Credit_Before_Fees__c Actual Value of Credit Before Fees Fall 2018 Actual value of credit for items that have a return action of Customer Credit. Calculated from the item quantities multiplied by the customer return unit prices.

Formula:
IF( ISPICKVAL( Return_Action__c , 'Customer Credit') , Actual_Quantity_Returned__c * Unit_Price__c , 0)
Currency(18,9)
Actual_Value_of_Credit_Minus_Fees__c Actual Value of Credit Minus Fees Fall 2018 Actual value of credit for items that have a return action of Customer Credit minus restocking fees minus other fees.

Formula:
IF( AND(ISPICKVAL( Return_Action__c , 'Customer Credit'), Actual_Quantity_Returned__c > 0) , ( Actual_Quantity_Returned__c * Unit_Price__c ) - Restocking__c - Other__c , 0)
Currency(18,9)
Actual_Value_of_Return_Items__c Actual Value of Return Items Fall 2019 Actual Quantity Returned x Unit Price

Formula:
Actual_Quantity_Returned__c * Unit_Price__c
Currency(18,9)
Already_Returned_Quantity__c Already Returned Spring 2019 The current quantity that has already been returned by the customer.

Formula:
Sales_Order_Line__r.Already_Returned__c
Number(18,4)
Already_Returned__c DEPRECATED: Already Returned Fall 2018 Deprecated field. The current quantity that has already returned by the customer.

Number(18,4) 0
Customer_Credit_Minus_NC_Items_and_Fees__c Customer Credit Minus NC Items and Fees Fall 2018 Actual value of the returned items minus the total return fees, minus the total value of Non Conforming (NC) items. Only customer return lines with a return action of Customer Credit will be included.

Formula:
IF( AND(ISPICKVAL( Return_Action__c , 'Customer Credit'), Actual_Quantity_Returned__c > 0) , ( ( Actual_Quantity_Returned__c - Quantity_of_Non_Conforming_Items__c ) * Unit_Price__c ) - Restocking__c - Other__c , 0)
Currency(18,9)
Customer_Return__c Customer Return Fall 2018 Looks up to: Customer_Return__c
MasterDetail
Customer_Warranty_Claim_Date__c Customer Warranty Claim Date Fall 2018 The date the customer submitted the warranty claim for a replacement or credit.

Date
Customer_Warranty_Claim_Granted__c Customer Warranty Claim Granted Fall 2018 Picklist:
No
Yes
Customer_Warranty_Claim_Resolution_Date__c Customer Warranty Claim Resolution Date Fall 2018 The date the customer warranty claim for a replacement or credit was resolved.

Date
Date_Returned__c Date Returned Fall 2018 Date on which the last of the returned items were received into the return warehouse.

Date
Expected_Extended_Price__c Expected Extended Price Fall 2018 The customer return unit price multiplied by the expected return quantity.

Formula:
To_Return__c * Unit_Price__c
Currency(18,9)
Expected_Value_of_Credit_Minus_Fees__c Expected Value of Credit Minus Fees Fall 2018 The expected value of the returned items minus the total return fees. Only customer return lines with a return action of Customer Credit will be rolled up. Customer return lines that are customer exchanges or repairs are not rolled up.

Formula:
IF( AND(ISPICKVAL( Return_Action__c , 'Customer Credit'), To_Return__c > 0) , ( To_Return__c * Unit_Price__c ) - Restocking__c - Other__c , 0)
Currency(18,9)
Inspected_Quantity_Accepted__c Inspected Quantity Accepted Fall 2019 The current quantity of items that have been accepted during inspection.

Number(18,4) 0
Inspection__c Inspection Fall 2018 Inspection options for the customer return. Defaults from the header. Line values can be changed. Editing is enabled by a custom setting.

Picklist:
Inspection Required
No Inspection Required
No Inspection Required - Customer Scrapping
Unused/Closed Box
Item_Description__c Item Description Fall 2018 Formula:
Sales_Order_Line__r.Item_Description__c
Text
Item_Master__c Item Master Fall 2018 The Item Master this return line refers to.

Looks up to: Item__c
Lookup
Item_Past_Returns_Date__c Item Past Returns Date Fall 2018 Based on your company returns policy, this field indicates if the item has passed the last return date.

Checkbox true
Item_Shipped_Cost__c Item Cost When Shipped Fall 2019 The supplier cost of the item when it was shipped to the customer.

Currency(18,9) 0
Lot_Numbers_Shipped__c Lot Numbers Shipped Fall 2018 LongTextArea(32768)
Lot_Numbers_to_Return__c Lot Numbers to Return Fall 2018 LongTextArea(32768)
Other__c Other Fall 2018 Currency(18,9) 0
Quantity_Shipped__c Quantity Shipped Fall 2018 The quantity shipped on the associated sales order.

Formula:
Sales_Order_Line__r.Quantity_Shipped__c
Number(18,4)
Quantity_of_Non_Conforming_Items__c Quantity of Non Conforming Items Fall 2018 The total quantity of non conforming items at inspection.

Number(18,4) 0
Reason_for_Return__c Reason for Return Fall 2018 Reason for the customer return. The reason selected at header level will be the default for the customer return lines, but each line value can be changed individually.

Picklist:
Item faulty
Item not as expected
Item not required
Restocking_And_Other_Fees_Sum__c Restocking And Other Fees Sum Fall 2018 Formula:
Restocking__c + Other__c
Currency(18,9)
Restocking__c Restocking Fall 2018 A fee charged to the customer for accepting a return, either as a flat fee or percentage.

Currency(18,9) 0
Return_Action__c Return Action Fall 2018 The customers preferred action. The action selected at the header will be the default for the customer return lines. Each line action can be changed individually.

Picklist:
Customer Credit
Customer Exchange
Repair
Sales_Order_Line__c Sales Order Line Fall 2018 The Sales Order line this return line refers to.

Looks up to: Sales_Order_Line_Item__c
Lookup
Serial_Numbers_Shipped__c Serial Numbers Shipped Fall 2018 LongTextArea(32768)
Serial_Numbers_Status__c Serial Numbers Status Spring 2020 Indicates if all the required serial numbers have been entered on the customer return line, or if more serial numbers are required, or if no serial number required for the customer return item.

Formula:
IF( OR ( Item_Master__r.Serial_Number_Control__c, Item_Master__r.Inbound_Outbound_Serial_Number__c ), IF( OR ( ISNULL(Total_Serial_Numbers__c), Total_Serial_Numbers__c < To_Return__c ), IMAGE('/resource/SCMC__CustomerReturn/images/emptyCircle.png', $Label.SerialNumbersPending, 25, 30), IMAGE('/resource/SCMC__CustomerReturn/images/successCircle.png', $Label.SerialNumbersAllSelected, 25, 30) ), '' )
Text
Serial_Numbers_to_Return__c Serial Numbers to Return Fall 2018 LongTextArea(32768)
Shipping_Date__c Shipping Date Fall 2018 The date the items were shipped to the customer.

Formula:
NOW()
Date
Shipping__c Shipping Fall 2018 Defaults from the header. You can change the value at line level if required.

Picklist:
Customer Arranging Shipping
No Shipping Required - Customer Scrapping
Shipment Arrangement Required
Status__c Status Fall 2018 Status of the customer return line. Updated by the system as the items progress through the customer returns process.

Picklist:
Approved
Inspected
New
Partially Received
Received
Supplier_Warranty_Claim__c Supplier Warranty Claim Fall 2018 Has a warranty claim been filed with the original supplier.

Picklist:
No
Yes
To_Return__c To Return Fall 2018 The quantity expected to be returned by the customer.

Number(18,4)
Total_Serial_Numbers__c Total Serial Numbers Spring 2020 Total number of serial numbers added.

Number(10,0) 0
Unit_Price__c Unit Price Fall 2018 The unit price of the customer return line item. Derived from the sales order.

Currency(18,9)
Value_of_Non_Conforming_Items__c Value of Non Conforming Items Fall 2018 The quantity of non conforming items multiplied by their unit costs.

Formula:
Quantity_of_Non_Conforming_Items__c * Unit_Price__c
Currency(18,9)


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