project QadFinancials > class BDebtorShipTo > business logic query DebtorShipToForDebtorByIsDebtor


Parameters


iiDebtorIDinteger
ilDebtorShiptoIsDebtorlogical
icDebtorShiptoCodecharacter
iiCompanyIdintegerCompany id


query condition


  each DebtorShipTo where
DebtorShipTo.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
DebtorShipTo.Debtor_ID <> iiDebtorID AND
DebtorShipTo.DebtorShipToIsDebtor = ilDebtorShiptoIsDebtor 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 tqDebtorShipToForDebtorIsDebtor


field namedata typedb fielddescription
tiAddress_IDintegerDebtorShipTo.Address_IDCity
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.
tlDebtorShipToIsDebtorlogicalDebtorShipTo.DebtorShipToIsDebtorSelect this field if you want to specify another customer as the ship-to of this customer.
api annotation:Value for this field defaults to false. If it is true, the related customer code selected is used to fill the ship-to code field.


Internal usage


QadFinancials
method BDebtor.ValidateComponent
method BDebtorShipTo.ValidateComponent