PC_FUND_AET(SQL Table) |
Index Back |
|---|---|
Temporary Processing TableTAO/TMP/AET - Table is used during an application engine process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: PROJECT.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
| 3 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: PROJECT.PROJECT_ID Prompt Table: PROJECT |
| 4 | PC_BUDGET_ID | Number(3,0) | SMALLINT NOT NULL |
Budget Plan ID
Prompt Table: PC_BUD_PLAN |
| 5 | ANALYSIS_GROUP | Character(5) | VARCHAR2(5) NOT NULL |
Analysis Group
Default Value: OPR_DEF_TBL_PC.ANALYSIS_GROUP Prompt Table: %EDIT_ANALYSIS |
| 6 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table: PC_ANGRP_VW |
| 7 | TRANS_DT | Date(10) | DATE NOT NULL |
Transaction Date
Default Value: %date |
| 8 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 9 | COMMITMENT_CNTL_PC | Character(1) | VARCHAR2(1) NOT NULL | Commitment Control on PC |
| 10 | FIELD_LIST | Long Character(4000) | CLOB | Field List |