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