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

$PBExportHeader$f_init_tntblinfo.srf
global type f_init_tntblinfo from function_object
end type

forward prototypes
global function integer f_init_tntblinfo ()
end prototypes

global function integer f_init_tntblinfo ();//f_init_tntblinfo
//tabletype:
//-1 -特殊表(不执行update insert)
//0- 必须全部转移的表
//1- 定义数据表
//2- 业务数据表
//3- 根据附加筛选条件决定上传下传的数据的表
//4- 工资财务
//5- 消息

s_tntblinfo[1].Table_name = 'cw_banktype'
s_tntblinfo[1].Table_dscrp = '结算方式'
s_tntblinfo[1].Sc_id_name = 'banktypeid'
s_tntblinfo[1].Indcolumn_name = ''
s_tntblinfo[1].thrIndcolumn_name = ''
s_tntblinfo[1].fouindcolumn_name = ''
s_tntblinfo[1].clearstr = "delete from cw_banktype where banktypename <> '记帐'"
s_tntblinfo[1].tabletype = 1

s_tntblinfo[2].Table_name = 'cw_currency'
s_tntblinfo[2].Table_dscrp = '币种'
s_tntblinfo[2].Sc_id_name = 'moneyid'
s_tntblinfo[2].Indcolumn_name = ''
s_tntblinfo[2].thrIndcolumn_name = ''
s_tntblinfo[2].fouindcolumn_name = ''
s_tntblinfo[2].clearstr = "delete from cw_currency where native = 0"
s_tntblinfo[2].tabletype = 1

s_tntblinfo[3].Table_name = 'cw_department'
s_tntblinfo[3].Table_dscrp = '部门设定'
s_tntblinfo[3].Sc_id_name = 'departmentid'
s_tntblinfo[3].Indcolumn_name = ''
s_tntblinfo[3].thrIndcolumn_name = ''
s_tntblinfo[3].fouindcolumn_name = ''
s_tntblinfo[3].clearstr = 'truncate table cw_department'
s_tntblinfo[3].tabletype = 1

s_tntblinfo[4].Table_name = 'dts_deletelog'
s_tntblinfo[4].Table_dscrp = '系统删除日志(传递必选)'
s_tntblinfo[4].Sc_id_name = ''
s_tntblinfo[4].Indcolumn_name = ''
s_tntblinfo[4].thrIndcolumn_name = ''
s_tntblinfo[4].fouindcolumn_name = ''
s_tntblinfo[4].clearstr = 'truncate table dts_deletelog'
s_tntblinfo[4].tabletype = -1

s_tntblinfo[5].Table_name = 'Sys_admsg'
s_tntblinfo[5].Table_dscrp = '消息表'
s_tntblinfo[5].Sc_id_name = 'msgid'
s_tntblinfo[5].Indcolumn_name = ''
s_tntblinfo[5].thrIndcolumn_name = ''
s_tntblinfo[5].fouindcolumn_name = ''
s_tntblinfo[5].clearstr = 'truncate table Sys_admsg '
s_tntblinfo[5].tabletype = 5

s_tntblinfo[6].Table_name = 'Sys_admsgmx'
s_tntblinfo[6].Table_dscrp = '消息明细表'
s_tntblinfo[6].Sc_id_name = 'msgid'
s_tntblinfo[6].Indcolumn_name = 'senddtint'
s_tntblinfo[6].thrIndcolumn_name = 'empid'
s_tntblinfo[6].fouindcolumn_name = ''
s_tntblinfo[6].clearstr = 'truncate table Sys_admsgmx '
s_tntblinfo[6].tabletype = 5

s_tntblinfo[7].Table_name = 'sys_ct_data'
s_tntblinfo[7].Table_dscrp = '截数日志'
s_tntblinfo[7].Sc_id_name = 'ct_dateint'
s_tntblinfo[7].Indcolumn_name = ''
s_tntblinfo[7].thrIndcolumn_name = ''
s_tntblinfo[7].fouindcolumn_name = ''
s_tntblinfo[7].clearstr = 'truncate table sys_ct_data '
s_tntblinfo[7].tabletype = -1

s_tntblinfo[8].Table_name = 'sys_func_pwr'
s_tntblinfo[8].Table_dscrp = '权限功能'
s_tntblinfo[8].Sc_id_name = 'funcid'
s_tntblinfo[8].Indcolumn_name = ''
s_tntblinfo[8].thrIndcolumn_name = ''
s_tntblinfo[8].fouindcolumn_name = ''
s_tntblinfo[8].clearstr = ''
s_tntblinfo[8].tabletype = 1

s_tntblinfo[9].Table_name = 'sys_option'
s_tntblinfo[9].Table_dscrp = '系统设置'
s_tntblinfo[9].Sc_id_name = 'optionid'
s_tntblinfo[9].Indcolumn_name = ''
s_tntblinfo[9].thrIndcolumn_name = ''
s_tntblinfo[9].fouindcolumn_name = ''
s_tntblinfo[9].clearstr = 'truncate table sys_option '
s_tntblinfo[9].tabletype = 1

s_tntblinfo[10].Table_name = 'Sys_scIdentity'
s_tntblinfo[10].Table_dscrp = 'ID流水表'
s_tntblinfo[10].Sc_id_name = 'scid'
s_tntblinfo[10].Indcolumn_name = 'Tablename'
s_tntblinfo[10].thrIndcolumn_name = 'Columnname'
s_tntblinfo[10].fouindcolumn_name = ''
s_tntblinfo[10].clearstr = 'truncate table Sys_scIdentity '
s_tntblinfo[10].tabletype = -1

s_tntblinfo[11].Table_name = 'Tb_infor'
s_tntblinfo[11].Table_dscrp = '静态信息(表字段信息)'
s_tntblinfo[11].Sc_id_name = 'Gx_id'
s_tntblinfo[11].Indcolumn_name = ''
s_tntblinfo[11].thrIndcolumn_name = ''
s_tntblinfo[11].fouindcolumn_name = ''
s_tntblinfo[11].clearstr = ''
s_tntblinfo[11].tabletype = 1

s_tntblinfo[12].Table_name = 'TbFields_Script'
s_tntblinfo[12].Table_dscrp = '静态信息(字段明细信息)'
s_tntblinfo[12].Sc_id_name = 'Gx_id'
s_tntblinfo[12].Indcolumn_name = 'Static_id'
s_tntblinfo[12].thrIndcolumn_name = ''
s_tntblinfo[12].fouindcolumn_name = ''
s_tntblinfo[12].clearstr = ''
s_tntblinfo[12].tabletype = 1

