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
| icDomainCode | character | |
| icAddress | character | |
query condition
each cm_mstr where
cm_mstr.cm_domain = icDomainCode AND
cm_mstr.cm_addr = icAddress
query resultset tqCustomerByDomainAddress
| field name | data type | db field | description |
|---|
| tlcm_active | logical | cm_mstr.cm_active | Active |
| tccm_addr | character | cm_mstr.cm_addr | Customer |
| tlcm_datacomplete | logical | cm_mstr.cm_datacomplete | Data Complete |
| tccm_domain | character | cm_mstr.cm_domain | Domain |
| tlcm_po_reqd | logical | cm_mstr.cm_po_reqd | PO Required |
| tccm_region | character | cm_mstr.cm_region | Region |
| tccm_site | character | cm_mstr.cm_site | Site |
| tccm_type | character | cm_mstr.cm_type | Type |
| tdoid_cm_mstr | decimal | cm_mstr.oid_cm_mstr | |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(cm_mstr) |
Internal usage
QadFinancials