project QadFinancials > class BDebtorBalance > business logic query DBalanceByCompanyDebtorCurr
Description
DBalanceByCompanyDebtorCurr: Query on DBalance with filtering-options on the Code and ID for the Company, Currency and Debtor
Parameters
iiCompanyId | integer | Company id |
iiDBalanceID | integer | |
icCompanyCode | character | |
icDebtorCode | character | |
iiDebtorID | integer | |
icCurrencyCode | character | |
iiCurrencyID | integer | |
query condition
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
query resultset tqDBalanceByCompanyDebtorCurr
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. |
Internal usage
QadFinancials