Order and Inventory Management Data Dictionary

Purchase_Contract__c

Label: Purchase Agreement

Stores the details of an agreement between a vendor and an organization. It lists the goods and/or services that will be provided in exchange for payment, and any provisions and conditions associated with the services the vendor provides.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Amount_Matched__c Amount Matched Spring 2020 The sum of the amounts on purchase agreement lines that have been matched.

Currency(18,9) 0
Amount_On_Order__c Amount on Order Spring 2020 The sum of the values in the Amount on Order field of all purchase agreement lines.

Currency(18,9) 0
Amount_Received__c Amount Received Spring 2020 The sum of the amounts on purchase agreement lines that have been received.

Currency(18,9) 0
Buyer__c Buyer Spring 2020 Looks up to: User

Lookup
Currency_Master__c Currency Spring 2020 The currency that relates to the purchase agreement. This defaults from the related supplier site but can be modified.

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

Formula:
End_Date__c - TODAY()
Number(18,2)
Effective_Cancel_Date__c Effective Date of Cancellation Summer 2023 The date on which the purchase agreement is canceled.

Date
End_Date__c End Date Spring 2020 The date on which the agreement ends.

Date
End_of_Contract_Notes__c End of Agreement Notes Summer 2023 The notes regarding the cancellation of the purchase agreement.

LongTextArea(256)
Maximum_Amount_To_Order__c Maximum Amount to Order Spring 2020 The maximum spend you can order for the purchase agreement. If you want this purchase agreement to have an unlimited amount, leave this field blank.

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. If you want this purchase agreement to have an unlimited quantity, leave this field blank.

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

Looks up to: Purchase_Contract__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.

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.

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

Looks up to: Purchase_Contract__c
Lookup
Quantity_Matched__c Quantity Matched Spring 2020 The sum of the quantities on purchase agreement lines that have been matched.

Number(18,4) 0
Quantity_On_Order__c Quantity on Order Spring 2020 The sum of the values in the Quantity on Order field of all purchase agreement lines.

Number(18,4) 0
Quantity_Received__c Quantity Received Spring 2020 The sum of the quantities on purchase agreement lines that have been received.

Number(18,4) 0
Reason_for_Cancelling_Contract__c Reason for Agreement Cancellation Summer 2023 The reason to cancel the purchase agreement.

Picklist:
Terminated
Remaining_Amount_on_Order__c Remaining Amount to Order Summer 2022 The remaining amount that you can order on the purchase agreement. This field only populates when you define a maximum sum to spend on 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_On_Order__c Remaining Quantity to Order Summer 2022 The remaining number of units that you can order on the purchase agreement. This field only populates when you define a maximum quantity on 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)
Renewal_Reminder__c Renewal Reminder Winter 2023 The date on which to report that the purchase agreement is due for renewal.

Date
Ship_To_Warehouse__c Ship to Warehouse Spring 2020 Looks up to: Warehouse__c
Lookup
Start_Date__c Start Date Spring 2020 The date from which the purchase agreement is effective.

Date
Status__c Status Spring 2020 The current purchase agreement status.

Picklist:
Active
Approved
Canceled
Complete
Draft
Expired
Submitted for Approval
Superseded
Supplier_Contact__c Supplier Contact Spring 2020 Looks up to: Supplier_Contact__c
Lookup
Supplier_Site__c Supplier Site Spring 2020 Looks up to: Supplier_Site__c
Lookup


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