DIST_TMPL_TMP

(SQL Table)
Index Back

AM AE Dist Templates Temp Tbl

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category

Prompt Table: CATEGORY_TBL

3 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type

Prompt Table: COST_TYPE_TBL

4 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

Prompt Table: DIST_TT_VW

5 TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Transaction Code

Prompt Table: TRANS_CODE_VW

6 ACCT_ENT_TMPL_ID Character(10) VARCHAR2(10) NOT NULL Account Entry Template ID

Default Value: INSTALLATION_AM.ACCT_ENT_TMPL_ID

Prompt Table: AMAE_TMPLID_TBL

7 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template

Prompt Table: JRNLGEN_APPL_ID

8 APPL_JRNL_ID_BUD Character(10) VARCHAR2(10) NOT NULL Budget Journal Template ID

Prompt Table: JRNLGEN_APPL_ID