RE_LS_BKP

(SQL Table)
Index Back

Lease Breakpoints

Contains percent rent lease breakpoints

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key

Default Value: RE_LS.LS_KEY

2 BKP_HDR_ID Number(15,0) DECIMAL(15) NOT NULL Breakpoint Header ID
3 SLS_BKP_ID Number(10,0) DECIMAL(10) NOT NULL Sales Breakpoint ID
4 FROM_BKP Number(27,3) DECIMAL(26,3) NOT NULL From Breakpoint
5 TO_BKP Number(27,3) DECIMAL(26,3) NOT NULL To Breakpoint
6 BKP_OPERATOR Character(1) VARCHAR2(1) NOT NULL Breakpoint Operator
1=Amount
2=Percent
3=Amount & Percent

Default Value: 2

7 BKP_AMT Number(27,3) DECIMAL(26,3) NOT NULL Break Point Amount
8 BKP_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL Break Point Percent
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: RE_LS_WRK.CURRENCY_CD

10 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
11 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
12 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
13 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.