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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#MH1-COMPANY PKCOMPANY | Numeric 4 | 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. | AP198 |
#MH1-VENDOR PKVENDOR | 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 PKINVOICE | Alpha 22 | Used to identify the invoice. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP198, AP20.1 +52 more (list truncated in source) |
#MH1-SUFFIX PKSUFFIX | Numeric 3 | This is the suffix for the invoice. | AP198 |
#MH1-PO-NUMBER PKPO_NUMBER | Alpha 14 (Right Justified) | This field contains the number representing the purchase order. | AP198 |
#MH1-PO-RELEASE PKPO_RELEASE | Numeric 4 | Used to identify a purchase order release (created from a Blanket or Standing order). | AP198 |
#MH1-PO-CODE PKPO_CODE | Alpha 4 | This is the purchase order code. | AP198 |
#MH1-LINE-NBR PKLINE_NBR | Numeric 6 | This field contains the line number. | AP198 |
#MH1-AOC-CODE PKAOC_CODE | Alpha 2 | This field contains the identifier for the add on cost associated with this line item. | — |
#MH1-SEQ-NBR PKSEQ_NBR | Numeric 4 | An automatically assigned sequence number. | AP198 |
#MH1-ITEM-TYPEITEM_TYPE | Alpha 1 | This field identifies the line item type. | AP198 |
#MH1-ITEMITEM | Alpha 32 | This field contains the item identifier. | AP198 |
#MH1-VEN-ITEMVEN_ITEM | Alpha 32 | This field contains the item identifier. | AP198 |
#MH1-ITEM-DESCITEM_DESC | Alpha 30 (Lower Case) | This field displays the description. | AP198 |
#MH1-MATCHED-QTYMATCHED_QTY | Signed 13.4 | This field contains the desired quantity. | AP198 |
#MH1-MATCH-UNIT-CSTMATCH_UNIT_CST | Signed 18.5 | — | AP198 |
#MH1-VPRI-UOMVPRI_UOM | Alpha 4 | This field contains the valid stock unit of measure for this item. | AP198 |
#MH1-VPRI-UOM-MULTVPRI_UOM_MULT | Signed 13.7 | This field contains the multiplier for converting this unit of measure to the stock unit of measure. | AP198 |
#MH1-ENTERED-QTYENTERED_QTY | Signed 13.4 | This field contains the desired quantity. | AP198 |
#MH1-ENT-UNIT-CSTENT_UNIT_CST | Signed 18.5 | — | AP198 |
#MH1-TAX-CODETAX_CODE | Alpha 10 | This field contains a code representing specific tax information. This must be valid Tax Code. | AP198 |
#MH1-TAX-TYPETAX_TYPE | Alpha 1 | The type of tax. | AP198 |
#MH1-TAX-AMOUNTTAX_AMOUNT | Signed 18.2 | — | AP198 |
#MH1-VBUY-MATCH-QTYVBUY_MATCH_QTY | Signed 13.4 | This field contains the desired quantity. | AP198 |
#MH1-VBUY-UOMVBUY_UOM | Alpha 4 | This field contains the valid stock unit of measure for this item. | AP198 |
#MH1-VBUY-UOM-MULTVBUY_UOM_MULT | Signed 13.7 | This field contains the multiplier for converting this unit of measure to the stock unit of measure. | AP198 |
#MH1-NO-TAX-FLAGNO_TAX_FLAG | Alpha 1 | — | AP198 |
#MH1-MATCH-CLASSMATCH_CLASS | Alpha 10 | — | AP198 |
#MH1-MATCH-DTL-KEY SET8MATCH_DTL_KEY | Alpha 85 | — | AP198 |
#MH1-RTL-UNIT-COSTRTL_UNIT_COST | Signed 18.5 | — | AP198 |
#MH1-LOCATION SET8LOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | AP198 |
#MH1-MATCH-OBJ-ID SET9MATCH_OBJ_ID | Numeric 12 | 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. | AP198 |
#MH1-ENT-UOMENT_UOM | Alpha 4 | This field contains the valid stock unit of measure for this item. | AP198 |
#MH1-ENT-UOM-MULTENT_UOM_MULT | Signed 13.7 | This field contains the multiplier for converting this unit of measure to the stock unit of measure. | AP198 |
#MH1-TRAN-NDTRAN_ND | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | AP198 |
#MH1-REC-SOURCEREC_SOURCE | Alpha 2 | — | AP198 |
#MH1-TOT-DIST-AMTTOT_DIST_AMT | Signed 18.2 | — | AP198 |
#MH1-TOT-BASE-AMTTOT_BASE_AMT | Signed 18.2 | — | AP198 |
#MH1-STATUSSTATUS | Numeric 1 | This field displays the status of the transaction. | AP198 |
#MH1-API-OBJ-ID SET8API_OBJ_ID | Numeric 12 | 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. | AP198 |
#MH1-MA-REC-NBRMA_REC_NBR | Numeric 10 | The receiver number. Assigned when this receiving information was added. | AP198 |
#MH1-MA-LINE-NBRMA_LINE_NBR | Numeric 6 | This field contains the line number. | AP198 |
#MH1-MATCH-SEQ-NBR SET9MATCH_SEQ_NBR | Numeric 4 | — | AP198 |
#MH1-MTCH-EXC-PROCMTCH_EXC_PROC | Numeric 1 | — | AP198 |
#MH1-INVOICE-TYPEINVOICE_TYPE | Alpha 1 | 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. | AP198 |
#MH1-DISTRIB-DATEDISTRIB_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | AP198 |
#MH1-UPDATE-DATE SET10UPDATE_DATE | Numeric 8 (yyyymmdd) | This field contains the date the record was updated. | AP198 |
#MH1-UPDATE-TIME SET10UPDATE_TIME | Numeric 6 | This field contains the system time when the record was updated. | AP198 |
#MH1-TAX-USAGE-CDTAX_USAGE_CD | Alpha 10 | The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required. | AP198 |
#MH1-ICN-CODEICN_CODE | Alpha 8 | — | AP198 |
#MH1-SUPLMNTARY-QTYSUPLMNTARY_QTY | Signed 13.4 | This field contains the desired quantity. | AP198 |
#MH1-WEIGHTWEIGHT | Signed 9.3 | This field contains the unit weight of the item based on the stocking UOM. | AP198 |
#MH1-TERMS-CDTERMS_CD | Alpha 5 | — | AP198 |
#MH1-DISC-RATEDISC_RATE | Percent 5.3 (Percent) | — | AP198 |
#MH1-DISC-DATEDISC_DATE | Numeric 8 (yyyymmdd) | — | AP198 |
#MH1-FLEX-FLAGFLEX_FLAG | Alpha 1 | — | AP198 |
#MH1-PREPAY-QTYPREPAY_QTY | Signed 13.4 | — | AP198 |
#MH1-XREF-VENDORXREF_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-TYPEMATCH_ERR_TYPE | Numeric 2 | This is the reason the match was not successful. | AP198 |
#MH1-CATCH-WGT-COSTCATCH_WGT_COST | Signed 18.5 | — | AP198 |
#MH1-REASON-CODEREASON_CODE | Alpha 4 | This field contains the reason code, which indicates the cause for credit memos. | AP198 |
#MH1-CHARGEBACK-FLCHARGEBACK_FL | Alpha 1 | — | AP198 |
#MH1-IR-DIFF-AMTIR_DIFF_AMT | Signed 18.2 | — | AP198 |
#MH1-MATCH-EXT-COSTMATCH_EXT_COST | Derived | — | — |
#MH1-AGREEMENT-REFAGREEMENT_REF | Alpha 30 | — | AP198 |
#MH1-LAST-MSG-SEQLAST_MSG_SEQ | Numeric 6 | A unique number assigned to each transaction to be interfaced into the Lawson system. | — |
#MH1-SUPLMNTARY-UOMSUPLMNTARY_UOM | Alpha 4 | This field contains the valid stock unit of measure for this item. | — |
#MH1-PRPY-UNIT-CSTPRPY_UNIT_CST | Signed 18.5 | — | — |
#MH1-PRPY-TAX-CODEPRPY_TAX_CODE | Alpha 10 | — | — |
#MH1-PRPY-TAX-AMTPRPY_TAX_AMT | Signed 18.2 | — | — |
#MH1-PRPY-RTL-UCSTPRPY_RTL_UCST | Signed 18.5 | — | — |
#MH1-PREPAY-DATEPREPAY_DATE | Numeric 8 (yyyymmdd) | — | — |
#MH1-INVC-TAX-AMTINVC_TAX_AMT | Signed 18.2 | — | — |
#MH1-ACCR-TAX-AMTACCR_TAX_AMT | Signed 18.2 | — | — |
#MH1-COMMODITY-CODECOMMODITY_CODE | Alpha 35 | — | AP198 |
#MH1-PROD-TAX-CATPROD_TAX_CAT | Alpha 15 | — | AP198 |
#MH1-GTINGTIN | Numeric 14 | — | AP198 |
Indexes (5)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
MH1SET1 |
| Primary | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +22 more (list truncated in source) | |
MH1SET10 |
| KeyChange, Subset | Where STATUS = 1 | MA278, PO64.1 |
MH1SET2 |
| KeyChange | — | |
MH1SET8 |
| KeyChange | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source) | |
MH1SET9 |
| KeyChange, Subset | Where INVOICE-TYPE = Spaces | AM19.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
| Relation | Table | Rules | Condition | Field map | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Apapihist | APAPIHIST | Required |
| ||||||||||||||||||||||
| Maaoihist | MAAOIHIST | Not Required |
| ||||||||||||||||||||||
| Poline | POLINE | Not Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Mmdist | MMDIST | Valid When MH1-ITEM-TYPE != "I" |
|
Programs
Updated by (243)
- AM19.1 PO Line Asset Detail
- AM19.2 Create Detail
- AP115 Vendor Merge
- AP125 Batch Release
- AP126 Mass Invoice Release
- AP131 Chargeback
- AP180 Bill of Exchange Cashing Update
- AP181 Bill of Exchange Statement Update
- AP190 Invoice Reinstatement
- AP198 Invoice Data Archival
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP21.1 View Distributions
- AP220 Invoice Edit Report
- AP23.1 Transit Invoice Entry
- AP25.1 Batch Control
- AP25.2 Batch Review
- AP26.1 Invoice Release
- AP27.1 Single Invoice Release
- AP28.1 Bill of Exchange Acceptance by Vendor
- AP28.2 Bill of Exchange Acceptance by Date
- AP30.2 Distribution Adjustments
- AP30.4 Invoice Cancel
- AP300 Invoice and Vendor History Purge
- AP305 Accounts Payable Company Purge
- AP45.1 Reportable Income Adjustment
- AP510 Vendor Conversion
- API1.1 Add Invoice
- API2.1 Add Invoice
- CX100 Pick List Print
- CX20.1 Case Build
- CX20.2 Case Detail
- CX20.4 Substitute Items
- CX20.5 Insert line
- CX220 Case, Preference Listing
- CX30.1 Case Completion Feedback
- CX300 Preference List Purge
- CX506 HL7 Schedules Import Interface
- CXCP.1 Copy preference to case
- DR100 Distribution Requirements Report
- IC12.1 Item Location
- IC140 Vendor Reorder Advice
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC145 Stock Status Report
- IC243 Killed Item Report
- IC330 Item Mass Change
- IC64.1 Global Location Nbr Assignment GL/IC Company
- IC64.2 Global Location Nbr Assignment IC Location
- IC64.3 Global Location Number Assignment RQ Location
- IC64.4 Global Location Number Assignment Manuf Code
- IC64.5 Global Location Number Assignment Manuf Div
- IC64.6 Global Location Number Assignment Vendor
- IC64.7 Global Location Number Assignment Vendor Location
- IC64.8 Global Location Number Assignment IC Bin
- IC64.9 Global Location Number Assignment Buyer
- IC66.1 Replenishment PO Worksheet
- IC83.1 Par Location Counts
- MA126 Auto Matching
- MA180 Open Receipt Archive
- MA278 Cost Variance Analysis
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.1 Memo Line Detail - Purchase Order
- MA42.2 Memo Line AOC Detail
- MA43.1 Invoice Line Detail - Purchase Order
- MA43.2 Purchase Order Lookup
- MA43.3 Invoice Line Detail - Receipt
- MA43.4 Invoice Line Detail - Service
- MA43.6 Service Agreement Detail
- MA43.7 GL Distribution
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA53.1 Receipt Interface
- MA530 ERS Invoice Creation
- MA531 Receipt Interface
- MA60.2 Invoice Level Match
- MA60.3 Detail Level Match
- MA60.5 Receipt Match Reference Adjustment
- MA61.1 Match Invoice Approval
- MA63.1 Invoice Line Match
- MA65.1 Invoice Line Adjustment
- MA66.2 Invoice Message - Details
- MA67.2 Invoice Match from frontend
- MA67.3 Detail Match from frontend
- MA68.2 Invoice Level Match - Prepaid
- MA68.3 Detail Level Match - Prepaid
- MA68.5 Receipt Match Reference Adjustment
- MA69.1 AOC Level Detail Match
- MA70.1 Invoice Unmatch
- MA75.1 PO Invoice Cancel
- MA80.1 Receipt Archive
- MAI1.1 Invoke for MAMATCH Object
- PD10.1 P-Card Card Request
- PD10.2 P-Card Cardholder
- PD130 P-Card Invoice and Release
- PD20.1 P-Card Charge Approval
- PD20.2 P-Card Charge Approval Level
- PD20.3 P-Card Charge Approval SEA
- PD570 P-Card Charge Import
- PO04.1 Buyer
- PO04.2 Buyer Purchasing Class
- PO10.1 PO Vendor
- PO10.2 Vendor Purchase From Location
- PO100 Purchase Order Interface from Lawson Applications
- PO101 Create Standing PO Release
- PO115 Procurement Template Mass Changes
- PO120 Mass PO Issue
- PO122 Transmitted PO Acknowledgement
- PO131 Receiving Log
- PO132 Print Vendor Return Material Authorization
- PO136 Matched, Not Received Report
- PO15.1 Procurement Templates
- PO15.2 Procurement Template Participants
- PO15.4 Procurement Template Line Detail
- PO150 Bid Load to Contract or Catalog
- PO17.1 Purchase Order Approval Review
- PO190 Close Purchase Order Header
- PO20.1 Purchase Order Entry
- PO20.6 Substitute Vendor Items
- PO20.9 Multiple Lines
- PO204 Buyer Master Listing
- PO21.1 Select and Copy
- PO21.2 Add-On Cost Spread
- PO21.3 Account Distribution
- PO21.4 Miscellaneous Add-On Cost
- PO21.5 Item Add-On Cost
- PO22.1 Authorization, Release
- PO22.3 Mass Cancel or Delete Purchase Orders
- PO22.4 Mass Cancel or Delete Purchase Order Lines
- PO220 PO Status Report
- PO222 Remaining PO Balance Report
- PO224 PO Revision Report
- PO225 Vendor Agreement Listing
- PO229 Vendor Agreement Format Print
- PO23.1 Purchase Order Worksheet
- PO230 Unreleased Receivings Listing
- PO234 PO Interface Listing Report
- PO24.1 Purchase Order Direct Approval
- PO25.1 Vendor Agreements
- PO25.5 Vendor Agreement Item Add-On Cost
- PO25.6 Vendor Agreement Line
- PO25.7 Service Agreement Line
- PO251 PO Buyer Message Listing
- PO26.3 Vendor Agreement Commitments Spread
- PO26.7 Mass Release of Vendor Agreements
- PO26.9 Vendor Agreement Release
- PO27.2 Select Blanket Lines
- PO27.3 Create PO From Procurement Template
- PO27.4 Select and Copy Template
- PO275 Delivery Date Analysis
- PO276 Deliver Quantity Analysis
- PO277 Deliver Quality Analysis
- PO28.2 Vendor Agreement Line Detail List
- PO280 Purchases By Class
- PO29.1 Copy Purchase Order
- PO30.1 PO Receiving
- PO30.2 Substitute Item
- PO30.3 Additional Tracking Numbers
- PO30.4 PO Receiving Line Detail List
- PO300 PO and Receipt Purge
- PO31.1 Vendor Return
- PO31.2 Vendor Return Item Selection
- PO32.2 Item Detail
- PO32.4 Cancel Detail
- PO33.1 Receiving Adjustment
- PO34.1 Inspection Accept or Reject
- PO35.1 Receiving Approval and Release
- PO36.1 Identify Lawson Items by Vendor Agreement Line
- PO36.2 Vendor Agreement Import Manual Input
- PO38.1 Invoice AOC
- PO39.1 Additional Receiving Entry
- PO39.2 Additional Adjustment/Rejection Entry
- PO44.1 PO Line Source
- PO50.1 Buyer Message Entry
- PO52.1 Buyer Message - Receiving
- PO520 Purchase Order Interface from Non Lawson
- PO536 Vendor Price Agreement Load
- PO54.5 PO Line Detail List
- POCP.1 POC Comments Copy
- POI3.1 Invoke for POPI70PD
- POID.1 PO Delivery Ticket Select
- POII.1 Invoke for POPCRUPD
- POIJ.1 Invoke for POPLIUPD
- RQ01.1 Requesting Locations
- RQ10.1 Requisition
- RQ10.2 Account Distribution
- RQ10.3 Select and Copy
- RQ10.4 Requisition Line Entry Detail
- RQ10.5 Substitutes
- RQ11.1 Kit Accessories
- RQ12.1 Approval Review
- RQ13.1 Direct Approval
- RQ13.2 Direct Line Approval
- RQ35.1 Requisition Returns
- RQ44.1 Requisition Inquiry
- RQ500 Requisition Interface
- RQ810 Request Location Load
- RQIB.1 RQRQHUPD Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQII.1 Invoke for Reqheader Inquiry
- RQIJ.1 Requisition Copy
- WH130 Pick List Print
- WH132 Batch Feedback
- WH190 Shipment Release
- WH20.2 Nonstock and Special Allocation
- WH20.7 Substitute Location
- WH222 Shipments In Process
- WH30.1 Picking Feedback by Document
- WH30.2 Picking Feedback by Shipment
- WH30.3 Picking by Batch
- WH30.4 Bin Sequence Picking Feedback
- WH31.1 Packing Feedback by Document
- WH31.2 Packing Feedback by Shipment
- WH31.3 Packing by Batch
- WH31.4 Bin Sequence Packing Feedback
- WH32.1 Shipping Feedback by Document
- WH32.2 Shipping Feedback by Shipment
- WH32.3 Shipping by Batch
- WH32.4 Bin Sequence Shipping Feedback
- WH32.5 Shipping Line Feedback
- WH33.1 Bins
- WH33.2 Lots
- WH33.3 Serials
- WH33.4 UOMs
- WH33.5 Additional Shipment Information
- WH33.6 Catch Weight
- WH33.8 Preassembled Kits
- WH33.9 Line Options
- WH34.1 Component Bins
- WH34.2 Component Lots
- WH34.3 Component Serials
- WH34.4 Component UOMs
- WH40.1 Bill of Lading
- WH40.2 Bill of Lading Feedback
- WH520 Batch Feedback Interface
- WH830 Shipment Load Program
Referenced by (1)
- PO64.1 PO Line Item History