s_tntblinfo[13].Table_name = 'u_accounts'
s_tntblinfo[13].Table_dscrp = '出纳帐号表'
s_tntblinfo[13].Sc_id_name = 'accountsid'
s_tntblinfo[13].Indcolumn_name = ''
s_tntblinfo[13].thrIndcolumn_name = ''
s_tntblinfo[13].fouindcolumn_name = ''
s_tntblinfo[13].clearstr = 'truncate table u_accounts '
s_tntblinfo[13].tabletype = 1

//s_tntblinfo[14].Table_name = 'u_apportion'
//s_tntblinfo[14].Table_dscrp = '车间盘点材料表'
//s_tntblinfo[14].Sc_id_name = 'atid'
//s_tntblinfo[14].Indcolumn_name = 'mtrlid'
//s_tntblinfo[14].thrIndcolumn_name = ''
//s_tntblinfo[14].fouindcolumn_name = ''
//s_tntblinfo[14].clearstr = 'truncate table u_apportion '
//s_tntblinfo[14].tabletype = 2

//s_tntblinfo[15].Table_name = 'u_apportion_cp'
//s_tntblinfo[15].Table_dscrp = '成品统计表'
//s_tntblinfo[15].Sc_id_name = 'atid'
//s_tntblinfo[15].Indcolumn_name = 'mtrlid'
//s_tntblinfo[15].thrIndcolumn_name = ''
//s_tntblinfo[15].fouindcolumn_name = ''
//s_tntblinfo[15].tabletype = 2
//
//s_tntblinfo[16].Table_name = 'u_apportion_mtrl'
//s_tntblinfo[16].Table_dscrp = '材料统计表'
//s_tntblinfo[16].Sc_id_name = 'atid'
//s_tntblinfo[16].Indcolumn_name = 'mtrlid'
//s_tntblinfo[16].thrIndcolumn_name = ''
//s_tntblinfo[16].fouindcolumn_name = ''
//s_tntblinfo[16].tabletype = 2
//
//s_tntblinfo[17].Table_name = 'u_apportion_time'
//s_tntblinfo[17].Table_dscrp = '车间盘点时间表'
//s_tntblinfo[17].Sc_id_name = 'atid'
//s_tntblinfo[17].Indcolumn_name = ''
//s_tntblinfo[17].thrIndcolumn_name = ''
//s_tntblinfo[17].fouindcolumn_name = ''
//s_tntblinfo[17].tabletype = 2
//
//s_tntblinfo[18].Table_name = 'u_apportion_time'
//s_tntblinfo[18].Table_dscrp = '车间盘点半成品表'
//s_tntblinfo[18].Sc_id_name = 'atid'
//s_tntblinfo[18].Indcolumn_name = 'orderid'
//s_tntblinfo[18].thrIndcolumn_name = 'wrkGrpid'
//s_tntblinfo[18].fouindcolumn_name = 'mtrlid'
//s_tntblinfo[18].tabletype = 2

s_tntblinfo[19].Table_name = 'u_bsnNo'
s_tntblinfo[19].Table_dscrp = '业务编号表'
s_tntblinfo[19].Sc_id_name = 'scid'
s_tntblinfo[19].Indcolumn_name = 'opdate'
s_tntblinfo[19].thrIndcolumn_name = 'Typecode'
s_tntblinfo[19].fouindcolumn_name = 'status'
s_tntblinfo[19].clearstr = 'truncate table u_bsnNo '
s_tntblinfo[19].tabletype = 2

s_tntblinfo[20].Table_name = 'u_buyTask'
s_tntblinfo[20].Table_dscrp = '采购合同'
s_tntblinfo[20].Sc_id_name = 'scid'
s_tntblinfo[20].Indcolumn_name = 'TaskID'
s_tntblinfo[20].thrIndcolumn_name = ''
s_tntblinfo[20].fouindcolumn_name = ''
s_tntblinfo[20].clearstr = 'truncate table u_buyTask '
s_tntblinfo[20].tabletype = 2

s_tntblinfo[21].Table_name = 'u_buyTaskMx'
s_tntblinfo[21].Table_dscrp = '采购合同明细'
s_tntblinfo[21].Sc_id_name = 'scid'
s_tntblinfo[21].Indcolumn_name = 'TaskID'
s_tntblinfo[21].thrIndcolumn_name = 'printid'
s_tntblinfo[21].fouindcolumn_name = ''
s_tntblinfo[21].clearstr = 'truncate table u_buyTaskMx '
s_tntblinfo[21].tabletype = 2

s_tntblinfo[22].Table_name = 'u_color'
s_tntblinfo[22].Table_dscrp = '规格颜色表'
s_tntblinfo[22].Sc_id_name = 'colorid'
s_tntblinfo[22].Indcolumn_name = ''
s_tntblinfo[22].thrIndcolumn_name = ''
s_tntblinfo[22].fouindcolumn_name = ''
s_tntblinfo[22].clearstr = 'truncate table u_color '
s_tntblinfo[22].tabletype = 1

s_tntblinfo[23].Table_name = 'u_color_wood'
s_tntblinfo[23].Table_dscrp = '木色表'
s_tntblinfo[23].Sc_id_name = 'woodcodeid'
s_tntblinfo[23].Indcolumn_name = ''
s_tntblinfo[23].thrIndcolumn_name = ''
s_tntblinfo[23].fouindcolumn_name = ''
s_tntblinfo[23].clearstr = 'truncate table u_color_wood '
s_tntblinfo[23].tabletype = 1

s_tntblinfo[24].Table_name = 'u_cus_price'
s_tntblinfo[24].Table_dscrp = '客户报价表'
s_tntblinfo[24].Sc_id_name = 'cusid'
s_tntblinfo[24].Indcolumn_name = 'mtrlid'
s_tntblinfo[24].thrIndcolumn_name = ''
s_tntblinfo[24].fouindcolumn_name = ''
s_tntblinfo[24].clearstr = 'truncate table u_cus_price '
s_tntblinfo[24].tabletype = 6

s_tntblinfo[25].Table_name = 'u_cus_price_MX'
s_tntblinfo[25].Table_dscrp = '客户报价历史明细表'
s_tntblinfo[25].Sc_id_name = 'cusid'
s_tntblinfo[25].Indcolumn_name = 'mtrlid'
s_tntblinfo[25].thrIndcolumn_name = 'opdate'
s_tntblinfo[25].fouindcolumn_name = ''
s_tntblinfo[25].clearstr = 'truncate table u_cus_price_MX '
s_tntblinfo[25].tabletype = 6

