ARCOMPAUD

AR Company Audit

REFERENCED BY
AC56.1 AC560 BR02.3 BR10.1 BR10.9 BR11.1
BR120 BR121 BR122 BR123 BR131 BR140
BR145 BR151 BR152 BR156 BR157 BR16.1
BR16.2 BR17.1 BR180 BR19.1 BR20.1 BR20.2
BR20.3 BR20.4 BR20.5 BR20.7 BR21.1 BR211
BR216 BR217 BR220 BR245 BR252 BR300
BR420 BR45.1 BR450 BR46.1 BR46.2 BR46.4
BR48.1 BR49.1 BR521 BR91.1 BRIP.1 TX101
TX140 TX226 TX301 WH20.2 WH20.7


UPDATED BY
AR01.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RAU-UNIQUE-I-D
Element: Unique I D		Bad Type 36
RAU-COMPANY
Element: Company		Numeric 4
AR01.1
RAU-CUST-GROUP
Element: Cust Group		Alpha 5
AR01.1
RAU-ACTION
Element: Action		Alpha 1
AR01.1
RAU-OPERATOR
Element: Operator		Alpha 10
AR01.1
RAU-DATE
Element: Date		Numeric 8 (yyyymmdd)
AR01.1
RAU-TIME
Element: Sys Time		Numeric 6 (hhmmss)
AR01.1
RAU-PROGRAM
Element: Program		Alpha 5
AR01.1
RAU-FLD-NAME
Element: Fld Name		Alpha 15
AR01.1
RAU-FLD-NBR
Element: Fld Nbr		Numeric 4
AR01.1
RAU-OLD-VALUE
Element: Description		Alpha 30 (Lower Case)
AR01.1
RAU-NEW-VALUE
Element: Description		Alpha 30 (Lower Case)
AR01.1
RAU-DB-FILE-PFX
Element: Db File Pfx		Alpha 3
AR01.1


ARCOMPAUD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RAUSET1 COMPANY
UNIQUE-I-D
...
AC56.1 AC560
BR02.3 BR10.1
BR10.9 BR11.1
BR120 BR121
BR122 BR123
BR131 BR140
BR145 BR151
BR152 BR156
BR157 BR16.1
BR16.2 BR17.1
BR180 BR19.1
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR20.7
BR21.1 BR211
RAUSET2 CUST-GROUP
COMPANY
UNIQUE-I-D
RAUSET3 COMPANY
DATE
OPERATOR
UNIQUE-I-D
RAUUID UNIQUE-I-D


ARCOMPAUD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
RAU-COMPANY->ACO-COMPANY (ACOSET1)
Ardict ARDICT Required
RAU-DB-FILE-PFX->ARY-DB-FILE-PFX
RAU-FLD-NBR->ARY-FLD-NBR

File created: Thu Jun 09 02:09:00 2016

Home
Contact Us



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