project QadFinancials > class BDebtorEndUser > business logic query DebtorEndUserByID

Parameters

icDebtorEndUserCode	character
iiDebtorEndUser_ID	integer
iiCompanyId	integer	Company id

query condition

each DebtorEndUser where

DebtorEndUser.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
DebtorEndUser.DebtorEndUser_ID = iiDebtorEndUser_ID AND
DebtorEndUser.DebtorEndUserCode = icDebtorEndUserCode

query resultset tqDebtorEndUserByID

field name	data type	db field	description
tiAddress_ID	integer	DebtorEndUser.Address_ID	City
tiDebtor_ID	integer	DebtorEndUser.Debtor_ID	Customer Code
tiDebtorEndUser_ID	integer	DebtorEndUser.DebtorEndUser_ID	Record ID
tcDebtorEndUserCode	character	DebtorEndUser.DebtorEndUserCode	End user code(maximum 8 characters).
	api annotation:		If you select Link to Customer or Link to Ship-To Address, the End User Code field is filled with the value you specify for the customer or ship-to address./ Otherwise the system automatically generates a number for the record based on the sequence defined in End User Autonumber Create.
tcDebtorEndUserName	character	DebtorEndUser.DebtorEndUserName	End User Name

Internal usage

QadFinancials

method BDebtorEndUser.DataLoadByInput
method BDebtorShipTo.ApiCreateDebtorShipto
method BDebtorShipTo.ApiMaintainDebtorShipto
method BMfgAddress.MaintainDataEndUser