project QadFinancials > class BDebtor > business logic query DebtorByDebtorIDCodeNoJoins


Parameters


iiCompanyIdintegerCompany id
iiDebtorIDinteger
icDebtorCodecharacter


query condition


  each Debtor where
Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.Debtor_ID = iiDebtorID AND
Debtor.DebtorCode = icDebtorCode


query resultset tqDebtorByDebtorIDCodeNoJoins


field namedata typedb fielddescription
tiBusinessRelation_IDintegerDebtor.BusinessRelation_IDBusiness Relation
tiDebtor_IDintegerDebtor.Debtor_IDRecord ID
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.
tlDebtorIsActivelogicalDebtor.DebtorIsActiveIndicate if this is an active record.
api annotation:Value for this field defaults to false.
tiSharedSet_IDintegerDebtor.SharedSet_IDLink to SharedSet


Internal usage


QadFinancials
method BDebtorEndUser.DataLoadByInput
method BDebtorShipTo.DataLoadByInput
method BDebtorShipTo.ValidateComponent