RE_LSA_BKP

(SQL Table)
Index Back

Lease Amended Breakpoints

Contains percent rent sales reporting breakpoints by category.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
2 AMND_NBR Number(3,0) SMALLINT NOT NULL Amendment Number
3 BKP_HDR_ID Number(15,0) DECIMAL(15) NOT NULL Breakpoint Header ID
4 SLS_BKP_ID Number(10,0) DECIMAL(10) NOT NULL Sales Breakpoint ID
5 UPDATE_FLG Character(1) VARCHAR2(1) NOT NULL Update Flag
0=No Modification
1=Add
2=Change
3=Delete

Default Value: 0

6 FROM_BKP Number(27,3) DECIMAL(26,3) NOT NULL From Breakpoint
7 TO_BKP Number(27,3) DECIMAL(26,3) NOT NULL To Breakpoint
8 BKP_OPERATOR Character(1) VARCHAR2(1) NOT NULL Breakpoint Operator
1=Amount
2=Percent
3=Amount & Percent

Default Value: 2

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

Default Value: RE_LS_WRK.CURRENCY_CD

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