business logic query BaseCashOperation

Parameters

iiCompanyId	integer	Company id
icBankStateTransactionType	character
icCanDoBankStateLines	character

query condition

each BankState where

BankState.Company_Id = iiCompanyId AND
BankState.BankStateTransactionType = icBankStateTransactionType

each BankStateLine (conditional-join) where

BankStateLine.Company_Id = iiCompanyId AND
BankStateLine.BankState_ID = BankState.BankState_ID AND
string(BankStateLine1.BankStateLine_ID) can-do icCanDoBankStateLines

each BankStateAlloc (conditional-join) where

BankStateAlloc.Company_Id = iiCompanyId AND
BankStateAlloc.BankStateLine_ID = BankStateLine.BankStateLine_ID AND

first CInvoice (outer-join) where

CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoice_ID = BankStateAlloc.CInvoice_ID AND

first Creditor (outer-join) where

Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.Creditor_ID = CInvoice.Creditor_ID AND

first DInvoice (outer-join) where

DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoice_ID = BankStateAlloc.DInvoice_ID AND

first Debtor (outer-join) where

Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.Debtor_ID = DInvoice.Debtor_ID AND

first Posting1 (outer-join) where

Posting1.Company_Id = iiCompanyId AND
Posting1.Posting_ID = BankStateAlloc.Posting_ID AND

first Posting2 (conditional-join) where

Posting2.Company_Id = iiCompanyId AND
Posting2.Posting_ID = BankStateLine.Posting_ID AND

each PostingLine (conditional-join) where

PostingLine.Company_Id = iiCompanyId AND
PostingLine.Posting_ID = Posting2.Posting_ID AND

first Currency1 (conditional-join) where

Currency1.Currency_ID = PostingLine.Currency_ID AND

first GL (conditional-join) where

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

first Currency2 (inner-join) where

Currency2.Currency_ID = BankState.Currency_ID AND

query resultset tqBaseCashOperation

field name	data type	db field	description
ttBankStateLinePostingDate	date	BankStateLine.BankStateLinePostingDate	Posting Date
tcLastModifiedUser	character	BankStateLine.LastModifiedUser	Last Modified User
tiBankStateLine_ID	integer	BankStateLine.BankStateLine_ID	Record ID
tcBankStateLineInOut	character	BankStateLine.BankStateLineInOut	In/Out
tdBankStateLineAmountTC	decimal	BankStateLine.BankStateLineAmountTC	TC Amount
tcBankStateLineDescription	character	BankStateLine.BankStateLineDescription	Description
tcBankStateLineInformation	character	BankStateLine.BankStateLineInformation	Information
tiAloccPosting_ID	integer	BankStateAlloc.Posting_ID	Link to Posting
tdBankStateAllocBankAmountTC	decimal	BankStateAlloc.BankStateAllocBankAmountTC	TC Bank Amt
tiCInvoice_ID	integer	BankStateAlloc.CInvoice_ID	Link to CInvoice
tiDInvoice_ID	integer	BankStateAlloc.DInvoice_ID	Link to DInvoice
tiBankStateAlloc_ID	integer	BankStateAlloc.BankStateAlloc_ID	Record ID
tiAlocPostingVoucher	integer	Posting1.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.
tiAlocPostingYear	integer	Posting1.PostingYear	The GL calendar year for the posting.
tiAlocPeriod_ID	integer	Posting1.Period_ID	Link to Period
tiAlocJournal_ID	integer	Posting1.Journal_ID	Daybook Code
tiDInvoiceVoucher	integer	DInvoice.DInvoiceVoucher	Voucher.This field displays the numeric identifier assigned to the posting. When the daybook of the journal entry is charged(after transfer), the voucher is cleared. Voucher must be unique in one GL period. When the user input is zero, the system automatically assign a value not used yet for this field.
tiDInvJournal_ID	integer	DInvoice.Journal_ID	Daybook Code
tiDInvPeriod_ID	integer	DInvoice.Period_ID	Link to Period
tiDebBusRel_ID	integer	Debtor.BusinessRelation_ID	Business Relation
tiCInvoiceVoucher	integer	CInvoice.CInvoiceVoucher	Voucher. This field displays the numeric identifier assigned to the posting. When the daybook of the journal entry is changed (after transfer), the voucher is cleared. Voucher must be unique in one GL period. When the user input is zero, the system automatically assign a value not used yet for this field.
tiCInvJournal_ID	integer	CInvoice.Journal_ID	Daybook Code
tiCInvPeriod_ID	integer	CInvoice.Period_ID	Link to Period
tiCrBusRel_ID	integer	Creditor.BusinessRelation_ID	Name
ttPostingDate	date	Posting2.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).
tiPostingVoucher	integer	Posting2.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	Posting2.PostingYear	The GL calendar year for the posting.
tiJournal_ID	integer	Posting2.Journal_ID	Daybook Code
tiPeriod_ID	integer	Posting2.Period_ID	Link to Period
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
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.
tiPostingLine_ID	integer	PostingLine.PostingLine_ID	Record ID
tiCurrencyNumberOfDecimalsPost	integer	Currency1.CurrencyNumberOfDecimals	Number of Decimals
tcPostingLineCurrency	character	Currency1.CurrencyCode	Currency Code
tcGLCode	character	GL.GLCode	A code identifying the GL account.
tiCurrencyNumberOfDecimals	integer	Currency2.CurrencyNumberOfDecimals	Number of Decimals
tcCurrencyCode	character	Currency2.CurrencyCode	Currency Code
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(BankState),rowid(BankStateLine),rowid(BankStateAlloc),rowid(CInvoice),rowid(Creditor),rowid(DInvoice),rowid(Debtor),rowid(Posting1),rowid(Posting2),rowid(PostingLine),rowid(Currency1),rowid(GL),rowid(Currency2)

Internal usage

QadFinancials

method BCashBoxReport.CashPaid
method BCashBoxReport.CashReceived