project QadFinancials > class BDebtorShipTo > business logic query DebtorShiptoByAddress


Parameters


iiCompanyIdintegerCompany id
iiAddressIDinteger
iiDebtorShiptoIDDifferentFrominteger


query condition


  each DebtorShipTo where
DebtorShipTo.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
DebtorShipTo.Address_ID = iiAddressID AND
DebtorShipTo.DebtorShipTo_ID <> iiDebtorShiptoIDDifferentFrom


query resultset tqDebtorShiptoByAddress


field namedata typedb fielddescription
tiAddress_IDintegerDebtorShipTo.Address_IDCity
tiDebtor_IDintegerDebtorShipTo.Debtor_IDCustomer Code
tiDebtorShipTo_IDintegerDebtorShipTo.DebtorShipTo_IDRecord ID
tcDebtorShipToCodecharacterDebtorShipTo.DebtorShipToCodeShip-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.


Internal usage


QadFinancials
method BBusinessRelation.ValidateComponentAddressDelete
method BBusinessRelation.ValidateComponentDelete
method BDebtorShipTo.AdditionalUpdates
method BDebtorShipTo.Calculate
method BDebtorShipTo.DataLoadByInput
method BDebtorShipTo.ValidateComponentUpdateAllSharedShiptos