s_tntblinfo[26].Table_name = 'u_cusamt'
s_tntblinfo[26].Table_dscrp = '收据表'
s_tntblinfo[26].Sc_id_name = 'cusmonid'
s_tntblinfo[26].Indcolumn_name = ''
s_tntblinfo[26].thrIndcolumn_name = ''
s_tntblinfo[26].fouindcolumn_name = ''
s_tntblinfo[26].clearstr = 'truncate table u_cusamt '
s_tntblinfo[26].tabletype = 2

s_tntblinfo[27].Table_name = 'u_Cusarea'
s_tntblinfo[27].Table_dscrp = '客户区域设定'
s_tntblinfo[27].Sc_id_name = 'Cusareaid'
s_tntblinfo[27].Indcolumn_name = ''
s_tntblinfo[27].thrIndcolumn_name = ''
s_tntblinfo[27].fouindcolumn_name = ''
s_tntblinfo[27].clearstr = 'truncate table u_Cusarea '
s_tntblinfo[27].tabletype = 1

s_tntblinfo[28].Table_name = 'u_cust'
s_tntblinfo[28].Table_dscrp = '客户设定'
s_tntblinfo[28].Sc_id_name = 'cusid'
s_tntblinfo[28].Indcolumn_name = ''
s_tntblinfo[28].thrIndcolumn_name = ''
s_tntblinfo[28].fouindcolumn_name = ''
s_tntblinfo[28].clearstr = 'truncate table u_cust '
s_tntblinfo[28].tabletype = 1

s_tntblinfo[29].Table_name = 'u_dismantle_install'
s_tntblinfo[29].Table_dscrp = '拆装单'
s_tntblinfo[29].Sc_id_name = 'billid'
s_tntblinfo[29].Indcolumn_name = ''
s_tntblinfo[29].thrIndcolumn_name = ''
s_tntblinfo[29].fouindcolumn_name = ''
s_tntblinfo[29].clearstr = 'truncate table u_dismantle_install '
s_tntblinfo[29].tabletype = 2

s_tntblinfo[30].Table_name = 'u_dismantle_installmx'
s_tntblinfo[30].Table_dscrp = '拆装单明细'
s_tntblinfo[30].Sc_id_name = 'billid'
s_tntblinfo[30].Indcolumn_name = 'printid'
s_tntblinfo[30].thrIndcolumn_name = ''
s_tntblinfo[30].fouindcolumn_name = ''
s_tntblinfo[30].clearstr = 'truncate table u_dismantle_installmx '
s_tntblinfo[30].tabletype = 2

s_tntblinfo[31].Table_name = 'u_gz_award_punish'
s_tntblinfo[31].Table_dscrp = '奖罚单'
s_tntblinfo[31].Sc_id_name = 'billid'
s_tntblinfo[31].Indcolumn_name = ''
s_tntblinfo[31].thrIndcolumn_name = ''
s_tntblinfo[31].fouindcolumn_name = ''
s_tntblinfo[31].clearstr = 'truncate table u_gz_award_punish '
s_tntblinfo[31].tabletype = 2

s_tntblinfo[32].Table_name = 'u_gz_cwork'
s_tntblinfo[32].Table_dscrp = '考勤单'
s_tntblinfo[32].Sc_id_name = 'billid'
s_tntblinfo[32].Indcolumn_name = ''
s_tntblinfo[32].thrIndcolumn_name = ''
s_tntblinfo[32].fouindcolumn_name = ''
s_tntblinfo[32].clearstr = 'truncate table u_gz_cwork '
s_tntblinfo[32].tabletype = 2

s_tntblinfo[33].Table_name = 'u_gz_cworkitem'
s_tntblinfo[33].Table_dscrp = '考勤项目'
s_tntblinfo[33].Sc_id_name = 'cworkid'
s_tntblinfo[33].Indcolumn_name = ''
s_tntblinfo[33].thrIndcolumn_name = ''
s_tntblinfo[33].fouindcolumn_name = ''
s_tntblinfo[33].clearstr = 'truncate table u_gz_cworkitem '
s_tntblinfo[33].tabletype = 1

s_tntblinfo[34].Table_name = 'u_gz_loanwage'
s_tntblinfo[34].Table_dscrp = '借支单'
s_tntblinfo[34].Sc_id_name = 'billid'
s_tntblinfo[34].Indcolumn_name = ''
s_tntblinfo[34].thrIndcolumn_name = ''
s_tntblinfo[34].fouindcolumn_name = ''
s_tntblinfo[34].clearstr = 'truncate table u_gz_loanwage '
s_tntblinfo[34].tabletype = 2

s_tntblinfo[35].Table_name = 'u_gz_wage'
s_tntblinfo[35].Table_dscrp = '工资表'
s_tntblinfo[35].Sc_id_name = 'empid'
s_tntblinfo[35].Indcolumn_name = 'wagemth'
s_tntblinfo[35].thrIndcolumn_name = ''
s_tntblinfo[35].fouindcolumn_name = ''
s_tntblinfo[35].clearstr = 'truncate table u_gz_wage '
s_tntblinfo[35].tabletype = 2

s_tntblinfo[36].Table_name = 'u_gz_wageitem'
s_tntblinfo[36].Table_dscrp = '工资项目表'
s_tntblinfo[36].Sc_id_name = 'wageid'
s_tntblinfo[36].Indcolumn_name = ''
s_tntblinfo[36].thrIndcolumn_name = ''
s_tntblinfo[36].fouindcolumn_name = ''
s_tntblinfo[36].clearstr = 'truncate table u_gz_wageitem '
s_tntblinfo[36].tabletype = 1

s_tntblinfo[37].Table_name = 'u_gz_wagemx'
s_tntblinfo[37].Table_dscrp = '工资明细表'
s_tntblinfo[37].Sc_id_name = 'wageid'
s_tntblinfo[37].Indcolumn_name = 'empid'
s_tntblinfo[37].thrIndcolumn_name = 'wagemth'
s_tntblinfo[37].fouindcolumn_name = ''
s_tntblinfo[37].clearstr = 'truncate table u_gz_wagemx '
s_tntblinfo[37].tabletype = 2

s_tntblinfo[38].Table_name = 'u_incase'
s_tntblinfo[38].Table_dscrp = '装箱单'
s_tntblinfo[38].Sc_id_name = 'scid'
s_tntblinfo[38].Indcolumn_name = 'incaseid'
s_tntblinfo[38].thrIndcolumn_name = ''
s_tntblinfo[38].fouindcolumn_name = ''
s_tntblinfo[38].clearstr = 'truncate table u_incase '
s_tntblinfo[38].tabletype = 2

