OPRIDPrompt Table: OPRID_VW
RUN_CNTL_IDPrompt Table: SP_BU_PC_NONVW
Prompt Table: SALES_PERSN_VW
Prompt Table: PSA_SCENARIO
Prompt Table: PSA_OPPTY_HDR
Prompt Table: PSA_STATUS_DEFN
PSA_RUN_RPT_TBL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 4 | END_DATE | Date(10) | DATE | End Date |
| 5 | SALES_PERSON | Character(8) | VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.
Prompt Table: SALES_PERSN_VW |
| 6 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 7 | 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
Prompt Table: PSA_SCENARIO |
| 8 | OPPORTUNITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Opportunity ID
Prompt Table: PSA_OPPTY_HDR |
| 9 | STATUS_OPPORTUNITY | Character(3) | VARCHAR2(3) NOT NULL |
Opportunity Status
Prompt Table: PSA_STATUS_DEFN |
| 10 | CONFIDENCE_START | Number(3,0) | SMALLINT NOT NULL | Confindence Start |
| 11 | CONFIDENCE_END | Number(3,0) | SMALLINT NOT NULL | Confidence To |