SCMC Data Dictionary

AP_Voucher_Line__c

Label: AP Voucher Line

The lines on the incoming invoice.

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

Looks up to: Item__c
Lookup
Capital_Equipment__c Capital Equipment Spring 2019 This field will be populated with the fixed asset numbers related to the AP Voucher Line.

LongTextArea(32768)
Delivery_Method__c Delivery Method Pre-Spring 2018 Designates by what means this will be delivered.

Picklist:
ASP Delivery
Electronic Delivery
Load and Leave
Physical Delivery
Description__c Description Pre-Spring 2018 Formula:
IF ( Purchase_Order_Line_Item__r.RecordType.DeveloperName == 'Capital_Equipment', Purchase_Order_Line_Item__r.Item_Master__r.Name, IF ( !ISBLANK(Purchase_Order_Line_Item__r.Description__c), Purchase_Order_Line_Item__r.Description__c, 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 PPV Pre-Spring 2018 Formula:
Unit_Purchase_Price_Variance__c * Quantity__c
Number(18,2)
Is_Capital_Equipment__c Is Capital Equipment Spring 2019 When selected, FAM records will be created for associated AP Voucher lines.

Checkbox false
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)
Received_Date__c Received Date Pre-Spring 2018 Date Today()
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_Code__c Tax Code Pre-Spring 2018 Text(20)
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 PPV Pre-Spring 2018 This is calculated by the vouchering process during the matching process.

Number(18,9) 0
Use_Code__c Use Code Pre-Spring 2018 For use tax purposes. Determines what the item is to be used for.

Picklist:
A - Federal Government
B - State Government
C - Tribal Government
D - Foreign Diplomat
E - Charitable Organization
F - Religious/Education
G - Resale
H - Agricultural Production
I - Industrial Prod/Mfg.
J - Direct Pay Permit
K - Direct Mail
L - Other
N - Local Government
P - Commercial Aquaculture
Q - Commercial Fishery
R - Non-resident


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