project QadFinancials > class BDebtor > business logic query DebtorForShipto
Parameters
| iiCompanyId | integer | Company id |
| icDebtorCode | character | |
| icAddressTypeCode | character | |
query condition
each Debtor where
Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.DebtorCode = icDebtorCode
first BusinessRelation (inner-join) where
BusinessRelation.BusinessRelation_ID = Debtor.BusinessRelation_ID AND
each Address (inner-join) where
Address.BusinessRelation_ID = BusinessRelation.BusinessRelation_ID AND
first AddressType (inner-join) where
AddressType.AddressType_ID = Address.AddressType_ID AND
AddressType.AddressTypeCode = icAddressTypeCode
query resultset tqDebtorForShipto
| field name | data type | db field | description |
|---|
| tiAddress_ID | integer | Address.Address_ID | Record ID |
| tcAddressTypeCode | character | AddressType.AddressTypeCode | Address Type |
| tiBusinessRelation_ID | integer | BusinessRelation.BusinessRelation_ID | Record ID |
| tiDebtor_ID | integer | Debtor.Debtor_ID | Record ID |
| tcDebtorCode | character | Debtor.DebtorCode | A 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. |
Internal usage
QadFinancials