project QadFinancials > class BPeriod > business logic query PeriodForSubLedgers

Description

Return all subledger-details for a period


Parameters


iiCompanyIdintegerCompany id
iiPeriodYearintegerAccounting Year
iiPeriodPeriodintegerGL Period
iiPeriodIDinteger


query condition


  each Period where
Period.Company_Id = iiCompanyId AND
Period.Period_ID = iiPeriodID AND
Period.PeriodYear = iiPeriodYear AND
Period.PeriodPeriod = iiPeriodPeriod


query sort order


Period.Company_ID (ascending)
Period.PeriodYear (ascending)
Period.PeriodPeriod (ascending)


query resultset tqPeriodForSubLedgers


field namedata typedb fielddescription
tiCompany_IDintegerPeriod.Company_IDLink to Company
tiPeriod_IDintegerPeriod.Period_IDRecord ID
ttPeriodClosingDatedatePeriod.PeriodClosingDateClosing Date
ttPeriodEndDatedatePeriod.PeriodEndDateEnd Date
tlPeriodIsPostingGLAllowedlogicalPeriod.PeriodIsPostingGLAllowedGL
tlPeriodIsPostingInvAllowedlogicalPeriod.PeriodIsPostingInvAllowedInventory
tlPeriodIsPostingOtherAllowlogicalPeriod.PeriodIsPostingOtherAllowOther
tlPeriodIsPostingPCAllowedlogicalPeriod.PeriodIsPostingPCAllowedPeriodic Costing
tlPeriodIsPostingPurchAllowlogicalPeriod.PeriodIsPostingPurchAllowPurchases
tlPeriodIsPostingSalesAllowlogicalPeriod.PeriodIsPostingSalesAllowSales
tlPeriodIsReportCheckedlogicalPeriod.PeriodIsReportCheckedChecked/Reported
tiPeriodMark_IDintegerPeriod.PeriodMark_IDMark
tiPeriodPeriodintegerPeriod.PeriodPeriodGL Period
tcPeriodReportingPeriodcharacterPeriod.PeriodReportingPeriodReporting GL Period
ttPeriodStartDatedatePeriod.PeriodStartDateStart Date
tcPeriodStatuscharacterPeriod.PeriodStatusStatus
tcPeriodTypeCodecharacterPeriod.PeriodTypeCodeGL Period Type
tiPeriodYearPeriodintegerPeriod.PeriodYearPeriodGL Calendar Year/GL Period
tiPeriodYearintegerPeriod.PeriodYearGL Calendar Year


Internal usage


QadFinancials
method BMassLayerTransfer.ApiExecuteLayerTransferV01
method BPeriod.ApiGetPeriodicCostingPropertyForPeriod