MAMTTAUD

Match Table Audit

REFERENCED BY
MA89.2


UPDATED BY
MA00.1 MA00.4 MA01.1 MA189

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MTT-UNIQUE-I-D
Element: Unique I D		Bad Type 36
MTT-MATCH-TABLE
Element: Match Table		Alpha 10
MA00.1 MA00.4
MA01.1
MTT-ACTION
Element: Action		Alpha 1
MA00.1 MA00.4
MA01.1
MTT-OPERATOR
Element: Operator		Alpha 10
MA00.1 MA00.4
MA01.1
MTT-DATE
Element: Date		Numeric 8 (yyyymmdd)
MA00.1 MA00.4
MA01.1
MTT-TIME
Element: Sys Time		Numeric 6 (hhmmss)
MA00.1 MA00.4
MA01.1
MTT-PROGRAM
Element: Program		Alpha 5
MA00.1 MA00.4
MA01.1
MTT-FLD-NAME
Element: Fld Name		Alpha 15
MA00.1 MA00.4
MA01.1
MTT-FLD-NBR
Element: Fld Nbr		Numeric 4
MA00.1 MA00.4
MA01.1
MTT-OLD-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
MA00.1 MA00.4
MA01.1
MTT-NEW-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
MA00.1 MA00.4
MA01.1
MTT-DB-FILE-PFX
Element: Db File Pfx		Alpha 3


MAMTTAUD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MTTSET1 MATCH-TABLE
ACTION
DATE
TIME
UNIQUE-I-D
MA189 MA89.2
MTTSET2 MATCH-TABLE
DATE
TIME
ACTION
UNIQUE-I-D
MTTSET3 MATCH-TABLE
OPERATOR
ACTION
DATE
TIME
UNIQUE-I-D
MTTSET4 MATCH-TABLE
FLD-NAME
ACTION
DATE
TIME
UNIQUE-I-D
MTTUID UNIQUE-I-D


MAMTTAUD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Dictionary MADICT Required
MTT-DB-FILE-PFX->MDC-DB-FILE-PFX (MDCSET1)
MTT-FLD-NBR->MDC-FIELD-NBR
Match Table MAMATCHTBL Required
MTT-MATCH-TABLE->MAM-MATCH-TABLE

File created: Thu Jun 09 02:22:56 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.