DIST_TMPLLN_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
2	CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Asset Category
3	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type
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
5	TRANS_CODE	Character(5)	VARCHAR2(5) NOT NULL	Transaction Code
6	ACCT_ENT_TMPL_ID	Character(10)	VARCHAR2(10) NOT NULL	Account Entry Template ID Default Value: INSTALLATION_AM.ACCT_ENT_TMPL_ID
7	TRANS_IN_OUT	Character(1)	VARCHAR2(1) NOT NULL	Transaction In/Out I=In M=IUT Proceeds Markup O=Out
8	DISTRIBUTION_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Distribution Type
9	ACCOUNT_SIGN	Signed Number(2,0)	DECIMAL(1) NOT NULL	Account Sign
10	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: GL_ACCT_ALL_VW
11	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Prompt Table: ALTACCT_CUR_VW
12	SIGN_ADJUSTER	Signed Number(2,0)	DECIMAL(1) NOT NULL	Used to adjust sign for AM trn
13	BOOK_CODE	Character(4)	VARCHAR2(4) NOT NULL	Book Code Prompt Table: BOOK_CODE_TBL