project QadFinancials > class BDebtorEndUser > business logic query DebtorEndUserByID


Parameters


icDebtorEndUserCodecharacter
iiDebtorEndUser_IDinteger
iiCompanyIdintegerCompany 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 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.
tcDebtorEndUserNamecharacterDebtorEndUser.DebtorEndUserNameEnd User Name


Internal usage


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