Order and Inventory Management 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
Editable_Name__c Editable AP Voucher Line Credit 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 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_Name_1__c Tax Name 1 Winter 2023 Name of the tax that applies to this AP voucher line credit. You can use up to three 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 that applies to this AP voucher line credit. You can use up to three 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 that applies to this AP voucher line credit. You can use up to three 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 credit.

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

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

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 Purchase Price Variance Pre-Spring 2018 This is calculated by the vouchering process during the matching process.

Number(18,9) 0


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