Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MAMADHIST


                             MAMADHIST FILE

REFERENCED BY

MA278     PO64.1

UPDATED BY

AM19.1    AM19.2    AP115     AP125     AP126     AP131
AP180     AP181     AP190     AP198     AP20.1    AP20.2
AP20.3    AP20.4    AP20.5    AP20.7    AP21.1    AP220
AP23.1    AP25.1    AP25.2    AP26.1    AP27.1    AP28.1
AP28.2    AP30.2    AP30.4    AP300     AP305     AP45.1
API1.1    API2.1    BL120     BL122     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL29.1    BL29.2    BL520
BL820     BL92.1    MA180     MA41.1    MA41.2    MA41.4
MA41.7    MA43.1    MA43.2    MA43.3    MA43.4    MA43.6
MA43.7    MA530     MA531     MA60.2    MA60.3    MA60.5
MA61.1    MA63.1    MA65.1    MA66.2    MA66.3    MA67.2
MA67.3    MA68.2    MA68.3    MA68.5    MA70.1    MA75.1
MA80.1    MAI1.1    PD10.1    PD10.2    PD130     PD20.1
PD20.2    PD20.3    PO100     PO101     PO122     PO131
PO20.1    PO21.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO23.1    PO24.1    PO25.1    PO25.5    PO25.6
PO25.7    PO27.2    PO29.1    PO30.1    PO30.2    PO30.3
PO300     PO31.1    PO31.2    PO32.2    PO32.4    PO33.1
PO34.1    PO35.1    PO36.1    PO36.2    PO38.1    PO39.1
PO39.2    PO44.1    PO50.1    PO52.1    PO520     PO536
POI3.1    POID.1    POII.1    POIJ.1    RQ10.1    RQ10.2
WH20.2    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MH1-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.

MH1-VENDOR             Alpha 9  (Right Justified)                AM19.1  AM19.2
Element: Vendor        The vendor's identification code.         AP115   AP125
                                                                 AP126   AP131
                                                                 AP198   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP220   AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP305   API1.1
                                                                 API2.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  MA180
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.4
                                                                 MA43.6  MA43.7
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA66.2  MA66.3
                                                                 MA67.2  MA67.3
                                                                 ...

MH1-INVOICE            Alpha 22                                  AM19.1  AM19.2
Element: Invoice       Used to identify the invoice.             AP115   AP125
                                                                 AP126   AP131
                                                                 AP198   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP220   AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP305   API1.1
                                                                 API2.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  MA180
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.4
                                                                 MA43.6  MA43.7
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA66.2  MA66.3
                                                                 MA67.2  MA67.3
                                                                 ...

MH1-SUFFIX             Numeric 3                                 AP198
Element: Suffix        This is the suffix for the invoice.

MH1-PO-NUMBER          Alpha 14  (Right Justified)               AP198
Element: Po Number     This field contains the number
                       representing the purchase order.

MH1-PO-RELEASE         Numeric 4                                 AP198
Element: Po Release    Used to identify a purchase order
                       release (created from a Blanket or
                       Standing order).

MH1-PO-CODE            Alpha 4                                   AP198
Element: Po Code       This is the purchase order code.

MH1-LINE-NBR           Numeric 6                                 AP198
Element: Line Nbr      This field contains the line number.

MH1-AOC-CODE           Alpha 2
Element: Aoc Code      This field contains the identifier for
                       the add on cost associated with this
                       line item.

MH1-SEQ-NBR            Numeric 4                                 AP198
Element: Seq Nbr       An automatically assigned sequence
                       number.

MH1-ITEM-TYPE          Alpha 1                                   AP198
Element: Item Type     This field identifies the line item
                       type.

MH1-ITEM               Alpha 32                                  AP198
Element: Item          This field contains the item
                       identifier.

MH1-VEN-ITEM           Alpha 32                                  AP198
Element: Item          This field contains the item
                       identifier.

MH1-ITEM-DESC          Alpha 30  (Lower Case)                    AP198
Element: Description   This field displays the description.

