Global Ledger measures

Measure Source and/or calculation
Birst Load Number [Birst Load Number]=GETVARIABLE('LoadNumber')
Budget Alternate 1 Amount [Budget Alternate 1 Amount]=[Totals.Alternate 1 Amount]
Budget Alternate 2 Amount [Budget Alternate 2 Amount]=[Totals.Alternate 2 Amount]
Budget Alternate 3 Amount [Budget Alternate 3 Amount]=[Totals.Alternate 3 Amount]
Budget Functional Amount [Budget Functional Amount]=[Totals.Functional Amount]
Budget Project Amount [Budget Project Amount]=[Totals.Project Amount]
Budget Report 1 Amount [Budget Report 1 Amount]=[Totals.Report 1 Amount]
Budget Report 2 Amount [Budget Report 2 Amount]=[Totals.Report 2 Amount]
Budget Report 3 Amount [Budget Report 3 Amount]=[Totals.Report 3 Amount]
Budget Report 4 Amount [Budget Report 4 Amount]=[Totals.Report 4 Amount]
Budget Report 5 Amount [Budget Report 5 Amount]=[Totals.Report 5 Amount]
Budget Transactional Amount [Budget Transactional Amount]=[Transactional Amount]
Budget Units Amount [Budget Units Amount]=[Totals.Units Amount]
Project

IF [Totals.Project] IS NOT NULL THEN

[Project]=[Totals.Project]

ELSE

[Project]=GETVARIABLE('BlankCodeIdentifier')

