project QadFinancials > class BDebtorShipTo > business logic query DebtorShipToByIDCode

Parameters

iiDebtorShiptoId	integer
icDebtorShiptoCode	character
iiCompanyId	integer	Company id

query condition

each DebtorShipTo where

DebtorShipTo.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
DebtorShipTo.DebtorShipTo_ID = iiDebtorShiptoId AND
DebtorShipTo.DebtorShipToCode = icDebtorShiptoCode

query resultset tqDebtorShipToByIDCode

field name	data type	db field	description
tiAddress_ID	integer	DebtorShipTo.Address_ID	City
tiDebtor_ID	integer	DebtorShipTo.Debtor_ID	Customer Code
tiDebtorShipTo_ID	integer	DebtorShipTo.DebtorShipTo_ID	Record ID
tcDebtorShipToCode	character	DebtorShipTo.DebtorShipToCode	Ship-To Code. If you are not linking to another customer or to an end user, specify a new code. This code is automatically created with an address type of ship-to. If you leave Ship-To Code blank, the system Setting Up Business Relations automatically generates a number for the record based on the sequence defined in Customer Autonumber Create.
	api annotation:		If you select Link to Another Customer or Link to End User, the Ship-To Code field is filled with the value you specify for the customer or end user. These addresses are added as ship-tos for the customer specified in Customer Code.
tcDebtorShiptoName	character	DebtorShipTo.DebtorShipToName	Ship-To Name

Internal usage

QadFinancials

method BDebtorShipTo.DataLoadByInput
method BMfgAddress.MaintainDataDebtorShipto