MAINVREF

UPDATED BY
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP21.1 AP23.1 API1.1 MA41.1 MA41.2 MA41.4
MA41.7 MA42.1 MA42.2 MA43.2 MA44.1 MA44.2
MA70.1 MA75.1 MAI1.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MRF-COMPANY
Element: Company
Numeric 4
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
MRF-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
MRF-API-INVOICE
Element: Invoice
Alpha 22
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
MRF-API-SUFFIX
Element: Suffix
Numeric 3
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1
MRF-API-CANCEL-SEQ
Element: Seq Nbr
Numeric 4
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1
MRF-REF-INV-NBR
Element: Invoice
Alpha 22
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
MRF-REF-SUFFIX
Element: Suffix
Numeric 3
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2
MRF-REF-CANCEL-SEQ
Element: Seq Nbr
Numeric 4
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
API1.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2


MAINVREF FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MRFSET1 COMPANY
VENDOR
API-INVOICE
API-SUFFIX
API-CANCEL-SEQ
REF-INV-NBR
REF-SUFFIX
REF-CANCEL-SEQ
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.1 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1 MAI1.1
MRFSET2 COMPANY
VENDOR
REF-INV-NBR
REF-SUFFIX
REF-CANCEL-SEQ
API-INVOICE
API-SUFFIX
API-CANCEL-SEQ
MA42.1 MA70.1
MA75.1


MAINVREF FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apinvoice1 APINVOICE Required
MRF-COMPANY->API-COMPANY
MRF-VENDOR->API-VENDOR
MRF-API-INVOICE->API-INVOICE
MRF-API-SUFFIX->API-SUFFIX
MRF-API-CANCEL-SEQ->API-CANCEL-SEQ
Apinvoice2 APINVOICE Required
MRF-COMPANY->API-COMPANY
MRF-VENDOR->API-VENDOR
MRF-REF-INV-NBR->API-INVOICE
MRF-REF-SUFFIX->API-SUFFIX
MRF-REF-CANCEL-SEQ->API-CANCEL-SEQ


File created: Thu Jun 09 11:20:25 2016

Home
Contact Us



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