BUSINESS_UNITPROPOSAL_IDVERSION_IDSUB_PROP_NBRBUDGET_CATEGORYDefault Value: GM_PROPOSAL.CURRENCY_CD
Prompt Table: CURRENCY_CD_TBL
GM_BUD_INQ4(SQL Table) |
Index Back |
|---|---|
Budget Inquiry by Project |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROPOSAL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Proposal ID |
| 3 | VERSION_ID |
Character(7) | VARCHAR2(7) NOT NULL | Version ID |
| 4 | SUB_PROP_NBR |
Character(15) | VARCHAR2(15) NOT NULL | SUB_PROP_NBR |
| 5 | BUDGET_CATEGORY |
Character(15) | VARCHAR2(15) NOT NULL | BUDGET_CATEGORY |
| 6 | SPONSOR_AMT_PD01 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Period 1 Sponsor Direct |
| 7 | SPONSOR_AMT_PD02 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Period 2 Sponsor Direct |
| 8 | SPONSOR_AMT_PD03 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Period 3 Sponsor Direct |
| 9 | SPONSOR_AMT_PD04 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Period 4 Sponsor Direct |
| 10 | SPONSOR_AMT_PD05 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Period 5 Sponsor Direct |
| 11 | SPONSOR_AMT_PD06 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Period 6 Sponsor Direct |
| 12 | SPONSOR_AMT_PD07 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Period 7 Sponsor Direct |
| 13 | SPONSOR_AMT_PD08 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Period 8 Sponsor Direct |
| 14 | SPONSOR_AMT_PD09 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Period 9 Sponsor Direct |
| 15 | SPONSOR_AMT_PD10 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Period 10 Sponsor Direct |
| 16 | SPONSOR_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SPONSOR_AMT |
| 17 | COST_SHARE_IN_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | COST_SHARE_IN_AMT |
| 18 | COST_SHARE_TP_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | COST_SHARE_TP_AMT |
| 19 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: GM_PROPOSAL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL |