Q5/ws_objects/cw_bsnobj.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 = ''
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