RE_LS_STLINE_VW

(SQL View)
 Index Back

Lease Straightline View

Lease Straightline View

SELECT A.LS_KEY , A.BUSINESS_UNIT , A.ASSET_ID , A.ASSET_SEQ_NBR , A.ASSET_CLASSIFY , A.AMND_NBR , A.ROUNDING_APPLIED , A.PRORATE_LS_EXP , A.TRANS_DT , A.ACCOUNTING_DT , A.TERM_RENT_TYPE , A.STLINE_KEY , A.STLINE_SCH_KEY , A.FISCAL_YEAR , A.ACCOUNTING_PERIOD , A.END_DT , A.DST_ALLOC_METHOD , A.PERCENTAGE , A.CF_SEQNO , A.STLINE_PRORATE_RT , A.ACTUAL_AMT , A.STLINE_AMT , A.ACCR_DEFR_TOT_AMT , A.ACCR_DEFR_AMT , %Sql(RE_BASE_AMT_CONV, A.DECIMAL_POSITIONS, A.ACCR_DEFR_TOT_AMT, A.RATE_MULT, A.RATE_DIV) , %Sql(RE_BASE_AMT_CONV, A.DECIMAL_POSITIONS, A.ACCR_DEFR_AMT, A.RATE_MULT, A.RATE_DIV) , A.CURRENCY_CD FROM PS_RE_LS_SL A

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
4 ASSET_SEQ_NBR Number(5,0) INTEGER NOT NULL Asset Sequence Number
5 ASSET_CLASSIFY Character(1) VARCHAR2(1) NOT NULL Field for Lease Classification
C=Finance
O=Operating
6 AMND_NBR Number(3,0) SMALLINT NOT NULL Amendment Number
7 ROUNDING_APPLIED Character(1) VARCHAR2(1) NOT NULL Rounding Applied
N=No
Y=Yes
8 PRORATE_LS_EXP Character(1) VARCHAR2(1) NOT NULL Recognize Monthly Expense
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 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
12 STLINE_KEY Number(15,0) DECIMAL(15) NOT NULL Straightline Key - Number (15)
13 STLINE_SCH_KEY Number(15,0) DECIMAL(15) NOT NULL Straightline Schedule Key - Number (15)
14 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
15 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.
16 END_DT Date(10) DATE End Date
17 DST_ALLOC_METHOD Character(1) VARCHAR2(1) NOT NULL Distribution Allocation Method
1=Percentage
2=Amount
3=Area
4=None
5=Quantity
18 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
19 CF_SEQNO Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
20 STLINE_PRORATE_RT Number(14,10) DECIMAL(13,10) NOT NULL Straightline Proration Rate
21 ACTUAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Amount field for the Actual V Budgeted Pagelet
22 STLINE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Straightline Amount - Signed Number (23.3)
23 ACCR_DEFR_TOT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Accrual/ Deferral Amount
24 ACCR_DEFR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Accrual/ Deferral Amount
25 ACR_DFR_TOT_AMT_BS Signed Number(28,3) DECIMAL(26,3) NOT NULL Accrual/ Deferral Amount
26 ACR_DFR_AMT_BS Signed Number(28,3) DECIMAL(26,3) NOT NULL Accrual/ Deferral Amount
27 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code