RS_2090AVST_TMP(SQL Table) |
Index Back |
|---|---|
hold view results for AVST |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NEW_DATE | Date(10) | DATE | Service Order New Date |
| 2 | CLOSED_DATE | Date(10) | DATE | Service Order Closed Date |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | SO_ID | Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 5 | QTY_INTEGER | Number(11,0) | DECIMAL(11) NOT NULL | Quantity Rounded to 0 Decimals |
| 6 | ASSIGNED_TO | Character(30) | VARCHAR2(30) NOT NULL | Assigned To |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | SO_PRIORITY | Character(10) | VARCHAR2(10) NOT NULL | Service Order Priority |