BUSINESS_UNITDefault Value: PROJECT.BUSINESS_UNIT
Prompt Table: SP_BU_PC_NONVW
PROJECT_IDDefault Value: PROJECT.PROJECT_ID
Prompt Table: SP_PROJ_NONVW
BUDGET_PERIODPrompt Table: PC_BUD_BP_DVW
GM_PC_BUD_PD_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT BUSINESS_UNIT , PROJECT_ID , BUDGET_PERIOD , CURRENCY_CD FROM PS_PC_BUD_DETAIL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: PROJECT.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: PROJECT.PROJECT_ID Prompt Table: SP_PROJ_NONVW |
| 3 | BUDGET_PERIOD |
Character(8) | VARCHAR2(8) NOT NULL |
Budget Period
Prompt Table: PC_BUD_BP_DVW |
| 4 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |