TERM_SCHED_IDSEQ_NUMSCHED_TYPEC=Capital Interim Rent
I=Interim Rent
N=Normal Rent
R=Reversal Normal Rent
S=Reversal Interim Rent
T=Reversal Capital Interim
X=Normal Rent Reverted
Y=Interim Reverted
Z=Capital Interim Reverted
Default Value: N
RE_LS_INT_SCHED(SQL Table) |
Index Back |
|---|---|
Interst Expense ScheduleLease Interest Expense Schedule |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TERM_SCHED_ID |
Number(30,0) | DECIMAL(30) NOT NULL | Lease Term Schedule ID |
| 2 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 3 | SCHED_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Schedule Type
C=Capital Interim Rent I=Interim Rent N=Normal Rent R=Reversal Normal Rent S=Reversal Interim Rent T=Reversal Capital Interim X=Normal Rent Reverted Y=Interim Reverted Z=Capital Interim Reverted Default Value: N |
| 4 | SCHED_DATE | Date(10) | DATE | Schedule Date |
| 5 | LS_KEY | Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | INTEREST_EXPENSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Interest Expense |
| 8 | INTEREST_ACCRUAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Interest calculated |
| 9 | AMORTIZATION_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amortization Amount |