END IF
Accounting Unit [Accounting Unit]=[Grain(Commit and Encumbrance).Accounting Unit]
Current Commit Alternate 1 Amount [Current Commit Alternate 1 Amount]=[Grain(Commit and Encumbrance).Current Commit Alternate 1 Amount]
Current Commit Alternate 1 Currency Rate [Current Commit Alternate 1 Currency Rate]=[Grain(Commit and Encumbrance).Current Commit Alternate 1 Currency Rate]
Current Commit Alternate 2 Amount [Current Commit Alternate 2 Amount]=[Grain(Commit and Encumbrance).Current Commit Alternate 2 Amount]
Current Commit Alternate 2 Currency Rate [Current Commit Alternate 2 Currency Rate]=[Grain(Commit and Encumbrance).Current Commit Alternate 2 Currency Rate]
Current Commit Alternate 3 Amount [Current Commit Alternate 3 Amount]=[Grain(Commit and Encumbrance).Current Commit Alternate 3 Amount]
Current Commit Alternate 3 Currency Rate [Current Commit Alternate 3 Currency Rate]=[Grain(Commit and Encumbrance).Current Commit Alternate 3 Currency Rate]
Current Commit From Entity Alternate 1 Amount [Current Commit From Entity Alternate 1 Amount]=[Grain(Commit and Encumbrance).Current Commit From Entity Alternate 1 Amount]
Current Commit From Entity Alternate 1 Currency Rate [Current Commit From Entity Alternate 1 Currency Rate]=[Grain(Commit and Encumbrance).Current Commit From Entity Alternate 1 Currency Rate]
Current Commit From Entity Alternate 2 Amount [Current Commit From Entity Alternate 2 Currency Rate]=[Grain(Commit and Encumbrance).Current Commit From Entity Alternate 2 Currency Rate]
Current Commit From Entity Alternate 2 Currency Rate [Current Commit From Entity Alternate 2 Currency Rate]=[Grain(Commit and Encumbrance).Current Commit From Entity Alternate 2 Currency Rate]
Current Commit From Entity Alternate 3 Amount [Current Commit From Entity Alternate 3 Amount]=[Grain(Commit and Encumbrance).Current Commit From Entity Alternate 3 Amount]
Current Commit From Entity Alternate 3 Currency Rate [Current Commit From Entity Alternate 3 Currency Rate]=[Grain(Commit and Encumbrance).Current Commit From Entity Alternate 3 Currency Rate]
Current Commit From Entity Functional Amount [Current Commit From Entity Functional Amount]=[Grain(Commit and Encumbrance).Current Commit From Entity Functional Amount]
Current Commit From Entity Functional Currency Rate [Current Commit From Entity Functional Currency Rate]=[Grain(Commit and Encumbrance).Current Commit From Entity Functional Currency Rate]
Current Commit Functional Amount [Current Commit Functional Amount]=[Grain(Commit and Encumbrance).Current Commit Functional Amount]
Current Commit Functional Currency Rate [Current Commit Functional Currency Rate]=[Grain(Commit and Encumbrance).Current Commit Functional Currency Rate]
Current Commit Project Amount [Current Commit Project Amount]=[Grain(Commit and Encumbrance).Current Commit Project Amount]
Current Commit Project Currency Rate [Current Commit Project Currency Rate]=[Grain(Commit and Encumbrance).Current Commit Project Currency Rate]
Current Commit Report 1 Amount [Current Commit Report 1 Amount]=[Grain(Commit and Encumbrance).Current Commit Report 1 Amount]
Current Commit Report 1 Currency Rate [Current Commit Report 1 Currency Rate]=[Grain(Commit and Encumbrance).Current Commit Report 1 Currency Rate]
Current Commit Report 2 Amount [Current Commit Report 2 Amount]=[Grain(Commit and Encumbrance).Current Commit Report 2 Amount]
Current Commit Report 2 Currency Rate [Current Commit Report 2 Currency Rate]=[Grain(Commit and Encumbrance).Current Commit Report 2 Currency Rate]
Current Commit Report 3 Amount [Current Commit Report 3 Amount]=[Grain(Commit and Encumbrance).Current Commit Report 3 Amount]
Current Commit Report 3 Currency Rate [Current Commit Report 3 Currency Rate]=[Grain(Commit and Encumbrance).Current Commit Report 3 Currency Rate]
Current Commit Report 4 Amount [Current Commit Report 4 Amount]=[Grain(Commit and Encumbrance).Current Commit Report 4 Amount]
Current Commit Report 4 Currency Rate [Current Commit Report 4 Currency Rate]=[Grain(Commit and Encumbrance).Current Commit Report 4 Currency Rate]
Current Commit Report 5 Amount [Current Commit Report 5 Amount]=[Grain(Commit and Encumbrance).Current Commit Report 5 Amount]
Current Commit Report 5 Currency Rate [Current Commit Report 5 Currency Rate]=[Grain(Commit and Encumbrance).Current Commit Report 5 Currency Rate]
Current Commit Transaction Amount [Current Commit Transaction Amount]=[Grain(Commit and Encumbrance).Current Commit Transaction Amount]
Current Commit Units [Current Commit Units]=[Grain(Commit and Encumbrance).Current Commit Units]
Current Encumbrance Alternate 1 Amount [Current Encumbrance Alternate 1 Amount]=[Grain(Commit and Encumbrance).Current Encumbrance Alternate 1 Amount]
Current Encumbrance Alternate 1 Currency Rate [Current Encumbrance Alternate 1 Currency Rate]=[Grain(Commit and Encumbrance).Current Encumbrance Alternate 1 Currency Rate]
Current Encumbrance Alternate 2 Amount [Current Encumbrance Alternate 2 Amount]=[Grain(Commit and Encumbrance).Current Encumbrance Alternate 2 Amount]
Current Encumbrance Alternate 2 Currency Rate [Current Encumbrance Alternate 2 Currency Rate]=[Grain(Commit and Encumbrance).Current Encumbrance Alternate 2 Currency Rate]
Current Encumbrance Alternate 3 Amount [Current Encumbrance Alternate 3 Amount]=[Grain(Commit and Encumbrance).Current Encumbrance Alternate 3 Amount]
Current Encumbrance Alternate 3 Currency Rate [Current Encumbrance Alternate 3 Currency Rate]=[Grain(Commit and Encumbrance).Current Encumbrance Alternate 3 Currency Rate]
Current Encumbrance From Entity Alternate 1 Amount [Current Encumbrance From Entity Alternate 1 Amount]=[Grain(Commit and Encumbrance).Current Encumbrance From Entity Alternate 1 Amount]
Current Encumbrance From Entity Alternate 1 Currency Rate [Current Encumbrance From Entity Alternate 1 Currency Rate]=[Grain(Commit and Encumbrance).Current Encumbrance From Entity Alternate 1 Currency Rate]
Current Encumbrance From Entity Alternate 2 Amount [Current Encumbrance From Entity Alternate 2 Amount]=[Grain(Commit and Encumbrance).Current Encumbrance From Entity Alternate 2 Amount]
Current Encumbrance From Entity Alternate 2 Currency Rate [Current Encumbrance From Entity Alternate 2 Currency Rate]=[Grain(Commit and Encumbrance).Current Encumbrance From Entity Alternate 2 Currency Rate]
Current Encumbrance From Entity Alternate 3 Amount [Current Encumbrance From Entity Alternate 3 Amount]=[Grain(Commit and Encumbrance).Current Encumbrance From Entity Alternate 3 Amount]
Current Encumbrance From Entity Alternate 3 Currency Rate [Current Encumbrance From Entity Alternate 3 Currency Rate]=[Grain(Commit and Encumbrance).Current Encumbrance From Entity Alternate 3 Currency Rate]
Current Encumbrance From Entity Functional Amount [Current Encumbrance From Entity Functional Amount]=[Grain(Commit and Encumbrance).Current Encumbrance From Entity Functional Amount]
Current Encumbrance From Entity Functional Currency Rate [Current Encumbrance From Entity Functional Currency Rate]=[Grain(Commit and Encumbrance).Current Encumbrance From Entity Functional Currency Rate]
Current Encumbrance Functional Amount [Current Encumbrance Functional Amount]=[Grain(Commit and Encumbrance).Current Encumbrance Functional Amount]
Current Encumbrance Functional Currency Rate [Current Encumbrance Functional Currency Rate]=[Grain(Commit and Encumbrance).Current Encumbrance Functional Currency Rate]
Current Encumbrance Project Amount [Current Encumbrance Project Amount]=[Grain(Commit and Encumbrance).Current Encumbrance Project Amount]
Current Encumbrance Project Currency Rate [Current Encumbrance Project Currency Rate]=[Grain(Commit and Encumbrance).Current Encumbrance Project Currency Rate]
Current Encumbrance Report 1 Amount [Current Encumbrance Report 1 Amount]=[Grain(Commit and Encumbrance).Current Encumbrance Report 1 Amount]
Current Encumbrance Report 2 Amount [Current Encumbrance Report 2 Amount]=[Grain(Commit and Encumbrance).Current Encumbrance Report 2 Amount]
Current Encumbrance Report 2 Currency Rate [Current Encumbrance Report 2 Currency Rate]=[Grain(Commit and Encumbrance).Current Encumbrance Report 2 Currency Rate]
Current Encumbrance Report 3 Amount [Current Encumbrance Report 3 Amount]=[Grain(Commit and Encumbrance).Current Encumbrance Report 3 Amount]
Current Encumbrance Report 3 Currency Rate [Current Encumbrance Report 3 Currency Rate]=[Grain(Commit and Encumbrance).Current Encumbrance Report 3 Currency Rate]
Current Encumbrance Report 4 Amount [Current Encumbrance Report 4 Amount]=[Grain(Commit and Encumbrance).Current Encumbrance Report 4 Amount]
Current Encumbrance Report 4 Currency Rate [Current Encumbrance Report 4 Currency Rate]=[Grain(Commit and Encumbrance).Current Encumbrance Report 4 Currency Rate]
Current Encumbrance Report 5 Amount [Current Encumbrance Report 5 Amount]=[Grain(Commit and Encumbrance).Current Encumbrance Report 5 Amount]
Current Encumbrance Report 5 Currency Rate [Current Encumbrance Report 5 Currency Rate]=[Grain(Commit and Encumbrance).Current Encumbrance Report 5 Currency Rate]
Current Encumbrance Transaction Amount [Current Encumbrance Transaction Amount]=[Grain(Commit and Encumbrance).Current Encumbrance Transaction Amount]
Current Encumbrance Units [Current Encumbrance Units]=[Grain(Commit and Encumbrance).Current Encumbrance Units]
Encumbrance/Commit Year Rollover Alternate 1 Amount [Encumbrance/Commit Year Rollover Alternate 1 Amount]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Alternate 1 Amount]
Encumbrance/Commit Year Rollover Alternate 1 Currency Rate [Encumbrance/Commit Year Rollover Alternate 1 Currency Rate]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Alternate 1 Currency Rate]
Encumbrance/Commit Year Rollover Alternate 2 Amount [Encumbrance/Commit Year Rollover Alternate 2 Amount]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Alternate 2 Amount]
Encumbrance/Commit Year Rollover Alternate 2 Currency Rate [Encumbrance/Commit Year Rollover Alternate 2 Currency Rate]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Alternate 2 Currency Rate]
Encumbrance/Commit Year Rollover Alternate 3 Amount [Encumbrance/Commit Year Rollover Alternate 3 Amount]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Alternate 3 Amount]
Encumbrance/Commit Year Rollover Alternate 3 Currency Rate [Encumbrance/Commit Year Rollover Alternate 3 Currency Rate]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Alternate 3 Currency Rate]
Encumbrance/Commit Year Rollover From Entity Alternate 1 Amount [Encumbrance/Commit Year Rollover From Entity Alternate 1 Amount]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover From Entity Alternate 1 Amount]
Encumbrance/Commit Year Rollover From Entity Alternate 1 Currency Rate [Encumbrance/Commit Year Rollover From Entity Alternate 1 Currency Rate]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover From Entity Alternate 1 Currency Rate]
Encumbrance/Commit Year Rollover From Entity Alternate 2 Amount [Encumbrance/Commit Year Rollover From Entity Alternate 2 Amount]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover From Entity Alternate 2 Amount]
Encumbrance/Commit Year Rollover From Entity Alternate 2 Currency Rate [Encumbrance/Commit Year Rollover From Entity Alternate 2 Currency Rate]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover From Entity Alternate 2 Currency Rate]
Encumbrance/Commit Year Rollover From Entity Alternate 3 Amount [Encumbrance/Commit Year Rollover From Entity Alternate 3 Amount]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover From Entity Alternate 3 Amount]
Encumbrance/Commit Year Rollover From Entity Alternate 3 Currency Rate [Encumbrance/Commit Year Rollover From Entity Alternate 3 Currency Rate]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover From Entity Alternate 3 Currency Rate]
Encumbrance/Commit Year Rollover From Entity Functional Amount [Encumbrance/Commit Year Rollover From Entity Functional Amount]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover From Entity Functional Amount]
Encumbrance/Commit Year Rollover From Entity Functional Currency Rate [Encumbrance/Commit Year Rollover From Entity Functional Currency Rate]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover From Entity Functional Currency Rate]
Encumbrance/Commit Year Rollover Functional Amount [Encumbrance/Commit Year Rollover Functional Amount]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Functional Amount]
Encumbrance/Commit Year Rollover Functional Currency Rate [Encumbrance/Commit Year Rollover Functional Currency Rate]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Functional Currency Rate]
Encumbrance/Commit Year Rollover Project Amount [Encumbrance/Commit Year Rollover Project Amount]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Project Amount]
Encumbrance/Commit Year Rollover Project Currency Rate [Encumbrance/Commit Year Rollover Project Currency Rate]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Project Currency Rate]
Encumbrance/Commit Year Rollover Report 1 Amount [Encumbrance/Commit Year Rollover Report 1 Amount]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Report 1 Amount]
Encumbrance/Commit Year Rollover Report 1 Currency Rate [Encumbrance/Commit Year Rollover Report 1 Currency Rate]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Report 1 Currency Rate]
Encumbrance/Commit Year Rollover Report 2 Amount [Encumbrance/Commit Year Rollover Report 2 Amount]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Report 2 Amount]
Encumbrance/Commit Year Rollover Report 2 Currency Rate [Encumbrance/Commit Year Rollover Report 2 Currency Rate]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Report 2 Currency Rate]
Encumbrance/Commit Year Rollover Report 3 Amount [Encumbrance/Commit Year Rollover Report 3 Amount]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Report 3 Amount]
Encumbrance/Commit Year Rollover Report 3 Currency Rate [Encumbrance/Commit Year Rollover Report 3 Currency Rate]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Report 3 Currency Rate]
Encumbrance/Commit Year Rollover Report 4 Amount [Encumbrance/Commit Year Rollover Report 4 Amount]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Report 4 Amount]
Encumbrance/Commit Year Rollover Report 4 Currency Rate [Encumbrance/Commit Year Rollover Report 4 Currency Rate]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Report 4 Currency Rate]
Encumbrance/Commit Year Rollover Report 5 Amount [Encumbrance/Commit Year Rollover Report 5 Amount]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Report 5 Amount]
Encumbrance/Commit Year Rollover Report 5 Currency Rate [Encumbrance/Commit Year Rollover Report 5 Currency Rate]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Report 5 Currency Rate]
Encumbrance/Commit Year Rollover Transaction Amount [Encumbrance/Commit Year Rollover Transaction Amount]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Transaction Amount]
Encumbrance/Commit Year Rollover Units [Encumbrance/Commit Year Rollover Units]=[Grain(Commit and Encumbrance).Encumbrance/Commit Year Rollover Units]
Finance Dimension 01 [Finance Dimension 01]=[Grain(Commit and Encumbrance).Finance Dimension 01]
Finance Dimension 02 [Finance Dimension 02]=[Grain(Commit and Encumbrance).Finance Dimension 02]
Finance Dimension 03 [Finance Dimension 03]=[Grain(Commit and Encumbrance).Finance Dimension 03]
Finance Dimension 04 [Finance Dimension 04]=[Grain(Commit and Encumbrance).Finance Dimension 04]
Finance Dimension 05 [Finance Dimension 05]=[Grain(Commit and Encumbrance).Finance Dimension 05]
Finance Dimension 06 [Finance Dimension 06]=[Grain(Commit and Encumbrance).Finance Dimension 06]
Finance Dimension 07 [Finance Dimension 07]=[Grain(Commit and Encumbrance).Finance Dimension 07]
Finance Dimension 08 [Finance Dimension 08]=[Grain(Commit and Encumbrance).Finance Dimension 08]
Finance Dimension 09 [Finance Dimension 09]=[Grain(Commit and Encumbrance).Finance Dimension 09]
Finance Dimension 10 [Finance Dimension 10]=[Grain(Commit and Encumbrance).Finance Dimension 10]
Commit Birst Load ID [Commit Birst Load ID]=INTEGER(GetVariable('LoadNumber'))
Project [Project]=[Grain(Commit and Encumbrance).Project]
SubSystem Linked Date [SubSystem Linked Date] = NOW
Account [Account] = [Commit.Account]
Accounting Unit

