OPRIDRUN_CNTL_IDPrompt Table: SP_BU_TRD_NONVW
01=Under Negotiation
02=Sample
03=Open
04=Matured
05=Deactivated
06=Rejected
07=Sold / Bought back
08=Forecasted
09=Partially Sold/Bought Back
Default Value: 04
E=External
I=Internal
N=Netting
O=Origin
RUN_CNTL_CTPY(SQL Table) |
Index Back |
|---|---|
Run Control for Debt/InvDeals by Counterparty -- Maturity Date |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 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_TRD_NONVW |
| 4 | START_DATE | Date(10) | DATE NOT NULL | Start Date for Gen Standing PO |
| 5 | END_DATE | Date(10) | DATE NOT NULL | End Date |
| 6 | DEAL_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Represents the specific state or point in the life cycle of a deal transaction.
01=Under Negotiation 02=Sample 03=Open 04=Matured 05=Deactivated 06=Rejected 07=Sold / Bought back 08=Forecasted 09=Partially Sold/Bought Back Default Value: 04 |
| 7 | BANK_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
"An attribute that determines whether a bank or counterparty is defined as being internal or external
E=External I=Internal N=Netting O=Origin |
| 8 | TR_DATE_LBL_RFT | Character(1) | VARCHAR2(1) NOT NULL | Settlement Date Parameters |
| 9 | TR_RPT_PARM_RFT | Character(1) | VARCHAR2(1) NOT NULL | Report Request Parameters |