BUSINESS_UNITPROJECT_IDPrompt Table: PC_INT_TMPL
Prompt Table: RT_TYPE_TBL
Prompt Table: SP_SETID_NONVW
GM_PROJ_VW(SQL View) |
Index Back |
|---|---|
Grants Projects View |
| SELECT BUSINESS_UNIT , PROJECT_ID , INTEGRATION_TMPL , DESCR , SYSTEM_SOURCE , RT_TYPE , SET_OVERRIDE FROM PS_PROJECT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 3 | INTEGRATION_TMPL | Character(15) | VARCHAR2(15) NOT NULL |
Integration
Prompt Table: PC_INT_TMPL |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | SYSTEM_SOURCE | Character(3) | VARCHAR2(3) NOT NULL | Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen. |
| 6 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |
| 7 | SET_OVERRIDE | Character(5) | VARCHAR2(5) NOT NULL |
FS_08 SetID
Prompt Table: SP_SETID_NONVW |