ALTER TABLE xray_items MODIFY COLUMN `doctor_fee` double(15,3)
ALTER TABLE web_conf MODIFY COLUMN `header` varchar(1)
ALTER TABLE visit_pttype_change MODIFY COLUMN `old_paid_amount` double(15,3)
ALTER TABLE village_student_vaccine MODIFY COLUMN `provider_hospcode` char(5)
ALTER TABLE village MODIFY COLUMN `address_id` char(6)
ALTER TABLE stock_snapshot_detail MODIFY COLUMN `total_price` double(15,5)
ALTER TABLE stock_po_detail MODIFY COLUMN `stock_po_total` double(15,5)
ALTER TABLE stock_po_detail MODIFY COLUMN `stock_po_ref_price` double(15,5)
ALTER TABLE stock_po_detail MODIFY COLUMN `stock_po_price` double(15,5)
ALTER TABLE stock_item MODIFY COLUMN `dummy_left_price` double(15,3)
ALTER TABLE report_sks MODIFY COLUMN `page_amount` double(15,3)
ALTER TABLE report_sks MODIFY COLUMN `total_sum` double(15,3)
ALTER TABLE report_sks MODIFY COLUMN `rcpt_sum` double(15,3)
ALTER TABLE report_sks MODIFY COLUMN `rcpt03` double(15,3)
ALTER TABLE report_sks MODIFY COLUMN `rcpt01` double(15,3)
ALTER TABLE rcpt_debt_cancel MODIFY COLUMN `total_amount` double(15,3)
ALTER TABLE rcpt_debt_cancel MODIFY COLUMN `discount_amount` double(15,3)
ALTER TABLE rcpt_debt_cancel MODIFY COLUMN `amount` double(15,3)
ALTER TABLE rcpt_current_detail MODIFY COLUMN `total_amount` double(15,3)
ALTER TABLE rcpt_current_detail MODIFY COLUMN `discount` double(15,3)
ALTER TABLE rcpt_current_detail MODIFY COLUMN `amount` double(15,3)
ALTER TABLE rcpt_current MODIFY COLUMN `total_amount` double(15,3)
ALTER TABLE rcpt_current MODIFY COLUMN `discount_amount` double(15,3)
ALTER TABLE rcpt_current MODIFY COLUMN `amount` double(15,3)
ALTER TABLE rcpt_credit_detail MODIFY COLUMN `total_amount` double(15,3)
ALTER TABLE rcpt_credit MODIFY COLUMN `total_amount` double(15,3)
ALTER TABLE rcpt_credit MODIFY COLUMN `discount` double(15,3)
ALTER TABLE physic_list MODIFY COLUMN `price` double(15,3)
ALTER TABLE physic_items MODIFY COLUMN `price` double(15,3)
ALTER TABLE person_women_service MODIFY COLUMN `provider_hospcode` char(5)
ALTER TABLE person_wbc_service MODIFY COLUMN `provider_hospcode` char(5)
ALTER TABLE person_labour MODIFY COLUMN `thyroid_test_hospcode` char(5)
ALTER TABLE person_labour MODIFY COLUMN `labour_hospcode` char(5)
ALTER TABLE person_epi_vaccine MODIFY COLUMN `provider_hospcode` char(5)
ALTER TABLE person_duty MODIFY COLUMN `hcis_code` varchar(2)
ALTER TABLE person_card_request MODIFY COLUMN `hospmain` char(5)
ALTER TABLE person_card_request MODIFY COLUMN `hospcode` char(5)
ALTER TABLE person_card_request MODIFY COLUMN `cid` char(13)
ALTER TABLE person_anc_service MODIFY COLUMN `provider_hospcode` char(5)
ALTER TABLE person_anc MODIFY COLUMN `labour_hospcode` char(5)
ALTER TABLE patient_relation_address MODIFY COLUMN `po_code` char(5)
ALTER TABLE patient_pttype MODIFY COLUMN `hospsub` char(5)
ALTER TABLE patient_pttype MODIFY COLUMN `hospmain` char(5)
ALTER TABLE patient_hospital_refer MODIFY COLUMN `service_price` double(15,3)
ALTER TABLE ovst_sticker MODIFY COLUMN `depcode` varchar(3)
ALTER TABLE operation_screen_in MODIFY COLUMN `bw` double(15,3)
ALTER TABLE operation_anes MODIFY COLUMN `df_price` double(15,3)
ALTER TABLE lab_items MODIFY COLUMN `service_cost` double(15,3)
ALTER TABLE ipt_nurse_oper MODIFY COLUMN `oper_price` double(15,3)
ALTER TABLE ipt_labour_medication MODIFY COLUMN `price` double(15,3)
ALTER TABLE ipt_labour_child_med MODIFY COLUMN `price` double(15,3)
ALTER TABLE ipt_labour_child MODIFY COLUMN `temperature` double(15,3)
ALTER TABLE ipd_refer MODIFY COLUMN `refer_to_hospcode` char(5)
ALTER TABLE ipd_df MODIFY COLUMN `price` double(15,3)
ALTER TABLE finger_template MODIFY COLUMN `cid` char(13)
ALTER TABLE dtmain_save MODIFY COLUMN `fee` double(15,3)
ALTER TABLE drugitems_usage MODIFY COLUMN `icode` char(7)
ALTER TABLE drugitems_ingredient MODIFY COLUMN `icode` char(7)
ALTER TABLE doctor_fee_list MODIFY COLUMN `approve_amount` double(15,3)
ALTER TABLE doctor_fee_list MODIFY COLUMN `original_fee` double(15,3)
ALTER TABLE doctor_df_rate MODIFY COLUMN `price` double(15,3)
ALTER TABLE doctor_dep_dlg_list MODIFY COLUMN `depcode` varchar(3)
ALTER TABLE detail_account MODIFY COLUMN `mouth` varchar(2)
ALTER TABLE company_contact_discount MODIFY COLUMN `discount` double(15,3)
ALTER TABLE blood_request_item MODIFY COLUMN `icode` char(7)
ALTER TABLE blood_detail_type MODIFY COLUMN `icode` char(7)
ALTER TABLE bedno MODIFY COLUMN `nurse_charge_price` double(15,3)
ALTER TABLE bedno MODIFY COLUMN `food_charge_price` double(15,3)
ALTER TABLE bedno MODIFY COLUMN `room_charge_price` double(15,3)
ALTER TABLE bed_charge_pttype MODIFY COLUMN `icode` char(7)
ALTER TABLE ar_receive_head MODIFY COLUMN `total_amount` double(15,3)
ALTER TABLE ar_receive_detail MODIFY COLUMN `amount` double(15,3)
ALTER TABLE ar_original_detail MODIFY COLUMN `total_amount` double(15,3)
ALTER TABLE ar_original_detail MODIFY COLUMN `discount` double(15,3)
ALTER TABLE ar_original_detail MODIFY COLUMN `amount` double(15,3)
ALTER TABLE ar_head MODIFY COLUMN `max_debt_amount` double(15,3)
ALTER TABLE ar_head MODIFY COLUMN `hospsub` char(5)
ALTER TABLE ar_head MODIFY COLUMN `hospmain` char(5)
ALTER TABLE ar_head MODIFY COLUMN `original_amount` double(15,3)
ALTER TABLE ar_head MODIFY COLUMN `debit_adjust_amount` double(15,3)
ALTER TABLE ar_head MODIFY COLUMN `credit_adjust_amount` double(15,3)
ALTER TABLE ar_head MODIFY COLUMN `receive_money_total` double(15,3)
ALTER TABLE ar_head MODIFY COLUMN `total_amount` double(15,3)
ALTER TABLE ar_head MODIFY COLUMN `discount_amount` double(15,3)
ALTER TABLE ar_head MODIFY COLUMN `debt_amount` double(15,3)
ALTER TABLE ar_detail MODIFY COLUMN `total_amount` double(15,3)
ALTER TABLE ar_detail MODIFY COLUMN `discount` double(15,3)
ALTER TABLE ar_detail MODIFY COLUMN `amount` double(15,3)
ALTER TABLE ar_adjust_head MODIFY COLUMN `adjust_amount` double(15,3)
ALTER TABLE ar_adjust MODIFY COLUMN `amount` double(15,3)
หัวข้อ: 3.51.8.10 การเปลี่ยนแปลงที่พบเบื้องต้น (อ่าน 5163 ครั้ง)