RE_LS_SLS_CTG

(SQL Table)
Index Back

Lease Percent Rent

Contains percent rent sales reporting categories

# 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 SLS_CAT_ID Number(10,0) DECIMAL(10) NOT NULL Sales Category
3 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

4 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

5 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

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.