Q5/ws_objects/Ew_datatran.pbl.src/f_init_tntblinfo_2.srf

$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