小税种

来自ling
跳转至: 导航搜索

表结构变化

ALTER TABLE T_TMS_MIS_SD_RH ADD USERNAMED varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_SD_RH ADD USERNAMEC varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_SD_RH ADD USERNAMEB varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_SD_RH ADD USERD varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_SD_RH ADD USERC varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_SD_RH ADD USERB varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_SD_RH ADD READY_FOR_TRA varchar2(100) NULL;


ALTER TABLE t_BASE_DEPT ADD ORG_ID_DATA varchar2(100) NULL;
ALTER TABLE t_BASE_DEPT ADD ORG_CODE_DATA varchar2(100) NULL;
ALTER TABLE t_BASE_DEPT ADD ORGSECTOR_ID_DATA varchar2(100) NULL;
ALTER TABLE t_BASE_DEPT ADD ORGSECTOR_CODE_DATA varchar2(100) NULL;
ALTER TABLE t_BASE_DEPT ADD DELETEMAN varchar2(100) NULL;

ALTER TABLE t_BASE_DEPT ADD DELETED_FLAG varchar2(100) NULL;
ALTER TABLE t_BASE_DEPT ADD DELETEDTIME varchar2(200) NULL;
ALTER TABLE t_BASE_DEPT ADD BASE_COMPANY_ID_DATA varchar2(100) NULL;
ALTER TABLE t_BASE_DEPT ADD BASE_COMPANY_CODE_DATA varchar2(100) NULL;
ALTER TABLE t_BASE_DEPT ADD ORG_CODE_DATA varchar2(100) NULL;
ALTER TABLE t_BASE_DEPT ADD ORG_ID_DATA varchar2(100) NULL;
ALTER TABLE t_BASE_DEPT ADD ORG_NAME varchar2(100) NULL;
ALTER TABLE t_BASE_DEPT ADD UPDATEDATE varchar2(100) NULL;
ALTER TABLE t_BASE_DEPT ADD UPDATEMAN varchar2(100) NULL;


ALTER TABLE T_TMS_MIS_NRE_LVIT ADD ORG_ID_DATA varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_NRE_LVIT ADD ORG_CODE_DATA varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_NRE_LVIT ADD ORGSECTOR_ID_DATA varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_NRE_LVIT ADD ORGSECTOR_CODE_DATA varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_NRE_LVIT ADD DELETEMAN varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_NRE_LVIT ADD DELETED_FLAG varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_NRE_LVIT ADD DELETEDTIME date NULL;
ALTER TABLE T_TMS_MIS_NRE_LVIT ADD BASE_COMPANY_ID_DATA varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_NRE_LVIT ADD BASE_COMPANY_CODE_DATA varchar2(100) NULL;


ALTER TABLE T_TMS_MIS_DM_ACCO_BALA ADD ORG_NAME varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_DM_ACCO_BALA ADD ORG_CODE varchar2(100) NULL;


ALTER TABLE T_TMS_MIS_NRE_LVIT ADD ORG_ID_DATA varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_NRE_LVIT ADD ORG_CODE_DATA varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_NRE_LVIT ADD ORGSECTOR_ID_DATA varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_NRE_LVIT ADD ORGSECTOR_CODE_DATA varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_NRE_LVIT ADD DELETEMAN varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_NRE_LVIT ADD DELETED_FLAG varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_NRE_LVIT ADD DELETEDTIME date NULL;
ALTER TABLE T_TMS_MIS_NRE_LVIT ADD BASE_COMPANY_ID_DATA varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_NRE_LVIT ADD BASE_COMPANY_CODE_DATA varchar2(100) NULL;


ALTER TABLE T_TMS_MIS_SD_PAYABLE ADD ORG_NAME varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_SD_PAYABLE ADD ORG_CODE varchar2(100) NULL;
ALTER TABLE T_TMS_MIS_SD_PAYABLE ADD CONTRACT_CATEGORY_NAME varchar2(200) NULL;
ALTER TABLE T_TMS_MIS_SD_PAYABLE ADD CONTRACT_CATEGORY_CODE varchar2(200) NULL;

T_TMS_MIS_SD_TAX_PAYER
T_TAX_PAYABLE_ID
T_EXP_REGISTER_ID
T_RH_ID
T_RL_ID
T_TMS_MIS_PRO_RELIEF
T_TMS_MIS_RENT_RLF_REL
T_TMS_MIS_VAL_RELF_REL
T_TMS_MIS_LAND_TMP
T_TMS_TMS_DASHBOARD
T_TMS_MIS_SD_TAX_PAYER