DIST_TMPLLN_VW

(SQL View)
 Index Back

AM Distribution Template Lines


SELECT a.SetID , a.Category , a.Cost_Type , a.Trans_Type , a.Trans_Code , a.Distribution_Type , a.acct_ent_tmpl_id , a.Trans_In_Out , a.Account_Sign , a.Account , a.Altacct , b.Appl_Jrnl_ID , a.Sign_Adjuster , (a.ACCOUNT_SIGN * A.SIGN_ADJUSTER) , a.book_code FROM PS_DIST_TMPLLN_TBL a , ps_Dist_Tmpl_Tbl b WHERE a.SetID = b.Setid AND a.Category = b.Category AND a.Cost_Type = b.Cost_Type AND a.Trans_Type = b.Trans_Type AND a.Trans_Code = b.Trans_Code AND a.acct_ent_tmpl_id = b.acct_ent_tmpl_id

# 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: SETID_TBL

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
5 TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Transaction Code

Prompt Table: TRANS_CODE_VW

6 DISTRIBUTION_TYPE Character(2) VARCHAR2(2) NOT NULL Distribution Type
7 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

8 TRANS_IN_OUT Character(1) VARCHAR2(1) NOT NULL Transaction In/Out
I=In
M=IUT Proceeds Markup
O=Out
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_CNTL_VW

11 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

Prompt Table: ALTACCT_XREF

12 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
13 SIGN_ADJUSTER Signed Number(2,0) DECIMAL(1) NOT NULL Used to adjust sign for AM trn
14 CREDIT_MULTIPLIER Signed Number(4,0) DECIMAL(3) NOT NULL Credit Multiplier
15 BOOK_CODE Character(4) VARCHAR2(4) NOT NULL Book Code