Lawson Insight Technical Documentation |
|
MAMADHIST
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 MA41.1 MA41.2
MA41.4 MA41.7 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 MA75.1
MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MH1-COMPANY Numeric 4 AP198
Element: Company The company number represents an
established company and is entered on
all function codes.
MH1-VENDOR Alpha 9 (Right Justified) AP115 AP125
Element: 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 MA41.1
MA41.2 MA41.4
MA41.7 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
MA75.1 MAI1.1
MH1-INVOICE Alpha 22 AP115 AP125
Element: Invoice NumberUsed 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 MA41.1
MA41.2 MA41.4
MA41.7 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
MA75.1 MAI1.1
MH1-SUFFIX Numeric 3 AP198
Element: Invoice SuffixThis 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 NumUsed 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 Number This field contains the line number.
MH1-AOC-CODE Alpha 2 AP198
Element: Add On Cost CoThis field contains the identifier for
the add on cost associated with this
line item.
MH1-SEQ-NBR Numeric 4 AP198
Element: Sequence NumbeAn 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 Number This field contains the item
identifier.
MH1-VEN-ITEM Alpha 32 AP198
Element: Item Number
MH1-MATCHED-QTY Signed 13.4 AP198
Element: Quantity
MH1-MATCH-UNIT-CST Signed 13.5 AP198
Element: Base Cost
MH1-VPRI-UOM Alpha 4 AP198
Element: Unit of Measure
MH1-VPRI-UOM-MULT Signed 13.7 AP198
Unit of Measure
Multiplier
MH1-ENTERED-QTY Signed 13.4 AP198
Element: Quantity
MH1-ENT-UNIT-CST Signed 13.5 AP198
Element: Base 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
Element: Tax Type The type of tax.
MH1-TAX-AMOUNT Signed 13.5 AP198
Element: Base Cost
MH1-VBUY-MATCH-QTY Signed 13.4 AP198
Element: Quantity
MH1-VBUY-UOM Alpha 4 AP198
Element: Unit of Measure
MH1-VBUY-UOM-MULT Signed 13.7 AP198
Unit of Measure
Multiplier
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 13.5 AP198
Element: Base Cost
MH1-LOCATION Alpha 5 AP198
Element: Location Code This field contains a valid stocking
location within the company inventory.
MH1-MATCH-OBJ-ID Numeric 12 AP198
Object
Identification
MH1-ENT-UOM Alpha 4 AP198
Element: Unit of Measure
MH1-ENT-UOM-MULT Signed 13.7 AP198
Unit of Measure
Multiplier
MH1-TRAN-ND Numeric 1 AP198
Account Currency
Code
MH1-REC-SOURCE Alpha 2 AP198
Element: Rec Source
MH1-TOT-DIST-AMT Signed 15.2 AP198
Element: Adj Amt
MH1-TOT-BASE-AMT Signed 15.2 AP198
Element: Adj Amt
MH1-STATUS Numeric 1 AP198
Element: Status This field displays the status of the
transaction.
MH1-API-OBJ-ID Numeric 12 AP198
Object
Identification
MH1-MA-REC-NBR Numeric 10 AP198
Element: Receiver Number
MH1-MA-LINE-NBR Numeric 6 AP198
Element: Line Number
MH1-MATCH-SEQ-NBR Numeric 4 AP198
Element: Number of Items
MH1-MTCH-EXC-PROC Numeric 1 AP198
Element: Mtch Exc Proc
MH1-INVOICE-TYPE Alpha 1 AP198
Element: Invoice Type
MH1-DISTRIB-DATE Numeric 8 (yyyymmdd) AP198
Element: Date
MH1-UPDATE-DATE Numeric 8 (yyyymmdd) AP198
Element: Date
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
MH1-WEIGHT Signed 9.3 AP198
Element: 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 MA41.1
MA41.2 MA41.4
...
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
...
MH1SET9 COMPANY KeyChange, Subset AP115 AP125
MATCH-OBJ-ID Where INVOICE-TYPE = Spaces AP126 AP131
MATCH-SEQ-NBR AP20.1 AP20.2
VENDOR AP20.3 AP20.4
INVOICE AP20.5 AP20.7
SUFFIX AP220 AP23.1
PO-NUMBER AP25.1 AP25.2
PO-RELEASE AP26.1 AP27.1
PO-CODE AP30.2 AP30.4
LINE-NBR AP305 API1.1
AOC-CODE MA41.1 MA41.2
SEQ-NBR MA41.4 MA41.7
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
|