 |
Lawson Insight Technical Documentation |
|
MAMADHIST FILE
REFERENCED BY
MA278 PO64.1
UPDATED BY
AP115 AP125 AP126 AP131 AP180 AP181
AP190 AP198 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 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 MA126 MA41.1
MA41.2 MA41.4 MA43.1 MA43.2 MA43.3 MA43.4
MA43.5 MA43.7 MA43.8 MA60.2 MA60.3 MA61.1
MA63.1 MA65.1 MA66.2 MA68.1 MA70.1 MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MH1-COMPANY Numeric 4 AP198
Company The company number represents an
established company and is entered on
all function codes.
MH1-VENDOR Alpha 9 (Right Justified) AP115 AP125
Vendor ID The vendor's identification code. AP126 AP131
AP198 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 MA126
MA41.1 MA41.2
MA41.4 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.2 MA60.3
MA61.1 MA63.1
MA65.1 MA66.2
MA68.1 MA70.1
MAI1.1
MH1-INVOICE Alpha 22 AP115 AP125
Invoice Number Used to identify the invoice. AP126 AP131
AP198 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 MA126
MA41.1 MA41.2
MA41.4 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA60.2 MA60.3
MA61.1 MA63.1
MA65.1 MA66.2
MA68.1 MA70.1
MAI1.1
MH1-SUFFIX Numeric 3 AP198
Invoice Suffix This is the suffix for the invoice.
MH1-PO-NUMBER Alpha 14 (Right Justified) AP198
PO Number This field contains the number
representing the purchase order.
MH1-PO-RELEASE Numeric 4 AP198
PO Release Number Used to identify a purchase order
release (created from a Blanket or
Standing order).
MH1-PO-CODE Alpha 4 AP198
Po Code This is the purchase order code.
MH1-LINE-NBR Numeric 6 AP198
Line Number This field contains the line number.
MH1-AOC-CODE Alpha 2 AP198
Add On Cost Code This field contains the identifier for
the add on cost associated with this
line item.
MH1-SEQ-NBR Numeric 4 AP198
Sequence Number An automatically assigned sequence
number.
MH1-ITEM-TYPE Alpha 1 AP198
Item Type This field identifies the line item
type.
MH1-ITEM Alpha 32 AP198
Item Number This field contains the item
identifier.
MH1-VEN-ITEM Alpha 32 AP198
Vendor Item The vendor's item identifer.
MH1-MATCHED-QTY Signed 13.4 AP198
Matched Qty
MH1-MATCH-UNIT-CST Signed 13.5 AP198
Match Unit Cst
MH1-VPRI-UOM Alpha 4 AP198
Vendor Price Unit This is the vendor pricing unit of
of Measure measure.
MH1-VPRI-UOM-MULT Signed 13.7 AP198
Vendor Price UOM This is the vendor pricing unit of
Multiplier measure multiplier. It is used to
convert unit cost to stock unit of
measure terms.
MH1-ENTERED-QTY Signed 13.4 AP198
Entered Qty
MH1-ENT-UNIT-CST Signed 13.5 AP198
Entered Unit Cost The entered unit cost.
MH1-TAX-CODE Alpha 10 AP198
Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
MH1-TAX-TYPE Alpha 1
Tax Type The type of tax.
MH1-TAX-AMOUNT Signed 13.5 AP198
Tax Amount
MH1-VBUY-MATCH-QTY Signed 13.4 AP198
Vbuy Match Qty
MH1-VBUY-UOM Alpha 4 AP198
Vendor Buy Unit of The vendor's buying unit of measure.
Measure
MH1-VBUY-UOM-MULT Signed 13.7 AP198
Vendor Buy UOM Vendor Buy Unit Of Measure Multiplier.
Multiplier Used to convert quantity and unit cost.
MH1-NO-TAX-FLAG Alpha 1 AP198
No Tax Flag
MH1-MATCH-CLASS Alpha 10 AP198
Match Class
MH1-MATCH-DTL-KEY Alpha 55 AP198
Match Dtl Key
MH1-RTL-UNIT-COST Signed 13.5 AP198
Rtl Unit Cost
MH1-LOCATION Alpha 5 AP198
Location Code This field contains a valid stocking
location within the company inventory.
MH1-MATCH-OBJ-ID Numeric 12 AP198
Match Obj Id
MH1-ENT-UOM Alpha 4 AP198
Ent Uom
MH1-ENT-UOM-MULT Signed 13.7 AP198
Entered UOM This is the multiplier that relates the
Multiplier entered UOM to stock UOM.
MH1-TRAN-ND Numeric 1 AP198
Transaction Number The number of decimal positions defined
of Decimals for the transaction currency.
MH1-REC-SOURCE Alpha 2 AP198
Rec Source
MH1-TOT-DIST-AMT Signed 15.2 AP198
Total Distributed
Amount
MH1-TOT-BASE-AMT Signed 15.2 AP198
Total Base Amount This defines the total distributed
approval amount in the company base
currency.
MH1-STATUS Numeric 1 AP198
Status This field displays the status of the
transaction.
MH1-API-OBJ-ID Numeric 12 AP198
Api Obj Id
MH1-MA-REC-NBR Numeric 10 AP198
Ma Rec Nbr
MH1-MA-LINE-NBR Numeric 6 AP198
Ma Line Nbr
MH1-MATCH-SEQ-NBR Numeric 4 AP198
Match Seq Nbr
MH1-MTCH-EXC-PROC Numeric 1 AP198
Mtch Exc Proc
MH1-INVOICE-TYPE Alpha 1 AP198
Invoice Type
MH1-DISTRIB-DATE Numeric 8 (yyyymmdd) AP198
Distribution Date The date used for posting the
transactions to the general ledger.
MH1-UPDATE-DATE Numeric 8 (yyyymmdd) AP198
Update Date This field contains the date the record
was updated.
MH1-UPDATE-TIME Numeric 6 AP198
Update Time This field contains the system time
when the record was updated.
MH1-TAX-USAGE-CD Alpha 10 AP198
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
Icn Code
MH1-SUPLMNTARY-QTY Signed 13.4 AP198
Suplmntary Qty
MH1-WEIGHT Signed 9.3 AP198
Unit Weight This field contains the unit weight of
the item based on the stocking UOM.
MAMADHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MH1SET1 COMPANY AP115 AP125
VENDOR AP126 AP131
INVOICE AP180 AP181
SUFFIX AP190 AP20.1
PO-NUMBER AP20.2 AP20.3
PO-RELEASE AP20.4 AP20.5
PO-CODE AP20.7 AP220
LINE-NBR AP23.1 AP25.1
AOC-CODE AP25.2 AP26.1
SEQ-NBR AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP300
AP305 AP45.1
API1.1 MA126
MA41.1 MA41.2
...
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 AP115 AP125
API-OBJ-ID AP126 AP131
PO-NUMBER AP20.1 AP20.2
PO-RELEASE AP20.3 AP20.4
PO-CODE AP20.5 AP20.7
LOCATION AP220 AP23.1
MATCH-DTL-KEY AP25.1 AP25.2
LINE-NBR AP26.1 AP27.1
AOC-CODE AP30.2 AP30.4
SEQ-NBR AP305 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
...
MH1SET9 COMPANY KeyChange, Duplicates, Subset AP115 AP125
MATCH-OBJ-ID Where INVOICE-TYPE = Spaces AP126 AP131
MATCH-SEQ-NBR AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
...
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
|