business logic query BillByDebtorId

Parameters

iiCompanyId	integer	Company id
iiDebtor_ID	integer

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 name	data type	db field	description
tiBill_ID	integer	Bill.Bill_ID	Record ID
tdBillClosingBalanceTC	decimal	Bill.BillClosingBalanceTC	TC Closing Balance
ttBillConfirmDate	date	Bill.BillConfirmDate	Bill Confirm Date
ttBillDate	date	Bill.BillDate	Bill Date
ttBillDueDate	date	Bill.BillDueDate	Bill Due Date
tiBillNumber	integer	Bill.BillNumber	Bill Number
tdBillOpeningBalanceTC	decimal	Bill.BillOpeningBalanceTC	TC Opening Balance
tdBillPaymentAmtTC	decimal	Bill.BillPaymentAmtTC	TC Payment Amount
tdBillSalesAmtTC	decimal	Bill.BillSalesAmtTC	TC Sales Amount
tcBillStatus	character	Bill.BillStatus	Status
tdBillTaxAmtTC	decimal	Bill.BillTaxAmtTC	TC Tax Amount
tiBillYear	integer	Bill.BillYear	Bill Year
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
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.
tcEmployeeCode	character	Employee.EmployeeCode	Employee 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