business logic query DBalanceByCompanyDebtorCurr

Description

DBalanceByCompanyDebtorCurr: Query on DBalance with filtering-options on the Code and ID for the Company, Currency and Debtor

each DBalance where

DBalance.Company_Id = iiCompanyId AND
DBalance.Debtor_ID = iiDebtorID AND
DBalance.Currency_ID = iiCurrencyID AND
DBalance.DBalance_ID = iiDBalanceID

first Company (inner-join) where

Company.Company_Id = iiCompanyId AND
Company.Company_ID = DBalance.Company_ID AND
Company.CompanyCode = icCompanyCode

first Currency (inner-join) where

Currency.Currency_ID = DBalance.Currency_ID AND
Currency.CurrencyCode = icCurrencyCode

first Debtor (inner-join) where

Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.Debtor_ID = DBalance.Debtor_ID AND
Debtor.DebtorCode = icDebtorCode

field name	data type	db field	description
tiCompany_ID	integer	DBalance.Company_ID	Link to Company
tcCompanyCode	character	Company.CompanyCode	Entity Code
tiCurrency_ID	integer	DBalance.Currency_ID	Link to Currency
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tiDBalance_ID	integer	DBalance.DBalance_ID	Record ID
tiDebtor_ID	integer	DBalance.Debtor_ID	Link to Debtor
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.

QadFinancials