IF [Commit.Accounting Unit] IS NOT NULL THEN

[Accounting Unit] = [Commit.Accounting Unit]

ELSE

[Accounting Unit] = GETVARIABLE('BlankCodeIdentifier')

END IF
Current Commit Alternate 1 Amount [Current Commit Alternate 1 Amount] = [Commit.Current Commit Alternate 1 Amount]
Current Commit Alternate 1 Currency Rate [Current Commit Alternate 1 Currency Rate] = [Commit.Current Commit Alternate 1 Currency Rate]
Current Commit Alternate 2 Amount [Current Commit Alternate 2 Amount] = [Commit.Current Commit Alternate 2 Amount]
Current Commit Alternate 2 Currency Rate [Current Commit Alternate 2 Currency Rate] = [Commit.Current Commit Alternate 2 Currency Rate]
Current Commit Alternate 3 Amount [Current Commit Alternate 3 Amount] = [Commit.Current Commit Alternate 3 Amount]
Current Commit Alternate 3 Currency Rate [Current Commit Alternate 3 Currency Rate] = [Commit.Current Commit Alternate 3 Currency Rate]
Current Commit From Entity Alternate 1 Amount [Current Commit From Entity Alternate 1 Amount] = [Commit.Current Commit From Entity Alternate 1 Amount]
Current Commit From Entity Alternate 1 Currency Rate [Current Commit From Entity Alternate 1 Currency Rate] = [Commit.Current Commit From Entity Alternate 1 Currency Rate]
Current Commit From Entity Alternate 2 Amount [Current Commit From Entity Alternate 2 Amount] = [Commit.Current Commit From Entity Alternate 2 Amount]
Current Commit From Entity Alternate 2 Currency Rate [Current Commit From Entity Alternate 2 Currency Rate] = [Commit.Current Commit From Entity Alternate 2 Currency Rate]
Current Commit From Entity Alternate 3 Amount [Current Commit From Entity Alternate 3 Amount] = [Commit.Current Commit From Entity Alternate 3 Amount]
Current Commit From Entity Alternate 3 Currency Rate [Current Commit From Entity Alternate 3 Currency Rate] = [Commit.Current Commit From Entity Alternate 3 Currency Rate]
Current Commit From Entity Functional Amount [Current Commit From Entity Functional Amount] = [Commit.Current Commit From Entity Functional Amount]
Current Commit From Entity Functional Currency Rate [Current Commit From Entity Functional Currency Rate] = [Commit.Current Commit From Entity Functional Currency Rate]
Current Commit Functional Amount [Current Commit Functional Amount] = [Commit.Current Commit Functional Amount]
Current Commit Functional Currency Rate [Current Commit Functional Currency Rate] = [Commit.Current Commit Functional Currency Rate]
Current Commit Project Amount [Current Commit Project Amount] = [Commit.Current Commit Project Amount]
Current Commit Project Currency Rate [Current Commit Project Currency Rate] = [Commit.Current Commit Project Currency Rate]
Current Commit Report 1 Amount [Current Commit Report 1 Amount] = [Commit.Current Commit Report 1 Amount]
Current Commit Report 1 Currency Rate [Current Commit Report 1 Currency Rate] = [Commit.Current Commit Report 1 Currency Rate]
Current Commit Report 2 Amount [Current Commit Report 2 Amount] = [Commit.Current Commit Report 2 Amount]
Current Commit Report 2 Currency Rate [Current Commit Report 2 Currency Rate] = [Commit.Current Commit Report 2 Currency Rate]
Current Commit Report 3 Amount [Current Commit Report 3 Amount] = [Commit.Current Commit Report 3 Amount]
Current Commit Report 3 Currency Rate [Current Commit Report 3 Currency Rate] = [Commit.Current Commit Report 3 Currency Rate]
Current Commit Report 4 Amount [Current Commit Report 4 Amount] = [Commit.Current Commit Report 4 Amount]
Current Commit Report 4 Currency Rate [Current Commit Report 4 Currency Rate] = [Commit.Current Commit Report 4 Currency Rate]
Current Commit Report 5 Amount [Current Commit Report 5 Amount] = [Commit.Current Commit Report 5 Amount]
Current Commit Report 5 Currency Rate [Current Commit Report 5 Currency Rate] = [Commit.Current Commit Report 5 Currency Rate]
Current Commit Transaction Amount [Current Commit Transaction Amount] = [Commit.Current Commit Transaction Amount]
Current Commit Units [Current Commit Units] = [Commit.Current Commit Units]
Current Encumbrance Alternate 1 Amount [Current Encumbrance Alternate 1 Amount] = [Commit.Current Commit Alternate 1 Amount]
Current Encumbrance Alternate 1 Currency Rate [Current Encumbrance Alternate 1 Currency Rate] = [Commit.Current Commit Alternate 1 Currency Rate]
Current Encumbrance Alternate 2 Amount [Current Encumbrance Alternate 2 Amount] = [Commit.Current Commit Alternate 2 Amount]
Current Encumbrance Alternate 2 Currency Rate [Current Encumbrance Alternate 2 Currency Rate] = [Commit.Current Commit Alternate 2 Currency Rate]
Current Encumbrance Alternate 3 Amount [Current Encumbrance Alternate 3 Amount] = [Commit.Current Commit Alternate 3 Amount]
Current Encumbrance Alternate 3 Currency Rate [Current Encumbrance Alternate 3 Currency Rate] = [Commit.Current Commit Alternate 3 Currency Rate]
Current Encumbrance From Entity Alternate 1 Amount [Current Encumbrance From Entity Alternate 1 Amount] = [Commit.Current Commit From Entity Alternate 1 Amount]
Current Encumbrance From Entity Alternate 1 Currency Rate [Current Encumbrance From Entity Alternate 1 Currency Rate] = [Commit.Current Commit From Entity Alternate 1 Currency Rate]
Current Encumbrance From Entity Alternate 2 Amount [Current Encumbrance From Entity Alternate 2 Amount] = [Commit.Current Commit From Entity Alternate 2 Amount]
Current Encumbrance From Entity Alternate 2 Currency Rate [Current Encumbrance From Entity Alternate 2 Currency Rate] = [Commit.Current Commit From Entity Alternate 2 Currency Rate]
Current Encumbrance From Entity Alternate 3 Amount [Current Encumbrance From Entity Alternate 3 Amount] = [Commit.Current Commit From Entity Alternate 3 Amount]
Current Encumbrance From Entity Alternate 3 Currency Rate [Current Encumbrance From Entity Alternate 3 Currency Rate] = [Commit.Current Commit From Entity Alternate 3 Currency Rate]
Current Encumbrance From Entity Functional Amount [Current Encumbrance From Entity Functional Amount] = [Commit.Current Commit From Entity Functional Amount]
Current Encumbrance From Entity Functional Currency Rate [Current Encumbrance From Entity Functional Currency Rate] = [Commit.Current Commit From Entity Functional Currency Rate]
Current Encumbrance Functional Amount [Current Encumbrance Functional Amount] = [Commit.Current Commit Functional Amount]
Current Encumbrance Functional Currency Rate [Current Encumbrance Functional Currency Rate] = [Commit.Current Commit Functional Currency Rate]
Current Encumbrance Project Amount [Current Encumbrance Project Amount] = [Commit.Current Commit Project Amount]
Current Encumbrance Project Currency Rate [Current Encumbrance Project Currency Rate] = [Commit.Current Commit Project Currency Rate]
Current Encumbrance Report 1 Amount [Current Encumbrance Report 1 Amount] = [Commit.Current Commit Report 1 Amount]
Current Encumbrance Report 1 Currency Rate [Current Encumbrance Report 1 Currency Rate] = [Commit.Current Commit Report 1 Currency Rate]
Current Encumbrance Report 2 Amount [Current Encumbrance Report 2 Amount] = [Commit.Current Commit Report 2 Amount]
Current Encumbrance Report 2 Currency Rate [Current Encumbrance Report 2 Currency Rate] = [Commit.Current Commit Report 2 Currency Rate]
Current Encumbrance Report 3 Amount [Current Encumbrance Report 3 Amount] = [Commit.Current Commit Report 3 Amount]
Current Encumbrance Report 3 Currency Rate [Current Encumbrance Report 3 Currency Rate] = [Commit.Current Commit Report 3 Currency Rate]
Current Encumbrance Report 4 Amount [Current Encumbrance Report 4 Amount] = [Commit.Current Commit Report 4 Amount]
Current Encumbrance Report 4 Currency Rate [Current Encumbrance Report 4 Currency Rate] = [Commit.Current Commit Report 4 Currency Rate]
Current Encumbrance Report 5 Amount [Current Encumbrance Report 5 Amount] = [Commit.Current Commit Report 5 Amount]
Current Encumbrance Report 5 Currency Rate [Current Encumbrance Report 5 Currency Rate] = [Commit.Current Commit Report 5 Currency Rate]
Current Encumbrance Transaction Amount [Current Encumbrance Transaction Amount] = [Commit.Current Commit Transaction Amount]
Current Encumbrance Units [Current Encumbrance Units] = [Commit.Current Commit Units]
Encumbrance/Commit Year Rollover Alternate 1 Amount [Encumbrance/Commit Year Rollover Alternate 1 Amount] = [Commit.Encumbrance Year Rollover Alternate 1 Amount]
Encumbrance/Commit Year Rollover Alternate 1 Currency Rate [Encumbrance/Commit Year Rollover Alternate 1 Currency Rate] = [Commit.Encumbrance Year Rollover Alternate 1 Currency Rate]
Encumbrance/Commit Year Rollover Alternate 2 Amount [Encumbrance/Commit Year Rollover Alternate 2 Amount] = [Commit.Encumbrance Year Rollover Alternate 2 Amount]
Encumbrance/Commit Year Rollover Alternate 2 Currency Rate [Encumbrance/Commit Year Rollover Alternate 2 Currency Rate] = [Commit.Encumbrance Year Rollover Alternate 2 Currency Rate]
Encumbrance/Commit Year Rollover Alternate 3 Amount [Encumbrance/Commit Year Rollover Alternate 3 Amount] = [Commit.Encumbrance Year Rollover Alternate 3 Amount]
Encumbrance/Commit Year Rollover Alternate 3 Currency Rate [Encumbrance/Commit Year Rollover Alternate 3 Currency Rate] = [Commit.Encumbrance Year Rollover Alternate 3 Currency Rate]
Encumbrance/Commit Year Rollover From Entity Alternate 1 Amount [Encumbrance/Commit Year Rollover From Entity Alternate 1 Amount] = [Commit.Encumbrance Year Rollover From Entity Alternate 1 Amount]
Encumbrance/Commit Year Rollover From Entity Alternate 1 Currency Rate [Encumbrance/Commit Year Rollover From Entity Alternate 1 Currency Rate] = [Commit.Encumbrance Year Rollover From Entity Alternate 1 Currency Rate]
Encumbrance/Commit Year Rollover From Entity Alternate 2 Amount [Encumbrance/Commit Year Rollover From Entity Alternate 2 Amount] = [Commit.Encumbrance Year Rollover From Entity Alternate 2 Amount]
Encumbrance/Commit Year Rollover From Entity Alternate 2 Currency Rate [Encumbrance/Commit Year Rollover From Entity Alternate 2 Currency Rate] = [Commit.Encumbrance Year Rollover From Entity Alternate 2 Currency Rate]
Encumbrance/Commit Year Rollover From Entity Alternate 3 Amount [Encumbrance/Commit Year Rollover From Entity Alternate 3 Amount] = [Commit.Encumbrance Year Rollover From Entity Alternate 3 Amount]
Encumbrance/Commit Year Rollover From Entity Alternate 3 Currency Rate [Encumbrance/Commit Year Rollover From Entity Alternate 3 Currency Rate] = [Commit.Encumbrance Year Rollover From Entity Alternate 3 Currency Rate]
Encumbrance/Commit Year Rollover From Entity Functional Amount [Encumbrance/Commit Year Rollover From Entity Functional Amount] = [Commit.Encumbrance Year Rollover From Entity Functional Amount]
Encumbrance/Commit Year Rollover From Entity Functional Currency Rate [Encumbrance/Commit Year Rollover From Entity Functional Currency Rate] = [Commit.Encumbrance Year Rollover From Entity Functional Currency Rate]
Encumbrance/Commit Year Rollover Functional Amount [Encumbrance/Commit Year Rollover Functional Amount] = [Commit.Encumbrance Year Rollover Functional Amount]
Encumbrance/Commit Year Rollover Functional Currency Rate [Encumbrance/Commit Year Rollover Functional Currency Rate] = [Commit.Encumbrance Year Rollover Functional Currency Rate]
Encumbrance/Commit Year Rollover Project Amount [Encumbrance/Commit Year Rollover Project Amount] = [Commit.Encumbrance Year Rollover Project Amount]
Encumbrance/Commit Year Rollover Project Currency Rate [Encumbrance/Commit Year Rollover Project Currency Rate] = [Commit.Encumbrance Year Rollover Project Currency Rate]
Encumbrance/Commit Year Rollover Report 1 Amount [Encumbrance/Commit Year Rollover Report 1 Amount] = [Commit.Encumbrance Year Rollover Report 1 Amount]
Encumbrance/Commit Year Rollover Report 1 Currency Rate [Encumbrance/Commit Year Rollover Report 1 Currency Rate] = [Commit.Encumbrance Year Rollover Report 1 Currency Rate]
Encumbrance/Commit Year Rollover Report 2 Amount [Encumbrance/Commit Year Rollover Report 2 Amount] = [Commit.Encumbrance Year Rollover Report 2 Amount]
Encumbrance/Commit Year Rollover Report 2 Currency Rate [Encumbrance/Commit Year Rollover Report 2 Currency Rate] = [Commit.Encumbrance Year Rollover Report 2 Currency Rate]
Encumbrance/Commit Year Rollover Report 3 Amount [Encumbrance/Commit Year Rollover Report 3 Amount] = [Commit.Encumbrance Year Rollover Report 3 Amount]
Encumbrance/Commit Year Rollover Report 3 Currency Rate [Encumbrance/Commit Year Rollover Report 3 Currency Rate] = [Commit.Encumbrance Year Rollover Report 3 Currency Rate]
Encumbrance/Commit Year Rollover Report 4 Amount [Encumbrance/Commit Year Rollover Report 4 Amount] = [Commit.Encumbrance Year Rollover Report 4 Amount]
Encumbrance/Commit Year Rollover Report 4 Currency Rate [Encumbrance/Commit Year Rollover Report 4 Currency Rate] = [Commit.Encumbrance Year Rollover Report 4 Currency Rate]
Encumbrance/Commit Year Rollover Report 5 Amount [Encumbrance/Commit Year Rollover Report 5 Amount] = [Commit.Encumbrance Year Rollover Report 5 Amount]
Encumbrance/Commit Year Rollover Report 5 Currency Rate [Encumbrance/Commit Year Rollover Report 5 Currency Rate] = [Commit.Encumbrance Year Rollover Report 5 Currency Rate]
Encumbrance/Commit Year Rollover Transaction Amount [Encumbrance/Commit Year Rollover Transaction Amount] = [Commit.Encumbrance Year Rollover Transaction Amount]
Encumbrance/Commit Year Rollover Units [Encumbrance/Commit Year Rollover Units] = [Commit.Encumbrance Year Rollover Units]
Finance Dimension 01

