Lawson Insight Technical Documentation |
|
MAAOIHIST
MAAOIHIST FILE
UPDATED BY
AP115 AP180 AP181 AP190 AP198 AP25.2
AP26.1 AP27.1 AP28.1 AP28.2 AP30.4 AP300
AP305 AP45.1
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 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. AP25.2 AP26.1
AP27.1 AP30.4
AP305
MH2-INVOICE Alpha 22 AP115 AP198
Element: Invoice NumberUsed to identify the invoice. AP25.2 AP26.1
AP27.1 AP30.4
AP305
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 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 AP25.2 AP26.1
SUFFIX AP27.1 AP28.1
PO-NUMBER AP28.2 AP30.4
PO-RELEASE AP300 AP305
PO-CODE AP45.1
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
|