|
|
ACEMPVEN FILE
REFERENCED BY
AP170
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AEP-COMPANY Numeric 4
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
AEP-EMPLOYEE Numeric 9
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
Element: Apcompany
AEP-VENDOR Alpha 9 (Right Justified)
Element: Vendor ID The vendor's identification code.
AEP-PROC-LEVEL Alpha 5
Element: Process Level The process level represents a
reporting level below company.
ACEMPVEN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AEPSET1 COMPANY
EMPLOYEE
AEPSET2 APCOMPANY KeyChange AP170
VENDOR
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
|