IF [Commit.Finance Dimension 01] IS NOT NULL THEN

[Finance Dimension 01] = [Commit.Finance Dimension 01]

ELSE

[Finance Dimension 01] = GETVARIABLE('BlankCodeIdentifier')

END IF
Finance Dimension 02

IF [Commit.Finance Dimension 02] IS NOT NULL THEN

[Finance Dimension 02] = [Commit.Finance Dimension 02]

ELSE

[Finance Dimension 02] = GETVARIABLE('BlankCodeIdentifier')

END IF
Finance Dimension 03

IF [Commit.Finance Dimension 03] IS NOT NULL THEN

[Finance Dimension 03] = [Commit.Finance Dimension 03]

ELSE

[Finance Dimension 03] = GETVARIABLE('BlankCodeIdentifier')

END IF
Finance Dimension 04

IF [Commit.Finance Dimension 04] IS NOT NULL THEN

[Finance Dimension 04] = [Commit.Finance Dimension 04]

ELSE

[Finance Dimension 04] = GETVARIABLE('BlankCodeIdentifier')

END IF
Finance Dimension 05

IF [Commit.Finance Dimension 05] IS NOT NULL THEN

[Finance Dimension 05] = [Commit.Finance Dimension 05]

ELSE

[Finance Dimension 05] = GETVARIABLE('BlankCodeIdentifier')

