AM_FDRL_IUT_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.BOOK , A.DTTM_STAMP , A.CF_SEQNO , A.IU_MAP_KEY , A.TRANS_TYPE , A.TRANS_IN_OUT , A.DEPTID , A.%Sql(FUND_CODE,) , C.SETID , B.BUSINESS_UNIT , B.ASSET_ID , B.BOOK , B.CF_SEQNO , B.IU_MAP_KEY , B.DEPTID , B.%Sql(FUND_CODE,) , D.SETID FROM PS_COST A , PS_COST B , PS_AM_FDRL_TRF1_VW C , PS_AM_FDRL_TRF1_VW D WHERE B.BUSINESS_UNIT = A.TRANSFER_BU AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.ASSET_ID = A.TRANSFER_ASSET_ID AND B.BOOK = A.BOOK AND B.DTTM_STAMP = A.DTTM_STAMP AND A.TRANS_TYPE = 'TRF' AND (A.%Sql(FUND_CODE,) <> B.%Sql(FUND_CODE,) OR (A.%Sql(FUND_CODE,) = B.%Sql(FUND_CODE,) AND ( C.SETID <> D.SETID )))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
3 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
4 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.
5 CF_SEQNO Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
6 IU_MAP_KEY Number(7,0) INTEGER NOT NULL InterUnit transfer map key
7 TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Types of Asset Management Transactions
ACR=Accretion Expense
ADD=Asset Addition
ADJ=Asset Cost Adjustment
BKS=Book Adjustment
BUD=Budgeted Depreciation
DPR=Depreciation
INF=Inflation Adjustment
LEX=Lease Expense
LPB=Budgeted Lease Payments
LPY=Lease Payment
PDP=Prior Period Depreciation
PLP=Prior Lease Payment
RAD=Manual Reserve Adjustment
RCT=Asset Recategorization
REI=Asset Reinstatement
RES=Resume Depreciation
RET=Asset Retirement
RRC=Retro rate change for grp ast
SUS=Suspend Depreciation
TRF=Asset Transfer
8 TRANS_IN_OUT Character(1) VARCHAR2(1) NOT NULL Transaction In/Out
I=In
M=IUT Proceeds Markup
O=Out
9 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
10 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
11 SETID1 Character(5) VARCHAR2(5) NOT NULL SetID Value
12 TRANSFER_BU Character(5) VARCHAR2(5) NOT NULL Transfer Business Unit
13 TRANSFER_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Transfer Asset ID
14 TRANSFER_BOOK Character(10) VARCHAR2(10) NOT NULL Transfer From Book
15 CF_SEQNO2 Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
16 IU_MAP_KEY2 Number(7,0) INTEGER NOT NULL InterUnit transfer map key
17 DEPTID2 Character(10) VARCHAR2(10) NOT NULL DEPTID2
18 FUND_CODE2 Character(5) VARCHAR2(5) NOT NULL Fund Code
19 SETID2 Character(5) VARCHAR2(5) NOT NULL 2nd SetId