GVT_WIP_STATUS(SQL Table) |
Index Back |
|---|---|
WIP Status Data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GVT_WIP_RECORD |
Character(25) | VARCHAR2(25) NOT NULL | Transaction |
| 2 | GVT_WIP_STATUS |
Character(3) | VARCHAR2(3) NOT NULL | Work-in-Progress Status |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | GVT_WORK_IN_PROGRS | Character(1) | VARCHAR2(1) NOT NULL |
Work in Progress?
Y/N Table Edit Default Value: N |
| 6 | GVT_SF52_AREA | Character(3) | VARCHAR2(3) NOT NULL |
SF-52 Print Area
A-5=Part A - Box 5: Requested By A-6=Part A - Box 6: Authorized By C-A=Part C - Line A C-B=Part C - Line B C-C=Part C - Line C C-S=Part C - Signature |
| 7 | GVT_INSERT_ALLOWED | Character(1) | VARCHAR2(1) NOT NULL |
Allow Row Insert?
Y/N Table Edit Default Value: N |
| 8 | GVT_STATUS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Status Type
CAN=Cancelled COM=Completed COR=Corrected IRR=IRR Reported WIP=Work-in-progress Default Value: WIP |
| 9 | GVT_HIDE_CANCEL | Character(1) | VARCHAR2(1) NOT NULL |
Hide Canceled Data?
Y/N Table Edit Default Value: N |
| 10 | GVT_ALLOW_SF50 | Character(1) | VARCHAR2(1) NOT NULL |
Allow SF-50 Print?
Y/N Table Edit Default Value: N |