END IF
Finance Dimension 06

IF [Commit.Finance Dimension 06] IS NOT NULL THEN

[Finance Dimension 06] = [Commit.Finance Dimension 06]

ELSE

[Finance Dimension 06] = GETVARIABLE('BlankCodeIdentifier')

END IF
Finance Dimension 07

IF [Commit.Finance Dimension 07] IS NOT NULL THEN

[Finance Dimension 07] = [Commit.Finance Dimension 07]

ELSE

[Finance Dimension 07] = GETVARIABLE('BlankCodeIdentifier')

END IF
Finance Dimension 08

IF [Commit.Finance Dimension 08] IS NOT NULL THEN

[Finance Dimension 08] = [Commit.Finance Dimension 08]

ELSE

[Finance Dimension 08] = GETVARIABLE('BlankCodeIdentifier')

END IF
Finance Dimension 09

IF [Commit.Finance Dimension 09] IS NOT NULL THEN

[Finance Dimension 09] = [Commit.Finance Dimension 09]

ELSE

[Finance Dimension 09] = GETVARIABLE('BlankCodeIdentifier')

END IF
Finance Dimension 10

IF [Commit.Finance Dimension 10] IS NOT NULL THEN

[Finance Dimension 10] = [Commit.Finance Dimension 10]

ELSE

[Finance Dimension 10] = GETVARIABLE('BlankCodeIdentifier')

END IF
Commit Birst Load ID [Commit Birst Load ID]=[v_BirstLoadID]
Commit Record Update [Commit Record Update] = NOW
Project

IF [Commit.Project] IS NOT NULL THEN

[Project] = [Commit.Project]

ELSE

[Project] = GETVARIABLE('BlankCodeIdentifier')

END IF
Accounting Unit

IF [Totals.Accounting Unit] IS NOT NULL THEN

[Accounting Unit]=[Totals.Accounting Unit]

ELSE

[Accounting Unit]=GETVARIABLE('BlankCodeIdentifier')

END IF
Actual Alternate 1 Amount [Actual Alternate 1 Amount]=[Totals.Alternate 1 Amount]
Actual Alternate 2 Amount [Actual Alternate 2 Amount]=[Totals.Alternate 2 Amount]
Actual Alternate 3 Amount [Actual Alternate 3 Amount]=[Totals.Alternate 3 Amount]
Actual Functional Amount [Actual Functional Amount]=[Totals.Functional Amount]
Actual Project Amount [Actual Project Amount]=[Totals.Project Amount]
Actual Report 1 Amount [Actual Report 1 Amount]=[Totals.Report 1 Amount]
Actual Report 2 Amount [Actual Report 2 Amount]=[Totals.Report 2 Amount]
Actual Report 3 Amount [Actual Report 3 Amount]=[Totals.Report 3 Amount]
Actual Report 4 Amount [Actual Report 4 Amount]=[Totals.Report 4 Amount]
Actual Report 5 Amount [Actual Report 5 Amount]=[Totals.Report 5 Amount]
Actual Transactional Amount [Actual Transactional Amount]=[Totals.Transactional Amount]
Actual Units Amount [Actual Units Amount]=[Totals.Units Amount]
Birst Load Number [Birst Load Number]=GETVARIABLE('LoadNumber')
Commitment Alternate 1 Amount [Commitment Alternate 1 Amount]=[Totals.Alternate 1 Amount]
Commitment Alternate 2 Amount [Commitment Alternate 2 Amount]=[Totals.Alternate 2 Amount]
Commitment Alternate 3 Amount [Commitment Alternate 3 Amount]=[Totals.Alternate 3 Amount]
Commitment Functional Amount [Commitment Functional Amount]=[Totals.Functional Amount]
Commitment Project Amount [Commitment Project Amount]=[Totals.Project Amount]
Commitment Report 1 Amount [Commitment Report 1 Amount]=[Totals.Report 1 Amount]
Commitment Report 2 Amount [CommitmentReport2Amount]=[GLTotals.GLReport2Amount]
Commitment Report 3 Amount [CommitmentReport3Amount]=[GLTotals.GLReport3Amount]
Commitment Report 4 Amount [CommitmentReport4Amount]=[GLTotals.GLReport4Amount]
Commitment Report 5 Amount [CommitmentReport5Amount]=[GLTotals.GLReport5Amount]
Commitment Transactional Amount [Commitment Transactional Amount]=[Totals.Transactional Amount]
Commitment Units Amount [Commitment Units Amount]=[Totals.Units Amount]
Encumbrance Alternate 1 Amount [Encumbrance Alternate 1 Amount]=0
Encumbrance Alternate 2 Amount [Encumbrance Alternate 2 Amount]=0
Encumbrance Alternate 3 Amount [Encumbrance Alternate 3 Amount]=0
Encumbrance Functional Amount [Encumbrance Functional Amount]=[Totals.Functional Amount]
Encumbrance Project Amount [Encumbrance Project Amount]=[Totals.Project Amount]
Encumbrance Report 1 Amount [Encumbrance Report 1 Amount]=[Totals.Report 1 Amount]
Encumbrance Report 2 Amount [Encumbrance Report 2 Amount]=[Totals.Report 2 Amount]
Encumbrance Report 3 Amount [Encumbrance Report 3 Amount]=[Totals.Report 3 Amount]
Encumbrance Report 4 Amount [Encumbrance Report 4 Amount]=[Totals.Report 4 Amount]
Encumbrance Report 5 Amount [Encumbrance Report 5 Amount]=[Totals.Report 5 Amount]
Encumbrance Transactional Amount [Encumbrance Transactional Amount]=[Totals.Transactional Amount]
Encumbrance Units Amount [Encumbrance Units Amount]=[Totals.Units Amount]
Project

IF [Totals.Project] IS NOT NULL THEN

[Project]=[Totals.Project]

ELSE

[Project]=GETVARIABLE('BlankCodeIdentifier')

END IF
GLT Alternate 1 Amount [GLT Alternate 1 Amount]=[Transactions.GLT From Entity Alternate 1 Amount]
GLT Alternate 1 Amount Currency Rate

IF [Transactions.Journal Accounting Entity] = [Transactions.Accounting Entity]

[GLT Functional Amount Currency Rate]=[Transactions.GLT From Entity Functional Amount Currency Rate]

[GLT Alternate 1 Amount Currency Rate]=[Transactions.GLT From Entity Alternate 1 Amount Currency Rate]

[GLT Alternate 2 Amount Currency Rate]=[Transactions.GLT From Entity Alternate 2 Amount Currency Rate]

[GLT Alternate 3 Amount Currency Rate]=[Transactions.GLT From Entity Alternate 3 Amount Currency Rate]

ELSE

[GLT Functional Amount Currency Rate]=[Transactions.GLT Functional Amount Currency Rate]

[GLT Alternate 1 Amount Currency Rate]=[Transactions.GLT Alternate 1 Amount Currency Rate]

[GLT Alternate 2 Amount Currency Rate]=[Transactions.GLT Alternate 2 Amount Currency Rate]

[GLT Alternate 3 Amount Currency Rate]=[Transactions.GLT Alternate 3 Amount Currency Rate]

END IF
GLT Alternate 2 Amount

IF [Transactions.Journal Accounting Entity] = [Transactions.Accounting Entity]

[GLT Functional Amount]=[Transactions.GLT From Entity Functional Amount]

[GLT Alternate 1 Amount]=[Transactions.GLT From Entity Alternate 1 Amount]

[GLT Alternate 2 Amount]=[Transactions.GLT From Entity Alternate 2 Amount]

[GLT Alternate 3 Amount]=[Transactions.GLT From Entity Alternate 3 Amount]

ELSE

[GLT Functional Amount]=[Transactions.GLT Functional Amount]

[GLT Alternate 1 Amount]=[Transactions.GLT Alternate 1 Amount]

[GLT Alternate 2 Amount]=[Transactions.GLT Alternate 2 Amount]

[GLT Alternate 3 Amount]=[Transactions.GLT Alternate 3 Amount]

END IF
GLT Alternate 2 Amount Currency Rate

IF [Transactions.Journal Accounting Entity] = [Transactions.Accounting Entity]

[GLT Functional Amount Currency Rate]=[Transactions.GLT From Entity Functional Amount Currency Rate]

[GLT Alternate 1 Amount Currency Rate]=[Transactions.GLT From Entity Alternate 1 Amount Currency Rate]

