business logic query DebtorEndUserForShipto

Parameters

iiCompanyId	integer	Company id
icDebtorEndUserCode	character

each DebtorEndUser where

DebtorEndUser.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND

first Address (inner-join) where

Address.Address_ID = DebtorEndUser.Address_ID AND

first BusinessRelation (inner-join) where

BusinessRelation.BusinessRelation_ID = Address.BusinessRelation_ID AND

field name	data type	db field	description
tiAddress_ID	integer	DebtorEndUser.Address_ID	City
tiBusinessRelation_ID	integer	BusinessRelation.BusinessRelation_ID	Record ID
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.

QadFinancials