business logic query DebtorBalanceDHist

Parameters

iiCompanyId	integer	Company id
icCandoBRCode	character
icCandoDebtorCode	character
icCandoGLCode	character
iiEndOfYearPeriod	integer
icFromBRCode	character
icFromDebtorCode	character
icFromGLCode	character
icToBRCode	character
icToDebtorCode	character
icToGLCode	character

query condition

each Debtor where

Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.DebtorCode >= icFromDebtorCode AND
Debtor.DebtorCode <= icToDebtorCode AND
Debtor.DebtorCode can-do icCandoDebtorCode

first BusinessRelation (inner-join) where

BusinessRelation.BusinessRelation_ID = Debtor.BusinessRelation_ID AND
BusinessRelation.BusinessRelationCode >= icFromBRCode AND
BusinessRelation.BusinessRelationCode <= icToBRCode AND
BusinessRelation.BusinessRelationCode can-do icCandoBRCode

each DHist (inner-join) where

DHist.Company_Id = iiCompanyId AND
DHist.Debtor_ID = Debtor.Debtor_ID AND
DHist.DHistYearPeriodFrom <= iiEndOfYearPeriod AND
DHist.DHistYearPeriodTill >= iiEndOfYearPeriod

first Currency (inner-join) where

Currency.Currency_ID = DHist.Currency_ID AND

first GL (inner-join) where

GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = DHist.GL_ID AND
GL.GLCode >= icFromGLCode AND
GL.GLCode <= icToGLCode AND
GL.GLCode can-do icCandoGLCode

first Journal (inner-join) where

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

query resultset tqDebtorBalanceDHist

field name	data type	db field	description
tcBusinessRelationCode	character	BusinessRelation.BusinessRelationCode	Business Relation. A code to identify the business relation. If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create.
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tiCurrencyNumberOfDecimals	integer	Currency.CurrencyNumberOfDecimals	Number of Decimals
tiDebtor_ID	integer	Debtor.Debtor_ID	Record ID
tcDebtorCode	character	Debtor.DebtorCode	A code (maximum eight characters) that identifies a customer. If the code you specify matches an existing supplier code, a warning message displays. You can choose to ignore the warning, and create the record. However, when a supplier and customer share the same code, they must reference the same business relation.
	api annotation:		If you leave the Customer Code field blank, the system automatically generates a number for the record based on the sequence defined in Customer Autonumber Create.
tdDHistBalanceCC	decimal	DHist.DHistBalanceCC	SC Balance
tdDHistBalanceLC	decimal	DHist.DHistBalanceLC	BC Balance
tdDHistBalanceTC	decimal	DHist.DHistBalanceTC	TC Balance
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.
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".

Internal usage

QadFinancials

method BDebtorReport.DebtorAccountMovements