MAAOIHIST

UPDATED BY
AP115 AP180 AP181 AP190 AP198 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP23.1 AP25.2 AP26.1 AP27.1 AP28.1 AP28.2
AP30.4 AP305 AP45.1 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA44.1 MA44.2 MA70.1
MA75.1 AP300

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MH2-COMPANY
Element: Company		Numeric 4
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.
AP198
MH2-PO-NUMBER
Element: Po Number		Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
AP198
MH2-PO-RELEASE
Element: Po Release		Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
AP198
MH2-PO-CODE
Element: Po Code		Alpha 4
This is the purchase order code.
AP198
MH2-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code.
AP115 AP198
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.2 AP26.1
AP27.1 AP30.4
AP305 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1
MH2-INVOICE
Element: Invoice		Alpha 22
Used to identify the invoice.
AP115 AP198
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.2 AP26.1
AP27.1 AP30.4
AP305 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1
MA75.1
MH2-SUFFIX
Element: Suffix		Numeric 3
This is the suffix for the invoice.
AP198
MH2-MATCH-REF-NBR
Element: Match Ref Nbr		Alpha 22
AP198
MH2-TAX-CODE
Element: Tax Code		Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
AP198
MH2-LOCATION
Element: Location		Alpha 5
This field contains a valid stocking location within the company inventory.
AP198
MH2-INVOICE-TYPE
Element: Invoice Type		Alpha 1
THis field will be filled in from the Invoice based on PO number. This is a carrier for the field. The PORECEIVE file will have to be updated with this field.
AP198


MAAOIHIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MH2SET1 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
VENDOR
INVOICE
SUFFIX
MH2SET2 COMPANY
VENDOR
INVOICE
SUFFIX
PO-NUMBER
PO-RELEASE
PO-CODE
...
AP115 AP180
AP181 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP300 AP305
AP45.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA70.1


MAAOIHIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Apapihist APAPIHIST Required
MH2-COMPANY->AH1-COMPANY
MH2-VENDOR->AH1-VENDOR
MH2-INVOICE->AH1-INVOICE
MH2-SUFFIX->AH1-SUFFIX
Zeroes->AH1-CANCEL-SEQ
Apcompany APCOMPANY Required
MH2-COMPANY->CPY-COMPANY
Purchorder PURCHORDER Required
MH2-COMPANY->PCR-COMPANY
MH2-PO-CODE->PCR-PO-CODE
MH2-PO-NUMBER->PCR-PO-NUMBER
MH2-PO-RELEASE->PCR-PO-RELEASE
Vendor APVENMAST Required
CPY-VENDOR-GROUP->VEN-VENDOR-GROUP
MH2-VENDOR->VEN-VENDOR


MAAOIHIST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Mamadhist MAMADHIST
MH2-COMPANY->MH1-COMPANY
MH2-VENDOR->MH1-VENDOR
MH2-INVOICE->MH1-INVOICE
MH2-SUFFIX->MH1-SUFFIX
MH2-PO-NUMBER->MH1-PO-NUMBER
MH2-PO-RELEASE->MH1-PO-RELEASE
MH2-PO-CODE->MH1-PO-CODE
  MH1-LINE-NBR
  MH1-AOC-CODE
  MH1-SEQ-NBR
Mamadhist All MAMADHIST
MH2-COMPANY->MH1-COMPANY
MH2-VENDOR->MH1-VENDOR
MH2-INVOICE->MH1-INVOICE
MH2-SUFFIX->MH1-SUFFIX
  MH1-PO-NUMBER
  MH1-PO-RELEASE
  MH1-PO-CODE
  MH1-LINE-NBR
  MH1-AOC-CODE
  MH1-SEQ-NBR
Popsphist POPSPHIST Delete Cascades
MH2-COMPANY->PH1-COMPANY
MH2-INVOICE->PH1-PO-NUMBER
  PH1-PO-RELEASE
  PH1-PO-CODE
  PH1-AOC-CODE
  PH1-INVOICE

File created: Thu Jun 09 02:22:42 2016

Home
Contact Us



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