project QadFinancials > class BDebtor > business logic query DebtorByCode

Description

Debtor by code


Parameters


iiCompanyIdintegerCompany id
icDebtorCodecharacter


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


query resultset tqDebtorByCode


field namedata typedb fielddescription
tiBusinessRelation_IDintegerDebtor.BusinessRelation_IDBusiness Relation
tcBusinessRelationCodecharacterBusinessRelation.BusinessRelationCodeBusiness Relation. A code to identify the business relation.
If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create.
tlBusinessRelationIsCompenslogicalBusinessRelation.BusinessRelationIsCompensCustomer/Supplier Compensation Allowed. This filed indicates how open items should be managed during payment processing when a customer and supplier are both associated with this business relation.
api annotation:PartialUpdate = yes - defaults to false.
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.
tiSharedSet_IDintegerDebtor.SharedSet_IDLink to SharedSet


Internal usage


QadFinancials
method BBankImportLine.GetDebtorByBankImpLine
method BDebtor.ApiExtractHighCreditInfo
method BDebtor.ApiGetARBalance
method BDebtor.ApiGetDebtorCreditStatus
method BDebtor.ApiGetDebtorLastSale
method BDebtor.ApiGetFixedCreditLimit
method BDebtor.ApiGetOpenOrdersTotal
method BDebtor.ApiGetTurnoverCreditLimit
method BDebtor.ApiUpdateDebtorHighCreditInfo
method BDebtorEndUser.ApiCreateDebtorEndUser
method BDebtorShipTo.ApiMaintainDebtorShipto
method BMfgAddress.MaintainDataDebtorShipto
method BOpenItemAdjustment.OIAdjNewOpenItem
dataset BBankImportLine.tDebtorByCode