AR_PE_DEDAM_CHT

(SQL Table)
Index Back

Deduction by Amt Chart

This record is used for charting on the Deduction by Amount pagelet.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 PERIOD_COUNTER Number(7,0) INTEGER NOT NULL PERIOD COUNTER
3 AR_DATA_SERIES Character(1) VARCHAR2(1) NOT NULL Used to indicate a data series value for charting stacked graphs.
4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
5 AMT1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Used in Virtual Approver to store the various rule amounts that go on each approval step
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code