Professional Services Automation Data Dictionary

pse__Vendor_Invoice_Item__c

Label: Vendor Invoice Item

The line item for a vendor invoice, calculated from the cost fields on timecards and milestones, and from reimbursement amounts on expenses.

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
pse__Account_Currency__c Account Currency Pre-Spring 2018 Formula:
TEXT(pse__Vendor_Invoice__r.pse__Account__r.CurrencyIsoCode)
Text false
pse__Action_Recalc_Vendor_Currency_Amount__c Action: Recalc Vendor Currency Amount: Pre-Spring 2018 Checkbox false
pse__Amount__c Amount Pre-Spring 2018 The amount for this line item. This field is automatically populated from the respective related record: the Reimbursement Amount field from Expense, the Milestone Cost field from Milestone, the Amount field from Miscellaneous Adjustment, and Total Cost from Timecard Split. NOTE: this field is not automatically updated if the fields on the related record change.

Currency(18,2) true
pse__Budget_Header__c Budget Header Pre-Spring 2018 A reference to the budget header that this item applies to. This field is required.

Looks up to: pse__Budget_Header__c
Lookup false
pse__Date__c Date Pre-Spring 2018 The date of the invoice item. The value is populated by the New Invoice Items page from the respective field on the related record: Expense Date on Expense, Actual Date on Milestone, Effective Date on Misc. Adjustment, End Date on Timecard Split.

Date true Today()
pse__Description__c Description Pre-Spring 2018 TextArea false
pse__Expense__c Expense Pre-Spring 2018 Looks up to: pse__Expense__c
Lookup false
pse__Item_Exchange_Rate_Override__c Item Exchange Rate Override Pre-Spring 2018 Item-level vendor currency exchange rate override. Is applied if and only if the above "Override Item Exchange Rate" checkbox is checked. If not checked then this field value has no effect. Note that this will be set as the relative rate between the Vendor currency and the Project currency.

Number(18,6) false
pse__Milestone__c Milestone Pre-Spring 2018 Looks up to: pse__Milestone__c
Lookup false
pse__Miscellaneous_Adjustment__c Miscellaneous Adjustment Pre-Spring 2018 Looks up to: pse__Miscellaneous_Adjustment__c
Lookup false
pse__Override_Item_Exchange_Rate__c Override Item Exchange Rate Pre-Spring 2018 May only be checked if parent Vendor Invoice has Apply Vendor Exchange Rate Override UN-checked (otherwise the rate would come from the parent Vendor Invoice).

Checkbox false
pse__Project_Currency_Exchange_Rate__c Project Currency Exchange Rate Pre-Spring 2018 This is the system exchange rate for the project currency (relative to the corporate currency) It should be read only the page layout. The field is auto populated by the system.

Number(18,6) false
pse__Project__c Project Pre-Spring 2018 Looks up to: pse__Proj__c
Lookup false
pse__Quantity__c Quantity Pre-Spring 2018 Number(14,2) false
pse__Resource__c Resource Pre-Spring 2018 Resource related to this item. Valid for Time Card Splits and Expenses.

Looks up to: Contact

Lookup false
pse__Timecard__c Timecard Pre-Spring 2018 Looks up to: pse__Timecard__c
Lookup false
pse__Unit_Price__c Unit Price Pre-Spring 2018 Currency(18,2) false
pse__Vendor_Currency_Amount_Number__c Vendor Currency Amount Number Pre-Spring 2018 Number(18,2) false
pse__Vendor_Currency_Amount__c Vendor Currency Amount Pre-Spring 2018 Formula:
pse__Vendor_Currency__c+' '+TEXT(pse__Vendor_Currency_Amount_Number__c)
Text false
pse__Vendor_Currency_Exchange_Rate__c Vendor Currency Exchange Rate Pre-Spring 2018 Vendor Currency Exchange Rate that is used to convert amount to Vendor currency. This is always populated based on whichever rate is actually used - Project Currency Rate, Vendor Invoice Item override rate, or parent Vendor Invoice override rate. This field is auto-populated by the system, and should be read only on the page layout.

Number(18,6) false
pse__Vendor_Currency__c Vendor Currency Pre-Spring 2018 Formula:
pse__Vendor_Invoice__r.pse__Vendor_Currency__c
Text false
pse__Vendor_Invoice_ER_Override_Applied__c Vendor Invoice ER Override Applied Pre-Spring 2018 Formula:
IF(pse__Vendor_Invoice__r.pse__Override_Vendor_Invoice_Exchange_Rate__c, $Label.common_label_yes , $Label.common_label_no)
Text false
pse__Vendor_Invoice__c Vendor Invoice Pre-Spring 2018 Looks up to: pse__Vendor_Invoice__c
MasterDetail


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