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 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
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 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
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 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6


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
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
MRFSET2 COMPANY
VENDOR
REF-INV-NBR
REF-SUFFIX
REF-CANCEL-SEQ
API-INVOICE
API-SUFFIX
API-CANCEL-SEQ


MAINVREF FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Apinvoice1 APINVOICE Required
MRF-COMPANY->API-COMPANY (APISET1)
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: Wed Jun 08 20:50:10 2016

Home
Contact Us



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