FAM系统总帐分数据字典.docVIP

FAM系统部分数据字典 测试环境： 本次测试在FAM系统的TEST环境进行测试。TEST环境配置如下： TEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.158.176.29)(PORT = 1522)) ) (CONNECT_DATA = (SERVICE_NAME = test2) ) ) 总帐模块： 维度：帐套、组织、期间、币种 + 会计弹性域段值 会计弹性域段值：电厂10段，物资公司 7段 SELECT se.id_flex_num, s.flex_value_set_name, se.flex_value_set_id, s.description, se.application_column_name, se.segment_name, s.*, se.* FROM fnd_id_flex_segments se, fnd_flex_value_sets s WHERE s.flex_value_set_id = se.flex_value_set_id and se.id_flex_num in( 50260,50259) order by se.id_flex_num,se.segment_num --公司段 SEGMENT1 SELECT v.flex_value,v.description FROM fnd_flex_value_sets s,fnd_flex_values_vl v WHERE s.flex_value_set_name = HDPI_COMPANY AND s.flex_value_set_id = v.flex_value_set_id AND v.summary_flag = N ORDER BY v.flex_value --青岛发电厂成本中心 SEGMENT2 SELECT v.flex_value,v.description FROM fnd_flex_value_sets s,fnd_flex_values_vl v WHERE s.flex_value_set_name = HDPI_QD_DC_COST_CENTER AND s.flex_value_set_id = v.flex_value_set_id AND v.summary_flag = N ORDER BY v.flex_value --会计科目 SEGMENT3 SELECT v.flex_value,v.description FROM fnd_flex_value_sets s,fnd_flex_values_vl v WHERE s.flex_value_set_name = HDPI_ACCOUNTING AND s.flex_value_set_id = v.flex_value_set_id AND v.summary_flag = N ORDER BY v.flex_value --青岛发电厂子目段 4 SELECT v.flex_value,v.description FROM fnd_flex_value_sets s,fnd_flex_values_vl v WHERE s.flex_value_set_name = HDPI_QD_DC_SUBACCOUNTING AND s.flex_value_set_id = v.flex_value_set_id AND v.summary_flag = N ORDER BY v.flex_value --投资期值 SEGMENT6 SELECT v.flex_value,v.description FROM fnd_flex_value_sets s,fnd_flex_values_vl v WHERE s.flex_value_set_name = HDPI_PERIOD AND s.flex_value_set_id = v.flex_value_set_id AND v.summary_flag = N ORDER BY v.flex_value --机组 SEGMENT7 SELECT v.flex_value,v.description FROM fnd_flex_value_sets s,fnd_flex_values_vl v W