CNV_FAS_4

(SQL Table)
Index Back

AM Convert FAS PROPTMGR.ASC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FAS_4001 Number(10,3) DECIMAL(9,3) NOT NULL SYS Number
2 FAS_4002 Character(6) VARCHAR2(6) NOT NULL Historical Acq Date MMDDYY
3 FAS_4003 Signed Number(13,2) DECIMAL(11,2) NOT NULL Historical Acquired Value
4 FAS_4004 Character(4) VARCHAR2(4) NOT NULL Depreciation Table Number
5 FAS_4005 Character(4) VARCHAR2(4) NOT NULL Appreciation Table Number
6 FAS_4006 Character(4) VARCHAR2(4) NOT NULL Tax Code
7 FAS_4007 Character(30) VARCHAR2(30) NOT NULL Tax Code Description