business logic query PostingByPeriodRange

Parameters

iiCompanyId	integer	Company id
iiFromYearPeriod	integer
iiToYearPeriod	integer

query condition

each Posting where

Posting.Company_Id = iiCompanyId AND
Posting.PostingYearPeriod >= iiFromYearPeriod and
Posting.PostingYearPeriod <= iiToYearPeriod

first Journal (inner-join) where

Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting.Journal_ID AND

first Layer (inner-join) where

Layer.Layer_ID = Journal.Layer_ID AND

each PostingLine (inner-join) where

PostingLine.Company_Id = iiCompanyId AND
PostingLine.Posting_ID = Posting.Posting_ID AND

first BusinessRelation (outer-join) where

BusinessRelation.BusinessRelation_ID = PostingLine.IntercoBusinessRelation_ID AND

first CostCentre (outer-join) where

CostCentre.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre.CostCentre_ID = PostingLine.CostCentre_ID AND

first Currency (inner-join) where

Currency.Currency_ID = PostingLine.Currency_ID AND

first Division (outer-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 Unit (outer-join) where

Unit.Unit_ID = GL.Unit_ID AND

first Project (outer-join) where

Project.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project.Project_ID = PostingLine.Project_ID AND

query resultset tqPostingByPeriodRange

field name	data type	db field	description
tcBusinessRelationICCode	character	BusinessRelation.BusinessRelationICCode	Intercompany Code. When Intercompany is true, this field is mandatory. The code entered here must match the intercompany code entered for GL accounts in order to generate intercompany reports. The intercompany code must be unique for this business relation.
tiClosing_ID	integer	Posting.ObsoleteClosing_ID	Link to Closing
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.
tiCreatorUsr_ID	integer	Posting.CreatorUsr_ID	Login
tiCrossCompany_ID	integer	PostingLine.CrossCompany_ID	Link to Company
tiCrossCompanyPosting_ID	integer	PostingLine.CrossCompanyPosting_ID	Posting (Cross-Cy)
tiCrossCompanyPostingLine_ID	integer	PostingLine.CrossCompanyPostingLine_ID	Posting line (Cross-Cy)
tiCurrency_ID	integer	PostingLine.Currency_ID	Currency Code
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tcCustomCombo0	character	Posting.CustomCombo0	Custom Combo Field
tcCustomCombo1	character	Posting.CustomCombo1	Custom Combo Field
tiDivision_ID	integer	PostingLine.Division_ID	Sub-Account Code
tcDivisionCode	character	Division.DivisionCode	Sub-Account
tiGL_ID	integer	GL.GL_ID	Record ID
tcGLCode	character	GL.GLCode	A code identifying the GL account.
tcGLDescription	character	GL.GLDescription	A description of the GL account.
tlGLIsAutomaticAccount	logical	GL.GLIsAutomaticAccount	Automatic Account: Indicate what types of posting this account accepts. Its value is decided by the value of tcPostingType.
	api annotation:		This field can be left blank as it will be calculated by the system.
tlGLIsDebitAccount	logical	GL.GLIsDebitAccount	Debit/Credit: The posting designation for this account.
	api annotation:		This field can be left blank as it will be calculated by the system.
tcGLTypeCode	character	GL.GLTypeCode	A code identifying the type of account.
tiIntercoBusinessRelation_ID	integer	PostingLine.IntercoBusinessRelation_ID	Intercompany Code
tiJournal_ID	integer	Posting.Journal_ID	Daybook Code
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tiLastVerifiedUsr_ID	integer	Posting.LastVerifiedUsr_ID	Link to Usr
tcLayerTypeCode	character	Layer.LayerTypeCode	Layer Type
tiPeriod_ID	integer	Posting.Period_ID	Link to Period
tiPeriodMark_ID	integer	Posting.PeriodMark_ID	Link to PeriodMark
tiPosting_ID	integer	Posting.Posting_ID	Record ID
tiPostingAddGLNbr	integer	Posting.PostingAddGLNbr	When additional GL numbering is enabled for an entity, all postings for this entity are assigned a continuous, uninterrupted incremental sequence numbers as the value for this field.
	api annotation:		When additional GL numbering is not enabled for the current entity, value for this field defaults to 0.
tcPostingBusinessRelationTxt	character	Posting.PostingBusinessRelationTxt	When the posting is a transaction linked to a business relation (for example, an invoice posting), this field contains the Business Relation Name. Used for information purposes on reports and browses.
	api annotation:		Value for this field defaults to blank.
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).
tcPostingInvoiceReferenceTxt	character	Posting.PostingInvoiceReferenceTxt	When the posting is part of an invoice posting, then this field contains the invoice number (Year/Daybook/Voucher extended with supplier invoice Reference in case of a supplier invoice). Used for information purpose on reports and browsers.
	api annotation:		Value for this field defaults to blank
