AM_FDRL_RUL_DTL(SQL Table) |
Index Back |
---|---|
AM Federal Asset Rule Detail |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | AM_FDRL_RULE | Character(10) | VARCHAR2(10) NOT NULL | AM Federal Asset Rules field |
3 | EFFDT | Date(10) | DATE NOT NULL | Effective Date |
4 | CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Asset Category
Prompt Table: CATEGORY_TBL |
5 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
6 | 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 |
7 | DISTRIBUTION_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Distribution Type |
8 | TRANS_IN_OUT | Character(1) | VARCHAR2(1) NOT NULL |
Transaction In/Out
I=In M=IUT Proceeds Markup O=Out |
9 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL |
Account
Prompt Table: GL_ACCT_ALL_VW |
10 | ACCOUNT_SIGN | Signed Number(2,0) | DECIMAL(1) NOT NULL | Account Sign |
11 | SIGN_ADJUSTER | Signed Number(2,0) | DECIMAL(1) NOT NULL | Used to adjust sign for AM trn |