s_tntblinfo[39].Table_name = 'u_incasemx'
s_tntblinfo[39].Table_dscrp = '装箱单明细'
s_tntblinfo[39].Sc_id_name = 'scid'
s_tntblinfo[39].Indcolumn_name = 'incaseid'
s_tntblinfo[39].thrIndcolumn_name = 'printid'
s_tntblinfo[39].fouindcolumn_name = ''
s_tntblinfo[39].clearstr = 'truncate table u_incasemx '
s_tntblinfo[39].tabletype = 2

s_tntblinfo[40].Table_name = 'u_inware'
s_tntblinfo[40].Table_dscrp = '进仓单表'
s_tntblinfo[40].Sc_id_name = 'scid'
s_tntblinfo[40].Indcolumn_name = 'inwareid'
s_tntblinfo[40].thrIndcolumn_name = ''
s_tntblinfo[40].fouindcolumn_name = ''
s_tntblinfo[40].clearstr = 'truncate table u_inware '
s_tntblinfo[40].tabletype = 2

s_tntblinfo[41].Table_name = 'u_INWareMx'
s_tntblinfo[41].Table_dscrp = '进仓明细表'
s_tntblinfo[41].Sc_id_name = 'scid'
s_tntblinfo[41].Indcolumn_name = 'inwareid'
s_tntblinfo[41].thrIndcolumn_name = 'printid'
s_tntblinfo[41].fouindcolumn_name = ''
s_tntblinfo[41].clearstr = 'truncate table u_INWareMx '
s_tntblinfo[41].tabletype = 2

s_tntblinfo[42].Table_name = 'u_itemdef'
s_tntblinfo[42].Table_dscrp = '费用项目表'
s_tntblinfo[42].Sc_id_name = 'itemid'
s_tntblinfo[42].Indcolumn_name = ''
s_tntblinfo[42].thrIndcolumn_name = ''
s_tntblinfo[42].fouindcolumn_name = ''
s_tntblinfo[42].clearstr = 'delete from u_itemdef where dfttype = 0 '
s_tntblinfo[42].tabletype = 1

s_tntblinfo[43].Table_name = 'u_iteminput'
s_tntblinfo[43].Table_dscrp = '费用表'
s_tntblinfo[43].Sc_id_name = 'itemid'
s_tntblinfo[43].Indcolumn_name = 'dateint'
s_tntblinfo[43].thrIndcolumn_name = ''
s_tntblinfo[43].fouindcolumn_name = ''
s_tntblinfo[43].clearstr = 'truncate table u_iteminput '
s_tntblinfo[43].tabletype = 2

s_tntblinfo[44].Table_name = 'u_spt_rep'
s_tntblinfo[44].Table_dscrp = '供应商联系人'
s_tntblinfo[44].Sc_id_name = 'repid'
s_tntblinfo[44].Indcolumn_name = ''
s_tntblinfo[44].thrIndcolumn_name = ''
s_tntblinfo[44].fouindcolumn_name = ''
s_tntblinfo[44].clearstr = 'truncate table u_spt_rep '
s_tntblinfo[44].tabletype = 1

s_tntblinfo[45].Table_name = 'u_cust_rep'
s_tntblinfo[45].Table_dscrp = '客户联系人'
s_tntblinfo[45].Sc_id_name = 'repid'
s_tntblinfo[45].Indcolumn_name = ''
s_tntblinfo[45].thrIndcolumn_name = ''
s_tntblinfo[45].fouindcolumn_name = ''
s_tntblinfo[45].clearstr = 'truncate table u_cust_rep '
s_tntblinfo[45].tabletype = 1

s_tntblinfo[46].Table_name = 'u_mtrl_structure_gy'
s_tntblinfo[46].Table_dscrp = '产品构成说明表'
s_tntblinfo[46].Sc_id_name = 'mtrlid'
s_tntblinfo[46].Indcolumn_name = 'pfcode'
s_tntblinfo[46].thrIndcolumn_name = ''
s_tntblinfo[46].fouindcolumn_name = ''
s_tntblinfo[46].clearstr = 'truncate table u_mtrl_structure_gy '
s_tntblinfo[46].tabletype = 1

s_tntblinfo[47].Table_name = 'u_mtrldef'
s_tntblinfo[47].Table_dscrp = '产品设定'
s_tntblinfo[47].Sc_id_name = 'mtrlid'
s_tntblinfo[47].Indcolumn_name = ''
s_tntblinfo[47].thrIndcolumn_name = ''
s_tntblinfo[47].fouindcolumn_name = ''
s_tntblinfo[47].clearstr = 'truncate table u_mtrldef '
s_tntblinfo[47].tabletype = 1

//s_tntblinfo[48].Table_name = 'u_mtrlprice_sum'
//s_tntblinfo[48].Table_dscrp = '产品最新成品统计表'
//s_tntblinfo[48].Sc_id_name = 'mtrlid'
//s_tntblinfo[48].Indcolumn_name = 'sumdate'
//s_tntblinfo[48].thrIndcolumn_name = ''
//s_tntblinfo[48].fouindcolumn_name = ''
//s_tntblinfo[48].clearstr = 'truncate table u_mtrlprice_sum '
//s_tntblinfo[48].tabletype = 2

s_tntblinfo[49].Table_name = 'u_mtrltype'
s_tntblinfo[49].Table_dscrp = '物料类别定义'
s_tntblinfo[49].Sc_id_name = 'mtrltypeid'
s_tntblinfo[49].Indcolumn_name = ''
s_tntblinfo[49].thrIndcolumn_name = ''
s_tntblinfo[49].fouindcolumn_name = ''
s_tntblinfo[49].clearstr = 'truncate table u_mtrltype '
s_tntblinfo[49].tabletype = 1

s_tntblinfo[50].Table_name = 'u_mtrlware'
s_tntblinfo[50].Table_dscrp = '库存表'
s_tntblinfo[50].Sc_id_name = 'scid'
s_tntblinfo[50].Indcolumn_name = 'mtrlwareID'
s_tntblinfo[50].thrIndcolumn_name = ''
s_tntblinfo[50].fouindcolumn_name = ''
s_tntblinfo[50].clearstr = 'truncate table u_mtrlware '
s_tntblinfo[50].tabletype = 2

