Order and Inventory Management 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
Editable_Name__c Editable AP Voucher Line Name Summer 2023 For system use. Used to enable the Foundations Transform service to edit the record.

Text(255)
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(10)
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
Override_Avalara_Tax_Code__c Override Avalara Tax Code Winter 2023 Avalara tax code used for the 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)
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_Name_1__c Tax Name 1 Winter 2023 Name of the tax used when calculating tax for this AP voucher line. You can use up to seven 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 used when calculating tax for this AP voucher line. You can use up to seven 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 used when calculating tax for this AP voucher line. You can use up to seven 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 AP voucher line.

Percent(7,4)
Tax_Rate_2__c Tax Rate 2 Winter 2023 Tax rate to use when calculating tax for this AP voucher line.

Percent(7,4)
Tax_Rate_3__c Tax Rate 3 Winter 2023 Tax rate to use when calculating tax for this AP voucher line.

Percent(7,4)
Tax_Rate__c Tax Rate Pre-Spring 2018 Percent(7,4)
Tax_Value_1__c Tax Value 1 Winter 2023 Tax value calculated from the corresponding tax rate.

Currency(9,2)
Tax_Value_2__c Tax Value 2 Winter 2023 Tax value calculated from the corresponding tax rate.

Currency(9,2)
Tax_Value_3__c Tax Value 3 Winter 2023 Tax value calculated from the corresponding tax rate.

Currency(9,2)
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–2023 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.