RE_LS_TRM_SCHED

#	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	TERM_ID	Number(10,0)	DECIMAL(10) NOT NULL	Financial Term ID
5	SCHED_DATE	Date(10)	DATE	Schedule Date
6	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
7	OBLIGATION_REDUCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Obligation Reduction
8	INTEREST_PAYMENT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment that goes towards paying the interest.
9	INTEREST_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Interest Amount
10	PRINCIPAL_ID	Character(15)	VARCHAR2(15) NOT NULL	Landlord/Tenant
11	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
12	STRLN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Straight Line Amount
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
14	PRORATION_RATE	Number(14,10)	DECIMAL(13,10) NOT NULL	Proration Rate
15	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
16	SCHED_NUM	Number(5,0)	INTEGER NOT NULL	Team sequence number
17	PLP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prior Lease Period Flag N=No Y=Yes Default Value: N
18	LS_TRM_SCHD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Lease Term Schedule Status 0=In Progress 1=Pending 2=Generated 3=Canceled
19	ESC_CATCHUP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Escalation Catchup Status 1=Pending 2=Done 3=Ignore Default Value: 3
20	ESC_CATCHUP_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Escalation Catchup Amount
21	GENERATED_DATE	Date(10)	DATE	Generated Date
22	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
23	START_DT	Date(10)	DATE	Start Date
24	END_DT	Date(10)	DATE	End Date