s_tntblinfo[51].Table_name = 'u_mtrlware_trans'
s_tntblinfo[51].Table_dscrp = '客户库存调整单'
s_tntblinfo[51].Sc_id_name = 'scid'
s_tntblinfo[51].Indcolumn_name = 'billid'
s_tntblinfo[51].thrIndcolumn_name = ''
s_tntblinfo[51].fouindcolumn_name = ''
s_tntblinfo[51].clearstr = 'truncate table u_mtrlware_trans '
s_tntblinfo[51].tabletype = 2

s_tntblinfo[52].Table_name = 'u_mtrlware_transmx'
s_tntblinfo[52].Table_dscrp = '客户库存调整单明细'
s_tntblinfo[52].Sc_id_name = 'scid'
s_tntblinfo[52].Indcolumn_name = 'billid'
s_tntblinfo[52].thrIndcolumn_name = 'printid'
s_tntblinfo[52].fouindcolumn_name = ''
s_tntblinfo[52].clearstr = 'truncate table u_mtrlware_transmx '
s_tntblinfo[52].tabletype = 2

s_tntblinfo[53].Table_name = 'u_oppose'
s_tntblinfo[53].Table_dscrp = '投诉单'
s_tntblinfo[53].Sc_id_name = 'billid'
s_tntblinfo[53].Indcolumn_name = ''
s_tntblinfo[53].thrIndcolumn_name = ''
s_tntblinfo[53].fouindcolumn_name = ''
s_tntblinfo[53].clearstr = 'truncate table u_oppose '
s_tntblinfo[53].tabletype = 2

s_tntblinfo[54].Table_name = 'u_oppose_item'
s_tntblinfo[54].Table_dscrp = '投诉项目'
s_tntblinfo[54].Sc_id_name = 'itemid'
s_tntblinfo[54].Indcolumn_name = ''
s_tntblinfo[54].thrIndcolumn_name = ''
s_tntblinfo[54].fouindcolumn_name = ''
s_tntblinfo[54].clearstr = 'truncate table u_oppose_item '
s_tntblinfo[54].tabletype = 1

s_tntblinfo[55].Table_name = 'u_opposemx_dept'
s_tntblinfo[55].Table_dscrp = '投诉单部门明细'
s_tntblinfo[55].Sc_id_name = 'billid'
s_tntblinfo[55].Indcolumn_name = 'deptid'
s_tntblinfo[55].thrIndcolumn_name = ''
s_tntblinfo[55].fouindcolumn_name = ''
s_tntblinfo[55].clearstr = 'truncate table u_opposemx_dept '
s_tntblinfo[55].tabletype = 2

s_tntblinfo[56].Table_name = 'u_opposemx_mtrl'
s_tntblinfo[56].Table_dscrp = '投诉单物料明细'
s_tntblinfo[56].Sc_id_name = 'billid'
s_tntblinfo[56].Indcolumn_name = 'mtrlid'
s_tntblinfo[56].thrIndcolumn_name = 'status'
s_tntblinfo[56].fouindcolumn_name = ''
s_tntblinfo[56].clearstr = 'truncate table u_opposemx_mtrl '
s_tntblinfo[56].tabletype = 2

//s_tntblinfo[57].Table_name = 'u_order_ml'
//s_tntblinfo[57].Table_dscrp = '生产计划表'
//s_tntblinfo[57].Sc_id_name = 'scid'
//s_tntblinfo[57].Indcolumn_name = 'OrderID'
//s_tntblinfo[57].thrIndcolumn_name = ''
//s_tntblinfo[57].fouindcolumn_name = ''
//s_tntblinfo[57].clearstr = 'truncate table u_order_ml '
//s_tntblinfo[57].tabletype = 2
//
//s_tntblinfo[58].Table_name = 'u_order_ml_mx'
//s_tntblinfo[58].Table_dscrp = '生产计划明细表'
//s_tntblinfo[58].Sc_id_name = 'scid'
//s_tntblinfo[58].Indcolumn_name = 'orderid'
//s_tntblinfo[58].thrIndcolumn_name = 'taskid'
//s_tntblinfo[58].fouindcolumn_name = ''
//s_tntblinfo[58].clearstr = 'truncate table u_order_ml_mx '
//s_tntblinfo[58].tabletype = 2

s_tntblinfo[59].Table_name = 'u_order_wfjg'
s_tntblinfo[59].Table_dscrp = '发外加工计划'
s_tntblinfo[59].Sc_id_name = 'scid'
s_tntblinfo[59].Indcolumn_name = 'wfjgID'
s_tntblinfo[59].thrIndcolumn_name = ''
s_tntblinfo[59].fouindcolumn_name = ''
s_tntblinfo[59].clearstr = 'truncate table u_order_wfjg '
s_tntblinfo[59].tabletype = 2

s_tntblinfo[60].Table_name = 'u_order_wfjgmx'
s_tntblinfo[60].Table_dscrp = '发外加工计划明细'
s_tntblinfo[60].Sc_id_name = 'scid'
s_tntblinfo[60].Indcolumn_name = 'wfjgID'
s_tntblinfo[60].thrIndcolumn_name = 'printid'
s_tntblinfo[60].fouindcolumn_name = ''
s_tntblinfo[60].clearstr = 'truncate table u_order_wfjgmx '
s_tntblinfo[60].tabletype = 2

s_tntblinfo[61].Table_name = 'u_order_wfjg_waste'
s_tntblinfo[61].Table_dscrp = '损耗单'
s_tntblinfo[61].Sc_id_name = 'scid'
s_tntblinfo[61].Indcolumn_name = 'wasteid'
s_tntblinfo[61].thrIndcolumn_name = ''
s_tntblinfo[61].fouindcolumn_name = ''
s_tntblinfo[61].clearstr = 'truncate table u_order_wfjg_waste '
s_tntblinfo[61].tabletype = 2

s_tntblinfo[62].Table_name = 'u_order_wfjg_wasteMx'
s_tntblinfo[62].Table_dscrp = '损耗单明细'
s_tntblinfo[62].Sc_id_name = 'scid'
s_tntblinfo[62].Indcolumn_name = 'wasteid'
s_tntblinfo[62].thrIndcolumn_name = 'printid'
s_tntblinfo[62].fouindcolumn_name = ''
s_tntblinfo[62].clearstr = 'truncate table u_order_wfjg_wasteMx '
s_tntblinfo[62].tabletype = 2

