MAMADHIST

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 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC140 IC66.1 IC83.1 MA180 MA278
MA41.1 MA41.2 MA41.4 MA41.7 MA42.1 MA42.2
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MA44.1 MA44.2 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA69.1 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PO100 PO101 PO122
PO131 PO136 PO150 PO190 PO20.1 PO20.6
PO20.9 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO23.1 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO27.2 PO28.2 PO29.1
PO30.1 PO30.2 PO30.3 PO30.4 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 PO54.5 PO64.1
POCP.1 POI3.1 POID.1 POII.1 POIJ.1 RQ10.1
RQ10.2 RQ10.4 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ500 RQIF.1 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MH1-COMPANY
Element: Company
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
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
...
AM19.1 AM19.2
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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.1 MA42.2
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA44.1 MA44.2
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MH1-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
...
AM19.1 AM19.2
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 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.1 MA42.2
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA44.1 MA44.2
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MH1-SUFFIX
Element: Suffix
Numeric 3
This is the suffix for the invoice.
AP198
MH1-PO-NUMBER
Element: Po Number
Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
AP198
MH1-PO-RELEASE
Element: Po Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
AP198
MH1-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
AP198
MH1-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
AP198
MH1-AOC-CODE
Element: Aoc Code
Alpha 2
This field contains the identifier for the add on cost associated with this line item.
MH1-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
AP198
MH1-ITEM-TYPE
Element: Item Type
Alpha 1
This field identifies the line item type.
AP198
MH1-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
AP198
MH1-VEN-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
AP198
MH1-ITEM-DESC
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
AP198
MH1-MATCHED-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
AP198
MH1-MATCH-UNIT-CST
Element: Intl Cost
Signed 18.5
AP198
MH1-VPRI-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
AP198
MH1-VPRI-UOM-MULT
Element: 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-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
AP198
MH1-ENT-UNIT-CST
Element: Intl Cost
Signed 18.5
AP198
MH1-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
AP198
MH1-TAX-TYPE
Element: Tax Type
Alpha 1
The type of tax.
AP198
MH1-TAX-AMOUNT
Element: Intl Amt
Signed 18.2
AP198
MH1-VBUY-MATCH-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
AP198
MH1-VBUY-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
AP198
MH1-VBUY-UOM-MULT
Element: 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-FLAG
Element: Account Flag
Alpha 1
AP198
MH1-MATCH-CLASS
Element: Match Class
Alpha 10
AP198
MH1-MATCH-DTL-KEY
Element: Match Dtl Key
Alpha 85
AP198
MH1-RTL-UNIT-COST
Element: Intl Cost
Signed 18.5
AP198
MH1-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
AP198
MH1-MATCH-OBJ-ID
Element: 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-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
AP198
MH1-ENT-UOM-MULT
Element: 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-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
AP198
MH1-REC-SOURCE
Element: Rec Source
Alpha 2
AP198
MH1-TOT-DIST-AMT
Element: Intl Amt
Signed 18.2
AP198
MH1-TOT-BASE-AMT
Element: Intl Amt
Signed 18.2
AP198
MH1-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction.
AP198
MH1-API-OBJ-ID
Element: 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-NBR
Element: Rec Number
Numeric 10
The receiver number. Assigned when this receiving information was added.
AP198
MH1-MA-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
AP198
MH1-MATCH-SEQ-NBR
Element: Match Seq Nbr
Numeric 4
AP198
MH1-MTCH-EXC-PROC
Element: Mtch Exc Proc
Numeric 1
AP198
MH1-INVOICE-TYPE
Element: Invoice 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-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
AP198
MH1-UPDATE-DATE
Element: Update Date
Numeric 8 (yyyymmdd)
This field contains the date the record was updated.
AP198
MH1-UPDATE-TIME
Element: Update Time
Numeric 6
This field contains the system time when the record was updated.
AP198
MH1-TAX-USAGE-CD
Element: Tax 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-CODE
Element: Icn Code
Alpha 8
AP198
MH1-SUPLMNTARY-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
AP198
MH1-WEIGHT
Element: Weight
Signed 9.3
This field contains the unit weight of the item based on the stocking UOM.
AP198
MH1-TERMS-CD
Element: Terms Cd
Alpha 5
AP198
MH1-DISC-RATE
Element: Disc Rate
Percent 5.3 (Percent)
AP198
MH1-DISC-DATE
Element: Disc Date
Numeric 8 (yyyymmdd)
AP198
MH1-FLEX-FLAG
Element: Flex Flag
Alpha 1
AP198
MH1-PREPAY-QTY
Element: Prepay Qty
Signed 13.4
AP198
MH1-XREF-VENDOR
Element: 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
Element: Match Err Type
Numeric 2
This is the reason the match was not successful.
AP198
MH1-CATCH-WGT-COST
Element: Intl Cost
Signed 18.5
AP198
MH1-REASON-CODE
Element: Reason Code
Alpha 4
This field contains the reason code, which indicates the cause for credit memos.
AP198
MH1-CHARGEBACK-FL
Element: Chargeback Fl
Alpha 1
AP198
MH1-IR-DIFF-AMT
Element: Intl Amt
Signed 18.2
AP198
MH1-MATCH-EXT-COST
Element: Match Ext Cost
Derived
MH1-AGREEMENT-REF
Element: Agreement Ref
Alpha 30
AP198
MH1-LAST-MSG-SEQ
Element: Seq Number
Numeric 6
A unique number assigned to each transaction to be interfaced into the Lawson system.
MH1-SUPLMNTARY-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
MH1-PRPY-UNIT-CST
Element: Intl Cost
Signed 18.5
MH1-PRPY-TAX-CODE
Element: Prpy Tax Code
Alpha 10
MH1-PRPY-TAX-AMT
Element: Intl Amt
Signed 18.2
MH1-PRPY-RTL-UCST
Element: Intl Cost
Signed 18.5
MH1-PREPAY-DATE
Element: Prepay Date
Numeric 8 (yyyymmdd)
MH1-INVC-TAX-AMT
Element: Intl Amt
Signed 18.2
MH1-ACCR-TAX-AMT
Element: Intl Amt
Signed 18.2
MH1-COMMODITY-CODE
Element: Commodity Code
Alpha 35
AP198
MH1-PROD-TAX-CAT
Element: Prod Tax Cat
Alpha 15
AP198
MH1-GTIN
Element: Gtin
Numeric 14
AP198


MAMADHIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MH1SET1 COMPANY
VENDOR
INVOICE
SUFFIX
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
AOC-CODE
SEQ-NBR
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
MH1SET10 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
UPDATE-DATE*
UPDATE-TIME*
VENDOR
INVOICE
SUFFIX
AOC-CODE
SEQ-NBR
KeyChange, Subset
WhereSTATUS =1
MA278 PO64.1
MH1SET2 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
VENDOR
INVOICE
SUFFIX
AOC-CODE
SEQ-NBR
KeyChange
MH1SET8 COMPANY
API-OBJ-ID
PO-NUMBER
PO-RELEASE
PO-CODE
LOCATION
MATCH-DTL-KEY
LINE-NBR
AOC-CODE
SEQ-NBR
KeyChange
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
MH1SET9 COMPANY
MATCH-OBJ-ID
MATCH-SEQ-NBR
VENDOR
INVOICE
SUFFIX
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
AOC-CODE
SEQ-NBR
KeyChange, Subset
WhereINVOICE-TYPE =Spaces
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220


MAMADHIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 11:20:27 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.