<M3 Table>

An example of an M3 Table is MITMAS.

Operation Elements Example*

C (Create)

When a new record is created

keyValue, startProgam, currentProgram, [Program properties], [Table columns]

                M3:MITMAS:C
startProgram=MMS001;
currentProgram=MITMASPI;
startTimeMillis=1327331743637;
owner=M3User;
startTime=2012-01-23 16:15:43;
jobUUID=533d5c25cecb43b884707ef1bafc4bd5;
sessionID=11.22.3.444:63547_0-0;
CWUN=PCE;
STAT=20;
...
ITNO=I012345        ;
...
CONO=330;
LMDT=20120123;
CONC=0;
SCGR=0.0;
keyValue=MMCONO,330,MMITNO,I012345++++++++;
environment=M3BEEnv;
version=1410;
application=M3;

U (Update)

When a record is updated

keyValue, startProgam, currentProgram, [Program properties], [Table columns (with old values if they are present)]

                M3:MITMAS:U
startProgram=MMS001;
currentProgram=MITMASPI;
startTimeMillis=1327331743637;
owner=M3User;
startTime=2012-01-23 16:15:43;
jobUUID=533d5c25cecb43b884707ef1bafc4bd5;
sessionID=11.22.3.444:63547_0-0;
CWUN=PCE(PCE);
STAT=20(20);
...
ITNO=I012345        (I012345        );
...
CONO=330(330);
LMDT=20120123(20120123);
CONC=0(0);
SCGR=0.0(0.0);
keyValue=MMCONO,330,MMITNO,I012345++++++++;
environment=M3BEEnv;
version=1410;
application=M3;

D (Delete)

When a record is deleted

keyValue, startProgam, currentProgram, [Program properties]

                M3:MITMAS:D
startProgram=MMS001;
currentProgram=MWMNGFDE;
startTimeMillis=1327331743637;
owner=M3User;
startTime=2012-01-23 16:15:43;
jobUUID=533d5c25cecb43b884707ef1bafc4bd5;
sessionID=11.22.3.444:63547_0-0;
CWUN=PCE;
STAT=90;
...
ITNO=I012345        ;
...
CONO=330;
LMDT=20120123;
CONC=0;
SCGR=0.0;
keyValue=MMCONO,330,MMITNO,I012345++++++++;
environment=M3BEEnv;
version=1410;
application=M3;