project QadFinancials > class BClosingPostingsReport > business logic query PostingSafCombinedByPeriod


Parameters


iiCompanyIdintegerCompany id
iiFromPeriodinteger
iiTillPeriodinteger


query condition


  each PostingHist where
PostingHist.Company_Id = iiCompanyId AND
PostingHist.PostingHistYearPeriodFrom = iiFromPeriod AND
PostingHist.PostingHistYearPeriodTill >= iiTillPeriod AND
PostingHist.PostingHistYearPeriodFrom <= iiTillPeriod

      first PostingSafCombined (inner-join) where
PostingSafCombined.PostingSafCombined_ID = PostingHist.PostingSafCombined_ID AND


query resultset tqPostingSafCombinedByPeriod


field namedata typedb fielddescription
tiCostCentre1Saf_IDintegerPostingSafCombined.CostCentre1Saf_IDLink to CostCentre-SAF1
tiCostCentre2Saf_IDintegerPostingSafCombined.CostCentre2Saf_IDLink to CostCentre-SAF2
tiCostCentre3Saf_IDintegerPostingSafCombined.CostCentre3Saf_IDLink to CostCentre-SAF3
tiCostCentre4Saf_IDintegerPostingSafCombined.CostCentre4Saf_IDLink to CostCentre-SAF4
tiCostCentre5Saf_IDintegerPostingSafCombined.CostCentre5Saf_IDLink to CostCentre-SAF5
tiCostCentreSafStructure_IDintegerPostingSafCombined.CostCentreSafStructure_IDLink to SafStructure
tiGL1Saf_IDintegerPostingSafCombined.GL1Saf_IDLink to GL-SAF1
tiGL2Saf_IDintegerPostingSafCombined.GL2Saf_IDLink to GL-SAF2
tiGL3Saf_IDintegerPostingSafCombined.GL3Saf_IDLink to GL-SAF3
tiGL4Saf_IDintegerPostingSafCombined.GL4Saf_IDLink to GL-SAF4
tiGL5Saf_IDintegerPostingSafCombined.GL5Saf_IDLink to GL-SAF5
tiGLSafStructure_IDintegerPostingSafCombined.GLSafStructure_IDLink to SafStructure
tiPostingHist_IDintegerPostingHist.PostingHist_IDRecord ID
tiPostingSafCombined_IDintegerPostingSafCombined.PostingSafCombined_IDRecord ID
tiProject1Saf_IDintegerPostingSafCombined.Project1Saf_IDLink to Project-SAF1
tiProject2Saf_IDintegerPostingSafCombined.Project2Saf_IDLink to Project-SAF2
tiProject3Saf_IDintegerPostingSafCombined.Project3Saf_IDLink to Project-SAF3
tiProject4Saf_IDintegerPostingSafCombined.Project4Saf_IDLink to Project-SAF4
tiProject5Saf_IDintegerPostingSafCombined.Project5Saf_IDLink to Project-SAF5
tiProjectSafStructure_IDintegerPostingSafCombined.ProjectSafStructure_IDLink to SafStructure
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(PostingHist),rowid(PostingSafCombined)


Internal usage


QadFinancials
method BClosingPostingsReport.HistoryPostingsCheck
dataset BClosingPostingsReport.tPrevPHistSaf