[GLT Alternate 2 Amount Currency Rate]=[Transactions.GLT From Entity Alternate 2 Amount Currency Rate]

[GLT Alternate 3 Amount Currency Rate]=[Transactions.GLT From Entity Alternate 3 Amount Currency Rate]

ELSE

[GLT Functional Amount Currency Rate]=[Transactions.GLT Functional Amount Currency Rate]

[GLT Alternate 1 Amount Currency Rate]=[Transactions.GLT Alternate 1 Amount Currency Rate]

[GLT Alternate 2 Amount Currency Rate]=[Transactions.GLT Alternate 2 Amount Currency Rate]

[GLT Alternate 3 Amount Currency Rate]=[Transactions.GLT Alternate 3 Amount Currency Rate]

END IF
GLT Alternate 3 Amount

IF [Transactions.Journal Accounting Entity] = [Transactions.Accounting Entity]

[GLT Functional Amount Currency Rate]=[Transactions.GLT From Entity Functional Amount Currency Rate]

[GLT Alternate 1 Amount Currency Rate]=[Transactions.GLT From Entity Alternate 1 Amount Currency Rate]

[GLT Alternate 2 Amount Currency Rate]=[Transactions.GLT From Entity Alternate 2 Amount Currency Rate]

[GLT Alternate 3 Amount Currency Rate]=[Transactions.GLT From Entity Alternate 3 Amount Currency Rate]

ELSE

[GLT Functional Amount Currency Rate]=[Transactions.GLT Functional Amount Currency Rate]

[GLT Alternate 1 Amount Currency Rate]=[Transactions.GLT Alternate 1 Amount Currency Rate]

[GLT Alternate 2 Amount Currency Rate]=[Transactions.GLT Alternate 2 Amount Currency Rate]

[GLT Alternate 3 Amount Currency Rate]=[Transactions.GLT Alternate 3 Amount Currency Rate]

END IF
GLT Alternate 3 Amount Currency Rate

IF [Transactions.Journal Accounting Entity] = [Transactions.Accounting Entity]

[GLT Functional Amount Currency Rate]=[Transactions.GLT From Entity Functional Amount Currency Rate]

[GLT Alternate 1 Amount Currency Rate]=[Transactions.GLT From Entity Alternate 1 Amount Currency Rate]

[GLT Alternate 2 Amount Currency Rate]=[Transactions.GLT From Entity Alternate 2 Amount Currency Rate]

[GLT Alternate 3 Amount Currency Rate]=[Transactions.GLT From Entity Alternate 3 Amount Currency Rate]

ELSE

[GLT Functional Amount Currency Rate]=[Transactions.GLT Functional Amount Currency Rate]

[GLT Alternate 1 Amount Currency Rate]=[Transactions.GLT Alternate 1 Amount Currency Rate]

[GLT Alternate 2 Amount Currency Rate]=[Transactions.GLT Alternate 2 Amount Currency Rate]

[GLT Alternate 3 Amount Currency Rate]=[Transactions.GLT Alternate 3 Amount Currency Rate]

END IF
GLT From Entity Alternate 1 Amount [GLT From Entity Alternate 1 Amount]=[Transactions.GLT From Entity Alternate 1 Amount]
GLT From Entity Alternate 1 Amount Currency Rate [GLT From Entity Alternate 1 Amount Currency Rate]=[Transactions.GLT From Entity Alternate 1 Amount Currency Rate]
GLT From Entity Alternate 2 Amount [GLT From Entity Alternate 2 Amount]=[Transactions.GLT From Entity Alternate 2 Amount]
GLT From Entity Alternate 2 Amount Currency Rate [GLT From Entity Alternate 2 Amount Currency Rate]=[Transactions.GLT From Entity Alternate 2 Amount Currency Rate]
GLT From Entity Alternate 3 Amount [GLT From Entity Alternate 3 Amount]=[Transactions.GLT From Entity Alternate 3 Amount]
GLT From Entity Alternate 3 Amount Currency Rate [GLT From Entity Alternate 3 Amount Currency Rate]=[Transactions.GLT From Entity Alternate 3 Amount Currency Rate]
GLT From Entity Functional Amount [GLT From Entity Functional Amount]=[Transactions.GLT From Entity Functional Amount]
GLT From Entity Functional Amount Currency Rate [GLT From Entity Functional Amount Currency Rate]=[Transactions.GLT From Entity Functional Amount Currency Rate]
GLT Functional Amount

IF [Transactions.Journal Accounting Entity] = [Transactions.Accounting Entity]

[GLT Functional Amount]=[Transactions.GLT From Entity Functional Amount]

[GLT Alternate 1 Amount]=[Transactions.GLT From Entity Alternate 1 Amount]

[GLT Alternate 2 Amount]=[Transactions.GLT From Entity Alternate 2 Amount]

[GLT Alternate 3 Amount]=[Transactions.GLT From Entity Alternate 3 Amount]

ELSE

[GLT Functional Amount]=[Transactions.GLT Functional Amount]

[GLT Alternate 1 Amount]=[Transactions.GLT Alternate 1 Amount]

[GLT Alternate 2 Amount]=[Transactions.GLT Alternate 2 Amount]

[GLT Alternate 3 Amount]=[Transactions.GLT Alternate 3 Amount]

END IF
GLT Functional Amount Currency Rate

IF [Transactions.Journal Accounting Entity] = [Transactions.Accounting Entity]

[GLT Functional Amount Currency Rate]=[Transactions.GLT From Entity Functional Amount Currency Rate]

[GLT Alternate 1 Amount Currency Rate]=[Transactions.GLT From Entity Alternate 1 Amount Currency Rate]

[GLT Alternate 2 Amount Currency Rate]=[Transactions.GLT From Entity Alternate 2 Amount Currency Rate]

[GLT Alternate 3 Amount Currency Rate]=[Transactions.GLT From Entity Alternate 3 Amount Currency Rate]

ELSE

[GLT Functional Amount Currency Rate]=[Transactions.GLT Functional Amount Currency Rate]

[GLT Alternate 1 Amount Currency Rate]=[Transactions.GLT Alternate 1 Amount Currency Rate]

[GLT Alternate 2 Amount Currency Rate]=[Transactions.GLT Alternate 2 Amount Currency Rate]

[GLT Alternate 3 Amount Currency Rate]=[Transactions.GLT Alternate 3 Amount Currency Rate]

END IF
GLT Project Amount [GLT Project Amount]=[Transactions.GLT Project Amount]
GLT Project Amount Currency Rate [GLT Project Amount Currency Rate]=[Transactions.GLT Project Amount Currency Rate]
GLT Report 1 Amount [GLT Report 1 Amount]=[Transactions.GLT Report 1 Amount]
GLT Report 1 Amount Currency Rate [GLT Report 1 Amount Currency Rate]=[Transactions.GLT Report 1 Amount Currency Rate]
GLT Report 2 Amount [GLT Report 2 Amount Currency Rate]=[Transactions.GLT Report 2 Amount Currency Rate]
GLT Report 2 Amount Currency Rate [GLT Report 2 Amount Currency Rate]=[Transactions.GLT Report 2 Amount Currency Rate]
GLT Report 3 Amount [GLT Report 3 Amount]=[Transactions.GLT Report 3 Amount]
GLT Report 3 Amount Currency Rate [GLT Report 3 Amount Currency Rate]=[Transactions.GLT Report 3 Amount Currency Rate]
GLT Report 4 Amount [GLT Report 4 Amount]=[Transactions.GLT Report 4 Amount]
GLT Report 4 Amount Currency Rate [GLT Report 4 Amount Currency Rate]=[Transactions.GLT Report 4 Amount Currency Rate]
GLT Report 5 Amount [GLT Report 5 Amount]=[Transactions.GLT Report 5 Amount]
GLT Report 5 Amount Currency Rate [GLT Report 5 Amount Currency Rate]=[Transactions.GLT Report 5 Amount Currency Rate]
GLT Transaction Amount [GLT Transaction Amount]=[Transactions.GLT Transaction Amount]
GLT Units Amount [GLT Units Amount]=[Transactions.GLT Units Amount]
Project

IF [Transactions.Project] IS NOT NULL THEN

[Project]=[Transactions.Project]

ELSE

[Project]=GETVARIABLE('BlankCodeIdentifier')

