business logic query PostingByPostingDate

Description

This query is used to select Posting records according the PostingDate range.

Parameters

iiCompanyId	integer	Company id
itPostingDateFrom	date
itPostingDateTo	date
itPostingDate	date

query condition

each Posting where

Posting.Company_Id = iiCompanyId AND
(Posting.PostingDate >= itPostingDateFrom and
Posting.PostingDate <= itPostingDateTo ) AND
Posting.PostingDate = itPostingDate

first Company (inner-join) where

Company.Company_Id = iiCompanyId AND
Company.Company_ID = Posting.Company_ID AND

each CompanyProperty (inner-join) where

CompanyProperty.Company_Id = iiCompanyId AND
CompanyProperty.Company_ID = Company.Company_ID AND

first Journal (inner-join) where

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

each PostingLine (inner-join) where

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

first Currency (inner-join) where

Currency.Currency_ID = PostingLine.Currency_ID AND

first GL (inner-join) where

GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = PostingLine.GL_ID AND

query resultset tqPostingByPostingDate

field name	data type	db field	description
tiClosing_ID	integer	Posting.ObsoleteClosing_ID	Link to Closing
tiCompany_ID	integer	Posting.Company_ID	Link to Company
tiCompanyCurrency_ID	integer	CompanyProperty.Currency_ID	Base Currency
tiCompanyProperty_ID	integer	CompanyProperty.CompanyProperty_ID	Record ID
tiCostCentre_ID	integer	PostingLine.CostCentre_ID	Cost Center Code
tiCreatorUsr_ID	integer	Posting.CreatorUsr_ID	Login
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
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.
tiJournal_ID	integer	Journal.Journal_ID	Record ID
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tcJournalDescription	character	Journal.JournalDescription	A brief description of the daybook.
	api annotation:		Value for this field defaults to null.
tcJournalTypeCode	character	Journal.JournalTypeCode	A daybook type code.
	api annotation:		Value for this field defaults to "Journal Entries".
tiLastVerifiedUsr_ID	integer	Posting.LastVerifiedUsr_ID	Link to Usr
tiPeriod_ID	integer	Posting.Period_ID	Link to Period
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.
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
tiPostingLineCurrency_ID	integer	PostingLine.Currency_ID	Currency Code
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.
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
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	PostingLine.Project_ID	Description

Internal usage

QadFinancials

method BAccountingInterface.FillProDsGLVoucher