MH1-MATCHED-QTY        Signed 13.4                               AP198
Element: Quantity      This field contains the desired
                       quantity.

MH1-MATCH-UNIT-CST     Signed 18.5                               AP198
Element: Intl Cost

MH1-VPRI-UOM           Alpha 4                                   AP198
Element: Uom           This field contains the valid stock
                       unit of measure for this item.


MH1-VPRI-UOM-MULT      Signed 13.7                               AP198
Element: Uom Mult      This field contains the multiplier for
                       converting this unit of measure to the
                       stock unit of measure.

MH1-ENTERED-QTY        Signed 13.4                               AP198
Element: Quantity      This field contains the desired
                       quantity.

MH1-ENT-UNIT-CST       Signed 18.5                               AP198
Element: Intl Cost

MH1-TAX-CODE           Alpha 10                                  AP198
Element: Tax Code      This field contains a code representing
                       specific tax information.  This must be
                       valid Tax Code.


MH1-TAX-TYPE           Alpha 1                                   AP198
Element: Tax Type      The type of tax.

MH1-TAX-AMOUNT         Signed 18.2                               AP198
Element: Intl Amt

MH1-VBUY-MATCH-QTY     Signed 13.4                               AP198
Element: Quantity      This field contains the desired
                       quantity.

MH1-VBUY-UOM           Alpha 4                                   AP198
Element: Uom           This field contains the valid stock
                       unit of measure for this item.


MH1-VBUY-UOM-MULT      Signed 13.7                               AP198
Element: Uom Mult      This field contains the multiplier for
                       converting this unit of measure to the
                       stock unit of measure.

MH1-NO-TAX-FLAG        Alpha 1                                   AP198
Element: Account Flag

MH1-MATCH-CLASS        Alpha 10                                  AP198
Element: Match Class

MH1-MATCH-DTL-KEY      Alpha 85                                  AP198
Element: Match Dtl Key

MH1-RTL-UNIT-COST      Signed 18.5                               AP198
Element: Intl Cost

MH1-LOCATION           Alpha 5                                   AP198
Element: Location      This field contains a valid stocking
                       location within the company inventory.

MH1-MATCH-OBJ-ID       Numeric 12                                AP198
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

MH1-ENT-UOM            Alpha 4                                   AP198
Element: Uom           This field contains the valid stock
                       unit of measure for this item.


MH1-ENT-UOM-MULT       Signed 13.7                               AP198
Element: Uom Mult      This field contains the multiplier for
                       converting this unit of measure to the
                       stock unit of measure.

MH1-TRAN-ND            Numeric 1                                 AP198
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


MH1-REC-SOURCE         Alpha 2                                   AP198
Element: Rec Source

MH1-TOT-DIST-AMT       Signed 18.2                               AP198
Element: Intl Amt

MH1-TOT-BASE-AMT       Signed 18.2                               AP198
Element: Intl Amt

MH1-STATUS             Numeric 1                                 AP198
Element: Status        This field displays the status of the
                       transaction.

MH1-API-OBJ-ID         Numeric 12                                AP198
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

MH1-MA-REC-NBR         Numeric 10                                AP198
Element: Rec Number    The receiver number.  Assigned when
                       this receiving information was added.

MH1-MA-LINE-NBR        Numeric 6                                 AP198
Element: Line Nbr      This field contains the line number.

MH1-MATCH-SEQ-NBR      Numeric 4                                 AP198
Element: Match Seq Nbr

MH1-MTCH-EXC-PROC      Numeric 1                                 AP198
Element: Mtch Exc Proc

MH1-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.

MH1-DISTRIB-DATE       Numeric 8  (yyyymmdd)                     AP198
Element: Date          This field displays the system date
                       when this was created.

MH1-UPDATE-DATE        Numeric 8  (yyyymmdd)                     AP198
Element: Update Date   This field contains the date the record
                       was updated.

MH1-UPDATE-TIME        Numeric 6                                 AP198
Element: Update Time   This field contains the system time
                       when the record was updated.

