OPRIDPrompt Table: OPRID_VW
RUN_CNTL_IDPrompt Table: SP_BU_TRD_NONVW
Prompt Table: TRX_HEADER_TR
Y/N Table Edit
Default Value: N
C=Current Date
O=Original Accounting Date
S=Specify Date
Prompt Table: TRA_COMBTMPL_VW
TRX_UNDO_DL_REQ(SQL Table) |
Index Back |
|---|---|
Position Update RequestRequests made to create/update Position records for Treasury Deals |
| # | 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_TRD_NONVW |
| 4 | TREAS_HEADER_ID | Character(12) | VARCHAR2(12) NOT NULL |
The unique key identifier for a given deal transaction.
Prompt Table: TRX_HEADER_TR |
| 5 | AS_OF_DATE | Date(10) | DATE NOT NULL | As of Date |
| 6 | REV_ACCTG_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Represents whether to reverse accounting for an Undo Deal.
Y/N Table Edit Default Value: N |
| 7 | RVSL_DATE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Reversal Date Option
C=Current Date O=Original Accounting Date S=Specify Date |
| 8 | REVERSAL_DATE | Date(10) | DATE | Specifies the date for an automatic reversal journal entry. The date must be within the calendar of the target (posting) ledger. PeopleSoft General Ledger automatically creates and populates a journal entry with this date. |
| 9 | COMBO_EDIT_TMPL | Character(10) | VARCHAR2(10) NOT NULL |
Record Template
Prompt Table: TRA_COMBTMPL_VW |