MAMADHIST – No description in the Lawson data dictionary

System
Matching (MA)
Prefix
MH1
Primary key
COMPANY, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, SEQ-NBR
Fields
77
Updated by
243 programs
Referenced by
1 program

MAMADHIST is a Lawson Matching table (prefix MH1); no description in the lawson data dictionary. It is indexed by COMPANY, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, SEQ-NBR (MH1SET1); alternate indexes: MH1SET10, MH1SET2, MH1SET8 and MH1SET9. It is related 1:1 to APAPIHIST, MAAOIHIST and POLINE and 1:M to MMDIST. It is updated by AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 and 235 more and referenced by PO64.1. The table has 77 fields, 5 indexes and 4 documented relations.

About MAMADHIST

No description in the Lawson data dictionary.

Fields (77)

Column = COBOL field name without the MH1- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
MH1-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.AP198
MH1-VENDOR PK
VENDOR
Alpha 9 (Right Justified)The vendor's identification code.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP198, AP20.1 +52 more (list truncated in source)
MH1-INVOICE PK
INVOICE
Alpha 22Used to identify the invoice.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP198, AP20.1 +52 more (list truncated in source)
MH1-SUFFIX PK
SUFFIX
Numeric 3This is the suffix for the invoice.AP198
MH1-PO-NUMBER PK
PO_NUMBER
Alpha 14 (Right Justified)This field contains the number representing the purchase order.AP198
MH1-PO-RELEASE PK
PO_RELEASE
Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AP198
MH1-PO-CODE PK
PO_CODE
Alpha 4This is the purchase order code.AP198
MH1-LINE-NBR PK
LINE_NBR
Numeric 6This field contains the line number.AP198
MH1-AOC-CODE PK
AOC_CODE
Alpha 2This field contains the identifier for the add on cost associated with this line item.
MH1-SEQ-NBR PK
SEQ_NBR
Numeric 4An automatically assigned sequence number.AP198
MH1-ITEM-TYPE
ITEM_TYPE
Alpha 1This field identifies the line item type.AP198
MH1-ITEM
ITEM
Alpha 32This field contains the item identifier.AP198
MH1-VEN-ITEM
VEN_ITEM
Alpha 32This field contains the item identifier.AP198
MH1-ITEM-DESC
ITEM_DESC
Alpha 30 (Lower Case)This field displays the description.AP198
MH1-MATCHED-QTY
MATCHED_QTY
Signed 13.4This field contains the desired quantity.AP198
MH1-MATCH-UNIT-CST
MATCH_UNIT_CST
Signed 18.5AP198
MH1-VPRI-UOM
VPRI_UOM
Alpha 4This field contains the valid stock unit of measure for this item.AP198
MH1-VPRI-UOM-MULT
VPRI_UOM_MULT
Signed 13.7This field contains the multiplier for converting this unit of measure to the stock unit of measure.AP198
MH1-ENTERED-QTY
ENTERED_QTY
Signed 13.4This field contains the desired quantity.AP198
MH1-ENT-UNIT-CST
ENT_UNIT_CST
Signed 18.5AP198
MH1-TAX-CODE
TAX_CODE
Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.AP198
MH1-TAX-TYPE
TAX_TYPE
Alpha 1The type of tax.AP198
MH1-TAX-AMOUNT
TAX_AMOUNT
Signed 18.2AP198
MH1-VBUY-MATCH-QTY
VBUY_MATCH_QTY
Signed 13.4This field contains the desired quantity.AP198
MH1-VBUY-UOM
VBUY_UOM
Alpha 4This field contains the valid stock unit of measure for this item.AP198
MH1-VBUY-UOM-MULT
VBUY_UOM_MULT
Signed 13.7This field contains the multiplier for converting this unit of measure to the stock unit of measure.AP198
MH1-NO-TAX-FLAG
NO_TAX_FLAG
Alpha 1AP198
MH1-MATCH-CLASS
MATCH_CLASS
Alpha 10AP198
MH1-MATCH-DTL-KEY
MATCH_DTL_KEY
Alpha 85AP198
MH1-RTL-UNIT-COST
RTL_UNIT_COST
Signed 18.5AP198
MH1-LOCATION
LOCATION
Alpha 5This field contains a valid stocking location within the company inventory.AP198
MH1-MATCH-OBJ-ID
MATCH_OBJ_ID
Numeric 12This 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.AP198
MH1-ENT-UOM
ENT_UOM
Alpha 4This field contains the valid stock unit of measure for this item.AP198
MH1-ENT-UOM-MULT
ENT_UOM_MULT
Signed 13.7This field contains the multiplier for converting this unit of measure to the stock unit of measure.AP198
MH1-TRAN-ND
TRAN_ND
Numeric 1The number of decimals assigned to a particular account as determined by the account currency.AP198
MH1-REC-SOURCE
REC_SOURCE
Alpha 2AP198
MH1-TOT-DIST-AMT
TOT_DIST_AMT
Signed 18.2AP198
MH1-TOT-BASE-AMT
TOT_BASE_AMT
Signed 18.2AP198
MH1-STATUS
STATUS
Numeric 1This field displays the status of the transaction.AP198
MH1-API-OBJ-ID
API_OBJ_ID
Numeric 12This 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.AP198
MH1-MA-REC-NBR
MA_REC_NBR
Numeric 10The receiver number. Assigned when this receiving information was added.AP198
MH1-MA-LINE-NBR
MA_LINE_NBR
Numeric 6This field contains the line number.AP198
MH1-MATCH-SEQ-NBR
MATCH_SEQ_NBR
Numeric 4AP198
MH1-MTCH-EXC-PROC
MTCH_EXC_PROC
Numeric 1AP198
MH1-INVOICE-TYPE
INVOICE_TYPE
Alpha 1THis 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.AP198
MH1-DISTRIB-DATE
DISTRIB_DATE
Numeric 8 (yyyymmdd)This field displays the system date when this was created.AP198
MH1-UPDATE-DATE
UPDATE_DATE
Numeric 8 (yyyymmdd)This field contains the date the record was updated.AP198
MH1-UPDATE-TIME
UPDATE_TIME
Numeric 6This field contains the system time when the record was updated.AP198
MH1-TAX-USAGE-CD
TAX_USAGE_CD
Alpha 10The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required.AP198
MH1-ICN-CODE
ICN_CODE
Alpha 8AP198
MH1-SUPLMNTARY-QTY
SUPLMNTARY_QTY
Signed 13.4This field contains the desired quantity.AP198
MH1-WEIGHT
WEIGHT
Signed 9.3This field contains the unit weight of the item based on the stocking UOM.AP198
MH1-TERMS-CD
TERMS_CD
Alpha 5AP198
MH1-DISC-RATE
DISC_RATE
Percent 5.3 (Percent)AP198
MH1-DISC-DATE
DISC_DATE
Numeric 8 (yyyymmdd)AP198
MH1-FLEX-FLAG
FLEX_FLAG
Alpha 1AP198
MH1-PREPAY-QTY
PREPAY_QTY
Signed 13.4AP198
MH1-XREF-VENDOR
XREF_VENDOR
Alpha 9 (Right Justified)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
MATCH_ERR_TYPE
Numeric 2This is the reason the match was not successful.AP198
MH1-CATCH-WGT-COST
CATCH_WGT_COST
Signed 18.5AP198
MH1-REASON-CODE
REASON_CODE
Alpha 4This field contains the reason code, which indicates the cause for credit memos.AP198
MH1-CHARGEBACK-FL
CHARGEBACK_FL
Alpha 1AP198
MH1-IR-DIFF-AMT
IR_DIFF_AMT
Signed 18.2AP198
MH1-MATCH-EXT-COST
MATCH_EXT_COST
Derived
MH1-AGREEMENT-REF
AGREEMENT_REF
Alpha 30AP198
MH1-LAST-MSG-SEQ
LAST_MSG_SEQ
Numeric 6A unique number assigned to each transaction to be interfaced into the Lawson system.
MH1-SUPLMNTARY-UOM
SUPLMNTARY_UOM
Alpha 4This field contains the valid stock unit of measure for this item.
MH1-PRPY-UNIT-CST
PRPY_UNIT_CST
Signed 18.5
MH1-PRPY-TAX-CODE
PRPY_TAX_CODE
Alpha 10
MH1-PRPY-TAX-AMT
PRPY_TAX_AMT
Signed 18.2
MH1-PRPY-RTL-UCST
PRPY_RTL_UCST
Signed 18.5
MH1-PREPAY-DATE
PREPAY_DATE
Numeric 8 (yyyymmdd)
MH1-INVC-TAX-AMT
INVC_TAX_AMT
Signed 18.2
MH1-ACCR-TAX-AMT
ACCR_TAX_AMT
Signed 18.2
MH1-COMMODITY-CODE
COMMODITY_CODE
Alpha 35AP198
MH1-PROD-TAX-CAT
PROD_TAX_CAT
Alpha 15AP198
MH1-GTIN
GTIN
Numeric 14AP198

