SCMC Data Dictionary

AP_Voucher_Line_Credit__c

Label: AP Voucher Line Credit

Line credits associated with an AP Voucher

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
AP_Voucher_Credit__c AP Voucher Credit Pre-Spring 2018 Looks up to: AP_Voucher_Credit__c
MasterDetail
AP_Voucher_Line__c AP Voucher Line Pre-Spring 2018 Looks up to: AP_Voucher_Line__c
Lookup
Accounting_Item__c Accounting Item Pre-Spring 2018 Item for accounting added AP Voucher Credit lines

Looks up to: Item__c
Lookup
Amount__c Amount Pre-Spring 2018 Number(12,2) 0
Description__c Description Pre-Spring 2018 Formula:
Purchase_Order_Line_Item__r.Item_Master__r.Item_Description__c
Text
Extended_Price__c Extended Price Pre-Spring 2018 Formula:
Quantity__c * Unit_Price__c
Currency(18,2)
Extended_Purchase_Price_Variance__c Extended Purchase Price Variance Pre-Spring 2018 Formula:
Unit_Purchase_Price_Variance__c * Quantity__c
Number(18,2)
Item__c Item Pre-Spring 2018 Formula:
Purchase_Order_Line_Item__r.Item_Master__r.Name
Text
Line_Number__c Line Number Pre-Spring 2018 Text(4)
Line_Type__c Line Type Pre-Spring 2018 Formula:
$RecordType.DeveloperName
Text
Non_Receivable__c Non-Receivable Pre-Spring 2018 Item on invoice that is not receivable or not on the PO

TextArea
Purchase_Order_Line_Item__c Purchase Order Line Item Pre-Spring 2018 Looks up to: Purchase_Order_Line_Item__c
Lookup
Quantity_Ordered__c Quantity Ordered Pre-Spring 2018 Formula:
if( Purchase_Order_Line_Item__c !=null, Purchase_Order_Line_Item__r.Quantity__c, 0)
Number(18,4)
Quantity_Received__c Quantity Received Pre-Spring 2018 Formula:
if( Purchase_Order_Line_Item__c != null, Purchase_Order_Line_Item__r.Quantity_Received__c, 0)
Number(18,4)
Quantity__c Quantity Vouchered Pre-Spring 2018 Number(18,4)
Sales_Order__c Sales Order Pre-Spring 2018 Formula:
HYPERLINK('/' +Purchase_Order_Line_Item__r.Sales_Order_Line_Item__r.Sales_Order__c , Purchase_Order_Line_Item__r.Sales_Order_Line_Item__r.Sales_Order__r.Name)
Text
Serial_Numbers__c Serial Numbers Pre-Spring 2018 A group of serial numbers. This is used where the customer does wants to drop a large number of serial numbers at once.

LongTextArea(32768)
Tax_Rate__c Tax Rate Pre-Spring 2018 Percent(7,4)
Tax__c Tax Pre-Spring 2018 Currency(9,2)
Unit_Price__c Unit Price Pre-Spring 2018 Number(18,9)
Unit_Purchase_Price_Variance__c Unit Purchase Price Variance Pre-Spring 2018 This is calculated by the vouchering process during the matching process.

Number(18,9) 0


© Copyright 2009–2020 FinancialForce.com, inc. All rights reserved. Various trademarks held by their respective owners.