project QadFinancials > class BDebtor > business logic query DebtorPrim

Description

DebtorPrim


Parameters


iiCompanyIdintegerCompany id
icDebtorCodecharacterCustomer Code
iiDebtor_IDintegerCustomer ID


query condition


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

      first BusinessRelation (inner-join) where
BusinessRelation.BusinessRelation_ID = Debtor.BusinessRelation_ID AND


query resultset tqDebtorPrim


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.
tcBusinessRelationName1characterBusinessRelation.BusinessRelationName1Name: The full name of the business relation.
This field sets the default name for linked addresses such as customers and suppliers.
api annotation:PartialUpdate = yes - defaults to the BusinessRelationCode.
tcBusinessRelationSearchNamecharacterBusinessRelation.BusinessRelationSearchNameSearch Name: An alternate name for finding the business relation. This field can be useful for sorting and filtering.
api annotation:PartialUpdate = yes - defaults to the BusinessRelationCode.
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.
tdDebtorHighCreditdecimalDebtor.DebtorHighCreditThe highest amount of credit you have ever extended to this customer. This is the largest AR balance they have had open at one time.
tdDebtorSalesOrderBalancedecimalDebtor.DebtorSalesOrderBalanceCurrent balance of all sales order related to this customer.
api annotation:Value for this field defaults to 0.0000 .


Internal usage


QadFinancials
method BBankEntry.GetPossibleAllocationsDInvoice
method BBankImportLine.AdditionalUpdates
method BBankImportLine.GetBankNumberByNumber
method BBankImportLine.GetDebtorByBankImpLine
method BBankNumber.ApiLoadCustomerBankNumber
method BBankNumber.ApiStdMaintainTT
method BBankNumber.CalculateBankNumber
method BBankNumber.DataLoadByInput
method BBankNumber.ValidateComponentParentObject
method BBankPayFormat.DataLoadByInput
method BDDocument.Calculate
method BDDocument.CreateDDocumentHeader
method BDDocument.GetPossibleAllocationsByBank
method BDDocument.ValidateComponentPreDebtor
method BDDocument.ValidateComponentPreDInvoice
method BDebtor.ApiGetCustomFields
method BDebtor.ApiGetRoleScopeValues
method BDebtor.ApiLoadDebtor
method BDebtor.ApiLoadDebtorCalcDebtorCode
method BDebtor.ApiReplicateFromDaemon
method BDebtor.ApiStdMaintainTT
method BDebtor.Calculate
method BDebtorBalance.RebuildHistoryValidateInputCheckDaemon
method BDebtorEndUser.Calculate
method BDebtorFinanceCharge.FCDInvoiceCommit
method BDebtorReport.ApiGetAlternateKeyValues
method BDebtorReport.SetDataItemsBasedOnFilterTT
method BDebtorShipTo.ApiShipToAndHOAddress
method BDebtorShipTo.Calculate
method BDebtorShipTo.ValidateComponent
method BDInvoice.CreateDIBank
method BDInvoice.CreateDInvoicesValidate
method BDInvoice.CreateDIPostingValidate
method BDInvoice.DefaultValuesNewBankNumber
method BDInvoice.DefaultValuesValidate
method BDInvoice.ValidateComponentPre
method BDomain.AdditionalUpdatesReplication
method BJournalEntry.CalcAllSelectPostingVat
method BJournalEntry.CalcAllSelectPostingVatV01
method BOpenItemAdjustment.OIAdjApplyFilterDebtor
method BPaymentSelection.ExportUNIFIPreselectCreditor
method BProject.ApiLoadProject
method BProject.ApiLoadProjectCalcDebtorCode
method BVATExportListing.ApiExportQuarterSum
dataset BBankImportLine.tDebtorPrim
read related business field(s) on tBill.Debtor_ID
read related business field(s) on tDDocument.Debtor_ID
read related business field(s) on tDebtor.BillToDebtor_ID
read related business field(s) on tDebtorEndUser.Debtor_ID
read related business field(s) on tDebtorShipTo.Debtor_ID
read related business field(s) on tDInvoice.Debtor_ID
read related business field(s) on tDInvoice.SoldToDebtor_ID
read related business field(s) on tProject.Debtor_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tBill.Debtor_ID
validate related business field(s) on tDDocument.Debtor_ID
validate related business field(s) on tDebtor.BillToDebtor_ID
validate related business field(s) on tDebtorEndUser.Debtor_ID
validate related business field(s) on tDebtorShipTo.Debtor_ID
validate related business field(s) on tDInvoice.Debtor_ID
validate related business field(s) on tDInvoice.SoldToDebtor_ID
validate related business field(s) on tProject.Debtor_ID