MACOAUD

Matching Company Audit

REFERENCED BY
MA89.1


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

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


MACOAUD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MCTSET1 COMPANY
ACTION
DATE
TIME
UNIQUE-I-D
MA189 MA89.1
MCTSET2 COMPANY
DATE
TIME
ACTION
UNIQUE-I-D
MCTSET3 COMPANY
OPERATOR
ACTION
DATE
TIME
UNIQUE-I-D
MCTSET4 COMPANY
FIELD-ID
ACTION
DATE
TIME
UNIQUE-I-D
MCTUID UNIQUE-I-D


MACOAUD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company MACOMPANY Required
MCT-COMPANY->MAY-COMPANY (MAYSET1)
Dictionary MADICT Required
MCT-DB-FILE-PFX->MDC-DB-FILE-PFX
MCT-FIELD-ID->MDC-FIELD-NBR

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

Home
Contact Us



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