Lawson Insight Technical Documentation |
|
MAAOIHIST
MAAOIHIST FILE
UPDATED BY
AP115 AP180 AP181 AP190 AP198 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP23.1
AP25.2 AP26.1 AP27.1 AP28.1 AP28.2 AP30.4
AP300 AP305 AP45.1 MA41.2 MA43.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MH2-COMPANY Numeric 4 AP198
Element: Company The company number represents an
established company and is entered on
all function codes.
MH2-PO-NUMBER Alpha 14 (Right Justified) AP198
Element: PO Number This field contains the number
representing the purchase order.
MH2-PO-RELEASE Numeric 4 AP198
Element: PO Release NumUsed to identify a purchase order
release (created from a Blanket or
Standing order).
MH2-PO-CODE Alpha 4 AP198
Element: Po Code This is the purchase order code.
MH2-VENDOR Alpha 9 (Right Justified) AP115 AP198
Element: Vendor ID The vendor's identification code. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.2
AP26.1 AP27.1
AP30.4 AP305
MA41.2 MA43.2
MH2-INVOICE Alpha 22 AP115 AP198
Element: Invoice NumberUsed to identify the invoice. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.2
AP26.1 AP27.1
AP30.4 AP305
MA41.2 MA43.2
MH2-SUFFIX Numeric 3 AP198
Element: Invoice SuffixThis is the suffix for the invoice.
MH2-MATCH-REF-NBR Alpha 22 AP198
Element: Match Ref Nbr
MH2-TAX-CODE Alpha 10 AP198
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
MH2-LOCATION Alpha 5 AP198
Element: Location Code This field contains a valid stocking
location within the company inventory.
MH2-INVOICE-TYPE Alpha 1 AP198
Element: Invoice Type
MAAOIHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MH2SET1 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
VENDOR
INVOICE
SUFFIX
MH2SET2 COMPANY AP115 AP180
VENDOR AP181 AP190
INVOICE AP20.1 AP20.2
SUFFIX AP20.3 AP20.4
PO-NUMBER AP20.5 AP20.7
PO-RELEASE AP23.1 AP25.2
PO-CODE AP26.1 AP27.1
AP28.1 AP28.2
AP30.4 AP300
AP305 AP45.1
MA41.2 MA43.2
MAAOIHIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|