*************************** 1. row *************************** Table: psa_taxhdr_cw Create Table: CREATE TABLE `psa_taxhdr_cw` ( `cmp_tp` char(2) DEFAULT NULL, `fac_tp` varchar(5) NOT NULL, `tax_no` varchar(13) NOT NULL, `cust_no` varchar(5) NOT NULL, `tax_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `sale_tp` varchar(5) DEFAULT NULL, `region_tp` varchar(5) NOT NULL, `cond_tp` varchar(5) DEFAULT NULL, `req_tp` varchar(5) DEFAULT NULL, `tax_exchg_yn` char(1) DEFAULT NULL, `exchg_calc_meth` varchar(5) DEFAULT NULL, `vat_calc_meth` varchar(5) DEFAULT NULL, `exchg_tp` varchar(5) DEFAULT NULL, `exchg_dt` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `zero_rate_yn` char(1) NOT NULL, `rev_issue_yn` char(1) NOT NULL, `ebill_trans_yn` char(1) DEFAULT NULL, `ebill_cmpt_yn` char(1) DEFAULT NULL, `ebill_state_cd` varchar(5) DEFAULT NULL, `ebill_no` varchar(24) DEFAULT NULL, `rec_fg` varchar(1) DEFAULT NULL, `ins_dt` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `ins_id` varchar(10) DEFAULT NULL, `last_dt` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `last_id` varchar(10) DEFAULT NULL, `vat_dcl_amount` decimal(22,6) DEFAULT NULL, `vat_dcl_money_tp` varchar(5) DEFAULT NULL, `vat_dcl_exchg_tp` varchar(5) DEFAULT NULL, `vat_dcl_exchg_dt` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `vat_dcl_exchg_rate` decimal(20,6) DEFAULT NULL, PRIMARY KEY (`fac_tp`,`tax_no`,`cust_no`,`tax_dt`) ) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='DSN=CWMSSQL;UID=starion;PWD=vmfhwjdtls' `TABLE_TYPE`='ODBC' `TABNAME`='psa_taxhdr'