project QadFinancials > class BConsolidDump > business logic query ConsolidDumpByCompany

Description

sorted on ToPeriodYear and ToPeriodPeriod

Parameters


iiCompanyIdintegerCompany id

query condition


  each ConsolidDump where
ConsolidDump.Company_Id = iiCompanyId AND

      first Currency (inner-join) where
Currency.Currency_ID = ConsolidDump.Currency_ID AND

      first Period1 (inner-join) where
Period1.Company_Id = iiCompanyId AND
Period1.Period_ID = ConsolidDump.FromPeriod_ID AND

      first Period2 (inner-join) where
Period2.Company_Id = iiCompanyId AND
Period2.Period_ID = ConsolidDump.ToPeriod_ID AND

query sort order


Period1.FromPeriodYear (ascending)
Period1.FromPeriodPeriod (ascending)

query resultset tqConsolidDumpByCompany


field namedata typedb fielddescription
tiCompany_IDintegerConsolidDump.Company_IDLink to Company
tiConsolidDump_IDintegerConsolidDump.ConsolidDump_IDRecord ID
tiConsolidDumpChunkSizeintegerConsolidDump.ConsolidDumpChunkSizeChunk Size
tcConsolidDumpCodecharacterConsolidDump.ConsolidDumpCodeCode
tcConsolidDumpConsolCompCodecharacterConsolidDump.ConsolidDumpConsolCompCodeConsolidation Entity
tdConsolidDumpConsolRatedecimalConsolidDump.ConsolidDumpConsolRateConsolidation Rate
tdConsolidDumpConsolRteScaledecimalConsolidDump.ConsolidDumpConsolRteScaleConsolid Scale Factor
ttConsolidDumpDatedateConsolidDump.ConsolidDumpDateExport Date
tcConsolidDumpDirectorycharacterConsolidDump.ConsolidDumpDirectoryExport Directory
tlConsolidDumpIsOpeningBallogicalConsolidDump.ConsolidDumpIsOpeningBalInclude Opening Balance
tlConsolidDumpIsWithDetaillogicalConsolidDump.ConsolidDumpIsWithDetailInclude Detail
tiCurrency_IDintegerConsolidDump.Currency_IDStatutory Currency
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
tiFromPeriod_IDintegerConsolidDump.FromPeriod_IDFrom GL Period
tiFromPeriodPeriodintegerPeriod1.PeriodPeriodGL Period
tiFromPeriodYearintegerPeriod1.PeriodYearGL Calendar Year
ttLastModifiedDatedateConsolidDump.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerConsolidDump.LastModifiedTimeLast Modified Time
tcLastModifiedUsercharacterConsolidDump.LastModifiedUserLast Modified User
tiToPeriod_IDintegerConsolidDump.ToPeriod_IDTo GL Period
tiToPeriodPeriodintegerPeriod2.PeriodPeriodGL Period
tiToPeriodYearintegerPeriod2.PeriodYearGL Calendar Year

Internal usage


QadFinancials
method BCompanyProperty.ValidateComponentModify
method BConsolidDump.InitialValues
method BDomainProperty.ValidateComponentPost