PSA – Accounting Connector Data Dictionary

c2g__codaPurchaseInvoiceExpenseLineItem__c

Label: c2g__codaPurchaseInvoiceExpenseLineItem__c

Adding fields to an object in a different managed package

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Analysis1__c Analysis 1 Pre-Spring 2018 Text(255)
Analysis2__c Analysis 2 Pre-Spring 2018 Text(255)
Analysis3__c Analysis 3 Pre-Spring 2018 Text(255)
Analysis4__c Analysis 4 Pre-Spring 2018 Text(255)
AutomaticallyPassToPSA__c Automatically Pass to PSA Fall 2021 When selected, the payable invoice expense line item is automatically passed to PSA as soon as it becomes eligible.

Checkbox false
Expense__c Expense Pre-Spring 2018 Looks up to: pse__Expense__c

Lookup
GrossValue__c Gross Value Pre-Spring 2018 Formula:
c2g__NetValue__c + c2g__TaxValueTotal__c
Number(18,2)
InvoiceCurrency__c Invoice Currency Pre-Spring 2018 Formula:
c2g__PurchaseInvoice__r.c2g__InvoiceCurrency__r.Name
Text
InvoiceDate__c Invoice Date Pre-Spring 2018 Formula:
c2g__PurchaseInvoice__r.c2g__InvoiceDate__c
Date
MiscellaneousAdjustmentName__c Miscellaneous Adjustment Name Pre-Spring 2018 Formula:
LEFT(c2g__PurchaseInvoice__r.Name & '-' & Name, 80)
Text
PassToPSA__c Pass to PSA Fall 2021 Controls whether the expense line is eligible for creating miscellaneous adjustments in PSA. When Recharge Customer is also selected, two miscellaneous adjustments are created. Otherwise, only a single miscellaneous adjustment is created with the External Cost transaction category.

Checkbox false
PassedToPSA__c Passed to PSA Pre-Spring 2018 Checkbox false
Project__c Project Pre-Spring 2018 Looks up to: pse__Proj__c

Lookup
RechargeCustomer__c Recharge Customer Fall 2021 When the expense line is passed to PSA, this controls whether an additional miscellaneous adjustment is created with the Pass-Through Ready-to-Bill Revenue transaction category. Only applicable when Pass to PSA is selected.

Checkbox false
RechargeMiscAdjustmentDescription__c Recharge Misc. Adjustment Description Fall 2021 For system use only. We don't recommend that you add this field to any page layout. Used to set the description of the miscellaneous adjustment created from the payable invoice expense line item with the Pass-Through Ready-to-Bill Revenue transaction category.

Formula:
"Recharge - " & c2g__LineDescription__c
Text
RechargeMiscAdjustmentName__c Recharge Miscellaneous Adjustment Name Fall 2021 For system use only. We don't recommend that you add this field to any page layout. Used to set the name of the miscellaneous adjustment created from the payable invoice expense line item with the Pass-Through Ready-to-Bill Revenue transaction category.

Formula:
LEFT("Recharge - "& c2g__PurchaseInvoice__r.Name & '-' & Name, 80)
Text
TransactionCategory__c Transaction Category Pre-Spring 2018 Picklist:
Booked Revenue
Budgeted Cost
Budgeted Expense Cost
Expense Budget
Expense Cost
External Cost
Internal Budget
Internal Cost
Other Cost
Pass-Through Ready-to-Bill Revenue
Pre-Billed Revenue
Ready-to-Bill Revenue
Revenue
VendorInvoiceItem__c Vendor Invoice Item Pre-Spring 2018 Looks up to: pse__Vendor_Invoice_Item__c

Lookup


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