RE_LSA_SLS_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 SLS_CAT_ID Number(10,0) DECIMAL(10) NOT NULL Sales Category
4 BKP_HDR_ID Number(15,0) DECIMAL(15) NOT NULL Breakpoint Header ID
5 SLS_BKP_ID Number(10,0) DECIMAL(10) NOT NULL Sales Breakpoint ID
6 UPDATE_FLG Character(1) VARCHAR2(1) NOT NULL Update Flag
0=No Modification
1=Add
2=Change
3=Delete

Default Value: 0

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

Default Value: 2

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

Default Value: RE_LS_WRK.CURRENCY_CD

13 EFFDT_FROM Date(10) DATE Effective Date From
14 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
15 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
16 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
17 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
18 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.