AM_DIST_NOJG_VW

(SQL View)
 Index Back

Acct Entries not yet Journaled


SELECT D.BUSINESS_UNIT , D.BOOK , D.ASSET_ID , MIN(A.DESCR) , D.TRANS_TYPE , D.ACCOUNTING_DT , D.BUSINESS_UNIT_GL , COUNT(DISTINCT D.ASSET_ID) FROM PS_DIST_LN D , PS_ASSET A WHERE D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.ASSET_ID = A.ASSET_ID AND D.JOURNAL_ID = ' ' AND D.GL_DISTRIB_STATUS = 'N' GROUP BY D.BUSINESS_UNIT, D.BOOK, D.ASSET_ID, D.TRANS_TYPE, D.ACCOUNTING_DT, D.BUSINESS_UNIT_GL

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

Prompt Table: SP_BUAM_NONVW

2 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

Prompt Table: SP_BU_BK_NONVW

3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 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
6 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
7 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
8 TOTAL_ROWS_CNT Number(13,0) DECIMAL(13) NOT NULL Total Rows Pending