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 |