RS_2020TUTR_WS2

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DATE_REPORT Date(10) DATE Report Date
2 DATA_POINT Character(3) VARCHAR2(3) NOT NULL Data Point
3 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
4 OPT_REALIZATION Number(27,3) DECIMAL(26,3) NOT NULL Optimal Revenue
5 DIFFERENCE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Difference Amount
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50