BUDGET_IDBUDGET_START_DTTREE_NODE_NUMWCS_AWESUMM_VW(SQL View) |
Index Back |
|---|---|
Approval Transaction SummaryDescription used in approval transaction summary. |
| SELECT HDR.BUDGET_ID , HDR.BUDGET_START_DT , HDR.TREE_NODE_NUM , 000.000000 , CFG.CURRENCY_CD , 'Proposed Amount Place Holder' , ' ' FROM PS_WCS_AWE_NOD_HDR HDR , PS_WCS_ECM_CYC_CFG CFG WHERE HDR.BUDGET_ID = CFG.BUDGET_ID AND HDR.BUDGET_START_DT = CFG.BUDGET_START_DT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUDGET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Budget ID |
| 2 | BUDGET_START_DT |
Date(10) | DATE NOT NULL | Budget Start Date |
| 3 | TREE_NODE_NUM |
Number(10,0) | DECIMAL(10) NOT NULL | Internal beginning node range number |
| 4 | WCS_TOT_P_AMT | Number(22,6) | DECIMAL(21,6) NOT NULL | Total Proposed Amount in Node (direct and indirect) |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | WCS_SUMMARY_AWE | Character(60) | VARCHAR2(60) NOT NULL | Used to display approval transaction summary. |
| 7 | WCS_CHAR_AMT01 | Character(30) | VARCHAR2(30) NOT NULL | Character field used to display formatted amounts. |