$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 = '' s_tntblinfo[1].Table_dscrp = '' s_tntblinfo[1].Sc_id_name = '' s_tntblinfo[1].Indcolumn_name = '' s_tntblinfo[1].thrIndcolumn_name = '' s_tntblinfo[1].fouindcolumn_name = '' s_tntblinfo[1].tabletype = -1 //1 s_tntblinfo[2].Table_name = 'cw_accset' s_tntblinfo[2].Table_dscrp = '帐套信息表' s_tntblinfo[2].Sc_id_name = 'accsetid' s_tntblinfo[2].Indcolumn_name = '' s_tntblinfo[2].thrIndcolumn_name = '' s_tntblinfo[2].fouindcolumn_name = '' s_tntblinfo[2].tabletype = 0 s_tntblinfo[3].Table_name = 'cw_assetcard' s_tntblinfo[3].Table_dscrp = '固定资产表' s_tntblinfo[3].Sc_id_name = 'accsetid' s_tntblinfo[3].Indcolumn_name = 'assetcardid' s_tntblinfo[3].thrIndcolumn_name = '' s_tntblinfo[3].fouindcolumn_name = '' s_tntblinfo[3].tabletype = 0 s_tntblinfo[4].Table_name = 'cw_assettype' s_tntblinfo[4].Table_dscrp = '固定资产类别表' s_tntblinfo[4].Sc_id_name = 'accsetid' s_tntblinfo[4].Indcolumn_name = 'assettypeid' s_tntblinfo[4].thrIndcolumn_name = '' s_tntblinfo[4].fouindcolumn_name = '' s_tntblinfo[4].tabletype = 0 s_tntblinfo[5].Table_name = 'cw_astbalance' s_tntblinfo[5].Table_dscrp = '累计折旧表' s_tntblinfo[5].Sc_id_name = 'accsetid' s_tntblinfo[5].Indcolumn_name = 'assetcardid' s_tntblinfo[5].thrIndcolumn_name = 'yearmon' s_tntblinfo[5].fouindcolumn_name = '' s_tntblinfo[5].tabletype = 0 s_tntblinfo[6].Table_name = 'cw_astclear' s_tntblinfo[6].Table_dscrp = '固定资产清理表' s_tntblinfo[6].Sc_id_name = 'accsetid' s_tntblinfo[6].Indcolumn_name = 'astclearid' s_tntblinfo[6].thrIndcolumn_name = '' s_tntblinfo[6].fouindcolumn_name = '' s_tntblinfo[6].tabletype = 0 s_tntblinfo[7].Table_name = 'cw_attachast' s_tntblinfo[7].Table_dscrp = '固定资产附加设备表' s_tntblinfo[7].Sc_id_name = 'accsetid' s_tntblinfo[7].Indcolumn_name = 'assetcardid' s_tntblinfo[7].thrIndcolumn_name = 'attachastname' s_tntblinfo[7].fouindcolumn_name = 'spectype' s_tntblinfo[7].tabletype = 0 s_tntblinfo[8].Table_name = 'cw_Balance' s_tntblinfo[8].Table_dscrp = '结余表' s_tntblinfo[8].Sc_id_name = 'accsetid' s_tntblinfo[8].Indcolumn_name = 'subaccsetid' s_tntblinfo[8].thrIndcolumn_name = 'SubID' s_tntblinfo[8].fouindcolumn_name = 'YearMon' s_tntblinfo[8].tabletype = 0 s_tntblinfo[9].Table_name = '' s_tntblinfo[9].Table_dscrp = '' s_tntblinfo[9].Sc_id_name = '' s_tntblinfo[9].Indcolumn_name = '' s_tntblinfo[9].thrIndcolumn_name = '' s_tntblinfo[9].fouindcolumn_name = '' s_tntblinfo[9].tabletype = 0 s_tntblinfo[10].Table_name = 'cw_banktype' s_tntblinfo[10].Table_dscrp = '结算方式表' s_tntblinfo[10].Sc_id_name = 'accsetid' s_tntblinfo[10].Indcolumn_name = 'banktypeid' s_tntblinfo[10].thrIndcolumn_name = '' s_tntblinfo[10].fouindcolumn_name = '' s_tntblinfo[10].tabletype = 0 s_tntblinfo[11].Table_name = '' s_tntblinfo[11].Table_dscrp = '' s_tntblinfo[11].Sc_id_name = '' s_tntblinfo[11].Indcolumn_name = '' s_tntblinfo[11].thrIndcolumn_name = '' s_tntblinfo[11].fouindcolumn_name = '' s_tntblinfo[11].tabletype = 0 s_tntblinfo[12].Table_name = 'cw_brief' s_tntblinfo[12].Table_dscrp = '凭证摘要表' s_tntblinfo[12].Sc_id_name = 'accsetid' s_tntblinfo[12].Indcolumn_name = 'briefid' s_tntblinfo[12].thrIndcolumn_name = '' s_tntblinfo[12].fouindcolumn_name = '' s_tntblinfo[12].tabletype = 0 s_tntblinfo[13].Table_name = 'cw_brieftype' s_tntblinfo[13].Table_dscrp = '凭证摘要类别表' s_tntblinfo[13].Sc_id_name = 'accsetid' s_tntblinfo[13].Indcolumn_name = 'brieftypeid' s_tntblinfo[13].thrIndcolumn_name = '' s_tntblinfo[13].fouindcolumn_name = '' s_tntblinfo[13].tabletype = 0 s_tntblinfo[14].Table_name = 'cw_calendar' s_tntblinfo[14].Table_dscrp = '日历表' s_tntblinfo[14].Sc_id_name = 'accsetid' s_tntblinfo[14].Indcolumn_name = 'cmonth' s_tntblinfo[14].thrIndcolumn_name = 'sdate' s_tntblinfo[14].fouindcolumn_name = 'edate' s_tntblinfo[14].tabletype = 0 //2 s_tntblinfo[15].Table_name = 'cw_CashItem' s_tntblinfo[15].Table_dscrp = '现金流量表' s_tntblinfo[15].Sc_id_name = 'accsetid' s_tntblinfo[15].Indcolumn_name = 'subaccsetid' s_tntblinfo[15].thrIndcolumn_name = 'CredID' s_tntblinfo[15].fouindcolumn_name = 'Flowid' s_tntblinfo[15].tabletype = 0 s_tntblinfo[16].Table_name = '' s_tntblinfo[16].Table_dscrp = '' s_tntblinfo[16].Sc_id_name = '' s_tntblinfo[16].Indcolumn_name = '' s_tntblinfo[16].thrIndcolumn_name = '' s_tntblinfo[16].fouindcolumn_name = '' s_tntblinfo[16].tabletype = 0 s_tntblinfo[17].Table_name = 'cw_credence' s_tntblinfo[17].Table_dscrp = '凭证表' s_tntblinfo[17].Sc_id_name = 'accsetid' s_tntblinfo[17].Indcolumn_name = 'subaccsetid' s_tntblinfo[17].thrIndcolumn_name = 'credid' s_tntblinfo[17].fouindcolumn_name = '' s_tntblinfo[17].tabletype = 0 s_tntblinfo[18].Table_name = 'cw_credencemx' s_tntblinfo[18].Table_dscrp = '凭证明细表' s_tntblinfo[18].Sc_id_name = 'accsetid' s_tntblinfo[18].Indcolumn_name = 'subaccsetid' s_tntblinfo[18].thrIndcolumn_name = 'credid' s_tntblinfo[18].fouindcolumn_name = 'fuluno' s_tntblinfo[18].tabletype = 0 s_tntblinfo[19].Table_name = 'cw_credence_auto' s_tntblinfo[19].Table_dscrp = '自动转帐[模式]凭证表' s_tntblinfo[19].Sc_id_name = 'accsetid' s_tntblinfo[19].Indcolumn_name = 'credid' s_tntblinfo[19].thrIndcolumn_name = '' s_tntblinfo[19].fouindcolumn_name = '' s_tntblinfo[19].tabletype = 0 s_tntblinfo[20].Table_name = 'cw_credencemx_auto' s_tntblinfo[20].Table_dscrp = '自动转帐[模式]凭证细表' s_tntblinfo[20].Sc_id_name = 'accsetid' s_tntblinfo[20].Indcolumn_name = 'credid' s_tntblinfo[20].thrIndcolumn_name = 'subid' s_tntblinfo[20].fouindcolumn_name = '' s_tntblinfo[20].tabletype = 0 s_tntblinfo[21].Table_name = 'cw_Credenceword' s_tntblinfo[21].Table_dscrp = '凭证字表' s_tntblinfo[21].Sc_id_name = 'accsetid' s_tntblinfo[21].Indcolumn_name = 'Credenceword' s_tntblinfo[21].thrIndcolumn_name = '' s_tntblinfo[21].fouindcolumn_name = '' s_tntblinfo[21].tabletype = 0 s_tntblinfo[22].Table_name = 'cw_currency' s_tntblinfo[22].Table_dscrp = '币种表' s_tntblinfo[22].Sc_id_name = 'accsetid' s_tntblinfo[22].Indcolumn_name = 'moneyid' s_tntblinfo[22].thrIndcolumn_name = '' s_tntblinfo[22].fouindcolumn_name = '' s_tntblinfo[22].tabletype = 0 s_tntblinfo[23].Table_name = 'cw_department' s_tntblinfo[23].Table_dscrp = '部门表' s_tntblinfo[23].Sc_id_name = 'accsetid' s_tntblinfo[23].Indcolumn_name = 'departmentid' s_tntblinfo[23].thrIndcolumn_name = '' s_tntblinfo[23].fouindcolumn_name = '' s_tntblinfo[23].tabletype = 0 s_tntblinfo[24].Table_name = 'cw_flow' s_tntblinfo[24].Table_dscrp = '现金流量表' s_tntblinfo[24].Sc_id_name = 'accsetid' s_tntblinfo[24].Indcolumn_name = 'flowid' s_tntblinfo[24].thrIndcolumn_name = '' s_tntblinfo[24].fouindcolumn_name = '' s_tntblinfo[24].tabletype = 0 s_tntblinfo[25].Table_name = 'cw_hsitem' s_tntblinfo[25].Table_dscrp = '项目表' s_tntblinfo[25].Sc_id_name = 'accsetid' s_tntblinfo[25].Indcolumn_name = 'hsitemid' s_tntblinfo[25].thrIndcolumn_name = '' s_tntblinfo[25].fouindcolumn_name = '' s_tntblinfo[25].tabletype = 0 s_tntblinfo[26].Table_name = 'cw_incrdecr' s_tntblinfo[26].Table_dscrp = '固定资产增加方式表' s_tntblinfo[26].Sc_id_name = 'accsetid' s_tntblinfo[26].Indcolumn_name = 'incrdecrid' s_tntblinfo[26].thrIndcolumn_name = '' s_tntblinfo[26].fouindcolumn_name = '' s_tntblinfo[26].tabletype = 0 s_tntblinfo[27].Table_name = 'cw_InitBalance' s_tntblinfo[27].Table_dscrp = '科目初始化表' s_tntblinfo[27].Sc_id_name = 'accsetid' s_tntblinfo[27].Indcolumn_name = 'SubID' s_tntblinfo[27].thrIndcolumn_name = '' s_tntblinfo[27].fouindcolumn_name = '' s_tntblinfo[27].tabletype = 0 s_tntblinfo[29].Table_name = '' s_tntblinfo[29].Table_dscrp = '' s_tntblinfo[29].Sc_id_name = '' s_tntblinfo[29].Indcolumn_name = '' s_tntblinfo[29].thrIndcolumn_name = '' s_tntblinfo[29].fouindcolumn_name = '' s_tntblinfo[29].tabletype = 0 s_tntblinfo[30].Table_name = '' s_tntblinfo[30].Table_dscrp = '' s_tntblinfo[30].Sc_id_name = '' s_tntblinfo[30].Indcolumn_name = '' s_tntblinfo[30].thrIndcolumn_name = '' s_tntblinfo[30].fouindcolumn_name = '' s_tntblinfo[30].tabletype = 0 s_tntblinfo[31].Table_name = '' s_tntblinfo[31].Table_dscrp = '' s_tntblinfo[31].Sc_id_name = '' s_tntblinfo[31].Indcolumn_name = '' s_tntblinfo[31].thrIndcolumn_name = '' s_tntblinfo[31].fouindcolumn_name = '' s_tntblinfo[31].tabletype = 0 s_tntblinfo[32].Table_name = 'cw_multibar' s_tntblinfo[32].Table_dscrp = '多栏帐表' s_tntblinfo[32].Sc_id_name = 'accsetid' s_tntblinfo[32].Indcolumn_name = 'multibarid' s_tntblinfo[32].thrIndcolumn_name = '' s_tntblinfo[32].fouindcolumn_name = '' s_tntblinfo[32].tabletype = 0 s_tntblinfo[33].Table_name = 'cw_multibarmx' s_tntblinfo[33].Table_dscrp = '多栏帐明细表' s_tntblinfo[33].Sc_id_name = 'accsetid' s_tntblinfo[33].Indcolumn_name = 'multibarid' s_tntblinfo[33].thrIndcolumn_name = 'itemno' s_tntblinfo[33].fouindcolumn_name = '' s_tntblinfo[33].tabletype = 0 s_tntblinfo[34].Table_name = '' s_tntblinfo[34].Table_dscrp = '' s_tntblinfo[34].Sc_id_name = '' s_tntblinfo[34].Indcolumn_name = '' s_tntblinfo[34].thrIndcolumn_name = '' s_tntblinfo[34].fouindcolumn_name = '' s_tntblinfo[34].tabletype = 0 s_tntblinfo[35].Table_name = 'cw_subject' s_tntblinfo[35].Table_dscrp = '会计科目表' s_tntblinfo[35].Sc_id_name = 'accsetid' s_tntblinfo[35].Indcolumn_name = 'subid' s_tntblinfo[35].thrIndcolumn_name = '' s_tntblinfo[35].fouindcolumn_name = '' s_tntblinfo[35].tabletype = 0 s_tntblinfo[36].Table_name = 'cw_usedtype' s_tntblinfo[36].Table_dscrp = '固定资产使用状况表' s_tntblinfo[36].Sc_id_name = 'accsetid' s_tntblinfo[36].Indcolumn_name = 'usedtypeid' s_tntblinfo[36].thrIndcolumn_name = '' s_tntblinfo[36].fouindcolumn_name = '' s_tntblinfo[36].tabletype = 0 s_tntblinfo[37].Table_name = '' s_tntblinfo[37].Table_dscrp = '' s_tntblinfo[37].Sc_id_name = '' s_tntblinfo[37].Indcolumn_name = '' s_tntblinfo[37].thrIndcolumn_name = '' s_tntblinfo[37].fouindcolumn_name = '' s_tntblinfo[37].tabletype = 0 s_tntblinfo[38].Table_name = '' s_tntblinfo[38].Table_dscrp = '' s_tntblinfo[38].Sc_id_name = '' s_tntblinfo[38].Indcolumn_name = '' s_tntblinfo[38].thrIndcolumn_name = '' s_tntblinfo[38].fouindcolumn_name = '' s_tntblinfo[38].tabletype = 0 s_tntblinfo[39].Table_name = '' s_tntblinfo[39].Table_dscrp = '' s_tntblinfo[39].Sc_id_name = 'accstid' s_tntblinfo[39].Indcolumn_name = '' s_tntblinfo[39].thrIndcolumn_name = '' s_tntblinfo[39].fouindcolumn_name = '' s_tntblinfo[39].tabletype = 0 s_tntblinfo[40].Table_name = '' s_tntblinfo[40].Table_dscrp = '' s_tntblinfo[40].Sc_id_name = '' s_tntblinfo[40].Indcolumn_name = '' s_tntblinfo[40].thrIndcolumn_name = '' s_tntblinfo[40].fouindcolumn_name = '' s_tntblinfo[40].tabletype = 0 s_tntblinfo[41].Table_name = '' s_tntblinfo[41].Table_dscrp = '' s_tntblinfo[41].Sc_id_name = '' s_tntblinfo[41].Indcolumn_name = '' s_tntblinfo[41].thrIndcolumn_name = '' s_tntblinfo[41].fouindcolumn_name = '' s_tntblinfo[41].tabletype = 0 s_tntblinfo[42].Table_name = '' s_tntblinfo[42].Table_dscrp = '' s_tntblinfo[42].Sc_id_name = '' s_tntblinfo[42].Indcolumn_name = '' s_tntblinfo[42].thrIndcolumn_name = '' s_tntblinfo[42].fouindcolumn_name = '' s_tntblinfo[42].tabletype = 0 s_tntblinfo[43].Table_name = '' s_tntblinfo[43].Table_dscrp = '' s_tntblinfo[43].Sc_id_name = '' s_tntblinfo[43].Indcolumn_name = '' s_tntblinfo[43].thrIndcolumn_name = '' s_tntblinfo[43].fouindcolumn_name = '' s_tntblinfo[43].tabletype = 0 s_tntblinfo[44].Table_name = 'reports' s_tntblinfo[44].Table_dscrp = '自定义报表' s_tntblinfo[44].Sc_id_name = 'accsetid' s_tntblinfo[44].Indcolumn_name = 'rid' s_tntblinfo[44].thrIndcolumn_name = 'cropid' s_tntblinfo[44].fouindcolumn_name = '' s_tntblinfo[44].tabletype = 0 RETURN 0 end function