MAAOIHIST – No description in the Lawson data dictionary

System
Matching (MA)
Prefix
MH2
Primary key
COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, VENDOR, INVOICE, SUFFIX
Fields
11
Updated by
32 programs
Referenced by
0 programs

MAAOIHIST is a Lawson Matching table (prefix MH2); no description in the lawson data dictionary. It is indexed by COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, VENDOR, INVOICE, SUFFIX (MH2SET1); alternate indexes: MH2SET2. It is related 1:1 to APAPIHIST, APCOMPANY, PURCHORDER and APVENMAST and 1:M to MAMADHIST and POPSPHIST. It is updated by AP115, AP180, AP181, AP190, AP198, AP20.1, AP20.2, AP20.3 and 24 more. The table has 11 fields, 2 indexes and 7 documented relations.

About MAAOIHIST

No description in the Lawson data dictionary.

Fields (11)

Column = COBOL field name without the MH2- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#MH2-COMPANY PK
COMPANY		Numeric 4Identifies 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 PK
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.AP198
#MH2-PO-RELEASE PK
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AP198
#MH2-PO-CODE PK
PO_CODE		Alpha 4This is the purchase order code.AP198
#MH2-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP115, AP198, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +17 more
#MH2-INVOICE PK
INVOICE		Alpha 22Used to identify the invoice.AP115, AP198, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +17 more
#MH2-SUFFIX PK
SUFFIX		Numeric 3This is the suffix for the invoice.AP198
#MH2-MATCH-REF-NBR
MATCH_REF_NBR		Alpha 22—AP198
#MH2-TAX-CODE
TAX_CODE		Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.AP198
#MH2-LOCATION
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.AP198
#MH2-INVOICE-TYPE
INVOICE_TYPE		Alpha 1THis 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

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MH2SET1
  1. COMPANY
  2. PO-NUMBER
  3. PO-RELEASE
  4. PO-CODE
  5. VENDOR
  6. INVOICE
  7. SUFFIX
Primary—
MH2SET2
  1. COMPANY
  2. VENDOR
  3. INVOICE
  4. SUFFIX
  5. PO-NUMBER
  6. PO-RELEASE
  7. PO-CODE
AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APAPIHISTAPCOMPANYPURCHORDERAPVENMASTMAMADHISTPOPSPHISTMAAOIHIST

One to one (4) — lookups and parents

RelationTableRulesConditionField map
ApapihistAPAPIHISTRequired
MH2-COMPANY→AH1-COMPANY
MH2-VENDOR→AH1-VENDOR
MH2-INVOICE→AH1-INVOICE
MH2-SUFFIX→AH1-SUFFIX
Zeroes→AH1-CANCEL-SEQ
ApcompanyAPCOMPANYRequired
MH2-COMPANY→CPY-COMPANY
PurchorderPURCHORDERRequired
MH2-COMPANY→PCR-COMPANY
MH2-PO-CODE→PCR-PO-CODE
MH2-PO-NUMBER→PCR-PO-NUMBER
MH2-PO-RELEASE→PCR-PO-RELEASE
VendorAPVENMASTRequired
CPY-VENDOR-GROUP→VEN-VENDOR-GROUP
MH2-VENDOR→VEN-VENDOR

One to many (3) — child tables

RelationTableRulesConditionField map
MamadhistMAMADHIST
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 AllMAMADHIST
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
PopsphistPOPSPHISTDelete Cascades
MH2-COMPANY→PH1-COMPANY
MH2-INVOICE→PH1-PO-NUMBER
—→PH1-PO-RELEASE
—→PH1-PO-CODE
—→PH1-AOC-CODE
—→PH1-INVOICE

Programs

Updated by (32)