APCOMPAUD

AP Company Audit

REFERENCED BY
AP89.1


UPDATED BY
AP00.4 AP00.6 AP00.7 AP101 AP189

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CAP-UNIQUE-I-D
Element: Unique I D		Bad Type 36
CAP-COMPANY
Element: Company		Numeric 4
AP00.4 AP00.6
AP00.7 AP101
CAP-VENDOR-GROUP
Element: Vendor Group		Alpha 4
AP00.4 AP00.6
AP00.7 AP101
CAP-PAY-GROUP
Element: Pay Group		Alpha 4
AP00.4 AP00.6
AP00.7 AP101
CAP-ACTION
Element: Action		Alpha 1

A = Add
D = Delete
C = Change
AP00.4 AP00.6
AP00.7 AP101
CAP-OPERATOR
Element: Operator		Alpha 10
AP00.4 AP00.6
AP00.7 AP101
CAP-DATE
Element: Date		Numeric 8 (yyyymmdd)
AP00.4 AP00.6
AP00.7 AP101
CAP-TIME
Element: Sys Time		Numeric 6 (hhmmss)
AP00.4 AP00.6
AP00.7 AP101
CAP-PROGRAM
Element: Program Code		Alpha 5
AP00.4 AP00.6
AP00.7 AP101
CAP-FLD-NAME
Element: Fld Name		Alpha 15
AP00.4 AP00.6
AP00.7 AP101
CAP-FLD-NBR
Element: Fld Nbr		Numeric 4
AP00.4 AP00.6
AP00.7 AP101
CAP-OLD-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
AP00.4 AP00.6
AP00.7 AP101
CAP-NEW-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
AP00.4 AP00.6
AP00.7 AP101
CAP-DB-FILE-PFX
Element: Db File Pfx		Alpha 3
AP00.4 AP00.6
AP00.7 AP101
CAP-USER-FLD-TYPE
Element: User Fld Type		Alpha 1
AP00.4 AP00.6
AP00.7 AP101
CAP-APPROVAL-TYPE
Element: Approval Type		Alpha 1
AP00.4 AP00.6
AP00.7 AP101
CAP-PROC-LEVEL
Element: Process Level		Alpha 5
AP00.4 AP00.6
AP00.7 AP101
CAP-FIELD-DESC
Element: Field Desc		Derived
CAP-ACCT-STRCT
Element: Acct Strct		Alpha 15
AP00.4 AP00.6
AP00.7 AP101


APCOMPAUD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CAPSET1 COMPANY
ACTION
DATE
TIME
UNIQUE-I-D
AP189 AP89.1
CAPSET2 VENDOR-GROUP
COMPANY
ACTION
DATE
TIME
UNIQUE-I-D
KeyChange
CAPSET3 PAY-GROUP
COMPANY
ACTION
DATE
TIME
UNIQUE-I-D
KeyChange
CAPSET4 COMPANY
DATE
TIME
ACTION
UNIQUE-I-D
KeyChange
CAPSET5 COMPANY
OPERATOR
ACTION
DATE
TIME
UNIQUE-I-D
KeyChange
CAPSET6 COMPANY
FLD-NAME
ACTION
DATE
TIME
UNIQUE-I-D
KeyChange
CAPSET7 COMPANY
USER-FLD-TYPE
VENDOR-GROUP
UNIQUE-I-D
KeyChange
CAPSET8 APPROVAL-TYPE
COMPANY
PROC-LEVEL
UNIQUE-I-D
KeyChange
CAPSET9 COMPANY
ACCT-STRCT
UNIQUE-I-D
CAPUID UNIQUE-I-D


APCOMPAUD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company APCOMPANY Required
CAP-COMPANY->CPY-COMPANY (CPYSET1)
Dictionary APDICT2 Required
CAP-DB-FILE-PFX->AP2-DB-FILE-PFX
CAP-FLD-NBR->AP2-FLD-NBR

File created: Thu Jun 09 02:06:57 2016

Home
Contact Us



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