TRX_UNDO_DL_AET

(SQL Table)
Index Back

State rec for TR_UNDO_DEAL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 ACCRUAL_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Used by AE (TR_EUROF) which recalculates fee positions after EURO conversion. It is ALLOCATION * FEE_AMT
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
5 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.
8 AS_OF_DATE Date(10) DATE As of Date
9 REV_ACCTG_FLAG Character(1) VARCHAR2(1) NOT NULL Represents whether to reverse accounting for an Undo Deal.

Default Value: N

10 RVSL_DATE_OPTN Character(1) VARCHAR2(1) NOT NULL Reversal Date Option
C=Current Date
O=Original Accounting Date
S=Specify Date
11 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.
12 COMBO_EDIT_TMPL Character(10) VARCHAR2(10) NOT NULL Record Template
13 TRANSACTION_LINE Number(3,0) SMALLINT NOT NULL The separate and distinct base instrument type components of a given deal transaction.
14 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
15 TRANSACTION_LEG Number(1,0) SMALLINT NOT NULL The separate and distinct business positions of a given deal transaction line.
1=Pay Leg
2=Receive Leg
16 PERIOD_START_DT Date(10) DATE Represents the date commencement point for a given time set utilized in cash worksheet processing.
17 PERIOD_END_DT Date(10) DATE Represents the date termination point for a given time set utilized in cash worksheet processing.
18 PERIOD_INT_ACCRUAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the amount of accrued interest attributable to an interest period for a given
19 DIFFDAYS1 Signed Number(17,2) DECIMAL(15,2) NOT NULL Used by AE (TR_EUROF) which recalculates fee positions after EURO conversion. It is the difference between FEE_END and FEE_START SCP - Modified to add a new label.Used in Scenario Summary Page
20 DIFFDAYS2 Signed Number(17,2) DECIMAL(15,2) NOT NULL Used by AE (TR_EUROF) which recalculates fee positions after EURO conversion. It is the difference between FEE_END and VALUE_DT SCP - Modified to add a new label.Used in Scenario Summary page
21 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
22 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
23 AE_DO_WHEN Character(1) VARCHAR2(1) NOT NULL When
24 AE_APPSTATUS Number(1,0) SMALLINT NOT NULL AE Application Warning Status
25 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
26 TREAS_PREVIOUS_ID Character(12) VARCHAR2(12) NOT NULL Previous ID for a given deal header for Partial Sell/Buy back.