END IF
Finance Dimension 01 [Finance Dimension 01]=[Grain(GTD Transactions).Finance Dimension 01]
Finance Dimension 02 [Finance Dimension 02]=[Grain(GTD Transactions).Finance Dimension 02]
Finance Dimension 03 [Finance Dimension 03]=[Grain(GTD Transactions).Finance Dimension 03]
Finance Dimension 04 [Finance Dimension 04]=[Grain(GTD Transactions).Finance Dimension 04]
Finance Dimension 05 [Finance Dimension 05]=[Grain(GTD Transactions).Finance Dimension 05]
Finance Dimension 06 [Finance Dimension 06]=[Grain(GTD Transactions).Finance Dimension 06]
Finance Dimension 07 [Finance Dimension 07]=[Grain(GTD Transactions).Finance Dimension 07]
Finance Dimension 08 [Finance Dimension 08]=[Grain(GTD Transactions).Finance Dimension 08]
Finance Dimension 09 [Finance Dimension 09]=[Grain(GTD Transactions).Finance Dimension 09]
Finance Dimension 10 [Finance Dimension 10]=[Grain(GTD Transactions).Finance Dimension 10]
GTD Alternate Amount 1 [GTD Alternate Amount 1]=[Grain(GTD Transactions).Sum: GTD Alternate Amount 1]
GTD Alternate Amount 1 Currency Rate [GTD Alternate Amount 1 Currency Rate]=[Grain(GTD Transactions).Sum: GTD Alternate Amount 1 Currency Rate]
GTD Alternate Amount 2 [GTD Alternate Amount 2]=[Grain(GTD Transactions).Sum: GTD Alternate Amount 2]
GTD Alternate Amount 2 Currency Rate [GTD Alternate Amount 2 Currency Rate]=[Grain(GTD Transactions).Sum: GTD Alternate Amount 2 Currency Rate]
GTD Alternate Amount 3 [GTD Alternate Amount 3]=[Grain(GTD Transactions).Sum: GTD Alternate Amount 3]
GTD Alternate Amount 3 Currency Rate [GTD Alternate Amount 3 Currency Rate]=[Grain(GTD Transactions).Sum: GTD Alternate Amount 3 Currency Rate]
GTD Birst Load ID [GTD Birst Load ID]=INTEGER(GetVariable('LoadNumber'))
GTD Extended Cost [GTD Extended Cost]= [Level(Cache Subsystem Transaction Detail Update.Transaction Unique ID).Extended Cost]
GTD From Entity Alternate Amount 1 [GTD From Entity Alternate Amount 1]=[Grain(GTD Transactions).Sum: GTD From Entity Alternate Amount 1]
GTD From Entity Alternate Amount 1 Currency Rate [GTD From Entity Alternate Amount 1 Currency Rate]=[Grain(GTD Transactions).Sum: GTD From Entity Alternate Amount 1 Currency Rate]
GTD From Entity Alternate Amount 2 [GTD From Entity Alternate Amount 2]=[Grain(GTD Transactions).Sum: GTD From Entity Alternate Amount 2]
GTD From Entity Alternate Amount 2 Currency Rate [GTD From Entity Alternate Amount 2 Currency Rate]=[Grain(GTD Transactions).Sum: GTD From Entity Alternate Amount 2 Currency Rate]
GTD From Entity Alternate Amount 3 [GTD From Entity Alternate Amount 3]=[Grain(GTD Transactions).Sum: GTD From Entity Alternate Amount 3]
GTD From Entity Alternate Amount 3 Currency Rate [GTD From Entity Alternate Amount 3 Currency Rate]=[Grain(GTD Transactions).Sum: GTD From Entity Alternate Amount 3 Currency Rate]
GTD From Entity Functional Amount [GTD From Entity Functional Amount]=[Grain(GTD Transactions).Sum: GTD From Entity Functional Amount]
GTD From Entity Functional Amount Currency Rate [GTD From Entity Functional Amount Currency Rate]= [Grain(GTD Transactions).Sum: GTD From Entity Functional Amount Currency Rate]
GTD Functional Amount [GTD Functional Amount]=[Grain(GTD Transactions).Sum: GTD Functional Amount]
GTD Functional Amount Currency Rate [GTD Functional Amount Currency Rate]=[Grain(GTD Transactions).Sum: GTD Functional Amount Currency Rate]
GTD Original Quantity [GTD Original Quantity]=NULL
GTD Project Amount [GTD Project Amount]=[Grain(GTD Transactions).Sum: GTD Project Amount]
GTD Project Amount Currency Rate [GTD Project Amount Currency Rate]=[Grain(GTD Transactions).Sum: GTD Project Amount Currency Rate]
GTD Quantity [GTD Quantity]=[Level(Cache Subsystem Transaction Detail Update.Transaction Unique ID).Quantity]
GTD Report Amount 1 [GTD Report Amount 1]=[Grain(GTD Transactions).Sum: GTD Report Amount 1]
GTD Report Amount 1 Currency Rate [GTD Report Amount 1 Currency Rate]=[Grain(GTD Transactions).Sum: GTD Report Amount 1 Currency Rate]
GTD Report Amount 2 [GTD Report Amount 2]=[Grain(GTD Transactions).Sum: GTD Report Amount 2]
GTD Report Amount 2 Currency Rate [GTD Report Amount 2 Currency Rate]=[Grain(GTD Transactions).Sum: GTD Report Amount 2 Currency Rate]
GTD Report Amount 3 [GTD Report Amount 3]=[Grain(GTD Transactions).Sum: GTD Report Amount 3]
GTD Report Amount 3 Currency Rate [GTD Report Amount 3 Currency Rate]=[Grain(GTD Transactions).Sum: GTD Report Amount 3 Currency Rate]
GTD Report Amount 4 [GTD Report Amount 4]=[Grain(GTD Transactions).Sum: GTD Report Amount 4]
GTD Report Amount 4 Currency Rate [GTD Report Amount 4 Currency Rate]=[Grain(GTD Transactions).Sum: GTD Report Amount 4 Currency Rate]
GTD Report Amount 5 [GTD Report Amount 5]=[Grain(GTD Transactions).Sum: GTD Report Amount 5]
GTD Report Amount 5 Currency Rate [GTD Report Amount 5 Currency Rate]=[Grain(GTD Transactions).Sum: GTD Report Amount 5 Currency Rate]
GTD Transaction Amount [GTD Transaction Amount]=[Grain(GTD Transactions).Sum: GTD Transaction Amount]
GTD Unit Cost [GTD Unit Cost]=[Level(Cache Subsystem Transaction Detail Update.Transaction Unique ID).Unit Cost]
GTD Units Amount [GTD Units Amount]=[Grain(GTD Transactions).Sum: GTD Units Amount]
Last Birst Update Stamp [Last Birst Update Stamp]=[v_BirstProcessTime]
SubSystem Linked Date [SubSystem Linked Date] = NOW
GTD Alternate Amount 1 [GTD Alternate Amount 1]=[Detail.GTD Alternate Amount 1]
GTD Alternate Amount 1 Currency Rate [GTD Alternate Amount 1 Currency Rate]=[Detail.GTD From Entity Alternate Amount 1 Currency Rate]
GTD Alternate Amount 2 [GTD Alternate Amount 2]=[Detail.GTD Alternate Amount 2]
GTD Alternate Amount 2 Currency Rate [GTD Alternate Amount 2 Currency Rate]=[Detail.GTD From Entity Alternate Amount 2 Currency Rate]
GTD Alternate Amount 3 [GTD Alternate Amount 3]=[Detail.GTD Alternate Amount 3]
GTD Alternate Amount 3 Currency Rate [GTD Alternate Amount 3 Currency Rate]=[Detail.GTD From Entity Alternate Amount 3 Currency Rate]
GTD Birst Load ID [GTD Birst Load ID] = [v_BirstLoadID]
GTD Extended Cost [GTD Extended Cost]=NULL
GTD From Entity Alternate Amount 1 [GTD From Entity Alternate Amount 1]=[Detail.GTD From Entity Alternate Amount 1]
GTD From Entity Alternate Amount 1 Currency Rate [GTD From Entity Alternate Amount 1 Currency Rate]=[Detail.GTD From Entity Alternate Amount 1 Currency Rate]
GTD From Entity Alternate Amount 2 [GTD From Entity Alternate Amount 3]=[Detail.GTD From Entity Alternate Amount 2]
GTD From Entity Alternate Amount 2 Currency Rate [GTD From Entity Alternate Amount 2 Currency Rate]=[Detail.GTD From Entity Alternate Amount 2 Currency Rate]
GTD From Entity Alternate Amount 3 [GTD From Entity Alternate Amount 3]=[Detail.GTD From Entity Alternate Amount 3]
GTD From Entity Alternate Amount 3 Currency Rate [GTD From Entity Alternate Amount 3 Currency Rate]=[Detail.GTD From Entity Alternate Amount 3 Currency Rate]
GTD From Entity Functional Amount [GTD From Entity Functional Amount]=[Detail.GTD From Entity Functional Amount]
GTD From Entity Functional Amount Currency Rate [GTD From Entity Functional Amount Currency Rate]=[Detail.GTD From Entity Functional Amount Currency Rate]
GTD Functional Amount [GTD Functional Amount]=[Detail.GTD Functional Amount]
GTD Functional Amount Currency Rate

