business logic query DebtorForBill

Parameters

iiCompanyId	integer	Company id
icDebtorList	character

each Debtor where

Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.Debtor_ID can-do icDebtorList AND
Debtor.BillSchedule_ID <> 0

first BillSchedule (inner-join) where

BillSchedule.BillSchedule_ID = Debtor.BillSchedule_ID AND

field name	data type	db field	description
tiBillSchedule_ID	integer	BillSchedule.BillSchedule_ID	Record ID
tcBillScheduleCode	character	BillSchedule.BillScheduleCode	Billing Schedule Code
tcBillScheduleDueDateCalType	character	BillSchedule.BillScheduleDueDateCalType	Calculation Type
tiDebtor_ID	integer	Debtor.Debtor_ID	Record ID
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.

QadFinancials