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 VersionDescriptionTypeRequiredDefault Value
Created_Date_In_Milliseconds__c Created Date In Milliseconds Summer 2024 The created date of the Transaction Delta in Milliseconds.

Number(18,2) false
Is_Project_Move__c Is Project Move Summer 2024 Field to identify transaction deltas that are part of a project move.

Checkbox false
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) false
New_Category__c New Category Pre-Spring 2018 Text(255) false
New_Currency__c New Currency Pre-Spring 2018 Text(3) false
New_Effective_Date__c New Effective Date Pre-Spring 2018 Date false
New_Group__c New Group Pre-Spring 2018 Looks up to: Grp__c
Lookup false
New_Hours__c New Hours Pre-Spring 2018 Number(5,2) false
New_Practice__c New Practice Pre-Spring 2018 Looks up to: Practice__c
Lookup false
New_Project__c New Project Pre-Spring 2018 Looks up to: Proj__c
Lookup false
New_Region__c New Region Pre-Spring 2018 Looks up to: Region__c
Lookup false
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 false
Old_Amount__c Old Amount Pre-Spring 2018 Currency(18,2) false
Old_Category__c Old Category Pre-Spring 2018 Text(255) false
Old_Currency__c Old Currency Pre-Spring 2018 Text(3) false
Old_Effective_Date__c Old Effective Date Pre-Spring 2018 Date false
Old_Group__c Old Group Pre-Spring 2018 Looks up to: Grp__c
Lookup false
Old_Hours__c Old Hours Pre-Spring 2018 Number(5,2) false
Old_Practice__c Old Practice Pre-Spring 2018 Looks up to: Practice__c
Lookup false
Old_Project__c Old Project Pre-Spring 2018 Looks up to: Proj__c
Lookup false
Old_Region__c Old Region Pre-Spring 2018 Looks up to: Region__c
Lookup false
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 false


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