ACSTRUCTAU

Activity Structure Audit

REFERENCED BY
AC88.4 AC208


UPDATED BY
AC08.1 AC08.2 AC08.3 AC08.4 AC08.5 AC08.6
AC08.7 AC108 AC305 AC558

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATU-UNIQUE-I-D
Element: Unique I D		Bad Type 36
ATU-STRUCTURE
Element: Structure		Alpha 15
AC08.1 AC08.2
AC08.3 AC08.4
AC08.5 AC08.6
AC08.7 AC108
AC558
ATU-CATEGORY-TYPE
Element: Category Type		Alpha 1
AC08.1 AC08.2
AC08.3 AC08.4
AC08.5 AC08.6
AC08.7 AC108
AC558
ATU-SUM-ACCT-CAT
Element: Sum Acct Cat		Alpha 5
AC08.1 AC08.2
AC08.3 AC08.4
AC08.5 AC08.6
AC08.7 AC108
AC558
ATU-ACCT-CATEGORY
Element: Acct Category		Alpha 5
AC08.2 AC08.3
AC08.4 AC08.5
AC08.7 AC108
AC558
ATU-ACTION
Element: Action		Alpha 1
AC08.1 AC08.2
AC08.3 AC08.4
AC08.5 AC08.6
AC08.7 AC108
AC558
ATU-OPERATOR
Element: Operator		Alpha 10
AC08.1 AC08.2
AC08.3 AC08.4
AC08.5 AC08.6
AC08.7 AC108
AC558
ATU-DATE
Element: Date		Numeric 8 (yyyymmdd)
AC08.1 AC08.2
AC08.3 AC08.4
AC08.5 AC08.6
AC08.7 AC108
AC558
ATU-TIME
Element: Sys Time		Numeric 6 (hhmmss)
AC08.1 AC08.2
AC08.3 AC08.4
AC08.5 AC08.6
AC08.7 AC108
AC558
ATU-PROGRAM
Element: Program Code		Alpha 5
AC08.1 AC08.2
AC08.3 AC08.4
AC08.5 AC08.6
AC08.7 AC108
AC558
ATU-FIELD-NAME
Element: Fld Name		Alpha 15
AC08.1 AC08.2
AC08.3 AC08.4
AC08.5 AC08.6
AC08.7 AC108
AC558
ATU-FIELD-ID
Element: Fld Nbr		Numeric 4
AC08.1 AC08.2
AC08.3 AC08.4
AC08.5 AC08.6
AC08.7 AC108
AC558
ATU-OLD-VALUE
Element: Description		Alpha 30 (Lower Case)
AC08.1 AC08.2
AC08.3 AC08.4
AC08.5 AC08.6
AC08.7 AC108
AC558
ATU-NEW-VALUE
Element: Description		Alpha 30 (Lower Case)
AC08.1 AC08.2
AC08.3 AC08.4
AC08.5 AC08.6
AC08.7 AC108
AC558


ACSTRUCTAU FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATUSET1 STRUCTURE
UNIQUE-I-D
AC305 AC88.4
ATUSET2 STRUCTURE
DATE
OPERATOR
UNIQUE-I-D
AC208 AC305
AC88.4
ATUSET3 STRUCTURE
SUM-ACCT-CAT
DATE
OPERATOR
UNIQUE-I-D
AC88.4
ATUUID UNIQUE-I-D


ACSTRUCTAU FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Accatsum ACCATSUM Required
ATU-STRUCTURE->SRS-STRUCTURE (SRSSET1)
ATU-SUM-ACCT-CAT->SRS-SUM-ACCT-CAT
Accatsumx ACCATSUM Required
ATU-STRUCTURE->SRS-STRUCTURE
ATU-SUM-ACCT-CAT->SRS-SUM-ACCT-CAT

File created: Thu Jun 09 02:03:13 2016

Home
Contact Us



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