business logic query BaseCashBook

Parameters

iiCompanyId	integer	Company id
icGLCode	character
itFromPostingDate	date
itToPostingDate	date
icJournalCode	character
iiPostingVoucher	integer
icLayer	character
iiAccPeriod	integer
iiAccYear	integer

query condition

each GL where

GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GLCode = icGLCode

each BankState (inner-join) where

BankState.Company_Id = iiCompanyId AND
BankState.GL_ID = GL.GL_ID AND

each BankStateLine (inner-join) where

BankStateLine.Company_Id = iiCompanyId AND
BankStateLine.BankState_ID = BankState.BankState_ID AND

first Posting (inner-join) where

Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = BankStateLine.Posting_ID AND
Posting.PostingDate >= itFromPostingDate AND
Posting.PostingDate <= itToPostingDate AND
Posting.PostingVoucher = iiPostingVoucher

first Journal (inner-join) where

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

first Layer (inner-join) where

Layer.Layer_ID = Journal.Layer_ID AND
Layer.LayerCode can-do icLayer

first Period (inner-join) where

Period.Company_Id = iiCompanyId AND
Period.Period_ID = Posting.Period_ID AND
Period.PeriodYear = iiAccYear AND
Period.PeriodPeriod = iiAccPeriod

each PostingLine (inner-join) where

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

first Currency1 (inner-join) where

Currency1.Currency_ID = PostingLine.Currency_ID AND

first GL2 (inner-join) where

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

first Currency2 (inner-join) where

Currency2.Currency_ID = BankState.Currency_ID AND

query resultset tqBaseCashBook

field name	data type	db field	description
tcBankStateLineInOut	character	BankStateLine.BankStateLineInOut	In/Out
tcCurrencyCode	character	Currency1.CurrencyCode	Currency Code
tcCurrencyCodeBankLine	character	Currency2.CurrencyCode	Currency Code
tiCurrencyNumberOfDecimals	integer	Currency1.CurrencyNumberOfDecimals	Number of Decimals
tiGL_ID	integer	GL.GL_ID	Record ID
tcGLCode	character	GL.GLCode	A code identifying the GL account.
tcGLCodeBank	character	GL2.GLCode	A code identifying the GL account.
tcGLDescription	character	GL.GLDescription	A description of the GL account.
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
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).
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.
tdPostingLineCreditTC	decimal	PostingLine.PostingLineCreditTC	TC Credit
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.
tdPostingLineDebitTC	decimal	PostingLine.PostingLineDebitTC	TC Debit
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	Period.PeriodYear	GL Calendar Year
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(GL),rowid(BankState),rowid(BankStateLine),rowid(Posting),rowid(Journal),rowid(Layer),rowid(Period),rowid(PostingLine),rowid(Currency1),rowid(GL2),rowid(Currency2)

Internal usage

QadFinancials

method BCashBoxReport.CashBook