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 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 MA43.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MH2-COMPANY Numeric 4 AP198
Element: Company 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.
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 Used 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 The vendor's identification code. 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 MA43.2
MH2-INVOICE Alpha 22 AP115 AP198
Element: Invoice Used to identify the invoice. 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 MA43.2
MH2-SUFFIX Numeric 3 AP198
Element: Suffix This 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 This field contains a valid stocking
location within the company inventory.
MH2-INVOICE-TYPE Alpha 1 AP198
Element: Invoice Type 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.
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 AP21.1 AP23.1
PO-CODE AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.4
AP300 AP305
AP45.1 MA41.1
MA41.2 MA41.4
MA41.7 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
|