RE_LS_SLSBKP_H (SQL Table)	Index Back
Sales Breakpoint Header This record will store the effective date and effective status for the sales breakpoints.

RE_LS_SLSBKP_H

(SQL Table)

Sales Breakpoint Header

This record will store the effective date and effective status for the sales 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

2 SLS_CAT_ID Number(10,0) DECIMAL(10) NOT NULL Sales Category

3 BKP_HDR_ID Number(15,0) DECIMAL(15) NOT NULL Breakpoint Header ID

4 EFFDT_FROM Date(10) DATE Effective Date From
Default Value: %date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

6 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.

7 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.

8 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.

9 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.

#	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	SLS_CAT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Sales Category
3	BKP_HDR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Breakpoint Header ID
4	EFFDT_FROM	Date(10)	DATE	Effective Date From Default Value: %date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
7	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
8	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
9	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.