OPEN_REV_IUT_VW

(SQL View)
 Index Back

AM Open Transactions


SELECT BUSINESS_UNIT , ASSET_ID , BOOK , DTTM_STAMP , TRANS_DT , ACCOUNTING_DT , TRANS_TYPE , MEM_IN_SERVICE_DT , CONVENTION , GROUP_ASSET_ID , EFFDT , TRANSFER_BU , TRANSFER_ASSET_ID , TRANSFER_BOOK , TRANS_IN_OUT , CALC_DEPR_STATUS , CALC_DIST_STATUS , CALC_REPT_STATUS , SUM_GROUP_STATUS , OPRID , OPEN_TRANS_ID , MIN_DTTM_STAMP , MAX_DTTM_STAMP , PROCESS_INSTANCE , REQUEST_ID FROM PS_OPEN_TRANS

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

Prompt Table: SP_BU_AM_NONVW

2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
3 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

Prompt Table: SP_BOOKB1_NONVW

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 TRANS_DT Date(10) DATE Transaction Date
6 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
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 MEM_IN_SERVICE_DT Date(10) DATE Group Member in Service Date
9 CONVENTION Character(2) VARCHAR2(2) NOT NULL Book Depreciation Convention or Cost Convention
10 GROUP_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Group Asset ID
11 EFFDT Date(10) DATE Effective Date
12 TRANSFER_BU Character(5) VARCHAR2(5) NOT NULL Transfer Business Unit

Prompt Table: SP_BU_AM_NONVW

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 TRANS_IN_OUT Character(1) VARCHAR2(1) NOT NULL Transaction In/Out
I=In
M=IUT Proceeds Markup
O=Out
16 CALC_DEPR_STATUS Character(1) VARCHAR2(1) NOT NULL Depreciation Calc Status
C=Completed Depreciation
H=Held For Transfer In
I=In Processing
N=Never Calculate Depreciation
P=Pending Depreciation
17 CALC_DIST_STATUS Character(1) VARCHAR2(1) NOT NULL Acctg Entry Creation Status
C=Completed Distribution
N=Never Calculate Distribution
P=Pending Distribution
R=Reconcilie Clearing
18 CALC_REPT_STATUS Character(1) VARCHAR2(1) NOT NULL Reporting Process Status
C=Completed
N=Never
P=Pending
19 SUM_GROUP_STATUS Character(1) VARCHAR2(1) NOT NULL Group Consolidation Status
C=Completed Sum Composite
G=Grouped Composite
M=Member Depreciation
N=Never Sum Composite
P=Pending Sum Composite
20 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
21 OPEN_TRANS_ID Number(10,0) DECIMAL(10) NOT NULL Open Transaction ID
22 MIN_DTTM_STAMP DateTime(26) TIMESTAMP Min DateTime Stamp(Group Asset
23 MAX_DTTM_STAMP DateTime(26) TIMESTAMP Max DateTime Stamp
24 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
25 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID