RE_PROSCHED_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |