OPRIDRUN_CNTL_IDPrompt Table: SP_BU_TRD_NONVW
E=External
I=Internal
N=Netting
O=Origin
01=Under Negotiation
02=Sample
03=Open
04=Matured
05=Deactivated
06=Rejected
07=Sold / Bought back
08=Forecasted
09=Partially Sold/Bought Back
RUN_CNTL_FXDL_T(SQL Table) |
Index Back |
|---|---|
Run Control for FX Trade |
| # | 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 | 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 |
| 5 | 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 |
| 6 | FROM_DATE | Date(10) | DATE | From Date |
| 7 | TO_DATE | Date(10) | DATE | To Date |
| 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 |