离开tmc工作记录

来自ling
跳转至: 导航搜索

2018-12-20

  • 1:30~7:00mfa研究
  • 9~2:00 厦门轨道测试服务器百旺服务器没解决,106长度修改,开票间隔由5-->3
/*alter table T_TMS_DR_INVOICE_MAN_L modify inventory_item_qty FLOAT(20);;
alter table T_TMS_DR_INVOICE_MAN_L add inventory_item_qty_barkup FLOAT(20);

update T_TMS_DR_INVOICE_MAN_L set inventory_item_qty_barkup=inventory_item_qty;
select inventory_item_qty_barkup,inventory_item_qty from T_TMS_DR_INVOICE_MAN_L;


update T_TMS_DR_INVOICE_MAN_L set inventory_item_qty = null;


update T_TMS_DR_INVOICE_MAN_L set inventory_item_qty =inventory_item_qty_barkup;
*/

select t.TOTAL_AMOUNT,t.TOTAL_TAX,t.AMOUNT_TAX from T_TMS_VAT_DR_INV_POL_H t where t.TMS_VAT_DR_INV_POL_HID='a1a6fff4-546d-46b3-abc5-16d405fdebd2';
--a1a6fff4-546d-46b3-abc5-16d405fdebd2
select t.ACCTD_AMOUNT_CR,t.TMS_AMOUNT,t.TAX from T_TMS_VAT_DR_INV_POL_L t where t.TMS_VAT_DR_INV_POL_HID='a1a6fff4-546d-46b3-abc5-16d405fdebd2';

select t.ACCTD_AMOUNT_CR,t.VAT_AMOUNT,t.INVOICE_AMOUNT from T_TMS_DR_INVOICE_MAN_L t;

alter table T_TMS_DR_INVOICE_MAN_L add inventory_item_qty_barkup float(*);;
update T_TMS_DR_INVOICE_MAN_L set inventory_item_qty_barkup=inventory_item_qty;
update T_TMS_DR_INVOICE_MAN_L set inventory_item_qty = null;
alter table T_TMS_DR_INVOICE_MAN_L modify inventory_item_qty NUMBER(38,6);
update T_TMS_DR_INVOICE_MAN_L set inventory_item_qty =inventory_item_qty_barkup;

--
alter table T_TMS_VAT_DR_INV_POL_H add TOTAL_AMOUNT_BARKUP float(*);
alter table T_TMS_VAT_DR_INV_POL_H add TOTAL_TAX_BARKUP float(*);
alter table T_TMS_VAT_DR_INV_POL_H add AMOUNT_TAX_BARKUP float(*);

update T_TMS_VAT_DR_INV_POL_H set TOTAL_AMOUNT_BARKUP=TOTAL_AMOUNT;
update T_TMS_VAT_DR_INV_POL_H set TOTAL_TAX_BARKUP=TOTAL_TAX;
update T_TMS_VAT_DR_INV_POL_H set AMOUNT_TAX_BARKUP=AMOUNT_TAX;

update T_TMS_VAT_DR_INV_POL_H set TOTAL_AMOUNT = null;
update T_TMS_VAT_DR_INV_POL_H set TOTAL_TAX = null;
update T_TMS_VAT_DR_INV_POL_H set AMOUNT_TAX = null;

alter table T_TMS_VAT_DR_INV_POL_H modify TOTAL_AMOUNT NUMBER(38,6);
alter table T_TMS_VAT_DR_INV_POL_H modify TOTAL_TAX NUMBER(38,6);
alter table T_TMS_VAT_DR_INV_POL_H modify AMOUNT_TAX NUMBER(38,6);

update T_TMS_VAT_DR_INV_POL_H set TOTAL_AMOUNT =TOTAL_AMOUNT_BARKUP;
update T_TMS_VAT_DR_INV_POL_H set TOTAL_TAX =TOTAL_TAX_BARKUP;
update T_TMS_VAT_DR_INV_POL_H set AMOUNT_TAX =AMOUNT_TAX_BARKUP;

