Professional Services Automation Data Dictionary

Transaction_Delta__c

Label: Transaction Delta

Tracks an unprocessed creation or update of a transaction that has been queued for processing. Transaction deltas are produced when the Actuals Calculation Mode is 'Scheduled' and new or updated transactions do not roll-up to Actuals immediately. PSA creates transaction deltas when transactions are inserted, updated, or deleted.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Is_Time__c Is Time Pre-Spring 2018 Checkbox false
Is_Update__c Is Update Pre-Spring 2018 If true, this record was created in response to a DML UPDATE on Transaction. If false (default), it was an INSERT.

Checkbox false
New_Amount__c New Amount Pre-Spring 2018 Currency(18,2)
New_Category__c New Category Pre-Spring 2018 Text(255)
New_Currency__c New Currency Pre-Spring 2018 Text(3)
New_Effective_Date__c New Effective Date Pre-Spring 2018 Date
New_Group__c New Group Pre-Spring 2018 Looks up to: Grp__c
Lookup
New_Hours__c New Hours Pre-Spring 2018 Number(5,2)
New_Practice__c New Practice Pre-Spring 2018 Looks up to: Practice__c
Lookup
New_Project__c New Project Pre-Spring 2018 Looks up to: Proj__c
Lookup
New_Region__c New Region Pre-Spring 2018 Looks up to: Region__c
Lookup
New_Related_Record_Deleted__c New Related Record Ineligible Pre-Spring 2018 Checkbox false
New_Resource__c New Resource Pre-Spring 2018 Looks up to: Contact

Lookup
Old_Amount__c Old Amount Pre-Spring 2018 Currency(18,2)
Old_Category__c Old Category Pre-Spring 2018 Text(255)
Old_Currency__c Old Currency Pre-Spring 2018 Text(3)
Old_Effective_Date__c Old Effective Date Pre-Spring 2018 Date
Old_Group__c Old Group Pre-Spring 2018 Looks up to: Grp__c
Lookup
Old_Hours__c Old Hours Pre-Spring 2018 Number(5,2)
Old_Practice__c Old Practice Pre-Spring 2018 Looks up to: Practice__c
Lookup
Old_Project__c Old Project Pre-Spring 2018 Looks up to: Proj__c
Lookup
Old_Region__c Old Region Pre-Spring 2018 Looks up to: Region__c
Lookup
Old_Related_Record_Deleted__c Old Related Record Ineligible Pre-Spring 2018 Checkbox false
Old_Resource__c Old Resource Pre-Spring 2018 Looks up to: Contact

Lookup


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