资源描述：
《fam系统总帐部分数据字典》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、FAM系统部分数据字典一、测试环境：本次测试在FAM系统的TEST环境进行测试。TEST环境配置如下：TEST=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.158.176.29)(PORT=1522)))(CONNECT_DATA=(SERVICE_NAME=test2)))二、总帐模块：1、维度：帐套、组织、期间、币种+会计弹性域段值会计弹性域段值：电厂10段，物资公司7段SELECTse.id_flex_num,s.flex_value_s
2、et_name,se.flex_value_set_id,s.description,se.application_column_name,se.segment_name,s.*,se.*FROMfnd_id_flex_segmentsse,fnd_flex_value_setssWHEREs.flex_value_set_id=se.flex_value_set_idandse.id_flex_numin(50260,50259)orderbyse.id_flex_num,se.segment_num--公司段SE
3、GMENT1SELECTv.flex_value,v.descriptionFROMfnd_flex_value_setss,fnd_flex_values_vlvWHEREs.flex_value_set_name='HDPI_COMPANY'ANDs.flex_value_set_id=v.flex_value_set_idANDv.summary_flag='N'ORDERBYv.flex_value--青岛发电厂成本中心SEGMENT2SELECTv.flex_value,v.descriptionFROMf
4、nd_flex_value_setss,fnd_flex_values_vlvWHEREs.flex_value_set_name='HDPI_QD_DC_COST_CENTER'ANDs.flex_value_set_id=v.flex_value_set_idANDv.summary_flag='N'ORDERBYv.flex_value--会计科目SEGMENT3SELECTv.flex_value,v.descriptionFROMfnd_flex_value_setss,fnd_flex_values_vl
5、vWHEREs.flex_value_set_name='HDPI_ACCOUNTING'ANDs.flex_value_set_id=v.flex_value_set_idANDv.summary_flag='N'ORDERBYv.flex_value--青岛发电厂子目段4SELECTv.flex_value,v.descriptionFROMfnd_flex_value_setss,fnd_flex_values_vlvWHEREs.flex_value_set_name='HDPI_QD_DC_SUBACCOU
6、NTING'ANDs.flex_value_set_id=v.flex_value_set_idANDv.summary_flag='N'ORDERBYv.flex_value--投资期值SEGMENT6SELECTv.flex_value,v.descriptionFROMfnd_flex_value_setss,fnd_flex_values_vlvWHEREs.flex_value_set_name='HDPI_PERIOD'ANDs.flex_value_set_id=v.flex_value_set_idA
7、NDv.summary_flag='N'ORDERBYv.flex_value--机组SEGMENT7SELECTv.flex_value,v.descriptionFROMfnd_flex_value_setss,fnd_flex_values_vlvWHEREs.flex_value_set_name='HDPI_SET'ANDs.flex_value_set_id=v.flex_value_set_idANDv.summary_flag='N'ORDERBYv.flex_value--产品SEGMENT8SEL
8、ECTv.flex_value,v.descriptionFROMfnd_flex_value_setss,fnd_flex_values_vlvWHEREs.flex_value_set_name='HDPI_PRODUCT'ANDs.flex_value_set_id=v.flex_value_set_idANDv.summary_flag
