RE_MIN_LS

(SQL View)
 Index Back

Minimum Obligation Lease view

View for the Minimum Lease Obligation Report (Government Reports).

SELECT B.BUSINESS_UNIT , B.LS_KEY , B.TXN_GRP , A.LS_NBR , A.LEASE_NAME , A.LEASE_START_DT , A.LEASE_END_DT , A.CURRENCY_CD , B.FIRST_FY_AMT , B.SECOND_FY_AMT , B.THIRD_FY_AMT , B.FOURTH_FY_AMT , B.FIFTH_FY_AMT , B.THEREAFTER_AMT , B.TOTAL_AMT FROM PS_RE_LS A , PS_RE_BU_LS_DET B WHERE A.LS_KEY = B.LS_KEY AND A.BUSINESS_UNIT = B.BUSINESS_UNIT

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

Prompt Table: RE_BU_SRCH
Set Control Field: BUSINESS_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 LS_NBR Character(10) VARCHAR2(10) NOT NULL Lease Number, User Enterable or Generated Sequence Number
5 LEASE_NAME Character(60) VARCHAR2(60) NOT NULL Lease Name
6 LEASE_START_DT Date(10) DATE Lease Start Date
7 LEASE_END_DT Date(10) DATE Lease End Date
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Lease Currency

Prompt Table: CURRENCY_CD_TBL

9 FIRST_FY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL First Fiscal Year Amount. Used for the Minimum Lease Obligation (Government) Report.
10 SECOND_FY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Second Fiscal Year Amount. Used for the Minimum Lease Obligation (Government) Report.
11 THIRD_FY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Third Fiscal Year Amount. Used for the Minimum Lease Obligation (Government) Report.
12 FOURTH_FY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Fourth Fiscal Year Amount. Used for the Minimum Lease Obligation (Government) Report.
13 FIFTH_FY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Fifth Fiscal Year Amount. Used for the Minimum Lease Obligation (Government) Report.
14 THEREAFTER_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL There After Amount. Used for the Minimum Lease Obligation (Government) Report.
15 TOTAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Amount