Order and Inventory Management Data Dictionary

Purchase_Contract_Line__c

Label: Purchase Agreement Line

Stores detailed information about the goods or services to be purchased. A purchase agreement can have multiple purchase agreement lines. A purchase agreement line can be associated with a single, or multiple purchase orders.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Amount_Matched__c Amount Matched Spring 2020 The sum of the matched amounts on the purchase order lines associated with the purchase agreement line.

Currency(18,9) 0
Amount_On_Order__c Amount on Order Spring 2020 The sum of the values in the Total Cost field of purchase order line items associated with the purchase agreement line.

Currency(18,9) 0
Amount_Received__c Amount Received Spring 2020 The sum of the received amounts on the purchase order lines associated with this purchase agreement line.

Currency(18,9) 0
Buyer__c Buyer Spring 2020 The user who is responsible for the purchase agreement line. If you leave this field blank, the buyer specified on the purchase agreement will be used.

Looks up to: User

Lookup
Condition_Code__c Condition Spring 2020 The condition code of the goods or services being purchased.

Looks up to: Condition_Code__c
Lookup
Days_Until_Expiration__c Days until Expiration Spring 2020 The number of days left before the purchase agreement line expires.

Formula:
End_Date__c - TODAY()
Number(18,2)
Description__c Description Spring 2020 TextArea
End_Date__c End Date Spring 2020 The date on which the purchase agreement line stops being effective. You must enter an end date that is before or on the purchase agreement end date. If you leave this field blank, the end date specified on the purchase agreement will be used.

Date
Item_Master__c Item Being Procured Spring 2020 Looks up to: Item__c
Lookup
Line_Type__c Line Type Spring 2020 The record type of the purchase agreement line.

Formula:
$RecordType.DeveloperName
Text
Maximum_Amount_To_Order__c Maximum Amount to Order Spring 2020 The maximum spend you can order for the purchase agreement line. You must enter a quantity that is equal to or less than the quantity specified in the Maximum Amount to Order field of the purchase agreement.

Currency(18,9)
Maximum_Quantity_To_Order__c Maximum Quantity to Order Spring 2020 The maximum number of units you can order for the purchase agreement line. You must enter a quantity that is equal to or less than the quantity specified in the Maximum Quantity to Order field of the purchase agreement.

Number(18,4)
Original_Contract_Line__c Original Agreement Line Spring 2022 The original purchase agreement line to which the change request line relates.

Looks up to: Purchase_Contract_Line__c
Lookup
Percentage_Of_Amount_Matched__c Percentage of Amount Matched Spring 2020 The percentage of the maximum amount to order that has been matched in AP voucher lines for the purchase agreement line.

Formula:
IF(ISBLANK(Maximum_Amount_To_Order__c),NULL,(Amount_Matched__c/Maximum_Amount_To_Order__c))
Percent(18,2)
Percentage_Of_Quantity_Matched__c Percentage of Quantity Matched Spring 2020 The percentage of the maximum quantity to order that has been matched in AP voucher lines for the purchase agreement line.

Formula:
IF(ISBLANK(Maximum_Quantity_To_Order__c),NULL,(Quantity_Matched__c/Maximum_Quantity_To_Order__c))
Percent(18,2)
Previous_Contract_Line__c Previous Agreement Line Spring 2022 The previous change request agreement line.

Looks up to: Purchase_Contract_Line__c
Lookup
Product_Group__c Category Summer 2022 The category of the goods or services for which the purchase agreement line is created. The category corresponds to a product group that has been set as a category. This field is used for purchase agreement lines of type Category.

Looks up to: Product_Group__c
Lookup
Purchase_Contract__c Purchase Agreement Spring 2020 The purchase agreement this line item is related to. All purchase agreement line items must have a purchase agreement.

Looks up to: Purchase_Contract__c
MasterDetail
Quantity_Matched__c Quantity Matched Spring 2020 The sum of the matched quantities on the purchase order lines associated with the purchase agreement line.

Number(18,4) 0
Quantity_On_Order__c Quantity on Order Spring 2020 The sum of the values in the Quantity field of purchase order line items associated with the purchase agreement line.

Number(18,4) 0
Quantity_Received__c Quantity Received Spring 2020 The sum of the received quantities on the purchase order lines associated with this purchase agreement line.

Number(18,4) 0
Quantity__c Quantity Winter 2023 The number of units of goods or services to include in the purchase agreement line. When managing subscriptions, the value in this field can be used to indicate the quantities to include in the purchase order line items of the recurring purchase orders created from a purchase agreement.

Number(18,4)
Remaining_Amount_to_Order__c Remaining Amount to Order Summer 2022 The remaining amount that you can order for the purchase agreement line. This field only populates when you define a maximum sum to spend for the purchase agreement line in the Maximum Amount to Order field.

Formula:
IF( Maximum_Amount_To_Order__c > 0, Maximum_Amount_To_Order__c - Amount_On_Order__c, null)
Currency(18,9)
Remaining_Quantity_to_Order__c Remaining Quantity to Order Summer 2022 The remaining number of units that you can order for the purchase agreement line. This field only populates when you define a maximum quantity for the purchase agreement line in the Maximum Quantity to Order field.

Formula:
IF( Maximum_Quantity_To_Order__c > 0, Maximum_Quantity_To_Order__c - Quantity_On_Order__c , null)
Number(18,4)
Requisition_Line__c Requisition Line Summer 2022 The requisition line to which the purchase agreement line relates.

Looks up to: Requisition_Line_Item__c
Lookup
Ship_To_Warehouse__c Ship to Warehouse Spring 2020 The warehouse used for the goods or services that are being purchased. If this field is left blank, the warehouse specified on the purchase agreement will be used.

Looks up to: Warehouse__c
Lookup
Start_Date__c Start Date Spring 2020 The date from which the purchase agreement line is effective. The start date must be equal to or later than the purchase agreement start date. If this field is left blank, the start date specified on the purchase agreement will be used.

Date
Status__c Status Spring 2020 Picklist:
Active
Canceled
Complete
Draft
Expired
Superseded
Supplier_Contact__c Supplier Contact Spring 2020 The supplier for the purchase agreement line. If you leave this field blank, the supplier contact specified on the purchase agreement will be used.

Looks up to: Supplier_Contact__c
Lookup
Unit_Cost__c Unit Cost Spring 2020 The unit cost of the goods or services that you are purchasing.

Currency(18,9) 0


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