WM_STATDSPLY_RS(SQL Table) |
Index Back |
---|---|
Work Order Status Display rule |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | Context ID | |
2 | Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. | |
3 | Character(2) | VARCHAR2(2) NOT NULL |
Internal Status
01=Open 02=Awaiting Schedule 03=Scheduled 04=Work In Progress 05=Complete 06=Closed 07=Canceled 08=On Hold 09=Work Order Created |
|
4 | Character(1) | VARCHAR2(1) NOT NULL |
Status Type
1=Header 2=Task 3=Service Request |
|
5 | ALLOW_INSERTS_SW | Character(1) | VARCHAR2(1) NOT NULL |
Allow Inserts
1=Allow Inserts 2=Allow Deletes 3=Allow Both 4=Don't allow inserts or deletes 5=Bypass 6=Inspect Lbr Assignments 7=Inspect Tools Assignments 8=Inspect Inventory Assignments 9=Inspect POs A=Inspect Standing Work Order B=Inspect Labor Assignment C=Inspect Tools Assignment D=Inspect Inventory Assignment E=Inspect PO's Assignment F=Assignments Exist on WO G=Assignments Exist Ext H=Inspect Lbr Actuals/Assgm Default Value: 3 |
6 | ALLOW_DELETES_SW | Character(1) | VARCHAR2(1) NOT NULL |
Allow Deletes
Y/N Table Edit Default Value: Y |