business logic query PostingLineByCostCentreProject

Description

PostingLineByCostCentreProject

Parameters

iiCompanyId	integer	Company id
iiCostCentreID	integer	CostCentreId
iiProjectID	integer	Project ID
itPostingDateFrom	date	From wich posting date
itPostingDateTill	date	Till wich posting date
iiPostingLineID	integer	Posting 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 name	data type	db field	description
tiCompany_ID	integer	Posting.Company_ID	Link to Company
tiCostCentre_ID	integer	PostingLine.CostCentre_ID	Cost Center Code
tcCostCentreCode	character	CostCentre.CostCentreCode	Cost Center: A code that identifies the cost center.
tiCurrency_ID	integer	PostingLine.Currency_ID	Currency Code
tiDivision_ID	integer	PostingLine.Division_ID	Sub-Account Code
tcDivisionCode	character	Division.DivisionCode	Sub-Account
tiGL_ID	integer	PostingLine.GL_ID	GL Description
tcGLCode	character	GL.GLCode	A code identifying the GL account.
tiJournal_ID	integer	Posting.Journal_ID	Daybook Code
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tiPeriod_ID	integer	Posting.Period_ID	Link to Period
tiPeriodPeriod	integer	Period.PeriodPeriod	GL Period
tiPeriodYear	integer	Period.PeriodYear	GL Calendar Year
ttPostingDate	date	Posting.PostingDate	The 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_ID	integer	PostingLine.PostingLine_ID	Record ID
tdPostingLineCreditTC	decimal	PostingLine.PostingLineCreditTC	TC Credit
tdPostingLineDebitTC	decimal	PostingLine.PostingLineDebitTC	TC Debit
tdPostingLineQTY	decimal	PostingLine.PostingLineQTY	Quantity
	api annotation:		Value for this field defaults to 0.0000.
tiPostingVoucher	integer	Posting.PostingVoucher	Voucher 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.
tiPostingYear	integer	Posting.PostingYear	The GL calendar year for the posting.
tiProject_ID	integer	PostingLine.Project_ID	Description
tcProjectCode	character	Project.ProjectCode	Project
tiUnit_ID	integer	GL.Unit_ID	GL Account Unit of Measure
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(PostingLine),rowid(CostCentre),rowid(Division),rowid(GL),rowid(Posting),rowid(Journal),rowid(Period),rowid(Project)

Internal usage

QadFinancials

method BAPMatching.PostSaveUpdateOperationals