oracle ebs cmro核心表结构

1.主构型

AHL_MC_HEADERS_B/AHL_MC_HEADERS_TL:For MC Headers

—— MC是全局的,多语言管理。在系统中建立一条MC后,在后台数据表中会生成中文和美语两条记录

界面:



界面上字段描述:

  1. Description of fields related to master configuration records
    FieldDescription
    NameName for the configuration template hierarchy.
    DescriptionDescriptive text field.
    StatusChoices are: Complete, Draft, Approval Pending, Approval Rejected, Closed or Expired.
    PositionPosition in the assembly that is the topmost node of the master configuration hierarchy.
    Position DescriptionDescriptive text field for this position in the configuration hierarchy.
    ATA CodeAir Transport Association of America (ATA) codes, used for Minimum Equipment List (MEL) and Configuration Deviation List (CDL) functionality. See: Minimum Equipment List (MEL) and Configuration Deviation List (CDL) Setup
    QuantityNumber of items in the item selection option set for this position.
    UOMUnit of measure
    Start and End DatesEffectivity of this position in the configuration hierarchy.
    Item Group Name and DescriptionName for the set of item option selections at this node.
    Display OrderOrderthe configuration positions are displayed.
    RevisionThe revision number to indicate that the master configuration is under revision control. Revision control enables multiple configuration revisions to be active at one time. This is necessary because all of the units cannot be migrated to the new master configuration at the same time. During that transition phase the user will maintain units based on two different revisions of the same master configuration. This also aids in implementing configuration modifications throughout the master configuration life cycle.
    NecessityIndicates if position is mandatory or optional.
    ModelThe Model field is displayed on Create Master Configuration page if you associate Enigma Configuration information to Master Configuration. The Model field is used to identify the type of document. For example, if the model is PW4000, then this corresponds to Engine Maintenance Manual in Enigma.
etrm字段描述:


2.

AHL_MC_RELATIONSHIPS: For the MC nodes hierarchy 

——这张表用于记录在MC上的每一个节点信息(描述位置关系,查看节点的关系)


界面上字段描述


etrm字段描述:




  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值