MH1-TAX-USAGE-CD       Alpha 10                                  AP198
Element: Tax Usage Cd  The tax usage coe for the vendor.  This
                       filed is required if the AP Company
                       inidcates that VAT reporting required.

MH1-ICN-CODE           Alpha 8                                   AP198
Element: Icn Code

MH1-SUPLMNTARY-QTY     Signed 13.4                               AP198
Element: Quantity      This field contains the desired
                       quantity.

MH1-WEIGHT             Signed 9.3                                AP198
Element: Weight        This field contains the unit weight of
                       the item based on the stocking UOM.

MH1-TERMS-CD           Alpha 5                                   AP198
Element: Terms Cd

MH1-DISC-RATE          Percent 5.3  (Percent)                    AP198
Element: Disc Rate

MH1-DISC-DATE          Numeric 8  (yyyymmdd)                     AP198
Element: Disc Date

MH1-FLEX-FLAG          Alpha 1                                   AP198
Element: Flex Flag

MH1-PREPAY-QTY         Signed 13.4                               AP198
Element: Prepay Qty

MH1-XREF-VENDOR        Alpha 9  (Right Justified)
Element: Xref Vendor   This is a vendor that is supported on a
                       system outside Lawson.  When records are
                       interfaces we will maintain this vendor
                       on the file but we will use the Lawson
                       vendor while in the lawson application.

MH1-MATCH-ERR-TYPE     Numeric 2                                 AP198
Element: Match Err TypeThis is the reason the match was not
                       successful.

MH1-CATCH-WGT-COST     Signed 18.5                               AP198
Element: Intl Cost

MH1-REASON-CODE        Alpha 4                                   AP198
Element: Reason Code   This field contains the reason code,
                       which indicates the cause for credit
                       memos.

MH1-CHARGEBACK-FL      Alpha 1                                   AP198
Element: Chargeback Fl

MH1-IR-DIFF-AMT        Signed 18.2                               AP198
Element: Intl Amt

MH1-MATCH-EXT-COST     Derived
Element: Match Ext Cost

MH1-AGREEMENT-REF      Alpha 30                                  AP198
Element: Agreement Ref

MH1-LAST-MSG-SEQ       Numeric 6
Element: Seq Number    A unique number assigned to each
                       transaction to be interfaced into the
                       Lawson system.

MH1-SUPLMNTARY-UOM     Alpha 4
Element: Uom           This field contains the valid stock
                       unit of measure for this item.


MH1-PRPY-UNIT-CST      Signed 18.5
Element: Intl Cost

MH1-PRPY-TAX-CODE      Alpha 10
Element: Prpy Tax Code

MH1-PRPY-TAX-AMT       Signed 18.2
Element: Intl Amt

MH1-PRPY-RTL-UCST      Signed 18.5
Element: Intl Cost

MH1-PREPAY-DATE        Numeric 8  (yyyymmdd)
Element: Prepay Date

MH1-INVC-TAX-AMT       Signed 18.2
Element: Intl Amt

MH1-ACCR-TAX-AMT       Signed 18.2
Element: Intl Amt

MH1-COMMODITY-CODE     Alpha 35                                  AP198
Element: Commodity Code

                         MAMADHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MH1SET1   COMPANY                                                AM19.1  AM19.2
          VENDOR                                                 AP115   AP125
          INVOICE                                                AP126   AP131
          SUFFIX                                                 AP180   AP181
          PO-NUMBER                                              AP190   AP20.1
          PO-RELEASE                                             AP20.2  AP20.3
          PO-CODE                                                AP20.4  AP20.5
          LINE-NBR                                               AP20.7  AP21.1
          AOC-CODE                                               AP220   AP23.1
          SEQ-NBR                                                AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP300   AP305
                                                                 AP45.1  API1.1
                                                                 ...

MH1SET10  COMPANY       KeyChange, Subset                        MA278   PO64.1
          PO-NUMBER     Where STATUS = 1
          PO-RELEASE
          PO-CODE
          LINE-NBR
          UPDATE-DATE*
          UPDATE-TIME*
          VENDOR
          INVOICE
          SUFFIX
          AOC-CODE
          SEQ-NBR

