BUSINESS_UNITPROPOSAL_IDVERSION_IDDefault Value: 0
Default Value: 0
CMTD=03 - Committed
CNCL=05 - Canceled
DENY=04 - Denied
DRAF=01 - Draft
NSUB=Not Submitted
RDY=02 - Ready
SUBM=Submitted
SUBR=Submitted With Error
Prompt Table: %EDITTABLE14
GM_OPPTY_INQ_VW(SQL View) |
Index Back |
|---|---|
PM version view |
| SELECT BUSINESS_UNIT , PROPOSAL_ID , VERSION_ID , TITLE56 , TOTAL_BUDGET_AMT , PROPOSED_AMT_EXP , PROPOSED_AMT_TIME , ESTIMATED_AMOUNT , ESTIMATED_AMT_EXP , ESTIMATED_AMT_TIME , BILL_AMT , BILL_AMT_EXP , BILL_AMT_TIME , COST_AMT , COST_AMT_EXP , COST_AMT_TIME , PM_MARGIN_PCT , MARGIN_PCT_EXP , MARGIN_PCT_TIME , RESOURCE_TOTAL , NBR_OF_HOURS , WEEKLY_WEEKS , CURRENT_VERSION , SCEN_ADJUST_PCT_EX , SCEN_ADJUST_PCT_TM , CURRENCY_CD , SUBMIT_STATUS , CUST_ID , EMPLID , BEGIN_DT , END_DT , DUE_DATE FROM PS_GM_PROPOSAL WHERE CURRENT_VERSION = 'Y' |
| # | 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 | TITLE56 | Character(56) | VARCHAR2(56) NOT NULL | TITLE56 |
| 5 | TOTAL_BUDGET_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | TOTAL_BUDGET_AMT |
| 6 | PROPOSED_AMT_EXP | Number(27,3) | DECIMAL(26,3) NOT NULL | Proposed Amount Expense |
| 7 | PROPOSED_AMT_TIME | Number(27,3) | DECIMAL(26,3) NOT NULL | Proposed Amount Time |
| 8 | ESTIMATED_AMOUNT | Number(27,3) | DECIMAL(26,3) NOT NULL | Estimated Amount SCP - Added new label - Estimated Cost |
| 9 | ESTIMATED_AMT_EXP | Number(27,3) | DECIMAL(26,3) NOT NULL | Estimated Amount Expense |
| 10 | ESTIMATED_AMT_TIME | Number(27,3) | DECIMAL(26,3) NOT NULL | Estimated Amount Time |
| 11 | BILL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bill Amount |
| 12 | BILL_AMT_EXP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bill Amount |
| 13 | BILL_AMT_TIME | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bill Amount |
| 14 | COST_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Amount |
| 15 | COST_AMT_EXP | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Amount Expense |
| 16 | COST_AMT_TIME | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Amount Time |
| 17 | PM_MARGIN_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Margin Percent |
| 18 | MARGIN_PCT_EXP | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Margin Percent |
| 19 | MARGIN_PCT_TIME | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Margin Percent |
| 20 | RESOURCE_TOTAL | Number(3,0) | SMALLINT NOT NULL | Resource Total |
| 21 | NBR_OF_HOURS | Number(5,0) | INTEGER NOT NULL | Number of Hours |
| 22 | WEEKLY_WEEKS | Number(3,0) | SMALLINT NOT NULL | Weeks |
| 23 | CURRENT_VERSION | Character(1) | VARCHAR2(1) NOT NULL | Current Version |
| 24 | SCEN_ADJUST_PCT_EX | Signed Number(7,2) | DECIMAL(5,2) NOT NULL |
Scenario Adjustment % for Expense
06/09/2004 PR_FS_B005
Added Label NON_LABOR_ADJUST
Default Value: 0 |
| 25 | SCEN_ADJUST_PCT_TM | Signed Number(7,2) | DECIMAL(5,2) NOT NULL |
Scenario Adjustment % for Time
06/09/2004 PR_FS_B005
Added Label - LABOR_ADJUST
Default Value: 0 |
| 26 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 27 | SUBMIT_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Proposal Submission Status
CMTD=03 - Committed CNCL=05 - Canceled DENY=04 - Denied DRAF=01 - Draft NSUB=Not Submitted RDY=02 - Ready SUBM=Submitted SUBR=Submitted With Error |
| 28 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: %EDITTABLE14 |
| 29 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 30 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 31 | END_DT | Date(10) | DATE | End Date |
| 32 | DUE_DATE | Date(10) | DATE | Delivery Due Date from PO |