json

[{"tableName":"SALE_ORDER","type":"UPDATE","listWhereParam":[{"column":"SALE_ORDER_ID","value":"572147392628425"}],"listParam":[{"column":"AMOUNT","value":"766500"},{"column":"CUSTOMER_ID","value":"6617"},{"column":"DISCOUNT","value":"0"},{"column":"IS_VISIT_PLAN","value":"1"},{"column":"TOTAL","value":"766500"},{"column":"UPDATE_DATE","value":"2016-09-15 16:27:32"},{"column":"UPDATE_USER","value":"HD0401"},{"column":"DELIVERY_DATE","value":"2016-09-16 08:00:00"},{"column":"PRIORITY","value":37},{"column":"DESCRIPTION","type":"NULL","value":""},{"column":"TYPE","value":1},{"column":"TOTAL_WEIGHT","value":6126},{"column":"ORDER_SOURCE","value":2},{"column":"APPROVED","value":0}]},{"tableName":"SALE_ORDER_DETAIL","type":"DELETE","listWhereParam":[{"column":"ORDER_DATE","value":"2016-09-15 14:58:04"},{"column":"SALE_ORDER_ID","value":"572147392628425"}]},{"tableName":"SALE_ORDER_PROMO_DETAIL","type":"DELETE","listWhereParam":[{"column":"ORDER_DATE","value":"2016-09-15 14:58:04"},{"column":"SALE_ORDER_ID","value":"572147392628425"}]},{"tableName":"SALE_ORDER_DETAIL","type":"INSERT","listParam":[{"column":"SALE_ORDER_DETAIL_ID","value":572147393165249},{"column":"PRODUCT_ID","value":74},{"column":"QUANTITY","value":3},{"column":"MAX_QUANTITY_FREE","value":0},{"column":"IS_FREE_ITEM","value":0},{"column":"AMOUNT","value":84000},{"column":"SALE_ORDER_ID","value":572147392628425},{"column":"PRICE","value":28000},{"column":"PRICE_NOT_VAT","value":25455},{"column":"PRICE_ID","value":161},{"column":"CREATE_USER","value":"HD0401"},{"column":"UPDATE_USER","value":"HD0401"},{"column":"SHOP_ID","value":278},{"column":"STAFF_ID","value":103},{"column":"CREATE_DATE","value":"2016-09-15 14:58:04"},{"column":"ORDER_DATE","value":"2016-09-15 14:58:04"},{"column":"UPDATE_DATE","value":"2016-09-15 16:27:32"},{"column":"TOTAL_WEIGHT","value":1026},{"column":"VAT","value":10},{"column":"IS_PACKAGE","value":0}]},{"tableName":"SALE_ORDER_DETAIL","type":"INSERT","listParam":[{"column":"SALE_ORDER_DETAIL_ID","value":572147393165250},{"column":"PRODUCT_ID","value":95},{"column":"QUANTITY","value":5},{"column":"MAX_QUANTITY_FREE","value":0},{"column":"IS_FREE_ITEM","value":0},{"column":"AMOUNT","value":300000},{"column":"SALE_ORDER_ID","value":572147392628425},{"column":"PRICE","value":60000},{"column":"PRICE_NOT_VAT","value":54545},{"column":"PRICE_ID","value":524},{"column":"CREATE_USER","value":"HD0401"},{"column":"UPDATE_USER","value":"HD0401"},{"column":"SHOP_ID","value":278},{"column":"STAFF_ID","value":103},{"column":"CREATE_DATE","value":"2016-09-15 14:58:04"},{"column":"ORDER_DATE","value":"2016-09-15 14:58:04"},{"column":"UPDATE_DATE","value":"2016-09-15 16:27:32"},{"column":"TOTAL_WEIGHT","value":2100},{"column":"VAT","value":10},{"column":"IS_PACKAGE","value":0}]},{"tableName":"SALE_ORDER_DETAIL","type":"INSERT","listParam":[{"column":"SALE_ORDER_DETAIL_ID","value":572147393165251},{"column":"PRODUCT_ID","value":96},{"column":"QUANTITY","value":5},{"column":"MAX_QUANTITY_FREE","value":0},{"column":"IS_FREE_ITEM","value":0},{"column":"AMOUNT","value":300000},{"column":"SALE_ORDER_ID","value":572147392628425},{"column":"PRICE","value":60000},{"column":"PRICE_NOT_VAT","value":54545},{"column":"PRICE_ID","value":525},{"column":"CREATE_USER","value":"HD0401"},{"column":"UPDATE_USER","value":"HD0401"},{"column":"SHOP_ID","value":278},{"column":"STAFF_ID","value":103},{"column":"CREATE_DATE","value":"2016-09-15 14:58:04"},{"column":"ORDER_DATE","value":"2016-09-15 14:58:04"},{"column":"UPDATE_DATE","value":"2016-09-15 16:27:32"},{"column":"TOTAL_WEIGHT","value":2100},{"column":"VAT","value":10},{"column":"IS_PACKAGE","value":0}]},{"tableName":"SALE_ORDER_DETAIL","type":"INSERT","listParam":[{"column":"SALE_ORDER_DETAIL_ID","value":572147393165252},{"column":"PRODUCT_ID","value":65},{"column":"QUANTITY","value":5},{"column":"MAX_QUANTITY_FREE","value":0},{"column":"IS_FREE_ITEM","value":0},{"column":"AMOUNT","value":82500},{"column":"SALE_ORDER_ID","value":572147392628425},{"column":"PRICE","value":16500},{"column":"PRICE_NOT_VAT","value":15000},{"column":"PRICE_ID","value":65},{"column":"CREATE_USER","value":"HD0401"},{"column":"UPDATE_USER","value":"HD0401"},{"column":"SHOP_ID","value":278},{"column":"STAFF_ID","value":103},{"column":"CREATE_DATE","value":"2016-09-15 14:58:04"},{"column":"ORDER_DATE","value":"2016-09-15 14:58:04"},{"column":"UPDATE_DATE","value":"2016-09-15 16:27:32"},{"column":"TOTAL_WEIGHT","value":900},{"column":"VAT","value":10},{"column":"IS_PACKAGE","value":0}]},{"tableName":"SALE_ORDER_PROMO_DETAIL","type":"INSERT","listParam":[{"column":"SALE_ORDER_PROMO_DETAIL_ID","value":572147393165255},{"column":"STAFF_ID","value":103},{"column":"ROUTING_ID","value":53},{"column":"SALE_ORDER_ID","value":572147392628425},{"column":"PRODUCT_ID","value":74},{"column":"QUANTITY","value":3},{"column":"QUANTITY_MAX","value":0},{"column":"DISCOUNT_AMOUNT","value":0},{"column":"DISCOUNT_AMOUNT_MAX","value":0},{"column":"IS_FREE_ITEM","value":0},{"column":"AMOUNT","value":84000},{"column":"PROGRAM_CODE","value":""},{"column":"MUTIPLE","value":0},{"column":"SHOP_ID","value":278},{"column":"ORDER_DATE","value":"2016-09-15 14:58:04"},{"column":"CREATE_DATE","value":"2016-09-15 14:58:04"},{"column":"CREATE_USER","value":"HD0401"}]},{"tableName":"SALE_ORDER_PROMO_DETAIL","type":"INSERT","listParam":[{"column":"SALE_ORDER_PROMO_DETAIL_ID","value":572147393165256},{"column":"STAFF_ID","value":103},{"column":"ROUTING_ID","value":53},{"column":"SALE_ORDER_ID","value":572147392628425},{"column":"PRODUCT_ID","value":95},{"column":"QUANTITY","value":5},{"column":"QUANTITY_MAX","value":0},{"column":"DISCOUNT_AMOUNT","value":0},{"column":"DISCOUNT_AMOUNT_MAX","value":0},{"column":"IS_FREE_ITEM","value":0},{"column":"AMOUNT","value":300000},{"column":"PROGRAM_CODE","value":""},{"column":"MUTIPLE","value":0},{"column":"SHOP_ID","value":278},{"column":"ORDER_DATE","value":"2016-09-15 14:58:04"},{"column":"CREATE_DATE","value":"2016-09-15 14:58:04"},{"column":"CREATE_USER","value":"HD0401"}]},{"tableName":"SALE_ORDER_PROMO_DETAIL","type":"INSERT","listParam":[{"column":"SALE_ORDER_PROMO_DETAIL_ID","value":572147393165257},{"column":"STAFF_ID","value":103},{"column":"ROUTING_ID","value":53},{"column":"SALE_ORDER_ID","value":572147392628425},{"column":"PRODUCT_ID","value":96},{"column":"QUANTITY","value":5},{"column":"QUANTITY_MAX","value":0},{"column":"DISCOUNT_AMOUNT","value":0},{"column":"DISCOUNT_AMOUNT_MAX","value":0},{"column":"IS_FREE_ITEM","value":0},{"column":"AMOUNT","value":300000},{"column":"PROGRAM_CODE","value":""},{"column":"MUTIPLE","value":0},{"column":"SHOP_ID","value":278},{"column":"ORDER_DATE","value":"2016-09-15 14:58:04"},{"column":"CREATE_DATE","value":"2016-09-15 14:58:04"},{"column":"CREATE_USER","value":"HD0401"}]},{"tableName":"SALE_ORDER_PROMO_DETAIL","type":"INSERT","listParam":[{"column":"SALE_ORDER_PROMO_DETAIL_ID","value":572147393165258},{"column":"STAFF_ID","value":103},{"column":"ROUTING_ID","value":53},{"column":"SALE_ORDER_ID","value":572147392628425},{"column":"PRODUCT_ID","value":65},{"column":"QUANTITY","value":5},{"column":"QUANTITY_MAX","value":0},{"column":"DISCOUNT_AMOUNT","value":0},{"column":"DISCOUNT_AMOUNT_MAX","value":0},{"column":"IS_FREE_ITEM","value":0},{"column":"AMOUNT","value":82500},{"column":"PROGRAM_CODE","value":""},{"column":"MUTIPLE","value":0},{"column":"SHOP_ID","value":278},{"column":"ORDER_DATE","value":"2016-09-15 14:58:04"},{"column":"CREATE_DATE","value":"2016-09-15 14:58:04"},{"column":"CREATE_USER","value":"HD0401"}]},{"tableName":"STOCK_TOTAL","type":"UPDATE","listWhereParam":[{"column":"OBJECT_ID","value":278},{"column":"OBJECT_TYPE","value":1},{"column":"PRODUCT_ID","value":74}],"listParam":[{"column":"AVAILABLE_QUANTITY","type":"OPERATION","value":"*-3"}]},{"tableName":"STOCK_TOTAL","type":"UPDATE","listWhereParam":[{"column":"OBJECT_ID","value":278},{"column":"OBJECT_TYPE","value":1},{"column":"PRODUCT_ID","value":95}],"listParam":[{"column":"AVAILABLE_QUANTITY","type":"OPERATION","value":"*-5"}]},{"tableName":"STOCK_TOTAL","type":"UPDATE","listWhereParam":[{"column":"OBJECT_ID","value":278},{"column":"OBJECT_TYPE","value":1},{"column":"PRODUCT_ID","value":96}],"listParam":[{"column":"AVAILABLE_QUANTITY","type":"OPERATION","value":"*-5"}]},{"tableName":"STOCK_TOTAL","type":"UPDATE","listWhereParam":[{"column":"OBJECT_ID","value":278},{"column":"OBJECT_TYPE","value":1},{"column":"PRODUCT_ID","value":65}],"listParam":[{"column":"AVAILABLE_QUANTITY","type":"OPERATION","value":"*-5"}]},{"tableName":"CUSTOMER","type":"UPDATE","listWhereParam":[{"column":"CUSTOMER_ID","value":6617}],"listParam":[{"column":"LAST_ORDER","value":"2016-09-15 16:27:32"}]},{"tableName":"STAFF_CUSTOMER","type":"INSERTORUPDATE","listWhereParam":[{"column":"CUSTOMER_ID","value":6617},{"column":"STAFF_ID","value":103}],"listParam":[{"column":"STAFF_CUSTOMER_ID","key":"ISPK","value":125144669335754},{"column":"LAST_ORDER","value":"2016-09-15 16:27:32"},{"column":"CUSTOMER_ID","value":6617},{"column":"STAFF_ID","value":103}]},{"tableName":"DISPLAY_CUSTOMER_MAP","type":"UPDATE","listWhereParam":[{"column":"DISPLAY_CUSTOMER_MAP_ID","value":164147339670092}],"listParam":[{"column":"DISPLAY_PROGRAM_LEVEL_ID","value":755},{"column":"STATUS","value":3},{"column":"UPDATE_DATE"},{"column":"UPDATE_USER"},{"column":"REGISTER_DATE","value":"2016-09-15 16:27:32"},{"column":"SALE_ORDER_ID","value":572147392628425}]},{"tableName":"DISPLAY_CUSTOMER_MAP","type":"INSERT","listParam":[{"column":"DISPLAY_CUSTOMER_MAP_ID","value":572147393165261},{"column":"DISPLAY_PROGRAM_LEVEL_ID","value":561},{"column":"STATUS","value":3},{"column":"CREATE_DATE","value":"2016-09-15 16:27:32"},{"column":"CREATE_USER","value":"HD0401"},{"column":"CUSTOMER_ID","value":6617},{"column":"SHOP_ID","value":"278"},{"column":"STAFF_ID","value":103},{"column":"REGISTER_DATE","value":"2016-09-15 16:27:32"},{"column":"DISPLAY_PROGRAM_ID","value":689},{"column":"SALE_ORDER_ID","value":572147392628425},{"column":"CREATE_USER_ID","value":103}]}]