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