AM_BKC_RSET_AET

(SQL Table)
Index Back

Book code reset AET

Book Code Reset state record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
5 ACCT_ENT_TMPL_ID Character(10) VARCHAR2(10) NOT NULL Account Entry Template ID
6 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category
7 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
8 COST_TYPE_ALL_SW Character(1) VARCHAR2(1) NOT NULL Cost Type All Switch
9 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
10 TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Transaction Code
11 TRANS_CODE_ALL_SW Character(1) VARCHAR2(1) NOT NULL Trans Code All Switch
12 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
13 ACCOUNT_2 Character(10) VARCHAR2(10) NOT NULL Account
14 BLANK Character(1) VARCHAR2(1) NOT NULL Blank

Default Value: N