UPG_PC_BD_I_TMP(SQL Table) |
Index Back |
|---|---|
Project Budget Items |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
|
| 3 | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: PROJECT_VW |
|
| 4 | Number(3,0) | SMALLINT NOT NULL | Budget Plan ID | |
| 5 | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PROJ_ACT_VW |
|
| 6 | Character(15) | VARCHAR2(15) NOT NULL |
Project Budgeting: Budget Item
11/15/2004- FS - Added label COST_BUDGET_ITEM
Default Value: GM_BUD_CATEGORY.BUDGET_CATEGORY Prompt Table: PC_BUD_ITM_VW |
|
| 7 | Number(15,0) | DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 1 |
|
| 8 | Character(8) | VARCHAR2(8) NOT NULL | Budget Period | |
| 9 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL |
Account
Prompt Table: GL_ACCT_BUGL_VW |
| 10 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL |
Alternate Account
Prompt Table: ALT_BUGL_VW |
| 11 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPTID_BUGL_VW |
| 12 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Source Type
Default Value: PROJ_RES_TYPE.RESOURCE_TYPE Prompt Table: PROJ_RES_TYP_VW |
| 13 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Category
Default Value: PROJ_CATG_TBL.RESOURCE_CATEGORY Prompt Table: %EDITTABLE |
| 14 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL |
Subcategory
Default Value: PROJ_CAT_SUB.RESOURCE_SUB_CAT Prompt Table: %EDITTABLE2 |
| 15 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Default Value: PC_INT_TMPLGLVW.BUSINESS_UNIT_GL Prompt Table: SP_BUPCIT_NONVW |
| 16 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table: OPRUNT_BUGL2_VW |
| 17 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table: PRODCT_BUGL2_VW |
| 18 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table: FUND_BUGL2_VW |
| 19 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL |
Class Field
Prompt Table: CLASS_BUGL2_VW |
| 20 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table: PROGRM_BUGL2_VW |
| 21 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table: BUDREF_BUGL2_VW |
| 22 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table: AFFILIATE_VW |
| 23 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01 |
| 24 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02 |
| 25 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table: CF1_BUGL2_VW |
| 26 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table: CF2_BUGL2_VW |
| 27 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table: CF3_BUGL2_VW |
| 28 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 29 | BUDGET_ADJUST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Budget Adjustment Amount |
| 30 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table:
SP_LEDGPC_NONVW
|
| 31 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL |
Ledger
Prompt Table:
SP_LEDPC_NONVW
|
| 32 | KK_DEFAULT_EE | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No Indicator - Use Default Entry Event
Y/N Table Edit Default Value: BUS_UNIT_OPT_PC.KK_DEFAULT_EE |
| 33 | KK_GEN_PARENT | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No Indicator - Generate Parent Budgets
Y/N Table Edit |
| 34 | KK_PARENT_ENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Indicator - Parent Budget Entry Type
0=Original 1=Adjustment 2=Transfer Adjustment 3=Transfer Original |
| 35 | KK_BUDG_TRANS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Budget Entry Type
0=Original 1=Adjustment 2=Transfer Adjustment 3=Transfer Original 4=Closing 5=Roll Forward Default Value: 0 |
| 36 | ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table:
EE_PCB_CODES_VW
|