MAPOINV – Multiple PO Invoice

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

MAPOINV is the Multiple PO Invoice table in Lawson Matching (prefix AOI). It is indexed by COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, VENDOR, INVOICE, SUFFIX (AOISET1); alternate indexes: AOISET2. It is related 1:1 to APBATCH, APCOMPANY, APINVOICE, ICCOMPANY, MACOMPANY, POCOMPANY, PURCHORDER, APVENMAST and 1 more and 1:M to MAINVDTL, POAOCDTL, POAOCSPRD, POLINE, PORECEIVE and PORECLINE. It is updated by AP115, AP180, AP181, AP190, AP198, AP20.1, AP20.2, AP20.3 and 26 more and referenced by AM19.1, AM19.2, AP125, AP126, AP131, AP220, AP510, API2.1 and 207 more. The table has 11 fields, 2 indexes and 16 documented relations.

About MAPOINV

The Matching Purchase Order file contains header information for purchase orders.

Fields (11)

Column = COBOL field name without the AOI- 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
#AOI-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.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +24 more
#AOI-PO-NUMBER PK
PO_NUMBER		Alpha 14 (Right Justified)The purchase order number.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +24 more
#AOI-PO-RELEASE PK
PO_RELEASE		Numeric 4Identifies a purchase order release (created from a blanket or standing order).AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +24 more
#AOI-PO-CODE PK
PO_CODE		Alpha 4Purchase order code.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +24 more
#AOI-VENDOR PK
VENDOR		Alpha 9 (Right Justified)Vendor identification code.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +24 more
#AOI-INVOICE PK
INVOICE		Alpha 22Invoice number.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +24 more
#AOI-SUFFIX PK
SUFFIX		Numeric 3The suffix of the invoice.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +24 more
#AOI-MATCH-REF-NBR
MATCH_REF_NBR		Alpha 22Matching reference number used to match invoices.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +24 more
#AOI-TAX-CODE
TAX_CODE		Alpha 10Tax code. Represents specific tax information and rules.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +24 more
#AOI-LOCATION
LOCATION		Alpha 5A valid stocking location within the company inventory.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +24 more
#AOI-INVOICE-TYPE
INVOICE_TYPE		Alpha 1Invoice type.AP115, AP180, AP181, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +24 more

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
AOISET1
  1. COMPANY
  2. PO-NUMBER
  3. PO-RELEASE
  4. PO-CODE
  5. VENDOR
  6. INVOICE
  7. SUFFIX
PrimaryAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)
AOISET2
  1. COMPANY
  2. VENDOR
  3. INVOICE
  4. SUFFIX
  5. PO-NUMBER
  6. PO-RELEASE
  7. PO-CODE
KeyChangeAP115, AP125, AP126, AP198, 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)
APBATCHAPCOMPANYAPINVOICEICCOMPANYMACOMPANYPOCOMPANYPURCHORDERAPVENMASTAPVENLOCMAINVDTLPOAOCDTLPOAOCSPRDPOLINEPORECEIVEPORECLINEMAPOINV

One to one (9) — lookups and parents

RelationTableRulesConditionField map
ApbatchAPBATCHNot Required
AOI-COMPANY→APB-COMPANY
API-BATCH-NUM→APB-BATCH-NUM
ApcompanyAPCOMPANYRequired
AOI-COMPANY→CPY-COMPANY
ApinvoiceAPINVOICERequired
AOI-COMPANY→API-COMPANY
AOI-VENDOR→API-VENDOR
AOI-INVOICE→API-INVOICE
AOI-SUFFIX→API-SUFFIX
Zeroes→API-CANCEL-SEQ
IccompanyICCOMPANYRequired
AOI-COMPANY→ICC-COMPANY
MacompanyMACOMPANYRequired
AOI-COMPANY→MAY-COMPANY
PocompanyPOCOMPANYRequired
AOI-COMPANY→PCY-COMPANY
PurchorderPURCHORDERRequired
AOI-COMPANY→PCR-COMPANY
AOI-PO-CODE→PCR-PO-CODE
AOI-PO-NUMBER→PCR-PO-NUMBER
AOI-PO-RELEASE→PCR-PO-RELEASE
VendorAPVENMASTRequired
CPY-VENDOR-GROUP→VEN-VENDOR-GROUP
AOI-VENDOR→VEN-VENDOR
VendorlocAPVENLOCNot RequiredValid When PCR-PURCH-FR-LOC != Spaces
CPY-VENDOR-GROUP→VLO-VENDOR-GROUP
AOI-VENDOR→VLO-VENDOR
PCR-PURCH-FR-LOC→VLO-LOCATION-CODE

One to many (7) — child tables

RelationTableRulesConditionField map
MainvdtlMAINVDTL
AOI-COMPANY→MAD-COMPANY
AOI-VENDOR→MAD-VENDOR
AOI-INVOICE→MAD-INVOICE
AOI-SUFFIX→MAD-SUFFIX
AOI-PO-NUMBER→MAD-PO-NUMBER
AOI-PO-RELEASE→MAD-PO-RELEASE
AOI-PO-CODE→MAD-PO-CODE
—→MAD-LINE-NBR
—→MAD-SEQ-NBR
Mainvdtl AllMAINVDTL
AOI-COMPANY→MAD-COMPANY
AOI-VENDOR→MAD-VENDOR
AOI-INVOICE→MAD-INVOICE
AOI-SUFFIX→MAD-SUFFIX
—→MAD-PO-NUMBER
—→MAD-PO-RELEASE
—→MAD-PO-CODE
—→MAD-LINE-NBR
—→MAD-SEQ-NBR
PoaochdrdtlPOAOCDTL
AOI-COMPANY→PAO-COMPANY
Spaces→PAO-PROCURE-GROUP
Spaces→PAO-VEN-AGRMT-REF
AOI-PO-NUMBER→PAO-PO-NUMBER
AOI-PO-RELEASE→PAO-PO-RELEASE
AOI-PO-CODE→PAO-PO-CODE
Zeroes→PAO-LINE-NBR
—→PAO-AOC-CODE
PoaocsprdPOAOCSPRDDelete Cascades
AOI-COMPANY→PSP-COMPANY
AOI-INVOICE→PSP-INVOICE
—→PSP-AOC-CODE
—→PSP-PO-NUMBER
—→PSP-PO-RELEASE
—→PSP-PO-CODE
PolinePOLINE
AOI-COMPANY→PLI-COMPANY
AOI-PO-NUMBER→PLI-PO-NUMBER
AOI-PO-RELEASE→PLI-PO-RELEASE
AOI-PO-CODE→PLI-PO-CODE
—→PLI-LINE-NBR
PoreceivePORECEIVE
AOI-COMPANY→POR-COMPANY
AOI-PO-CODE→POR-PO-CODE
AOI-PO-NUMBER→POR-PO-NUMBER
AOI-PO-RELEASE→POR-PO-RELEASE
—→POR-PO-LOCATION
—→POR-REC-NUMBER
PoreclinePORECLINE
AOI-COMPANY→PRL-COMPANY
AOI-PO-CODE→PRL-PO-CODE
AOI-PO-NUMBER→PRL-PO-NUMBER
AOI-PO-RELEASE→PRL-PO-RELEASE
—→PRL-PO-LINE-NBR
—→PRL-UPDATE-DATE
—→PRL-UPDATE-TIME
—→PRL-REC-NUMBER
—→PRL-LINE-NBR

Programs

Updated by (34)

Referenced by (215)