SCMC Data Dictionary

Purchase_Contract_Line__c

Label: Purchase Contract Line

A purchase contract line specifies detailed information about the goods or services to be purchased. A purchase contract can have multiple purchase contract lines. A purchase contract 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 this purchase contract line.

Currency(18,9) 0
Amount_On_Order__c Amount on Order Spring 2020 The sum of the amounts on the purchase order lines associated with this purchase contract 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 contract line.

Currency(18,9) 0
Buyer__c Buyer Spring 2020 If you leave this field blank, the buyer specified on the purchase contract will be used.

Looks up to: User

Lookup
Condition_Code__c Condition Spring 2020 Specify the condition code of the goods or services that you are purchasing.

Looks up to: Condition_Code__c
Lookup
Days_Until_Expiration__c Days until Expiration Spring 2020 Number of days left before the purchase contract 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 contract line stops being effective. You must enter an end date that is before or on the purchase contract end date. If you leave this field blank, the end date specified on the purchase contract 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 this purchase contract line.

Formula:
$RecordType.DeveloperName
Text
Maximum_Amount_To_Order__c Maximum Amount to Order Spring 2020 The maximum spend you can order for this purchase contract 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 contract.

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 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 contract.

Number(18,4)
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 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 Percentage of Maximum Quantity to Order that has been matched in AP voucher lines for the purchase contract line.

Formula:
IF(ISBLANK(Maximum_Quantity_To_Order__c),NULL,(Quantity_Matched__c/Maximum_Quantity_To_Order__c))
Percent(18,2)
Purchase_Contract__c Purchase Contract Spring 2020 The purchase order this line item is related to. All purchase order line items must have a purchase order.

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 this purchase contract line.

Number(18,4) 0
Quantity_On_Order__c Quantity on Order Spring 2020 The sum of the quantities on the purchase order lines associated with this purchase contract 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 contract line.

Number(18,4) 0
Ship_To_Warehouse__c Ship to Warehouse Spring 2020 The warehouse you want to use for the goods or services that you are purchasing. If you leave this field blank, the warehouse specified on the purchase contract will be used.

Looks up to: Warehouse__c
Lookup
Start_Date__c Start Date Spring 2020 The date from which the purchase contract line is effective. You must enter a start date that is on or after the purchase contract start date. If you leave this field blank, the start date specified on the purchase contract will be used.

Date
Status__c Status Spring 2020 Picklist:
Active
Canceled
Complete
Draft
Expired
Supplier_Contact__c Supplier Contact Spring 2020 If you leave this field blank, the supplier contact specified on the purchase contract 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–2020 FinancialForce.com, inc. All rights reserved. Various trademarks held by their respective owners.