笨笨乐园

WIP表结构

WIP_DISCRETE_JOBS:JOB主表
     ORGANIZATION_ID:组织ID
     WIP_ENTITY_ID:       JOB ID

     STATUS_TYPE:          STATUS
     PRIMARY_ITEM_ID: Assembly Item ID
     START_QUANTITY: Start Qty
     NET_QUANTITY:       Net Qty
     COMMON_ROUTING_SEQUENCE_ID:
     COMMON_BOM_SEQUENCE_ID:

WIP_OPERATIONS:JOB OP表
     ORGANIZATION_ID:组织ID
     WIP_ENTITY_ID:      JOB ID
     OPERATION_SEQ_NUM

     NEXT_OPERATION_SEQ_NUM
     SCHEDULED_QUANTITY
     QUANTITY_IN_QUEUE
     QUANTITY_RUNNING
     QUANTITY_WAITING_TO_MOVE
     QUANTITY_REJECTED
     QUANTITY_SCRAPPED
     QUANTITY_COMPLETED

WIP_REQUIREMENT_OPERATIONS:JOB用料表
     ORGANIZATION_ID:
     WIP_ENTITY_ID:
      OPERATION_SEQ_NUM:
      INVENTORY_ITEM_ID:

      REQUIRED_QUANTITY:
      QUANTITY_ISSUED:
    

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

导航