DIST_TMPLLN_TMP(SQL Table) |
Index Back |
---|---|
AM AE Dist Template Lines Temp |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID |
|
2 | Character(5) | VARCHAR2(5) NOT NULL | Asset Category | |
3 | Character(1) | VARCHAR2(1) NOT NULL | Cost Type | |
4 | 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 | Character(1) | VARCHAR2(1) NOT NULL |
Transaction In/Out
I=In M=IUT Proceeds Markup O=Out |
|
6 | Character(5) | VARCHAR2(5) NOT NULL | Transaction Code | |
7 | Character(2) | VARCHAR2(2) NOT NULL | Distribution Type | |
8 | Character(10) | VARCHAR2(10) NOT NULL |
Account Entry Template ID
Default Value: INSTALLATION_AM.ACCT_ENT_TMPL_ID |
|
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_CUR_VW |
12 | SIGN_ADJUSTER | Signed Number(2,0) | DECIMAL(1) NOT NULL | Used to adjust sign for AM trn |