AM_PND_AEDST_VW

(SQL View)
 Index Back

Asset Trans Pending Acct Entry

Asset Transactions Pending Accounting Entry Creation. Used for GL Subsystem Reconciliation.

SELECT C.BUSINESS_UNIT , C.ASSET_ID , C.BOOK , C.DTTM_STAMP , C.CF_SEQNO , C.GROUP_ASSET_ID , C.MEM_IN_SERVICE_DT , C.IU_MAP_KEY , C.CONVENTION , %subrec(CF12_AN_SBR, C) , %subrec(AM_CF1_N_SBR, C) , C.PROJECT_ID , C.DEPTID , C.CATEGORY , C.COST_TYPE , C.TRANS_TYPE , C.TRANS_IN_OUT , C.TRANS_CODE , C.TRANS_DT , C.ACCOUNTING_DT , C.QUANTITY , C.TXN_COST , C.COST , C.TXN_CURRENCY_CD , C.FROM_CUR , C.SALVAGE_VALUE , C.ACTIVITY_SW , C.RETIRE_SW , OT.CALC_DIST_STATUS , OT.CALC_DEPR_STATUS , BK.BUSINESS_UNIT_GL , BK.LEDGER_GROUP , BK.LEDGER FROM PS_COST C , PS_OPEN_TRANS OT , PS_BU_BOOK_TBL BK WHERE OT.CALC_DIST_STATUS = 'P' AND %Join(COMMON_KEYS, COST C, OPEN_TRANS OT ) AND BK.BUSINESS_UNIT = C.BUSINESS_UNIT AND BK.BOOK = C.BOOK

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

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

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

Prompt Table: BOOK

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 GROUP_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Group Asset ID
7 MEM_IN_SERVICE_DT Date(10) DATE Group Member in Service Date
8 IU_MAP_KEY Number(7,0) INTEGER NOT NULL InterUnit transfer map key
9 CONVENTION Character(2) VARCHAR2(2) NOT NULL Book Depreciation Convention or Cost Convention
10 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
11 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
12 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
13 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
14 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
15 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
16 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
17 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
18 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
19 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
20 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
21 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
22 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
23 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
24 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
25 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
26 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
27 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
28 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: PROJECT_ID_VW

29 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
30 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category
31 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type

Prompt Table: COST_TYPE_TBL

32 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
33 TRANS_IN_OUT Character(1) VARCHAR2(1) NOT NULL Transaction In/Out
I=In
M=IUT Proceeds Markup
O=Out
34 TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Transaction Code
35 TRANS_DT Date(10) DATE Transaction Date
36 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
37 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
38 TXN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
39 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
40 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
41 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
42 SALVAGE_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Salvage Value
43 ACTIVITY_SW Signed Number(2,0) DECIMAL(1) NOT NULL Activity Switch
44 RETIRE_SW Signed Number(2,0) DECIMAL(1) NOT NULL Retirement Switch
45 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
46 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
47 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
48 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
49 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger