RE_PROSCHED_AET

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
3 TERM_ID Number(10,0) DECIMAL(10) NOT NULL Financial Term ID
4 TERM_SCHED_ID Number(30,0) DECIMAL(30) NOT NULL Lease Term Schedule ID
5 SCHED_NUM Number(5,0) INTEGER NOT NULL Team sequence number
6 CALC_ESC_CATCHUP Character(1) VARCHAR2(1) NOT NULL Calculate Escalation Catchup
7 ESC_CATCHUP_STATUS Character(1) VARCHAR2(1) NOT NULL Escalation Catchup Status
1=Pending
2=Done
3=Ignore
8 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
9 STRLN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Straight Line Amount
10 CATCH_UP_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Catch Up Amount
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
12 PREV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Previous Amount
13 PRIOR_PER_DIF Signed Number(13,2) DECIMAL(11,2) NOT NULL Prior Period Difference for Opex Audit
14 SCHED_DATE Date(10) DATE Schedule Date
15 PRORATION_RATE Number(14,10) DECIMAL(13,10) NOT NULL Proration Rate
16 START_DT Date(10) DATE Start Date
17 END_DT Date(10) DATE End Date
18 CAPITALIZE_SW Character(1) VARCHAR2(1) NOT NULL Capitalized