MU_TP_TRANS_TBL (SQL Table)	Index Back
Transaction Table Table of transactions to be processed by the Transaction Processor. This table is generated by any product that needs to process changes in the application. It is used primary by Mass Update processes.

MU_TP_TRANS_TBL

(SQL Table)

Transaction Table

Table of transactions to be processed by the Transaction Processor. This table is generated by any product that needs to process changes in the application. It is used primary by Mass Update processes.

Parent Record Of MU_TP_DATES MU_TP_DATES_HST MU_TP_TRANS_LOG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MU_TRANS_SRC Character(10) VARCHAR2(10) NOT NULL Transaction Source

2 MU_TRANS_REF Character(15) VARCHAR2(15) NOT NULL Transaction Reference

3 MU_TRANS_ID Number(10,0) DECIMAL(10) NOT NULL Transaction ID

4 MU_EXEC_STATUS_FLG Character(1) VARCHAR2(1) NOT NULL Mass Update execution result status flag.
C=Cancel
F=Failure
R=Ready
S=Success
W=Warning

5 MU_TRANS_XML Long Character CLOB Transaction (XML)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MU_TRANS_SRC	Character(10)	VARCHAR2(10) NOT NULL	Transaction Source
2	MU_TRANS_REF	Character(15)	VARCHAR2(15) NOT NULL	Transaction Reference
3	MU_TRANS_ID	Number(10,0)	DECIMAL(10) NOT NULL	Transaction ID
4	MU_EXEC_STATUS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Mass Update execution result status flag. C=Cancel F=Failure R=Ready S=Success W=Warning
5	MU_TRANS_XML	Long Character	CLOB	Transaction (XML)