tiPostingLine_ID	integer	PostingLine.PostingLine_ID	Record ID
tiPostingLineCompanyId	integer	PostingLine.Company_ID	Link to Company
tcPostingLineCostCentreText	character	PostingLine.PostingLineCostCentreText	Cost Center
	api annotation:		Value for this field defaults to blank.
tdPostingLineCreditCC	decimal	PostingLine.PostingLineCreditCC	SC Credit
	api annotation:		Partial Update = yes - it will get a default value depending on the value of PostingLinCreditTC, PostingLineCCRate & PostingLineCCScale. SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, you should enter the correct value for this field
tdPostingLineCreditLC	decimal	PostingLine.PostingLineCreditLC	BC Credit
	api annotation:		Partial Update = yes - it will get a default value depends on the value of PostingLineCreditTC, PostingLineExchangeRate & PostingLineRateScale. BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update is false, enter a value for this field.
tdPostingLineCreditPC	decimal	PostingLine.PostingLineCreditPC	PC Credit
	api annotation:		This field is obsolete and can be left blank.
tdPostingLineCreditTC	decimal	PostingLine.PostingLineCreditTC	TC Credit
tdPostingLineDebitCC	decimal	PostingLine.PostingLineDebitCC	SC Debit
	api annotation:		Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineCCRate & PostingLineCCScale. SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, enter the correct value for this field.
tdPostingLineDebitLC	decimal	PostingLine.PostingLineDebitLC	BC Debit
	api annotation:		Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineExchangeRate and PostingLineRateScale. BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update = false, enter the correct value into this field.
tdPostingLineDebitPC	decimal	PostingLine.PostingLineDebitPC	PC Debit
	api annotation:		This field is obsolete.
tdPostingLineDebitTC	decimal	PostingLine.PostingLineDebitTC	TC Debit
tdPostingLineExchangeRate	decimal	PostingLine.PostingLineExchangeRate	Exchange Rate
	api annotation:		Default value for this field depends on the exchang erate shared set specified for the current domain.
tlPostingLineIsProjPosting	logical	PostingLine.PostingLineIsProjPosting	Project Posting
tiPostingLineMaster_ID	integer	PostingLine.PostingLineMaster_ID	Link to Master
tiPostingLinePeriodId	integer	PostingLine.Period_ID	Link to Period
tiPostingLinePostingId	integer	PostingLine.Posting_ID	Link to Posting
tcPostingLineProjectText	character	PostingLine.PostingLineProjectText	Project
	api annotation:		Value for this field defaults to blank.
tdPostingLineQTY	decimal	PostingLine.PostingLineQTY	Quantity
	api annotation:		Value for this field defaults to 0.0000.
tdPostingLineRateScale	decimal	PostingLine.PostingLineRateScale	Scale Factor
	api annotation:		The default value is 1.
tcPostingLineSafText	character	PostingLine.PostingLineSafText	SAF
	api annotation:		Value for this field defaults to blank.
tiPostingLineSequence	integer	PostingLine.PostingLineSequence	Sequence
tcPostingLineText	character	PostingLine.PostingLineText	Description
	api annotation:		Value for this field defaults to blank. Note: if a new record is created through the user interface, the default value is as same as the value of "PostingText" of tPosting.
tiPostingLineTransaction_ID	integer	PostingLine.PostingLineTransaction_ID	Link to Transaction
tiPostingLineYearPeriod	integer	PostingLine.PostingYearPeriod	The GL calendar year/period for the journal entry.
	api annotation:		In Create mode, it will get be defaulted to the value for the field PostingYearPeriod of tPosting.
tcPostingParentText	character	Posting.PostingParentText	Contains the description field from the parent object that triggered the posting. When the posting is an invoice posting, this field contains the invoice description. When the posting is a banking entry posting, the description of the bank statement line is copied to this field, etc. Used for information purposes on reports and browses.
	api annotation:		Value for this field defaults to blank.
tiPostingPeriod	integer	Posting.PostingPeriod	The GL period for the posting. The period must be open.
ttPostingSystemDate	date	Posting.PostingSystemDate	The system date of the posting corresponding to "PostingDate".
	api annotation:		In Create mode, when Partial Update = yes - this field gets a default value which is the current date of the system.
tcPostingText	character	Posting.PostingText	Free text describing the posting.
	api annotation:		Value for this field defaults to blank
ttPostingValueDate	date	Posting.PostingValueDate	The value date (used for banking entries).
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.
tiPostingYearPeriod	integer	Posting.PostingYearPeriod	The GL calendar year/period for the posting. This field is determined by "PostingPeriod" and "PostingYear".
	api annotation:		If Partial Update is true, the value defaults using PostingPeriod and PostingYear.
tiProject_ID	integer	Project.Project_ID	Record ID
tcProjectCode	character	Project.ProjectCode	Project
tcProjectDescription	character	Project.ProjectDescription	Description
tcUnitCode	character	Unit.UnitCode	Unit of Measure

Internal usage

QadFinancials

method BJournalEntry.DumpJEDetForConsolid
method BJournalEntry.DumpJESumForConsolid