资源描述:
《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_val
2、ue_set_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_nu
3、m--公司段SEGMENT1SELECTv.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.desc
4、riptionFROMfnd_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,fn
5、d_flex_values_vlvWHEREs.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=
6、'HDPI_QD_DC_SUBACCOUNTING'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
7、_id=v.flex_value_set_idANDv.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'ORDERB
8、Yv.flex_value--产品SEGMENT8SELECTv.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