Data Dictionary
>
FPSBASE Tables
> FPSBASE.MSOUI_W_TRANSACTION_HIST
Table FPSBASE.MSOUI_W_TRANSACTION_HIST"
Master MSO transaction history. All changes are made at lower level tables. One record for each transaction is stored in this table and the transaction id is what links all the sub tables together based on the parent_transaction_id.
-
Schema: FPSBASE
-
Tablespace: FPSDATAHIST
-
Primary key: TRANSACTION_ID
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
TRANSACTION_ID |
VARCHAR2(75) |
N |
|
|
OS_USER_ID |
VARCHAR2(50) |
N |
|
|
TRANSACTION_CHANGE_DESC |
VARCHAR2(1000) |
N |
|
|
TRANSACTION_CHANGE_TYPE |
VARCHAR2(100) |
N |
|
|
TRANSACTION_COMMENT |
VARCHAR2(2000) |
||
|
TRANSACTION_INST |
DATE |