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 |