$PBExportHeader$f_init_tntblinfo_2.srf global type f_init_tntblinfo_2 from function_object end type forward prototypes global function integer f_init_tntblinfo_2 () end prototypes global function integer f_init_tntblinfo_2 ();//f_init_tntblinfo //tabletype: //-1 -特殊表(不执行update insert) //0- 必须全部转移的表 //1- 定义数据表 //2- 业务数据表 //3- 根据附加筛选条件决定上传下传的数据的表 //4- 工资财务 //5- 消息 //6-价格 s_tntblinfo[100].Table_name = 'u_spt_price_MX' s_tntblinfo[100].Table_dscrp = '供应商报价明细表' s_tntblinfo[100].Sc_id_name = 'sptid' s_tntblinfo[100].Indcolumn_name = 'mtrlid' s_tntblinfo[100].thrIndcolumn_name = 'Opdate' s_tntblinfo[100].fouindcolumn_name = '' s_tntblinfo[100].clearstr = 'truncate table u_spt_price_MX ' s_tntblinfo[100].tabletype = 6 s_tntblinfo[101].Table_name = 'u_spt_price_change' s_tntblinfo[101].Table_dscrp = '调价单表' s_tntblinfo[101].Sc_id_name = 'billid' s_tntblinfo[101].Indcolumn_name = '' s_tntblinfo[101].thrIndcolumn_name = '' s_tntblinfo[101].fouindcolumn_name = '' s_tntblinfo[101].clearstr = 'truncate table u_spt_price_change ' s_tntblinfo[101].tabletype = 2 s_tntblinfo[102].Table_name = 'u_static' s_tntblinfo[102].Table_dscrp = '进出原因定义' s_tntblinfo[102].Sc_id_name = 'staticid' s_tntblinfo[102].Indcolumn_name = '' s_tntblinfo[102].thrIndcolumn_name = '' s_tntblinfo[102].fouindcolumn_name = '' s_tntblinfo[102].clearstr = 'truncate table u_static ' s_tntblinfo[102].tabletype = 1 s_tntblinfo[103].Table_name = 'u_storage' s_tntblinfo[103].Table_dscrp = '仓库设定' s_tntblinfo[103].Sc_id_name = 'scid' s_tntblinfo[103].Indcolumn_name = 'storageid' s_tntblinfo[103].thrIndcolumn_name = '' s_tntblinfo[103].fouindcolumn_name = '' s_tntblinfo[103].clearstr = 'truncate table u_storage ' s_tntblinfo[103].tabletype = 1 s_tntblinfo[104].Table_name = 'u_user' s_tntblinfo[104].Table_dscrp = '用户表' s_tntblinfo[104].Sc_id_name = 'scid' s_tntblinfo[104].Indcolumn_name = 'empid' s_tntblinfo[104].thrIndcolumn_name = '' s_tntblinfo[104].fouindcolumn_name = '' s_tntblinfo[104].clearstr = 'delete from u_user where empid <> 0' s_tntblinfo[104].tabletype = 1 s_tntblinfo[105].Table_name = 'u_usergroup' s_tntblinfo[105].Table_dscrp = '操作员组设定' s_tntblinfo[105].Sc_id_name = 'scid' s_tntblinfo[105].Indcolumn_name = 'Empid' s_tntblinfo[105].thrIndcolumn_name = 'usergroupid' s_tntblinfo[105].fouindcolumn_name = 'Grouptype' s_tntblinfo[105].clearstr = 'truncate table u_usergroup ' s_tntblinfo[105].tabletype = 1 s_tntblinfo[106].Table_name = 'u_usergroupdef' s_tntblinfo[106].Table_dscrp = '操作员组设定' s_tntblinfo[106].Sc_id_name = 'scid' s_tntblinfo[106].Indcolumn_name = 'usergroupid' s_tntblinfo[106].thrIndcolumn_name = '' s_tntblinfo[106].fouindcolumn_name = '' s_tntblinfo[106].clearstr = 'truncate table u_usergroupdef ' s_tntblinfo[106].tabletype = 1 s_tntblinfo[107].Table_name = 'u_warebalc' s_tntblinfo[107].Table_dscrp = '结存表' s_tntblinfo[107].Sc_id_name = 'scid' s_tntblinfo[107].Indcolumn_name = 'mtrlid' s_tntblinfo[107].thrIndcolumn_name = 'Storageid' s_tntblinfo[107].fouindcolumn_name = 'status' s_tntblinfo[107].fifindcolumn_name = 'woodcode' s_tntblinfo[107].sixindcolumn_name = 'pcode' s_tntblinfo[107].sevindcolumn_name = 'balcdateint' s_tntblinfo[107].clearstr = 'truncate table u_warebalc ' s_tntblinfo[107].tabletype = 2 s_tntblinfo[108].Table_name = 'u_warepdb' s_tntblinfo[108].Table_dscrp = '盘点表' s_tntblinfo[108].Sc_id_name = 'storageid' s_tntblinfo[108].Indcolumn_name = 'pdbdate' s_tntblinfo[108].thrIndcolumn_name = 'mtrlid' s_tntblinfo[108].fouindcolumn_name = 'status' s_tntblinfo[108].fifindcolumn_name = 'plancode' s_tntblinfo[108].sixindcolumn_name = 'Sptid' s_tntblinfo[108].sevindcolumn_name = 'woodcode' s_tntblinfo[108].eigindcolumn_name = 'pcode' s_tntblinfo[108].clearstr = 'truncate table u_warepdb ' s_tntblinfo[108].tabletype = 2 s_tntblinfo[109].Table_name = 'u_quote' s_tntblinfo[109].Table_dscrp = '报价单表' s_tntblinfo[109].Sc_id_name = 'scid' s_tntblinfo[109].Indcolumn_name = 'quoteid' s_tntblinfo[109].thrIndcolumn_name = '' s_tntblinfo[109].fouindcolumn_name = '' s_tntblinfo[109].clearstr = 'truncate table u_quote ' s_tntblinfo[109].tabletype = 2 s_tntblinfo[110].Table_name = 'u_quotemx' s_tntblinfo[110].Table_dscrp = '报价单表' s_tntblinfo[110].Sc_id_name = 'scid' s_tntblinfo[110].Indcolumn_name = 'quoteid' s_tntblinfo[110].thrIndcolumn_name = 'printid' s_tntblinfo[110].fouindcolumn_name = '' s_tntblinfo[110].clearstr = 'truncate table u_quotemx ' s_tntblinfo[110].tabletype = 2 s_tntblinfo[111].Table_name = 'u_OutWaremovemx' s_tntblinfo[111].Table_dscrp = '仓库调拨单明细' s_tntblinfo[111].Sc_id_name = 'scid' s_tntblinfo[111].Indcolumn_name = 'outwareid' s_tntblinfo[111].thrIndcolumn_name = 'MtrlWareID' s_tntblinfo[111].fouindcolumn_name = '' s_tntblinfo[111].clearstr = 'truncate table u_OutWaremovemx ' s_tntblinfo[111].tabletype = 2 s_tntblinfo[112].Table_name = 'u_updatecost' s_tntblinfo[112].Table_dscrp = '仓库成本调整单' s_tntblinfo[112].Sc_id_name = 'scid' s_tntblinfo[112].Indcolumn_name = 'wareid' s_tntblinfo[112].thrIndcolumn_name = '' s_tntblinfo[112].fouindcolumn_name = '' s_tntblinfo[112].clearstr = 'truncate table u_updatecost ' s_tntblinfo[112].tabletype = 1 s_tntblinfo[113].Table_name = 'u_updatecostmx' s_tntblinfo[113].Table_dscrp = '仓库成本调整单明细表' s_tntblinfo[113].Sc_id_name = 'scid' s_tntblinfo[113].Indcolumn_name = 'wareid' s_tntblinfo[113].thrIndcolumn_name = 'printid' s_tntblinfo[113].fouindcolumn_name = '' s_tntblinfo[113].clearstr = 'truncate table u_updatecostmx ' s_tntblinfo[113].tabletype = 1 s_tntblinfo[114].Table_name = 'u_workgroup' s_tntblinfo[114].Table_dscrp = '工作组设定' s_tntblinfo[114].Sc_id_name = 'workgroupid' s_tntblinfo[114].Indcolumn_name = '' s_tntblinfo[114].thrIndcolumn_name = '' s_tntblinfo[114].fouindcolumn_name = '' s_tntblinfo[114].clearstr = 'truncate table u_workgroup ' s_tntblinfo[114].tabletype = 1 //s_tntblinfo[115].Table_name = 'u_workgroupmx' //s_tntblinfo[115].Table_dscrp = '工作组人员设定' //s_tntblinfo[115].Sc_id_name = 'workgroupid' //s_tntblinfo[115].Indcolumn_name = 'empid' //s_tntblinfo[115].thrIndcolumn_name = '' //s_tntblinfo[115].fouindcolumn_name = '' //s_tntblinfo[115].tabletype = 1 //s_tntblinfo[116].Table_name = 'u_freeday_def' //s_tntblinfo[116].Table_dscrp = '节假日设定' //s_tntblinfo[116].Sc_id_name = 'Freeid' //s_tntblinfo[116].Indcolumn_name = '' //s_tntblinfo[116].thrIndcolumn_name = '' //s_tntblinfo[116].fouindcolumn_name = '' //s_tntblinfo[116].tabletype = 1 // //s_tntblinfo[117].Table_name = 'u_timeclockdef' //s_tntblinfo[117].Table_dscrp = '考勤机设定' //s_tntblinfo[117].Sc_id_name = 'clockid' //s_tntblinfo[117].Indcolumn_name = '' //s_tntblinfo[117].thrIndcolumn_name = '' //s_tntblinfo[117].fouindcolumn_name = '' //s_tntblinfo[117].tabletype = 1 // //s_tntblinfo[118].Table_name = 'u_workday_def' //s_tntblinfo[118].Table_dscrp = '人员排班' //s_tntblinfo[118].Sc_id_name = 'Wagemth' //s_tntblinfo[118].Indcolumn_name = 'Empid' //s_tntblinfo[118].thrIndcolumn_name = 'typeid' //s_tntblinfo[118].fouindcolumn_name = 'Startdate' //s_tntblinfo[118].tabletype = 1 //s_tntblinfo[119].Table_name = 'u_scwg_taskwork' //s_tntblinfo[119].Table_dscrp = '工作组计件单' //s_tntblinfo[119].Sc_id_name = 'wageid' //s_tntblinfo[119].Indcolumn_name = 'workgroupid' //s_tntblinfo[119].thrIndcolumn_name = 'proid' //s_tntblinfo[119].fouindcolumn_name = 'wagemth' //s_tntblinfo[119].clearstr = 'truncate table u_scwg_taskwork ' //s_tntblinfo[119].tabletype = 2 // //s_tntblinfo[120].Table_name = 'u_scwg_taskwork_money' //s_tntblinfo[120].Table_dscrp = '工作组计件单工资分配' //s_tntblinfo[120].Sc_id_name = 'wageid' //s_tntblinfo[120].Indcolumn_name = 'workgroupid' //s_tntblinfo[120].thrIndcolumn_name = 'empid' //s_tntblinfo[120].fouindcolumn_name = 'wagemth' //s_tntblinfo[120].clearstr = 'truncate table u_scwg_taskwork_money ' //s_tntblinfo[120].tabletype = 2 //s_tntblinfo[121].Table_name = 'u_attendance' //s_tntblinfo[121].Table_dscrp = '打卡明细' //s_tntblinfo[121].Sc_id_name = 'starttime' //s_tntblinfo[121].Indcolumn_name = 'empid' //s_tntblinfo[121].thrIndcolumn_name = '' //s_tntblinfo[121].fouindcolumn_name = '' //s_tntblinfo[121].clearstr = 'truncate table u_attendance ' //s_tntblinfo[121].tabletype = 2 // //s_tntblinfo[122].Table_name = 'u_dayattendance' //s_tntblinfo[122].Table_dscrp = '考勤明细' //s_tntblinfo[122].Sc_id_name = 'empid' //s_tntblinfo[122].Indcolumn_name = 'atdateint' //s_tntblinfo[122].thrIndcolumn_name = 'classmxID' //s_tntblinfo[122].fouindcolumn_name = '' //s_tntblinfo[122].clearstr = 'truncate table u_dayattendance ' //s_tntblinfo[122].tabletype = 2 //s_tntblinfo[123].Table_name = 'u_sc_abnormity_bill_item' //s_tntblinfo[123].Table_dscrp = '返工返修项目' //s_tntblinfo[123].Sc_id_name = 'itemid' //s_tntblinfo[123].Indcolumn_name = '' //s_tntblinfo[123].thrIndcolumn_name = '' //s_tntblinfo[123].fouindcolumn_name = '' //s_tntblinfo[123].tabletype = 1 //s_tntblinfo[124].Table_name = 'u_spt_wfjg' //s_tntblinfo[124].Table_dscrp = '加工费分摊单表' //s_tntblinfo[124].Sc_id_name = 'scid' //s_tntblinfo[124].Indcolumn_name = 'billid' //s_tntblinfo[124].thrIndcolumn_name = '' //s_tntblinfo[124].fouindcolumn_name = '' //s_tntblinfo[124].clearstr = 'truncate table u_spt_wfjg ' //s_tntblinfo[124].tabletype = 2 // //s_tntblinfo[125].Table_name = 'u_spt_wfjgmx' //s_tntblinfo[125].Table_dscrp = '加工费分摊单明细表' //s_tntblinfo[125].Sc_id_name = 'scid' //s_tntblinfo[125].Indcolumn_name = 'billid' //s_tntblinfo[125].thrIndcolumn_name = 'printid' //s_tntblinfo[125].fouindcolumn_name = '' //s_tntblinfo[125].clearstr = 'truncate table u_spt_wfjgmx ' //s_tntblinfo[125].tabletype = 2 s_tntblinfo[126].Table_name = 'u_order_wfjgMx_out' s_tntblinfo[126].Table_dscrp = '外加工计划发出明细表' s_tntblinfo[126].Sc_id_name = 'scid' s_tntblinfo[126].Indcolumn_name = 'wfjgID' s_tntblinfo[126].thrIndcolumn_name = 'printid' s_tntblinfo[126].fouindcolumn_name = '' s_tntblinfo[126].clearstr = 'truncate table u_order_wfjgMx_out ' s_tntblinfo[126].tabletype = 2 s_tntblinfo[127].Table_name = 'u_invoice' s_tntblinfo[127].Table_dscrp = '发票表' s_tntblinfo[127].Sc_id_name = 'scid' s_tntblinfo[127].Indcolumn_name = 'invoiceid' s_tntblinfo[127].thrIndcolumn_name = '' s_tntblinfo[127].fouindcolumn_name = '' s_tntblinfo[127].clearstr = 'truncate table u_invoice ' s_tntblinfo[127].tabletype = 2 s_tntblinfo[128].Table_name = 'u_invoicemx' s_tntblinfo[128].Table_dscrp = '发票明细表' s_tntblinfo[128].Sc_id_name = 'scid' s_tntblinfo[128].Indcolumn_name = 'invoiceid' s_tntblinfo[128].thrIndcolumn_name = 'printid' s_tntblinfo[128].fouindcolumn_name = '' s_tntblinfo[128].clearstr = 'truncate table u_invoicemx ' s_tntblinfo[128].tabletype = 2 s_tntblinfo[129].Table_name = 'u_giveback' s_tntblinfo[129].Table_dscrp = '返利单表' s_tntblinfo[129].Sc_id_name = 'scid' s_tntblinfo[129].Indcolumn_name = 'givebackid' s_tntblinfo[129].thrIndcolumn_name = '' s_tntblinfo[129].fouindcolumn_name = '' s_tntblinfo[129].clearstr = 'truncate table u_giveback ' s_tntblinfo[129].tabletype = 2 s_tntblinfo[130].Table_name = 'u_givebackmx' s_tntblinfo[130].Table_dscrp = '返利单明细表' s_tntblinfo[130].Sc_id_name = 'scid' s_tntblinfo[130].Indcolumn_name = 'givebackid' s_tntblinfo[130].thrIndcolumn_name = 'printid' s_tntblinfo[130].fouindcolumn_name = '' s_tntblinfo[130].clearstr = 'truncate table u_givebackmx ' s_tntblinfo[130].tabletype = 2 s_tntblinfo[131].Table_name = 'u_reissue' s_tntblinfo[131].Table_dscrp = '补件单表' s_tntblinfo[131].Sc_id_name = 'scid' s_tntblinfo[131].Indcolumn_name = 'reissueid' s_tntblinfo[131].thrIndcolumn_name = '' s_tntblinfo[131].fouindcolumn_name = '' s_tntblinfo[131].clearstr = 'truncate table u_reissue ' s_tntblinfo[131].tabletype = 2 s_tntblinfo[132].Table_name = 'u_reissuemx' s_tntblinfo[132].Table_dscrp = '补件单明细表' s_tntblinfo[132].Sc_id_name = 'scid' s_tntblinfo[132].Indcolumn_name = 'reissueid' s_tntblinfo[132].thrIndcolumn_name = 'printid' s_tntblinfo[132].fouindcolumn_name = '' s_tntblinfo[132].clearstr = 'truncate table u_reissuemx ' s_tntblinfo[132].tabletype = 2 s_tntblinfo[133].Table_name = 'u_mtrl_storage' s_tntblinfo[133].Table_dscrp = '存放仓库' s_tntblinfo[133].Sc_id_name = 'mtrlid' s_tntblinfo[133].Indcolumn_name = 'storageid' s_tntblinfo[133].thrIndcolumn_name = '' s_tntblinfo[133].fouindcolumn_name = '' s_tntblinfo[133].clearstr = 'truncate table u_mtrl_storage ' s_tntblinfo[133].tabletype = 1 s_tntblinfo[134].Table_name = 'u_quoterqmtrl' s_tntblinfo[134].Table_dscrp = '报价单用料明细表' s_tntblinfo[134].Sc_id_name = 'scid' s_tntblinfo[134].Indcolumn_name = 'quoteid' s_tntblinfo[134].thrIndcolumn_name = 'MtrlID' s_tntblinfo[134].fouindcolumn_name = 'olmtrlid' s_tntblinfo[134].clearstr = 'truncate table u_quoterqmtrl ' s_tntblinfo[134].tabletype = 2 s_tntblinfo[135].Table_name = 'u_unit_def' s_tntblinfo[135].Table_dscrp = '物料单位' s_tntblinfo[135].Sc_id_name = 'unitid' s_tntblinfo[135].Indcolumn_name = '' s_tntblinfo[135].thrIndcolumn_name = '' s_tntblinfo[135].fouindcolumn_name = '' s_tntblinfo[135].clearstr = 'truncate table u_unit_def ' s_tntblinfo[135].tabletype = 1 s_tntblinfo[136].Table_name = 'u_Bmstpay' s_tntblinfo[136].Table_dscrp = '应付帐表' s_tntblinfo[136].Sc_id_name = 'payid' s_tntblinfo[136].Indcolumn_name = '' s_tntblinfo[136].thrIndcolumn_name = '' s_tntblinfo[136].fouindcolumn_name = '' s_tntblinfo[136].clearstr = 'truncate table u_Bmstpay ' s_tntblinfo[136].tabletype = -1 s_tntblinfo[137].Table_name = 'u_Bmstpaymx' s_tntblinfo[137].Table_dscrp = '应收帐明细表' s_tntblinfo[137].Sc_id_name = 'scid' s_tntblinfo[137].Indcolumn_name = 'payid' s_tntblinfo[137].thrIndcolumn_name = 'listno' s_tntblinfo[137].fouindcolumn_name = '' s_tntblinfo[137].clearstr = 'truncate table u_Bmstpaymx ' s_tntblinfo[137].tabletype = -1 s_tntblinfo[138].Table_name = 'u_Bmsttake' s_tntblinfo[138].Table_dscrp = '应收帐表' s_tntblinfo[138].Sc_id_name = 'takeid' s_tntblinfo[138].Indcolumn_name = '' s_tntblinfo[138].thrIndcolumn_name = '' s_tntblinfo[138].fouindcolumn_name = '' s_tntblinfo[138].clearstr = 'truncate table u_Bmsttake ' s_tntblinfo[138].tabletype = -1 s_tntblinfo[139].Table_name = 'u_bmsttakemx' s_tntblinfo[139].Table_dscrp = '应收帐表' s_tntblinfo[139].Sc_id_name = 'scid' s_tntblinfo[139].Indcolumn_name = 'takeid' s_tntblinfo[139].thrIndcolumn_name = 'listno' s_tntblinfo[139].fouindcolumn_name = '' s_tntblinfo[139].clearstr = 'truncate table u_bmsttakemx ' s_tntblinfo[139].tabletype = -1 s_tntblinfo[140].Table_name = 'u_buybill' s_tntblinfo[140].Table_dscrp = '支出单表' s_tntblinfo[140].Sc_id_name = 'buybillid' s_tntblinfo[140].Indcolumn_name = '' s_tntblinfo[140].thrIndcolumn_name = '' s_tntblinfo[140].fouindcolumn_name = '' s_tntblinfo[140].clearstr = 'truncate table u_buybill ' s_tntblinfo[140].tabletype = 2 s_tntblinfo[141].Table_name = 'u_salebill' s_tntblinfo[141].Table_dscrp = '收入单表' s_tntblinfo[141].Sc_id_name = 'salebillid' s_tntblinfo[141].Indcolumn_name = '' s_tntblinfo[141].thrIndcolumn_name = '' s_tntblinfo[141].fouindcolumn_name = '' s_tntblinfo[141].clearstr = 'truncate table u_salebill ' s_tntblinfo[141].tabletype = 2 //s_tntblinfo[142].Table_name = 'u_Bmsttakemx' //s_tntblinfo[142].Table_dscrp = '应收帐明细表' //s_tntblinfo[142].Sc_id_name = 'scid' //s_tntblinfo[142].Indcolumn_name = 'takeid' //s_tntblinfo[142].thrIndcolumn_name = 'listno' //s_tntblinfo[142].fouindcolumn_name = '' //s_tntblinfo[142].clearstr = 'truncate table u_Bmsttakemx ' //s_tntblinfo[142].tabletype = -1 //s_tntblinfo[143].Table_name = 'u_requestbuy' //s_tntblinfo[143].Table_dscrp = '申购单表' //s_tntblinfo[143].Sc_id_name = 'scid' //s_tntblinfo[143].Indcolumn_name = 'requestbuyid' //s_tntblinfo[143].thrIndcolumn_name = '' //s_tntblinfo[143].fouindcolumn_name = '' //s_tntblinfo[160].clearstr = 'truncate table ow_wfjgware ' //s_tntblinfo[143].tabletype = 2 s_tntblinfo[144].Table_name = 'u_salebillmx' s_tntblinfo[144].Table_dscrp = '支出单明细表' s_tntblinfo[144].Sc_id_name = 'salebillid' s_tntblinfo[144].Indcolumn_name = 'takeid' s_tntblinfo[144].thrIndcolumn_name = '' s_tntblinfo[144].fouindcolumn_name = '' s_tntblinfo[144].clearstr = 'truncate table u_salebillmx ' s_tntblinfo[144].tabletype = 2 s_tntblinfo[145].Table_name = 'u_buybillmx' s_tntblinfo[145].Table_dscrp = '收入单明细表' s_tntblinfo[145].Sc_id_name = 'buybillid' s_tntblinfo[145].Indcolumn_name = 'payid' s_tntblinfo[145].thrIndcolumn_name = '' s_tntblinfo[145].fouindcolumn_name = '' s_tntblinfo[145].clearstr = 'truncate table u_buybillmx ' s_tntblinfo[145].tabletype = 2 s_tntblinfo[146].Table_name = 'u_billcode' s_tntblinfo[146].Table_dscrp = '单据编号定义表' s_tntblinfo[146].Sc_id_name = 'id' s_tntblinfo[146].Indcolumn_name = '' s_tntblinfo[146].thrIndcolumn_name = '' s_tntblinfo[146].fouindcolumn_name = '' s_tntblinfo[146].clearstr = 'truncate table u_billcode ' s_tntblinfo[146].tabletype = 1 //s_tntblinfo[147].Table_name = 'u_addon_techdef' //s_tntblinfo[147].Table_dscrp = '物料工艺资料表' //s_tntblinfo[147].Sc_id_name = 'TechID' //s_tntblinfo[147].Indcolumn_name = '' //s_tntblinfo[147].thrIndcolumn_name = '' //s_tntblinfo[147].fouindcolumn_name = '' //s_tntblinfo[147].tabletype = 1 // //s_tntblinfo[148].Table_name = 'u_addon_mtrldef' //s_tntblinfo[148].Table_dscrp = '物料辅料资料表' //s_tntblinfo[148].Sc_id_name = 'AdMtrlID' //s_tntblinfo[148].Indcolumn_name = '' //s_tntblinfo[148].thrIndcolumn_name = '' //s_tntblinfo[148].fouindcolumn_name = '' //s_tntblinfo[148].tabletype = 1 // //s_tntblinfo[149].Table_name = 'u_addon_formularprice' //s_tntblinfo[149].Table_dscrp = '物料辅料公式表' //s_tntblinfo[149].Sc_id_name = 'MtrlID' //s_tntblinfo[149].Indcolumn_name = 'AdMtrlID' //s_tntblinfo[149].thrIndcolumn_name = '' //s_tntblinfo[149].fouindcolumn_name = '' //s_tntblinfo[149].tabletype = 1 // //s_tntblinfo[150].Table_name = 'u_addon_formular_mxtechprice' //s_tntblinfo[150].Table_dscrp = '物料工艺明细表' //s_tntblinfo[150].Sc_id_name = 'MtrlID' //s_tntblinfo[150].Indcolumn_name = 'AdMtrlID' //s_tntblinfo[150].thrIndcolumn_name = 'TechID' //s_tntblinfo[150].fouindcolumn_name = '' //s_tntblinfo[150].tabletype = 1 s_tntblinfo[151].Table_name = 'u_outware_waste' s_tntblinfo[151].Table_dscrp ='废弃单表' s_tntblinfo[151].Sc_id_name = 'wastenum' s_tntblinfo[151].Indcolumn_name = 'scid' s_tntblinfo[151].thrIndcolumn_name = 'outwareid' s_tntblinfo[151].fouindcolumn_name = '' s_tntblinfo[151].clearstr = 'truncate table u_outware_waste ' s_tntblinfo[151].tabletype = 2 s_tntblinfo[152].Table_name = 'u_outwaremx_waste' s_tntblinfo[152].Table_dscrp ='废弃单明细表' s_tntblinfo[152].Sc_id_name = 'wastenum' s_tntblinfo[152].Indcolumn_name = 'scid' s_tntblinfo[152].thrIndcolumn_name = 'outwareid' s_tntblinfo[152].fouindcolumn_name = 'printid' s_tntblinfo[152].clearstr = 'truncate table u_outwaremx_waste ' s_tntblinfo[152].tabletype = 2 s_tntblinfo[153].Table_name = 'u_spt_price_changemx' s_tntblinfo[153].Table_dscrp = '调价单明细表' s_tntblinfo[153].Sc_id_name = 'billid' s_tntblinfo[153].Indcolumn_name = 'mtrlid' s_tntblinfo[153].thrIndcolumn_name = 'status' s_tntblinfo[153].fouindcolumn_name = 'woodcode' s_tntblinfo[153].fifindcolumn_name = 'pcode' s_tntblinfo[153].sixindcolumn_name = 'unit' s_tntblinfo[153].clearstr = 'truncate table u_spt_price_changemx ' s_tntblinfo[153].tabletype = 2 s_tntblinfo[154].Table_name = 'ow_wfjg_out' s_tntblinfo[154].Table_dscrp ='外协出仓表' s_tntblinfo[154].Sc_id_name = 'scid' s_tntblinfo[154].Indcolumn_name = 'outwareid' s_tntblinfo[154].thrIndcolumn_name = '' s_tntblinfo[154].fouindcolumn_name = '' s_tntblinfo[154].clearstr = 'truncate table ow_wfjg_out ' s_tntblinfo[154].tabletype = 2 s_tntblinfo[155].Table_name = 'ow_wfjgmx_out' s_tntblinfo[155].Table_dscrp = '外协出仓明细表' s_tntblinfo[155].Sc_id_name = 'scid' s_tntblinfo[155].Indcolumn_name = 'outwareid' s_tntblinfo[155].thrIndcolumn_name = 'printid' s_tntblinfo[155].fouindcolumn_name = '' s_tntblinfo[155].clearstr = 'truncate table ow_wfjgmx_out ' s_tntblinfo[155].tabletype = 2 s_tntblinfo[156].Table_name = 'ow_wfjg_in' s_tntblinfo[156].Table_dscrp ='外协进仓表' s_tntblinfo[156].Sc_id_name = 'scid' s_tntblinfo[156].Indcolumn_name = 'inwareid' s_tntblinfo[156].thrIndcolumn_name = '' s_tntblinfo[156].fouindcolumn_name = '' s_tntblinfo[156].clearstr = 'truncate table ow_wfjg_in ' s_tntblinfo[156].tabletype = 2 s_tntblinfo[157].Table_name = 'ow_wfjgmx_in_aft' s_tntblinfo[157].Table_dscrp = '外协进仓(收货)明细表' s_tntblinfo[157].Sc_id_name = 'scid' s_tntblinfo[157].Indcolumn_name = 'inwareid' s_tntblinfo[157].thrIndcolumn_name = 'printid' s_tntblinfo[157].fouindcolumn_name = '' s_tntblinfo[157].clearstr = 'truncate table ow_wfjgmx_in_aft ' s_tntblinfo[157].tabletype = 2 s_tntblinfo[158].Table_name = 'ow_wfjgmx_in_bef' s_tntblinfo[158].Table_dscrp = '外协进仓(库存)明细表' s_tntblinfo[158].Sc_id_name = 'scid' s_tntblinfo[158].Indcolumn_name = 'inwareid' s_tntblinfo[158].thrIndcolumn_name = 'printid' s_tntblinfo[158].fouindcolumn_name = '' s_tntblinfo[158].clearstr = 'truncate table ow_wfjgmx_in_bef ' s_tntblinfo[158].tabletype = 2 s_tntblinfo[159].Table_name = 'ow_wfjgbalc' s_tntblinfo[159].Table_dscrp = '外协结存表' s_tntblinfo[159].Sc_id_name = 'scid' s_tntblinfo[159].Indcolumn_name = 'balcdateint' s_tntblinfo[159].thrIndcolumn_name = 'mtrlid' s_tntblinfo[159].fouindcolumn_name = 'sptid' s_tntblinfo[159].fifIndcolumn_name = 'status' s_tntblinfo[159].sixindcolumn_name = 'woodcode' s_tntblinfo[159].clearstr = 'truncate table ow_wfjgbalc ' s_tntblinfo[159].tabletype = 2 s_tntblinfo[160].Table_name = 'ow_wfjgware' s_tntblinfo[160].Table_dscrp = '外协库存表' s_tntblinfo[160].Sc_id_name = 'scid' s_tntblinfo[160].Indcolumn_name = 'mtrlwareid' s_tntblinfo[160].thrIndcolumn_name = '' s_tntblinfo[160].fouindcolumn_name = '' s_tntblinfo[160].clearstr = 'truncate table ow_wfjgware ' s_tntblinfo[160].tabletype = 0 s_tntblinfo[161].Table_name = 'u_warepdb_bill' s_tntblinfo[161].Table_dscrp = '盘点单表' s_tntblinfo[161].Sc_id_name = 'scid' s_tntblinfo[161].Indcolumn_name = 'billid' s_tntblinfo[161].thrIndcolumn_name = '' s_tntblinfo[161].fouindcolumn_name = '' s_tntblinfo[161].tabletype = 2 s_tntblinfo[162].Table_name = 'u_warepdb_billmx' s_tntblinfo[162].Table_dscrp = '盘点单明细表' s_tntblinfo[162].Sc_id_name = 'scid' s_tntblinfo[162].Indcolumn_name = 'billid' s_tntblinfo[162].thrIndcolumn_name = 'printid' s_tntblinfo[162].fouindcolumn_name = '' s_tntblinfo[162].clearstr = 'truncate table u_warepdb_billmx ' s_tntblinfo[162].tabletype = 2 s_tntblinfo[163].Table_name = 'u_income_expenses' s_tntblinfo[163].Table_dscrp = '其他收入支出单' s_tntblinfo[163].Sc_id_name = 'scid' s_tntblinfo[163].Indcolumn_name = 'billid' s_tntblinfo[163].thrIndcolumn_name = '' s_tntblinfo[163].fouindcolumn_name = '' s_tntblinfo[163].clearstr = 'truncate table u_income_expenses ' s_tntblinfo[163].tabletype = 2 s_tntblinfo[164].Table_name = 'Sys_admsg_fj' s_tntblinfo[164].Table_dscrp = '消息表附件' s_tntblinfo[164].Sc_id_name = 'fjid' s_tntblinfo[164].Indcolumn_name = '' s_tntblinfo[164].thrIndcolumn_name = '' s_tntblinfo[164].fouindcolumn_name = '' s_tntblinfo[164].clearstr = 'truncate table Sys_admsg_fj ' s_tntblinfo[164].tabletype = 5 s_tntblinfo[165].Table_name = 'u_color_pcode' s_tntblinfo[165].Table_dscrp = '配置三表' s_tntblinfo[165].Sc_id_name = 'pcodeid' s_tntblinfo[165].Indcolumn_name = '' s_tntblinfo[165].thrIndcolumn_name = '' s_tntblinfo[165].fouindcolumn_name = '' s_tntblinfo[165].clearstr = 'truncate table u_color_pcode ' s_tntblinfo[165].tabletype = 1 s_tntblinfo[166].Table_name = 'u_cust_exchange' s_tntblinfo[166].Table_dscrp = '积分兑换单' s_tntblinfo[166].Sc_id_name = 'scid' s_tntblinfo[166].Indcolumn_name = 'billid' s_tntblinfo[166].thrIndcolumn_name = '' s_tntblinfo[166].fouindcolumn_name = '' s_tntblinfo[166].clearstr = 'truncate table u_cust_exchange ' s_tntblinfo[166].tabletype = 2 s_tntblinfo[167].Table_name = 'u_cust_exchangemx' s_tntblinfo[167].Table_dscrp = '积分兑换单明细' s_tntblinfo[167].Sc_id_name = 'scid' s_tntblinfo[167].Indcolumn_name = 'billid' s_tntblinfo[167].thrIndcolumn_name = 'printid' s_tntblinfo[167].fouindcolumn_name = '' s_tntblinfo[167].clearstr = 'truncate table u_cust_exchangemx ' s_tntblinfo[167].tabletype = 2 s_tntblinfo[168].Table_name = 'u_cust_interview' s_tntblinfo[168].Table_dscrp = '客户走访记录' s_tntblinfo[168].Sc_id_name = 'interviewid' s_tntblinfo[168].Indcolumn_name = '' s_tntblinfo[168].thrIndcolumn_name = '' s_tntblinfo[168].fouindcolumn_name = '' s_tntblinfo[168].clearstr = 'truncate table u_cust_interview ' s_tntblinfo[168].tabletype = 1 s_tntblinfo[169].Table_name = 'u_cust_member' s_tntblinfo[169].Table_dscrp = '会员类型设定' s_tntblinfo[169].Sc_id_name = 'memberid' s_tntblinfo[169].Indcolumn_name = '' s_tntblinfo[169].thrIndcolumn_name = '' s_tntblinfo[169].fouindcolumn_name = '' s_tntblinfo[169].clearstr = 'truncate table u_cust_member ' s_tntblinfo[169].tabletype = 1 s_tntblinfo[170].Table_name = 'u_cust_plan' s_tntblinfo[170].Table_dscrp = '客户计划' s_tntblinfo[170].Sc_id_name = 'planid' s_tntblinfo[170].Indcolumn_name = '' s_tntblinfo[170].thrIndcolumn_name = '' s_tntblinfo[170].fouindcolumn_name = '' s_tntblinfo[170].clearstr = 'truncate table u_cust_plan ' s_tntblinfo[170].tabletype = 1 s_tntblinfo[171].Table_name = 'u_cust_rep' s_tntblinfo[171].Table_dscrp = '客户联系人设定' s_tntblinfo[171].Sc_id_name = 'cusid' s_tntblinfo[171].Indcolumn_name = 'repid' s_tntblinfo[171].thrIndcolumn_name = '' s_tntblinfo[171].fouindcolumn_name = '' s_tntblinfo[171].clearstr = 'truncate table u_cust_rep ' s_tntblinfo[171].tabletype = 1 s_tntblinfo[172].Table_name = 'u_cust_sample' s_tntblinfo[172].Table_dscrp = '客户产品样板' s_tntblinfo[172].Sc_id_name = 'sampleid' s_tntblinfo[172].Indcolumn_name = '' s_tntblinfo[172].thrIndcolumn_name = '' s_tntblinfo[172].fouindcolumn_name = '' s_tntblinfo[172].clearstr = 'truncate table u_cust_sample ' s_tntblinfo[172].tabletype = 1 s_tntblinfo[173].Table_name = 'u_cust_station' s_tntblinfo[173].Table_dscrp = '客户货运部' s_tntblinfo[173].Sc_id_name = 'cusid' s_tntblinfo[173].Indcolumn_name = '' s_tntblinfo[173].thrIndcolumn_name = '' s_tntblinfo[173].fouindcolumn_name = '' s_tntblinfo[173].clearstr = 'truncate table u_cust_station ' s_tntblinfo[173].tabletype = 1 s_tntblinfo[174].Table_name = 'u_email_fj' s_tntblinfo[174].Table_dscrp = '邮件附件' s_tntblinfo[174].Sc_id_name = 'fjid' s_tntblinfo[174].Indcolumn_name = '' s_tntblinfo[174].thrIndcolumn_name = '' s_tntblinfo[174].fouindcolumn_name = '' s_tntblinfo[174].clearstr = 'truncate table u_email_fj ' s_tntblinfo[174].tabletype = 2 s_tntblinfo[175].Table_name = 'u_email_rep' s_tntblinfo[175].Table_dscrp = '邮箱联系人' s_tntblinfo[175].Sc_id_name = 'repID' s_tntblinfo[175].Indcolumn_name = '' s_tntblinfo[175].thrIndcolumn_name = '' s_tntblinfo[175].fouindcolumn_name = '' s_tntblinfo[175].clearstr = 'truncate table u_email_rep ' s_tntblinfo[175].tabletype = 2 s_tntblinfo[176].Table_name = 'u_email_rev' s_tntblinfo[176].Table_dscrp = '邮件收件箱' s_tntblinfo[176].Sc_id_name = 'RevID' s_tntblinfo[176].Indcolumn_name = '' s_tntblinfo[176].thrIndcolumn_name = '' s_tntblinfo[176].fouindcolumn_name = '' s_tntblinfo[176].clearstr = 'truncate table u_email_rev ' s_tntblinfo[176].tabletype = 2 s_tntblinfo[177].Table_name = 'u_email_send' s_tntblinfo[177].Table_dscrp = '邮件发件箱' s_tntblinfo[177].Sc_id_name = 'cusid' s_tntblinfo[177].Indcolumn_name = '' s_tntblinfo[177].thrIndcolumn_name = '' s_tntblinfo[177].fouindcolumn_name = '' s_tntblinfo[177].clearstr = 'truncate table u_email_send ' s_tntblinfo[177].tabletype = 2 s_tntblinfo[178].Table_name = 'u_email_sendmx' s_tntblinfo[178].Table_dscrp = '邮件发件箱接收人' s_tntblinfo[178].Sc_id_name = 'sendid' s_tntblinfo[178].Indcolumn_name = 'printid' s_tntblinfo[178].thrIndcolumn_name = '' s_tntblinfo[178].fouindcolumn_name = '' s_tntblinfo[178].clearstr = 'truncate table u_email_sendmx ' s_tntblinfo[178].tabletype = 2 s_tntblinfo[179].Table_name = 'u_email_set' s_tntblinfo[179].Table_dscrp = '邮箱设定' s_tntblinfo[179].Sc_id_name = 'mailID' s_tntblinfo[179].Indcolumn_name = '' s_tntblinfo[179].thrIndcolumn_name = '' s_tntblinfo[179].fouindcolumn_name = '' s_tntblinfo[179].clearstr = 'truncate table u_email_set ' s_tntblinfo[179].tabletype = 2 s_tntblinfo[180].Table_name = 'U_Expenses' s_tntblinfo[180].Table_dscrp = '客户/供应商费用项目' s_tntblinfo[180].Sc_id_name = 'ExpensesID' s_tntblinfo[180].Indcolumn_name = '' s_tntblinfo[180].thrIndcolumn_name = '' s_tntblinfo[180].fouindcolumn_name = '' s_tntblinfo[180].clearstr = 'truncate table U_Expenses ' s_tntblinfo[180].tabletype = 1 s_tntblinfo[181].Table_name = 'u_formula_def' s_tntblinfo[181].Table_dscrp = '公式' s_tntblinfo[181].Sc_id_name = 'formulaid' s_tntblinfo[181].Indcolumn_name = '' s_tntblinfo[181].thrIndcolumn_name = '' s_tntblinfo[181].fouindcolumn_name = '' s_tntblinfo[181].clearstr = 'truncate table u_formula_def ' s_tntblinfo[181].tabletype = 1 s_tntblinfo[182].table_name = 'u_item_cust_spt' s_tntblinfo[182].table_dscrp = '客户/供应商辅助项目表' s_tntblinfo[182].sc_id_name = 'itemid' s_tntblinfo[182].indcolumn_name = 'relid' s_tntblinfo[182].thrindcolumn_name = 'reltype' s_tntblinfo[182].fouindcolumn_name = '' s_tntblinfo[182].clearstr = 'truncate table u_item_cust_spt' s_tntblinfo[182].tabletype = 1 s_tntblinfo[183].table_name = 'u_item_cust_spt_def' s_tntblinfo[183].table_dscrp = '辅助项目表' s_tntblinfo[183].sc_id_name = 'itemid' s_tntblinfo[183].indcolumn_name = '' s_tntblinfo[183].thrindcolumn_name = '' s_tntblinfo[183].fouindcolumn_name = '' s_tntblinfo[183].clearstr = 'truncate table u_item_cust_spt_def' s_tntblinfo[183].tabletype = 1 s_tntblinfo[184].table_name = 'u_item_cust_spt_def_mx' s_tntblinfo[184].table_dscrp = '辅助项目明细表' s_tntblinfo[184].sc_id_name = 'mxid' s_tntblinfo[184].indcolumn_name = '' s_tntblinfo[184].thrindcolumn_name = '' s_tntblinfo[184].fouindcolumn_name = '' s_tntblinfo[184].clearstr = 'truncate table u_item_cust_spt_def_mx' s_tntblinfo[184].tabletype = 1 s_tntblinfo[185].table_name = 'u_mtrldef_maxminqty' s_tntblinfo[185].table_dscrp = '库存上下限' s_tntblinfo[185].sc_id_name = 'mtrlid' s_tntblinfo[185].indcolumn_name = 'status' s_tntblinfo[185].thrindcolumn_name = 'woodcode' s_tntblinfo[185].fouindcolumn_name = 'pcode' s_tntblinfo[185].clearstr = 'truncate table u_mtrldef_maxminqty' s_tntblinfo[185].tabletype = 1 s_tntblinfo[186].table_name = 'u_order_wfjg_wasteMx_spt' s_tntblinfo[186].table_dscrp = '外协损耗单外协库存表' s_tntblinfo[186].sc_id_name = 'scid' s_tntblinfo[186].indcolumn_name = 'wasteid' s_tntblinfo[186].thrindcolumn_name = 'printid' s_tntblinfo[186].fouindcolumn_name = '' s_tntblinfo[186].clearstr = 'truncate table u_order_wfjg_wasteMx_spt' s_tntblinfo[186].tabletype = 2 s_tntblinfo[187].table_name = 'U_OuterConnection' s_tntblinfo[187].table_dscrp = '外部连接表' s_tntblinfo[187].sc_id_name = 'ConnectionID' s_tntblinfo[187].indcolumn_name = '' s_tntblinfo[187].thrindcolumn_name = '' s_tntblinfo[187].fouindcolumn_name = '' s_tntblinfo[187].clearstr = 'truncate table U_OuterConnection' s_tntblinfo[187].tabletype = -1 s_tntblinfo[188].table_name = 'u_outtype' s_tntblinfo[188].table_dscrp = '销售类型' s_tntblinfo[188].sc_id_name = 'outtypeid' s_tntblinfo[188].indcolumn_name = '' s_tntblinfo[188].thrindcolumn_name = '' s_tntblinfo[188].fouindcolumn_name = '' s_tntblinfo[188].clearstr = 'truncate table u_outtype' s_tntblinfo[188].tabletype = 1 s_tntblinfo[189].table_name = 'u_quote' s_tntblinfo[189].table_dscrp = '报价单表' s_tntblinfo[189].sc_id_name = 'scid' s_tntblinfo[189].indcolumn_name = 'quoteid' s_tntblinfo[189].thrindcolumn_name = '' s_tntblinfo[189].fouindcolumn_name = '' s_tntblinfo[189].clearstr = 'truncate table u_quote' s_tntblinfo[189].tabletype = 2 s_tntblinfo[190].table_name = 'u_quotemx' s_tntblinfo[190].table_dscrp = '报价单表' s_tntblinfo[190].sc_id_name = 'scid' s_tntblinfo[190].indcolumn_name = 'quoteid' s_tntblinfo[190].thrindcolumn_name = 'printid' s_tntblinfo[190].fouindcolumn_name = '' s_tntblinfo[190].clearstr = 'truncate table u_quotemx' s_tntblinfo[190].tabletype = 2 s_tntblinfo[191].table_name = 'u_quoterqmtrl' s_tntblinfo[191].table_dscrp = '报价单用料明细表' s_tntblinfo[191].sc_id_name = 'scid' s_tntblinfo[191].indcolumn_name = 'quoteid' s_tntblinfo[191].thrindcolumn_name = 'printid' s_tntblinfo[191].fouindcolumn_name = 'pid' s_tntblinfo[191].clearstr = 'truncate table u_quoterqmtrl' s_tntblinfo[191].tabletype = 2 s_tntblinfo[192].table_name = 'u_rap_money_transfer' s_tntblinfo[192].table_dscrp = '出纳转帐单表' s_tntblinfo[192].sc_id_name = 'billid' s_tntblinfo[192].indcolumn_name = '' s_tntblinfo[192].thrindcolumn_name = '' s_tntblinfo[192].fouindcolumn_name = '' s_tntblinfo[192].clearstr = 'truncate table u_rap_money_transfer' s_tntblinfo[192].tabletype = 2 s_tntblinfo[193].table_name = 'u_rs_emppic' s_tntblinfo[193].table_dscrp = '人事图片表' s_tntblinfo[193].sc_id_name = 'empid' s_tntblinfo[193].indcolumn_name = '' s_tntblinfo[193].thrindcolumn_name = '' s_tntblinfo[193].fouindcolumn_name = '' s_tntblinfo[193].clearstr = 'truncate table u_rs_emppic' s_tntblinfo[193].tabletype = -1 s_tntblinfo[194].table_name = 'u_sc_workprocedure' s_tntblinfo[194].table_dscrp = '工序表' s_tntblinfo[194].sc_id_name = 'proid' s_tntblinfo[194].indcolumn_name = '' s_tntblinfo[194].thrindcolumn_name = '' s_tntblinfo[194].fouindcolumn_name = '' s_tntblinfo[194].clearstr = 'truncate table u_sc_workprocedure' s_tntblinfo[194].tabletype = 1 s_tntblinfo[195].table_name = 'u_spttype' s_tntblinfo[195].table_dscrp = '供应商类别表' s_tntblinfo[195].sc_id_name = 'spttypeid' s_tntblinfo[195].indcolumn_name = '' s_tntblinfo[195].thrindcolumn_name = '' s_tntblinfo[195].fouindcolumn_name = '' s_tntblinfo[195].clearstr = 'truncate table u_spttype' s_tntblinfo[195].tabletype = 1 s_tntblinfo[196].table_name = 'u_station' s_tntblinfo[196].table_dscrp = '货运部表' s_tntblinfo[196].sc_id_name = 'stationid' s_tntblinfo[196].indcolumn_name = '' s_tntblinfo[196].thrindcolumn_name = '' s_tntblinfo[196].fouindcolumn_name = '' s_tntblinfo[196].clearstr = 'truncate table u_station' s_tntblinfo[196].tabletype = 1 s_tntblinfo[197].table_name = 'u_planprice_changed' s_tntblinfo[197].table_dscrp = '计划价变更单' s_tntblinfo[197].sc_id_name = 'billid' s_tntblinfo[197].indcolumn_name = '' s_tntblinfo[197].thrindcolumn_name = '' s_tntblinfo[197].fouindcolumn_name = '' s_tntblinfo[197].clearstr = 'truncate table u_planprice_changed' s_tntblinfo[197].tabletype = 2 s_tntblinfo[198].table_name = 'u_planprice_changedmx' s_tntblinfo[198].table_dscrp = '计划价变更单明细' s_tntblinfo[198].sc_id_name = 'billid' s_tntblinfo[198].indcolumn_name = 'printid' s_tntblinfo[198].thrindcolumn_name = '' s_tntblinfo[198].fouindcolumn_name = '' s_tntblinfo[198].clearstr = 'truncate table u_planprice_changedmx' s_tntblinfo[198].tabletype = 2 s_tntblinfo[199].table_name = 'u_planprice_his' s_tntblinfo[199].table_dscrp = '计划价变更历史' s_tntblinfo[199].sc_id_name = 'billid' s_tntblinfo[199].indcolumn_name = 'printid' s_tntblinfo[199].thrindcolumn_name = 'mtrlid' s_tntblinfo[199].fouindcolumn_name = 'changedtime' s_tntblinfo[199].clearstr = 'truncate table u_planprice_his' s_tntblinfo[199].tabletype = 2 s_tntblinfo[200].table_name = 'u_plugins' s_tntblinfo[200].table_dscrp = '外挂' s_tntblinfo[200].sc_id_name = 'fileid' s_tntblinfo[200].indcolumn_name = '' s_tntblinfo[200].thrindcolumn_name = '' s_tntblinfo[200].fouindcolumn_name = '' s_tntblinfo[200].clearstr = 'truncate table u_plugins' s_tntblinfo[200].tabletype = 1 s_tntblinfo[201].table_name = 'u_saleRqMtrl_scll' s_tntblinfo[201].table_dscrp = '订单明细运算表' s_tntblinfo[201].sc_id_name = 'rqmtrlid' s_tntblinfo[201].indcolumn_name = '' s_tntblinfo[201].thrindcolumn_name = '' s_tntblinfo[201].fouindcolumn_name = '' s_tntblinfo[201].clearstr = 'truncate table u_saleRqMtrl_scll' s_tntblinfo[201].tabletype = 2 s_tntblinfo[202].table_name = 'u_sptmtrlname' s_tntblinfo[202].table_dscrp = '供应商别名' s_tntblinfo[202].sc_id_name = 'sptid' s_tntblinfo[202].indcolumn_name = 'mtrlid' s_tntblinfo[202].thrindcolumn_name = '' s_tntblinfo[202].fouindcolumn_name = '' s_tntblinfo[202].clearstr = 'truncate table u_sptmtrlname' s_tntblinfo[202].tabletype = 1 return 0 end function