project QadFinancials > class BDebtorShipTo > business logic query DebtorShipToPrim


Parameters


iiDebtorShiptoIDinteger
icDebtorShiptoCodecharacter
iiCompanyIdintegerCompany id


query condition


  each DebtorShipTo where
DebtorShipTo.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
DebtorShipTo.DebtorShipTo_ID = iiDebtorShiptoID AND
DebtorShipTo.DebtorShipToCode = icDebtorShiptoCode

      first Debtor (inner-join) where
Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.Debtor_ID = DebtorShipTo.Debtor_ID AND


query resultset tqDebtorShipToPrim


field namedata typedb fielddescription
tiDebtor_IDintegerDebtorShipTo.Debtor_IDCustomer Code
tcDebtorCodecharacterDebtor.DebtorCodeA code (maximum eight characters) that identifies a customer. If the code you specify matches an existing supplier code, a warning message displays. You can choose to ignore the warning, and create the record. However, when a supplier and customer share the same code, they must reference the same business relation.
api annotation:If you leave the Customer Code field blank, the system automatically generates a number for the record based on the sequence defined in Customer Autonumber Create.
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 BDebtorEndUser.ApiCreateDebtorEndUser
method BDebtorEndUser.ValidateComponent
method BDebtorShipTo.ApiCreateDebtorShipto
method BDebtorShipTo.ApiMaintainDebtorShipto
method BDebtorShipTo.ApiReplicateFromDaemon
method BDInvoice.ValidateComponentAllShipTo
method BDInvoice.ValidateComponentAllStopQueries