CREATE TABLE "global_cust_clmnstre" (
  "GLOBAL_CUST_KEY" varchar(60) NOT NULL,
  "GLOBAL_IDENT_NUM" varchar(50) DEFAULT NULL,
  "ASOF_DT" datetime NOT NULL,
  "REL_GRP_KEY" varchar(30) DEFAULT NULL,
  "CUST_OWNR_KEY" varchar(20) DEFAULT NULL,
  "IDENT_NUM_TYP" varchar(30) DEFAULT NULL,
  "CUST_NM" varchar(200) DEFAULT NULL,
  "MAS_INDUSTRY_CD" varchar(20) DEFAULT NULL,
  "MAS_INDUSTRY_DESC" varchar(80) DEFAULT NULL,
  "SIC_CD" varchar(20) DEFAULT NULL,
  "SIC_DESC" varchar(512) DEFAULT NULL,
  "CNTRY_OF_REGISTRATION" varchar(3) DEFAULT NULL,
  "CNTRY_NM_OF_REGISTRATION" varchar(44) DEFAULT NULL,
  "DT_OF_REGISTRATION" datetime DEFAULT NULL,
  "LOCAL_RM_CD" varchar(50) DEFAULT NULL,
  "LRM_NM" varchar(100) DEFAULT NULL,
  "GLOBAL_RM_CD" varchar(50) DEFAULT NULL,
  "GRM_NM" varchar(100) DEFAULT NULL,
  "CR_APRVR_CD" varchar(50) DEFAULT NULL,
  "CR_APRVR_NM" varchar(100) DEFAULT NULL,
  "CUST_TYP_IND" varchar(20) DEFAULT NULL,
  "PRM_DOC_NUM" varchar(20) DEFAULT NULL,
  "PRM_DOC_TYP" varchar(255) DEFAULT NULL,
  "PRM_DOC_ISSUE_CNTRY_CD" varchar(3) DEFAULT NULL,
  "PRM_DOC_ISSUE_CNTRY_NM" varchar(44) DEFAULT NULL,
  "PRM_DOC_ISSUE_DT" datetime DEFAULT NULL,
  "PRM_DOC_EXPIRE_DT" datetime DEFAULT NULL,
  "REF_CD" varchar(50) DEFAULT NULL,
  "REF_CD_TYP" varchar(20) DEFAULT NULL,
  "UPDT_DT" datetime DEFAULT NULL,
  "CONSTN_CD" varchar(5) DEFAULT NULL,
  "CONSTN_DESC" varchar(40) DEFAULT NULL,
  "LRM_CNTRY_CD" varchar(3) DEFAULT NULL,
  "GRM_CNTRY_CD" varchar(3) DEFAULT NULL,
  "BRWNG_CUST_FLG" char(1) DEFAULT NULL,
  "NEW_CUST_FLG" char(1) DEFAULT NULL,
  "LOST_CUST_FLG" char(1) DEFAULT NULL,
  "INDUSTRY_SPCLST_CD" varchar(30) DEFAULT NULL,
  "INDUSTRY_SPCLST_NM" varchar(100) DEFAULT NULL,
  "INDUSTRY_SPCLST_REL_GRP_KEY" varchar(30) DEFAULT NULL,
  "INDUSTRY_SPCLST_CNTRY_CD" varchar(30) DEFAULT NULL,
  "SUSPEND_FLG" varchar(20) DEFAULT NULL,
  "GCIN_CREATE_DT" datetime DEFAULT NULL,
  "S35_IND" varchar(100) DEFAULT NULL,
  "BASEL_ENTITY_CLSS" varchar(30) DEFAULT NULL,
  "CR_DEPT" varchar(100) DEFAULT NULL,
  "CR_RISK_MNGR" varchar(100) DEFAULT NULL,
  "PRGM_ID_CD" varchar(100) DEFAULT NULL,
  "PRGM_ID_DESC" varchar(200) DEFAULT NULL,
  "CRM_PTFLIO_CD" varchar(100) DEFAULT NULL,
  "CRM_PTFLIO_DESC" varchar(200) DEFAULT NULL,
  "SPVSNG_OFFCR" varchar(100) DEFAULT NULL,
  "SPVSNG_DEPT" varchar(100) DEFAULT NULL,
  "RSDEN_CNTRY" varchar(100) DEFAULT NULL,
  "PRNCPL_CNTRY" varchar(100) DEFAULT NULL,
  "GTS_CLIENT_FLG" varchar(1) DEFAULT NULL,
  "STATUS" varchar(5) DEFAULT NULL,
  "CLOSURE_REASON" varchar(100) DEFAULT NULL,
  "IND_COVERAGE" varchar(80) DEFAULT NULL,
  "GI_CD_KEY" varchar(30) DEFAULT NULL,
  "CNTRY_HQ" varchar(100) DEFAULT NULL,
  "REF_NO" varchar(100) DEFAULT NULL,
  "RELATIONSHIP_GRP" varchar(65) DEFAULT NULL,
  "RECORD_STATUS" varchar(5) DEFAULT NULL,
  "SRM" varchar(50) DEFAULT NULL,
  "CLIENT_PROFILE" varchar(10) DEFAULT NULL,
  "CNTRY_OF_ORIGIN" varchar(50) DEFAULT NULL,
  "PRM_DOC_PLACE_CNTRY_CD" varchar(100) DEFAULT NULL,
  "RM_1" varchar(50) DEFAULT NULL,
  "RM_2" varchar(50) DEFAULT NULL,
  "RM_3" varchar(50) DEFAULT NULL,
  "RM_4" varchar(50) DEFAULT NULL,
  "NATURE_OF_BIZ" varchar(255) DEFAULT NULL,
  "LISTED_STATUS" varchar(100) DEFAULT NULL,
  "PUBLIC_PRIV" varchar(10) DEFAULT NULL,
  "GENDER" varchar(2) DEFAULT NULL,
  "CLIENT_RS_TYP" varchar(50) DEFAULT NULL,
  "LEGAL_PARENT_ETY" varchar(100) DEFAULT NULL,
  "PRM_DOC_TYPECODE" varchar(50) DEFAULT NULL,
  "CR_DEPT_DESC" varchar(50) DEFAULT NULL,
  "LOCAL_LANGUAGE_NAME" varchar(200) DEFAULT NULL
)