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
|