RE_LS_TSCH_HIST

(SQL Table)
Index Back

Lease Term Schedule

Contains the schedule dates and amount for a lease financial term

# 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 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
3 AMND_NBR Number(3,0) SMALLINT NOT NULL Amendment Number
4 TRANS_DT Date(10) DATE Transaction Date
5 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
6 TERM_ID Number(10,0) DECIMAL(10) NOT NULL Financial Term ID
7 SCHED_DATE Date(10) DATE Schedule Date
8 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
9 OBLIGATION_REDUCE Signed Number(28,3) DECIMAL(26,3) NOT NULL Obligation Reduction
10 INTEREST_PAYMENT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment that goes towards paying the interest.
11 INTEREST_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Interest Amount
12 PRINCIPAL_ID Character(15) VARCHAR2(15) NOT NULL Landlord/Tenant
13 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
14 STRLN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Straight Line Amount
15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
16 PRORATION_RATE Number(14,10) DECIMAL(13,10) NOT NULL Proration Rate
17 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

18 SCHED_NUM Number(5,0) INTEGER NOT NULL Team sequence number
19 PLP_FLG Character(1) VARCHAR2(1) NOT NULL Prior Lease Period Flag
N=No
Y=Yes

Default Value: N

20 LEASE_EXPIRED_FLG Character(1) VARCHAR2(1) NOT NULL Lease Expire Flag

Default Value: N

21 LS_TRM_SCHD_STATUS Character(1) VARCHAR2(1) NOT NULL Lease Term Schedule Status
0=In Progress
1=Pending
2=Generated
3=Canceled
22 ESC_CATCHUP_STATUS Character(1) VARCHAR2(1) NOT NULL Escalation Catchup Status
1=Pending
2=Done
3=Ignore

Default Value: 3

23 ESC_CATCHUP_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Escalation Catchup Amount
24 GENERATED_DATE Date(10) DATE Generated Date
25 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
26 START_DT Date(10) DATE Start Date
27 END_DT Date(10) DATE End Date