--
alter table T_TMS_VAT_DR_INV_POL_L add ACCTD_AMOUNT_CR_BARKUP float(*);
alter table T_TMS_VAT_DR_INV_POL_L add TMS_AMOUNT_TAX_BARKUP float(*);
alter table T_TMS_VAT_DR_INV_POL_L add TAX_BARKUP float(*);

update T_TMS_VAT_DR_INV_POL_L set ACCTD_AMOUNT_CR_BARKUP=ACCTD_AMOUNT_CR;
update T_TMS_VAT_DR_INV_POL_L set TMS_AMOUNT_TAX_BARKUP=TMS_AMOUNT;
update T_TMS_VAT_DR_INV_POL_L set TAX_BARKUP=TAX;

update T_TMS_VAT_DR_INV_POL_L set ACCTD_AMOUNT_CR = null;
update T_TMS_VAT_DR_INV_POL_L set TMS_AMOUNT = null;
update T_TMS_VAT_DR_INV_POL_L set TAX = null;

alter table T_TMS_VAT_DR_INV_POL_L modify ACCTD_AMOUNT_CR NUMBER(38,6);
alter table T_TMS_VAT_DR_INV_POL_L modify TMS_AMOUNT NUMBER(38,6);
alter table T_TMS_VAT_DR_INV_POL_L modify TAX NUMBER(38,6);

update T_TMS_VAT_DR_INV_POL_L set ACCTD_AMOUNT_CR =ACCTD_AMOUNT_CR_BARKUP;
update T_TMS_VAT_DR_INV_POL_L set TMS_AMOUNT =TMS_AMOUNT_TAX_BARKUP;
update T_TMS_VAT_DR_INV_POL_L set TAX =TAX_BARKUP;

--
alter table T_TMS_DR_INVOICE_MAN_L add ACCTD_AMOUNT_CR_BARKUP float(*);
alter table T_TMS_DR_INVOICE_MAN_L add VAT_AMOUNT_BARKUP float(*);
alter table T_TMS_DR_INVOICE_MAN_L add INVOICE_AMOUNT_BARKUP float(*);

update T_TMS_DR_INVOICE_MAN_L set ACCTD_AMOUNT_CR_BARKUP=ACCTD_AMOUNT_CR;
update T_TMS_DR_INVOICE_MAN_L set VAT_AMOUNT_BARKUP=VAT_AMOUNT;
update T_TMS_DR_INVOICE_MAN_L set INVOICE_AMOUNT_BARKUP=INVOICE_AMOUNT;

update T_TMS_DR_INVOICE_MAN_L set ACCTD_AMOUNT_CR = null;
update T_TMS_DR_INVOICE_MAN_L set VAT_AMOUNT = null;
update T_TMS_DR_INVOICE_MAN_L set INVOICE_AMOUNT = null;

alter table T_TMS_DR_INVOICE_MAN_L modify ACCTD_AMOUNT_CR NUMBER(38,6);
alter table T_TMS_DR_INVOICE_MAN_L modify VAT_AMOUNT NUMBER(38,6);
alter table T_TMS_DR_INVOICE_MAN_L modify INVOICE_AMOUNT NUMBER(38,6);

update T_TMS_DR_INVOICE_MAN_L set ACCTD_AMOUNT_CR =ACCTD_AMOUNT_CR_BARKUP;
update T_TMS_DR_INVOICE_MAN_L set VAT_AMOUNT =VAT_AMOUNT_BARKUP;
update T_TMS_DR_INVOICE_MAN_L set INVOICE_AMOUNT =INVOICE_AMOUNT_BARKUP;
  • 2-3点 DAC saba
  • 3-9点 个税信息导入 导入逻辑部分

2018-12-21

  • 9-2:30 个税信息导入,完成了前后端数据绑定.导入,查询,删除等
  • 2:30-3 厦门项目交接
  • 3-5 办公室需要搬到渝中区,需要清空桌子
  • 6-7:30 个税导入计算
  • 9:00-11:37 个税信息导入计算