CNV_FAS_3(SQL Table) |
Index Back |
|---|---|
AM Convert FAS LABLINFO.ASC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,3) | DECIMAL(9,3) NOT NULL | SYS Number | |
| 2 | FAS_3002 | Character(15) | VARCHAR2(15) NOT NULL | Asset GL Account Number |
| 3 | FAS_3003 | Character(15) | VARCHAR2(15) NOT NULL | Expense GL Account Number |
| 4 | FAS_3004 | Character(15) | VARCHAR2(15) NOT NULL | Accum GL Account Number |
| 5 | FAS_3005 | Character(6) | VARCHAR2(6) NOT NULL | Acquisition Date MMDDYY |
| 6 | FAS_3006 | Character(12) | VARCHAR2(12) NOT NULL | Department |
| 7 | FAS_3007 | Character(12) | VARCHAR2(12) NOT NULL | Location |
| 8 | FAS_3008 | Character(12) | VARCHAR2(12) NOT NULL | Insurance Category |
| 9 | FAS_3009 | Character(20) | VARCHAR2(20) NOT NULL | Custodian |
| 10 | FAS_3010 | Character(12) | VARCHAR2(12) NOT NULL | Purchase Order Number |
| 11 | FAS_3011 | Character(20) | VARCHAR2(20) NOT NULL | Manufacturer Serial Number |
| 12 | FAS_3012 | Character(25) | VARCHAR2(25) NOT NULL | Supplier/Manufacturer |
| 13 | FAS_3013 | Character(6) | VARCHAR2(6) NOT NULL | Warranty Date MMDDYY |
| 14 | FAS_3014 | Character(20) | VARCHAR2(20) NOT NULL | User Field 1 |
| 15 | FAS_3015 | Character(20) | VARCHAR2(20) NOT NULL | User Field 2 |
| 16 | FAS_3016 | Character(20) | VARCHAR2(20) NOT NULL | User Field 3 |
| 17 | FAS_3017 | Character(20) | VARCHAR2(20) NOT NULL | User Field 4 |
| 18 | FAS_3018 | Character(20) | VARCHAR2(20) NOT NULL | User Field 5 |
| 19 | FAS_3019 | Character(20) | VARCHAR2(20) NOT NULL | User Field 6 |
| 20 | FAS_3020 | Character(20) | VARCHAR2(20) NOT NULL | User Field 7 |
| 21 | FAS_3021 | Character(20) | VARCHAR2(20) NOT NULL | User Field 8 |
| 22 | FAS_3022 | Character(20) | VARCHAR2(20) NOT NULL | User Field 9 |
| 23 | FAS_3023 | Character(20) | VARCHAR2(20) NOT NULL | User Field 10 |