//s_tntblinfo[63].Table_name = 'u_OrderMtrl_workgroup'
//s_tntblinfo[63].Table_dscrp = '生产计划工组表'
//s_tntblinfo[63].Sc_id_name = 'scid'
//s_tntblinfo[63].Indcolumn_name = 'orderid'
//s_tntblinfo[63].thrIndcolumn_name = 'wrkGrpid'
//s_tntblinfo[63].fouindcolumn_name = ''
//s_tntblinfo[63].clearstr = 'truncate table u_OrderMtrl_workgroup '
//s_tntblinfo[63].tabletype = 2
//
//s_tntblinfo[64].Table_name = 'u_OrderRqMtrl'
//s_tntblinfo[64].Table_dscrp = '生产计划用料需求表'
//s_tntblinfo[64].Sc_id_name = 'scid'
//s_tntblinfo[64].Indcolumn_name = 'OrderID'
//s_tntblinfo[64].thrIndcolumn_name = 'wrkgrpid'
//s_tntblinfo[64].fouindcolumn_name = 'MtrlID'
//s_tntblinfo[64].clearstr = 'truncate table u_OrderRqMtrl '
//s_tntblinfo[64].tabletype = 2

//s_tntblinfo[65].Table_name = 'u_OrderRqMtrl_middle'
//s_tntblinfo[65].Table_dscrp = '生产计划外加工需求表'
//s_tntblinfo[65].Sc_id_name = 'scid'
//s_tntblinfo[65].Indcolumn_name = 'OrderID'
//s_tntblinfo[65].thrIndcolumn_name = 'wrkgrpid'
//s_tntblinfo[65].fouindcolumn_name = 'MtrlID'
//s_tntblinfo[65].clearstr = 'truncate table u_OrderRqMtrl_middle '
//s_tntblinfo[65].tabletype = 2

//s_tntblinfo[66].Table_name = 'U_OrderRqwp'
//s_tntblinfo[66].Table_dscrp = '生产计划工序表'
//s_tntblinfo[66].Sc_id_name = 'scid'
//s_tntblinfo[66].Indcolumn_name = 'OrderID'
//s_tntblinfo[66].thrIndcolumn_name = 'Procode'
//s_tntblinfo[66].fouindcolumn_name = ''
//s_tntblinfo[66].clearstr = 'truncate table U_OrderRqwp '
//s_tntblinfo[66].tabletype = 2

//s_tntblinfo[67].Table_name = 'U_OrderRqwp_safa'
//s_tntblinfo[67].Table_dscrp = '生产计划工序[沙发]表'
//s_tntblinfo[67].Sc_id_name = 'scid'
//s_tntblinfo[67].Indcolumn_name = 'OrderID'
//s_tntblinfo[67].thrIndcolumn_name = 'Procode'
//s_tntblinfo[67].fouindcolumn_name = ''
//s_tntblinfo[67].clearstr = 'truncate table U_OrderRqwp_safa '
//s_tntblinfo[67].tabletype = 2

//s_tntblinfo[68].Table_name = 'u_orderworkgroup_num'
//s_tntblinfo[68].Table_dscrp = '生产计划交接单'
//s_tntblinfo[68].Sc_id_name = 'billid'
//s_tntblinfo[68].Indcolumn_name = ''
//s_tntblinfo[68].thrIndcolumn_name = ''
//s_tntblinfo[68].fouindcolumn_name = ''
//s_tntblinfo[68].clearstr = 'truncate table u_orderworkgroup_num '
//s_tntblinfo[68].tabletype = 2
//
//s_tntblinfo[69].Table_name = 'u_orderworkgroup_nummx'
//s_tntblinfo[69].Table_dscrp = '生产计划交接单明细'
//s_tntblinfo[69].Sc_id_name = 'billid'
//s_tntblinfo[69].Indcolumn_name = 'printid'
//s_tntblinfo[69].thrIndcolumn_name = ''
//s_tntblinfo[69].fouindcolumn_name = ''
//s_tntblinfo[69].clearstr = 'truncate table u_orderworkgroup_nummx '
//s_tntblinfo[69].tabletype = 2

//s_tntblinfo[70].Table_name = 'u_orderworkgroup_time'
//s_tntblinfo[70].Table_dscrp = '生产计划工组调整时间'
//s_tntblinfo[70].Sc_id_name = 'billid'
//s_tntblinfo[70].Indcolumn_name = ''
//s_tntblinfo[70].thrIndcolumn_name = ''
//s_tntblinfo[70].fouindcolumn_name = ''
//s_tntblinfo[70].clearstr = 'truncate table u_orderworkgroup_time '
//s_tntblinfo[70].tabletype = 2
//
//s_tntblinfo[71].Table_name = 'u_orderworkgroup_timemx'
//s_tntblinfo[71].Table_dscrp = '生产计划工组调整时间明细'
//s_tntblinfo[71].Sc_id_name = 'billid'
//s_tntblinfo[71].Indcolumn_name = 'printid'
//s_tntblinfo[71].thrIndcolumn_name = ''
//s_tntblinfo[71].fouindcolumn_name = ''
//s_tntblinfo[71].clearstr = 'truncate table u_orderworkgroup_timemx '
//s_tntblinfo[71].tabletype = 2

s_tntblinfo[72].Table_name = 'u_outrepdef'
s_tntblinfo[72].Table_dscrp = '业务员表'
s_tntblinfo[72].Sc_id_name = 'outrepcode'
s_tntblinfo[72].Indcolumn_name = ''
s_tntblinfo[72].thrIndcolumn_name = ''
s_tntblinfo[72].fouindcolumn_name = ''
s_tntblinfo[72].clearstr = 'truncate table u_outrepdef '
s_tntblinfo[72].tabletype = 1

s_tntblinfo[73].Table_name = 'u_outware'
s_tntblinfo[73].Table_dscrp = '出仓单表'
s_tntblinfo[73].Sc_id_name = 'scid'
s_tntblinfo[73].Indcolumn_name = 'outwareid'
s_tntblinfo[73].thrIndcolumn_name = ''
s_tntblinfo[73].fouindcolumn_name = ''
s_tntblinfo[73].clearstr = 'truncate table u_outware '
s_tntblinfo[73].tabletype = 2

s_tntblinfo[74].Table_name = 'u_outwaremx'
s_tntblinfo[74].Table_dscrp = '出仓明细表'
s_tntblinfo[74].Sc_id_name = 'scid'
s_tntblinfo[74].Indcolumn_name = 'outwareid'
s_tntblinfo[74].thrIndcolumn_name = 'printid'
s_tntblinfo[74].fouindcolumn_name = ''
s_tntblinfo[74].clearstr = 'truncate table u_outwaremx '
s_tntblinfo[74].tabletype = 2

