Audit trail for M3 master data

Requirement

In Germany, as required by audit regulations, master data changes must be traced.

M3 solution

Audit trail functionality is provided by M3.

Configuration guidelines

We recommend that you configure the audit trail functionality.

To access this functionality, you must have the IFS security role M3BE-FATAdmin. For more information on the audit trail functionality, see the M3 Core Administration Guide.

To access the setup and analysis functionality, select Administration Tools > Business Engine Field Audit Trail from the Infor M3 menu in Infor Ming.le®.

We recommend that you set up at least these tables:


Table	Description
CBANAC	Bank Accounts Master Table
CIDMAS	Supplier Master Table
CIDVEN	Supplier - Purchase & Finance
CMNDIV	Division Master Table
CMNFNG	M3 Functions
CMNPSU	Permission Setup
CMNROL	Role Definitions
CMNRUS	Roles per User
CMNUSR	User Definition Table
CSYPAR	System Parameters
FCHACC	Accounting Identities Master Table
OCUSMA	Customer Master Table

We recommend that you set up at least these columns per table:


Table	Description	Columns or comment
CBANAC	Bank Accounts Master Table	BCACGR BCAIT1 BCAIT2 BCAIT3 BCAIT4 BCAIT5 BCAIT6 BCAIT7 BCBANA BCBKNO BCCHID BCCUCD BCIBAN BCIBCN BCIBIB BCIBSW BCLMDT BCSWBI
CIDMAS	Supplier Master Table	IDCOR2 IDCORG IDCSCD IDSUNM IDVRNO
CIDVEN	Supplier - Purchase & Finance	IICRTP IICUCD IIIAPC IIIAPE IIIAPF IIIAPT IIOUCN IIPRSU IIPTDY IIPYME IISCNO IITECD IITEDL IITEPY IITXAP IIVTCD
CMNDIV	Division Master Table	CCACGR CCCDCD CCCOA1 CCCOA2 CCCOA3 CCCOA4 CCCONM CCCOR2 CCCORG CCCSCD CCCSVN CCDMCU CCDTFM CCECAR CCFACI CCGEMS CCISTA CCLOCD CCNPT1 CCPONO CCTATM CCTOWN CCVDME CCVRNO CCWHLO
CMNFNG	M3 Functions	JFAPP3 JFAUTY JFBBOF JFCHID JFCHNO JFCHPW JFFCMD JFFNLA JFFNMV JFFNT3 JFFVDT JFJOB JFLLID JFLMDT JFLMTS JFLOGL JFLVDT JFMAON JFMASH JFMDEV JFMID1 JFMID2 JFMSF1 JFMSF2 JFPGNM JFPRTF JFRCLR JFRGDT JFRGTM JFSEID JFSFID JFSPIC JFSTAT JFTX15 JFTX40 JFTXID JFURLA
CMNPSU	Permission Setup	KSALO KSCHID KSCHNO KSKKO KSLMDT KSLMTS KSOKO KSRGDT KSRGTM KSSTAT KSTXID
CMNROL	Role Definitions	KRCHID KRCHNO KRLMDT KRLMTS KRRGDT KRRGTM KRROLT KRTX15 KRTX40 KRTXID
CMNRUS	Roles per User	KUCHID KUCHNO KUFVDT KULMDT KULMTS KURGDT KURGTM KUTXID KUVTDT
CMNUSR	User Definition Table	Define all fields.
CSYPAR	System Parameters	CPCHID CPCHNO CPLMDT CPMGSQ CPPARM CPRGDT CPRGTM
FCHACC	Accounting Identities Master Table	EAACGR EAAICL EAAPCG EAAT01 EAAT02 EAAT03 EAAT04 EAAT05 EAAT06 EAAT07 EAAT08 EAAT09 EAAT10 EAAT11 EAAT12 EAAT13 EABUAC EACAAC EACCCD EACHID EACICT EACLRA EACUCD EALCCD EALMDT EAMQCD EAMTCD EAOUAC EAPCA1 EARECE EARESP EASLCD EASTOA EATX15 EATX40 EAVFDT EAVTDT EAAT14
OCUSMA	Customer Master Table	OKBLCD OKCOR2 OKCORG OKCRL2 OKCRL3 OKCRLM OKCSCD OKCUA1 OKCUA2 OKCUA3 OKCUA4 OKCUCD OKCUNM OKMODL OKPYCD OKPYNO OKTECD OKTEDL OKTEPY OKTXAP OKVRNO OKVTCD OKCUCL OKRGDT OKPONO