project QadFinancials > class BDebtorEndUser > business logic query DebtorEndUserByDebtorByAddress


Parameters


iiAddressIDinteger
ilDebtorEndUserIsShiptological
ilDebtorEndUserIsDebtorlogical
icDebtorShipToCodecharacter
iiDebtorIDinteger
iiCompanyIdintegerCompany id


query condition


  each DebtorEndUser where
DebtorEndUser.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
DebtorEndUser.Debtor_ID = iiDebtorID AND
DebtorEndUser.Address_ID = iiAddressID AND
DebtorEndUser.DebtorEndUserIsDebtor = ilDebtorEndUserIsDebtor AND
DebtorEndUser.DebtorEndUserIsShipTo = ilDebtorEndUserIsShipto AND
DebtorEndUser.DebtorEndUserCode <> icDebtorShipToCode


query resultset tqDebtorEndUserByDebtorByAddress


field namedata typedb fielddescription
tiAddress_IDintegerDebtorEndUser.Address_IDCity
tiDebtor_IDintegerDebtorEndUser.Debtor_IDCustomer Code
tiDebtorEndUser_IDintegerDebtorEndUser.DebtorEndUser_IDRecord ID
tcDebtorEndUserCodecharacterDebtorEndUser.DebtorEndUserCodeEnd 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.
tlDebtorEndUserIsDebtorlogicalDebtorEndUser.DebtorEndUserIsDebtorIndicate whether you select Link to Customer.Select this field if you want to define the customer entered in the field "tcDebtorCode" as an end user.
api annotation:Value for this field defaults to false.
tlDebtorEndUserIsShipTologicalDebtorEndUser.DebtorEndUserIsShipToIndicate whether you select Link to Ship-to Address. Select this field if you want to enter a shipto associated with the customer and define the ship-to as an end user.
api annotation:Value for this field defaults to false.


Internal usage


QadFinancials
method BDomain.AdditionalUpdatesReplication
method BMfgEndUser.MaintainDataBusinessRelation