project QadFinancials > class BPosting > business logic query PostingLineByCostCentreProject

Description

PostingLineByCostCentreProject


Parameters


iiCompanyIdintegerCompany id
iiCostCentreIDintegerCostCentreId
iiProjectIDintegerProject ID
itPostingDateFromdateFrom wich posting date
itPostingDateTilldateTill wich posting date
iiPostingLineIDintegerPosting Line ID


query condition


  each PostingLine where
PostingLine.Company_Id = iiCompanyId AND
PostingLine.CostCentre_ID = iiCostCentreID AND
PostingLine.Project_ID = iiProjectID AND
PostingLine.PostingLine_ID = iiPostingLineID

      first CostCentre (conditional-join) where
CostCentre.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre.CostCentre_ID = PostingLine.CostCentre_ID AND

      first Division (conditional-join) where
Division.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division.Division_ID = PostingLine.Division_ID AND

      first GL (inner-join) where
GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = PostingLine.GL_ID AND

      first Posting (inner-join) where
Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = PostingLine.Posting_ID AND
Posting.PostingDate >= itPostingDateFrom AND
Posting.PostingDate <= itPostingDateTill

          first Journal (inner-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting.Journal_ID AND

          first Period (inner-join) where
Period.Company_Id = iiCompanyId AND
Period.Period_ID = Posting.Period_ID AND

      first Project (conditional-join) where
Project.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project.Project_ID = PostingLine.Project_ID AND


query resultset tqPostingLineByCostCentreProject


field namedata typedb fielddescription
tiCompany_IDintegerPosting.Company_IDLink to Company
tiCostCentre_IDintegerPostingLine.CostCentre_IDCost Center Code
tcCostCentreCodecharacterCostCentre.CostCentreCodeCost Center: A code that identifies the cost center.
tiCurrency_IDintegerPostingLine.Currency_IDCurrency Code
tiDivision_IDintegerPostingLine.Division_IDSub-Account Code
tcDivisionCodecharacterDivision.DivisionCodeSub-Account
tiGL_IDintegerPostingLine.GL_IDGL Description
tcGLCodecharacterGL.GLCodeA code identifying the GL account.
tiJournal_IDintegerPosting.Journal_IDDaybook Code
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tiPeriod_IDintegerPosting.Period_IDLink to Period
tiPeriodPeriodintegerPeriod.PeriodPeriodGL Period
tiPeriodYearintegerPeriod.PeriodYearGL Calendar Year
ttPostingDatedatePosting.PostingDateThe accounting date on which the journal entry is posted. The posting date must be a valid calendar date and must be within the GL calendar year (PostingYear) and period (PostingPeriod).
tiPostingLine_IDintegerPostingLine.PostingLine_IDRecord ID
tdPostingLineCreditTCdecimalPostingLine.PostingLineCreditTCTC Credit
tdPostingLineDebitTCdecimalPostingLine.PostingLineDebitTCTC Debit
tdPostingLineQTYdecimalPostingLine.PostingLineQTYQuantity
api annotation:Value for this field defaults to 0.0000.
tiPostingVoucherintegerPosting.PostingVoucherVoucher is a sequential number that uniquely identifies the journal entry (within the combination of an entity and a daybook code).
api annotation:In create mode,enter 0 in this field - the voucher number is generated by the system. In Modify/Delete, the correct voucher number must be entered because this identifies the record.
tiPostingYearintegerPosting.PostingYearThe GL calendar year for the posting.
tiProject_IDintegerPostingLine.Project_IDDescription
tcProjectCodecharacterProject.ProjectCodeProject
tiUnit_IDintegerGL.Unit_IDGL Account Unit of Measure
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(PostingLine),rowid(CostCentre),rowid(Division),rowid(GL),rowid(Posting),rowid(Journal),rowid(Period),rowid(Project)


Internal usage


QadFinancials
method BAPMatching.PostSaveUpdateOperationals