CNV_FAS_3

(SQL Table)
Index Back

AM Convert FAS LABLINFO.ASC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FAS_3001 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