Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.MSOUI_W_TRANSACTION_HIST
Table FPSINPUT.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: FPSINPUT
-
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 |