RE_LS_ST_SCH_VW

(SQL View)
 Index Back

Lease Straightline View

Lease Straightline View

SELECT I.BUSINESS_UNIT , A.LS_KEY , C.BUSINESS_UNIT_AM , C.ASSET_ID , C.ASSET_SEQ_NBR , C.ASSET_CLASSIFY , C.AMND_NBR , C.ROUNDING_APPLIED , AMND.TRANS_DT , AMND.ACCOUNTING_DT , I.PRORATE_LS_EXP , A.TERM_RENT_TYPE , B.STLINE_KEY , B.STLINE_SCH_KEY , B.FISCAL_YEAR , B.ACCOUNTING_PERIOD , D.END_DT , C.DST_ALLOC_METHOD , DST.DISTRIBUTION_ID , %Coalesce(DST.PERCENTAGE, 100) , CASE WHEN A.TERM_RENT_TYPE IN ('04' , '10') THEN %Coalesce(DST.CF_SEQNO_EXP, C.CF_SEQNO_EXP) WHEN A.TERM_RENT_TYPE = '09' THEN %Coalesce(DST.CF_SEQNO_INC, C.CF_SEQNO_INC) ELSE %Coalesce(DST.CF_SEQNO, C.CF_SEQNO) END , C.STLINE_PRORATE_RT , B.ACTUAL_AMT , B.STLINE_AMT , (B.STLINE_AMT - B.ACTUAL_AMT) , %Sql(RE_ASSET_STAMT_CALC, CD.DECIMAL_POSITIONS, (B.STLINE_AMT - B.ACTUAL_AMT), A.TERM_RENT_TYPE, C.STLINE_PRORATE_RT, C.PVLP_STLINE_RATE) , B.CURRENCY_CD , C.RATE_MULT , C.RATE_DIV , CD.DECIMAL_POSITIONS , C2.DECIMAL_POSITIONS FROM PS_RE_STLINE A , PS_RE_STLINE_SCH B , PS_CAL_DETP_TBL D , PS_SET_CNTRL_REC G , PS_RE_LS I , PS_RE_LSA AMND , PS_BU_AM_BOOK_VW BK , PS_CURRENCY_CD_TBL C2 , PS_CURRENCY_CD_TBL CD , PS_RE_LSA_PPTY C LEFT OUTER JOIN PS_RE_LSA_AST_DST DST ON (DST.LS_KEY = C.LS_KEY AND DST.AMND_NBR = C.AMND_NBR AND DST.ASSET_SEQ_NBR = C.ASSET_SEQ_NBR) WHERE A.STLINE_KEY = B.STLINE_KEY AND A.LS_KEY = C.LS_KEY AND A.LS_KEY = I.LS_KEY AND D.CALENDAR_ID = A.CALENDAR_ID AND D.FISCAL_YEAR = B.FISCAL_YEAR AND D.ACCOUNTING_PERIOD = B.ACCOUNTING_PERIOD AND A.REGENERATE = 'N' AND D.SETID = G.SETID AND G.RECNAME = 'CAL_DETP_TBL' AND G.SETCNTRLVALUE = C.BUSINESS_UNIT_AM AND AMND.LS_KEY = I.LS_KEY AND AMND.AMND_NBR = C.AMND_NBR AND BK.BUSINESS_UNIT = C.BUSINESS_UNIT_AM AND BK.BOOK = BK.LEASE_BOOK AND C2.CURRENCY_CD = BK.CURRENCY_CD AND CD.CURRENCY_CD = I.CURRENCY_CD AND %EffdtCheck(CURRENCY_CD_TBL, CD, %CurrentDateIn) AND %EffdtCheck(CURRENCY_CD_TBL, C2, %CurrentDateIn) AND CD.EFF_STATUS = 'A' AND C2.EFF_STATUS = 'A' AND C.AMND_NBR = (%Coalesce( (SELECT MAX(AMND_NBR) FROM PS_RE_LSA H WHERE H.LS_KEY = A.LS_KEY AND AMND_STATUS <> '1' AND (H.TRANS_DT <= D.BEGIN_DT OR H.TRANS_DT BETWEEN D.BEGIN_DT AND D.END_DT) ), (SELECT MAX(AMND_NBR) FROM PS_RE_LSA H WHERE H.LS_KEY = A.LS_KEY AND AMND_STATUS <> '1' ) ))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_RE Character(5) VARCHAR2(5) NOT NULL RE Business Unit
2 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
5 ASSET_SEQ_NBR Number(5,0) INTEGER NOT NULL Asset Sequence Number
6 ASSET_CLASSIFY Character(1) VARCHAR2(1) NOT NULL Field for Lease Classification
C=Finance
O=Operating
7 AMND_NBR Number(3,0) SMALLINT NOT NULL Amendment Number
8 ROUNDING_APPLIED Character(1) VARCHAR2(1) NOT NULL Rounding Applied
N=No
Y=Yes
9 TRANS_DT Date(10) DATE Transaction Date
10 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
11 PRORATE_LS_EXP Character(1) VARCHAR2(1) NOT NULL Recognize Monthly Expense
12 TERM_RENT_TYPE Character(2) VARCHAR2(2) NOT NULL List of Rent Type for Transaction Group
00=Residual Value
01=Base Rent
02=Operating Expense
03=Miscellaneous Rent
04=Initial Direct Cost
05=Prepaid Rent
06=Purchase Option
07=Renewal Option
08=Penality Option
09=Lease Incentives
10=Prepaid Rent
13 STLINE_KEY Number(15,0) DECIMAL(15) NOT NULL Straightline Key - Number (15)
14 STLINE_SCH_KEY Number(15,0) DECIMAL(15) NOT NULL Straightline Schedule Key - Number (15)
15 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
16 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
17 END_DT Date(10) DATE End Date
18 DST_ALLOC_METHOD Character(1) VARCHAR2(1) NOT NULL Distribution Allocation Method
1=Percentage
2=Amount
3=Area
4=None
5=Quantity
19 DISTRIBUTION_ID Number(5,0) INTEGER NOT NULL Distribution ID
20 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
21 CF_SEQNO Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
22 STLINE_PRORATE_RT Number(14,10) DECIMAL(13,10) NOT NULL Straightline Proration Rate
23 ACTUAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Amount field for the Actual V Budgeted Pagelet
24 STLINE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Straightline Amount - Signed Number (23.3)
25 ACCR_DEFR_TOT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Accrual/ Deferral Amount
26 ACCR_DEFR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Accrual/ Deferral Amount
27 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
28 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
29 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
30 DECIMAL_POSITIONS Number(2,0) SMALLINT NOT NULL Decimal Positions
31 DECIMAL_POSITIONS2 Number(2,0) SMALLINT NOT NULL Decimal Positions