s_tntblinfo[75].Table_name = 'u_OutWare_move'
s_tntblinfo[75].Table_dscrp = '仓库调拨单表'
s_tntblinfo[75].Sc_id_name = 'scid'
s_tntblinfo[75].Indcolumn_name = 'outwareid'
s_tntblinfo[75].thrIndcolumn_name = ''
s_tntblinfo[75].fouindcolumn_name = ''
s_tntblinfo[75].clearstr = 'truncate table u_OutWare_move '
s_tntblinfo[75].tabletype = 2

///u_OutWaremovemx 111

s_tntblinfo[76].Table_name = 'u_PrdPF'
s_tntblinfo[76].Table_dscrp = '产品构成表'
s_tntblinfo[76].Sc_id_name = 'mtrlid'
s_tntblinfo[76].Indcolumn_name = 'pfcode'
s_tntblinfo[76].thrIndcolumn_name = 'pfgroup'
s_tntblinfo[76].fouindcolumn_name = 'SonMtrlid'
s_tntblinfo[76].clearstr = 'truncate table u_PrdPF '
s_tntblinfo[76].tabletype = 1

s_tntblinfo[77].Table_name='u_rap_money'
s_tntblinfo[77].Table_dscrp='出纳帐'
s_tntblinfo[77].Sc_id_name='rapmoneyid'
s_tntblinfo[77].Indcolumn_name=''
s_tntblinfo[77].thrIndcolumn_name=''
s_tntblinfo[77].fouindcolumn_name=''
s_tntblinfo[77].clearstr = 'truncate table u_rap_money '
s_tntblinfo[77].tabletype=-1

s_tntblinfo[78].Table_name = 'u_rs_empinfo'
s_tntblinfo[78].Table_dscrp = '人事表'
s_tntblinfo[78].Sc_id_name = 'empid'
s_tntblinfo[78].Indcolumn_name = ''
s_tntblinfo[78].thrIndcolumn_name = ''
s_tntblinfo[78].fouindcolumn_name = ''
s_tntblinfo[78].clearstr = 'truncate table u_rs_empinfo '
s_tntblinfo[78].tabletype = 1

s_tntblinfo[79].Table_name = 'u_rs_emprecord'
s_tntblinfo[79].Table_dscrp = '个人简历表'
s_tntblinfo[79].Sc_id_name = 'mxid'
s_tntblinfo[79].Indcolumn_name = ''
s_tntblinfo[79].thrIndcolumn_name = ''
s_tntblinfo[79].fouindcolumn_name = ''
s_tntblinfo[79].clearstr = 'truncate table u_rs_emprecord '
s_tntblinfo[79].tabletype = 1

s_tntblinfo[80].Table_name = 'u_rs_insure'
s_tntblinfo[80].Table_dscrp = '社保记录表'
s_tntblinfo[80].Sc_id_name = 'insureid'
s_tntblinfo[80].Indcolumn_name = ''
s_tntblinfo[80].thrIndcolumn_name = ''
s_tntblinfo[80].fouindcolumn_name = ''
s_tntblinfo[80].clearstr = 'truncate table u_rs_insure '
s_tntblinfo[80].tabletype = 1

s_tntblinfo[81].Table_name = 'u_rs_Train'
s_tntblinfo[81].Table_dscrp = '培训记录表'
s_tntblinfo[81].Sc_id_name = 'Trainid'
s_tntblinfo[81].Indcolumn_name = ''
s_tntblinfo[81].thrIndcolumn_name = ''
s_tntblinfo[81].fouindcolumn_name = ''
s_tntblinfo[81].clearstr = 'truncate table u_rs_Train '
s_tntblinfo[81].tabletype = 1

s_tntblinfo[82].Table_name = 'u_rs_moverecord'
s_tntblinfo[82].Table_dscrp = '调动记录表'
s_tntblinfo[82].Sc_id_name = 'moveid'
s_tntblinfo[82].Indcolumn_name = ''
s_tntblinfo[82].thrIndcolumn_name = ''
s_tntblinfo[82].fouindcolumn_name = ''
s_tntblinfo[82].clearstr = 'truncate table u_rs_moverecord '
s_tntblinfo[82].tabletype = 1

s_tntblinfo[83].Table_name = 'u_sale_price_list'
s_tntblinfo[83].Table_dscrp = '价格表'
s_tntblinfo[83].Sc_id_name = 'pricelistid'
s_tntblinfo[83].Indcolumn_name = ''
s_tntblinfo[83].thrIndcolumn_name = ''
s_tntblinfo[83].fouindcolumn_name = ''
s_tntblinfo[83].clearstr = 'truncate table u_sale_price_list '
s_tntblinfo[83].tabletype = 1

s_tntblinfo[84].Table_name = 'u_sale_price_mx'
s_tntblinfo[84].Table_dscrp = '价格表明细'
s_tntblinfo[84].Sc_id_name = 'pricelistid'
s_tntblinfo[84].Indcolumn_name = 'mtrlid'
s_tntblinfo[84].thrIndcolumn_name = ''
s_tntblinfo[84].fouindcolumn_name = ''
s_tntblinfo[84].clearstr = 'truncate table u_sale_price_mx '
s_tntblinfo[84].tabletype = 1

s_tntblinfo[85].Table_name = 'u_SaleTask'
s_tntblinfo[85].Table_dscrp = '销售订单表'
s_tntblinfo[85].Sc_id_name = 'scid'
s_tntblinfo[85].Indcolumn_name = 'TaskID'
s_tntblinfo[85].thrIndcolumn_name = ''
s_tntblinfo[85].fouindcolumn_name = ''
s_tntblinfo[85].clearstr = 'truncate table u_SaleTask '
s_tntblinfo[85].tabletype = 2

s_tntblinfo[86].Table_name = 'u_SaleTaskMx'
s_tntblinfo[86].Table_dscrp = '销售订单明细表'
s_tntblinfo[86].Sc_id_name = 'scid'
s_tntblinfo[86].Indcolumn_name = 'TaskID'
s_tntblinfo[86].thrIndcolumn_name = 'printid'
s_tntblinfo[86].fouindcolumn_name = ''
s_tntblinfo[86].clearstr = 'truncate table u_SaleTaskMx '
s_tntblinfo[86].tabletype = 2

