PSA_SCEN_EXP(SQL Table) |
Index Back |
|---|---|
Scenario Expenses |
| # | 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 | COST_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL |
Cost Rate
Default Value: 0 |
| 8 | BILL_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Billing Rate |
| 9 | ACTUAL_BILL_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Actual Bill Rate |
| 10 | ADJUSTED_FLAG_BILL | Character(1) | VARCHAR2(1) NOT NULL |
Adjusted Flag
H=Header Level Adjustment L=Line Level Adjustment N=No Adjustments Default Value: N |
| 11 | ADJUST_OPTION_BILL | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment Option Bill Rate
A=Flat Amount N=No Adjustment P=Percentage R=New Rate Default Value: N |
| 12 | ADJUSTMENT_BILLAMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Adjustment Bill Amount |
| 13 | ADJUSTMENT_BILLPCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Adjustment Bill Percent |
| 14 | ADJUSTMENT_BILL_RT | Number(27,3) | DECIMAL(26,3) NOT NULL | Adjustment Bill Rate |
| 15 | BILL_AMT_EXP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bill Amount |
| 16 | COST_AMT_EXP | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Amount Expense |
| 17 | MARGIN_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Margin Percent |
| 18 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: PSA_OPPTY_HDR.CURRENCY_CD |
| 19 | REVIEW | Character(1) | VARCHAR2(1) NOT NULL | Review |