RE_LSA_SLS_CTG

#	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	UPDATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Update Flag 0=No Modification 1=Add 2=Change 3=Delete Default Value: 0
5	TXN_GRP	Character(1)	VARCHAR2(1) NOT NULL	Transaction Group 1=Base Rent 2=Security Deposit 3=Straightline Accounting 4=Operating Expense 5=Percent Rent 6=Miscellaneous Rent 7=Manual Fee 8=Lease Obligation 9=Lease Interest Expense A=Prior Period Lease Obligation B=Prior Period Lease Interest C=Rent Expense D=Lease Incentive Default Value: 5
6	CHG_GRP_CD	Character(10)	VARCHAR2(10) NOT NULL	This field holds the Charge Group Code for the Transaction Groups. Prompt Table: RE_SLS_CAT
7	DST_ALLOC_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Distribution Allocation Method 1=Percentage 2=Amount 3=Area 4=None 5=Quantity Default Value: 4
8	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
9	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
10	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
11	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.