AMREVAL_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 5 | PROCESS_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process N=Don't Run O=Process Once |
| 6 | PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Process Status
A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | BOOK | Character(10) | VARCHAR2(10) NOT NULL | Asset Book Name |
| 9 | ASSET_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Select All Assets ?
A=All Assets with this criteria N=A Range of Assets |
| 10 | ASSET_ID_FROM | Character(12) | VARCHAR2(12) NOT NULL | From Asset ID |
| 11 | ASSET_ID_TO | Character(12) | VARCHAR2(12) NOT NULL | Asset ID to |
| 12 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL | Operating Unit ChartField |
| 13 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product ChartField |
| 14 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL | Fund Code |
| 15 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL | Class Field |
| 16 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code ChartField |
| 17 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL | Budget Reference |
| 18 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Affiliate |
| 19 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate1 |
| 20 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL | Operating Unit Affiliate |
| 21 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL | Expansion chartfield 1 |
| 22 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 2 |
| 23 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 3 |
| 24 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 25 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 26 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 27 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 28 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 29 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 30 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 31 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 32 | CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Asset Category |
| 33 | COST_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Cost Type |
| 34 | TRANS_DT | Date(10) | DATE | Transaction Date |
| 35 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 36 | PERCENT_PNL | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Percent on Panels |
| 37 | INTFC_ID | Number(8,0) | INTEGER NOT NULL | Interface ID |
| 38 | OPEN_TRANS_ID | Number(10,0) | DECIMAL(10) NOT NULL | Open Transaction ID |
| 39 | WHERE_CLAUSE_LONG2 | Long Character(8192) | CLOB | Where Clause |
| 40 | DATE_BEGIN | Date(10) | DATE | Start Date |
| 41 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 42 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 43 | COPY_TO_OTH_BK | Character(1) | VARCHAR2(1) NOT NULL | Copy Impairment to other books |
| 44 | PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Asset Profile ID |
| 45 | FMV_PERCENT | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | FV Percentage(%) |
| 46 | NBV_PERCENT | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | NBV Percentage(%) |
| 47 | USE_FMV | Character(1) | VARCHAR2(1) NOT NULL | Use Fair Value |
| 48 | CONVENTION | Character(2) | VARCHAR2(2) NOT NULL | Book Depreciation Convention or Cost Convention |
| 49 | REVAL_COST_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Cost Type for Revaluation |
| 50 | INCLUDE_CUR_PD_DPR | Character(1) | VARCHAR2(1) NOT NULL | Include Current Period Depr. |
| 51 | EXC_AST_IMP_DT_AFT | Date(10) | DATE | Exclude Assets Impaired After |
| 52 | RT_RATE_INDEX | Character(10) | VARCHAR2(10) NOT NULL | Market Rate Index |
| 53 | REVALUE_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Revaluation Method
C=Cost Based D=Depr. Write-Off I=Investment Property |
| 54 | DUMMY_FIELD | Character(1) | VARCHAR2(1) NOT NULL | Dummy Field for Hiding Groups |
| 55 | BUSINESS_UNIT_2 | Character(5) | VARCHAR2(5) NOT NULL | Non-Joint Venture BU |
| 56 | ASSET_ID2 | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 57 | DELETE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Deletion Flag
Default Value: N |
| 58 | ASSET_CLASS | Character(10) | VARCHAR2(10) NOT NULL | Asset Class |
| 59 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 60 | FROM_INTFC_ID | Number(8,0) | INTEGER NOT NULL | From Interface ID |
| 61 | TO_INTFC_ID | Number(8,0) | INTEGER NOT NULL | To Interface ID |
| 62 | GROUP_ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Group Asset ID |
| 63 | TEMP_TABLE1 | Character(18) | VARCHAR2(18) NOT NULL | Temporary Table |
| 64 | VALUATION_METHOD | Character(30) | VARCHAR2(30) NOT NULL | Valuation Method |
| 65 | VALUATION_PREMISE | Character(1) | VARCHAR2(1) NOT NULL |
Fair Value Valuation Premise: 1:In-Exchange;2:In-Use
1=In-Exchange 2=In-Use |
| 66 | FV_GROUP_BY | Character(1) | VARCHAR2(1) NOT NULL |
Fair Value Group By: 1:FV Group ID; 2:Cash Generating Unit; 3:Group Asset ID; 4:Parent ID
1=FV Group ID 2=Cash Generating Unit 3=Group Asset ID 4=Parent ID |
| 67 | FV_GROUP_ID | Character(20) | VARCHAR2(20) NOT NULL | FV Group ID used to group related FV Assets |
| 68 | FV_INPUT_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Fair Value Input Level. 1:Level1;2:Level2;3:Level4;4:All Level
1=Level 1 2=Level 2 3=Level 3 |