//s_tntblinfo[87].Table_name = 'u_saletaskmx_mtrlchange'
//s_tntblinfo[87].Table_dscrp = '换料明细'
//s_tntblinfo[87].Sc_id_name = ''
//s_tntblinfo[87].Indcolumn_name = ''
//s_tntblinfo[87].thrIndcolumn_name = ''
//s_tntblinfo[87].fouindcolumn_name = ''
//s_tntblinfo[87].clearstr = 'truncate table u_saletaskmx_mtrlchange '
//s_tntblinfo[87].tabletype = 2

s_tntblinfo[88].Table_name = 'u_sc_abnormity'
s_tntblinfo[88].Table_dscrp = '异常计件单表'
s_tntblinfo[88].Sc_id_name = 'billid'
s_tntblinfo[88].Indcolumn_name = ''
s_tntblinfo[88].thrIndcolumn_name = ''
s_tntblinfo[88].fouindcolumn_name = ''
s_tntblinfo[88].clearstr = 'truncate table u_sc_abnormity '
s_tntblinfo[88].tabletype = 2

s_tntblinfo[89].Table_name = 'u_sc_abnormitymx'
s_tntblinfo[89].Table_dscrp = '异常计件单明细表'
s_tntblinfo[89].Sc_id_name = 'billid'
s_tntblinfo[89].Indcolumn_name = 'printid'
s_tntblinfo[89].thrIndcolumn_name = ''
s_tntblinfo[89].fouindcolumn_name = ''
s_tntblinfo[89].clearstr = 'truncate table u_sc_abnormitymx '
s_tntblinfo[89].tabletype = 2

//s_tntblinfo[90].Table_name = 'u_sc_abnormity_bill'
//s_tntblinfo[90].Table_dscrp = '返工返修赔偿单'
//s_tntblinfo[90].Sc_id_name = 'billid'
//s_tntblinfo[90].Indcolumn_name = ''
//s_tntblinfo[90].thrIndcolumn_name = ''
//s_tntblinfo[90].fouindcolumn_name = ''
//s_tntblinfo[90].clearstr = 'truncate table u_sc_abnormity_bill '
//s_tntblinfo[90].tabletype = 2

s_tntblinfo[91].Table_name = 'u_sc_taskwork'
s_tntblinfo[91].Table_dscrp = '计件单表'
s_tntblinfo[91].Sc_id_name = 'scid'
s_tntblinfo[91].Indcolumn_name = 'billid'
s_tntblinfo[91].thrIndcolumn_name = ''
s_tntblinfo[91].fouindcolumn_name = ''
s_tntblinfo[91].clearstr = 'truncate table u_sc_taskwork '
s_tntblinfo[91].tabletype = 2

s_tntblinfo[92].Table_name = 'u_sc_taskworkmx'
s_tntblinfo[92].Table_dscrp = '计件单明细表'
s_tntblinfo[92].Sc_id_name = 'Billid'
s_tntblinfo[92].Indcolumn_name = 'Empid'
s_tntblinfo[92].thrIndcolumn_name = 'Procode'
s_tntblinfo[92].fouindcolumn_name = 'scid'
s_tntblinfo[92].clearstr = 'truncate table u_sc_taskworkmx '
s_tntblinfo[92].tabletype = 2

s_tntblinfo[93].Table_name = 'u_sc_workgroup'
s_tntblinfo[93].Table_dscrp = '工组表'
s_tntblinfo[93].Sc_id_name = 'wrkGrpid'
s_tntblinfo[93].Indcolumn_name = ''
s_tntblinfo[93].thrIndcolumn_name = ''
s_tntblinfo[93].fouindcolumn_name = ''
s_tntblinfo[93].clearstr = 'truncate table u_sc_workgroup '
s_tntblinfo[93].tabletype = 1

//s_tntblinfo[94].Table_name = 'u_sc_workprice'
//s_tntblinfo[94].Table_dscrp = '产品工价表'
//s_tntblinfo[94].Sc_id_name = 'Mtrlid'
//s_tntblinfo[94].Indcolumn_name = 'procode'
//s_tntblinfo[94].thrIndcolumn_name = ''
//s_tntblinfo[94].fouindcolumn_name = ''
//s_tntblinfo[94].tabletype = 1
//
//s_tntblinfo[95].Table_name = 'u_sc_workprocedure'
//s_tntblinfo[95].Table_dscrp = '工序表'
//s_tntblinfo[95].Sc_id_name = 'proid'
//s_tntblinfo[95].Indcolumn_name = ''
//s_tntblinfo[95].thrIndcolumn_name = ''
//s_tntblinfo[95].fouindcolumn_name = ''
//s_tntblinfo[95].tabletype = 1

s_tntblinfo[96].Table_name = 'u_scdef'
s_tntblinfo[96].Table_dscrp = '分部设定'
s_tntblinfo[96].Sc_id_name = 'scid'
s_tntblinfo[96].Indcolumn_name = ''
s_tntblinfo[96].thrIndcolumn_name = ''
s_tntblinfo[96].fouindcolumn_name = ''
s_tntblinfo[96].clearstr = 'delete from u_scdef where scid <> 0 '
s_tntblinfo[96].tabletype = 1

s_tntblinfo[97].Table_name = 'u_spt'
s_tntblinfo[97].Table_dscrp = '供应商设定'
s_tntblinfo[97].Sc_id_name = 'sptid'
s_tntblinfo[97].Indcolumn_name = ''
s_tntblinfo[97].thrIndcolumn_name = ''
s_tntblinfo[97].fouindcolumn_name = ''
s_tntblinfo[97].clearstr = 'truncate table u_spt '
s_tntblinfo[97].tabletype = 1

s_tntblinfo[98].Table_name = 'u_spt_amerce'
s_tntblinfo[98].Table_dscrp = '罚款单表'
s_tntblinfo[98].Sc_id_name = 'scid'
s_tntblinfo[98].Indcolumn_name = 'billid'
s_tntblinfo[98].thrIndcolumn_name = ''
s_tntblinfo[98].fouindcolumn_name = ''
s_tntblinfo[98].clearstr = 'truncate table u_spt_amerce '
s_tntblinfo[98].tabletype = 2

s_tntblinfo[99].Table_name = 'u_spt_price'
s_tntblinfo[99].Table_dscrp = '供应商报价表'
s_tntblinfo[99].Sc_id_name = 'sptid'
s_tntblinfo[99].Indcolumn_name = 'mtrlid'
s_tntblinfo[99].thrIndcolumn_name = ''
s_tntblinfo[99].fouindcolumn_name = ''
s_tntblinfo[99].clearstr = 'truncate table u_spt_price '
s_tntblinfo[99].tabletype = 6

f_init_tntblinfo_2()

RETURN 0

end function