BUSINESS_UNITPROPOSAL_IDVERSION_IDCOST_CLASSIFICATNPrompt Table: GM_COSTCLSS_TBL
GM_XML_COSTCLAS(SQL Table) |
Index Back |
|---|
| # | 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 | COST_CLASSIFICATN |
Character(100) | VARCHAR2(100) NOT NULL |
Cost Classification
Prompt Table: GM_COSTCLSS_TBL |
| 5 | BUD_ALLOW_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Allowable Budget Amount |
| 6 | BUD_NO_ALLOW_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Not Allowable Budget Amount |
| 7 | TOT_BUD_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Budget Amount |
| 8 | SPN_ALLOW_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Allowable Sponsor Amount |
| 9 | SPN_NO_ALLOW_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Not Allowable Sponsor Amount |
| 10 | TOT_SPN_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Sponsor Amount |