ACEMPVEN FILE
REFERENCED BY
AC259 AC550 AC551 AC542 AP170
UPDATED BY
AC559 AC59.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AEP-COMPANY Numeric 4 AC559 AC59.1
Element: Company The company number represents an
established company and is entered on
all function codes.
AEP-EMPLOYEE Numeric 9 AC559 AC59.1
Element: Employee Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
AEP-APCOMPANY Numeric 4 AC59.1
Element: Apcompany
AEP-VENDOR Alpha 9 (Right Justified) AC59.1
Element: Vendor ID The vendor's identification code.
AEP-PROC-LEVEL Alpha 5 AC59.1
Element: Process Level
ACEMPVEN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AEPSET1 COMPANY AC259 AC550
EMPLOYEE AC551 AC559
AC59.1
AEPSET2 APCOMPANY KeyChange AC542 AC59.1
VENDOR AP170
COMPANY
EMPLOYEE
ACEMPVEN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
AEP-APCOMPANY -> CPY-COMPANY
Approclev APPROCLEV Required
AEP-APCOMPANY -> APR-COMPANY
AEP-PROC-LEVEL -> APR-PROC-LEVEL
Apvenmast APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
AEP-VENDOR -> VEN-VENDOR
Employee EMPLOYEE Required
AEP-COMPANY -> EMP-COMPANY
AEP-EMPLOYEE -> EMP-EMPLOYEE
|
