RE_LS_TR_PRT_VW

(SQL View)
 Index Back

SELECT 'T' , LS_KEY , AMND_NBR , TRANS_DT , ACCOUNTING_DT , ASSET_SEQ_NBR , TRF_KEY , BUSINESS_UNIT_AM , ASSET_ID , BOOK , DTTM_STAMP , TRANS_IN_OUT , IU_MAP_KEY , CF_SEQNO , TRF_TYPE , COST_TYPE , PRORATION_RATE , AMOUNT , AMOUNT_BSE FROM PS_RE_LS_AST_LOTRF UNION ALL SELECT 'R' , LS_KEY , AMND_NBR , TRANS_DT , ACCOUNTING_DT , ASSET_SEQ_NBR , 0 , BUSINESS_UNIT_AM , ASSET_ID , BOOK , DTTM_STAMP , ' ' , 0 , CF_SEQNO , TRF_TYPE , COST_TYPE , PRORATION_RATE , AMOUNT , AMOUNT_BSE FROM PS_RE_LS_AST_PRET WHERE TRF_TYPE = 'AA'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ROW_SOURCE Character(1) VARCHAR2(1) NOT NULL Row Source
2 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
3 AMND_NBR Number(3,0) SMALLINT NOT NULL Amendment Number
4 TRANS_DT Date(10) DATE Transaction Date
5 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
6 ASSET_SEQ_NBR Number(5,0) INTEGER NOT NULL Asset Sequence Number
7 TRF_KEY Number(3,0) SMALLINT NOT NULL Transfer Key
8 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
9 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
10 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
11 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
12 TRANS_IN_OUT Character(1) VARCHAR2(1) NOT NULL Transaction In/Out
I=In
M=IUT Proceeds Markup
O=Out
13 IU_MAP_KEY Number(7,0) INTEGER NOT NULL InterUnit transfer map key
14 CF_SEQNO Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
15 TRF_TYPE Character(2) VARCHAR2(2) NOT NULL Transfer Type
LN=Lease Incentive
LO=Lease Obligation
RE=Rent Expense
16 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
17 PRORATION_RATE Number(14,10) DECIMAL(13,10) NOT NULL Proration Rate
18 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
19 AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount