WM_STATDSPLY_RS

(SQL Table)
Index Back

Work Order Status Display rule

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTEXT_ID Character(30) VARCHAR2(30) NOT NULL Context ID
2 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
3 INTERNAL_STATUS 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 WO_STATUS_TYPE 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