Cu_CMH_Cust_Master_Hdr
This is a customer related master table that stores customer master details. It provides static reference data for linking customers and related attributes in transaction processing.
Process: SSU · Component: BasCu · Table type: Master Table Category: Stores customer master details to link operational transactions with accurate organizational and locational data.
This table is the canonical store for the Customer entity.
Primary key
CMH_Created_Ouinstance, CMH_Cust_Code
Columns (51)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | CMH_Cust_Name | varchar | Customer name |
| 2 | CMH_Cust_Nature | varchar | Nature of the customer (e.g., individual, corporate) |
| 3 | CMH_Reference_Status | varchar | Reference status of the customer |
| 4 | CMH_Operator_Code | varchar | Operator code associated with the customer |
| 5 | CMH_ParCust_Code | varchar | Parent customer code |
| 6 | CMH_Supl_Code | varchar | Supplier code linked to the customer |
| 7 | CMH_Spec_Code | varchar | Specification code associated with the customer |
| 8 | CMH_Sita_Code | datetime | SITA code for airline or airport reference |
| 9 | CMH_Register_Date | varchar | Customer registration date |
| 10 | CMH_Address1 | varchar | Customer address line 1 |
| 11 | CMH_Address2 | varchar | Customer address line 2 |
| 12 | CMH_Address3 | varchar | Customer address line 3 |
| 13 | CMH_City | varchar | Customer city |
| 14 | CMH_ZipCode | varchar | Customer postal/ZIP code |
| 15 | CMH_State | varchar | Customer state |
| 16 | CMH_Country | varchar | Customer country |
| 17 | CMH_phone_No | varchar | Customer phone number |
| 18 | CMH_Mobile_No | varchar | Customer mobile number |
| 19 | CMH_Fax_No | varchar | Customer fax number |
| 20 | CMH_Email_Id | varchar | Customer email ID |
| 21 | CMH_Url_Id | varchar | Customer website URL |
| 22 | CMH_Company_Code | varchar | Customer company code |
| 23 | CMH_BU_Code | varchar | Business unit code |
| 24 | CMH_PartSale_Flag | varchar | Flag indicating if part sales are applicable to the customer |
| 25 | CMH_SerSale_Flag | varchar | Flag indicating if service sales are applicable to the customer |
| 26 | CMH_CompLoan_Flag | varchar | Flag indicating if company loan is applicable to the customer |
| 27 | CMH_CompExange_Flag | varchar | Flag indicating if company exchange is applicable to the customer |
| 28 | CMH_Credcheck_Code | varchar | Credit check code associated with the customer |
| 29 | CMH_FileName | varchar | Customer-related file name or document |
| 30 | CMH_Remarks | varchar | Remarks about the customer |
| 31 | CMH_Enga_Type | varchar | Engagement type with the customer |
| 32 | CMH_Created_By | datetime | User who created the customer record |
| 33 | CMH_Created_Date | varchar | Customer record creation date |
| 34 | CMH_Modified_By | datetime | User who last modified the customer record |
| 35 | CMH_Modified_Date | int | Customer record last modified date |
| 36 | CMH_Timestamp | varchar | Timestamp of the customer record |
| 37 | CMH_UserName | varchar | Customer username |
| 38 | CMH_Restrict_Type | varchar | Type of restriction applicable to the customer |
| 39 | CMH_Multi_Oper | Char | Flag indicating multiple operators for the customer |
| 40 | CMH_Autogencso | varchar | Flag for automatic generation of customer sales orders |
| 41 | CMH_cuscatogerydesc | varchar | Customer category description |
| 42 | CMH_cuscatogerycode | varchar | Customer category code |
| 43 | CMH_LastReviewedDate | varchar | Date when the customer record was last reviewed |
| 44 | CMH_ValidTillDate | Char | Date until which the customer record is valid |
| 45 | CMH_prospect_no | Char | Prospect number for the customer |
| 46 | CMH_Address4 | Char | Customer address line 4 |
| 47 | cmh_county | Char | County of the customer |
| 48 | cmh_province | varchar | Province or state of the customer |
| 49 | CMH_Carragency | varchar | Carrier agency associated with the customer |
| 50 | CMH_Station | varchar | Customer station or location |
| 51 | CMH_Delpt | #N/A | Delivery point code for the customer |
Relationships (2)
CUSTOMER_IN_OU→ OrganizationUnit (—) (no automatic join)- Customer belongs to OU
- AMEPackage (FLOG_TLGMN_TECH_LOG_HDR) →
FOR_CUSTOMER(this table is target)- Join:
FLOG_TLGMN_TECH_LOG_HDR.tlgmn_cust_no = Cu_CMH_Cust_Master_Hdr.CMH_Cust_No - AME Package having customer reference
- Join:
Sample rows (from live DB)
CMH_Cust_Name | CMH_Cust_Nature | CMH_Reference_Status | CMH_Operator_Code | CMH_ParCust_Code | CMH_Supl_Code |
|---|---|---|---|---|---|
| CUST 1 | E | U | — | — | — |
| RAMCO | E | U | — | — | — |
| RAMCO | E | U | — | — | — |
Showing 3 of 684 rows.