project QadFinancials > class BCreditorBalance > business logic query CBalanceByCompanyCreditorCurr
Description
CBalanceByCompanyCreditorCurr: Query on CBalance with filtering-options on the Code and ID for the Company, Currency and Creditor
Parameters
iiCompanyID | integer | Company id |
iiCreditorID | integer | Creditor_ID |
iiCurrencyID | integer | Currency ID |
iiCBalanceID | integer | CBalance_ID |
icCompanyCode | character | CompanyCode |
icCreditorCode | character | CreditorCode |
icCurrencyCode | character | CurrencyCode |
query condition
each CBalance where
CBalance.Company_Id = iiCompanyId AND
CBalance.Creditor_ID = iiCreditorID AND
CBalance.Currency_ID = iiCurrencyID AND
CBalance.CBalance_ID = iiCBalanceID
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CBalance.Company_ID AND
Company.CompanyCode = icCompanyCode
first Creditor (inner-join) where
Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.Creditor_ID = CBalance.Creditor_ID AND
Creditor.CreditorCode = icCreditorCode
first Currency (inner-join) where
Currency.Currency_ID = CBalance.Currency_ID AND
Currency.CurrencyCode = icCurrencyCode
query resultset tqCBalanceByCompanyCreditorCurr
field name | data type | db field | description |
tiCBalance_ID | integer | CBalance.CBalance_ID | Record ID |
tiCompany_ID | integer | CBalance.Company_ID | Link to Company |
tcCompanyCode | character | Company.CompanyCode | Entity Code |
tiCreditor_ID | integer | CBalance.Creditor_ID | Link to Creditor |
tcCreditorCode | character | Creditor.CreditorCode | Supplier Code |
tiCurrency_ID | integer | CBalance.Currency_ID | Link to Currency |
tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
Internal usage
QadFinancials