WM_SHOP_TYPE(SQL Table) |
Index Back |
|---|---|
Shop Work Order TypeShop and Work Order Type record. Used to setup commit/reservation rules by shop and work order type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SHOP_ID |
Character(10) | VARCHAR2(10) NOT NULL | Shop Identification |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: WM_SHOP_HDR.EFFDT |
| 4 | WO_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Work Order Type
Prompt Table: WM_WO_TYPE |
| 5 | WO_INV_COMMIT_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Inventory commit rule, when to commit inventory for Work Management
1=Parts List Creation 2=Pick Plan Creation 3=Work Order Status Change 4=Commit at Reserve |
| 6 | WO_INV_COMMIT_DEF | Character(1) | VARCHAR2(1) NOT NULL |
Bank Flag
D=Default S=Specify Default Value: D |
| 7 | INTERNAL_STAT_COMM | Character(2) | VARCHAR2(2) NOT NULL |
Work Order commit rule internal status.
02=Awaiting Schedule 03=Scheduled 04=Work In Progress |
| 8 | WO_RESERVE_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Work Order Reservation rule
1=Parts List Creation 2=Pick Plan Creation 3=Work Order Status Change 4=Batch Reserve Only |
| 9 | WO_RESERVE_DEF | Character(1) | VARCHAR2(1) NOT NULL |
Work Order Reservation default for shop setup
D=Default S=Specify Default Value: D |
| 10 | INTERNAL_STAT_RSRV | Character(2) | VARCHAR2(2) NOT NULL |
Work Order Reservation rule internal status.
02=Awaiting Schedule 03=Scheduled 04=Work In Progress |
| 11 | PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL | Priority |