MH1SET2   COMPANY       KeyChange
          PO-NUMBER
          PO-RELEASE
          PO-CODE
          LINE-NBR
          VENDOR
          INVOICE
          SUFFIX
          AOC-CODE
          SEQ-NBR

MH1SET8   COMPANY       KeyChange                                AM19.1  AM19.2
          API-OBJ-ID                                             AP115   AP125
          PO-NUMBER                                              AP126   AP131
          PO-RELEASE                                             AP20.1  AP20.2
          PO-CODE                                                AP20.3  AP20.4
          LOCATION                                               AP20.5  AP20.7
          MATCH-DTL-KEY                                          AP21.1  AP220
          LINE-NBR                                               AP23.1  AP25.1
          AOC-CODE                                               AP25.2  AP26.1
          SEQ-NBR                                                AP27.1  AP30.2
                                                                 AP30.4  AP305
                                                                 API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 ...

MH1SET9   COMPANY       KeyChange, Subset                        AM19.1  AM19.2
          MATCH-OBJ-ID  Where INVOICE-TYPE = Spaces              AP115   AP125
          MATCH-SEQ-NBR                                          AP126   AP131
          VENDOR                                                 AP20.1  AP20.2
          INVOICE                                                AP20.3  AP20.4
          SUFFIX                                                 AP20.5  AP20.7
          PO-NUMBER                                              AP21.1  AP220
          PO-RELEASE                                             AP23.1  AP25.1
          PO-CODE                                                AP25.2  AP26.1
          LINE-NBR                                               AP27.1  AP30.2
          AOC-CODE                                               AP30.4  AP305
          SEQ-NBR                                                API1.1  API2.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 ...

                         MAMADHIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apapihist      APAPIHIST    Required

                            MH1-COMPANY       -> AH1-COMPANY
                            MH1-VENDOR        -> AH1-VENDOR
                            MH1-INVOICE       -> AH1-INVOICE
                            MH1-SUFFIX        -> AH1-SUFFIX
                            Zeroes            -> AH1-CANCEL-SEQ

Maaoihist      MAAOIHIST    Not Required

                            MH1-COMPANY       -> MH2-COMPANY
                            MH1-PO-NUMBER     -> MH2-PO-NUMBER
                            MH1-PO-RELEASE    -> MH2-PO-RELEASE
                            MH1-PO-CODE       -> MH2-PO-CODE
                            MH1-VENDOR        -> MH2-VENDOR
                            MH1-INVOICE       -> MH2-INVOICE
                            MH1-SUFFIX        -> MH2-SUFFIX

Poline         POLINE       Not Required

                            MH1-COMPANY       -> PLI-COMPANY
                            MH1-PO-NUMBER     -> PLI-PO-NUMBER
                            MH1-PO-RELEASE    -> PLI-PO-RELEASE
                            MH1-PO-CODE       -> PLI-PO-CODE
                            MH1-LINE-NBR      -> PLI-LINE-NBR

                         MAMADHIST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mmdist         MMDIST
                            Valid When MH1-ITEM-TYPE != "I"

                            MH1-COMPANY       -> MMD-COMPANY
                            "PO"              -> MMD-SYSTEM-CD
                            Spaces            -> MMD-LOCATION
                            "PT"              -> MMD-DOC-TYPE
                            MH1-PO-NUMBER     -> MMD-DOC-NUMBER
                            MH1-PO-RELEASE    -> MMD-DOC-NBR-NUM
                            MH1-PO-CODE       -> MMD-PO-CODE
                            MH1-LINE-NBR      -> MMD-LINE-NBR
                            Zeroes            -> MMD-COMPONENT-SEQ
                            MH1-AOC-CODE      -> MMD-AOC-CODE
                                                 MMD-LINE-SEQ
                                                 MMD-REQ-LOCATION
                                                 MMD-API-OBJ-ID