IF [Detail.Accounting Entity]=[Detail.Journal Accounting Entity]

[GTD Functional Amount Currency Rate]=[Detail.GTD From Entity Functional Amount Currency Rate]

[GTD Alternate Amount 1 Currency Rate]=[Detail.GTD From Entity Alternate Amount 1 Currency Rate]

[GTD Alternate Amount 2 Currency Rate]=[Detail.GTD From Entity Alternate Amount 2 Currency Rate]

[GTD Alternate Amount 3 Currency Rate]=[Detail.GTD From Entity Alternate Amount 3 Currency Rate]

ELSE

[GTD Functional Amount Currency Rate]=[Detail.GTD Functional Amount Currency Rate]

[GTD Alternate Amount 1 Currency Rate]=[Detail.GTD Alternate Amount 1 Currency Rate]

[GTD Alternate Amount 2 Currency Rate]=[Detail.GTD Alternate Amount 2 Currency Rate]

[GTD Alternate Amount 3 Currency Rate]=[Detail.GTD Alternate Amount 3 Currency Rate]

END IF
GTD Original Quantity [GTD Original Quantity]=NULL
GTD Project Amount [GTD Project Amount]=[Detail.GTD Project Amount]
GTD Project Amount Currency Rate [GTD Project Amount Currency Rate]=[Detail.GTD Project Amount Currency Rate]
GTD Quantity [GTD Quantity]=NULL
GTD Report Amount 1 [GTD Report Amount 1]=[Detail.GTD Report Amount 1]
GTD Report Amount 1 Currency Rate [GTD Report Amount 1 Currency Rate]=[Detail.GTD Report Amount 1 Currency Rate]
GTD Report Amount 2 [GTD Report Amount 2]=[Detail.GTD Report Amount 2]
GTD Report Amount 2 Currency Rate [GTD Report Amount 2 Currency Rate]=[Detail.GTD Report Amount 2 Currency Rate]
GTD Report Amount 3 [GTD Report Amount 3]=[Detail.GTD Report Amount 3]
GTD Report Amount 3 Currency Rate [GTD Report Amount 3 Currency Rate]=[Detail.GTD Report Amount 3 Currency Rate]
GTD Report Amount 4 [GTD Report Amount 4]=[Detail.GTD Report Amount 4]
GTD Report Amount 4 Currency Rate [GTD Report Amount 4 Currency Rate]=[Detail.GTD Report Amount 4 Currency Rate]
GTD Report Amount 5 [GTD Report Amount 5]=[Detail.GTD Report Amount 5]
GTD Report Amount 5 Currency Rate [GTD Report Amount 5 Currency Rate]=[Detail.GTD Report Amount 5 Currency Rate]
GTD Transaction Amount [GTD Transaction Amount]=[Detail.GTD Transaction Amount]
GTD Unit Cost [GTD Unit Cost]=NULL
GTD Units Amount [GTD Units Amount]=[Detail.GTD Units Amount]
Last Birst Update Stamp [Last Birst Update Stamp]=[v_BirstProcessTime]
Project

IF [Detail.Project] IS NOT NULL THEN

[Project]=[Detail.Project]

ELSE

[Project]=[v_blankIdentifier]

END IF
Transaction Detail Load Date [Transaction Detail Load Date] = [v_BirstProcessTime]
Email Count [Email Count]=[Project Contract Invoice.Email Count]
Project Contract Invoice Adjustment Amount [Project Contract Invoice Adjustment Amount]=[Project Contract Invoice.Project Contract Invoice Adjustment Amount]
Project Contract Invoice Advance Amount [Project Contract Invoice Advance Amount]=[Project Contract Invoice.Project Contract Invoice Advance Amount]
Project Contract Invoice Allowance Amount [Project Contract Invoice Allowance Amount]=[Project Contract Invoice.Project Contract Invoice Allowance Amount]
Project Contract Invoice Amount [Project Contract Invoice Amount]=[Project Contract Invoice.Project Contract Invoice Amount]
Project Contract Invoice Fees Amount [Project Contract Invoice Fees Amount]=[Project Contract Invoice.Project Contract Invoice Fees Amount]
Project Contract Invoice Pass Through Amount [Project Contract Invoice Pass Through Amount]=[Project Contract Invoice.Project Contract Invoice Pass Through Amount]
Project Contract Invoice Retainage Amount [Project Contract Invoice Retainage Amount]=[Project Contract Invoice.Project Contract Invoice Retainage Amount]
Project Contract Invoice Retained Tax Amount [Project Contract Invoice Retained Tax Amount]=[Project Contract Invoice.Project Contract Invoice Retained Tax Amount]
Project Contract Invoice Retainer Amount [Project Contract Invoice Retainer Amount]=[Project Contract Invoice.Project Contract Invoice Retainer Amount]
Project Contract Invoice Tax Amount [Project Contract Invoice Tax Amount]=[Project Contract Invoice.Project Contract Invoice Tax Amount]
Project Contract Invoice Units Amount [Project Contract Invoice Units Amount]=[Project Contract Invoice.Project Contract Invoice Units Amount]
Invoice Date [Invoice Date]=[Level(Project Contract Invoice.Project Contract Invoice).Invoice Date]
Project Contract Invoice Line Amount [Project Contract Invoice Line Amount]= [Project Contract Invoice Line.Project Contract Invoice Line Amount]
Project Contract Invoice Line Amount Removed [Project Contract Invoice Line Amount Removed]= [Project Contract Invoice Line.Project Contract Invoice Line Amount Removed]
Project Contract Invoice Line Billable Amount [Project Contract Invoice Line Billable Amount]= [Project Contract Invoice Line.Project Contract Invoice Line Billable Amount]
Project Contract Invoice Line Billable Rate [Project Contract Invoice Line Billable Rate]= [Project Contract Invoice Line.Project Contract Invoice Line Billable Rate]
Project Contract Invoice Line Tax Amount [Project Contract Invoice Line Tax Amount]= [Project Contract Invoice Line.Project Contract Invoice Line Tax Amount]
Project Contract Invoice Line Units Amount [Project Contract Invoice Line Units Amount]= [Project Contract Invoice Line.Project Contract Invoice Line Units Amount]
Tax Rate [Tax Rate]= [Project Contract Invoice Line.Tax Rate]
Project Contract Milestone Amount [Project Contract Milestone Amount]=[Project Contract Milestone.Milestone Amount]
Project Contract Milestone Percent Complete [Project Contract Milestone Percent Complete]=[Project Contract Milestone.Percent Complete]
Project Contract Retainer Amount [Project Contract Retainer Amount]=[Project Contract Retainer.Amount]
Project Contract Retainer Applied Amount [Project Contract Retainer Applied Amount]=[Project Contract Retainer.Applied Amount]
Project Contract Amount [Project Contract Amount]=[Project Contract.Contract Amount]
Project Contract Budget Amount [Project Contract Budget Amount]=[Project Contract.Project Contract Budget Amount]
Project Contract Invoice Format [Project Contract Invoice Format]=[Project Contract.Project Contract Invoice Format]
Project Contract Markup Percent [Project Contract Markup Percent]=[Project Contract.Markup Percent]
Project Contract Maximum Fees [Project Contract Maximum Fees]=[Project Contract.Maximum Fees]
Project Contract Total Billed Allowance [Project Contract Total Billed Allowance]=[Project Contract.Total Billed Allowance]
Project Contract Total Billed Amount [Project Contract Total Billed Amount]=[Project Contract.Total Billed Amount]
Project Contract Total Billed Fees [Project Contract Total Billed Fees]=[Project Contract.Total Billed Fees]
Project Contract Total Recognized Allowance [Project Contract Total Recognized Allowance]=[Project Contract.Total Recognized Allowance]
Project Contract Total Recognized Amount [Project Contract Total Recognized Amount]=[Project Contract.Total Recognized Amount]
Project Contract Total Recognized Fees [Project Contract Total Recognized Fees]=[Project Contract.Total Recognized Fees]
Funding Source Allowance Percent [Funding Source Allowance Percent]= [Project Funding Source.Allowance Percent]
Funding Source Funded Amount [Funding Source Funded Amount]= [Project Funding Source.Funded Amount]
Funding Source Percent [Funding Source Percent]= [Project Funding Source.Percent]
Funding Source Total Billed Allowance [Funding Source Total Billed Allowance]= [Project Funding Source.Total Billed Allowance]
Funding Source Total Billed Amount [Funding Source Total Billed Amount]= [Project Funding Source.Total Billed Amount]
Funding Source Total Billed Fees [Funding Source Total Billed Fees]= [Project Funding Source.Total Billed Fees]
Funding Source Total Recognized Allowance [Funding Source Total Recognized Allowance]= [Project Funding Source.Total Recognized Allowance]
Funding Source Total Recognized Amount [Funding Source Total Recognized Amount]= [Project Funding Source.Total Recognized Amount]