project QadFinancials > class BBill > business logic query BillByDebtorId


Parameters


iiCompanyIdintegerCompany id
iiDebtor_IDinteger


query condition


  each Bill where
Bill.Company_Id = iiCompanyId AND
Bill.Debtor_ID = iiDebtor_ID AND
Bill.BillStatus <> {&BILLSTATUS-CLOSED}

      first Currency (inner-join) where
Currency.Currency_ID = Bill.Currency_ID AND

      first Debtor (inner-join) where
Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.Debtor_ID = Bill.Debtor_ID AND

      first Employee (conditional-join) where
Employee.Company_Id = iiCompanyId AND
Employee.Employee_ID = Bill.Employee_ID AND


query resultset tqBillByDebtorId


field namedata typedb fielddescription
tiBill_IDintegerBill.Bill_IDRecord ID
tdBillClosingBalanceTCdecimalBill.BillClosingBalanceTCTC Closing Balance
ttBillConfirmDatedateBill.BillConfirmDateBill Confirm Date
ttBillDatedateBill.BillDateBill Date
ttBillDueDatedateBill.BillDueDateBill Due Date
tiBillNumberintegerBill.BillNumberBill Number
tdBillOpeningBalanceTCdecimalBill.BillOpeningBalanceTCTC Opening Balance
tdBillPaymentAmtTCdecimalBill.BillPaymentAmtTCTC Payment Amount
tdBillSalesAmtTCdecimalBill.BillSalesAmtTCTC Sales Amount
tcBillStatuscharacterBill.BillStatusStatus
tdBillTaxAmtTCdecimalBill.BillTaxAmtTCTC Tax Amount
tiBillYearintegerBill.BillYearBill Year
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
tcDebtorCodecharacterDebtor.DebtorCodeA 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.
tcEmployeeCodecharacterEmployee.EmployeeCodeEmployee Code. A code that identifies an employee. The code cannot match any other employee in the current entity or any other entities in the current domain.
If you leave the Employee Code field blank, the system automatically generates a number for the record based on the sequence defined in Employee Autonumber Create.


Internal usage


QadFinancials
method BDebtor.GetDebtorBillData