RE_LSOPTIMIZE_P

(SQL Table)
Index Back

Lease Optimization pagelet

REM Pagelet: Leases Optimization Pagelet Data (temporary data), refreshed by application Engine.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: RE_BUS_UNIT

2 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
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
4 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
5 PERIOD_CTR Number(12,0) DECIMAL(12) NOT NULL Period Counter
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURR_CD_EFF_VW

7 REGION Character(30) VARCHAR2(30) NOT NULL Geographic Region
8 TOTAL_COSTS Number(27,3) DECIMAL(26,3) NOT NULL Total Amount
9 TOTAL_REVENUE Number(27,3) DECIMAL(26,3) NOT NULL Total Revenue
10 TOT_PAYAREA Number(18,3) DECIMAL(17,3) NOT NULL Total Payables Lease Area
11 TOT_SUBLSAREA Number(18,3) DECIMAL(17,3) NOT NULL Area for Subleases