Indexes (5)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MH1SET1COMPANY, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, SEQ-NBRPrimaryAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +22 more (list truncated in source)
MH1SET10COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, UPDATE-DATE*, UPDATE-TIME*, VENDOR, INVOICE, SUFFIX, AOC-CODE, SEQ-NBRKeyChange, SubsetWhere STATUS = 1MA278, PO64.1
MH1SET2COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, VENDOR, INVOICE, SUFFIX, AOC-CODE, SEQ-NBRKeyChange
MH1SET8COMPANY, API-OBJ-ID, PO-NUMBER, PO-RELEASE, PO-CODE, LOCATION, MATCH-DTL-KEY, LINE-NBR, AOC-CODE, SEQ-NBRKeyChangeAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)
MH1SET9COMPANY, MATCH-OBJ-ID, MATCH-SEQ-NBR, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, SEQ-NBRKeyChange, SubsetWhere INVOICE-TYPE = SpacesAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
ApapihistAPAPIHISTRequiredMH1-COMPANYAH1-COMPANY, MH1-VENDORAH1-VENDOR, MH1-INVOICEAH1-INVOICE, MH1-SUFFIXAH1-SUFFIX, ZeroesAH1-CANCEL-SEQ
MaaoihistMAAOIHISTNot RequiredMH1-COMPANYMH2-COMPANY, MH1-PO-NUMBERMH2-PO-NUMBER, MH1-PO-RELEASEMH2-PO-RELEASE, MH1-PO-CODEMH2-PO-CODE, MH1-VENDORMH2-VENDOR, MH1-INVOICEMH2-INVOICE, MH1-SUFFIXMH2-SUFFIX
PolinePOLINENot RequiredMH1-COMPANYPLI-COMPANY, MH1-PO-NUMBERPLI-PO-NUMBER, MH1-PO-RELEASEPLI-PO-RELEASE, MH1-PO-CODEPLI-PO-CODE, MH1-LINE-NBRPLI-LINE-NBR

One to many (1) — child tables

RelationTableRulesConditionField map
MmdistMMDISTValid When MH1-ITEM-TYPE != "I"MH1-COMPANYMMD-COMPANY, "PO"MMD-SYSTEM-CD, SpacesMMD-LOCATION, "PT"MMD-DOC-TYPE, MH1-PO-NUMBERMMD-DOC-NUMBER, MH1-PO-RELEASEMMD-DOC-NBR-NUM, MH1-PO-CODEMMD-PO-CODE, MH1-LINE-NBRMMD-LINE-NBR, ZeroesMMD-COMPONENT-SEQ, MH1-AOC-CODEMMD-AOC-CODE, MMD-LINE-SEQ, MMD-REQ-LOCATION, MMD-API-OBJ-ID

Programs

Updated by (243)

Referenced by (1)