project QadFinancials > class BMfgCustomer > business logic query CustomerByDomainAddress

Description

CustomerByDomainAddress: query that returns a limited set of fields based on the logical key (domain and address).


Parameters


icDomainCodecharacter
icAddresscharacter


query condition


  each cm_mstr where
cm_mstr.cm_domain = icDomainCode AND
cm_mstr.cm_addr = icAddress


query resultset tqCustomerByDomainAddress


field namedata typedb fielddescription
tlcm_activelogicalcm_mstr.cm_activeActive
tccm_addrcharactercm_mstr.cm_addrCustomer
tlcm_datacompletelogicalcm_mstr.cm_datacompleteData Complete
tccm_domaincharactercm_mstr.cm_domainDomain
tlcm_po_reqdlogicalcm_mstr.cm_po_reqdPO Required
tccm_regioncharactercm_mstr.cm_regionRegion
tccm_sitecharactercm_mstr.cm_siteSite
tccm_typecharactercm_mstr.cm_typeType
tdoid_cm_mstrdecimalcm_mstr.oid_cm_mstr
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(cm_mstr)


Internal usage


QadFinancials
method BDebtorEndUser.ValidateComponent
method BDInvoice.DefaultValuesShipFromShipTo
method BDInvoiceJournalEntry.CreateCustCtrlSafRecords
method BMfgEndUser.ApiReplicateFromFinancials
method BMfgEndUser.CreateMfgData
method BAPMatching.GetGLPLVarRateLogCharge