笨笨乐园

BOM表结构

BOM_ALTERNATE_DESIGNATORS:类别(使用于Routing和BOM,建BOM时无对应Routing则取Primary)
      ORGANIZATION_ID:组织ID
      ALTERNATE_DESIGNATOR_CODE:类别代码

BOM_OPERATIONAL_ROUTINGS:料品制程主档表 --  BOM_OPERATIONAL_ROUTINGS_V
      ORGANIZATION_ID:组织ID
      ASSEMBLY_ITEM_ID:Assembly料品ID
      ALTERNATE_ROUTING_DESIGNATOR:类别(不选,则默认Primary,值为NULL)

      ROUTING_SEQUENCE_ID:制程主档Sequence

BOM_OPERATION_SEQUENCES:料品制程明细档表--  BOM_OPERATION_SEQUENCES_V
     ROUTING_SEQUENCE_ID:制程主档Sequence
     OPERATION_SEQUENCE_ID:制程明细Sequence

     OPERATION_SEQ_NUM:制程明细序号
     STANDARD_OPERATION_ID:制程明细对应的OP ID
     OPERATION_DESCRIPTION:OP名称


BOM_STRUCTURES_B:BOM主档--BOM_BILL_OF_MATERIALS_V
    ORGANIZATION_ID:
    ASSEMBLY_ITEM_ID:
    ALTERNATE_BOM_DESIGNATOR:

    BILL_SEQUENCE_ID

BOM_COMPONENTS_B:BOM明细档--BOM_INVENTORY_COMPONENTS_V
    BILL_SEQUENCE_ID:
    COMPONENT_SEQUENCE_ID:

    COMPONENT_ITEM_ID:
    COMPONENT_QUANTITY:
    OPERATION_SEQ_NUM:
    WIP_SUPPLY_TYPE:

posted on 2006-08-01 09:26  Angus  阅读(3543)  评论(0编辑  收藏  举报

导航