Order and Inventory Management Data Dictionary

Purchase_Contract__c

Label: Purchase Contract

Provides details a contract 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 contract 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 contract lines.

Currency(18,9) 0
Amount_Received__c Amount Received Spring 2020 The sum of the amounts on purchase contract 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 This defaults from the Supplier Site but can be overriden by the user

Looks up to: Currency_Master__c
Lookup
Days_Until_Expiration__c Days until Expiration Spring 2020 Number of days left before the purchase contract 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 contract is canceled.

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

Date
End_of_Contract_Notes__c End of Contract Notes Summer 2023 Notes regarding the cancellation of a purchase contract.

LongTextArea(256)
Maximum_Amount_To_Order__c Maximum Amount to Order Spring 2020 The maximum spend you can order for this purchase contract. If you want this purchase contract 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 this purchase contract. If you want this purchase contract to have an unlimited quantity, leave this field blank.

Number(18,4)
Original_Purchase_Contract__c Original Purchase Contract Spring 2022 The original purchase contract to which this change request relates.

Looks up to: Purchase_Contract__c
Lookup
Percentage_Of_Amount_Matched__c Percentage of Amount Matched Spring 2020 Percentage of Maximum Amount to Order that has been matched in AP voucher lines for the purchase contract.

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 Percentage of Maximum Quantity to Order that has been matched in AP voucher lines for the purchase contract.

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

Looks up to: Purchase_Contract__c
Lookup
Quantity_Matched__c Quantity Matched Spring 2020 The sum of the quantities on purchase contract 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 contract lines.

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

Number(18,4) 0
Reason_for_Cancelling_Contract__c Reason for Contract Cancellation Summer 2023 The reason to cancel a purchase contract.

Picklist:
Terminated
Remaining_Amount_on_Order__c Remaining Amount to Order Summer 2022 The remaining amount that you can order on the purchase contract. 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 contract. 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 Date on which to report that this purchase contract 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 contract is effective.

Date
Status__c Status Spring 2020 The current purchase contract 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.