ConsolidatedTrialBalance.xml

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<data-set>
  <relations format-version="3" relations-version="20160530" main-table="GIDesign">
    <link from="GIFilter (DesignID)" to="GIDesign (DesignID)" />
    <link from="GIGroupBy (DesignID)" to="GIDesign (DesignID)" />
    <link from="GIMassAction (DesignID)" to="GIDesign (DesignID)" />
    <link from="GIMassUpdateField (DesignID)" to="GIDesign (DesignID)" />
    <link from="GINavigationScreen (DesignID)" to="GIDesign (DesignID)" />
    <link from="GINavigationParameter (DesignID, ScreenID)" to="GINavigationScreen (DesignID, ScreenID)" />
    <link from="GIOn (DesignID, RelationNbr)" to="GIRelation (DesignID, LineNbr)" />
    <link from="GIRecordDefault (DesignID)" to="GIDesign (DesignID)" />
    <link from="GIRelation (DesignID, ParentTable)" to="GITable (DesignID, Alias)" />
    <link from="GIRelation (DesignID, ChildTable)" to="GITable (DesignID, Alias)" />
    <link from="GIResult (DesignID)" to="GIDesign (DesignID)" />
    <link from="GIResult (ObjectName, DesignID)" to="GITable (Alias, DesignID)" />
    <link from="GISort (DesignID)" to="GIDesign (DesignID)" />
    <link from="GITable (DesignID)" to="GIDesign (DesignID)" />
    <link from="GIWhere (DesignID)" to="GIDesign (DesignID)" />
    <link from="SiteMap (Url)" to="GIDesign (DesignID)" type="WeakByUrl" linkname="toDesignById" baseurl="~/GenericInquiry/GenericInquiry.aspx" paramnames="id" />
    <link from="SiteMap (Url)" to="GIDesign (Name)" type="WeakByUrl" linkname="toDesignByName" baseurl="~/GenericInquiry/GenericInquiry.aspx" />
    <link from="ListEntryPoint (ListScreenID)" to="SiteMap (ScreenID)" />
    <link from="SiteMap (ScreenID)" to="GIDesign (PrimaryScreenIDNew)" linkname="to1Screen" />
    <link from="SiteMap (NodeID)" to="SiteMap (ParentID)" type="WeakToParent" recursive-nesting="yes" include-parents="False" />
    <link from="GIDesign (NoteID)" to="Note (NoteID)" type="Note" />
    <link from="GIFilter (NoteID)" to="Note (NoteID)" type="Note" />
    <link from="GIFilter (NoteID)" to="GIFilterKvExt (RecordID)" type="RowKvExt" />
    <link from="GIGroupBy (NoteID)" to="Note (NoteID)" type="Note" />
    <link from="GIOn (NoteID)" to="Note (NoteID)" type="Note" />
    <link from="GIRelation (NoteID)" to="Note (NoteID)" type="Note" />
    <link from="GIResult (NoteID)" to="Note (NoteID)" type="Note" />
    <link from="GIResult (NoteID)" to="GIResultKvExt (RecordID)" type="RowKvExt" />
    <link from="GISort (NoteID)" to="Note (NoteID)" type="Note" />
    <link from="GITable (NoteID)" to="Note (NoteID)" type="Note" />
    <link from="GIWhere (NoteID)" to="Note (NoteID)" type="Note" />
  </relations>
  <layout>
    <table name="GIDesign">
      <table name="GIFilter" uplink="(DesignID) = (DesignID)">
        <table name="Note" uplink="(NoteID) = (NoteID)" />
        <table name="GIFilterKvExt" uplink="(NoteID) = (RecordID)" />
      </table>
      <table name="GIGroupBy" uplink="(DesignID) = (DesignID)">
        <table name="Note" uplink="(NoteID) = (NoteID)" />
      </table>
      <table name="GIMassAction" uplink="(DesignID) = (DesignID)" />
      <table name="GIMassUpdateField" uplink="(DesignID) = (DesignID)" />
      <table name="GINavigationScreen" uplink="(DesignID) = (DesignID)">
        <table name="GINavigationParameter" uplink="(DesignID, ScreenID) = (DesignID, ScreenID)" />
      </table>
      <table name="GIRecordDefault" uplink="(DesignID) = (DesignID)" />
      <table name="GISort" uplink="(DesignID) = (DesignID)">
        <table name="Note" uplink="(NoteID) = (NoteID)" />
      </table>
      <table name="GITable" uplink="(DesignID) = (DesignID)">
        <table name="GIRelation" uplink="(DesignID, Alias) = (DesignID, ParentTable)">
          <table name="GIOn" uplink="(DesignID, LineNbr) = (DesignID, RelationNbr)">
            <table name="Note" uplink="(NoteID) = (NoteID)" />
          </table>
          <table name="Note" uplink="(NoteID) = (NoteID)" />
        </table>
        <table name="GIResult" uplink="(Alias, DesignID) = (ObjectName, DesignID)">
          <table name="Note" uplink="(NoteID) = (NoteID)" />
          <table name="GIResultKvExt" uplink="(NoteID) = (RecordID)" />
        </table>
        <table name="Note" uplink="(NoteID) = (NoteID)" />
      </table>
      <table name="GIWhere" uplink="(DesignID) = (DesignID)">
        <table name="Note" uplink="(NoteID) = (NoteID)" />
      </table>
      <table name="SiteMap" uplink="(DesignID) = (Url)" recursion="(NodeID) = (ParentID)" linkname="toDesignById">
        <table name="ListEntryPoint" uplink="(ScreenID) = (ListScreenID)" />
      </table>
      <table name="SiteMap" uplink="(Name) = (Url)" recursion="(NodeID) = (ParentID)" linkname="toDesignByName">
        <table name="ListEntryPoint" uplink="(ScreenID) = (ListScreenID)" />
      </table>
      <table name="SiteMap" uplink="(PrimaryScreenIDNew) = (ScreenID)" recursion="(NodeID) = (ParentID)" linkname="to1Screen">
        <table name="ListEntryPoint" uplink="(ScreenID) = (ListScreenID)" />
      </table>
      <table name="Note" uplink="(NoteID) = (NoteID)" />
    </table>
  </layout>
  <data>
    <GIDesign>
      <row DesignID="0afa3dfa-8611-4e05-852f-9f407ed205ac" Name="TrialBalance" FilterColCount="3" PagerStyle="0" PageSize="0" NewRecordCreationEnabled="0" MassDeleteEnabled="0" AutoConfirmDelete="0" MassRecordsUpdateEnabled="0" MassActionsOnRecordsEnabled="0" ExposeViaOData="0">
        <GIFilter LineNbr="2" IsActive="1" Name="Period" FieldName="Last.finPeriodID" DataType="string" IsExpression="0" ColSpan="1" Required="0" />
        <GIFilter LineNbr="3" IsActive="1" Name="Ledger" FieldName="Last.ledgerID" DataType="string" IsExpression="0" ColSpan="1" Required="0" />
        <GIFilter LineNbr="4" IsActive="1" Name="SupressZero" FieldName="PX.Data.Maintenance.GI.CheckboxCombobox+checkbox" DataType="string" DisplayName="Supress Zero" IsExpression="1" DefaultValue="True" ColSpan="1" Required="0" />
        <GISort LineNbr="1" IsActive="1" DataFieldName="Account.accountCD" SortOrder="A" />
        <GISort LineNbr="2" IsActive="1" DataFieldName="Sub.subCD" SortOrder="A" />
        <GISort LineNbr="3" IsActive="1" DataFieldName="Ledger.ledgerCD" SortOrder="A" />
        <GISort LineNbr="4" IsActive="1" DataFieldName="GLHistoryByPeriod.finPeriodID" SortOrder="A" />
        <GITable Alias="Account" Name="PX.Objects.GL.Account">
          <GIRelation LineNbr="1" ChildTable="Ledger" IsActive="1" JoinType="I" />
          <GIResult LineNbr="1" IsActive="1" Field="accountCD" Caption="Account" Width="120" IsVisible="1" DefaultNav="1" />
          <GIResult LineNbr="2" IsActive="1" Field="description" Caption="Account Description" Width="200" IsVisible="1" DefaultNav="1" />
          <GIResult LineNbr="3" IsActive="1" Field="type" Width="100" IsVisible="1" DefaultNav="1" />
        </GITable>
        <GITable Alias="Branch" Name="PX.Objects.GL.Branch">
          <GIResult LineNbr="5" IsActive="1" Field="branchCD" Caption="Branch" Width="100" IsVisible="1" DefaultNav="1" />
        </GITable>
        <GITable Alias="Current" Name="PX.Objects.GL.GLHistory" />
        <GITable Alias="FinPeriod" Name="PX.Objects.GL.FinPeriod">
          <GIRelation LineNbr="3" ChildTable="GLHistoryByPeriod" IsActive="1" JoinType="L">
            <GIOn LineNbr="39" ParentField="=[Account.AccountID]" Condition="E " ChildField="accountID" Operation="A" />
            <GIOn LineNbr="40" ParentField="=[Ledger.LedgerID]" Condition="E " ChildField="ledgerID" Operation="A" />
            <GIOn LineNbr="41" ParentField="finPeriodID" Condition="E " ChildField="finPeriodID" Operation="A" />
          </GIRelation>
          <GIResult LineNbr="6" IsActive="1" Field="finPeriodID" Caption="Period" Width="100" IsVisible="1" DefaultNav="1" />
        </GITable>
        <GITable Alias="GLHistoryByPeriod" Name="PX.Objects.GL.GLHistoryByPeriod">
          <GIRelation LineNbr="4" ChildTable="Sub" IsActive="1" JoinType="L">
            <GIOn LineNbr="38" ParentField="subID" Condition="E " ChildField="subID" Operation="A" />
          </GIRelation>
          <GIRelation LineNbr="5" ChildTable="Current" IsActive="1" JoinType="L">
            <GIOn LineNbr="33" ParentField="ledgerID" Condition="E " ChildField="ledgerID" Operation="A" />
            <GIOn LineNbr="34" ParentField="accountID" Condition="E " ChildField="accountID" Operation="A" />
            <GIOn LineNbr="35" ParentField="subID" Condition="E " ChildField="subID" Operation="A" />
            <GIOn LineNbr="36" ParentField="finPeriodID" Condition="E " ChildField="finPeriodID" Operation="A" />
            <GIOn LineNbr="37" ParentField="branchID" Condition="E " ChildField="branchID" Operation="A" />
          </GIRelation>
          <GIRelation LineNbr="6" ChildTable="Last" IsActive="1" JoinType="L">
            <GIOn LineNbr="28" ParentField="ledgerID" Condition="E " ChildField="ledgerID" Operation="A" />
            <GIOn LineNbr="29" ParentField="accountID" Condition="E " ChildField="accountID" Operation="A" />
            <GIOn LineNbr="30" ParentField="subID" Condition="E " ChildField="subID" Operation="A" />
            <GIOn LineNbr="31" ParentField="lastActivityPeriod" Condition="E " ChildField="finPeriodID" Operation="A" />
            <GIOn LineNbr="32" ParentField="branchID" Condition="E " ChildField="branchID" Operation="A" />
          </GIRelation>
          <GIRelation LineNbr="7" ChildTable="Branch" IsActive="1" JoinType="L">
            <GIOn LineNbr="27" ParentField="branchID" Condition="E " ChildField="branchID" Operation="A" />
          </GIRelation>
          <GIRelation LineNbr="8" ChildTable="GLSetup" IsActive="1" JoinType="C" />
          <GIResult LineNbr="9" IsActive="1" Field="=IIF(([Account.Type] = 'I' Or [Account.Type] = 'L'), -1, 1) * IsNull([Last.FinYtdBalance],0)" Caption="YTD Balance" Width="130" IsVisible="1" DefaultNav="1" />
          <GIResult LineNbr="10" IsActive="1" Field="=IIF(([Account.Type] = 'I' Or [Account.Type] = 'L'), -1, 1) * IsNull([Last.CuryFinYtdBalance],0)" Caption="Cury YTD Balance" Width="130" IsVisible="1" DefaultNav="1" />
        </GITable>
        <GITable Alias="GLSetup" Name="PX.Objects.GL.GLSetup" />
        <GITable Alias="Last" Name="PX.Objects.GL.GLHistory">
          <GIResult LineNbr="8" IsActive="1" Field="curyID" Caption="Currency" Width="100" IsVisible="1" DefaultNav="1" />
        </GITable>
        <GITable Alias="Ledger" Name="PX.Objects.GL.Ledger">
          <GIRelation LineNbr="2" ChildTable="FinPeriod" IsActive="1" JoinType="I" />
          <GIResult LineNbr="4" IsActive="1" Field="ledgerCD" Caption="Ledger" Width="120" IsVisible="1" DefaultNav="1" />
        </GITable>
        <GITable Alias="Sub" Name="PX.Objects.GL.Sub">
          <GIResult LineNbr="7" IsActive="1" Field="subCD" Caption="Subaccount" Width="100" IsVisible="1" DefaultNav="1" />
        </GITable>
        <GIWhere LineNbr="3" IsActive="1" OpenBrackets="(        " DataFieldName="FinPeriod.finPeriodID" Condition="E " IsExpression="0" Value1="[Period]" Operation="O" />
        <GIWhere LineNbr="4" IsActive="1" DataFieldName="[Period]" Condition="NU" IsExpression="0" CloseBrackets=")        " Operation="A" />
        <GIWhere LineNbr="5" IsActive="1" OpenBrackets="(        " DataFieldName="Ledger.ledgerID" Condition="E " IsExpression="0" Value1="[Ledger]" Operation="O" />
        <GIWhere LineNbr="6" IsActive="1" DataFieldName="[Ledger]" Condition="NU" IsExpression="0" CloseBrackets=")        " Operation="A" />
        <GIWhere LineNbr="7" IsActive="1" OpenBrackets="(        " DataFieldName="Ledger.ledgerCD" Condition="NU" IsExpression="0" Operation="O" />
        <GIWhere LineNbr="8" IsActive="1" DataFieldName="Ledger.ledgerCD" Condition="E " IsExpression="1" Value1="DEGBP" Operation="O" />
        <GIWhere LineNbr="21" IsActive="1" DataFieldName="Ledger.ledgerCD" Condition="E " IsExpression="1" Value1="USGBP" CloseBrackets=")        " Operation="A" />
        <GIWhere LineNbr="22" IsActive="1" OpenBrackets="(        " DataFieldName="Account.type" Condition="E " IsExpression="1" Value1="A" Operation="O" />
        <GIWhere LineNbr="24" IsActive="1" DataFieldName="Account.type" Condition="E " IsExpression="1" Value1="L" Operation="O" />
        <GIWhere LineNbr="25" IsActive="1" DataFieldName="GLHistoryByPeriod.lastActivityPeriod" Condition="NU" IsExpression="0" Operation="O" />
        <GIWhere LineNbr="26" IsActive="1" DataFieldName="GLHistoryByPeriod.lastActivityPeriod" Condition="GE" IsExpression="0" Value1="=Left([GLHistoryByPeriod.FinPeriodID],4)+'01'" CloseBrackets=")        " Operation="A" />
        <GIWhere LineNbr="27" IsActive="1" DataFieldName="Account.accountID" Condition="NE" IsExpression="0" Value1="=[GLSetup.YtdNetIncAccountID]" Operation="A" />
        <GIWhere LineNbr="28" IsActive="1" OpenBrackets="(        " DataFieldName="[SupressZero]" Condition="E " IsExpression="0" Value1="=False" Operation="O" />
        <GIWhere LineNbr="29" IsActive="1" DataFieldName="GLHistoryByPeriod.lastActivityPeriod" Condition="NN" IsExpression="0" CloseBrackets=")        " Operation="A" />
        <SiteMap linkname="toDesignById">
          <row Position="5" Title="Trial Balance Detailed GBP" Url="~/GenericInquiry/GenericInquiry.aspx?id=0afa3dfa-8611-4e05-852f-9f407ed205ac" Expanded="0" IsFolder="0" ScreenID="GI000004" NodeID="4be43918-9b6d-4b3a-8939-949da7e7680d" ParentID="f1df9950-25ee-4fdc-99fa-ad1d8d814e93" />
        </SiteMap>
      </row>
    </GIDesign>
  </data>
</data-set>