OPPORTUNITY_IDSCENARIO_IDEXPENSE_TYPEPrompt Table:
EX_TYPES_TBL
Set Control Field: BUSINESS_UNIT
SEQ_NBR2Default Value: 1
Default Value: 1
PSA_SCEN_EXP_VW(SQL View) |
Index Back |
|---|---|
Engagement Planning ExpenseDtl |
| SELECT OPPORTUNITY_ID , SCENARIO_ID , EXPENSE_TYPE , SEQ_NBR2 , DESCR , QTY_INTEGER , CURRENCY_CD , COST_RATE , BILL_RATE , COST_AMT_EXP , BILL_AMT_EXP , MARGIN_PCT , REVIEW FROM PS_PSA_SCEN_EXP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPPORTUNITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Opportunity ID |
| 2 | SCENARIO_ID |
Character(4) | VARCHAR2(4) NOT NULL | A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca |
| 3 | EXPENSE_TYPE |
Character(7) | VARCHAR2(7) NOT NULL |
Expense Type
Prompt Table:
EX_TYPES_TBL
|
| 4 | SEQ_NBR2 |
Number(15,0) | DECIMAL(15) NOT NULL |
Used as a key to SHIP_INV_TMP in addition to the DEMAND_PHYS_INV.
Default Value: 1 |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | QTY_INTEGER | Number(11,0) | DECIMAL(11) NOT NULL |
Quantity Rounded to 0 Decimals
Default Value: 1 |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 8 | COST_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Rate |
| 9 | BILL_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Billing Rate |
| 10 | COST_AMT_EXP | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Amount Expense |
| 11 | BILL_AMT_EXP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bill Amount |
| 12 | MARGIN_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Margin Percent |
| 13 | REVIEW | Character(1) | VARCHAR2(1) NOT NULL | Review |