IN_WO_TASK_VW(SQL View) |
Index Back |
---|---|
Work Order Tasks in Task Rec10/19/05 MEG CN#IN900: Added WO_INV_COMMIT_RULE. |
SELECT DISTINCT b.business_unit_in , a.business_unit , a.wo_id , a.wo_task_id , %Substring(a.descr254,1,30) , a.asset_id , a.location , a.currency_cd , a.sched_start_dt , a.sched_start_time , a.wo_inv_commit_rule , a.wo_reserve_rule , a.priority_nbr FROM PS_WM_WO_TSK a , ps_bus_unit_tbl_wm b WHERE a.internal_status NOT IN ('05','06','07') AND b.business_unit = a.business_unit |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
3 | WO_ID | Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
4 | WO_TASK_ID | Number(5,0) | INTEGER NOT NULL | Task Number |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
6 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
7 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
9 | SCHED_START_DT | Date(10) | DATE | Scheduled Start Date |
10 | SCHED_START_TIME | Time(15) | TIMESTAMP | Schedule Start Time |
11 | 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 |
12 | 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 |
13 | PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL | Priority |