Description
Returns DebtorBalance records for a certain Debtor, Company and Currency.
query filter (table tFilter)
| tcBusinessFieldName | tcDataType | tcOperator |
|---|
| iiCompanyId | i | |
| iiDebtorId | i | = |
| iiCurrencyId | i | = |
| icFromDebtor | c | >= |
| icToDebtor | c | <= |
| icCanDoDebtor | c | can-do |
| ilActiveDebtors | l | = |
| ilWithReminders | l | = |
| tDBalance.DBalanceCC | d | =,>=,>,<>,<=,< |
| tDBalance.DBalanceLC | d | =,>=,>,<>,<=,< |
| tDBalance.DBalanceTC | d | =,>=,>,<>,<=,< |
Parameters (internal)
| iiCompanyId | integer | Company id |
| iiDebtorId | integer | |
| iiCurrencyId | integer | CurrencyID |
| icFromDebtor | character | From Customer |
| icToDebtor | character | To Customer |
| icCanDoDebtor | character | Can Do Customer |
| ilActiveDebtors | logical | |
| ilWithReminders | logical | |
query condition
each DBalance where
DBalance.Company_Id = iiCompanyId AND
DBalance.Debtor_ID = iiDebtorId AND
DBalance.Currency_ID = iiCurrencyId
first Debtor (inner-join) where
Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.Debtor_ID = DBalance.Debtor_ID AND
Debtor.DebtorCode >= icFromDebtor AND
Debtor.DebtorCode <= icToDebtor AND
Debtor.DebtorCode can-do icCanDoDebtor AND
Debtor.DebtorIsActive = ilActiveDebtors AND
Debtor.DebtorIsPrintReminder = ilWithReminders
query resultset tqDebtorBalance
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | DBalance.Company_ID | Link to Company |
| tiCurrency_ID | integer | DBalance.Currency_ID | Link to Currency |
| tiDBalance_ID | integer | DBalance.DBalance_ID | Record ID |
| tdDBalanceCC | decimal | DBalance.DBalanceCC | SC Balance |
| tdDBalanceLC | decimal | DBalance.DBalanceLC | BC Balance |
| tdDBalanceTC | decimal | DBalance.DBalanceTC | TC Balance |
| tiDebtor_ID | integer | DBalance.Debtor_ID | Link to Debtor |
| DBalanceCustom | character | calculated | custom fields |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(DBalance),rowid(Debtor) |
Internal usage
QadFinancials