Exportfile for AOT version 1.0 or later
Formatversion: 1
***Element: VPA
; Microsoft Dynamics AX VISUALSTUDIOPROJECT : EBCVendAgeingPaymReport unloaded
; --------------------------------------------------------------------------------
VERSION 1
VISUALSTUDIOPROJECT #EBCVendAgeingPaymReport
PROPERTIES
Name #EBCVendAgeingPaymReport
ProjectGUID #{CF6B9965-8932-4378-9040-0C676AEFBA38}
ProjectTypeGUID #{AA631830-3AD7-4631-8CF6-443A09BF983B}
VisualStudioProjectFile #EBCVendAgeingPaymReport.dynamicsproj
Origin #{25BBE35B-E9B6-4DB9-841D-8D18DDB64AA8}
ENDPROPERTIES
REFERENCEDPROJECTS
#
ENDREFERENCEDPROJECTS
VISUALSTUDIOPROJECTFOLDER #Project Content
PROPERTIES
Name #Project Content
ENDPROPERTIES
VISUALSTUDIOPROJECTFILE #EBCVendAgeingPaymReport.dynamicsproj
PROPERTIES
Name #EBCVendAgeingPaymReport.dynamicsproj
ENDPROPERTIES
SOURCE 2202
#<?xml version="1.0" encoding="utf-8"?>
#<Project ToolsVersion="4.0" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
# <PropertyGroup>
# <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
# <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
# <ProductVersion>6.3.3000.111</ProductVersion>
# <SchemaVersion>2.0</SchemaVersion>
# <ProjectGuid>cf6b9965-8932-4378-9040-0c676aefba38</ProjectGuid>
# <ProjectTypeGuids>{BF6F8E12-879D-49E7-ADF0-5503146B24B8};{aa631830-3ad7-4631-8cf6-443a09bf983b}</ProjectTypeGuids>
# <Name>EBCVendAgeingPaymReport</Name>
# <BaseAssemblyName>EBCVendAgeingPaymReport</BaseAssemblyName>
# <!-- Application property page properties -->
# <OutputType>Dynamics Reporting Library</OutputType>
# <!-- AssemblyInfo properties -->
# <AssemblyTitle>EBCVendAgeingPaymReport</AssemblyTitle>
# <AssemblyCompany>
# </AssemblyCompany>
# <AssemblyProduct>EBCVendAgeingPaymReport</AssemblyProduct>
# <AssemblyCopyright>Copyright © 2018</AssemblyCopyright>
# <TargetFrameworkVersion>v4.5</TargetFrameworkVersion>
# <FileAlignment>512</FileAlignment>
# <OutputPath>bin\Debug\</OutputPath>
# <DeployToServer>No</DeployToServer>
# <DeployToClient>No</DeployToClient>
# <DeployToEP>No</DeployToEP>
# <RootNamespace>EBCVendAgeingPaymReport</RootNamespace>
# <StartupElement />
# <DebugTarget>None</DebugTarget>
# </PropertyGroup>
# <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
# <OutputPath>bin\Debug\</OutputPath>
# </PropertyGroup>
# <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
# <OutputPath>bin\Release\</OutputPath>
# </PropertyGroup>
# <ItemGroup>
# <Compile Include="\SSRS Reports\Reports\EBCVendAgingPaym">
# <Virtual>True</Virtual>
# </Compile>
# </ItemGroup>
# <Import Project="$(MSBuildExtensionsPath)\Microsoft\DynamicsTools\Microsoft.Dynamics.Framework.Design.Reporting.Modeling.targets" />
# <Import Project="$(MSBuildExtensionsPath)\Microsoft\DynamicsTools\Microsoft.Dynamics.Framework.Design.InteractionProject.targets" />
#</Project>
ENDSOURCE
ENDVISUALSTUDIOPROJECTFILE
ENDVISUALSTUDIOPROJECTFOLDER
VISUALSTUDIOPROJECTFOLDER #Project Output
PROPERTIES
Name #Project Output
ENDPROPERTIES
ENDVISUALSTUDIOPROJECTFOLDER
ENDVISUALSTUDIOPROJECT
***Element: SRP
; Microsoft Dynamics AX REPORT : EBCVendAgingPaym unloaded
; --------------------------------------------------------------------------------
VERSION 1
REPORT #EBCVendAgingPaym
PROPERTIES
Name #EBCVendAgingPaym
Origin #{C9A779D7-C94C-4C3C-A039-1BB6ED1A6DD4}
ENDPROPERTIES
CROSSREFERENCES
#<CrossReferenceInfo>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymDP</ReferencedAotObjectName>
# <xrefKind>10</xrefKind>
# <XrefReference>2</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymDP.EBCVendAgingPaymTmp</ReferencedAotObjectName>
# <xrefKind>11</xrefKind>
# <XrefReference>4</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymDP.processReport</ReferencedAotObjectName>
# <xrefKind>11</xrefKind>
# <XrefReference>4</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.AccountNum</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp</ReferencedAotObjectName>
# <xrefKind>1</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.ClosingBalance</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.Correct</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.CreditAmount</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.DebitAmount</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.MainAccountName</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>@SYS7902</ReferencedAotObjectName>
# <xrefKind>19</xrefKind>
# <XrefReference>2</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaym</ReferencedAotObjectName>
# <xrefKind>39</xrefKind>
# <XrefReference>2</XrefReference>
# </CrossReferenceEntry>
#</CrossReferenceInfo>
ENDCROSSREFERENCES
MOXL 10866
#<?xml version="1.0" encoding="utf-8" ?>
#<Reports Version="6.2.15.0">
# <Report Name="EBCVendAgingPaym">
# <DataSet Name="VendAgingPaymDetails" DataSourceType="ReportDataProvider" Query="SELECT EBCVendAgingPaymTmp.1.AccountNum,EBCVendAgingPaymTmp.1.ClosingBalance,EBCVendAgingPaymTmp.1.Correct:NAME(NoYes),EBCVendAgingPaymTmp.1.Correct:LABEL(NoYes),EBCVendAgingPaymTmp.1.CreditAmount,EBCVendAgingPaymTmp.1.DebitAmount,EBCVendAgingPaymTmp.1.MainAccountName FROM EBCVendAgingPaymDP.EBCVendAgingPaymTmp">
# <DataSetField Name="AccountNum" Alias="EBCVendAgingPaymTmp.1.AccountNum" Caption="@SYS1996" DisplayWidth="Auto" UserDefined="False"/>
# <DataSetField Name="ClosingBalance" Alias="EBCVendAgingPaymTmp.1.ClosingBalance" Caption="@SYS6928" DataType="System.Double" DisplayWidth="Auto" UserDefined="False"/>
# <DataSetField Name="Correct" Alias="EBCVendAgingPaymTmp.1.Correct:NAME(NoYes)" Caption="@SYS13069" DisableAutoCreateInDataRegion="True" DisplayWidth="Auto" UserDefined="False"/>
# <DataSetField Name="Correct1" Alias="EBCVendAgingPaymTmp.1.Correct:LABEL(NoYes)" Caption="@SYS13069" DisplayWidth="Auto" UserDefined="False"/>
# <DataSetField Name="CreditAmount" Alias="EBCVendAgingPaymTmp.1.CreditAmount" Caption="@SYS6928" DataType="System.Double" DisplayWidth="Auto" UserDefined="False"/>
# <DataSetField Name="DebitAmount" Alias="EBCVendAgingPaymTmp.1.DebitAmount" Caption="@SYS6928" DataType="System.Double" DisplayWidth="Auto" UserDefined="False"/>
# <DataSetField Name="MainAccountName" Alias="EBCVendAgingPaymTmp.1.MainAccountName" Caption="@SYS9624" DisplayWidth="Auto" UserDefined="False"/>
# <DataSetParameter Name="AX_PartitionKey" Alias="AX_PartitionKey" DataType="System.String" Parameter=":EBCVendAgingPaym.Parameters.AX_PartitionKey"/>
# <DataSetParameter Name="AX_CompanyName" Alias="AX_CompanyName" DataType="System.String" Parameter=":EBCVendAgingPaym.Parameters.AX_CompanyName"/>
# <DataSetParameter Name="AX_UserContext" Alias="AX_UserContext" DataType="System.String" Parameter=":EBCVendAgingPaym.Parameters.AX_UserContext"/>
# <DataSetParameter Name="AX_RenderingCulture" Alias="AX_RenderingCulture" DataType="System.String" Parameter=":EBCVendAgingPaym.Parameters.AX_RenderingCulture"/>
# <DataSetParameter Name="AX_ReportContext" Alias="AX_ReportContext" DataType="System.String" Parameter=":EBCVendAgingPaym.Parameters.AX_ReportContext"/>
# <DataSetParameter Name="AX_RdpPreProcessedId" Alias="AX_RdpPreProcessedId" DataType="System.String" Parameter=":EBCVendAgingPaym.Parameters.AX_RdpPreProcessedId"/>
# <DataSetParameter Name="AsOn" Alias="AsOn" DataType="System.DateTime" Parameter=":EBCVendAgingPaym.Parameters.VendAgingPaymDetails_AsOn"/>
# <DataSetParameter Name="EBCVendAgingPaymDP_DynamicParameter" Alias="EBCVendAgingPaymDP_DynamicParameter" DataType="Microsoft.Dynamics.AX.Framework.Services.Client.QueryMetadata" Parameter=":EBCVendAgingPaym.Parameters.EBCVendAgingPaymDP_DynamicParameter"/>
# </DataSet>
# <ParameterGroup Name="Parameters">
# <Parameter Name="AX_PartitionKey" AllowBlank="True" Nullable="True" UserVisibility="Hidden"/>
# <Parameter Name="AX_CompanyName" UserVisibility="Hidden">
# <UnboundDefault Name="UnboundDefault" Value="=Microsoft.Dynamics.Framework.Reports.BuiltInMethods.GetUserCompany(Parameters!AX_UserContext.Value)"/>
# </Parameter>
# <Parameter Name="AX_UserContext" AllowBlank="True" Nullable="True" UserVisibility="Hidden"/>
# <Parameter Name="AX_RenderingCulture" AllowBlank="True" Nullable="True" UserVisibility="Hidden"/>
# <Parameter Name="AX_ReportContext" AllowBlank="True" Nullable="True" UserVisibility="Hidden"/>
# <Parameter Name="AX_RdpPreProcessedId" AllowBlank="True" Nullable="True" UserVisibility="Hidden"/>
# <Parameter Name="VendAgingPaymDetails_AsOn" DataType="System.DateTime" PromptString="@SYS7902"/>
# <Parameter Name="EBCVendAgingPaymDP_DynamicParameter" AllowBlank="True" AOTQuery="EBCVendAgingPaym" DataType="Microsoft.Dynamics.AX.Framework.Services.Client.QueryMetadata" Nullable="True" UserVisibility="Hidden"/>
# </ParameterGroup>
# <PrecisionDesign Name="Report" StyleTemplate=":TableStyleTemplate" Text="<?xml version="1.0" encoding="utf-8"?><Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"><rd:ExpressionDialog>Microsoft.Dynamics.Framework.Design.Reports.ExpressionEditor.ExpressionEditorDialog, Microsoft.Dynamics.Framework.Design.Reports</rd:ExpressionDialog><rd:SnapToGrid>true</rd:SnapToGrid><rd:DrawGrid>true</rd:DrawGrid><Page><BottomMargin>1in</BottomMargin><RightMargin>1in</RightMargin><LeftMargin>1in</LeftMargin><TopMargin>1in</TopMargin><InteractiveWidth>8.5in</InteractiveWidth><InteractiveHeight>11in</InteractiveHeight></Page><Body><Height>3.0in</Height></Body><Width>8.5in</Width><Language>en-US</Language><rd:ReportID>03bd922e-37d3-4701-821b-4c2aa643c400</rd:ReportID></Report>">
# <DisableIndividualTransformation Name="DisableIndividualTransformation"/>
# </PrecisionDesign>
# </Report>
#</Reports>
ENDMOXL
DESIGNS
SSRSREPORTDESIGN
PROPERTIES
Name #Report
ENDPROPERTIES
CROSSREFERENCES
#<CrossReferenceInfo>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymDP</ReferencedAotObjectName>
# <xrefKind>10</xrefKind>
# <XrefReference>2</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymDP.EBCVendAgingPaymTmp</ReferencedAotObjectName>
# <xrefKind>11</xrefKind>
# <XrefReference>4</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymDP.processReport</ReferencedAotObjectName>
# <xrefKind>11</xrefKind>
# <XrefReference>4</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.AccountNum</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp</ReferencedAotObjectName>
# <xrefKind>1</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.ClosingBalance</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.Correct</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.CreditAmount</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.DebitAmount</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.MainAccountName</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>@SYS7902</ReferencedAotObjectName>
# <xrefKind>19</xrefKind>
# <XrefReference>2</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaym</ReferencedAotObjectName>
# <xrefKind>39</xrefKind>
# <XrefReference>2</XrefReference>
# </CrossReferenceEntry>
#</CrossReferenceInfo>
ENDCROSSREFERENCES
RDL 17146
#<?xml version="1.0" encoding="utf-8"?>
#<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
# <rd:ExpressionDialog>Microsoft.Dynamics.Framework.Design.Reports.ExpressionEditor.ExpressionEditorDialog, Microsoft.Dynamics.Framework.Design.Reports</rd:ExpressionDialog>
# <rd:SnapToGrid>true</rd:SnapToGrid>
# <rd:DrawGrid>true</rd:DrawGrid>
# <Page>
# <BottomMargin>1in</BottomMargin>
# <RightMargin>1in</RightMargin>
# <LeftMargin>1in</LeftMargin>
# <TopMargin>1in</TopMargin>
# <InteractiveWidth>8.5in</InteractiveWidth>
# <InteractiveHeight>11in</InteractiveHeight>
# </Page>
# <Body>
# <Height>3.0in</Height>
# </Body>
# <Width>8.5in</Width>
# <Language>en-US</Language>
# <rd:ReportID>03bd922e-37d3-4701-821b-4c2aa643c400</rd:ReportID>
# <DataSources>
# <DataSource Name="AutoGen__ReportDataProvider">
# <Transaction>true</Transaction>
# <ConnectionProperties>
# <DataProvider>AXREPORTDATAPROVIDER</DataProvider>
# <ConnectString />
# <IntegratedSecurity>true</IntegratedSecurity>
# </ConnectionProperties>
# <rd:DataSourceID>5f70fabe-5273-4a11-93dc-ddea28522b36</rd:DataSourceID>
# </DataSource>
# </DataSources>
# <DataSets>
# <DataSet Name="VendAgingPaymDetails">
# <Fields>
# <Field Name="AccountNum">
# <DataField>EBCVendAgingPaymTmp.1.AccountNum</DataField>
# <rd:TypeName>System.String</rd:TypeName>
# </Field>
# <Field Name="ClosingBalance">
# <DataField>EBCVendAgingPaymTmp.1.ClosingBalance</DataField>
# <rd:TypeName>System.Double</rd:TypeName>
# </Field>
# <Field Name="Correct">
# <DataField>EBCVendAgingPaymTmp.1.Correct:NAME(NoYes)</DataField>
# <rd:TypeName>System.String</rd:TypeName>
# </Field>
# <Field Name="Correct1">
# <DataField>EBCVendAgingPaymTmp.1.Correct:LABEL(NoYes)</DataField>
# <rd:TypeName>System.String</rd:TypeName>
# </Field>
# <Field Name="CreditAmount">
# <DataField>EBCVendAgingPaymTmp.1.CreditAmount</DataField>
# <rd:TypeName>System.Double</rd:TypeName>
# </Field>
# <Field Name="DebitAmount">
# <DataField>EBCVendAgingPaymTmp.1.DebitAmount</DataField>
# <rd:TypeName>System.Double</rd:TypeName>
# </Field>
# <Field Name="MainAccountName">
# <DataField>EBCVendAgingPaymTmp.1.MainAccountName</DataField>
# <rd:TypeName>System.String</rd:TypeName>
# </Field>
# </Fields>
# <Query>
# <QueryParameters>
# <QueryParameter Name="AX_PartitionKey">
# <Value>=Parameters!AX_PartitionKey.Value</Value>
# </QueryParameter>
# <QueryParameter Name="AX_CompanyName">
# <Value>=Parameters!AX_CompanyName.Value</Value>
# </QueryParameter>
# <QueryParameter Name="AX_UserContext">
# <Value>=Parameters!AX_UserContext.Value</Value>
# </QueryParameter>
# <QueryParameter Name="AX_RenderingCulture">
# <Value>=Parameters!AX_RenderingCulture.Value</Value>
# </QueryParameter>
# <QueryParameter Name="AX_ReportContext">
# <Value>=Parameters!AX_ReportContext.Value</Value>
# </QueryParameter>
# <QueryParameter Name="AX_RdpPreProcessedId">
# <Value>=Parameters!AX_RdpPreProcessedId.Value</Value>
# </QueryParameter>
# <QueryParameter Name="AsOn">
# <Value>=Parameters!VendAgingPaymDetails_AsOn.Value</Value>
# </QueryParameter>
# <QueryParameter Name="EBCVendAgingPaymDP_DynamicParameter">
# <Value>=Parameters!EBCVendAgingPaymDP_DynamicParameter.Value</Value>
# </QueryParameter>
# </QueryParameters>
# <DataSourceName>AutoGen__ReportDataProvider</DataSourceName>
# <CommandType>Text</CommandType>
# <CommandText>SELECT EBCVendAgingPaymTmp.1.AccountNum,EBCVendAgingPaymTmp.1.ClosingBalance,EBCVendAgingPaymTmp.1.Correct:NAME(NoYes),EBCVendAgingPaymTmp.1.Correct:LABEL(NoYes),EBCVendAgingPaymTmp.1.CreditAmount,EBCVendAgingPaymTmp.1.DebitAmount,EBCVendAgingPaymTmp.1.MainAccountName FROM EBCVendAgingPaymDP.EBCVendAgingPaymTmp</CommandText>
# <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
# </Query>
# <rd:DataSetInfo>
# <rd:TableAdapterGetDataMethod>GetData</rd:TableAdapterGetDataMethod>
# <rd:DataSetName>VendAgingPaymDetails</rd:DataSetName>
# <rd:TableAdapterFillMethod>Fill</rd:TableAdapterFillMethod>
# <rd:TableAdapterName>FieldsTableAdapter</rd:TableAdapterName>
# <rd:TableName>Fields</rd:TableName>
# </rd:DataSetInfo>
# </DataSet>
# </DataSets>
# <ReportParameters>
# <ReportParameter Name="AX_PartitionKey">
# <DataType>String</DataType>
# <Nullable>true</Nullable>
# <Hidden>true</Hidden>
# <AllowBlank>true</AllowBlank>
# <Prompt>AX_PartitionKey</Prompt>
# <MultiValue>false</MultiValue>
# </ReportParameter>
# <ReportParameter Name="AX_UserContext">
# <DataType>String</DataType>
# <Nullable>true</Nullable>
# <Hidden>true</Hidden>
# <AllowBlank>true</AllowBlank>
# <Prompt>AX_UserContext</Prompt>
# <MultiValue>false</MultiValue>
# </ReportParameter>
# <ReportParameter Name="AX_CompanyName">
# <DataType>String</DataType>
# <Nullable>false</Nullable>
# <Hidden>true</Hidden>
# <DefaultValue>
# <Values>
# <Value>=Microsoft.Dynamics.Framework.Reports.BuiltInMethods.GetUserCompany(Parameters!AX_UserContext.Value)</Value>
# </Values>
# </DefaultValue>
# <AllowBlank>false</AllowBlank>
# <Prompt>AX_CompanyName</Prompt>
# <MultiValue>false</MultiValue>
# </ReportParameter>
# <ReportParameter Name="AX_RenderingCulture">
# <DataType>String</DataType>
# <Nullable>true</Nullable>
# <Hidden>true</Hidden>
# <AllowBlank>true</AllowBlank>
# <Prompt>AX_RenderingCulture</Prompt>
# <MultiValue>false</MultiValue>
# </ReportParameter>
# <ReportParameter Name="AX_ReportContext">
# <DataType>String</DataType>
# <Nullable>true</Nullable>
# <Hidden>true</Hidden>
# <AllowBlank>true</AllowBlank>
# <Prompt>AX_ReportContext</Prompt>
# <MultiValue>false</MultiValue>
# <UsedInQuery>True</UsedInQuery>
# </ReportParameter>
# <ReportParameter Name="AX_RdpPreProcessedId">
# <DataType>String</DataType>
# <Nullable>true</Nullable>
# <Hidden>true</Hidden>
# <AllowBlank>true</AllowBlank>
# <Prompt>AX_RdpPreProcessedId</Prompt>
# <MultiValue>false</MultiValue>
# </ReportParameter>
# <ReportParameter Name="VendAgingPaymDetails_AsOn">
# <DataType>DateTime</DataType>
# <Nullable>false</Nullable>
# <Hidden>false</Hidden>
# <AllowBlank>false</AllowBlank>
# <Prompt>As on</Prompt>
# <MultiValue>false</MultiValue>
# </ReportParameter>
# <ReportParameter Name="EBCVendAgingPaymDP_DynamicParameter">
# <DataType>String</DataType>
# <Nullable>true</Nullable>
# <Hidden>true</Hidden>
# <AllowBlank>true</AllowBlank>
# <Prompt>EBCVendAgingPaymDP_DynamicParameter</Prompt>
# <MultiValue>false</MultiValue>
# </ReportParameter>
# </ReportParameters>
# <CodeModules>
# <CodeModule>Microsoft.Dynamics.Framework.Reports, Version=6.3.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35</CodeModule>
# <CodeModule>Microsoft.Dynamics.Framework.Metadata.AX, Version=6.3.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35</CodeModule>
# </CodeModules>
# <Code>Protected Overrides Sub OnInit()
# Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ReportInitialize()
#End Sub
#
#</Code>
# <CustomProperties>
# <CustomProperty>
# <Name>DynamicParameterAOTQueryName_EBCVendAgingPaymDP_DynamicParameter</Name>
# <Value>EBCVendAgingPaym</Value>
# </CustomProperty>
# <CustomProperty>
# <Name>DATASETSFIELDS</Name>
# <Value><![CDATA[VendAgingPaymDetails:AccountNum.EBCVendAgingPaymTmp.AccountNum;ClosingBalance.EBCVendAgingPaymTmp.ClosingBalance;Correct.EBCVendAgingPaymTmp.Correct;Correct1.EBCVendAgingPaymTmp.Correct;CreditAmount.EBCVendAgingPaymTmp.CreditAmount;DebitAmount.EBCVendAgingPaymTmp.DebitAmount;MainAccountName.EBCVendAgingPaymTmp.MainAccountName]]></Value>
# </CustomProperty>
# </CustomProperties>
#</Report>
ENDRDL
PERMISSIONSET #Permissions
PROPERTIES
ENDPROPERTIES
TABLES #Tables
ENDTABLES
SERVERMETHODS #Server Methods
ENDSERVERMETHODS
ASSOCIATEDFORMS #Associated Forms
ENDASSOCIATEDFORMS
ENDPERMISSIONSET
ENDSSRSREPORTDESIGN
ENDDESIGNS
ENDREPORT
***Element: CLS
; Microsoft Dynamics AX Class: VendDueAmountAnalysisContract_CN unloaded
; --------------------------------------------------------------------------------
CLSVERSION 1
CLASS #VendDueAmountAnalysisContract_CN
PROPERTIES
Name #VendDueAmountAnalysisContract_CN
Origin #{45253A72-5621-441C-8AD9-C85812BB2F66}
ENDPROPERTIES
METHODS
SOURCE #classDeclaration
#/// <summary>
#/// The <c>VendDueAmountAnalysisContract_CN</c> is contract class for <c>VendDueAmountAnalysis_CN</c> SSRS report.
#/// </summary>
#[DataContractAttribute]
#public class VendDueAmountAnalysisContract_CN
#{
# TransDate asOn;
#}
#
ENDSOURCE
SOURCE #parmAsOn
#/// <summary>
#/// Gets or sets the value of the datacontract parameter asOn.
#/// </summary>
#/// <param name="_asOn">
#/// The new value of the datacontract parameter asOn.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter asOn.
#/// </returns>
#[
# DataMemberAttribute('AsOn'),
# SysOperationLabelAttribute(literalstr("@SYS7902")),
# SysOperationHelpTextAttribute(literalstr("@SYS7902"))
#]
#public TransDate parmAsOn(TransDate _asOn = asOn)
#{
# asOn = _asOn;
# return asOn;
#}
ENDSOURCE
ENDMETHODS
ENDCLASS
***Element: DBT
; Microsoft Dynamics AX Table : CustVendBalanceTmp_CN unloaded
; --------------------------------------------------------------------------------
TABLEVERSION 1
TABLE #CustVendBalanceTmp_CN
EnforceFKRelation 1
PROPERTIES
Name #CustVendBalanceTmp_CN
Label #@GLS107030
TableType #InMemory
ConfigurationKey #LedgerBasic
MaxAccessMode #NoAccess
Visible #No
CreateRecIdIndex #Yes
PrimaryIndex #SurrogateKey
ClusterIndex #SurrogateKey
DeveloperDocumentation #@GLS100103
CountryRegionCodes #CN
Origin #{66BA81D0-C2A8-4470-B623-1F4C030EE74D}
ENDPROPERTIES
FIELDS
FIELD #AccountNum
STRING
PROPERTIES
Name #AccountNum
Table #CustVendBalanceTmp_CN
Origin #{53F7AA0C-3633-4520-B1A1-0F3E57C4954F}
ExtendedDataType #AccountNum
StringSize #20
ENDPROPERTIES
FIELD #ClosingBalance
REAL
PROPERTIES
Name #ClosingBalance
Table #CustVendBalanceTmp_CN
Origin #{54F1C519-3FC7-4B30-B72E-D4CB42D1DE42}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Correct
ENUM
PROPERTIES
Name #Correct
Table #CustVendBalanceTmp_CN
Origin #{D2C39FF9-A7A7-42EB-AE53-B20194E35E9F}
ExtendedDataType #Correct
EnumType #NoYes
ENDPROPERTIES
FIELD #CreditAmount
REAL
PROPERTIES
Name #CreditAmount
Table #CustVendBalanceTmp_CN
Origin #{C0BA3B78-89A8-4822-8406-56F3D0626C6D}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #DebitAmount
REAL
PROPERTIES
Name #DebitAmount
Table #CustVendBalanceTmp_CN
Origin #{8047937A-89E2-463D-B599-08AAD3C70E39}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #MainAccountName
STRING
PROPERTIES
Name #MainAccountName
Table #CustVendBalanceTmp_CN
Origin #{0120E1EB-DA64-4DFD-BCCE-61E1B6CAD725}
ExtendedDataType #AccountName
StringSize #60
ENDPROPERTIES
FIELD #MainAccountNum
STRING
PROPERTIES
Name #MainAccountNum
Table #CustVendBalanceTmp_CN
Origin #{DF0033B4-AE8D-461D-96E2-BDD18065CEAB}
ExtendedDataType #MainAccountNum
StringSize #20
ENDPROPERTIES
FIELD #OpeningBalance
REAL
PROPERTIES
Name #OpeningBalance
Table #CustVendBalanceTmp_CN
Origin #{266D7A2F-A6F6-487A-94FE-D2514C3668DA}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #PartyAccountName
STRING
PROPERTIES
Name #PartyAccountName
Table #CustVendBalanceTmp_CN
Origin #{CA987529-208A-48A6-98AA-3EAE1E6165DC}
ExtendedDataType #DirPartyName
StringSize #100
ENDPROPERTIES
FIELD #PeriodCode
STRING
PROPERTIES
Name #PeriodCode
Table #CustVendBalanceTmp_CN
Origin #{351F7C3F-8D8B-47C8-995A-39BCE0BC5F29}
ExtendedDataType #String255
StringSize #255
ENDPROPERTIES
FIELD #TransDate
DATE
PROPERTIES
Name #TransDate
Table #CustVendBalanceTmp_CN
Origin #{8CD76EF3-042B-4A52-94E7-639619CB10B9}
ExtendedDataType #TransDate
ENDPROPERTIES
ENDFIELDS
GROUPS
ENDGROUPS
INDICES
ENDINDICES
FULLTEXTINDICES
ENDFULLTEXTINDICES
REFERENCES
REFERENCE #MainAccount
PROPERTIES
Name #MainAccount
Table #MainAccount
RelatedTableCardinality #ZeroOne
Cardinality #ZeroMore
RelationshipType #Association
UseDefaultRoleNames #Yes
EDTRelation #Yes
ENDPROPERTIES
FIELDREFERENCES
REFERENCETYPE NORMAL
PROPERTIES
Field #MainAccountNum
RelatedField #MainAccountId
SourceEDT #MainAccountNum
ENDPROPERTIES
ENDFIELDREFERENCES
ENDREFERENCE
ENDREFERENCES
DELETEACTIONS
ENDDELETEACTIONS
METHODS
ENDMETHODS
ENDTABLE
***Element: DBT
; Microsoft Dynamics AX Table : EBCVendAgingPaymTmp unloaded
; --------------------------------------------------------------------------------
TABLEVERSION 1
TABLE #EBCVendAgingPaymTmp
EnforceFKRelation 1
PROPERTIES
Name #EBCVendAgingPaymTmp
Label #@GLS107030
TableType #InMemory
ConfigurationKey #LedgerBasic
MaxAccessMode #NoAccess
Visible #No
CreateRecIdIndex #Yes
PrimaryIndex #SurrogateKey
ClusterIndex #SurrogateKey
DeveloperDocumentation #@GLS100103
CountryRegionCodes #CN
Origin #{2C078D35-860D-4E5F-93C8-26E9CC45AD5B}
ENDPROPERTIES
FIELDS
FIELD #AccountNum
STRING
PROPERTIES
Name #AccountNum
Table #EBCVendAgingPaymTmp
Origin #{F2CE0A30-7467-4C8D-8DFC-515498B901C8}
ExtendedDataType #AccountNum
StringSize #20
ENDPROPERTIES
FIELD #ClosingBalance
REAL
PROPERTIES
Name #ClosingBalance
Table #EBCVendAgingPaymTmp
Origin #{138B2C34-C618-480A-9721-477CEEFD5A9B}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Correct
ENUM
PROPERTIES
Name #Correct
Table #EBCVendAgingPaymTmp
Origin #{758A866A-BD01-4234-86C5-E1DB85D8071B}
ExtendedDataType #Correct
EnumType #NoYes
ENDPROPERTIES
FIELD #CreditAmount
REAL
PROPERTIES
Name #CreditAmount
Table #EBCVendAgingPaymTmp
Origin #{3C927268-98A9-4922-88B1-D080BD4178B7}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #DebitAmount
REAL
PROPERTIES
Name #DebitAmount
Table #EBCVendAgingPaymTmp
Origin #{8F79427A-99E8-4C4D-A77E-82DCBEFA9D3A}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #MainAccountName
STRING
PROPERTIES
Name #MainAccountName
Table #EBCVendAgingPaymTmp
Origin #{7627E036-7CCB-46CD-8086-C0D65B80F483}
ExtendedDataType #AccountName
StringSize #60
ENDPROPERTIES
FIELD #MainAccountNum
STRING
PROPERTIES
Name #MainAccountNum
Table #EBCVendAgingPaymTmp
Origin #{96D2DD32-8165-4CA8-B9B9-9E76AE627C1C}
ExtendedDataType #MainAccountNum
StringSize #20
ENDPROPERTIES
FIELD #OpeningBalance
REAL
PROPERTIES
Name #OpeningBalance
Table #EBCVendAgingPaymTmp
Origin #{33637E69-8DA7-408B-BEB6-7A559E68409B}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #PartyAccountName
STRING
PROPERTIES
Name #PartyAccountName
Table #EBCVendAgingPaymTmp
Origin #{E1F61501-F689-466A-92FD-ADCC9F9AFE86}
ExtendedDataType #DirPartyName
StringSize #100
ENDPROPERTIES
FIELD #PeriodCode
STRING
PROPERTIES
Name #PeriodCode
Table #EBCVendAgingPaymTmp
Origin #{682E5027-A9ED-443F-BB8D-FFC95AF6486A}
ExtendedDataType #String255
StringSize #255
ENDPROPERTIES
FIELD #TransDate
DATE
PROPERTIES
Name #TransDate
Table #EBCVendAgingPaymTmp
Origin #{A3632585-2660-4CD3-A6F1-6AA9E3CD8C8E}
ExtendedDataType #TransDate
ENDPROPERTIES
ENDFIELDS
GROUPS
ENDGROUPS
INDICES
ENDINDICES
FULLTEXTINDICES
ENDFULLTEXTINDICES
REFERENCES
REFERENCE #MainAccount
PROPERTIES
Name #MainAccount
Table #MainAccount
RelatedTableCardinality #ZeroOne
Cardinality #ZeroMore
RelationshipType #Association
UseDefaultRoleNames #Yes
EDTRelation #Yes
ENDPROPERTIES
FIELDREFERENCES
REFERENCETYPE NORMAL
PROPERTIES
Field #MainAccountNum
RelatedField #MainAccountId
ENDPROPERTIES
ENDFIELDREFERENCES
ENDREFERENCE
ENDREFERENCES
DELETEACTIONS
ENDDELETEACTIONS
METHODS
ENDMETHODS
ENDTABLE
***Element: CLS
; Microsoft Dynamics AX Class: VendBalanceDP_CN unloaded
; --------------------------------------------------------------------------------
CLSVERSION 1
CLASS #VendBalanceDP_CN
PROPERTIES
Name #VendBalanceDP_CN
Extends #SRSReportDataProviderBase
RunOn #Server
Origin #{A9A35685-2374-4837-AA7A-3B53CE2B3D89}
ENDPROPERTIES
METHODS
SOURCE #classDeclaration
#/// <summary>
#/// The <c>VendBalanceDP_CN</c> is the
#/// data provider class for <c>VendBalance_CN</c> report.
#/// </summary>
#/// <remarks>
#/// The <c>CustBalanceDP_CN</c> and <c>VendBalanceDP_CN</c> use
#/// similar logic, so any change in one class requires the other class to be changed.
#/// </remarks>
#[
# SRSReportQueryAttribute(queryStr(VendBalance_CN)),
# SRSReportParameterAttribute(classStr(LedgerFiscalPeriodNameContract_CN))
#]
#public class VendBalanceDP_CN extends SRSReportDataProviderBase
#{
# CustVendBalanceTmp_CN custVendBalanceTmp_CN;
#}
ENDSOURCE
SOURCE #getCustVendBalanceTmp_CN
#/// <summary>
#/// Retrieves the data used by <c>VendBalance_CN</c> report.
#/// </summary>
#/// <returns>
#/// Temporary table <c>CustVendBalanceTmp_CN</c>.
#/// </returns>
#[ SRSReportDataSetAttribute(tableStr(CustVendBalanceTmp_CN)) ]
#public CustVendBalanceTmp_CN getCustVendBalanceTmp_CN()
#{
# return custVendBalanceTmp_CN;
#}
ENDSOURCE
SOURCE #insertCustVendBalanceTmp_CN
#/// <summary>
#/// Inserts records into <c>CustVendBalanceTmp_CN</c> table.
#/// </summary>
#/// <param name="_mainAccount">
#/// Assigns a value to MainAccountNum field of above mentioned table.
#/// </param>
#/// <param name="_mainAccountName">
#/// Assigns a value to MainAccountName field of above mentioned table.
#/// </param>
#/// <param name="_vendAccountNum">
#/// Assigns a value to AccountNum field of above mentioned table.
#/// </param>
#/// <param name="_dirPartyName">
#/// Assigns a value to PartyAccountName field of above mentioned table.
#/// </param>
#/// <param name="_openingBalance">
#/// Assigns a value to OpeningBalance field of above mentioned table.
#/// </param>
#/// <param name="_debitBalance">
#/// Assigns a value to DebitAmount field of above mentioned table.
#/// </param>
#/// <param name="_creditBalance">
#/// Assigns a value to CreditAmount field of above mentioned table.
#/// </param>
#/// <param name="_periodCode">
#/// Sends period code of the ledger period selected.
#/// </param>
#private void insertCustVendBalanceTmp_CN(
# MainAccountNum _mainAccount,
# AccountName _mainAccountName,
# AccountNum _vendAccountNum,
# DirPartyName _dirPartyName,
# AmountMST _openingBalance,
# AmountMST _debitBalance,
# AmountMST _creditBalance,
# String255 _periodCode)
#{
# custVendBalanceTmp_CN.AccountNum = _vendAccountNum;
# custVendBalanceTmp_CN.PartyAccountName = _dirPartyName;
# custVendBalanceTmp_CN.MainAccountNum = _mainAccount;
# custVendBalanceTmp_CN.MainAccountName = _mainAccountName;
# custVendBalanceTmp_CN.OpeningBalance = _openingBalance;
# custVendBalanceTmp_CN.DebitAmount = _debitBalance;
# custVendBalanceTmp_CN.CreditAmount = -_creditBalance;
# custVendBalanceTmp_CN.PeriodCode = _periodCode;
# custVendBalanceTmp_CN.ClosingBalance = _openingBalance + _debitBalance + _creditBalance;
# custVendBalanceTmp_CN.insert();
#}
ENDSOURCE
SOURCE #processReport
#[SysEntryPointAttribute]
#public void processReport()
#{
# VendTable vendTable;
# VendTrans vendTrans;
# MainAccount mainAccount;
# TransDate currentTransDate, fromdate, todate;
# AccountNum curVendAccountNum;
# MainAccountNum curMainAccountNum;
# Name mainAccountName;
# DirPartyName vendAccountName;
# Query query;
# QueryRun queryRun;
# AmountMST openingBalance, creditBalance, debitBalance;
# LedgerFiscalPeriodNameContract_CN contract;
# CustVendBalanceTmp_CN localCopy;
# LedgerDimensionDefaultAccount defaultAccount;
# DimensionAttributeValueCombination dimensionAttribute;
# String255 periodCode, fromPeriodName, toPeriodName;
# FiscalCalendarPeriod currFiscalPeriod;
#
# query = this.parmQuery();
# contract = this.parmDataContract() as LedgerFiscalPeriodNameContract_CN;
#
# if ( !contract.parmFromDate() || !contract.parmToDate())
# {
# currFiscalPeriod = FiscalCalendarPeriod::currentLedgePeriod_CN();
# }
#
# fromdate = (contract.parmFromDate()) ? contract.parmFromDate() : currFiscalPeriod.StartDate;
# todate = (contract.parmToDate()) ? contract.parmToDate() : currFiscalPeriod.EndDate;
# fromPeriodName = (contract.parmFromPeriod()) ? contract.parmFromPeriod() : currFiscalPeriod.Name;
# toPeriodName = (contract.parmToPeriod()) ? contract.parmToPeriod() : currFiscalPeriod.Name;
# periodCode = fromPeriodName + '-' + toPeriodName;
#
# query.dataSourceTable(tableNum(VendTrans)).addRange(fieldNum(VendTrans, TransDate)).value(
# SysQuery::range(dateNull(), todate));
# queryRun = new queryRun(query);
# while (queryRun.next())
# {
# vendTable = queryRun.get(tableNum(VendTable));
# vendTrans = queryRun.get(tableNum(VendTrans));
#
# localCopy.AccountNum = vendTable.AccountNum;
# localCopy.PartyAccountName = DirPartyTable::getName(vendTable.Party);
# localCopy.TransDate = vendTrans.TransDate;
# localCopy.CreditAmount = vendTrans.AmountMST;
# localCopy.Correct = vendTrans.Correct;
# defaultAccount = VendLedgerAccounts::summaryLedgerDimension(
# vendTable.AccountNum,
# vendTrans.PostingProfile);
#
# dimensionAttribute = DimensionAttributeValueCombination::find(defaultAccount);
# mainAccount = mainAccount::find(dimensionAttribute.MainAccount);
# localCopy.MainAccountName = mainAccount.localizedName();
# localCopy.MainAccountNum = mainAccount.MainAccountId;
# localCopy.insert();
# }
#
# while select * from localCopy
# order by localCopy.AccountNum, localCopy.MainAccountName, localCopy.TransDate asc
# {
#
# currentTransDate = localCopy.TransDate;
#
# if (!curVendAccountNum && !curMainAccountNum)
# {
# curMainAccountNum = localCopy.MainAccountNum;
# curVendAccountNum = localCopy.AccountNum;
# mainAccountName = localCopy.MainAccountName;
# vendAccountName = localCopy.PartyAccountName;
# }
#
# if (curVendAccountNum == localCopy.AccountNum
# && curMainAccountNum == localCopy.MainAccountNum )
# {
# if (currentTransDate < fromdate)
# {
# openingBalance += localCopy.CreditAmount ;
# }
# else
# {
# creditBalance += ((localCopy.CreditAmount <= 0 || (localCopy.CreditAmount > 0 && localCopy.Correct)) ? localCopy.CreditAmount : 0.00);
# debitBalance += ((localCopy.CreditAmount > 0 && !localCopy.Correct) ? localCopy.CreditAmount : 0.00);
# }
# }
# else
# {
# this.insertCustVendBalanceTmp_CN(
# curMainAccountNum,
# mainAccountName,
# curVendAccountNum,
# vendAccountName,
# openingBalance,
# debitBalance,
# creditBalance,
# periodCode);
#
# curMainAccountNum = localCopy.MainAccountNum;
# curVendAccountNum = localCopy.AccountNum;
# mainAccountName = localCopy.MainAccountName;
# vendAccountName = localCopy.PartyAccountName;
# creditBalance = 0.00;
# debitBalance = 0.00;
# openingBalance = 0.00;
# if (currentTransDate < fromdate)
# {
# openingBalance = localCopy.CreditAmount ;
# }
# else
# {
# creditBalance = ((localCopy.CreditAmount <= 0 || (localCopy.CreditAmount > 0 && localCopy.Correct)) ? localCopy.CreditAmount : 0.00);
# debitBalance = ((localCopy.CreditAmount > 0 && !localCopy.Correct) ? localCopy.CreditAmount : 0.00);
# }
# }
# }
# // for the last record
# this.insertCustVendBalanceTmp_CN(
# curMainAccountNum,
# mainAccountName,
# curVendAccountNum,
# vendAccountName,
# openingBalance,
# debitBalance,
# creditBalance,
# periodCode);
#} //End for process report
ENDSOURCE
ENDMETHODS
ENDCLASS
***Element: CLS
; Microsoft Dynamics AX Class: EBCVendAgingPaymDP unloaded
; --------------------------------------------------------------------------------
CLSVERSION 1
CLASS #EBCVendAgingPaymDP
PROPERTIES
Name #EBCVendAgingPaymDP
Extends #SRSReportDataProviderBase
RunOn #Server
Origin #{CA5C2AA5-BFCF-48F2-A815-DEA63AADC456}
ENDPROPERTIES
METHODS
SOURCE #classDeclaration
#/// <summary>
#/// The <c>VendBalanceDP_CN</c> is the
#/// data provider class for <c>VendBalance_CN</c> report.
#/// </summary>
#/// <remarks>
#/// The <c>CustBalanceDP_CN</c> and <c>VendBalanceDP_CN</c> use
#/// similar logic, so any change in one class requires the other class to be changed.
#/// </remarks>
#[
# SRSReportQueryAttribute(queryStr(EBCVendAgingPaym)),
# SRSReportParameterAttribute(classStr(EBCVendAgingPaymContract))
#]
#public class EBCVendAgingPaymDP extends SRSReportDataProviderBase
#{
# EBCVendAgingPaymTmp vendAgingPaymTmp;
#}
ENDSOURCE
SOURCE #getVendAgingPaymTmp
#/// <summary>
#/// Retrieves the data used by <c>VendBalance_CN</c> report.
#/// </summary>
#/// <returns>
#/// Temporary table <c>CustVendBalanceTmp_CN</c>.
#/// </returns>
#[ SRSReportDataSetAttribute(tableStr(EBCVendAgingPaymTmp)) ]
#public EBCVendAgingPaymTmp getVendAgingPaymTmp()
#{
# return vendAgingPaymTmp;
#}
ENDSOURCE
SOURCE #insertCustVendBalanceTmp_CN
#/// <summary>
#/// Inserts records into <c>CustVendBalanceTmp_CN</c> table.
#/// </summary>
#/// <param name="_mainAccount">
#/// Assigns a value to MainAccountNum field of above mentioned table.
#/// </param>
#/// <param name="_mainAccountName">
#/// Assigns a value to MainAccountName field of above mentioned table.
#/// </param>
#/// <param name="_vendAccountNum">
#/// Assigns a value to AccountNum field of above mentioned table.
#/// </param>
#/// <param name="_dirPartyName">
#/// Assigns a value to PartyAccountName field of above mentioned table.
#/// </param>
#/// <param name="_openingBalance">
#/// Assigns a value to OpeningBalance field of above mentioned table.
#/// </param>
#/// <param name="_debitBalance">
#/// Assigns a value to DebitAmount field of above mentioned table.
#/// </param>
#/// <param name="_creditBalance">
#/// Assigns a value to CreditAmount field of above mentioned table.
#/// </param>
#/// <param name="_periodCode">
#/// Sends period code of the ledger period selected.
#/// </param>
#private void insertCustVendBalanceTmp_CN(
# MainAccountNum _mainAccount,
# AccountName _mainAccountName,
# AccountNum _vendAccountNum,
# DirPartyName _dirPartyName,
# AmountMST _openingBalance,
# AmountMST _debitBalance,
# AmountMST _creditBalance,
# String255 _periodCode)
#{
# vendAgingPaymTmp.AccountNum = _vendAccountNum;
# vendAgingPaymTmp.PartyAccountName = _dirPartyName;
# vendAgingPaymTmp.MainAccountNum = _mainAccount;
# vendAgingPaymTmp.MainAccountName = _mainAccountName;
# vendAgingPaymTmp.OpeningBalance = _openingBalance;
# vendAgingPaymTmp.DebitAmount = _debitBalance;
# vendAgingPaymTmp.CreditAmount = -_creditBalance;
# vendAgingPaymTmp.PeriodCode = _periodCode;
# vendAgingPaymTmp.ClosingBalance = _openingBalance + _debitBalance + _creditBalance;
# vendAgingPaymTmp.insert();
#}
ENDSOURCE
SOURCE #processReport
#[SysEntryPointAttribute]
#public void processReport()
#{
# VendTable vendTable;
# VendTrans vendTrans;
# MainAccount mainAccount;
# TransDate currentTransDate, fromdate, todate;
# AccountNum curVendAccountNum;
# MainAccountNum curMainAccountNum;
# Name mainAccountName;
# DirPartyName vendAccountName;
# Query query;
# QueryRun queryRun;
# AmountMST openingBalance, creditBalance, debitBalance;
# LedgerFiscalPeriodNameContract_CN contract;
# CustVendBalanceTmp_CN localCopy;
# LedgerDimensionDefaultAccount defaultAccount;
# DimensionAttributeValueCombination dimensionAttribute;
# String255 periodCode, fromPeriodName, toPeriodName;
# FiscalCalendarPeriod currFiscalPeriod;
#
# query = this.parmQuery();
# contract = this.parmDataContract() as LedgerFiscalPeriodNameContract_CN;
#
# if ( !contract.parmFromDate() || !contract.parmToDate())
# {
# currFiscalPeriod = FiscalCalendarPeriod::currentLedgePeriod_CN();
# }
#
# fromdate = (contract.parmFromDate()) ? contract.parmFromDate() : currFiscalPeriod.StartDate;
# todate = (contract.parmToDate()) ? contract.parmToDate() : currFiscalPeriod.EndDate;
# fromPeriodName = (contract.parmFromPeriod()) ? contract.parmFromPeriod() : currFiscalPeriod.Name;
# toPeriodName = (contract.parmToPeriod()) ? contract.parmToPeriod() : currFiscalPeriod.Name;
# periodCode = fromPeriodName + '-' + toPeriodName;
#
# query.dataSourceTable(tableNum(VendTrans)).addRange(fieldNum(VendTrans, TransDate)).value(
# SysQuery::range(dateNull(), todate));
# queryRun = new queryRun(query);
# while (queryRun.next())
# {
# vendTable = queryRun.get(tableNum(VendTable));
# vendTrans = queryRun.get(tableNum(VendTrans));
#
# localCopy.AccountNum = vendTable.AccountNum;
# localCopy.PartyAccountName = DirPartyTable::getName(vendTable.Party);
# localCopy.TransDate = vendTrans.TransDate;
# localCopy.CreditAmount = vendTrans.AmountMST;
# localCopy.Correct = vendTrans.Correct;
# defaultAccount = VendLedgerAccounts::summaryLedgerDimension(
# vendTable.AccountNum,
# vendTrans.PostingProfile);
#
# dimensionAttribute = DimensionAttributeValueCombination::find(defaultAccount);
# mainAccount = mainAccount::find(dimensionAttribute.MainAccount);
# localCopy.MainAccountName = mainAccount.localizedName();
# localCopy.MainAccountNum = mainAccount.MainAccountId;
# localCopy.insert();
# }
#
# while select * from localCopy
# order by localCopy.AccountNum, localCopy.MainAccountName, localCopy.TransDate asc
# {
#
# currentTransDate = localCopy.TransDate;
#
# if (!curVendAccountNum && !curMainAccountNum)
# {
# curMainAccountNum = localCopy.MainAccountNum;
# curVendAccountNum = localCopy.AccountNum;
# mainAccountName = localCopy.MainAccountName;
# vendAccountName = localCopy.PartyAccountName;
# }
#
# if (curVendAccountNum == localCopy.AccountNum
# && curMainAccountNum == localCopy.MainAccountNum )
# {
# if (currentTransDate < fromdate)
# {
# openingBalance += localCopy.CreditAmount ;
# }
# else
# {
# creditBalance += ((localCopy.CreditAmount <= 0 || (localCopy.CreditAmount > 0 && localCopy.Correct)) ? localCopy.CreditAmount : 0.00);
# debitBalance += ((localCopy.CreditAmount > 0 && !localCopy.Correct) ? localCopy.CreditAmount : 0.00);
# }
# }
# else
# {
# this.insertCustVendBalanceTmp_CN(
# curMainAccountNum,
# mainAccountName,
# curVendAccountNum,
# vendAccountName,
# openingBalance,
# debitBalance,
# creditBalance,
# periodCode);
#
# curMainAccountNum = localCopy.MainAccountNum;
# curVendAccountNum = localCopy.AccountNum;
# mainAccountName = localCopy.MainAccountName;
# vendAccountName = localCopy.PartyAccountName;
# creditBalance = 0.00;
# debitBalance = 0.00;
# openingBalance = 0.00;
# if (currentTransDate < fromdate)
# {
# openingBalance = localCopy.CreditAmount ;
# }
# else
# {
# creditBalance = ((localCopy.CreditAmount <= 0 || (localCopy.CreditAmount > 0 && localCopy.Correct)) ? localCopy.CreditAmount : 0.00);
# debitBalance = ((localCopy.CreditAmount > 0 && !localCopy.Correct) ? localCopy.CreditAmount : 0.00);
# }
# }
# }
# // for the last record
# this.insertCustVendBalanceTmp_CN(
# curMainAccountNum,
# mainAccountName,
# curVendAccountNum,
# vendAccountName,
# openingBalance,
# debitBalance,
# creditBalance,
# periodCode);
#} //End for process report
ENDSOURCE
ENDMETHODS
ENDCLASS
***Element: CLS
; Microsoft Dynamics AX Class: EBCVendAgingPaymContract unloaded
; --------------------------------------------------------------------------------
CLSVERSION 1
CLASS #EBCVendAgingPaymContract
PROPERTIES
Name #EBCVendAgingPaymContract
Origin #{7CB83768-46A4-4262-A748-819C18FAD444}
ENDPROPERTIES
METHODS
SOURCE #classDeclaration
#/// <summary>
#/// Contains the from period, to period, from date and to date data contract for SSRS report.
#/// General data contract for from and to fiscal period name.
#/// This contract is used for selecting from and to fiscal period name.
#/// </summary>
#[DataContractAttribute]
#public class EBCVendAgingPaymContract implements SysOperationValidatable
#{
# PeriodName fromPeriod;
# PeriodName toPeriod;
# FromDate fromDate;
# ToDate toDate;
# boolean validateDates;
# TransDate asOn;
#}
ENDSOURCE
SOURCE #new
#public void new()
#{
# validateDates = true;
#}
ENDSOURCE
SOURCE #parmAsOn
#/// <summary>
#/// Gets or sets the value of the datacontract parameter asOn.
#/// </summary>
#/// <param name="_asOn">
#/// The new value of the datacontract parameter asOn.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter asOn.
#/// </returns>
#[
# DataMemberAttribute('AsOn'),
# SysOperationLabelAttribute(literalstr("@SYS7902")),
# SysOperationHelpTextAttribute(literalstr("@SYS7902"))
#]
#public TransDate parmAsOn(TransDate _asOn = asOn)
#{
# asOn = _asOn;
# return asOn;
#}
ENDSOURCE
SOURCE #validate
#/// <summary>
#/// Determines whether the parameters are valid.
#/// </summary>
#/// <returns>
#/// true when the parameters are valid; otherwise, false.
#/// </returns>
#public boolean validate()
#{
# boolean isValid = true;
#
# if (validateDates && fromDate && toDate)
# {
# if (fromDate > toDate)
# {
# //From date cannot be greater than To date.
# isValid = checkFailed("@SYS120590");
# }
# }
#
# return isValid;
#}
ENDSOURCE
ENDMETHODS
ENDCLASS
***Element: QUE
; Microsoft Dynamics AX Query: EBCVendAgingPaym unloaded
; --------------------------------------------------------------------------------
VERSION 31
QUERY #EBCVendAgingPaym
PROPERTIES
Name #EBCVendAgingPaym
Title #@GLS100078
Version #630
NextUniqueId #1020
Origin #{3DE264D8-7CDA-4D4F-A3D7-E66E960D7057}
ENDPROPERTIES
METHODS
SOURCE #classDeclaration
#public class QueryRun extends ObjectRun
#{
#}
ENDSOURCE
ENDMETHODS
BLOCKS
BLOCK #VendTable
PROPERTIES
Name #Vend
Table #VendTable
UniqueId #1009
FetchMode #1:1
ENDPROPERTIES
FIELDLIST
PROPERTIES
Dynamic #No
ENDPROPERTIES
FIELD #AccountNum
FIELD #Party
ENDFIELDLIST
SORTING
ENDSORTING
LINES
LINE #AccountNum
PROPERTIES
Name #AccountNum
Table #VendTable
Field #AccountNum
ENDPROPERTIES
ENDLINES
BLOCKS
BLOCK #VendTrans
PROPERTIES
Name #VTrans
Table #VendTrans
UniqueId #1010
FetchMode #1:1
ENDPROPERTIES
FIELDLIST
PROPERTIES
Dynamic #No
ENDPROPERTIES
FIELD #AmountMST
FIELD #Voucher
FIELD #TransDate
FIELD #AccountNum
FIELD #PostingProfile
FIELD #Correct
ENDFIELDLIST
SORTING
ENDSORTING
LINES
ENDLINES
BLOCKS
ENDBLOCKS
ASSOCIATIONS
ASSOCIATION
JOINDATASOURCE #Vend
MASTERFIELD #AccountNum
DETAILSFIELD #AccountNum
ENDASSOCIATIONS
ENDBLOCK
ENDBLOCKS
GROUPBY
ENDGROUPBY
HAVING
ENDHAVING
ORDERBY
ENDORDERBY
ENDBLOCK
ENDBLOCKS
DEPENDENTS
ENDDEPENDENTS
COMPOSITEQUERIES
ENDCOMPOSITEQUERIES
ENDQUERY
***Element: DBT
; Microsoft Dynamics AX Table : VendAgingReportTmp unloaded
; --------------------------------------------------------------------------------
TABLEVERSION 1
TABLE #VendAgingReportTmp
EnforceFKRelation 1
PROPERTIES
Name #VendAgingReportTmp
Label #@SYS3739
TitleField1 #TransDate
TitleField2 #AccountNum
TableType #TempDB
CreateRecIdIndex #Yes
SaveDataPerCompany #No
PrimaryIndex #SurrogateKey
ClusterIndex #SurrogateKey
DeveloperDocumentation #@SYS323396
Origin #{A4C2259D-0798-42F7-AE30-55D547B60357}
LegacyId #10602
ENDPROPERTIES
FIELDS
FIELD #AccountNum
STRING
PROPERTIES
Name #AccountNum
Table #VendAgingReportTmp
Origin #{1A12325F-DF0B-49FF-983C-54837DEB3F4E}
LegacyId #37
ExtendedDataType #AccountNum
StringSize #20
ENDPROPERTIES
FIELD #AsOfDate
STRING
PROPERTIES
Name #AsOfDate
Table #VendAgingReportTmp
Origin #{F8EE99F4-896F-4BD8-AF0D-D2521D929F64}
LegacyId #11
ExtendedDataType #Str1260
StringSize #1260
ENDPROPERTIES
FIELD #Balance
REAL
PROPERTIES
Name #Balance
Label #@SYS76227
Table #VendAgingReportTmp
Origin #{2A933EBC-42F7-45DB-832B-D48CEA03A773}
LegacyId #39
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance01
REAL
PROPERTIES
Name #Balance01
Label #@SYS76227
Table #VendAgingReportTmp
Origin #{25880EE5-ECB9-4AFA-ADAE-EA325CAEB007}
LegacyId #1
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance01Cur
REAL
PROPERTIES
Name #Balance01Cur
Table #VendAgingReportTmp
Origin #{F99E13F8-E292-4A9C-B719-0CBDB9445B36}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance02
REAL
PROPERTIES
Name #Balance02
Label #@SYS76228
Table #VendAgingReportTmp
Origin #{1AF39A79-07DA-42D1-A3FC-3DA256E4C824}
LegacyId #2
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance02Cur
REAL
PROPERTIES
Name #Balance02Cur
Table #VendAgingReportTmp
Origin #{6073498A-3507-484F-8EF5-FFEAE686E835}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance03
REAL
PROPERTIES
Name #Balance03
Label #@SYS76229
Table #VendAgingReportTmp
Origin #{486E2DF3-C358-40ED-8C6D-C8654BBA4AD5}
LegacyId #3
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance03Cur
REAL
PROPERTIES
Name #Balance03Cur
Table #VendAgingReportTmp
Origin #{B09B25D5-EE61-4EBC-B61E-BCA290D1D923}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance04
REAL
PROPERTIES
Name #Balance04
Label #@SYS76230
Table #VendAgingReportTmp
Origin #{4C1C8C15-F75E-43C2-A62B-A42599307A90}
LegacyId #4
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance04Cur
REAL
PROPERTIES
Name #Balance04Cur
Table #VendAgingReportTmp
Origin #{B418095E-8D48-4600-8D12-2ADD8A8B8DF3}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance05
REAL
PROPERTIES
Name #Balance05
Label #@SYS76231
Table #VendAgingReportTmp
Origin #{1476EF03-E10C-4BE6-8014-649E025CC920}
LegacyId #5
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance05Cur
REAL
PROPERTIES
Name #Balance05Cur
Table #VendAgingReportTmp
Origin #{6C7EE7B2-E55C-4FB3-947A-F94694BFA813}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance06
REAL
PROPERTIES
Name #Balance06
Label #@SYS76232
Table #VendAgingReportTmp
Origin #{77243993-5E73-4D0E-A41E-FBDB2762F824}
LegacyId #6
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance06Cur
REAL
PROPERTIES
Name #Balance06Cur
Table #VendAgingReportTmp
Origin #{06C71A67-05B7-4C44-9611-7DEF91F4DB46}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance07
REAL
PROPERTIES
Name #Balance07
Label #@SYS76233
Table #VendAgingReportTmp
Origin #{2FA3878D-8045-4822-8B68-D8D1DC5EE2CA}
LegacyId #7
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance07Cur
REAL
PROPERTIES
Name #Balance07Cur
Table #VendAgingReportTmp
Origin #{52469837-E830-47A4-B674-5770C9924468}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Blocked
ENUM
PROPERTIES
Name #Blocked
Table #VendAgingReportTmp
Origin #{D948B4B7-638B-4754-A50D-FAB0F10A548B}
ExtendedDataType #VendBlocked
EnumType #CustVendorBlocked
ENDPROPERTIES
FIELD #CurrencyCode
STRING
PROPERTIES
Name #CurrencyCode
Table #VendAgingReportTmp
Origin #{0B21779B-869B-4646-95FF-1EAFD6B6D0E6}
ExtendedDataType #CurrencyCode
StringSize #3
ENDPROPERTIES
FIELD #DirPartyTable
INT64
PROPERTIES
Name #DirPartyTable
Table #VendAgingReportTmp
Origin #{BAD2E1D0-C7FC-4645-9DB8-4F79737190B2}
ExtendedDataType #RefRecId
ENDPROPERTIES
FIELD #EBCNameAlias
STRING
PROPERTIES
Name #EBCNameAlias
Table #VendAgingReportTmp
Origin #{7F87F399-AA48-44BF-B513-F1064133BCD1}
ExtendedDataType #NameAlias
StringSize #20
ENDPROPERTIES
FIELD #Heading1
STRING
PROPERTIES
Name #Heading1
Table #VendAgingReportTmp
Origin #{3638DDCC-6BAB-4E58-9F3B-A8C77DA5348F}
LegacyId #14
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #Heading10
DATE
PROPERTIES
Name #Heading10
Table #VendAgingReportTmp
Origin #{BDCF7B9B-BC3F-406A-B0D3-9A1CB76970C8}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading11
DATE
PROPERTIES
Name #Heading11
Table #VendAgingReportTmp
Origin #{C709AA9E-D274-434D-8B4A-DCDBDFCE7C2B}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading12
DATE
PROPERTIES
Name #Heading12
Table #VendAgingReportTmp
Origin #{7D3552A9-6341-41AC-B538-1031993612CE}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading13
DATE
PROPERTIES
Name #Heading13
Table #VendAgingReportTmp
Origin #{19ACC1F5-3E71-4049-B833-C5456A26983E}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading14
DATE
PROPERTIES
Name #Heading14
Table #VendAgingReportTmp
Origin #{5C7098E9-2557-481E-9F79-4AB53D2E0F3A}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading15
STRING
PROPERTIES
Name #Heading15
Table #VendAgingReportTmp
Origin #{2C53B1F5-489E-4A5B-BBC4-72D80B0CF626}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #Heading2
STRING
PROPERTIES
Name #Heading2
Table #VendAgingReportTmp
Origin #{CF30311B-9C53-40B0-A295-94CB3077B0B0}
LegacyId #16
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #Heading2DateValue
DATE
PROPERTIES
Name #Heading2DateValue
Table #VendAgingReportTmp
Origin #{656B0DD1-9533-40D3-B072-7CA24ED77804}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading3
DATE
PROPERTIES
Name #Heading3
Table #VendAgingReportTmp
Origin #{99694BCC-19B3-4963-813C-DC64628DB9AA}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading4
DATE
PROPERTIES
Name #Heading4
Table #VendAgingReportTmp
Origin #{A5A79EBE-A061-44D5-819E-A3D8EEA9B00C}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading5
DATE
PROPERTIES
Name #Heading5
Table #VendAgingReportTmp
Origin #{58C67506-BFE6-4F49-ACF3-9D70DCB2B242}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading6
DATE
PROPERTIES
Name #Heading6
Table #VendAgingReportTmp
Origin #{E80142E5-D125-437B-BB67-C80C3C045874}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading7
STRING
PROPERTIES
Name #Heading7
Table #VendAgingReportTmp
Origin #{198E9D17-726B-458F-A296-39F808BF6C84}
LegacyId #21
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #Heading7DateValue
DATE
PROPERTIES
Name #Heading7DateValue
Table #VendAgingReportTmp
Origin #{E0443E78-6451-4F1E-991D-BCD37206A1F5}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading8
DATE
PROPERTIES
Name #Heading8
Table #VendAgingReportTmp
Origin #{1137266E-D0E2-4F95-AA6A-5601BEDEFC3D}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading9
DATE
PROPERTIES
Name #Heading9
Table #VendAgingReportTmp
Origin #{4920ECCF-1503-41BD-9340-045919B95F79}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #HeadingAccount
STRING
PROPERTIES
Name #HeadingAccount
Table #VendAgingReportTmp
Origin #{FA9F2699-8531-43BC-9B06-41FFFFD5582C}
LegacyId #12
ExtendedDataType #Addressing
StringSize #250
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription02
STRING
PROPERTIES
Name #HeadingAgingBucketDescription02
Table #VendAgingReportTmp
Origin #{04FBC5E1-FBCD-46F5-9990-409001C4FED0}
LegacyId #28
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription03
STRING
PROPERTIES
Name #HeadingAgingBucketDescription03
Table #VendAgingReportTmp
Origin #{86230A1B-D4A3-45DC-99BC-2A172AA0F6E3}
LegacyId #29
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription04
STRING
PROPERTIES
Name #HeadingAgingBucketDescription04
Table #VendAgingReportTmp
Origin #{D93EEDD7-8E6D-416C-977B-DDD5ECEDAA81}
LegacyId #30
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription05
STRING
PROPERTIES
Name #HeadingAgingBucketDescription05
Table #VendAgingReportTmp
Origin #{8CC93042-8CCA-4782-8E69-2A50694DABB8}
LegacyId #31
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription06
STRING
PROPERTIES
Name #HeadingAgingBucketDescription06
Table #VendAgingReportTmp
Origin #{B7DD90A3-65B2-4900-8C82-925FE222F847}
LegacyId #32
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription07
STRING
PROPERTIES
Name #HeadingAgingBucketDescription07
Table #VendAgingReportTmp
Origin #{7CC28B77-1C61-4F24-8A09-7CAFA04E0C12}
LegacyId #36
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingDate
STRING
PROPERTIES
Name #HeadingDate
Table #VendAgingReportTmp
Origin #{A51A8D11-4A76-4EA8-804F-AEA32A8C4CC5}
LegacyId #9
ExtendedDataType #ColumnTxt
StringSize #40
ENDPROPERTIES
FIELD #HeadingName
STRING
PROPERTIES
Name #HeadingName
Table #VendAgingReportTmp
Origin #{C7E06965-993D-4308-8B86-589EF4BF3F8D}
LegacyId #13
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingVoucher
STRING
PROPERTIES
Name #HeadingVoucher
Table #VendAgingReportTmp
Origin #{58330692-400F-41F2-A033-9B50904D61C9}
LegacyId #10
ExtendedDataType #ColumnTxt
StringSize #40
ENDPROPERTIES
FIELD #InvoiceId
STRING
PROPERTIES
Name #InvoiceId
Table #VendAgingReportTmp
Origin #{B0EA849B-6997-43DC-BAE8-A2F43796A58F}
ExtendedDataType #InvoiceId
StringSize #20
ENDPROPERTIES
FIELD #Name
STRING
PROPERTIES
Name #Name
Table #VendAgingReportTmp
Origin #{6CEB8714-FDFE-4C78-9AE5-F48D5980EB8A}
LegacyId #8
ExtendedDataType #VendName
StringSize #100
ENDPROPERTIES
FIELD #SortOrder
INT
PROPERTIES
Name #SortOrder
Table #VendAgingReportTmp
Origin #{DBBD6447-4E25-416B-9371-F0E9DC9CA406}
ExtendedDataType #Counter
ENDPROPERTIES
FIELD #TransDate
DATE
PROPERTIES
Name #TransDate
Table #VendAgingReportTmp
Origin #{E9D68AC7-E3A1-45FA-9F05-75F38551888D}
LegacyId #33
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Txt
STRING
PROPERTIES
Name #Txt
Table #VendAgingReportTmp
Origin #{AEF785AC-C036-473A-BF57-6EF369100EB4}
LegacyId #35
ExtendedDataType #CustVendAgingTransTxt
StringSize #100
ENDPROPERTIES
FIELD #VendAccount
STRING
PROPERTIES
Name #VendAccount
Table #VendAgingReportTmp
Origin #{73606D15-1FFE-4896-A6F6-1E719F10F901}
LegacyId #38
ExtendedDataType #VendAccount
StringSize #20
ENDPROPERTIES
FIELD #VendGroup
STRING
PROPERTIES
Name #VendGroup
Table #VendAgingReportTmp
Origin #{2CDA7912-2DA9-4A20-8F7D-6D1D5D010B3C}
LegacyId #41
ExtendedDataType #VendGroupId
ENDPROPERTIES
FIELD #Voucher
STRING
PROPERTIES
Name #Voucher
Table #VendAgingReportTmp
Origin #{7B839532-7CCB-4B68-B2B1-66B35E7E850A}
LegacyId #34
ExtendedDataType #Voucher
StringSize #20
ENDPROPERTIES
ENDFIELDS
GROUPS
GROUP #AutoReport
PROPERTIES
Name #AutoReport
ENDPROPERTIES
GROUPFIELDS
#AccountNum
#AsOfDate
#Balance
#Balance01
#Balance01Cur
#Balance02
#Balance02Cur
#Balance03
#Balance03Cur
#Balance04
#Balance04Cur
#Balance05
#Balance05Cur
#Balance06
#Balance06Cur
#Balance07
#Balance07Cur
#CurrencyCode
#Heading1
#Heading10
#Heading11
#Heading12
#Heading13
#Heading14
#Heading15
#Heading2
#Heading2DateValue
#Heading3
#Heading4
#Heading5
#Heading6
#Heading7
#Heading7DateValue
#Heading8
#Heading9
#HeadingAccount
#HeadingAgingBucketDescription02
#HeadingAgingBucketDescription03
#HeadingAgingBucketDescription04
#HeadingAgingBucketDescription05
#HeadingAgingBucketDescription06
#HeadingAgingBucketDescription07
#HeadingDate
#HeadingName
#HeadingVoucher
#InvoiceId
#Name
#TransDate
#Txt
#VendAccount
#VendGroup
#Voucher
ENDGROUPFIELDS
ENDGROUP
GROUP #General
PROPERTIES
Name #General
Label #@SYS19924
ENDPROPERTIES
GROUPFIELDS
#AccountNum
#AsOfDate
#Balance
#Balance01
#Balance01Cur
#Balance02
#Balance02Cur
#Balance03
#Balance03Cur
#Balance04
#Balance04Cur
#Balance05
#Balance05Cur
#Balance06
#Balance06Cur
#Balance07
#Balance07Cur
#CurrencyCode
#Heading1
#Heading10
#Heading11
#Heading12
#Heading13
#Heading14
#Heading15
#Heading2
#Heading2DateValue
#Heading3
#Heading4
#Heading5
#Heading6
#Heading7
#Heading7DateValue
#Heading8
#Heading9
#HeadingAccount
#HeadingAgingBucketDescription02
#HeadingAgingBucketDescription03
#HeadingAgingBucketDescription04
#HeadingAgingBucketDescription05
#HeadingAgingBucketDescription06
#HeadingAgingBucketDescription07
#HeadingDate
#HeadingName
#HeadingVoucher
#InvoiceId
#Name
#TransDate
#Txt
#VendAccount
#VendGroup
#Voucher
ENDGROUPFIELDS
ENDGROUP
ENDGROUPS
INDICES
#CurrencyIdx
PROPERTIES
Name #CurrencyIdx
Origin #{32EEE61A-A88E-4CCC-AABD-20FAE19243FB}
ENDPROPERTIES
INDEXFIELDS
#CurrencyCode
ENDINDEXFIELDS
ENDINDICES
FULLTEXTINDICES
ENDFULLTEXTINDICES
REFERENCES
REFERENCE #Currency
PROPERTIES
Name #Currency
Table #Currency
RelatedTableCardinality #ZeroOne
Cardinality #ZeroMore
RelationshipType #Association
UseDefaultRoleNames #Yes
EDTRelation #Yes
ENDPROPERTIES
FIELDREFERENCES
REFERENCETYPE PKFK
PROPERTIES
Field #CurrencyCode
RelatedField #CurrencyCode
SourceEDT #CurrencyCode
ENDPROPERTIES
ENDFIELDREFERENCES
ENDREFERENCE
REFERENCE #VendGroup
PROPERTIES
Name #VendGroup
Table #VendGroup
RelatedTableCardinality #ZeroOne
Cardinality #ZeroMore
RelationshipType #Association
UseDefaultRoleNames #Yes
RelatedTableRole #VendGroup
Role #VendAgingReportTmp
EDTRelation #Yes
ENDPROPERTIES
FIELDREFERENCES
REFERENCETYPE PKFK
PROPERTIES
Field #VendGroup
RelatedField #VendGroup
SourceEDT #VendGroupId
ENDPROPERTIES
ENDFIELDREFERENCES
ENDREFERENCE
REFERENCE #VendTable
PROPERTIES
Name #VendTable
Table #VendTable
RelatedTableCardinality #ZeroOne
Cardinality #ZeroMore
RelationshipType #Association
UseDefaultRoleNames #Yes
EDTRelation #Yes
ENDPROPERTIES
FIELDREFERENCES
REFERENCETYPE PKFK
PROPERTIES
Field #VendAccount
RelatedField #AccountNum
SourceEDT #VendAccount
ENDPROPERTIES
ENDFIELDREFERENCES
ENDREFERENCE
ENDREFERENCES
DELETEACTIONS
ENDDELETEACTIONS
METHODS
ENDMETHODS
ENDTABLE
***Element: DBT
; Microsoft Dynamics AX Table : EBCVendAgingPaymProposalTmp unloaded
; --------------------------------------------------------------------------------
TABLEVERSION 1
TABLE #EBCVendAgingPaymProposalTmp
EnforceFKRelation 1
PROPERTIES
Name #EBCVendAgingPaymProposalTmp
Label #@SYS3739
TitleField1 #TransDate
TitleField2 #AccountNum
CreateRecIdIndex #Yes
SaveDataPerCompany #No
PrimaryIndex #SurrogateKey
ClusterIndex #SurrogateKey
DeveloperDocumentation #@SYS323396
Origin #{4AB555FB-48DC-4B5E-B7E9-15C768DFBB95}
ENDPROPERTIES
FIELDS
FIELD #AccountNum
STRING
PROPERTIES
Name #AccountNum
Table #EBCVendAgingPaymProposalTmp
Origin #{C1047957-C7D5-4BBF-BEDE-ADA3FEC9E2FF}
ExtendedDataType #AccountNum
StringSize #20
ENDPROPERTIES
FIELD #AsOfDate
STRING
PROPERTIES
Name #AsOfDate
Table #EBCVendAgingPaymProposalTmp
Origin #{1CB85B92-23AC-43BE-A09B-312F3D4CA147}
ExtendedDataType #Str1260
StringSize #1260
ENDPROPERTIES
FIELD #Balance
REAL
PROPERTIES
Name #Balance
Label #@SYS76227
Table #EBCVendAgingPaymProposalTmp
Origin #{5FA57B37-8FD9-4BC3-9535-15CC913F5910}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance01
REAL
PROPERTIES
Name #Balance01
Label #@SYS76227
Table #EBCVendAgingPaymProposalTmp
Origin #{E21A7D5F-D9C5-40E5-A971-C18C5368DEF1}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance01Cur
REAL
PROPERTIES
Name #Balance01Cur
Table #EBCVendAgingPaymProposalTmp
Origin #{22F3BC5F-67ED-4EFE-AA2D-29C90CA0AA41}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance02
REAL
PROPERTIES
Name #Balance02
Label #@SYS76228
Table #EBCVendAgingPaymProposalTmp
Origin #{65DDCEBA-A591-419F-92A4-8F523956F125}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance02Cur
REAL
PROPERTIES
Name #Balance02Cur
Table #EBCVendAgingPaymProposalTmp
Origin #{337FF8A3-5717-448D-ADD0-100E7D2EB180}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance03
REAL
PROPERTIES
Name #Balance03
Label #@SYS76229
Table #EBCVendAgingPaymProposalTmp
Origin #{C7398BDD-8878-47B0-82E7-80D108BAA9B4}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance03Cur
REAL
PROPERTIES
Name #Balance03Cur
Table #EBCVendAgingPaymProposalTmp
Origin #{F8D4770B-3ABD-4DF3-A421-3B4EB4CB7A44}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance04
REAL
PROPERTIES
Name #Balance04
Label #@SYS76230
Table #EBCVendAgingPaymProposalTmp
Origin #{405C0191-2F0F-451E-BA99-8A627DA78329}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance04Cur
REAL
PROPERTIES
Name #Balance04Cur
Table #EBCVendAgingPaymProposalTmp
Origin #{F44098E2-A7BB-4669-A1E2-09089AE294FD}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance05
REAL
PROPERTIES
Name #Balance05
Label #@SYS76231
Table #EBCVendAgingPaymProposalTmp
Origin #{47FE182C-55BA-4498-B410-C8AC76AA2911}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance05Cur
REAL
PROPERTIES
Name #Balance05Cur
Table #EBCVendAgingPaymProposalTmp
Origin #{B07DFCBA-4A02-4348-B9B1-06FC16335E86}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance06
REAL
PROPERTIES
Name #Balance06
Label #@SYS76232
Table #EBCVendAgingPaymProposalTmp
Origin #{65AE387E-179C-4280-A86B-AA0C75B4967B}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance06Cur
REAL
PROPERTIES
Name #Balance06Cur
Table #EBCVendAgingPaymProposalTmp
Origin #{E8FDA53F-E432-41AD-B89A-B1BCA9F4E679}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance07
REAL
PROPERTIES
Name #Balance07
Label #@SYS76233
Table #EBCVendAgingPaymProposalTmp
Origin #{09BB6509-0342-4E28-8B4E-8CDD80F0D903}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance07Cur
REAL
PROPERTIES
Name #Balance07Cur
Table #EBCVendAgingPaymProposalTmp
Origin #{63CC3D8C-58EE-4854-862B-336F8D072E80}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Blocked
ENUM
PROPERTIES
Name #Blocked
Table #EBCVendAgingPaymProposalTmp
Origin #{80ED6E11-23D9-4D1B-BADA-E6E909D0F010}
ExtendedDataType #VendBlocked
EnumType #CustVendorBlocked
ENDPROPERTIES
FIELD #CurrencyCode
STRING
PROPERTIES
Name #CurrencyCode
Table #EBCVendAgingPaymProposalTmp
Origin #{F0A28C0B-FE05-4678-93F1-DEAE2B1CE46A}
ExtendedDataType #CurrencyCode
StringSize #3
ENDPROPERTIES
FIELD #DirPartyTable
INT64
PROPERTIES
Name #DirPartyTable
Table #EBCVendAgingPaymProposalTmp
Origin #{4D3CA762-889E-4B54-840A-A9DEEE2A84BF}
ExtendedDataType #RefRecId
ENDPROPERTIES
FIELD #EBCNameAlias
STRING
PROPERTIES
Name #EBCNameAlias
Table #EBCVendAgingPaymProposalTmp
Origin #{A4E9A435-50E5-432D-9107-C2367DF06FAA}
ExtendedDataType #NameAlias
StringSize #20
ENDPROPERTIES
FIELD #Heading1
STRING
PROPERTIES
Name #Heading1
Table #EBCVendAgingPaymProposalTmp
Origin #{506D0288-B057-4BAE-B288-6D2DCC7ED296}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #Heading10
DATE
PROPERTIES
Name #Heading10
Table #EBCVendAgingPaymProposalTmp
Origin #{FB5AC00E-7C85-4381-BB71-85E1B8F5E2C2}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading11
DATE
PROPERTIES
Name #Heading11
Table #EBCVendAgingPaymProposalTmp
Origin #{7E7B3288-32C8-4A5F-8E40-073A32659A3A}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading12
DATE
PROPERTIES
Name #Heading12
Table #EBCVendAgingPaymProposalTmp
Origin #{95939C93-71B6-4C5E-8C66-18AA35646882}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading13
DATE
PROPERTIES
Name #Heading13
Table #EBCVendAgingPaymProposalTmp
Origin #{71413B50-7281-47FD-BAB6-2F0572E8508A}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading14
DATE
PROPERTIES
Name #Heading14
Table #EBCVendAgingPaymProposalTmp
Origin #{B3B0018E-D127-4D95-AE33-57945A58DB51}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading15
STRING
PROPERTIES
Name #Heading15
Table #EBCVendAgingPaymProposalTmp
Origin #{15D36611-0427-47EA-9716-7A264B89F4EB}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #Heading2
STRING
PROPERTIES
Name #Heading2
Table #EBCVendAgingPaymProposalTmp
Origin #{211945C0-0D64-4D0E-BF98-62D45E5001DA}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #Heading2DateValue
DATE
PROPERTIES
Name #Heading2DateValue
Table #EBCVendAgingPaymProposalTmp
Origin #{FE3415D1-34B7-4F68-8F3D-C34CEDD0CA56}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading3
DATE
PROPERTIES
Name #Heading3
Table #EBCVendAgingPaymProposalTmp
Origin #{96E59BE2-7B11-4AF5-9218-A91BB8F5268F}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading4
DATE
PROPERTIES
Name #Heading4
Table #EBCVendAgingPaymProposalTmp
Origin #{C0CA78D7-F196-4A83-A181-FB5383746A85}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading5
DATE
PROPERTIES
Name #Heading5
Table #EBCVendAgingPaymProposalTmp
Origin #{611A7EFE-2ACD-459C-BF32-AF7BA4343CDA}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading6
DATE
PROPERTIES
Name #Heading6
Table #EBCVendAgingPaymProposalTmp
Origin #{96D23AF9-B1DA-446F-9592-3F6413272381}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading7
STRING
PROPERTIES
Name #Heading7
Table #EBCVendAgingPaymProposalTmp
Origin #{8BD96820-202B-416A-A724-7AF0DAF68D5E}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #Heading7DateValue
DATE
PROPERTIES
Name #Heading7DateValue
Table #EBCVendAgingPaymProposalTmp
Origin #{FC442D9A-89DE-411A-A3AC-B1CEE0235497}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading8
DATE
PROPERTIES
Name #Heading8
Table #EBCVendAgingPaymProposalTmp
Origin #{D56AFBE1-876B-4111-8ED4-58648793B151}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading9
DATE
PROPERTIES
Name #Heading9
Table #EBCVendAgingPaymProposalTmp
Origin #{8FF90233-3F90-4B6E-A764-42A231D7F074}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #HeadingAccount
STRING
PROPERTIES
Name #HeadingAccount
Table #EBCVendAgingPaymProposalTmp
Origin #{70A4B426-F3AB-4E2F-AFAE-6F9319061D8C}
ExtendedDataType #Addressing
StringSize #250
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription02
STRING
PROPERTIES
Name #HeadingAgingBucketDescription02
Table #EBCVendAgingPaymProposalTmp
Origin #{AFFCA94F-155C-49E5-BB72-84C3199095F0}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription03
STRING
PROPERTIES
Name #HeadingAgingBucketDescription03
Table #EBCVendAgingPaymProposalTmp
Origin #{D51CA06E-D260-4D68-88B7-CE5922C6660F}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription04
STRING
PROPERTIES
Name #HeadingAgingBucketDescription04
Table #EBCVendAgingPaymProposalTmp
Origin #{700819B6-2504-47FB-94EE-7CBD334B6513}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription05
STRING
PROPERTIES
Name #HeadingAgingBucketDescription05
Table #EBCVendAgingPaymProposalTmp
Origin #{788751F6-7762-4072-BBA3-4DED7727E7A4}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription06
STRING
PROPERTIES
Name #HeadingAgingBucketDescription06
Table #EBCVendAgingPaymProposalTmp
Origin #{B9F0715D-94CE-411F-BEA7-8464B45C1B8A}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription07
STRING
PROPERTIES
Name #HeadingAgingBucketDescription07
Table #EBCVendAgingPaymProposalTmp
Origin #{4670E5C9-AE9F-4850-9F08-EE706812216C}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingDate
STRING
PROPERTIES
Name #HeadingDate
Table #EBCVendAgingPaymProposalTmp
Origin #{E3BCCCFF-6F76-414F-B6E5-1B046A9B0DCF}
ExtendedDataType #ColumnTxt
StringSize #40
ENDPROPERTIES
FIELD #HeadingName
STRING
PROPERTIES
Name #HeadingName
Table #EBCVendAgingPaymProposalTmp
Origin #{BF66649B-149D-44A4-BEE8-D65DD8A9153E}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingVoucher
STRING
PROPERTIES
Name #HeadingVoucher
Table #EBCVendAgingPaymProposalTmp
Origin #{0BD2BDFB-7B33-4837-B878-5D3953D183A3}
ExtendedDataType #ColumnTxt
StringSize #40
ENDPROPERTIES
FIELD #InvoiceId
STRING
PROPERTIES
Name #InvoiceId
Table #EBCVendAgingPaymProposalTmp
Origin #{E1D7373F-895C-4EC2-8B1C-0226E959EDAD}
ExtendedDataType #InvoiceId
StringSize #20
ENDPROPERTIES
FIELD #Name
STRING
PROPERTIES
Name #Name
Table #EBCVendAgingPaymProposalTmp
Origin #{349A92A7-441F-40BD-B276-64947D309F52}
ExtendedDataType #VendName
StringSize #100
ENDPROPERTIES
FIELD #SortOrder
INT
PROPERTIES
Name #SortOrder
Table #EBCVendAgingPaymProposalTmp
Origin #{464BB78C-D0E9-433D-BB53-2DE69CDA3F14}
ExtendedDataType #Counter
ENDPROPERTIES
FIELD #TransDate
DATE
PROPERTIES
Name #TransDate
Table #EBCVendAgingPaymProposalTmp
Origin #{814441D7-B5BC-48FC-87A5-194A2F95545F}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Txt
STRING
PROPERTIES
Name #Txt
Table #EBCVendAgingPaymProposalTmp
Origin #{87AA8F4B-EE3C-4383-8FE5-1F1EA98B5F62}
ExtendedDataType #CustVendAgingTransTxt
StringSize #100
ENDPROPERTIES
FIELD #VendAccount
STRING
PROPERTIES
Name #VendAccount
Table #EBCVendAgingPaymProposalTmp
Origin #{6A3728CA-2F2C-4530-8114-BCB644529860}
ExtendedDataType #VendAccount
StringSize #20
ENDPROPERTIES
FIELD #VendGroup
STRING
PROPERTIES
Name #VendGroup
Table #EBCVendAgingPaymProposalTmp
Origin #{6DDDAF3A-5420-4F6A-9E53-76266CDA25E8}
ExtendedDataType #VendGroupId
ENDPROPERTIES
FIELD #Voucher
STRING
PROPERTIES
Name #Voucher
Table #EBCVendAgingPaymProposalTmp
Origin #{A686BE9D-9B77-491B-BAC8-04C4D312BDBD}
ExtendedDataType #Voucher
StringSize #20
ENDPROPERTIES
ENDFIELDS
GROUPS
GROUP #AutoReport
PROPERTIES
Name #AutoReport
ENDPROPERTIES
GROUPFIELDS
#AccountNum
#AsOfDate
#Balance
#Balance01
#Balance01Cur
#Balance02
#Balance02Cur
#Balance03
#Balance03Cur
#Balance04
#Balance04Cur
#Balance05
#Balance05Cur
#Balance06
#Balance06Cur
#Balance07
#Balance07Cur
#CurrencyCode
#Heading1
#Heading10
#Heading11
#Heading12
#Heading13
#Heading14
#Heading15
#Heading2
#Heading2DateValue
#Heading3
#Heading4
#Heading5
#Heading6
#Heading7
#Heading7DateValue
#Heading8
#Heading9
#HeadingAccount
#HeadingAgingBucketDescription02
#HeadingAgingBucketDescription03
#HeadingAgingBucketDescription04
#HeadingAgingBucketDescription05
#HeadingAgingBucketDescription06
#HeadingAgingBucketDescription07
#HeadingDate
#HeadingName
#HeadingVoucher
#InvoiceId
#Name
#TransDate
#Txt
#VendAccount
#VendGroup
#Voucher
ENDGROUPFIELDS
ENDGROUP
GROUP #General
PROPERTIES
Name #General
Label #@SYS19924
ENDPROPERTIES
GROUPFIELDS
#AccountNum
#AsOfDate
#Balance
#Balance01
#Balance01Cur
#Balance02
#Balance02Cur
#Balance03
#Balance03Cur
#Balance04
#Balance04Cur
#Balance05
#Balance05Cur
#Balance06
#Balance06Cur
#Balance07
#Balance07Cur
#CurrencyCode
#Heading1
#Heading10
#Heading11
#Heading12
#Heading13
#Heading14
#Heading15
#Heading2
#Heading2DateValue
#Heading3
#Heading4
#Heading5
#Heading6
#Heading7
#Heading7DateValue
#Heading8
#Heading9
#HeadingAccount
#HeadingAgingBucketDescription02
#HeadingAgingBucketDescription03
#HeadingAgingBucketDescription04
#HeadingAgingBucketDescription05
#HeadingAgingBucketDescription06
#HeadingAgingBucketDescription07
#HeadingDate
#HeadingName
#HeadingVoucher
#InvoiceId
#Name
#TransDate
#Txt
#VendAccount
#VendGroup
#Voucher
ENDGROUPFIELDS
ENDGROUP
ENDGROUPS
INDICES
#CurrencyIdx
PROPERTIES
Name #CurrencyIdx
Origin #{E9DDF1A2-2364-4DC2-B106-352DBE203108}
ENDPROPERTIES
INDEXFIELDS
#CurrencyCode
ENDINDEXFIELDS
ENDINDICES
FULLTEXTINDICES
ENDFULLTEXTINDICES
REFERENCES
REFERENCE #Currency
PROPERTIES
Name #Currency
Table #Currency
RelatedTableCardinality #ZeroOne
Cardinality #ZeroMore
RelationshipType #Association
UseDefaultRoleNames #Yes
EDTRelation #Yes
ENDPROPERTIES
FIELDREFERENCES
REFERENCETYPE PKFK
PROPERTIES
Field #CurrencyCode
RelatedField #CurrencyCode
ENDPROPERTIES
ENDFIELDREFERENCES
ENDREFERENCE
REFERENCE #VendGroup
PROPERTIES
Name #VendGroup
Table #VendGroup
RelatedTableCardinality #ZeroOne
Cardinality #ZeroMore
RelationshipType #Association
UseDefaultRoleNames #Yes
RelatedTableRole #VendGroup
Role #VendAgingReportTmp
EDTRelation #Yes
ENDPROPERTIES
FIELDREFERENCES
REFERENCETYPE PKFK
PROPERTIES
Field #VendGroup
RelatedField #VendGroup
ENDPROPERTIES
ENDFIELDREFERENCES
ENDREFERENCE
REFERENCE #VendTable
PROPERTIES
Name #VendTable
Table #VendTable
RelatedTableCardinality #ZeroOne
Cardinality #ZeroMore
RelationshipType #Association
UseDefaultRoleNames #Yes
EDTRelation #Yes
ENDPROPERTIES
FIELDREFERENCES
REFERENCETYPE PKFK
PROPERTIES
Field #VendAccount
RelatedField #AccountNum
ENDPROPERTIES
ENDFIELDREFERENCES
ENDREFERENCE
ENDREFERENCES
DELETEACTIONS
ENDDELETEACTIONS
METHODS
ENDMETHODS
ENDTABLE
***Element: CLS
; Microsoft Dynamics AX Class: EBCVendAgingPaymProposalContract unloaded
; --------------------------------------------------------------------------------
CLSVERSION 1
CLASS #EBCVendAgingPaymProposalContract
PROPERTIES
Name #EBCVendAgingPaymProposalContract
Origin #{E8FA447D-7D4A-4713-A5C5-4FD08ADA1C92}
ENDPROPERTIES
METHODS
SOURCE #classDeclaration
#/// <summary>
#/// Data Contract class for <c>VendAgingReport</c>Microsoft SQL Server Reporting Services report
#/// </summary>
#/// <remarks>
#/// This is the Data Contract class for the <c>VendAgingReport</c> SSRS Report.
#/// </remarks>
#[
# DataContractAttribute
#]
#public class EBCVendAgingPaymProposalContract implements SysOperationValidatable
#{
# TransDate startDate;
# TransDate zeroDate;
# DateTransactionDuedate dateTransactionDuedate;
# CustVendAgingBucketLookUp agingBuckets;
# NoYesCombo printAgingBucketDescription;
# PositiveDays interval;
# DayMonth period;
# ForwardBackwardPrinting direction;
# boolean detailed;
# boolean printZeroOrNegative;
# boolean payments;
# boolean excludeZeroBalanceVendor;
# boolean includeAmountCur;
# boolean printTotalLessThan100Euro;
# #define.emptyString('')
#}
#
ENDSOURCE
SOURCE #parmAgingBuckets
#/// <summary>
#/// Gets or sets the value of the datacontract parameter AgingBuckets.
#/// </summary>
#/// <param name="_agingBuckets">
#/// The new value of the datacontract parameter AgingBuckets; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter AgingBuckets
#/// </returns>
#[
# DataMemberAttribute('AgingBuckets'),
# SysOperationLabelAttribute(literalStr("@SYS78607")),
# SysOperationHelpTextAttribute(literalStr("@SYS28056")),
# SysOperationDisplayOrderAttribute('04')
#]
#public CustVendAgingBucketLookUp parmAgingBuckets(CustVendAgingBucketLookUp _agingBuckets = agingBuckets)
#{
# agingBuckets = _agingBuckets;
# return agingBuckets;
#}
ENDSOURCE
SOURCE #parmDateTransactionDuedate
#/// <summary>
#/// Gets or sets the value of the datacontract parameter DateTransactionDuedate.
#/// </summary>
#/// <param name="_dateTransactionDuedate">
#/// The new value of the datacontract parameter DateTransactionDuedate; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter DateTransactionDuedate
#/// </returns>
#[
# DataMemberAttribute('DateTransactionDuedate'),
# SysOperationLabelAttribute(literalStr("@SYS13128")),
# SysOperationHelpTextAttribute(literalStr("@SYS29102")),
# SysOperationDisplayOrderAttribute('03')
#]
#public DateTransactionDuedate parmDateTransactionDuedate(DateTransactionDuedate _dateTransactionDuedate = dateTransactionDuedate)
#{
# dateTransactionDuedate = _dateTransactionDuedate;
# return dateTransactionDuedate;
#}
ENDSOURCE
SOURCE #parmDetailed
#/// <summary>
#/// Gets or sets the value of the datacontract parameter Detailed.
#/// </summary>
#/// <param name="_detailed">
#/// The new value of the datacontract parameter Detailed; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter Detailed
#/// </returns>
#[
# DataMemberAttribute('Detailed'),
# SysOperationLabelAttribute(literalStr("@SYS8811")),
# SysOperationHelpTextAttribute(literalStr("@SYS20687")),
# SysOperationDisplayOrderAttribute('09')
#]
#public boolean parmDetailed(boolean _detailed = detailed)
#{
# detailed = _detailed;
# return detailed;
#}
ENDSOURCE
SOURCE #parmDirection
#/// <summary>
#/// Gets or sets the value of the datacontract parameter Direction.
#/// </summary>
#/// <param name="_direction">
#/// The new value of the datacontract parameter Direction; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter Direction
#/// </returns>
#[
# DataMemberAttribute('Direction'),
# SysOperationLabelAttribute(literalStr("@SYS70307")),
# SysOperationHelpTextAttribute(literalStr("@SYS70312")),
# SysOperationDisplayOrderAttribute('08')
#]
#public ForwardBackwardPrinting parmDirection(ForwardBackwardPrinting _direction = direction)
#{
# direction = _direction;
# return direction;
#}
ENDSOURCE
SOURCE #parmExcludeZeroBalanceVendor
#/// <summary>
#/// Gets or sets the value of the datacontract parameter <c>ExcludeZeroBalanceCustomers</c>.
#/// </summary>
#/// <param name="_excludeZeroBalanceVendor">
#/// The new value of the datacontract parameter <c>_excludeZeroBalanceVendor</c>; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter <c>_excludeZeroBalanceVendor</c>
#/// </returns>
#[
# DataMemberAttribute('ExcludeZeroBalanceVendor'),
# SysOperationLabelAttribute(literalStr("@SYS344269")),
# SysOperationHelpTextAttribute(literalStr("@SYS344270")),
# SysOperationDisplayOrderAttribute('12')
#]
#public boolean parmExcludeZeroBalanceVendor(boolean _excludeZeroBalanceVendor = excludeZeroBalanceVendor)
#{
# excludeZeroBalanceVendor = _excludeZeroBalanceVendor;
# return excludeZeroBalanceVendor;
#}
#
#
ENDSOURCE
SOURCE #parmIncludeAmountCur
#[
# DataMemberAttribute('IncludeAmountCur'),
# SysOperationLabelAttribute(literalStr("@SYS344267")),
# SysOperationHelpTextAttribute(literalStr("@SYS344268")),
# SysOperationDisplayOrderAttribute('10')
#]
#public boolean parmIncludeAmountCur(boolean _includeAmountCur = includeAmountCur)
#{
# includeAmountCur = _includeAmountCur;
# return includeAmountCur;
#}
ENDSOURCE
SOURCE #parmInterval
#/// <summary>
#/// Gets or sets the value of the datacontract parameter Interval.
#/// </summary>
#/// <param name="_interval">
#/// The new value of the datacontract parameter Interval; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter Interval
#/// </returns>
#[
# DataMemberAttribute('Interval'),
# SysOperationLabelAttribute(literalStr("@SYS12899")),
# SysOperationHelpTextAttribute(literalStr("@SYS17806")),
# SysOperationDisplayOrderAttribute('06')
#]
#public PositiveDays parmInterval(PositiveDays _interval = interval)
#{
# interval = _interval;
# return interval;
#}
ENDSOURCE
SOURCE #parmPayments
#/// <summary>
#/// Gets or sets the value of the datacontract parameter Payments.
#/// </summary>
#/// <param name="_payments">
#/// The new value of the datacontract parameter Payments; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter Payments
#/// </returns>
#[
# DataMemberAttribute('Payments'),
# SysOperationLabelAttribute(literalStr("@SYS68577")),
# SysOperationHelpTextAttribute(literalStr("@SYS68578")),
# SysOperationDisplayOrderAttribute('13')
#]
#public boolean parmPayments(boolean _payments = payments)
#{
# payments = _payments;
# return payments;
#}
ENDSOURCE
SOURCE #parmPeriod
#/// <summary>
#/// Gets or sets the value of the datacontract parameter Period.
#/// </summary>
#/// <param name="_period">
#/// The new value of the datacontract parameter Period; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter Period
#/// </returns>
#[
# DataMemberAttribute('Period'),
# SysOperationLabelAttribute(literalStr("@SYS16024")),
# SysOperationHelpTextAttribute(literalStr("@SYS67813")),
# SysOperationDisplayOrderAttribute('07')
#]
#public DayMonth parmPeriod(DayMonth _period = period)
#{
# period = _period;
# return period;
#}
ENDSOURCE
SOURCE #parmPrintAgingBucketDescription
#/// <summary>
#/// Gets or sets the value of the datacontract parameter PrintAgingBucketDescription.
#/// </summary>
#/// <param name="_printAgingBucketDescription">
#/// The new value of the datacontract parameter PrintAgingBucketDescription; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter PrintAgingBucketDescription
#/// </returns>
#[
# DataMemberAttribute('PrintAgingBucketDescription'),
# SysOperationLabelAttribute(literalStr("@SYS97360")),
# SysOperationHelpTextAttribute(literalStr("@SYS96942")),
# SysOperationDisplayOrderAttribute('05')
#]
#public NoYesCombo parmPrintAgingBucketDescription(NoYesCombo _printAgingBucketDescription = printAgingBucketDescription)
#{
# printAgingBucketDescription = _printAgingBucketDescription;
# return printAgingBucketDescription;
#}
ENDSOURCE
SOURCE #parmPrintZeroOrNegative
#/// <summary>
#/// Gets or sets the value of the datacontract parameter PrintZeroOrNegative.
#/// </summary>
#/// <param name="_printZeroOrNegative">
#/// The new value of the datacontract parameter PrintZeroOrNegative; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter PrintZeroOrNegative
#/// </returns>
#[
# DataMemberAttribute('PrintZeroOrNegative'),
# SysOperationLabelAttribute(literalStr("@SYS69732")),
# SysOperationHelpTextAttribute(literalStr("@SYS69733")),
# SysOperationDisplayOrderAttribute('11')
#]
#public boolean parmPrintZeroOrNegative(boolean _printZeroOrNegative = printZeroOrNegative)
#{
# printZeroOrNegative = _printZeroOrNegative;
# return printZeroOrNegative;
#}
ENDSOURCE
SOURCE #parmStartDate
#/// <summary>
#/// Gets or sets the value of the datacontract parameter StartDate.
#/// </summary>
#/// <param name="_startDate">
#/// The new value of the datacontract parameter StartDate; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter StartDate
#/// </returns>
#[
# DataMemberAttribute('StartDate'),
# SysOperationLabelAttribute(literalStr("@SYS6255")),
# SysOperationHelpTextAttribute(literalStr("@SYS29110")),
# SysOperationDisplayOrderAttribute('02')
#]
#public TransDate parmStartDate(TransDate _startDate = startDate)
#{
# startDate = _startDate;
# return startDate;
#}
ENDSOURCE
SOURCE #parmTotalLessThan100Euro
#/// <summary>
#/// Gets or sets the value of the datacontract parameter PrintZeroOrNegative.
#/// </summary>
#/// <param name="_printZeroOrNegative">
#/// The new value of the datacontract parameter PrintZeroOrNegative; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter PrintZeroOrNegative
#/// </returns>
#[
# DataMemberAttribute('TotalLessThan100Euro'),
# SysOperationLabelAttribute(literalStr("@SYS4160097")),
# SysOperationDisplayOrderAttribute('16')
#]
#public boolean parmTotalLessThan100Euro(boolean _printTotalLessThan100Euro = printTotalLessThan100Euro)
#{
# printTotalLessThan100Euro = _printTotalLessThan100Euro;
# return printTotalLessThan100Euro;
#}
ENDSOURCE
SOURCE #parmZeroDate
#/// <summary>
#/// Gets or sets the value of the datacontract parameter ZeroDate.
#/// </summary>
#/// <param name="_zeroDate">
#/// The new value of the datacontract parameter ZeroDate; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter ZeroDate
#/// </returns>
#[
# DataMemberAttribute('ZeroDate'),
# SysOperationLabelAttribute(literalStr("@SYS137399")),
# SysOperationHelpTextAttribute(literalStr("@SYS137399")),
# SysOperationDisplayOrderAttribute('01')
#]
#public TransDate parmZeroDate(TransDate _zeroDate = zeroDate)
#{
# zeroDate = _zeroDate;
# return zeroDate;
#}
ENDSOURCE
SOURCE #validate
#/// <summary>
#/// Determines whether the parameters are valid.
#/// </summary>
#/// <returns>
#/// true is the parameters are valid; otherwise, false.
#/// </returns>
#public boolean validate()
#{
# boolean ret;
# CustVendAgingBucketLookUp agingBucket;
# StatRepIntervalLine statRepIntervalLine;
# ret = true;
# agingBucket = this.parmAgingBuckets();
#
# if (agingBucket != #emptyString)
# {
# select count(Qty) from statRepIntervalLine
# where statRepIntervalLine.Name == agingBucket;
#
# if (! statRepIntervalLine.Qty)
# {
# ret = checkFailed("@SYS90115");
# }
#
# if (statRepIntervalLine.Qty > 6)
# {
# ret = checkFailed("@SYS90116");
# }
# }
# return ret;
#}
ENDSOURCE
ENDMETHODS
ENDCLASS
***Element: CLS
; Microsoft Dynamics AX Class: EBCVendAgingPaymController unloaded
; --------------------------------------------------------------------------------
CLSVERSION 1
CLASS #EBCVendAgingPaymController
PROPERTIES
Name #EBCVendAgingPaymController
Extends #SrsReportRunController
Origin #{E0474E00-268C-483B-8AD7-E7E47BB88079}
ENDPROPERTIES
METHODS
SOURCE #classDeclaration
#/// <summary>
#/// The <c>VendAgingReportController</c> class is the controller class for the
#/// <c>VendAgingReport</c>Microsoft SQL Server Reporting Services report.
#/// </summary>
#public class EBCVendAgingPaymController extends SrsReportRunController
#{
# #define.reportName('EBCVendAgingPaym.Report')
#}
ENDSOURCE
SOURCE #getReportName
#private str getReportName(EBCVendAgingPaymProposalContract _contract)
#{
# str reportNameLocal;
#
# reportNameLocal = ssrsReportStr (EBCVendAgingPaym, Report);
#
# return reportNameLocal;
#}
ENDSOURCE
SOURCE #init
#/// <summary>
#/// Assigns the parameter values of controller
#/// </summary>
#public void init()
#{
# SRSCatalogItemName sRSCatalogItemName;
#
# sRSCatalogItemName = ssrsReportStr(EBCVendAgingPaym, Report);
#
# this.parmReportName(sRSCatalogItemName);
#}
ENDSOURCE
SOURCE #prePromptModifyContract
#protected void prePromptModifyContract()
#{
# EBCVendAgingPaymContract contract;
#
# super();
#
# contract = this.parmReportContract().parmRdpContract();
# //Due amount analysis (China)
# this.parmDialogCaption("@GLS100140");
#
# if (!contract.parmAsOn())
# {
# contract.parmAsOn(systemDateGet());
# }
#}
ENDSOURCE
SOURCE #main
#/// <summary>
#/// Initializes the controller, assigns parameter values and run <c>VendDueAmountAnalysis_CN</c> SSRS Report
#/// </summary>
#/// <param name="_args">
#/// The <c>Args</c> object
#/// </param>
#public static void main(Args _args)
#{
#
# EBCVendAgingPaymController controller = new EBCVendAgingPaymController();
#
# controller.parmReportName(#reportName);
# controller.parmArgs(_args);
# controller.startOperation();
#}
#
ENDSOURCE
ENDMETHODS
ENDCLASS
***Element: CLS
; Microsoft Dynamics AX Class: EBCVendAgingPaymProposalDP unloaded
; --------------------------------------------------------------------------------
CLSVERSION 1
CLASS #EBCVendAgingPaymProposalDP
PROPERTIES
Name #EBCVendAgingPaymProposalDP
Extends #SrsReportDataProviderPreProcessTempDB
RunOn #Server
Origin #{12D82211-A0D0-4D57-899F-5BA0A3ECA1AC}
ENDPROPERTIES
METHODS
SOURCE #classDeclaration
#/// <summary>
#/// The <c>VendAgingReportDP</c> class declares the variables that are used in the
#/// <c>VendAgingReport</c> report.
#/// </summary>
#[
# SRSReportQueryAttribute(queryStr(VendAgingReport)),
# SRSReportParameterAttribute(classStr(EBCVendAgingPaymProposalContract))
#]
#public class EBCVendAgingPaymProposalDP extends SRSReportDataProviderPreProcessTempDB
#{
# EBCVendAgingPaymProposalTmp vendAgingReportTmp;
# VendTmpAccountSum tmpAccountSum;
# CustVendBalanceList custVendBalanceList;
# EBCVendAgingPaymProposalContract contract;
# EBCVendAgingPaymProposalTmp vendAgingPaymProposalTmp;
#
# ColumnTxt headingDate;
# TransDate heading011;
# TransDate heading02;
# TransDate heading021;
# TransDate heading03;
# TransDate heading031;
# TransDate heading04;
# TransDate heading041;
# TransDate heading05;
# TransDate heading051;
# TransDate heading06;
# TransDate heading061;
# TransDate heading07;
# TransDate heading071;
#
# TransTxt heading01;
# TransTxt heading02Text;
# TransTxt heading07Text;
# TransTxt headingAgingBucketDescription02;
# TransTxt headingAgingBucketDescription03;
# TransTxt headingAgingBucketDescription04;
# TransTxt headingAgingBucketDescription05;
# TransTxt headingAgingBucketDescription06;
# TransTxt headingAgingBucketDescription07;
#
# #define.emptyString('')
#}
ENDSOURCE
SOURCE #getReverseAmountsAndHeadings
#private boolean getReverseAmountsAndHeadings(CustVendAgingBucketLookUp _agingBucket, ForwardBackwardPrinting _direction)
#{
# boolean reverseAmountsAndHeadings = false;
#
# if (_agingBucket == '' && _direction == ForwardBackwardPrinting::Forward)
# {
# reverseAmountsAndHeadings = true;
# }
#
# return reverseAmountsAndHeadings;
#}
ENDSOURCE
SOURCE #getVendAgingReportTmp
#/// <summary>
#/// Gets temporary table.
#/// </summary>
#/// <returns>
#/// The <c>VendAgingReportTmp</c> temporary table.
#/// </returns>
#[
# SRSReportDataSetAttribute('EBCVendAgingPaymProposalTmp')
#]
#public EBCVendAgingPaymProposalTmp getVendAgingReportTmp()
#{
# select vendAgingReportTmp;
# return vendAgingReportTmp;
#}
ENDSOURCE
SOURCE #heading01
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransTxt heading01()
#{
# return strFmt("@SYS137399", #emptyString);
#}
ENDSOURCE
SOURCE #heading011
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading011()
#{
# return contract.parmZeroDate();
#}
ENDSOURCE
SOURCE #heading02
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading02()
#{
# if (contract.parmAgingBuckets())
# {
# return custVendBalanceList.startdate(2);
# }
# else
# {
# return dateNull();
# }
#}
ENDSOURCE
SOURCE #heading021
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading021()
#{
# if(contract.parmAgingBuckets())
# {
# return custVendBalanceList.enddate(2);
# }
# else
# {
# return custVendBalanceList.enddate(3);
# }
#}
ENDSOURCE
SOURCE #heading02Text
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransTxt heading02Text()
#{
# if (contract.parmAgingBuckets())
# {
# return #emptyString;
# }
# else
# {
# return contract.parmDateTransactionDuedate() ? strFmt("@SYS60131", #emptyString) : strFmt("@SYS62491", #emptyString);
# }
#}
ENDSOURCE
SOURCE #heading03
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading03()
#{
# return custVendBalanceList.startdate(3);
#}
ENDSOURCE
SOURCE #heading031
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading031()
#{
# return custVendBalanceList.enddate(3);
#}
ENDSOURCE
SOURCE #heading04
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading04()
#{
# return custVendBalanceList.startdate(4);
#}
ENDSOURCE
SOURCE #heading041
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading041()
#{
# return custVendBalanceList.enddate(4);
#}
ENDSOURCE
SOURCE #heading05
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading05()
#{
# return custVendBalanceList.startdate(5);
#}
ENDSOURCE
SOURCE #heading051
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading051()
#{
# return custVendBalanceList.enddate(5);
#}
ENDSOURCE
SOURCE #heading06
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading06()
#{
# return custVendBalanceList.startdate(6);
#}
ENDSOURCE
SOURCE #heading061
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading061()
#{
# return custVendBalanceList.enddate(6);
#}
ENDSOURCE
SOURCE #heading07
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading07()
#{
# if (contract.parmAgingBuckets())
# {
# return custVendBalanceList.startdate(7);
# }
# else
# {
# return dateNull();
# }
#}
ENDSOURCE
SOURCE #heading071
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading071()
#{
# if(contract.parmAgingBuckets())
# {
# return custVendBalanceList.enddate(7);
# }
# else
# {
# return custVendBalanceList.startdate(6);
# }
#}
ENDSOURCE
SOURCE #heading07Text
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransTxt heading07Text()
#{
# if (contract.parmAgingBuckets())
# {
# return #emptyString;
# }
# else
# {
# return contract.parmDateTransactionDuedate() ? strFmt("@SYS29113", #emptyString) : strFmt("@SYS62492", #emptyString);
# }
#}
ENDSOURCE
SOURCE #headingAgingBucketDescription02
#/// <summary>
#/// Gets the heading description.
#/// </summary>
#/// <returns>
#/// The heading description text.
#/// </returns>
#private TransTxt headingAgingBucketDescription02()
#{
# if (contract.parmAgingBuckets() && contract.parmPrintAgingBucketDescription())
# {
# return strFmt('%1', custVendBalanceList.getDescription(2));
# }
# else
# {
# return #emptyString;
# }
#}
ENDSOURCE
SOURCE #headingAgingBucketDescription03
#/// <summary>
#/// Gets the heading description.
#/// </summary>
#/// <returns>
#/// The heading description text.
#/// </returns>
#private TransTxt headingAgingBucketDescription03()
#{
# if (contract.parmAgingBuckets() && contract.parmPrintAgingBucketDescription())
# {
# return strFmt('%1', custVendBalanceList.getDescription(3));
# }
# else
# {
# return #emptyString;
# }
#}
ENDSOURCE
SOURCE #headingAgingBucketDescription04
#/// <summary>
#/// Gets the heading description.
#/// </summary>
#/// <returns>
#/// The heading description text.
#/// </returns>
#private TransTxt headingAgingBucketDescription04()
#{
# if (contract.parmAgingBuckets() && contract.parmPrintAgingBucketDescription())
# {
# return strFmt('%1', custVendBalanceList.getDescription(4));
# }
# else
# {
# return #emptyString;
# }
#}
ENDSOURCE
SOURCE #headingAgingBucketDescription05
#/// <summary>
#/// Gets the heading description.
#/// </summary>
#/// <returns>
#/// The heading description text.
#/// </returns>
#private TransTxt headingAgingBucketDescription05()
#{
# if (contract.parmAgingBuckets() && contract.parmPrintAgingBucketDescription())
# {
# return strFmt('%1', custVendBalanceList.getDescription(5));
# }
# else
# {
# return #emptyString;
# }
#}
ENDSOURCE
SOURCE #headingAgingBucketDescription06
#/// <summary>
#/// Gets the heading description.
#/// </summary>
#/// <returns>
#/// The heading description text.
#/// </returns>
#private TransTxt headingAgingBucketDescription06()
#{
# if (contract.parmAgingBuckets() && contract.parmPrintAgingBucketDescription())
# {
# return strFmt('%1', custVendBalanceList.getDescription(6));
# }
# else
# {
# return #emptyString;
# }
#}
ENDSOURCE
SOURCE #headingAgingBucketDescription07
#/// <summary>
#/// Gets the heading description.
#/// </summary>
#/// <returns>
#/// The heading description text.
#/// </returns>
#private TransTxt headingAgingBucketDescription07()
#{
# if (contract.parmAgingBuckets() && contract.parmPrintAgingBucketDescription())
# {
# return strFmt('%1', custVendBalanceList.getDescription(7));
# }
# else
# {
# return #emptyString;
# }
#}
ENDSOURCE
SOURCE #headingDate
#private ColumnTxt headingDate()
#{
# switch (contract.parmDateTransactionDuedate())
# {
# case DateTransactionDuedate::DocumentDate : return "@SYS2587";
# case DateTransactionDuedate::TransactionDate : return "@SYS67";
# case DateTransactionDuedate::DueDate : return "@SYS14588";
# default : return "@SYS14588";
# }
#}
ENDSOURCE
SOURCE #initHeadingValues
#/// <summary>
#/// Assign and cache the heading values used for each record of the report
#/// </summary>
#private void initHeadingValues()
#{
# headingDate = this.headingDate();
# heading01 = this.heading01();
# heading011 = this.heading011();
# heading02 = this.heading02();
# heading02Text = this.heading02Text();
# heading021 = this.heading021();
# heading03 = this.heading03();
# heading031 = this.heading031();
# heading04 = this.heading04();
# heading041 = this.heading041();
# heading05 = this.heading05();
# heading051 = this.heading051();
# heading06 = this.heading06();
# heading061 = this.heading061();
# heading07 = this.heading07();
# heading07Text = this.heading07Text();
# heading071 = this.heading071();
# headingAgingBucketDescription02 = this.headingAgingBucketDescription02();
# headingAgingBucketDescription03 = this.headingAgingBucketDescription03();
# headingAgingBucketDescription04 = this.headingAgingBucketDescription04();
# headingAgingBucketDescription05 = this.headingAgingBucketDescription05();
# headingAgingBucketDescription06 = this.headingAgingBucketDescription06();
# headingAgingBucketDescription07 = this.headingAgingBucketDescription07();
#}
ENDSOURCE
SOURCE #insertVendAgingReportTmp
#/// <summary>
#/// Inserts records into the temporary <c>VendAgingReportTmp</c> table.
#/// </summary>
#/// <param name="_reverseAmountsAndHeadings">
#/// A boolean value which indicates whether the column values should be reversed.
#/// </param>
#/// <param name="_tmpTableRecordList">
#/// An existing RecordInsertList, which is used to store VendAgingReportTmp records for bulk insert.
#/// </param>
#private void insertVendAgingReportTmp(boolean _reverseAmountsAndHeadings, RecordInsertList _tmpTableRecordList)
#{
# Str1260 asOfDate = strFmt("@SYS84682", date2StrUsr(contract.parmZeroDate(), DateFlags::FormatAll), contract.parmDateTransactionDuedate());
# Addressing headingAccount = strFmt("@SYS24500");
# TransTxt headingName = strFmt("@SYS7399");
# AmountMST balance = 100;
# CustVendTransAging custVendTransAging = custVendBalanceList.getCustVendTransAging();
#
# if (_reverseAmountsAndHeadings)
# {
# insert_recordset vendAgingReportTmp
# (Blocked, EBCNameAlias, Balance01, Balance02, Balance03, Balance04, Balance05, Balance06, Balance07,
# Balance01cur, Balance02cur, Balance03cur, Balance04cur, Balance05cur, Balance06cur, Balance07cur,
# TransDate, InvoiceId, Voucher, AccountNum, Name, VendAccount, Txt, CurrencyCode, VendGroup,
# AsOfDate, HeadingAccount, HeadingName, HeadingDate, Heading1, Heading2DateValue, Heading2,
# Heading3, Heading4, Heading5, Heading6, Heading7DateValue, Heading7, Heading8, Heading9,
# Heading10, Heading11, Heading12, Heading13, Heading14, HeadingAgingBucketDescription02,
# HeadingAgingBucketDescription03, HeadingAgingBucketDescription04, HeadingAgingBucketDescription05,
# HeadingAgingBucketDescription06, HeadingAgingBucketDescription07, Balance, SortOrder)
# select
# Blocked, EBCNameAlias, Balance01, Balance07, Balance06, Balance05, Balance04, Balance03, Balance02,
# Balance01cur, Balance07cur, Balance06cur, Balance05cur, Balance04cur, Balance03cur, Balance02cur,
# TransDate, InvoiceId, Voucher, AccountNum, Name, AccountNum, Txt, CurrencyCode, GroupId,
# asOfDate, headingAccount, headingName, headingDate, heading01, heading02, heading07Text,
# heading03, heading04, heading05, heading06, heading07, heading02Text, heading011, heading03,
# heading031, heading041, heading051, heading061, heading061, headingAgingBucketDescription02,
# headingAgingBucketDescription03, headingAgingBucketDescription04, headingAgingBucketDescription05,
# headingAgingBucketDescription06, headingAgingBucketDescription07, balance
# from tmpAccountSum
# join SortOrder
# from custVendTransAging
# where tmpAccountSum.AccountNum == custVendTransAging.AccountNum;
#
# }
# else
# {
# insert_recordset vendAgingReportTmp
# (Blocked, EBCNameAlias, Balance01, Balance02, Balance03, Balance04, Balance05, Balance06, Balance07,
# Balance01cur, Balance02cur, Balance03cur, Balance04cur, Balance05cur, Balance06cur, Balance07cur,
# TransDate, InvoiceId, Voucher, AccountNum, Name, VendAccount, Txt, CurrencyCode, VendGroup,
# AsOfDate, HeadingAccount, HeadingName, HeadingDate, Heading1, Heading2DateValue, Heading2,
# Heading3, Heading4, Heading5, Heading6, Heading7DateValue, Heading7, Heading8, Heading9,
# Heading10, Heading11, Heading12, Heading13, Heading14, HeadingAgingBucketDescription02,
# HeadingAgingBucketDescription03, HeadingAgingBucketDescription04, HeadingAgingBucketDescription05,
# HeadingAgingBucketDescription06, HeadingAgingBucketDescription07, Balance, SortOrder)
# select
# Blocked, EBCNameAlias, Balance01, Balance02, Balance03, Balance04, Balance05, Balance06, Balance07,
# Balance01cur, Balance02cur, Balance03cur, Balance04cur, Balance05cur, Balance06cur, Balance07cur,
# TransDate, InvoiceId, Voucher, AccountNum, Name, AccountNum, Txt, CurrencyCode, GroupId,
# asOfDate, headingAccount, headingName, headingDate, heading01, heading02, heading02Text,
# heading03, heading04, heading05, heading06, heading07, heading07Text, heading011, heading021,
# heading031, heading041, heading051, heading061, heading071, headingAgingBucketDescription02,
# headingAgingBucketDescription03, headingAgingBucketDescription04, headingAgingBucketDescription05,
# headingAgingBucketDescription06, headingAgingBucketDescription07, balance
# from tmpAccountSum
# join SortOrder
# from custVendTransAging
# where tmpAccountSum.AccountNum == custVendTransAging.AccountNum;
# }
#}
#
#
ENDSOURCE
SOURCE #parmUseDefaultTransactionOnly
#public boolean parmUseDefaultTransactionOnly(boolean _useDefaultTransOnly = useDefaultTransOnly)
#{
# useDefaultTransOnly = true;
# return useDefaultTransOnly;
#}
ENDSOURCE
SOURCE #processReport
#/// <summary>
#/// Processes the report business logic.
#/// </summary>
#/// <remarks>
#/// This method is used to process the report business logic which is used by the <c>VendAgingReport</c> report.
#/// </remarks>
#[SysEntryPointAttribute]
#public void processReport()
#{
# QueryRun qr;
# ForwardBackwardPrinting tmpDirection;
# boolean reverseAmountsAndHeadings;
# RecordInsertList tmpTableRecordList = new RecordInsertList(tableNum(VendAgingReportTmp), true, true, true, false, true, vendAgingReportTmp);
#
# contract = this.parmDataContract() as EBCVendAgingPaymProposalContract;
#
# qr = new QueryRun(this.parmQuery());
#
# if (!contract.parmStartDate())
# {
# // When start date is not given then use the system session date.
# contract.parmStartDate(systemDateGet());
# }
#
# if (!contract.parmZeroDate())
# {
# // when balance as of date is not given then
# // use the max date.
# contract.parmZeroDate(dateMax());
# }
#
# if (contract.parmAgingBuckets())
# {
# // Force layout direction to backwards,
# // the actual direction of the columns is done in the construct method of the class: CustVendBalanceList
# tmpDirection = StatRepInterval::find(contract.parmAgingBuckets()).PrintDirection;
# }
# else
# {
# tmpDirection = contract.parmDirection();
# }
#
# reverseAmountsAndHeadings = this.getReverseAmountsAndHeadings(contract.parmAgingBuckets(), tmpDirection);
#
# custVendBalanceList = CustVendBalanceList::construct(SysModule::Vend,
# contract.parmDateTransactionDuedate(),
# contract.parmInterval(),
# contract.parmZeroDate());
# //contract.parmStartDate(),
# //contract.parmPayments(),
# //contract.parmPeriod(),
# //tmpDirection,
# ////contract.parmAgingBuckets(),
# //NoYes::Yes,
# //contract.parmDetailed(),
# //null,
# //NoYes::No,
# //contract.parmExcludeZeroBalanceVendor(),
# //!contract.parmPrintZeroOrNegative());
#
# custVendBalanceList.calculateDetailsForMultiple(qr, contract.parmIncludeAmountCur());
# //custVendBalanceList.calculateDetails(
# tmpAccountSum = custVendBalanceList.initTmpAccountSum();
#
# this.initHeadingValues();
#
# this.insertVendAgingReportTmp(reverseAmountsAndHeadings, tmpTableRecordList);
#}
#
ENDSOURCE
SOURCE #setVendAgingReportTmp
#// <summary>
#// Sets the values of headings , descriptions and amount fields of the temp table.
#// </summary>
#[SysObsoleteAttribute('This method is no longer used.', true)]
#private void setVendAgingReportTmp()
#{
# throw error(Error::wrongUseOfFunction(funcName()));
#}
ENDSOURCE
SOURCE #setVendAgingReportTmpInReverse
#// <summary>
#// Sets the values of headings, descriptions and amount fields of the temp table.
#// The amounts and description are reversed in order to match the selected direction value.
#// </summary>
#[SysObsoleteAttribute('This method is no longer used.', true)]
#private void setVendAgingReportTmpInReverse()
#{
# throw error(Error::wrongUseOfFunction(funcName()));
#}
ENDSOURCE
ENDMETHODS
ENDCLASS
***Element: PRN
; Microsoft Dynamics AX Project : EBC_CreditorPaymentProposal unloaded
; --------------------------------------------------------------------------------
PROJECTVERSION 2
PROJECT #EBC_CreditorPaymentProposal
SHARED
PROPERTIES
Name #EBC_CreditorPaymentProposal
Origin #{B0F44423-23CB-43BD-93D5-DADCE5FA1AD3}
ENDPROPERTIES
PROJECTCLASS ProjectNode
BEGINNODE
FILETYPE 0
UTILTYPE 127
UTILOBJECTID 0
NODETYPE 1531
NAME #EBCVendAgeingPaymReport
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 85
UTILOBJECTID 0
NODETYPE 1439
NAME #EBCVendAgingPaym
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 45
UTILOBJECTID 1021343
NODETYPE 329
NAME #VendDueAmountAnalysisContract_CN
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 44
UTILOBJECTID 100347
NODETYPE 204
NAME #CustVendBalanceTmp_CN
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 44
UTILOBJECTID 106506
NODETYPE 204
NAME #EBCVendAgingPaymTmp
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 45
UTILOBJECTID 1021317
NODETYPE 329
NAME #VendBalanceDP_CN
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 45
UTILOBJECTID 1031437
NODETYPE 329
NAME #EBCVendAgingPaymDP
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 45
UTILOBJECTID 1031436
NODETYPE 329
NAME #EBCVendAgingPaymContract
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 20
UTILOBJECTID 0
NODETYPE 330
NAME #EBCVendAgingPaym
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 44
UTILOBJECTID 10602
NODETYPE 204
NAME #VendAgingReportTmp
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 44
UTILOBJECTID 106505
NODETYPE 204
NAME #EBCVendAgingPaymProposalTmp
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 45
UTILOBJECTID 1031433
NODETYPE 329
NAME #EBCVendAgingPaymProposalContract
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 45
UTILOBJECTID 1031434
NODETYPE 329
NAME #EBCVendAgingPaymController
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 45
UTILOBJECTID 1031435
NODETYPE 329
NAME #EBCVendAgingPaymProposalDP
ENDNODE
ENDPROJECT
***Element: END
Formatversion: 1
***Element: VPA
; Microsoft Dynamics AX VISUALSTUDIOPROJECT : EBCVendAgeingPaymReport unloaded
; --------------------------------------------------------------------------------
VERSION 1
VISUALSTUDIOPROJECT #EBCVendAgeingPaymReport
PROPERTIES
Name #EBCVendAgeingPaymReport
ProjectGUID #{CF6B9965-8932-4378-9040-0C676AEFBA38}
ProjectTypeGUID #{AA631830-3AD7-4631-8CF6-443A09BF983B}
VisualStudioProjectFile #EBCVendAgeingPaymReport.dynamicsproj
Origin #{25BBE35B-E9B6-4DB9-841D-8D18DDB64AA8}
ENDPROPERTIES
REFERENCEDPROJECTS
#
ENDREFERENCEDPROJECTS
VISUALSTUDIOPROJECTFOLDER #Project Content
PROPERTIES
Name #Project Content
ENDPROPERTIES
VISUALSTUDIOPROJECTFILE #EBCVendAgeingPaymReport.dynamicsproj
PROPERTIES
Name #EBCVendAgeingPaymReport.dynamicsproj
ENDPROPERTIES
SOURCE 2202
#<?xml version="1.0" encoding="utf-8"?>
#<Project ToolsVersion="4.0" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
# <PropertyGroup>
# <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
# <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
# <ProductVersion>6.3.3000.111</ProductVersion>
# <SchemaVersion>2.0</SchemaVersion>
# <ProjectGuid>cf6b9965-8932-4378-9040-0c676aefba38</ProjectGuid>
# <ProjectTypeGuids>{BF6F8E12-879D-49E7-ADF0-5503146B24B8};{aa631830-3ad7-4631-8cf6-443a09bf983b}</ProjectTypeGuids>
# <Name>EBCVendAgeingPaymReport</Name>
# <BaseAssemblyName>EBCVendAgeingPaymReport</BaseAssemblyName>
# <!-- Application property page properties -->
# <OutputType>Dynamics Reporting Library</OutputType>
# <!-- AssemblyInfo properties -->
# <AssemblyTitle>EBCVendAgeingPaymReport</AssemblyTitle>
# <AssemblyCompany>
# </AssemblyCompany>
# <AssemblyProduct>EBCVendAgeingPaymReport</AssemblyProduct>
# <AssemblyCopyright>Copyright © 2018</AssemblyCopyright>
# <TargetFrameworkVersion>v4.5</TargetFrameworkVersion>
# <FileAlignment>512</FileAlignment>
# <OutputPath>bin\Debug\</OutputPath>
# <DeployToServer>No</DeployToServer>
# <DeployToClient>No</DeployToClient>
# <DeployToEP>No</DeployToEP>
# <RootNamespace>EBCVendAgeingPaymReport</RootNamespace>
# <StartupElement />
# <DebugTarget>None</DebugTarget>
# </PropertyGroup>
# <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
# <OutputPath>bin\Debug\</OutputPath>
# </PropertyGroup>
# <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
# <OutputPath>bin\Release\</OutputPath>
# </PropertyGroup>
# <ItemGroup>
# <Compile Include="\SSRS Reports\Reports\EBCVendAgingPaym">
# <Virtual>True</Virtual>
# </Compile>
# </ItemGroup>
# <Import Project="$(MSBuildExtensionsPath)\Microsoft\DynamicsTools\Microsoft.Dynamics.Framework.Design.Reporting.Modeling.targets" />
# <Import Project="$(MSBuildExtensionsPath)\Microsoft\DynamicsTools\Microsoft.Dynamics.Framework.Design.InteractionProject.targets" />
#</Project>
ENDSOURCE
ENDVISUALSTUDIOPROJECTFILE
ENDVISUALSTUDIOPROJECTFOLDER
VISUALSTUDIOPROJECTFOLDER #Project Output
PROPERTIES
Name #Project Output
ENDPROPERTIES
ENDVISUALSTUDIOPROJECTFOLDER
ENDVISUALSTUDIOPROJECT
***Element: SRP
; Microsoft Dynamics AX REPORT : EBCVendAgingPaym unloaded
; --------------------------------------------------------------------------------
VERSION 1
REPORT #EBCVendAgingPaym
PROPERTIES
Name #EBCVendAgingPaym
Origin #{C9A779D7-C94C-4C3C-A039-1BB6ED1A6DD4}
ENDPROPERTIES
CROSSREFERENCES
#<CrossReferenceInfo>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymDP</ReferencedAotObjectName>
# <xrefKind>10</xrefKind>
# <XrefReference>2</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymDP.EBCVendAgingPaymTmp</ReferencedAotObjectName>
# <xrefKind>11</xrefKind>
# <XrefReference>4</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymDP.processReport</ReferencedAotObjectName>
# <xrefKind>11</xrefKind>
# <XrefReference>4</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.AccountNum</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp</ReferencedAotObjectName>
# <xrefKind>1</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.ClosingBalance</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.Correct</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.CreditAmount</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.DebitAmount</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.MainAccountName</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>@SYS7902</ReferencedAotObjectName>
# <xrefKind>19</xrefKind>
# <XrefReference>2</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaym</ReferencedAotObjectName>
# <xrefKind>39</xrefKind>
# <XrefReference>2</XrefReference>
# </CrossReferenceEntry>
#</CrossReferenceInfo>
ENDCROSSREFERENCES
MOXL 10866
#<?xml version="1.0" encoding="utf-8" ?>
#<Reports Version="6.2.15.0">
# <Report Name="EBCVendAgingPaym">
# <DataSet Name="VendAgingPaymDetails" DataSourceType="ReportDataProvider" Query="SELECT EBCVendAgingPaymTmp.1.AccountNum,EBCVendAgingPaymTmp.1.ClosingBalance,EBCVendAgingPaymTmp.1.Correct:NAME(NoYes),EBCVendAgingPaymTmp.1.Correct:LABEL(NoYes),EBCVendAgingPaymTmp.1.CreditAmount,EBCVendAgingPaymTmp.1.DebitAmount,EBCVendAgingPaymTmp.1.MainAccountName FROM EBCVendAgingPaymDP.EBCVendAgingPaymTmp">
# <DataSetField Name="AccountNum" Alias="EBCVendAgingPaymTmp.1.AccountNum" Caption="@SYS1996" DisplayWidth="Auto" UserDefined="False"/>
# <DataSetField Name="ClosingBalance" Alias="EBCVendAgingPaymTmp.1.ClosingBalance" Caption="@SYS6928" DataType="System.Double" DisplayWidth="Auto" UserDefined="False"/>
# <DataSetField Name="Correct" Alias="EBCVendAgingPaymTmp.1.Correct:NAME(NoYes)" Caption="@SYS13069" DisableAutoCreateInDataRegion="True" DisplayWidth="Auto" UserDefined="False"/>
# <DataSetField Name="Correct1" Alias="EBCVendAgingPaymTmp.1.Correct:LABEL(NoYes)" Caption="@SYS13069" DisplayWidth="Auto" UserDefined="False"/>
# <DataSetField Name="CreditAmount" Alias="EBCVendAgingPaymTmp.1.CreditAmount" Caption="@SYS6928" DataType="System.Double" DisplayWidth="Auto" UserDefined="False"/>
# <DataSetField Name="DebitAmount" Alias="EBCVendAgingPaymTmp.1.DebitAmount" Caption="@SYS6928" DataType="System.Double" DisplayWidth="Auto" UserDefined="False"/>
# <DataSetField Name="MainAccountName" Alias="EBCVendAgingPaymTmp.1.MainAccountName" Caption="@SYS9624" DisplayWidth="Auto" UserDefined="False"/>
# <DataSetParameter Name="AX_PartitionKey" Alias="AX_PartitionKey" DataType="System.String" Parameter=":EBCVendAgingPaym.Parameters.AX_PartitionKey"/>
# <DataSetParameter Name="AX_CompanyName" Alias="AX_CompanyName" DataType="System.String" Parameter=":EBCVendAgingPaym.Parameters.AX_CompanyName"/>
# <DataSetParameter Name="AX_UserContext" Alias="AX_UserContext" DataType="System.String" Parameter=":EBCVendAgingPaym.Parameters.AX_UserContext"/>
# <DataSetParameter Name="AX_RenderingCulture" Alias="AX_RenderingCulture" DataType="System.String" Parameter=":EBCVendAgingPaym.Parameters.AX_RenderingCulture"/>
# <DataSetParameter Name="AX_ReportContext" Alias="AX_ReportContext" DataType="System.String" Parameter=":EBCVendAgingPaym.Parameters.AX_ReportContext"/>
# <DataSetParameter Name="AX_RdpPreProcessedId" Alias="AX_RdpPreProcessedId" DataType="System.String" Parameter=":EBCVendAgingPaym.Parameters.AX_RdpPreProcessedId"/>
# <DataSetParameter Name="AsOn" Alias="AsOn" DataType="System.DateTime" Parameter=":EBCVendAgingPaym.Parameters.VendAgingPaymDetails_AsOn"/>
# <DataSetParameter Name="EBCVendAgingPaymDP_DynamicParameter" Alias="EBCVendAgingPaymDP_DynamicParameter" DataType="Microsoft.Dynamics.AX.Framework.Services.Client.QueryMetadata" Parameter=":EBCVendAgingPaym.Parameters.EBCVendAgingPaymDP_DynamicParameter"/>
# </DataSet>
# <ParameterGroup Name="Parameters">
# <Parameter Name="AX_PartitionKey" AllowBlank="True" Nullable="True" UserVisibility="Hidden"/>
# <Parameter Name="AX_CompanyName" UserVisibility="Hidden">
# <UnboundDefault Name="UnboundDefault" Value="=Microsoft.Dynamics.Framework.Reports.BuiltInMethods.GetUserCompany(Parameters!AX_UserContext.Value)"/>
# </Parameter>
# <Parameter Name="AX_UserContext" AllowBlank="True" Nullable="True" UserVisibility="Hidden"/>
# <Parameter Name="AX_RenderingCulture" AllowBlank="True" Nullable="True" UserVisibility="Hidden"/>
# <Parameter Name="AX_ReportContext" AllowBlank="True" Nullable="True" UserVisibility="Hidden"/>
# <Parameter Name="AX_RdpPreProcessedId" AllowBlank="True" Nullable="True" UserVisibility="Hidden"/>
# <Parameter Name="VendAgingPaymDetails_AsOn" DataType="System.DateTime" PromptString="@SYS7902"/>
# <Parameter Name="EBCVendAgingPaymDP_DynamicParameter" AllowBlank="True" AOTQuery="EBCVendAgingPaym" DataType="Microsoft.Dynamics.AX.Framework.Services.Client.QueryMetadata" Nullable="True" UserVisibility="Hidden"/>
# </ParameterGroup>
# <PrecisionDesign Name="Report" StyleTemplate=":TableStyleTemplate" Text="<?xml version="1.0" encoding="utf-8"?><Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"><rd:ExpressionDialog>Microsoft.Dynamics.Framework.Design.Reports.ExpressionEditor.ExpressionEditorDialog, Microsoft.Dynamics.Framework.Design.Reports</rd:ExpressionDialog><rd:SnapToGrid>true</rd:SnapToGrid><rd:DrawGrid>true</rd:DrawGrid><Page><BottomMargin>1in</BottomMargin><RightMargin>1in</RightMargin><LeftMargin>1in</LeftMargin><TopMargin>1in</TopMargin><InteractiveWidth>8.5in</InteractiveWidth><InteractiveHeight>11in</InteractiveHeight></Page><Body><Height>3.0in</Height></Body><Width>8.5in</Width><Language>en-US</Language><rd:ReportID>03bd922e-37d3-4701-821b-4c2aa643c400</rd:ReportID></Report>">
# <DisableIndividualTransformation Name="DisableIndividualTransformation"/>
# </PrecisionDesign>
# </Report>
#</Reports>
ENDMOXL
DESIGNS
SSRSREPORTDESIGN
PROPERTIES
Name #Report
ENDPROPERTIES
CROSSREFERENCES
#<CrossReferenceInfo>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymDP</ReferencedAotObjectName>
# <xrefKind>10</xrefKind>
# <XrefReference>2</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymDP.EBCVendAgingPaymTmp</ReferencedAotObjectName>
# <xrefKind>11</xrefKind>
# <XrefReference>4</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymDP.processReport</ReferencedAotObjectName>
# <xrefKind>11</xrefKind>
# <XrefReference>4</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.AccountNum</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp</ReferencedAotObjectName>
# <xrefKind>1</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.ClosingBalance</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.Correct</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.CreditAmount</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.DebitAmount</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaymTmp.MainAccountName</ReferencedAotObjectName>
# <xrefKind>2</xrefKind>
# <XrefReference>1</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>@SYS7902</ReferencedAotObjectName>
# <xrefKind>19</xrefKind>
# <XrefReference>2</XrefReference>
# </CrossReferenceEntry>
# <CrossReferenceEntry>
# <ReferencedAotObjectName>EBCVendAgingPaym</ReferencedAotObjectName>
# <xrefKind>39</xrefKind>
# <XrefReference>2</XrefReference>
# </CrossReferenceEntry>
#</CrossReferenceInfo>
ENDCROSSREFERENCES
RDL 17146
#<?xml version="1.0" encoding="utf-8"?>
#<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
# <rd:ExpressionDialog>Microsoft.Dynamics.Framework.Design.Reports.ExpressionEditor.ExpressionEditorDialog, Microsoft.Dynamics.Framework.Design.Reports</rd:ExpressionDialog>
# <rd:SnapToGrid>true</rd:SnapToGrid>
# <rd:DrawGrid>true</rd:DrawGrid>
# <Page>
# <BottomMargin>1in</BottomMargin>
# <RightMargin>1in</RightMargin>
# <LeftMargin>1in</LeftMargin>
# <TopMargin>1in</TopMargin>
# <InteractiveWidth>8.5in</InteractiveWidth>
# <InteractiveHeight>11in</InteractiveHeight>
# </Page>
# <Body>
# <Height>3.0in</Height>
# </Body>
# <Width>8.5in</Width>
# <Language>en-US</Language>
# <rd:ReportID>03bd922e-37d3-4701-821b-4c2aa643c400</rd:ReportID>
# <DataSources>
# <DataSource Name="AutoGen__ReportDataProvider">
# <Transaction>true</Transaction>
# <ConnectionProperties>
# <DataProvider>AXREPORTDATAPROVIDER</DataProvider>
# <ConnectString />
# <IntegratedSecurity>true</IntegratedSecurity>
# </ConnectionProperties>
# <rd:DataSourceID>5f70fabe-5273-4a11-93dc-ddea28522b36</rd:DataSourceID>
# </DataSource>
# </DataSources>
# <DataSets>
# <DataSet Name="VendAgingPaymDetails">
# <Fields>
# <Field Name="AccountNum">
# <DataField>EBCVendAgingPaymTmp.1.AccountNum</DataField>
# <rd:TypeName>System.String</rd:TypeName>
# </Field>
# <Field Name="ClosingBalance">
# <DataField>EBCVendAgingPaymTmp.1.ClosingBalance</DataField>
# <rd:TypeName>System.Double</rd:TypeName>
# </Field>
# <Field Name="Correct">
# <DataField>EBCVendAgingPaymTmp.1.Correct:NAME(NoYes)</DataField>
# <rd:TypeName>System.String</rd:TypeName>
# </Field>
# <Field Name="Correct1">
# <DataField>EBCVendAgingPaymTmp.1.Correct:LABEL(NoYes)</DataField>
# <rd:TypeName>System.String</rd:TypeName>
# </Field>
# <Field Name="CreditAmount">
# <DataField>EBCVendAgingPaymTmp.1.CreditAmount</DataField>
# <rd:TypeName>System.Double</rd:TypeName>
# </Field>
# <Field Name="DebitAmount">
# <DataField>EBCVendAgingPaymTmp.1.DebitAmount</DataField>
# <rd:TypeName>System.Double</rd:TypeName>
# </Field>
# <Field Name="MainAccountName">
# <DataField>EBCVendAgingPaymTmp.1.MainAccountName</DataField>
# <rd:TypeName>System.String</rd:TypeName>
# </Field>
# </Fields>
# <Query>
# <QueryParameters>
# <QueryParameter Name="AX_PartitionKey">
# <Value>=Parameters!AX_PartitionKey.Value</Value>
# </QueryParameter>
# <QueryParameter Name="AX_CompanyName">
# <Value>=Parameters!AX_CompanyName.Value</Value>
# </QueryParameter>
# <QueryParameter Name="AX_UserContext">
# <Value>=Parameters!AX_UserContext.Value</Value>
# </QueryParameter>
# <QueryParameter Name="AX_RenderingCulture">
# <Value>=Parameters!AX_RenderingCulture.Value</Value>
# </QueryParameter>
# <QueryParameter Name="AX_ReportContext">
# <Value>=Parameters!AX_ReportContext.Value</Value>
# </QueryParameter>
# <QueryParameter Name="AX_RdpPreProcessedId">
# <Value>=Parameters!AX_RdpPreProcessedId.Value</Value>
# </QueryParameter>
# <QueryParameter Name="AsOn">
# <Value>=Parameters!VendAgingPaymDetails_AsOn.Value</Value>
# </QueryParameter>
# <QueryParameter Name="EBCVendAgingPaymDP_DynamicParameter">
# <Value>=Parameters!EBCVendAgingPaymDP_DynamicParameter.Value</Value>
# </QueryParameter>
# </QueryParameters>
# <DataSourceName>AutoGen__ReportDataProvider</DataSourceName>
# <CommandType>Text</CommandType>
# <CommandText>SELECT EBCVendAgingPaymTmp.1.AccountNum,EBCVendAgingPaymTmp.1.ClosingBalance,EBCVendAgingPaymTmp.1.Correct:NAME(NoYes),EBCVendAgingPaymTmp.1.Correct:LABEL(NoYes),EBCVendAgingPaymTmp.1.CreditAmount,EBCVendAgingPaymTmp.1.DebitAmount,EBCVendAgingPaymTmp.1.MainAccountName FROM EBCVendAgingPaymDP.EBCVendAgingPaymTmp</CommandText>
# <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
# </Query>
# <rd:DataSetInfo>
# <rd:TableAdapterGetDataMethod>GetData</rd:TableAdapterGetDataMethod>
# <rd:DataSetName>VendAgingPaymDetails</rd:DataSetName>
# <rd:TableAdapterFillMethod>Fill</rd:TableAdapterFillMethod>
# <rd:TableAdapterName>FieldsTableAdapter</rd:TableAdapterName>
# <rd:TableName>Fields</rd:TableName>
# </rd:DataSetInfo>
# </DataSet>
# </DataSets>
# <ReportParameters>
# <ReportParameter Name="AX_PartitionKey">
# <DataType>String</DataType>
# <Nullable>true</Nullable>
# <Hidden>true</Hidden>
# <AllowBlank>true</AllowBlank>
# <Prompt>AX_PartitionKey</Prompt>
# <MultiValue>false</MultiValue>
# </ReportParameter>
# <ReportParameter Name="AX_UserContext">
# <DataType>String</DataType>
# <Nullable>true</Nullable>
# <Hidden>true</Hidden>
# <AllowBlank>true</AllowBlank>
# <Prompt>AX_UserContext</Prompt>
# <MultiValue>false</MultiValue>
# </ReportParameter>
# <ReportParameter Name="AX_CompanyName">
# <DataType>String</DataType>
# <Nullable>false</Nullable>
# <Hidden>true</Hidden>
# <DefaultValue>
# <Values>
# <Value>=Microsoft.Dynamics.Framework.Reports.BuiltInMethods.GetUserCompany(Parameters!AX_UserContext.Value)</Value>
# </Values>
# </DefaultValue>
# <AllowBlank>false</AllowBlank>
# <Prompt>AX_CompanyName</Prompt>
# <MultiValue>false</MultiValue>
# </ReportParameter>
# <ReportParameter Name="AX_RenderingCulture">
# <DataType>String</DataType>
# <Nullable>true</Nullable>
# <Hidden>true</Hidden>
# <AllowBlank>true</AllowBlank>
# <Prompt>AX_RenderingCulture</Prompt>
# <MultiValue>false</MultiValue>
# </ReportParameter>
# <ReportParameter Name="AX_ReportContext">
# <DataType>String</DataType>
# <Nullable>true</Nullable>
# <Hidden>true</Hidden>
# <AllowBlank>true</AllowBlank>
# <Prompt>AX_ReportContext</Prompt>
# <MultiValue>false</MultiValue>
# <UsedInQuery>True</UsedInQuery>
# </ReportParameter>
# <ReportParameter Name="AX_RdpPreProcessedId">
# <DataType>String</DataType>
# <Nullable>true</Nullable>
# <Hidden>true</Hidden>
# <AllowBlank>true</AllowBlank>
# <Prompt>AX_RdpPreProcessedId</Prompt>
# <MultiValue>false</MultiValue>
# </ReportParameter>
# <ReportParameter Name="VendAgingPaymDetails_AsOn">
# <DataType>DateTime</DataType>
# <Nullable>false</Nullable>
# <Hidden>false</Hidden>
# <AllowBlank>false</AllowBlank>
# <Prompt>As on</Prompt>
# <MultiValue>false</MultiValue>
# </ReportParameter>
# <ReportParameter Name="EBCVendAgingPaymDP_DynamicParameter">
# <DataType>String</DataType>
# <Nullable>true</Nullable>
# <Hidden>true</Hidden>
# <AllowBlank>true</AllowBlank>
# <Prompt>EBCVendAgingPaymDP_DynamicParameter</Prompt>
# <MultiValue>false</MultiValue>
# </ReportParameter>
# </ReportParameters>
# <CodeModules>
# <CodeModule>Microsoft.Dynamics.Framework.Reports, Version=6.3.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35</CodeModule>
# <CodeModule>Microsoft.Dynamics.Framework.Metadata.AX, Version=6.3.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35</CodeModule>
# </CodeModules>
# <Code>Protected Overrides Sub OnInit()
# Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ReportInitialize()
#End Sub
#
#</Code>
# <CustomProperties>
# <CustomProperty>
# <Name>DynamicParameterAOTQueryName_EBCVendAgingPaymDP_DynamicParameter</Name>
# <Value>EBCVendAgingPaym</Value>
# </CustomProperty>
# <CustomProperty>
# <Name>DATASETSFIELDS</Name>
# <Value><![CDATA[VendAgingPaymDetails:AccountNum.EBCVendAgingPaymTmp.AccountNum;ClosingBalance.EBCVendAgingPaymTmp.ClosingBalance;Correct.EBCVendAgingPaymTmp.Correct;Correct1.EBCVendAgingPaymTmp.Correct;CreditAmount.EBCVendAgingPaymTmp.CreditAmount;DebitAmount.EBCVendAgingPaymTmp.DebitAmount;MainAccountName.EBCVendAgingPaymTmp.MainAccountName]]></Value>
# </CustomProperty>
# </CustomProperties>
#</Report>
ENDRDL
PERMISSIONSET #Permissions
PROPERTIES
ENDPROPERTIES
TABLES #Tables
ENDTABLES
SERVERMETHODS #Server Methods
ENDSERVERMETHODS
ASSOCIATEDFORMS #Associated Forms
ENDASSOCIATEDFORMS
ENDPERMISSIONSET
ENDSSRSREPORTDESIGN
ENDDESIGNS
ENDREPORT
***Element: CLS
; Microsoft Dynamics AX Class: VendDueAmountAnalysisContract_CN unloaded
; --------------------------------------------------------------------------------
CLSVERSION 1
CLASS #VendDueAmountAnalysisContract_CN
PROPERTIES
Name #VendDueAmountAnalysisContract_CN
Origin #{45253A72-5621-441C-8AD9-C85812BB2F66}
ENDPROPERTIES
METHODS
SOURCE #classDeclaration
#/// <summary>
#/// The <c>VendDueAmountAnalysisContract_CN</c> is contract class for <c>VendDueAmountAnalysis_CN</c> SSRS report.
#/// </summary>
#[DataContractAttribute]
#public class VendDueAmountAnalysisContract_CN
#{
# TransDate asOn;
#}
#
ENDSOURCE
SOURCE #parmAsOn
#/// <summary>
#/// Gets or sets the value of the datacontract parameter asOn.
#/// </summary>
#/// <param name="_asOn">
#/// The new value of the datacontract parameter asOn.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter asOn.
#/// </returns>
#[
# DataMemberAttribute('AsOn'),
# SysOperationLabelAttribute(literalstr("@SYS7902")),
# SysOperationHelpTextAttribute(literalstr("@SYS7902"))
#]
#public TransDate parmAsOn(TransDate _asOn = asOn)
#{
# asOn = _asOn;
# return asOn;
#}
ENDSOURCE
ENDMETHODS
ENDCLASS
***Element: DBT
; Microsoft Dynamics AX Table : CustVendBalanceTmp_CN unloaded
; --------------------------------------------------------------------------------
TABLEVERSION 1
TABLE #CustVendBalanceTmp_CN
EnforceFKRelation 1
PROPERTIES
Name #CustVendBalanceTmp_CN
Label #@GLS107030
TableType #InMemory
ConfigurationKey #LedgerBasic
MaxAccessMode #NoAccess
Visible #No
CreateRecIdIndex #Yes
PrimaryIndex #SurrogateKey
ClusterIndex #SurrogateKey
DeveloperDocumentation #@GLS100103
CountryRegionCodes #CN
Origin #{66BA81D0-C2A8-4470-B623-1F4C030EE74D}
ENDPROPERTIES
FIELDS
FIELD #AccountNum
STRING
PROPERTIES
Name #AccountNum
Table #CustVendBalanceTmp_CN
Origin #{53F7AA0C-3633-4520-B1A1-0F3E57C4954F}
ExtendedDataType #AccountNum
StringSize #20
ENDPROPERTIES
FIELD #ClosingBalance
REAL
PROPERTIES
Name #ClosingBalance
Table #CustVendBalanceTmp_CN
Origin #{54F1C519-3FC7-4B30-B72E-D4CB42D1DE42}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Correct
ENUM
PROPERTIES
Name #Correct
Table #CustVendBalanceTmp_CN
Origin #{D2C39FF9-A7A7-42EB-AE53-B20194E35E9F}
ExtendedDataType #Correct
EnumType #NoYes
ENDPROPERTIES
FIELD #CreditAmount
REAL
PROPERTIES
Name #CreditAmount
Table #CustVendBalanceTmp_CN
Origin #{C0BA3B78-89A8-4822-8406-56F3D0626C6D}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #DebitAmount
REAL
PROPERTIES
Name #DebitAmount
Table #CustVendBalanceTmp_CN
Origin #{8047937A-89E2-463D-B599-08AAD3C70E39}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #MainAccountName
STRING
PROPERTIES
Name #MainAccountName
Table #CustVendBalanceTmp_CN
Origin #{0120E1EB-DA64-4DFD-BCCE-61E1B6CAD725}
ExtendedDataType #AccountName
StringSize #60
ENDPROPERTIES
FIELD #MainAccountNum
STRING
PROPERTIES
Name #MainAccountNum
Table #CustVendBalanceTmp_CN
Origin #{DF0033B4-AE8D-461D-96E2-BDD18065CEAB}
ExtendedDataType #MainAccountNum
StringSize #20
ENDPROPERTIES
FIELD #OpeningBalance
REAL
PROPERTIES
Name #OpeningBalance
Table #CustVendBalanceTmp_CN
Origin #{266D7A2F-A6F6-487A-94FE-D2514C3668DA}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #PartyAccountName
STRING
PROPERTIES
Name #PartyAccountName
Table #CustVendBalanceTmp_CN
Origin #{CA987529-208A-48A6-98AA-3EAE1E6165DC}
ExtendedDataType #DirPartyName
StringSize #100
ENDPROPERTIES
FIELD #PeriodCode
STRING
PROPERTIES
Name #PeriodCode
Table #CustVendBalanceTmp_CN
Origin #{351F7C3F-8D8B-47C8-995A-39BCE0BC5F29}
ExtendedDataType #String255
StringSize #255
ENDPROPERTIES
FIELD #TransDate
DATE
PROPERTIES
Name #TransDate
Table #CustVendBalanceTmp_CN
Origin #{8CD76EF3-042B-4A52-94E7-639619CB10B9}
ExtendedDataType #TransDate
ENDPROPERTIES
ENDFIELDS
GROUPS
ENDGROUPS
INDICES
ENDINDICES
FULLTEXTINDICES
ENDFULLTEXTINDICES
REFERENCES
REFERENCE #MainAccount
PROPERTIES
Name #MainAccount
Table #MainAccount
RelatedTableCardinality #ZeroOne
Cardinality #ZeroMore
RelationshipType #Association
UseDefaultRoleNames #Yes
EDTRelation #Yes
ENDPROPERTIES
FIELDREFERENCES
REFERENCETYPE NORMAL
PROPERTIES
Field #MainAccountNum
RelatedField #MainAccountId
SourceEDT #MainAccountNum
ENDPROPERTIES
ENDFIELDREFERENCES
ENDREFERENCE
ENDREFERENCES
DELETEACTIONS
ENDDELETEACTIONS
METHODS
ENDMETHODS
ENDTABLE
***Element: DBT
; Microsoft Dynamics AX Table : EBCVendAgingPaymTmp unloaded
; --------------------------------------------------------------------------------
TABLEVERSION 1
TABLE #EBCVendAgingPaymTmp
EnforceFKRelation 1
PROPERTIES
Name #EBCVendAgingPaymTmp
Label #@GLS107030
TableType #InMemory
ConfigurationKey #LedgerBasic
MaxAccessMode #NoAccess
Visible #No
CreateRecIdIndex #Yes
PrimaryIndex #SurrogateKey
ClusterIndex #SurrogateKey
DeveloperDocumentation #@GLS100103
CountryRegionCodes #CN
Origin #{2C078D35-860D-4E5F-93C8-26E9CC45AD5B}
ENDPROPERTIES
FIELDS
FIELD #AccountNum
STRING
PROPERTIES
Name #AccountNum
Table #EBCVendAgingPaymTmp
Origin #{F2CE0A30-7467-4C8D-8DFC-515498B901C8}
ExtendedDataType #AccountNum
StringSize #20
ENDPROPERTIES
FIELD #ClosingBalance
REAL
PROPERTIES
Name #ClosingBalance
Table #EBCVendAgingPaymTmp
Origin #{138B2C34-C618-480A-9721-477CEEFD5A9B}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Correct
ENUM
PROPERTIES
Name #Correct
Table #EBCVendAgingPaymTmp
Origin #{758A866A-BD01-4234-86C5-E1DB85D8071B}
ExtendedDataType #Correct
EnumType #NoYes
ENDPROPERTIES
FIELD #CreditAmount
REAL
PROPERTIES
Name #CreditAmount
Table #EBCVendAgingPaymTmp
Origin #{3C927268-98A9-4922-88B1-D080BD4178B7}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #DebitAmount
REAL
PROPERTIES
Name #DebitAmount
Table #EBCVendAgingPaymTmp
Origin #{8F79427A-99E8-4C4D-A77E-82DCBEFA9D3A}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #MainAccountName
STRING
PROPERTIES
Name #MainAccountName
Table #EBCVendAgingPaymTmp
Origin #{7627E036-7CCB-46CD-8086-C0D65B80F483}
ExtendedDataType #AccountName
StringSize #60
ENDPROPERTIES
FIELD #MainAccountNum
STRING
PROPERTIES
Name #MainAccountNum
Table #EBCVendAgingPaymTmp
Origin #{96D2DD32-8165-4CA8-B9B9-9E76AE627C1C}
ExtendedDataType #MainAccountNum
StringSize #20
ENDPROPERTIES
FIELD #OpeningBalance
REAL
PROPERTIES
Name #OpeningBalance
Table #EBCVendAgingPaymTmp
Origin #{33637E69-8DA7-408B-BEB6-7A559E68409B}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #PartyAccountName
STRING
PROPERTIES
Name #PartyAccountName
Table #EBCVendAgingPaymTmp
Origin #{E1F61501-F689-466A-92FD-ADCC9F9AFE86}
ExtendedDataType #DirPartyName
StringSize #100
ENDPROPERTIES
FIELD #PeriodCode
STRING
PROPERTIES
Name #PeriodCode
Table #EBCVendAgingPaymTmp
Origin #{682E5027-A9ED-443F-BB8D-FFC95AF6486A}
ExtendedDataType #String255
StringSize #255
ENDPROPERTIES
FIELD #TransDate
DATE
PROPERTIES
Name #TransDate
Table #EBCVendAgingPaymTmp
Origin #{A3632585-2660-4CD3-A6F1-6AA9E3CD8C8E}
ExtendedDataType #TransDate
ENDPROPERTIES
ENDFIELDS
GROUPS
ENDGROUPS
INDICES
ENDINDICES
FULLTEXTINDICES
ENDFULLTEXTINDICES
REFERENCES
REFERENCE #MainAccount
PROPERTIES
Name #MainAccount
Table #MainAccount
RelatedTableCardinality #ZeroOne
Cardinality #ZeroMore
RelationshipType #Association
UseDefaultRoleNames #Yes
EDTRelation #Yes
ENDPROPERTIES
FIELDREFERENCES
REFERENCETYPE NORMAL
PROPERTIES
Field #MainAccountNum
RelatedField #MainAccountId
ENDPROPERTIES
ENDFIELDREFERENCES
ENDREFERENCE
ENDREFERENCES
DELETEACTIONS
ENDDELETEACTIONS
METHODS
ENDMETHODS
ENDTABLE
***Element: CLS
; Microsoft Dynamics AX Class: VendBalanceDP_CN unloaded
; --------------------------------------------------------------------------------
CLSVERSION 1
CLASS #VendBalanceDP_CN
PROPERTIES
Name #VendBalanceDP_CN
Extends #SRSReportDataProviderBase
RunOn #Server
Origin #{A9A35685-2374-4837-AA7A-3B53CE2B3D89}
ENDPROPERTIES
METHODS
SOURCE #classDeclaration
#/// <summary>
#/// The <c>VendBalanceDP_CN</c> is the
#/// data provider class for <c>VendBalance_CN</c> report.
#/// </summary>
#/// <remarks>
#/// The <c>CustBalanceDP_CN</c> and <c>VendBalanceDP_CN</c> use
#/// similar logic, so any change in one class requires the other class to be changed.
#/// </remarks>
#[
# SRSReportQueryAttribute(queryStr(VendBalance_CN)),
# SRSReportParameterAttribute(classStr(LedgerFiscalPeriodNameContract_CN))
#]
#public class VendBalanceDP_CN extends SRSReportDataProviderBase
#{
# CustVendBalanceTmp_CN custVendBalanceTmp_CN;
#}
ENDSOURCE
SOURCE #getCustVendBalanceTmp_CN
#/// <summary>
#/// Retrieves the data used by <c>VendBalance_CN</c> report.
#/// </summary>
#/// <returns>
#/// Temporary table <c>CustVendBalanceTmp_CN</c>.
#/// </returns>
#[ SRSReportDataSetAttribute(tableStr(CustVendBalanceTmp_CN)) ]
#public CustVendBalanceTmp_CN getCustVendBalanceTmp_CN()
#{
# return custVendBalanceTmp_CN;
#}
ENDSOURCE
SOURCE #insertCustVendBalanceTmp_CN
#/// <summary>
#/// Inserts records into <c>CustVendBalanceTmp_CN</c> table.
#/// </summary>
#/// <param name="_mainAccount">
#/// Assigns a value to MainAccountNum field of above mentioned table.
#/// </param>
#/// <param name="_mainAccountName">
#/// Assigns a value to MainAccountName field of above mentioned table.
#/// </param>
#/// <param name="_vendAccountNum">
#/// Assigns a value to AccountNum field of above mentioned table.
#/// </param>
#/// <param name="_dirPartyName">
#/// Assigns a value to PartyAccountName field of above mentioned table.
#/// </param>
#/// <param name="_openingBalance">
#/// Assigns a value to OpeningBalance field of above mentioned table.
#/// </param>
#/// <param name="_debitBalance">
#/// Assigns a value to DebitAmount field of above mentioned table.
#/// </param>
#/// <param name="_creditBalance">
#/// Assigns a value to CreditAmount field of above mentioned table.
#/// </param>
#/// <param name="_periodCode">
#/// Sends period code of the ledger period selected.
#/// </param>
#private void insertCustVendBalanceTmp_CN(
# MainAccountNum _mainAccount,
# AccountName _mainAccountName,
# AccountNum _vendAccountNum,
# DirPartyName _dirPartyName,
# AmountMST _openingBalance,
# AmountMST _debitBalance,
# AmountMST _creditBalance,
# String255 _periodCode)
#{
# custVendBalanceTmp_CN.AccountNum = _vendAccountNum;
# custVendBalanceTmp_CN.PartyAccountName = _dirPartyName;
# custVendBalanceTmp_CN.MainAccountNum = _mainAccount;
# custVendBalanceTmp_CN.MainAccountName = _mainAccountName;
# custVendBalanceTmp_CN.OpeningBalance = _openingBalance;
# custVendBalanceTmp_CN.DebitAmount = _debitBalance;
# custVendBalanceTmp_CN.CreditAmount = -_creditBalance;
# custVendBalanceTmp_CN.PeriodCode = _periodCode;
# custVendBalanceTmp_CN.ClosingBalance = _openingBalance + _debitBalance + _creditBalance;
# custVendBalanceTmp_CN.insert();
#}
ENDSOURCE
SOURCE #processReport
#[SysEntryPointAttribute]
#public void processReport()
#{
# VendTable vendTable;
# VendTrans vendTrans;
# MainAccount mainAccount;
# TransDate currentTransDate, fromdate, todate;
# AccountNum curVendAccountNum;
# MainAccountNum curMainAccountNum;
# Name mainAccountName;
# DirPartyName vendAccountName;
# Query query;
# QueryRun queryRun;
# AmountMST openingBalance, creditBalance, debitBalance;
# LedgerFiscalPeriodNameContract_CN contract;
# CustVendBalanceTmp_CN localCopy;
# LedgerDimensionDefaultAccount defaultAccount;
# DimensionAttributeValueCombination dimensionAttribute;
# String255 periodCode, fromPeriodName, toPeriodName;
# FiscalCalendarPeriod currFiscalPeriod;
#
# query = this.parmQuery();
# contract = this.parmDataContract() as LedgerFiscalPeriodNameContract_CN;
#
# if ( !contract.parmFromDate() || !contract.parmToDate())
# {
# currFiscalPeriod = FiscalCalendarPeriod::currentLedgePeriod_CN();
# }
#
# fromdate = (contract.parmFromDate()) ? contract.parmFromDate() : currFiscalPeriod.StartDate;
# todate = (contract.parmToDate()) ? contract.parmToDate() : currFiscalPeriod.EndDate;
# fromPeriodName = (contract.parmFromPeriod()) ? contract.parmFromPeriod() : currFiscalPeriod.Name;
# toPeriodName = (contract.parmToPeriod()) ? contract.parmToPeriod() : currFiscalPeriod.Name;
# periodCode = fromPeriodName + '-' + toPeriodName;
#
# query.dataSourceTable(tableNum(VendTrans)).addRange(fieldNum(VendTrans, TransDate)).value(
# SysQuery::range(dateNull(), todate));
# queryRun = new queryRun(query);
# while (queryRun.next())
# {
# vendTable = queryRun.get(tableNum(VendTable));
# vendTrans = queryRun.get(tableNum(VendTrans));
#
# localCopy.AccountNum = vendTable.AccountNum;
# localCopy.PartyAccountName = DirPartyTable::getName(vendTable.Party);
# localCopy.TransDate = vendTrans.TransDate;
# localCopy.CreditAmount = vendTrans.AmountMST;
# localCopy.Correct = vendTrans.Correct;
# defaultAccount = VendLedgerAccounts::summaryLedgerDimension(
# vendTable.AccountNum,
# vendTrans.PostingProfile);
#
# dimensionAttribute = DimensionAttributeValueCombination::find(defaultAccount);
# mainAccount = mainAccount::find(dimensionAttribute.MainAccount);
# localCopy.MainAccountName = mainAccount.localizedName();
# localCopy.MainAccountNum = mainAccount.MainAccountId;
# localCopy.insert();
# }
#
# while select * from localCopy
# order by localCopy.AccountNum, localCopy.MainAccountName, localCopy.TransDate asc
# {
#
# currentTransDate = localCopy.TransDate;
#
# if (!curVendAccountNum && !curMainAccountNum)
# {
# curMainAccountNum = localCopy.MainAccountNum;
# curVendAccountNum = localCopy.AccountNum;
# mainAccountName = localCopy.MainAccountName;
# vendAccountName = localCopy.PartyAccountName;
# }
#
# if (curVendAccountNum == localCopy.AccountNum
# && curMainAccountNum == localCopy.MainAccountNum )
# {
# if (currentTransDate < fromdate)
# {
# openingBalance += localCopy.CreditAmount ;
# }
# else
# {
# creditBalance += ((localCopy.CreditAmount <= 0 || (localCopy.CreditAmount > 0 && localCopy.Correct)) ? localCopy.CreditAmount : 0.00);
# debitBalance += ((localCopy.CreditAmount > 0 && !localCopy.Correct) ? localCopy.CreditAmount : 0.00);
# }
# }
# else
# {
# this.insertCustVendBalanceTmp_CN(
# curMainAccountNum,
# mainAccountName,
# curVendAccountNum,
# vendAccountName,
# openingBalance,
# debitBalance,
# creditBalance,
# periodCode);
#
# curMainAccountNum = localCopy.MainAccountNum;
# curVendAccountNum = localCopy.AccountNum;
# mainAccountName = localCopy.MainAccountName;
# vendAccountName = localCopy.PartyAccountName;
# creditBalance = 0.00;
# debitBalance = 0.00;
# openingBalance = 0.00;
# if (currentTransDate < fromdate)
# {
# openingBalance = localCopy.CreditAmount ;
# }
# else
# {
# creditBalance = ((localCopy.CreditAmount <= 0 || (localCopy.CreditAmount > 0 && localCopy.Correct)) ? localCopy.CreditAmount : 0.00);
# debitBalance = ((localCopy.CreditAmount > 0 && !localCopy.Correct) ? localCopy.CreditAmount : 0.00);
# }
# }
# }
# // for the last record
# this.insertCustVendBalanceTmp_CN(
# curMainAccountNum,
# mainAccountName,
# curVendAccountNum,
# vendAccountName,
# openingBalance,
# debitBalance,
# creditBalance,
# periodCode);
#} //End for process report
ENDSOURCE
ENDMETHODS
ENDCLASS
***Element: CLS
; Microsoft Dynamics AX Class: EBCVendAgingPaymDP unloaded
; --------------------------------------------------------------------------------
CLSVERSION 1
CLASS #EBCVendAgingPaymDP
PROPERTIES
Name #EBCVendAgingPaymDP
Extends #SRSReportDataProviderBase
RunOn #Server
Origin #{CA5C2AA5-BFCF-48F2-A815-DEA63AADC456}
ENDPROPERTIES
METHODS
SOURCE #classDeclaration
#/// <summary>
#/// The <c>VendBalanceDP_CN</c> is the
#/// data provider class for <c>VendBalance_CN</c> report.
#/// </summary>
#/// <remarks>
#/// The <c>CustBalanceDP_CN</c> and <c>VendBalanceDP_CN</c> use
#/// similar logic, so any change in one class requires the other class to be changed.
#/// </remarks>
#[
# SRSReportQueryAttribute(queryStr(EBCVendAgingPaym)),
# SRSReportParameterAttribute(classStr(EBCVendAgingPaymContract))
#]
#public class EBCVendAgingPaymDP extends SRSReportDataProviderBase
#{
# EBCVendAgingPaymTmp vendAgingPaymTmp;
#}
ENDSOURCE
SOURCE #getVendAgingPaymTmp
#/// <summary>
#/// Retrieves the data used by <c>VendBalance_CN</c> report.
#/// </summary>
#/// <returns>
#/// Temporary table <c>CustVendBalanceTmp_CN</c>.
#/// </returns>
#[ SRSReportDataSetAttribute(tableStr(EBCVendAgingPaymTmp)) ]
#public EBCVendAgingPaymTmp getVendAgingPaymTmp()
#{
# return vendAgingPaymTmp;
#}
ENDSOURCE
SOURCE #insertCustVendBalanceTmp_CN
#/// <summary>
#/// Inserts records into <c>CustVendBalanceTmp_CN</c> table.
#/// </summary>
#/// <param name="_mainAccount">
#/// Assigns a value to MainAccountNum field of above mentioned table.
#/// </param>
#/// <param name="_mainAccountName">
#/// Assigns a value to MainAccountName field of above mentioned table.
#/// </param>
#/// <param name="_vendAccountNum">
#/// Assigns a value to AccountNum field of above mentioned table.
#/// </param>
#/// <param name="_dirPartyName">
#/// Assigns a value to PartyAccountName field of above mentioned table.
#/// </param>
#/// <param name="_openingBalance">
#/// Assigns a value to OpeningBalance field of above mentioned table.
#/// </param>
#/// <param name="_debitBalance">
#/// Assigns a value to DebitAmount field of above mentioned table.
#/// </param>
#/// <param name="_creditBalance">
#/// Assigns a value to CreditAmount field of above mentioned table.
#/// </param>
#/// <param name="_periodCode">
#/// Sends period code of the ledger period selected.
#/// </param>
#private void insertCustVendBalanceTmp_CN(
# MainAccountNum _mainAccount,
# AccountName _mainAccountName,
# AccountNum _vendAccountNum,
# DirPartyName _dirPartyName,
# AmountMST _openingBalance,
# AmountMST _debitBalance,
# AmountMST _creditBalance,
# String255 _periodCode)
#{
# vendAgingPaymTmp.AccountNum = _vendAccountNum;
# vendAgingPaymTmp.PartyAccountName = _dirPartyName;
# vendAgingPaymTmp.MainAccountNum = _mainAccount;
# vendAgingPaymTmp.MainAccountName = _mainAccountName;
# vendAgingPaymTmp.OpeningBalance = _openingBalance;
# vendAgingPaymTmp.DebitAmount = _debitBalance;
# vendAgingPaymTmp.CreditAmount = -_creditBalance;
# vendAgingPaymTmp.PeriodCode = _periodCode;
# vendAgingPaymTmp.ClosingBalance = _openingBalance + _debitBalance + _creditBalance;
# vendAgingPaymTmp.insert();
#}
ENDSOURCE
SOURCE #processReport
#[SysEntryPointAttribute]
#public void processReport()
#{
# VendTable vendTable;
# VendTrans vendTrans;
# MainAccount mainAccount;
# TransDate currentTransDate, fromdate, todate;
# AccountNum curVendAccountNum;
# MainAccountNum curMainAccountNum;
# Name mainAccountName;
# DirPartyName vendAccountName;
# Query query;
# QueryRun queryRun;
# AmountMST openingBalance, creditBalance, debitBalance;
# LedgerFiscalPeriodNameContract_CN contract;
# CustVendBalanceTmp_CN localCopy;
# LedgerDimensionDefaultAccount defaultAccount;
# DimensionAttributeValueCombination dimensionAttribute;
# String255 periodCode, fromPeriodName, toPeriodName;
# FiscalCalendarPeriod currFiscalPeriod;
#
# query = this.parmQuery();
# contract = this.parmDataContract() as LedgerFiscalPeriodNameContract_CN;
#
# if ( !contract.parmFromDate() || !contract.parmToDate())
# {
# currFiscalPeriod = FiscalCalendarPeriod::currentLedgePeriod_CN();
# }
#
# fromdate = (contract.parmFromDate()) ? contract.parmFromDate() : currFiscalPeriod.StartDate;
# todate = (contract.parmToDate()) ? contract.parmToDate() : currFiscalPeriod.EndDate;
# fromPeriodName = (contract.parmFromPeriod()) ? contract.parmFromPeriod() : currFiscalPeriod.Name;
# toPeriodName = (contract.parmToPeriod()) ? contract.parmToPeriod() : currFiscalPeriod.Name;
# periodCode = fromPeriodName + '-' + toPeriodName;
#
# query.dataSourceTable(tableNum(VendTrans)).addRange(fieldNum(VendTrans, TransDate)).value(
# SysQuery::range(dateNull(), todate));
# queryRun = new queryRun(query);
# while (queryRun.next())
# {
# vendTable = queryRun.get(tableNum(VendTable));
# vendTrans = queryRun.get(tableNum(VendTrans));
#
# localCopy.AccountNum = vendTable.AccountNum;
# localCopy.PartyAccountName = DirPartyTable::getName(vendTable.Party);
# localCopy.TransDate = vendTrans.TransDate;
# localCopy.CreditAmount = vendTrans.AmountMST;
# localCopy.Correct = vendTrans.Correct;
# defaultAccount = VendLedgerAccounts::summaryLedgerDimension(
# vendTable.AccountNum,
# vendTrans.PostingProfile);
#
# dimensionAttribute = DimensionAttributeValueCombination::find(defaultAccount);
# mainAccount = mainAccount::find(dimensionAttribute.MainAccount);
# localCopy.MainAccountName = mainAccount.localizedName();
# localCopy.MainAccountNum = mainAccount.MainAccountId;
# localCopy.insert();
# }
#
# while select * from localCopy
# order by localCopy.AccountNum, localCopy.MainAccountName, localCopy.TransDate asc
# {
#
# currentTransDate = localCopy.TransDate;
#
# if (!curVendAccountNum && !curMainAccountNum)
# {
# curMainAccountNum = localCopy.MainAccountNum;
# curVendAccountNum = localCopy.AccountNum;
# mainAccountName = localCopy.MainAccountName;
# vendAccountName = localCopy.PartyAccountName;
# }
#
# if (curVendAccountNum == localCopy.AccountNum
# && curMainAccountNum == localCopy.MainAccountNum )
# {
# if (currentTransDate < fromdate)
# {
# openingBalance += localCopy.CreditAmount ;
# }
# else
# {
# creditBalance += ((localCopy.CreditAmount <= 0 || (localCopy.CreditAmount > 0 && localCopy.Correct)) ? localCopy.CreditAmount : 0.00);
# debitBalance += ((localCopy.CreditAmount > 0 && !localCopy.Correct) ? localCopy.CreditAmount : 0.00);
# }
# }
# else
# {
# this.insertCustVendBalanceTmp_CN(
# curMainAccountNum,
# mainAccountName,
# curVendAccountNum,
# vendAccountName,
# openingBalance,
# debitBalance,
# creditBalance,
# periodCode);
#
# curMainAccountNum = localCopy.MainAccountNum;
# curVendAccountNum = localCopy.AccountNum;
# mainAccountName = localCopy.MainAccountName;
# vendAccountName = localCopy.PartyAccountName;
# creditBalance = 0.00;
# debitBalance = 0.00;
# openingBalance = 0.00;
# if (currentTransDate < fromdate)
# {
# openingBalance = localCopy.CreditAmount ;
# }
# else
# {
# creditBalance = ((localCopy.CreditAmount <= 0 || (localCopy.CreditAmount > 0 && localCopy.Correct)) ? localCopy.CreditAmount : 0.00);
# debitBalance = ((localCopy.CreditAmount > 0 && !localCopy.Correct) ? localCopy.CreditAmount : 0.00);
# }
# }
# }
# // for the last record
# this.insertCustVendBalanceTmp_CN(
# curMainAccountNum,
# mainAccountName,
# curVendAccountNum,
# vendAccountName,
# openingBalance,
# debitBalance,
# creditBalance,
# periodCode);
#} //End for process report
ENDSOURCE
ENDMETHODS
ENDCLASS
***Element: CLS
; Microsoft Dynamics AX Class: EBCVendAgingPaymContract unloaded
; --------------------------------------------------------------------------------
CLSVERSION 1
CLASS #EBCVendAgingPaymContract
PROPERTIES
Name #EBCVendAgingPaymContract
Origin #{7CB83768-46A4-4262-A748-819C18FAD444}
ENDPROPERTIES
METHODS
SOURCE #classDeclaration
#/// <summary>
#/// Contains the from period, to period, from date and to date data contract for SSRS report.
#/// General data contract for from and to fiscal period name.
#/// This contract is used for selecting from and to fiscal period name.
#/// </summary>
#[DataContractAttribute]
#public class EBCVendAgingPaymContract implements SysOperationValidatable
#{
# PeriodName fromPeriod;
# PeriodName toPeriod;
# FromDate fromDate;
# ToDate toDate;
# boolean validateDates;
# TransDate asOn;
#}
ENDSOURCE
SOURCE #new
#public void new()
#{
# validateDates = true;
#}
ENDSOURCE
SOURCE #parmAsOn
#/// <summary>
#/// Gets or sets the value of the datacontract parameter asOn.
#/// </summary>
#/// <param name="_asOn">
#/// The new value of the datacontract parameter asOn.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter asOn.
#/// </returns>
#[
# DataMemberAttribute('AsOn'),
# SysOperationLabelAttribute(literalstr("@SYS7902")),
# SysOperationHelpTextAttribute(literalstr("@SYS7902"))
#]
#public TransDate parmAsOn(TransDate _asOn = asOn)
#{
# asOn = _asOn;
# return asOn;
#}
ENDSOURCE
SOURCE #validate
#/// <summary>
#/// Determines whether the parameters are valid.
#/// </summary>
#/// <returns>
#/// true when the parameters are valid; otherwise, false.
#/// </returns>
#public boolean validate()
#{
# boolean isValid = true;
#
# if (validateDates && fromDate && toDate)
# {
# if (fromDate > toDate)
# {
# //From date cannot be greater than To date.
# isValid = checkFailed("@SYS120590");
# }
# }
#
# return isValid;
#}
ENDSOURCE
ENDMETHODS
ENDCLASS
***Element: QUE
; Microsoft Dynamics AX Query: EBCVendAgingPaym unloaded
; --------------------------------------------------------------------------------
VERSION 31
QUERY #EBCVendAgingPaym
PROPERTIES
Name #EBCVendAgingPaym
Title #@GLS100078
Version #630
NextUniqueId #1020
Origin #{3DE264D8-7CDA-4D4F-A3D7-E66E960D7057}
ENDPROPERTIES
METHODS
SOURCE #classDeclaration
#public class QueryRun extends ObjectRun
#{
#}
ENDSOURCE
ENDMETHODS
BLOCKS
BLOCK #VendTable
PROPERTIES
Name #Vend
Table #VendTable
UniqueId #1009
FetchMode #1:1
ENDPROPERTIES
FIELDLIST
PROPERTIES
Dynamic #No
ENDPROPERTIES
FIELD #AccountNum
FIELD #Party
ENDFIELDLIST
SORTING
ENDSORTING
LINES
LINE #AccountNum
PROPERTIES
Name #AccountNum
Table #VendTable
Field #AccountNum
ENDPROPERTIES
ENDLINES
BLOCKS
BLOCK #VendTrans
PROPERTIES
Name #VTrans
Table #VendTrans
UniqueId #1010
FetchMode #1:1
ENDPROPERTIES
FIELDLIST
PROPERTIES
Dynamic #No
ENDPROPERTIES
FIELD #AmountMST
FIELD #Voucher
FIELD #TransDate
FIELD #AccountNum
FIELD #PostingProfile
FIELD #Correct
ENDFIELDLIST
SORTING
ENDSORTING
LINES
ENDLINES
BLOCKS
ENDBLOCKS
ASSOCIATIONS
ASSOCIATION
JOINDATASOURCE #Vend
MASTERFIELD #AccountNum
DETAILSFIELD #AccountNum
ENDASSOCIATIONS
ENDBLOCK
ENDBLOCKS
GROUPBY
ENDGROUPBY
HAVING
ENDHAVING
ORDERBY
ENDORDERBY
ENDBLOCK
ENDBLOCKS
DEPENDENTS
ENDDEPENDENTS
COMPOSITEQUERIES
ENDCOMPOSITEQUERIES
ENDQUERY
***Element: DBT
; Microsoft Dynamics AX Table : VendAgingReportTmp unloaded
; --------------------------------------------------------------------------------
TABLEVERSION 1
TABLE #VendAgingReportTmp
EnforceFKRelation 1
PROPERTIES
Name #VendAgingReportTmp
Label #@SYS3739
TitleField1 #TransDate
TitleField2 #AccountNum
TableType #TempDB
CreateRecIdIndex #Yes
SaveDataPerCompany #No
PrimaryIndex #SurrogateKey
ClusterIndex #SurrogateKey
DeveloperDocumentation #@SYS323396
Origin #{A4C2259D-0798-42F7-AE30-55D547B60357}
LegacyId #10602
ENDPROPERTIES
FIELDS
FIELD #AccountNum
STRING
PROPERTIES
Name #AccountNum
Table #VendAgingReportTmp
Origin #{1A12325F-DF0B-49FF-983C-54837DEB3F4E}
LegacyId #37
ExtendedDataType #AccountNum
StringSize #20
ENDPROPERTIES
FIELD #AsOfDate
STRING
PROPERTIES
Name #AsOfDate
Table #VendAgingReportTmp
Origin #{F8EE99F4-896F-4BD8-AF0D-D2521D929F64}
LegacyId #11
ExtendedDataType #Str1260
StringSize #1260
ENDPROPERTIES
FIELD #Balance
REAL
PROPERTIES
Name #Balance
Label #@SYS76227
Table #VendAgingReportTmp
Origin #{2A933EBC-42F7-45DB-832B-D48CEA03A773}
LegacyId #39
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance01
REAL
PROPERTIES
Name #Balance01
Label #@SYS76227
Table #VendAgingReportTmp
Origin #{25880EE5-ECB9-4AFA-ADAE-EA325CAEB007}
LegacyId #1
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance01Cur
REAL
PROPERTIES
Name #Balance01Cur
Table #VendAgingReportTmp
Origin #{F99E13F8-E292-4A9C-B719-0CBDB9445B36}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance02
REAL
PROPERTIES
Name #Balance02
Label #@SYS76228
Table #VendAgingReportTmp
Origin #{1AF39A79-07DA-42D1-A3FC-3DA256E4C824}
LegacyId #2
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance02Cur
REAL
PROPERTIES
Name #Balance02Cur
Table #VendAgingReportTmp
Origin #{6073498A-3507-484F-8EF5-FFEAE686E835}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance03
REAL
PROPERTIES
Name #Balance03
Label #@SYS76229
Table #VendAgingReportTmp
Origin #{486E2DF3-C358-40ED-8C6D-C8654BBA4AD5}
LegacyId #3
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance03Cur
REAL
PROPERTIES
Name #Balance03Cur
Table #VendAgingReportTmp
Origin #{B09B25D5-EE61-4EBC-B61E-BCA290D1D923}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance04
REAL
PROPERTIES
Name #Balance04
Label #@SYS76230
Table #VendAgingReportTmp
Origin #{4C1C8C15-F75E-43C2-A62B-A42599307A90}
LegacyId #4
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance04Cur
REAL
PROPERTIES
Name #Balance04Cur
Table #VendAgingReportTmp
Origin #{B418095E-8D48-4600-8D12-2ADD8A8B8DF3}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance05
REAL
PROPERTIES
Name #Balance05
Label #@SYS76231
Table #VendAgingReportTmp
Origin #{1476EF03-E10C-4BE6-8014-649E025CC920}
LegacyId #5
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance05Cur
REAL
PROPERTIES
Name #Balance05Cur
Table #VendAgingReportTmp
Origin #{6C7EE7B2-E55C-4FB3-947A-F94694BFA813}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance06
REAL
PROPERTIES
Name #Balance06
Label #@SYS76232
Table #VendAgingReportTmp
Origin #{77243993-5E73-4D0E-A41E-FBDB2762F824}
LegacyId #6
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance06Cur
REAL
PROPERTIES
Name #Balance06Cur
Table #VendAgingReportTmp
Origin #{06C71A67-05B7-4C44-9611-7DEF91F4DB46}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance07
REAL
PROPERTIES
Name #Balance07
Label #@SYS76233
Table #VendAgingReportTmp
Origin #{2FA3878D-8045-4822-8B68-D8D1DC5EE2CA}
LegacyId #7
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance07Cur
REAL
PROPERTIES
Name #Balance07Cur
Table #VendAgingReportTmp
Origin #{52469837-E830-47A4-B674-5770C9924468}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Blocked
ENUM
PROPERTIES
Name #Blocked
Table #VendAgingReportTmp
Origin #{D948B4B7-638B-4754-A50D-FAB0F10A548B}
ExtendedDataType #VendBlocked
EnumType #CustVendorBlocked
ENDPROPERTIES
FIELD #CurrencyCode
STRING
PROPERTIES
Name #CurrencyCode
Table #VendAgingReportTmp
Origin #{0B21779B-869B-4646-95FF-1EAFD6B6D0E6}
ExtendedDataType #CurrencyCode
StringSize #3
ENDPROPERTIES
FIELD #DirPartyTable
INT64
PROPERTIES
Name #DirPartyTable
Table #VendAgingReportTmp
Origin #{BAD2E1D0-C7FC-4645-9DB8-4F79737190B2}
ExtendedDataType #RefRecId
ENDPROPERTIES
FIELD #EBCNameAlias
STRING
PROPERTIES
Name #EBCNameAlias
Table #VendAgingReportTmp
Origin #{7F87F399-AA48-44BF-B513-F1064133BCD1}
ExtendedDataType #NameAlias
StringSize #20
ENDPROPERTIES
FIELD #Heading1
STRING
PROPERTIES
Name #Heading1
Table #VendAgingReportTmp
Origin #{3638DDCC-6BAB-4E58-9F3B-A8C77DA5348F}
LegacyId #14
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #Heading10
DATE
PROPERTIES
Name #Heading10
Table #VendAgingReportTmp
Origin #{BDCF7B9B-BC3F-406A-B0D3-9A1CB76970C8}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading11
DATE
PROPERTIES
Name #Heading11
Table #VendAgingReportTmp
Origin #{C709AA9E-D274-434D-8B4A-DCDBDFCE7C2B}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading12
DATE
PROPERTIES
Name #Heading12
Table #VendAgingReportTmp
Origin #{7D3552A9-6341-41AC-B538-1031993612CE}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading13
DATE
PROPERTIES
Name #Heading13
Table #VendAgingReportTmp
Origin #{19ACC1F5-3E71-4049-B833-C5456A26983E}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading14
DATE
PROPERTIES
Name #Heading14
Table #VendAgingReportTmp
Origin #{5C7098E9-2557-481E-9F79-4AB53D2E0F3A}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading15
STRING
PROPERTIES
Name #Heading15
Table #VendAgingReportTmp
Origin #{2C53B1F5-489E-4A5B-BBC4-72D80B0CF626}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #Heading2
STRING
PROPERTIES
Name #Heading2
Table #VendAgingReportTmp
Origin #{CF30311B-9C53-40B0-A295-94CB3077B0B0}
LegacyId #16
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #Heading2DateValue
DATE
PROPERTIES
Name #Heading2DateValue
Table #VendAgingReportTmp
Origin #{656B0DD1-9533-40D3-B072-7CA24ED77804}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading3
DATE
PROPERTIES
Name #Heading3
Table #VendAgingReportTmp
Origin #{99694BCC-19B3-4963-813C-DC64628DB9AA}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading4
DATE
PROPERTIES
Name #Heading4
Table #VendAgingReportTmp
Origin #{A5A79EBE-A061-44D5-819E-A3D8EEA9B00C}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading5
DATE
PROPERTIES
Name #Heading5
Table #VendAgingReportTmp
Origin #{58C67506-BFE6-4F49-ACF3-9D70DCB2B242}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading6
DATE
PROPERTIES
Name #Heading6
Table #VendAgingReportTmp
Origin #{E80142E5-D125-437B-BB67-C80C3C045874}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading7
STRING
PROPERTIES
Name #Heading7
Table #VendAgingReportTmp
Origin #{198E9D17-726B-458F-A296-39F808BF6C84}
LegacyId #21
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #Heading7DateValue
DATE
PROPERTIES
Name #Heading7DateValue
Table #VendAgingReportTmp
Origin #{E0443E78-6451-4F1E-991D-BCD37206A1F5}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading8
DATE
PROPERTIES
Name #Heading8
Table #VendAgingReportTmp
Origin #{1137266E-D0E2-4F95-AA6A-5601BEDEFC3D}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading9
DATE
PROPERTIES
Name #Heading9
Table #VendAgingReportTmp
Origin #{4920ECCF-1503-41BD-9340-045919B95F79}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #HeadingAccount
STRING
PROPERTIES
Name #HeadingAccount
Table #VendAgingReportTmp
Origin #{FA9F2699-8531-43BC-9B06-41FFFFD5582C}
LegacyId #12
ExtendedDataType #Addressing
StringSize #250
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription02
STRING
PROPERTIES
Name #HeadingAgingBucketDescription02
Table #VendAgingReportTmp
Origin #{04FBC5E1-FBCD-46F5-9990-409001C4FED0}
LegacyId #28
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription03
STRING
PROPERTIES
Name #HeadingAgingBucketDescription03
Table #VendAgingReportTmp
Origin #{86230A1B-D4A3-45DC-99BC-2A172AA0F6E3}
LegacyId #29
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription04
STRING
PROPERTIES
Name #HeadingAgingBucketDescription04
Table #VendAgingReportTmp
Origin #{D93EEDD7-8E6D-416C-977B-DDD5ECEDAA81}
LegacyId #30
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription05
STRING
PROPERTIES
Name #HeadingAgingBucketDescription05
Table #VendAgingReportTmp
Origin #{8CC93042-8CCA-4782-8E69-2A50694DABB8}
LegacyId #31
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription06
STRING
PROPERTIES
Name #HeadingAgingBucketDescription06
Table #VendAgingReportTmp
Origin #{B7DD90A3-65B2-4900-8C82-925FE222F847}
LegacyId #32
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription07
STRING
PROPERTIES
Name #HeadingAgingBucketDescription07
Table #VendAgingReportTmp
Origin #{7CC28B77-1C61-4F24-8A09-7CAFA04E0C12}
LegacyId #36
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingDate
STRING
PROPERTIES
Name #HeadingDate
Table #VendAgingReportTmp
Origin #{A51A8D11-4A76-4EA8-804F-AEA32A8C4CC5}
LegacyId #9
ExtendedDataType #ColumnTxt
StringSize #40
ENDPROPERTIES
FIELD #HeadingName
STRING
PROPERTIES
Name #HeadingName
Table #VendAgingReportTmp
Origin #{C7E06965-993D-4308-8B86-589EF4BF3F8D}
LegacyId #13
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingVoucher
STRING
PROPERTIES
Name #HeadingVoucher
Table #VendAgingReportTmp
Origin #{58330692-400F-41F2-A033-9B50904D61C9}
LegacyId #10
ExtendedDataType #ColumnTxt
StringSize #40
ENDPROPERTIES
FIELD #InvoiceId
STRING
PROPERTIES
Name #InvoiceId
Table #VendAgingReportTmp
Origin #{B0EA849B-6997-43DC-BAE8-A2F43796A58F}
ExtendedDataType #InvoiceId
StringSize #20
ENDPROPERTIES
FIELD #Name
STRING
PROPERTIES
Name #Name
Table #VendAgingReportTmp
Origin #{6CEB8714-FDFE-4C78-9AE5-F48D5980EB8A}
LegacyId #8
ExtendedDataType #VendName
StringSize #100
ENDPROPERTIES
FIELD #SortOrder
INT
PROPERTIES
Name #SortOrder
Table #VendAgingReportTmp
Origin #{DBBD6447-4E25-416B-9371-F0E9DC9CA406}
ExtendedDataType #Counter
ENDPROPERTIES
FIELD #TransDate
DATE
PROPERTIES
Name #TransDate
Table #VendAgingReportTmp
Origin #{E9D68AC7-E3A1-45FA-9F05-75F38551888D}
LegacyId #33
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Txt
STRING
PROPERTIES
Name #Txt
Table #VendAgingReportTmp
Origin #{AEF785AC-C036-473A-BF57-6EF369100EB4}
LegacyId #35
ExtendedDataType #CustVendAgingTransTxt
StringSize #100
ENDPROPERTIES
FIELD #VendAccount
STRING
PROPERTIES
Name #VendAccount
Table #VendAgingReportTmp
Origin #{73606D15-1FFE-4896-A6F6-1E719F10F901}
LegacyId #38
ExtendedDataType #VendAccount
StringSize #20
ENDPROPERTIES
FIELD #VendGroup
STRING
PROPERTIES
Name #VendGroup
Table #VendAgingReportTmp
Origin #{2CDA7912-2DA9-4A20-8F7D-6D1D5D010B3C}
LegacyId #41
ExtendedDataType #VendGroupId
ENDPROPERTIES
FIELD #Voucher
STRING
PROPERTIES
Name #Voucher
Table #VendAgingReportTmp
Origin #{7B839532-7CCB-4B68-B2B1-66B35E7E850A}
LegacyId #34
ExtendedDataType #Voucher
StringSize #20
ENDPROPERTIES
ENDFIELDS
GROUPS
GROUP #AutoReport
PROPERTIES
Name #AutoReport
ENDPROPERTIES
GROUPFIELDS
#AccountNum
#AsOfDate
#Balance
#Balance01
#Balance01Cur
#Balance02
#Balance02Cur
#Balance03
#Balance03Cur
#Balance04
#Balance04Cur
#Balance05
#Balance05Cur
#Balance06
#Balance06Cur
#Balance07
#Balance07Cur
#CurrencyCode
#Heading1
#Heading10
#Heading11
#Heading12
#Heading13
#Heading14
#Heading15
#Heading2
#Heading2DateValue
#Heading3
#Heading4
#Heading5
#Heading6
#Heading7
#Heading7DateValue
#Heading8
#Heading9
#HeadingAccount
#HeadingAgingBucketDescription02
#HeadingAgingBucketDescription03
#HeadingAgingBucketDescription04
#HeadingAgingBucketDescription05
#HeadingAgingBucketDescription06
#HeadingAgingBucketDescription07
#HeadingDate
#HeadingName
#HeadingVoucher
#InvoiceId
#Name
#TransDate
#Txt
#VendAccount
#VendGroup
#Voucher
ENDGROUPFIELDS
ENDGROUP
GROUP #General
PROPERTIES
Name #General
Label #@SYS19924
ENDPROPERTIES
GROUPFIELDS
#AccountNum
#AsOfDate
#Balance
#Balance01
#Balance01Cur
#Balance02
#Balance02Cur
#Balance03
#Balance03Cur
#Balance04
#Balance04Cur
#Balance05
#Balance05Cur
#Balance06
#Balance06Cur
#Balance07
#Balance07Cur
#CurrencyCode
#Heading1
#Heading10
#Heading11
#Heading12
#Heading13
#Heading14
#Heading15
#Heading2
#Heading2DateValue
#Heading3
#Heading4
#Heading5
#Heading6
#Heading7
#Heading7DateValue
#Heading8
#Heading9
#HeadingAccount
#HeadingAgingBucketDescription02
#HeadingAgingBucketDescription03
#HeadingAgingBucketDescription04
#HeadingAgingBucketDescription05
#HeadingAgingBucketDescription06
#HeadingAgingBucketDescription07
#HeadingDate
#HeadingName
#HeadingVoucher
#InvoiceId
#Name
#TransDate
#Txt
#VendAccount
#VendGroup
#Voucher
ENDGROUPFIELDS
ENDGROUP
ENDGROUPS
INDICES
#CurrencyIdx
PROPERTIES
Name #CurrencyIdx
Origin #{32EEE61A-A88E-4CCC-AABD-20FAE19243FB}
ENDPROPERTIES
INDEXFIELDS
#CurrencyCode
ENDINDEXFIELDS
ENDINDICES
FULLTEXTINDICES
ENDFULLTEXTINDICES
REFERENCES
REFERENCE #Currency
PROPERTIES
Name #Currency
Table #Currency
RelatedTableCardinality #ZeroOne
Cardinality #ZeroMore
RelationshipType #Association
UseDefaultRoleNames #Yes
EDTRelation #Yes
ENDPROPERTIES
FIELDREFERENCES
REFERENCETYPE PKFK
PROPERTIES
Field #CurrencyCode
RelatedField #CurrencyCode
SourceEDT #CurrencyCode
ENDPROPERTIES
ENDFIELDREFERENCES
ENDREFERENCE
REFERENCE #VendGroup
PROPERTIES
Name #VendGroup
Table #VendGroup
RelatedTableCardinality #ZeroOne
Cardinality #ZeroMore
RelationshipType #Association
UseDefaultRoleNames #Yes
RelatedTableRole #VendGroup
Role #VendAgingReportTmp
EDTRelation #Yes
ENDPROPERTIES
FIELDREFERENCES
REFERENCETYPE PKFK
PROPERTIES
Field #VendGroup
RelatedField #VendGroup
SourceEDT #VendGroupId
ENDPROPERTIES
ENDFIELDREFERENCES
ENDREFERENCE
REFERENCE #VendTable
PROPERTIES
Name #VendTable
Table #VendTable
RelatedTableCardinality #ZeroOne
Cardinality #ZeroMore
RelationshipType #Association
UseDefaultRoleNames #Yes
EDTRelation #Yes
ENDPROPERTIES
FIELDREFERENCES
REFERENCETYPE PKFK
PROPERTIES
Field #VendAccount
RelatedField #AccountNum
SourceEDT #VendAccount
ENDPROPERTIES
ENDFIELDREFERENCES
ENDREFERENCE
ENDREFERENCES
DELETEACTIONS
ENDDELETEACTIONS
METHODS
ENDMETHODS
ENDTABLE
***Element: DBT
; Microsoft Dynamics AX Table : EBCVendAgingPaymProposalTmp unloaded
; --------------------------------------------------------------------------------
TABLEVERSION 1
TABLE #EBCVendAgingPaymProposalTmp
EnforceFKRelation 1
PROPERTIES
Name #EBCVendAgingPaymProposalTmp
Label #@SYS3739
TitleField1 #TransDate
TitleField2 #AccountNum
CreateRecIdIndex #Yes
SaveDataPerCompany #No
PrimaryIndex #SurrogateKey
ClusterIndex #SurrogateKey
DeveloperDocumentation #@SYS323396
Origin #{4AB555FB-48DC-4B5E-B7E9-15C768DFBB95}
ENDPROPERTIES
FIELDS
FIELD #AccountNum
STRING
PROPERTIES
Name #AccountNum
Table #EBCVendAgingPaymProposalTmp
Origin #{C1047957-C7D5-4BBF-BEDE-ADA3FEC9E2FF}
ExtendedDataType #AccountNum
StringSize #20
ENDPROPERTIES
FIELD #AsOfDate
STRING
PROPERTIES
Name #AsOfDate
Table #EBCVendAgingPaymProposalTmp
Origin #{1CB85B92-23AC-43BE-A09B-312F3D4CA147}
ExtendedDataType #Str1260
StringSize #1260
ENDPROPERTIES
FIELD #Balance
REAL
PROPERTIES
Name #Balance
Label #@SYS76227
Table #EBCVendAgingPaymProposalTmp
Origin #{5FA57B37-8FD9-4BC3-9535-15CC913F5910}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance01
REAL
PROPERTIES
Name #Balance01
Label #@SYS76227
Table #EBCVendAgingPaymProposalTmp
Origin #{E21A7D5F-D9C5-40E5-A971-C18C5368DEF1}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance01Cur
REAL
PROPERTIES
Name #Balance01Cur
Table #EBCVendAgingPaymProposalTmp
Origin #{22F3BC5F-67ED-4EFE-AA2D-29C90CA0AA41}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance02
REAL
PROPERTIES
Name #Balance02
Label #@SYS76228
Table #EBCVendAgingPaymProposalTmp
Origin #{65DDCEBA-A591-419F-92A4-8F523956F125}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance02Cur
REAL
PROPERTIES
Name #Balance02Cur
Table #EBCVendAgingPaymProposalTmp
Origin #{337FF8A3-5717-448D-ADD0-100E7D2EB180}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance03
REAL
PROPERTIES
Name #Balance03
Label #@SYS76229
Table #EBCVendAgingPaymProposalTmp
Origin #{C7398BDD-8878-47B0-82E7-80D108BAA9B4}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance03Cur
REAL
PROPERTIES
Name #Balance03Cur
Table #EBCVendAgingPaymProposalTmp
Origin #{F8D4770B-3ABD-4DF3-A421-3B4EB4CB7A44}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance04
REAL
PROPERTIES
Name #Balance04
Label #@SYS76230
Table #EBCVendAgingPaymProposalTmp
Origin #{405C0191-2F0F-451E-BA99-8A627DA78329}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance04Cur
REAL
PROPERTIES
Name #Balance04Cur
Table #EBCVendAgingPaymProposalTmp
Origin #{F44098E2-A7BB-4669-A1E2-09089AE294FD}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance05
REAL
PROPERTIES
Name #Balance05
Label #@SYS76231
Table #EBCVendAgingPaymProposalTmp
Origin #{47FE182C-55BA-4498-B410-C8AC76AA2911}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance05Cur
REAL
PROPERTIES
Name #Balance05Cur
Table #EBCVendAgingPaymProposalTmp
Origin #{B07DFCBA-4A02-4348-B9B1-06FC16335E86}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance06
REAL
PROPERTIES
Name #Balance06
Label #@SYS76232
Table #EBCVendAgingPaymProposalTmp
Origin #{65AE387E-179C-4280-A86B-AA0C75B4967B}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance06Cur
REAL
PROPERTIES
Name #Balance06Cur
Table #EBCVendAgingPaymProposalTmp
Origin #{E8FDA53F-E432-41AD-B89A-B1BCA9F4E679}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Balance07
REAL
PROPERTIES
Name #Balance07
Label #@SYS76233
Table #EBCVendAgingPaymProposalTmp
Origin #{09BB6509-0342-4E28-8B4E-8CDD80F0D903}
ExtendedDataType #AmountMST
ENDPROPERTIES
FIELD #Balance07Cur
REAL
PROPERTIES
Name #Balance07Cur
Table #EBCVendAgingPaymProposalTmp
Origin #{63CC3D8C-58EE-4854-862B-336F8D072E80}
ExtendedDataType #AmountCur
ENDPROPERTIES
FIELD #Blocked
ENUM
PROPERTIES
Name #Blocked
Table #EBCVendAgingPaymProposalTmp
Origin #{80ED6E11-23D9-4D1B-BADA-E6E909D0F010}
ExtendedDataType #VendBlocked
EnumType #CustVendorBlocked
ENDPROPERTIES
FIELD #CurrencyCode
STRING
PROPERTIES
Name #CurrencyCode
Table #EBCVendAgingPaymProposalTmp
Origin #{F0A28C0B-FE05-4678-93F1-DEAE2B1CE46A}
ExtendedDataType #CurrencyCode
StringSize #3
ENDPROPERTIES
FIELD #DirPartyTable
INT64
PROPERTIES
Name #DirPartyTable
Table #EBCVendAgingPaymProposalTmp
Origin #{4D3CA762-889E-4B54-840A-A9DEEE2A84BF}
ExtendedDataType #RefRecId
ENDPROPERTIES
FIELD #EBCNameAlias
STRING
PROPERTIES
Name #EBCNameAlias
Table #EBCVendAgingPaymProposalTmp
Origin #{A4E9A435-50E5-432D-9107-C2367DF06FAA}
ExtendedDataType #NameAlias
StringSize #20
ENDPROPERTIES
FIELD #Heading1
STRING
PROPERTIES
Name #Heading1
Table #EBCVendAgingPaymProposalTmp
Origin #{506D0288-B057-4BAE-B288-6D2DCC7ED296}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #Heading10
DATE
PROPERTIES
Name #Heading10
Table #EBCVendAgingPaymProposalTmp
Origin #{FB5AC00E-7C85-4381-BB71-85E1B8F5E2C2}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading11
DATE
PROPERTIES
Name #Heading11
Table #EBCVendAgingPaymProposalTmp
Origin #{7E7B3288-32C8-4A5F-8E40-073A32659A3A}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading12
DATE
PROPERTIES
Name #Heading12
Table #EBCVendAgingPaymProposalTmp
Origin #{95939C93-71B6-4C5E-8C66-18AA35646882}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading13
DATE
PROPERTIES
Name #Heading13
Table #EBCVendAgingPaymProposalTmp
Origin #{71413B50-7281-47FD-BAB6-2F0572E8508A}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading14
DATE
PROPERTIES
Name #Heading14
Table #EBCVendAgingPaymProposalTmp
Origin #{B3B0018E-D127-4D95-AE33-57945A58DB51}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading15
STRING
PROPERTIES
Name #Heading15
Table #EBCVendAgingPaymProposalTmp
Origin #{15D36611-0427-47EA-9716-7A264B89F4EB}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #Heading2
STRING
PROPERTIES
Name #Heading2
Table #EBCVendAgingPaymProposalTmp
Origin #{211945C0-0D64-4D0E-BF98-62D45E5001DA}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #Heading2DateValue
DATE
PROPERTIES
Name #Heading2DateValue
Table #EBCVendAgingPaymProposalTmp
Origin #{FE3415D1-34B7-4F68-8F3D-C34CEDD0CA56}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading3
DATE
PROPERTIES
Name #Heading3
Table #EBCVendAgingPaymProposalTmp
Origin #{96E59BE2-7B11-4AF5-9218-A91BB8F5268F}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading4
DATE
PROPERTIES
Name #Heading4
Table #EBCVendAgingPaymProposalTmp
Origin #{C0CA78D7-F196-4A83-A181-FB5383746A85}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading5
DATE
PROPERTIES
Name #Heading5
Table #EBCVendAgingPaymProposalTmp
Origin #{611A7EFE-2ACD-459C-BF32-AF7BA4343CDA}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading6
DATE
PROPERTIES
Name #Heading6
Table #EBCVendAgingPaymProposalTmp
Origin #{96D23AF9-B1DA-446F-9592-3F6413272381}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading7
STRING
PROPERTIES
Name #Heading7
Table #EBCVendAgingPaymProposalTmp
Origin #{8BD96820-202B-416A-A724-7AF0DAF68D5E}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #Heading7DateValue
DATE
PROPERTIES
Name #Heading7DateValue
Table #EBCVendAgingPaymProposalTmp
Origin #{FC442D9A-89DE-411A-A3AC-B1CEE0235497}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading8
DATE
PROPERTIES
Name #Heading8
Table #EBCVendAgingPaymProposalTmp
Origin #{D56AFBE1-876B-4111-8ED4-58648793B151}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Heading9
DATE
PROPERTIES
Name #Heading9
Table #EBCVendAgingPaymProposalTmp
Origin #{8FF90233-3F90-4B6E-A764-42A231D7F074}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #HeadingAccount
STRING
PROPERTIES
Name #HeadingAccount
Table #EBCVendAgingPaymProposalTmp
Origin #{70A4B426-F3AB-4E2F-AFAE-6F9319061D8C}
ExtendedDataType #Addressing
StringSize #250
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription02
STRING
PROPERTIES
Name #HeadingAgingBucketDescription02
Table #EBCVendAgingPaymProposalTmp
Origin #{AFFCA94F-155C-49E5-BB72-84C3199095F0}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription03
STRING
PROPERTIES
Name #HeadingAgingBucketDescription03
Table #EBCVendAgingPaymProposalTmp
Origin #{D51CA06E-D260-4D68-88B7-CE5922C6660F}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription04
STRING
PROPERTIES
Name #HeadingAgingBucketDescription04
Table #EBCVendAgingPaymProposalTmp
Origin #{700819B6-2504-47FB-94EE-7CBD334B6513}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription05
STRING
PROPERTIES
Name #HeadingAgingBucketDescription05
Table #EBCVendAgingPaymProposalTmp
Origin #{788751F6-7762-4072-BBA3-4DED7727E7A4}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription06
STRING
PROPERTIES
Name #HeadingAgingBucketDescription06
Table #EBCVendAgingPaymProposalTmp
Origin #{B9F0715D-94CE-411F-BEA7-8464B45C1B8A}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingAgingBucketDescription07
STRING
PROPERTIES
Name #HeadingAgingBucketDescription07
Table #EBCVendAgingPaymProposalTmp
Origin #{4670E5C9-AE9F-4850-9F08-EE706812216C}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingDate
STRING
PROPERTIES
Name #HeadingDate
Table #EBCVendAgingPaymProposalTmp
Origin #{E3BCCCFF-6F76-414F-B6E5-1B046A9B0DCF}
ExtendedDataType #ColumnTxt
StringSize #40
ENDPROPERTIES
FIELD #HeadingName
STRING
PROPERTIES
Name #HeadingName
Table #EBCVendAgingPaymProposalTmp
Origin #{BF66649B-149D-44A4-BEE8-D65DD8A9153E}
ExtendedDataType #TransTxt
StringSize #60
ENDPROPERTIES
FIELD #HeadingVoucher
STRING
PROPERTIES
Name #HeadingVoucher
Table #EBCVendAgingPaymProposalTmp
Origin #{0BD2BDFB-7B33-4837-B878-5D3953D183A3}
ExtendedDataType #ColumnTxt
StringSize #40
ENDPROPERTIES
FIELD #InvoiceId
STRING
PROPERTIES
Name #InvoiceId
Table #EBCVendAgingPaymProposalTmp
Origin #{E1D7373F-895C-4EC2-8B1C-0226E959EDAD}
ExtendedDataType #InvoiceId
StringSize #20
ENDPROPERTIES
FIELD #Name
STRING
PROPERTIES
Name #Name
Table #EBCVendAgingPaymProposalTmp
Origin #{349A92A7-441F-40BD-B276-64947D309F52}
ExtendedDataType #VendName
StringSize #100
ENDPROPERTIES
FIELD #SortOrder
INT
PROPERTIES
Name #SortOrder
Table #EBCVendAgingPaymProposalTmp
Origin #{464BB78C-D0E9-433D-BB53-2DE69CDA3F14}
ExtendedDataType #Counter
ENDPROPERTIES
FIELD #TransDate
DATE
PROPERTIES
Name #TransDate
Table #EBCVendAgingPaymProposalTmp
Origin #{814441D7-B5BC-48FC-87A5-194A2F95545F}
ExtendedDataType #TransDate
ENDPROPERTIES
FIELD #Txt
STRING
PROPERTIES
Name #Txt
Table #EBCVendAgingPaymProposalTmp
Origin #{87AA8F4B-EE3C-4383-8FE5-1F1EA98B5F62}
ExtendedDataType #CustVendAgingTransTxt
StringSize #100
ENDPROPERTIES
FIELD #VendAccount
STRING
PROPERTIES
Name #VendAccount
Table #EBCVendAgingPaymProposalTmp
Origin #{6A3728CA-2F2C-4530-8114-BCB644529860}
ExtendedDataType #VendAccount
StringSize #20
ENDPROPERTIES
FIELD #VendGroup
STRING
PROPERTIES
Name #VendGroup
Table #EBCVendAgingPaymProposalTmp
Origin #{6DDDAF3A-5420-4F6A-9E53-76266CDA25E8}
ExtendedDataType #VendGroupId
ENDPROPERTIES
FIELD #Voucher
STRING
PROPERTIES
Name #Voucher
Table #EBCVendAgingPaymProposalTmp
Origin #{A686BE9D-9B77-491B-BAC8-04C4D312BDBD}
ExtendedDataType #Voucher
StringSize #20
ENDPROPERTIES
ENDFIELDS
GROUPS
GROUP #AutoReport
PROPERTIES
Name #AutoReport
ENDPROPERTIES
GROUPFIELDS
#AccountNum
#AsOfDate
#Balance
#Balance01
#Balance01Cur
#Balance02
#Balance02Cur
#Balance03
#Balance03Cur
#Balance04
#Balance04Cur
#Balance05
#Balance05Cur
#Balance06
#Balance06Cur
#Balance07
#Balance07Cur
#CurrencyCode
#Heading1
#Heading10
#Heading11
#Heading12
#Heading13
#Heading14
#Heading15
#Heading2
#Heading2DateValue
#Heading3
#Heading4
#Heading5
#Heading6
#Heading7
#Heading7DateValue
#Heading8
#Heading9
#HeadingAccount
#HeadingAgingBucketDescription02
#HeadingAgingBucketDescription03
#HeadingAgingBucketDescription04
#HeadingAgingBucketDescription05
#HeadingAgingBucketDescription06
#HeadingAgingBucketDescription07
#HeadingDate
#HeadingName
#HeadingVoucher
#InvoiceId
#Name
#TransDate
#Txt
#VendAccount
#VendGroup
#Voucher
ENDGROUPFIELDS
ENDGROUP
GROUP #General
PROPERTIES
Name #General
Label #@SYS19924
ENDPROPERTIES
GROUPFIELDS
#AccountNum
#AsOfDate
#Balance
#Balance01
#Balance01Cur
#Balance02
#Balance02Cur
#Balance03
#Balance03Cur
#Balance04
#Balance04Cur
#Balance05
#Balance05Cur
#Balance06
#Balance06Cur
#Balance07
#Balance07Cur
#CurrencyCode
#Heading1
#Heading10
#Heading11
#Heading12
#Heading13
#Heading14
#Heading15
#Heading2
#Heading2DateValue
#Heading3
#Heading4
#Heading5
#Heading6
#Heading7
#Heading7DateValue
#Heading8
#Heading9
#HeadingAccount
#HeadingAgingBucketDescription02
#HeadingAgingBucketDescription03
#HeadingAgingBucketDescription04
#HeadingAgingBucketDescription05
#HeadingAgingBucketDescription06
#HeadingAgingBucketDescription07
#HeadingDate
#HeadingName
#HeadingVoucher
#InvoiceId
#Name
#TransDate
#Txt
#VendAccount
#VendGroup
#Voucher
ENDGROUPFIELDS
ENDGROUP
ENDGROUPS
INDICES
#CurrencyIdx
PROPERTIES
Name #CurrencyIdx
Origin #{E9DDF1A2-2364-4DC2-B106-352DBE203108}
ENDPROPERTIES
INDEXFIELDS
#CurrencyCode
ENDINDEXFIELDS
ENDINDICES
FULLTEXTINDICES
ENDFULLTEXTINDICES
REFERENCES
REFERENCE #Currency
PROPERTIES
Name #Currency
Table #Currency
RelatedTableCardinality #ZeroOne
Cardinality #ZeroMore
RelationshipType #Association
UseDefaultRoleNames #Yes
EDTRelation #Yes
ENDPROPERTIES
FIELDREFERENCES
REFERENCETYPE PKFK
PROPERTIES
Field #CurrencyCode
RelatedField #CurrencyCode
ENDPROPERTIES
ENDFIELDREFERENCES
ENDREFERENCE
REFERENCE #VendGroup
PROPERTIES
Name #VendGroup
Table #VendGroup
RelatedTableCardinality #ZeroOne
Cardinality #ZeroMore
RelationshipType #Association
UseDefaultRoleNames #Yes
RelatedTableRole #VendGroup
Role #VendAgingReportTmp
EDTRelation #Yes
ENDPROPERTIES
FIELDREFERENCES
REFERENCETYPE PKFK
PROPERTIES
Field #VendGroup
RelatedField #VendGroup
ENDPROPERTIES
ENDFIELDREFERENCES
ENDREFERENCE
REFERENCE #VendTable
PROPERTIES
Name #VendTable
Table #VendTable
RelatedTableCardinality #ZeroOne
Cardinality #ZeroMore
RelationshipType #Association
UseDefaultRoleNames #Yes
EDTRelation #Yes
ENDPROPERTIES
FIELDREFERENCES
REFERENCETYPE PKFK
PROPERTIES
Field #VendAccount
RelatedField #AccountNum
ENDPROPERTIES
ENDFIELDREFERENCES
ENDREFERENCE
ENDREFERENCES
DELETEACTIONS
ENDDELETEACTIONS
METHODS
ENDMETHODS
ENDTABLE
***Element: CLS
; Microsoft Dynamics AX Class: EBCVendAgingPaymProposalContract unloaded
; --------------------------------------------------------------------------------
CLSVERSION 1
CLASS #EBCVendAgingPaymProposalContract
PROPERTIES
Name #EBCVendAgingPaymProposalContract
Origin #{E8FA447D-7D4A-4713-A5C5-4FD08ADA1C92}
ENDPROPERTIES
METHODS
SOURCE #classDeclaration
#/// <summary>
#/// Data Contract class for <c>VendAgingReport</c>Microsoft SQL Server Reporting Services report
#/// </summary>
#/// <remarks>
#/// This is the Data Contract class for the <c>VendAgingReport</c> SSRS Report.
#/// </remarks>
#[
# DataContractAttribute
#]
#public class EBCVendAgingPaymProposalContract implements SysOperationValidatable
#{
# TransDate startDate;
# TransDate zeroDate;
# DateTransactionDuedate dateTransactionDuedate;
# CustVendAgingBucketLookUp agingBuckets;
# NoYesCombo printAgingBucketDescription;
# PositiveDays interval;
# DayMonth period;
# ForwardBackwardPrinting direction;
# boolean detailed;
# boolean printZeroOrNegative;
# boolean payments;
# boolean excludeZeroBalanceVendor;
# boolean includeAmountCur;
# boolean printTotalLessThan100Euro;
# #define.emptyString('')
#}
#
ENDSOURCE
SOURCE #parmAgingBuckets
#/// <summary>
#/// Gets or sets the value of the datacontract parameter AgingBuckets.
#/// </summary>
#/// <param name="_agingBuckets">
#/// The new value of the datacontract parameter AgingBuckets; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter AgingBuckets
#/// </returns>
#[
# DataMemberAttribute('AgingBuckets'),
# SysOperationLabelAttribute(literalStr("@SYS78607")),
# SysOperationHelpTextAttribute(literalStr("@SYS28056")),
# SysOperationDisplayOrderAttribute('04')
#]
#public CustVendAgingBucketLookUp parmAgingBuckets(CustVendAgingBucketLookUp _agingBuckets = agingBuckets)
#{
# agingBuckets = _agingBuckets;
# return agingBuckets;
#}
ENDSOURCE
SOURCE #parmDateTransactionDuedate
#/// <summary>
#/// Gets or sets the value of the datacontract parameter DateTransactionDuedate.
#/// </summary>
#/// <param name="_dateTransactionDuedate">
#/// The new value of the datacontract parameter DateTransactionDuedate; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter DateTransactionDuedate
#/// </returns>
#[
# DataMemberAttribute('DateTransactionDuedate'),
# SysOperationLabelAttribute(literalStr("@SYS13128")),
# SysOperationHelpTextAttribute(literalStr("@SYS29102")),
# SysOperationDisplayOrderAttribute('03')
#]
#public DateTransactionDuedate parmDateTransactionDuedate(DateTransactionDuedate _dateTransactionDuedate = dateTransactionDuedate)
#{
# dateTransactionDuedate = _dateTransactionDuedate;
# return dateTransactionDuedate;
#}
ENDSOURCE
SOURCE #parmDetailed
#/// <summary>
#/// Gets or sets the value of the datacontract parameter Detailed.
#/// </summary>
#/// <param name="_detailed">
#/// The new value of the datacontract parameter Detailed; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter Detailed
#/// </returns>
#[
# DataMemberAttribute('Detailed'),
# SysOperationLabelAttribute(literalStr("@SYS8811")),
# SysOperationHelpTextAttribute(literalStr("@SYS20687")),
# SysOperationDisplayOrderAttribute('09')
#]
#public boolean parmDetailed(boolean _detailed = detailed)
#{
# detailed = _detailed;
# return detailed;
#}
ENDSOURCE
SOURCE #parmDirection
#/// <summary>
#/// Gets or sets the value of the datacontract parameter Direction.
#/// </summary>
#/// <param name="_direction">
#/// The new value of the datacontract parameter Direction; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter Direction
#/// </returns>
#[
# DataMemberAttribute('Direction'),
# SysOperationLabelAttribute(literalStr("@SYS70307")),
# SysOperationHelpTextAttribute(literalStr("@SYS70312")),
# SysOperationDisplayOrderAttribute('08')
#]
#public ForwardBackwardPrinting parmDirection(ForwardBackwardPrinting _direction = direction)
#{
# direction = _direction;
# return direction;
#}
ENDSOURCE
SOURCE #parmExcludeZeroBalanceVendor
#/// <summary>
#/// Gets or sets the value of the datacontract parameter <c>ExcludeZeroBalanceCustomers</c>.
#/// </summary>
#/// <param name="_excludeZeroBalanceVendor">
#/// The new value of the datacontract parameter <c>_excludeZeroBalanceVendor</c>; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter <c>_excludeZeroBalanceVendor</c>
#/// </returns>
#[
# DataMemberAttribute('ExcludeZeroBalanceVendor'),
# SysOperationLabelAttribute(literalStr("@SYS344269")),
# SysOperationHelpTextAttribute(literalStr("@SYS344270")),
# SysOperationDisplayOrderAttribute('12')
#]
#public boolean parmExcludeZeroBalanceVendor(boolean _excludeZeroBalanceVendor = excludeZeroBalanceVendor)
#{
# excludeZeroBalanceVendor = _excludeZeroBalanceVendor;
# return excludeZeroBalanceVendor;
#}
#
#
ENDSOURCE
SOURCE #parmIncludeAmountCur
#[
# DataMemberAttribute('IncludeAmountCur'),
# SysOperationLabelAttribute(literalStr("@SYS344267")),
# SysOperationHelpTextAttribute(literalStr("@SYS344268")),
# SysOperationDisplayOrderAttribute('10')
#]
#public boolean parmIncludeAmountCur(boolean _includeAmountCur = includeAmountCur)
#{
# includeAmountCur = _includeAmountCur;
# return includeAmountCur;
#}
ENDSOURCE
SOURCE #parmInterval
#/// <summary>
#/// Gets or sets the value of the datacontract parameter Interval.
#/// </summary>
#/// <param name="_interval">
#/// The new value of the datacontract parameter Interval; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter Interval
#/// </returns>
#[
# DataMemberAttribute('Interval'),
# SysOperationLabelAttribute(literalStr("@SYS12899")),
# SysOperationHelpTextAttribute(literalStr("@SYS17806")),
# SysOperationDisplayOrderAttribute('06')
#]
#public PositiveDays parmInterval(PositiveDays _interval = interval)
#{
# interval = _interval;
# return interval;
#}
ENDSOURCE
SOURCE #parmPayments
#/// <summary>
#/// Gets or sets the value of the datacontract parameter Payments.
#/// </summary>
#/// <param name="_payments">
#/// The new value of the datacontract parameter Payments; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter Payments
#/// </returns>
#[
# DataMemberAttribute('Payments'),
# SysOperationLabelAttribute(literalStr("@SYS68577")),
# SysOperationHelpTextAttribute(literalStr("@SYS68578")),
# SysOperationDisplayOrderAttribute('13')
#]
#public boolean parmPayments(boolean _payments = payments)
#{
# payments = _payments;
# return payments;
#}
ENDSOURCE
SOURCE #parmPeriod
#/// <summary>
#/// Gets or sets the value of the datacontract parameter Period.
#/// </summary>
#/// <param name="_period">
#/// The new value of the datacontract parameter Period; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter Period
#/// </returns>
#[
# DataMemberAttribute('Period'),
# SysOperationLabelAttribute(literalStr("@SYS16024")),
# SysOperationHelpTextAttribute(literalStr("@SYS67813")),
# SysOperationDisplayOrderAttribute('07')
#]
#public DayMonth parmPeriod(DayMonth _period = period)
#{
# period = _period;
# return period;
#}
ENDSOURCE
SOURCE #parmPrintAgingBucketDescription
#/// <summary>
#/// Gets or sets the value of the datacontract parameter PrintAgingBucketDescription.
#/// </summary>
#/// <param name="_printAgingBucketDescription">
#/// The new value of the datacontract parameter PrintAgingBucketDescription; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter PrintAgingBucketDescription
#/// </returns>
#[
# DataMemberAttribute('PrintAgingBucketDescription'),
# SysOperationLabelAttribute(literalStr("@SYS97360")),
# SysOperationHelpTextAttribute(literalStr("@SYS96942")),
# SysOperationDisplayOrderAttribute('05')
#]
#public NoYesCombo parmPrintAgingBucketDescription(NoYesCombo _printAgingBucketDescription = printAgingBucketDescription)
#{
# printAgingBucketDescription = _printAgingBucketDescription;
# return printAgingBucketDescription;
#}
ENDSOURCE
SOURCE #parmPrintZeroOrNegative
#/// <summary>
#/// Gets or sets the value of the datacontract parameter PrintZeroOrNegative.
#/// </summary>
#/// <param name="_printZeroOrNegative">
#/// The new value of the datacontract parameter PrintZeroOrNegative; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter PrintZeroOrNegative
#/// </returns>
#[
# DataMemberAttribute('PrintZeroOrNegative'),
# SysOperationLabelAttribute(literalStr("@SYS69732")),
# SysOperationHelpTextAttribute(literalStr("@SYS69733")),
# SysOperationDisplayOrderAttribute('11')
#]
#public boolean parmPrintZeroOrNegative(boolean _printZeroOrNegative = printZeroOrNegative)
#{
# printZeroOrNegative = _printZeroOrNegative;
# return printZeroOrNegative;
#}
ENDSOURCE
SOURCE #parmStartDate
#/// <summary>
#/// Gets or sets the value of the datacontract parameter StartDate.
#/// </summary>
#/// <param name="_startDate">
#/// The new value of the datacontract parameter StartDate; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter StartDate
#/// </returns>
#[
# DataMemberAttribute('StartDate'),
# SysOperationLabelAttribute(literalStr("@SYS6255")),
# SysOperationHelpTextAttribute(literalStr("@SYS29110")),
# SysOperationDisplayOrderAttribute('02')
#]
#public TransDate parmStartDate(TransDate _startDate = startDate)
#{
# startDate = _startDate;
# return startDate;
#}
ENDSOURCE
SOURCE #parmTotalLessThan100Euro
#/// <summary>
#/// Gets or sets the value of the datacontract parameter PrintZeroOrNegative.
#/// </summary>
#/// <param name="_printZeroOrNegative">
#/// The new value of the datacontract parameter PrintZeroOrNegative; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter PrintZeroOrNegative
#/// </returns>
#[
# DataMemberAttribute('TotalLessThan100Euro'),
# SysOperationLabelAttribute(literalStr("@SYS4160097")),
# SysOperationDisplayOrderAttribute('16')
#]
#public boolean parmTotalLessThan100Euro(boolean _printTotalLessThan100Euro = printTotalLessThan100Euro)
#{
# printTotalLessThan100Euro = _printTotalLessThan100Euro;
# return printTotalLessThan100Euro;
#}
ENDSOURCE
SOURCE #parmZeroDate
#/// <summary>
#/// Gets or sets the value of the datacontract parameter ZeroDate.
#/// </summary>
#/// <param name="_zeroDate">
#/// The new value of the datacontract parameter ZeroDate; optional.
#/// </param>
#/// <returns>
#/// The current value of datacontract parameter ZeroDate
#/// </returns>
#[
# DataMemberAttribute('ZeroDate'),
# SysOperationLabelAttribute(literalStr("@SYS137399")),
# SysOperationHelpTextAttribute(literalStr("@SYS137399")),
# SysOperationDisplayOrderAttribute('01')
#]
#public TransDate parmZeroDate(TransDate _zeroDate = zeroDate)
#{
# zeroDate = _zeroDate;
# return zeroDate;
#}
ENDSOURCE
SOURCE #validate
#/// <summary>
#/// Determines whether the parameters are valid.
#/// </summary>
#/// <returns>
#/// true is the parameters are valid; otherwise, false.
#/// </returns>
#public boolean validate()
#{
# boolean ret;
# CustVendAgingBucketLookUp agingBucket;
# StatRepIntervalLine statRepIntervalLine;
# ret = true;
# agingBucket = this.parmAgingBuckets();
#
# if (agingBucket != #emptyString)
# {
# select count(Qty) from statRepIntervalLine
# where statRepIntervalLine.Name == agingBucket;
#
# if (! statRepIntervalLine.Qty)
# {
# ret = checkFailed("@SYS90115");
# }
#
# if (statRepIntervalLine.Qty > 6)
# {
# ret = checkFailed("@SYS90116");
# }
# }
# return ret;
#}
ENDSOURCE
ENDMETHODS
ENDCLASS
***Element: CLS
; Microsoft Dynamics AX Class: EBCVendAgingPaymController unloaded
; --------------------------------------------------------------------------------
CLSVERSION 1
CLASS #EBCVendAgingPaymController
PROPERTIES
Name #EBCVendAgingPaymController
Extends #SrsReportRunController
Origin #{E0474E00-268C-483B-8AD7-E7E47BB88079}
ENDPROPERTIES
METHODS
SOURCE #classDeclaration
#/// <summary>
#/// The <c>VendAgingReportController</c> class is the controller class for the
#/// <c>VendAgingReport</c>Microsoft SQL Server Reporting Services report.
#/// </summary>
#public class EBCVendAgingPaymController extends SrsReportRunController
#{
# #define.reportName('EBCVendAgingPaym.Report')
#}
ENDSOURCE
SOURCE #getReportName
#private str getReportName(EBCVendAgingPaymProposalContract _contract)
#{
# str reportNameLocal;
#
# reportNameLocal = ssrsReportStr (EBCVendAgingPaym, Report);
#
# return reportNameLocal;
#}
ENDSOURCE
SOURCE #init
#/// <summary>
#/// Assigns the parameter values of controller
#/// </summary>
#public void init()
#{
# SRSCatalogItemName sRSCatalogItemName;
#
# sRSCatalogItemName = ssrsReportStr(EBCVendAgingPaym, Report);
#
# this.parmReportName(sRSCatalogItemName);
#}
ENDSOURCE
SOURCE #prePromptModifyContract
#protected void prePromptModifyContract()
#{
# EBCVendAgingPaymContract contract;
#
# super();
#
# contract = this.parmReportContract().parmRdpContract();
# //Due amount analysis (China)
# this.parmDialogCaption("@GLS100140");
#
# if (!contract.parmAsOn())
# {
# contract.parmAsOn(systemDateGet());
# }
#}
ENDSOURCE
SOURCE #main
#/// <summary>
#/// Initializes the controller, assigns parameter values and run <c>VendDueAmountAnalysis_CN</c> SSRS Report
#/// </summary>
#/// <param name="_args">
#/// The <c>Args</c> object
#/// </param>
#public static void main(Args _args)
#{
#
# EBCVendAgingPaymController controller = new EBCVendAgingPaymController();
#
# controller.parmReportName(#reportName);
# controller.parmArgs(_args);
# controller.startOperation();
#}
#
ENDSOURCE
ENDMETHODS
ENDCLASS
***Element: CLS
; Microsoft Dynamics AX Class: EBCVendAgingPaymProposalDP unloaded
; --------------------------------------------------------------------------------
CLSVERSION 1
CLASS #EBCVendAgingPaymProposalDP
PROPERTIES
Name #EBCVendAgingPaymProposalDP
Extends #SrsReportDataProviderPreProcessTempDB
RunOn #Server
Origin #{12D82211-A0D0-4D57-899F-5BA0A3ECA1AC}
ENDPROPERTIES
METHODS
SOURCE #classDeclaration
#/// <summary>
#/// The <c>VendAgingReportDP</c> class declares the variables that are used in the
#/// <c>VendAgingReport</c> report.
#/// </summary>
#[
# SRSReportQueryAttribute(queryStr(VendAgingReport)),
# SRSReportParameterAttribute(classStr(EBCVendAgingPaymProposalContract))
#]
#public class EBCVendAgingPaymProposalDP extends SRSReportDataProviderPreProcessTempDB
#{
# EBCVendAgingPaymProposalTmp vendAgingReportTmp;
# VendTmpAccountSum tmpAccountSum;
# CustVendBalanceList custVendBalanceList;
# EBCVendAgingPaymProposalContract contract;
# EBCVendAgingPaymProposalTmp vendAgingPaymProposalTmp;
#
# ColumnTxt headingDate;
# TransDate heading011;
# TransDate heading02;
# TransDate heading021;
# TransDate heading03;
# TransDate heading031;
# TransDate heading04;
# TransDate heading041;
# TransDate heading05;
# TransDate heading051;
# TransDate heading06;
# TransDate heading061;
# TransDate heading07;
# TransDate heading071;
#
# TransTxt heading01;
# TransTxt heading02Text;
# TransTxt heading07Text;
# TransTxt headingAgingBucketDescription02;
# TransTxt headingAgingBucketDescription03;
# TransTxt headingAgingBucketDescription04;
# TransTxt headingAgingBucketDescription05;
# TransTxt headingAgingBucketDescription06;
# TransTxt headingAgingBucketDescription07;
#
# #define.emptyString('')
#}
ENDSOURCE
SOURCE #getReverseAmountsAndHeadings
#private boolean getReverseAmountsAndHeadings(CustVendAgingBucketLookUp _agingBucket, ForwardBackwardPrinting _direction)
#{
# boolean reverseAmountsAndHeadings = false;
#
# if (_agingBucket == '' && _direction == ForwardBackwardPrinting::Forward)
# {
# reverseAmountsAndHeadings = true;
# }
#
# return reverseAmountsAndHeadings;
#}
ENDSOURCE
SOURCE #getVendAgingReportTmp
#/// <summary>
#/// Gets temporary table.
#/// </summary>
#/// <returns>
#/// The <c>VendAgingReportTmp</c> temporary table.
#/// </returns>
#[
# SRSReportDataSetAttribute('EBCVendAgingPaymProposalTmp')
#]
#public EBCVendAgingPaymProposalTmp getVendAgingReportTmp()
#{
# select vendAgingReportTmp;
# return vendAgingReportTmp;
#}
ENDSOURCE
SOURCE #heading01
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransTxt heading01()
#{
# return strFmt("@SYS137399", #emptyString);
#}
ENDSOURCE
SOURCE #heading011
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading011()
#{
# return contract.parmZeroDate();
#}
ENDSOURCE
SOURCE #heading02
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading02()
#{
# if (contract.parmAgingBuckets())
# {
# return custVendBalanceList.startdate(2);
# }
# else
# {
# return dateNull();
# }
#}
ENDSOURCE
SOURCE #heading021
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading021()
#{
# if(contract.parmAgingBuckets())
# {
# return custVendBalanceList.enddate(2);
# }
# else
# {
# return custVendBalanceList.enddate(3);
# }
#}
ENDSOURCE
SOURCE #heading02Text
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransTxt heading02Text()
#{
# if (contract.parmAgingBuckets())
# {
# return #emptyString;
# }
# else
# {
# return contract.parmDateTransactionDuedate() ? strFmt("@SYS60131", #emptyString) : strFmt("@SYS62491", #emptyString);
# }
#}
ENDSOURCE
SOURCE #heading03
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading03()
#{
# return custVendBalanceList.startdate(3);
#}
ENDSOURCE
SOURCE #heading031
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading031()
#{
# return custVendBalanceList.enddate(3);
#}
ENDSOURCE
SOURCE #heading04
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading04()
#{
# return custVendBalanceList.startdate(4);
#}
ENDSOURCE
SOURCE #heading041
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading041()
#{
# return custVendBalanceList.enddate(4);
#}
ENDSOURCE
SOURCE #heading05
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading05()
#{
# return custVendBalanceList.startdate(5);
#}
ENDSOURCE
SOURCE #heading051
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading051()
#{
# return custVendBalanceList.enddate(5);
#}
ENDSOURCE
SOURCE #heading06
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading06()
#{
# return custVendBalanceList.startdate(6);
#}
ENDSOURCE
SOURCE #heading061
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading061()
#{
# return custVendBalanceList.enddate(6);
#}
ENDSOURCE
SOURCE #heading07
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading07()
#{
# if (contract.parmAgingBuckets())
# {
# return custVendBalanceList.startdate(7);
# }
# else
# {
# return dateNull();
# }
#}
ENDSOURCE
SOURCE #heading071
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransDate heading071()
#{
# if(contract.parmAgingBuckets())
# {
# return custVendBalanceList.enddate(7);
# }
# else
# {
# return custVendBalanceList.startdate(6);
# }
#}
ENDSOURCE
SOURCE #heading07Text
#/// <summary>
#/// Gets the heading.
#/// </summary>
#/// <returns>
#/// The heading text.
#/// </returns>
#private TransTxt heading07Text()
#{
# if (contract.parmAgingBuckets())
# {
# return #emptyString;
# }
# else
# {
# return contract.parmDateTransactionDuedate() ? strFmt("@SYS29113", #emptyString) : strFmt("@SYS62492", #emptyString);
# }
#}
ENDSOURCE
SOURCE #headingAgingBucketDescription02
#/// <summary>
#/// Gets the heading description.
#/// </summary>
#/// <returns>
#/// The heading description text.
#/// </returns>
#private TransTxt headingAgingBucketDescription02()
#{
# if (contract.parmAgingBuckets() && contract.parmPrintAgingBucketDescription())
# {
# return strFmt('%1', custVendBalanceList.getDescription(2));
# }
# else
# {
# return #emptyString;
# }
#}
ENDSOURCE
SOURCE #headingAgingBucketDescription03
#/// <summary>
#/// Gets the heading description.
#/// </summary>
#/// <returns>
#/// The heading description text.
#/// </returns>
#private TransTxt headingAgingBucketDescription03()
#{
# if (contract.parmAgingBuckets() && contract.parmPrintAgingBucketDescription())
# {
# return strFmt('%1', custVendBalanceList.getDescription(3));
# }
# else
# {
# return #emptyString;
# }
#}
ENDSOURCE
SOURCE #headingAgingBucketDescription04
#/// <summary>
#/// Gets the heading description.
#/// </summary>
#/// <returns>
#/// The heading description text.
#/// </returns>
#private TransTxt headingAgingBucketDescription04()
#{
# if (contract.parmAgingBuckets() && contract.parmPrintAgingBucketDescription())
# {
# return strFmt('%1', custVendBalanceList.getDescription(4));
# }
# else
# {
# return #emptyString;
# }
#}
ENDSOURCE
SOURCE #headingAgingBucketDescription05
#/// <summary>
#/// Gets the heading description.
#/// </summary>
#/// <returns>
#/// The heading description text.
#/// </returns>
#private TransTxt headingAgingBucketDescription05()
#{
# if (contract.parmAgingBuckets() && contract.parmPrintAgingBucketDescription())
# {
# return strFmt('%1', custVendBalanceList.getDescription(5));
# }
# else
# {
# return #emptyString;
# }
#}
ENDSOURCE
SOURCE #headingAgingBucketDescription06
#/// <summary>
#/// Gets the heading description.
#/// </summary>
#/// <returns>
#/// The heading description text.
#/// </returns>
#private TransTxt headingAgingBucketDescription06()
#{
# if (contract.parmAgingBuckets() && contract.parmPrintAgingBucketDescription())
# {
# return strFmt('%1', custVendBalanceList.getDescription(6));
# }
# else
# {
# return #emptyString;
# }
#}
ENDSOURCE
SOURCE #headingAgingBucketDescription07
#/// <summary>
#/// Gets the heading description.
#/// </summary>
#/// <returns>
#/// The heading description text.
#/// </returns>
#private TransTxt headingAgingBucketDescription07()
#{
# if (contract.parmAgingBuckets() && contract.parmPrintAgingBucketDescription())
# {
# return strFmt('%1', custVendBalanceList.getDescription(7));
# }
# else
# {
# return #emptyString;
# }
#}
ENDSOURCE
SOURCE #headingDate
#private ColumnTxt headingDate()
#{
# switch (contract.parmDateTransactionDuedate())
# {
# case DateTransactionDuedate::DocumentDate : return "@SYS2587";
# case DateTransactionDuedate::TransactionDate : return "@SYS67";
# case DateTransactionDuedate::DueDate : return "@SYS14588";
# default : return "@SYS14588";
# }
#}
ENDSOURCE
SOURCE #initHeadingValues
#/// <summary>
#/// Assign and cache the heading values used for each record of the report
#/// </summary>
#private void initHeadingValues()
#{
# headingDate = this.headingDate();
# heading01 = this.heading01();
# heading011 = this.heading011();
# heading02 = this.heading02();
# heading02Text = this.heading02Text();
# heading021 = this.heading021();
# heading03 = this.heading03();
# heading031 = this.heading031();
# heading04 = this.heading04();
# heading041 = this.heading041();
# heading05 = this.heading05();
# heading051 = this.heading051();
# heading06 = this.heading06();
# heading061 = this.heading061();
# heading07 = this.heading07();
# heading07Text = this.heading07Text();
# heading071 = this.heading071();
# headingAgingBucketDescription02 = this.headingAgingBucketDescription02();
# headingAgingBucketDescription03 = this.headingAgingBucketDescription03();
# headingAgingBucketDescription04 = this.headingAgingBucketDescription04();
# headingAgingBucketDescription05 = this.headingAgingBucketDescription05();
# headingAgingBucketDescription06 = this.headingAgingBucketDescription06();
# headingAgingBucketDescription07 = this.headingAgingBucketDescription07();
#}
ENDSOURCE
SOURCE #insertVendAgingReportTmp
#/// <summary>
#/// Inserts records into the temporary <c>VendAgingReportTmp</c> table.
#/// </summary>
#/// <param name="_reverseAmountsAndHeadings">
#/// A boolean value which indicates whether the column values should be reversed.
#/// </param>
#/// <param name="_tmpTableRecordList">
#/// An existing RecordInsertList, which is used to store VendAgingReportTmp records for bulk insert.
#/// </param>
#private void insertVendAgingReportTmp(boolean _reverseAmountsAndHeadings, RecordInsertList _tmpTableRecordList)
#{
# Str1260 asOfDate = strFmt("@SYS84682", date2StrUsr(contract.parmZeroDate(), DateFlags::FormatAll), contract.parmDateTransactionDuedate());
# Addressing headingAccount = strFmt("@SYS24500");
# TransTxt headingName = strFmt("@SYS7399");
# AmountMST balance = 100;
# CustVendTransAging custVendTransAging = custVendBalanceList.getCustVendTransAging();
#
# if (_reverseAmountsAndHeadings)
# {
# insert_recordset vendAgingReportTmp
# (Blocked, EBCNameAlias, Balance01, Balance02, Balance03, Balance04, Balance05, Balance06, Balance07,
# Balance01cur, Balance02cur, Balance03cur, Balance04cur, Balance05cur, Balance06cur, Balance07cur,
# TransDate, InvoiceId, Voucher, AccountNum, Name, VendAccount, Txt, CurrencyCode, VendGroup,
# AsOfDate, HeadingAccount, HeadingName, HeadingDate, Heading1, Heading2DateValue, Heading2,
# Heading3, Heading4, Heading5, Heading6, Heading7DateValue, Heading7, Heading8, Heading9,
# Heading10, Heading11, Heading12, Heading13, Heading14, HeadingAgingBucketDescription02,
# HeadingAgingBucketDescription03, HeadingAgingBucketDescription04, HeadingAgingBucketDescription05,
# HeadingAgingBucketDescription06, HeadingAgingBucketDescription07, Balance, SortOrder)
# select
# Blocked, EBCNameAlias, Balance01, Balance07, Balance06, Balance05, Balance04, Balance03, Balance02,
# Balance01cur, Balance07cur, Balance06cur, Balance05cur, Balance04cur, Balance03cur, Balance02cur,
# TransDate, InvoiceId, Voucher, AccountNum, Name, AccountNum, Txt, CurrencyCode, GroupId,
# asOfDate, headingAccount, headingName, headingDate, heading01, heading02, heading07Text,
# heading03, heading04, heading05, heading06, heading07, heading02Text, heading011, heading03,
# heading031, heading041, heading051, heading061, heading061, headingAgingBucketDescription02,
# headingAgingBucketDescription03, headingAgingBucketDescription04, headingAgingBucketDescription05,
# headingAgingBucketDescription06, headingAgingBucketDescription07, balance
# from tmpAccountSum
# join SortOrder
# from custVendTransAging
# where tmpAccountSum.AccountNum == custVendTransAging.AccountNum;
#
# }
# else
# {
# insert_recordset vendAgingReportTmp
# (Blocked, EBCNameAlias, Balance01, Balance02, Balance03, Balance04, Balance05, Balance06, Balance07,
# Balance01cur, Balance02cur, Balance03cur, Balance04cur, Balance05cur, Balance06cur, Balance07cur,
# TransDate, InvoiceId, Voucher, AccountNum, Name, VendAccount, Txt, CurrencyCode, VendGroup,
# AsOfDate, HeadingAccount, HeadingName, HeadingDate, Heading1, Heading2DateValue, Heading2,
# Heading3, Heading4, Heading5, Heading6, Heading7DateValue, Heading7, Heading8, Heading9,
# Heading10, Heading11, Heading12, Heading13, Heading14, HeadingAgingBucketDescription02,
# HeadingAgingBucketDescription03, HeadingAgingBucketDescription04, HeadingAgingBucketDescription05,
# HeadingAgingBucketDescription06, HeadingAgingBucketDescription07, Balance, SortOrder)
# select
# Blocked, EBCNameAlias, Balance01, Balance02, Balance03, Balance04, Balance05, Balance06, Balance07,
# Balance01cur, Balance02cur, Balance03cur, Balance04cur, Balance05cur, Balance06cur, Balance07cur,
# TransDate, InvoiceId, Voucher, AccountNum, Name, AccountNum, Txt, CurrencyCode, GroupId,
# asOfDate, headingAccount, headingName, headingDate, heading01, heading02, heading02Text,
# heading03, heading04, heading05, heading06, heading07, heading07Text, heading011, heading021,
# heading031, heading041, heading051, heading061, heading071, headingAgingBucketDescription02,
# headingAgingBucketDescription03, headingAgingBucketDescription04, headingAgingBucketDescription05,
# headingAgingBucketDescription06, headingAgingBucketDescription07, balance
# from tmpAccountSum
# join SortOrder
# from custVendTransAging
# where tmpAccountSum.AccountNum == custVendTransAging.AccountNum;
# }
#}
#
#
ENDSOURCE
SOURCE #parmUseDefaultTransactionOnly
#public boolean parmUseDefaultTransactionOnly(boolean _useDefaultTransOnly = useDefaultTransOnly)
#{
# useDefaultTransOnly = true;
# return useDefaultTransOnly;
#}
ENDSOURCE
SOURCE #processReport
#/// <summary>
#/// Processes the report business logic.
#/// </summary>
#/// <remarks>
#/// This method is used to process the report business logic which is used by the <c>VendAgingReport</c> report.
#/// </remarks>
#[SysEntryPointAttribute]
#public void processReport()
#{
# QueryRun qr;
# ForwardBackwardPrinting tmpDirection;
# boolean reverseAmountsAndHeadings;
# RecordInsertList tmpTableRecordList = new RecordInsertList(tableNum(VendAgingReportTmp), true, true, true, false, true, vendAgingReportTmp);
#
# contract = this.parmDataContract() as EBCVendAgingPaymProposalContract;
#
# qr = new QueryRun(this.parmQuery());
#
# if (!contract.parmStartDate())
# {
# // When start date is not given then use the system session date.
# contract.parmStartDate(systemDateGet());
# }
#
# if (!contract.parmZeroDate())
# {
# // when balance as of date is not given then
# // use the max date.
# contract.parmZeroDate(dateMax());
# }
#
# if (contract.parmAgingBuckets())
# {
# // Force layout direction to backwards,
# // the actual direction of the columns is done in the construct method of the class: CustVendBalanceList
# tmpDirection = StatRepInterval::find(contract.parmAgingBuckets()).PrintDirection;
# }
# else
# {
# tmpDirection = contract.parmDirection();
# }
#
# reverseAmountsAndHeadings = this.getReverseAmountsAndHeadings(contract.parmAgingBuckets(), tmpDirection);
#
# custVendBalanceList = CustVendBalanceList::construct(SysModule::Vend,
# contract.parmDateTransactionDuedate(),
# contract.parmInterval(),
# contract.parmZeroDate());
# //contract.parmStartDate(),
# //contract.parmPayments(),
# //contract.parmPeriod(),
# //tmpDirection,
# ////contract.parmAgingBuckets(),
# //NoYes::Yes,
# //contract.parmDetailed(),
# //null,
# //NoYes::No,
# //contract.parmExcludeZeroBalanceVendor(),
# //!contract.parmPrintZeroOrNegative());
#
# custVendBalanceList.calculateDetailsForMultiple(qr, contract.parmIncludeAmountCur());
# //custVendBalanceList.calculateDetails(
# tmpAccountSum = custVendBalanceList.initTmpAccountSum();
#
# this.initHeadingValues();
#
# this.insertVendAgingReportTmp(reverseAmountsAndHeadings, tmpTableRecordList);
#}
#
ENDSOURCE
SOURCE #setVendAgingReportTmp
#// <summary>
#// Sets the values of headings , descriptions and amount fields of the temp table.
#// </summary>
#[SysObsoleteAttribute('This method is no longer used.', true)]
#private void setVendAgingReportTmp()
#{
# throw error(Error::wrongUseOfFunction(funcName()));
#}
ENDSOURCE
SOURCE #setVendAgingReportTmpInReverse
#// <summary>
#// Sets the values of headings, descriptions and amount fields of the temp table.
#// The amounts and description are reversed in order to match the selected direction value.
#// </summary>
#[SysObsoleteAttribute('This method is no longer used.', true)]
#private void setVendAgingReportTmpInReverse()
#{
# throw error(Error::wrongUseOfFunction(funcName()));
#}
ENDSOURCE
ENDMETHODS
ENDCLASS
***Element: PRN
; Microsoft Dynamics AX Project : EBC_CreditorPaymentProposal unloaded
; --------------------------------------------------------------------------------
PROJECTVERSION 2
PROJECT #EBC_CreditorPaymentProposal
SHARED
PROPERTIES
Name #EBC_CreditorPaymentProposal
Origin #{B0F44423-23CB-43BD-93D5-DADCE5FA1AD3}
ENDPROPERTIES
PROJECTCLASS ProjectNode
BEGINNODE
FILETYPE 0
UTILTYPE 127
UTILOBJECTID 0
NODETYPE 1531
NAME #EBCVendAgeingPaymReport
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 85
UTILOBJECTID 0
NODETYPE 1439
NAME #EBCVendAgingPaym
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 45
UTILOBJECTID 1021343
NODETYPE 329
NAME #VendDueAmountAnalysisContract_CN
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 44
UTILOBJECTID 100347
NODETYPE 204
NAME #CustVendBalanceTmp_CN
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 44
UTILOBJECTID 106506
NODETYPE 204
NAME #EBCVendAgingPaymTmp
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 45
UTILOBJECTID 1021317
NODETYPE 329
NAME #VendBalanceDP_CN
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 45
UTILOBJECTID 1031437
NODETYPE 329
NAME #EBCVendAgingPaymDP
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 45
UTILOBJECTID 1031436
NODETYPE 329
NAME #EBCVendAgingPaymContract
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 20
UTILOBJECTID 0
NODETYPE 330
NAME #EBCVendAgingPaym
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 44
UTILOBJECTID 10602
NODETYPE 204
NAME #VendAgingReportTmp
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 44
UTILOBJECTID 106505
NODETYPE 204
NAME #EBCVendAgingPaymProposalTmp
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 45
UTILOBJECTID 1031433
NODETYPE 329
NAME #EBCVendAgingPaymProposalContract
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 45
UTILOBJECTID 1031434
NODETYPE 329
NAME #EBCVendAgingPaymController
ENDNODE
BEGINNODE
FILETYPE 0
UTILTYPE 45
UTILOBJECTID 1031435
NODETYPE 329
NAME #EBCVendAgingPaymProposalDP
ENDNODE
ENDPROJECT
***Element: END
No comments:
Post a Comment