Order and Inventory Management Data Dictionary

Serial_Number__c

Label: Serial Number

Serial numbers that are added at invoicing time

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
AP_Voucher_Line__c AP Voucher Line Pre-Spring 2018 Looks up to: AP_Voucher_Line__c
Lookup
Credit_Invoice_Line__c Credit Invoice Line Spring 2020 Looks up to: Credit_Invoice_Line__c
Lookup
Customer_Return_Line__c Customer Return Line Spring 2020 Looks up to: Customer_Return_Line__c
Lookup
Customer__c Customer Pre-Spring 2018 Formula:
Sales_Order_Line_Item__r.Sales_Order__r.Customer_Account__r.Name
Text
InInventory__c In Inventory Pre-Spring 2018 When checked, the serial number is currently in stock.

Checkbox true
Invoice_Line_Item__c Invoice Line Item Pre-Spring 2018 Looks up to: Invoice_Line_Item__c
Lookup
Is_Fixed_Asset_Created__c Is Fixed Asset Created Spring 2019 Checked when a fixed asset record has been created in FAM associated with this serial number.

Checkbox false
Item_Description__c Item Description Pre-Spring 2018 Formula:
Item__r.Item_Description__c
Text
Item__c Item Pre-Spring 2018 Looks up to: Item__c
Lookup
Last_Transfer_Request_Line__c Last Transfer Request Line Pre-Spring 2018 Looks up to: Transfer_Request_Line__c
Lookup
On_Hold__c On Hold Pre-Spring 2018 Serial number has been placed on and not allowed to shipped out.

Checkbox false
Original_Serial_Number_Record__c Original Serial Number Record Pre-Spring 2018 Looks up to: Serial_Number__c
Lookup
Ownership_Code__c Ownership Code Pre-Spring 2018 Looks up to: Ownership_Code__c
Lookup
Production_Order_Line__c Production Order Line Pre-Spring 2018 Looks up to: Production_Order_Line__c
Lookup
Production_Order__c Production Order Pre-Spring 2018 Looks up to: Production_Order__c
Lookup
Purchase_Order_Line_Item__c Purchase Order Line Item Pre-Spring 2018 Looks up to: Purchase_Order_Line_Item__c
Lookup
Reason_Code__c Reason Code Pre-Spring 2018 Looks up to: Reason_Code__c
Lookup
Rebate_Claim__c Rebate Claim Pre-Spring 2018 Lookup to the rebate claim associated with the serial number.

Looks up to: Rebate_Claim__c
Lookup
Receipt_Line__c Receipt Line Pre-Spring 2018 Looks up to: Receipt_Line__c
Lookup
Received_Date__c Received Date Pre-Spring 2018 Formula:
Receipt_Line__r.CreatedDate
Date
Receiving_Inspection__c Receiving Inspection Pre-Spring 2018 Looks up to: Receiving_Inspection__c
Lookup
Rejected__c Rejected Pre-Spring 2018 Checkbox false
Return_Material_Authorization__c Return Material Authorization Pre-Spring 2018 Looks up to: Return_Material_Authorization__c
Lookup
Sales_Order_Line_Item__c Sales Order Line Item Pre-Spring 2018 Looks up to: Sales_Order_Line_Item__c
Lookup
Serial_Number__c Serial Number Pre-Spring 2018 Text(100)
Service_Contract_Line__c Service Contract Line Pre-Spring 2018 Looks up to: Service_Order_Line__c
Lookup
Service_Purchase_Order_Line_Item__c Service Purchase Order Line Item Pre-Spring 2018 Looks up to: Purchase_Order_Line_Item__c
Lookup
Shelf_Life_Expiration__c Shelf Life Expiration Pre-Spring 2018 Shelf life is the time that item can be stored, during which the defined quality of a specified proportion of the item remains acceptable under expected (or specified) conditions of distribution and storage.

DateTime
Shipment_Date__c Shipment Date Pre-Spring 2018 Formula:
Sales_Order_Line_Item__r.Sales_Order__r.Fulfillment_Date__c
Date
Shipping__c Shipping Pre-Spring 2018 Looks up to: Shipping__c
Lookup
Supplier__c Supplier Pre-Spring 2018 Formula:
Purchase_Order_Line_Item__r.Purchase_Order__r.Supplier_Site__r.Name
Text
Transfer_Request_Line__c Transfer Request Line Pre-Spring 2018 Looks up to: Transfer_Request_Line__c
Lookup
Type_Of_Serial_Number__c Type Of Serial Number Pre-Spring 2018 Picklist:
Inbound/Outbound
Inventory Position
Warehouse__c Warehouse Pre-Spring 2018 Looks up to: Warehouse__c
Lookup


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