Lawson Insight Technical Documentation |
|
MAMADHIST
MAMADHIST FILE
REFERENCED BY
MA278 PO64.1
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 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 MA180 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA66.3 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO29.1 PO30.1 PO30.2 PO30.3
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
POI3.1 POID.1 POII.1 POIJ.1 RQ10.1 RQ10.2
WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MH1-COMPANY Numeric 4 AP198
Element: Company 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.
MH1-VENDOR Alpha 9 (Right Justified) AM19.1 AM19.2
Element: Vendor The vendor's identification code. 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 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
...
MH1-INVOICE Alpha 22 AM19.1 AM19.2
Element: Invoice Used to identify the invoice. 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 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA63.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
...
MH1-SUFFIX Numeric 3 AP198
Element: Suffix This 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 Used 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 Nbr This field contains the line number.
MH1-AOC-CODE Alpha 2
Element: Aoc Code This field contains the identifier for
the add on cost associated with this
line item.
MH1-SEQ-NBR Numeric 4 AP198
Element: Seq Nbr An 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 This field contains the item
identifier.
MH1-VEN-ITEM Alpha 32 AP198
Element: Item This field contains the item
identifier.
MH1-ITEM-DESC Alpha 30 (Lower Case) AP198
Element: Description This field displays the description.
MH1-MATCHED-QTY Signed 13.4 AP198
Element: Quantity This field contains the desired
quantity.
MH1-MATCH-UNIT-CST Signed 18.5 AP198
Element: Intl Cost
MH1-VPRI-UOM Alpha 4 AP198
Element: Uom This field contains the valid stock
unit of measure for this item.
MH1-VPRI-UOM-MULT Signed 13.7 AP198
Element: Uom Mult This field contains the multiplier for
converting this unit of measure to the
stock unit of measure.
MH1-ENTERED-QTY Signed 13.4 AP198
Element: Quantity This field contains the desired
quantity.
MH1-ENT-UNIT-CST Signed 18.5 AP198
Element: Intl 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 AP198
Element: Tax Type The type of tax.
MH1-TAX-AMOUNT Signed 18.2 AP198
Element: Intl Amt
MH1-VBUY-MATCH-QTY Signed 13.4 AP198
Element: Quantity This field contains the desired
quantity.
MH1-VBUY-UOM Alpha 4 AP198
Element: Uom This field contains the valid stock
unit of measure for this item.
MH1-VBUY-UOM-MULT Signed 13.7 AP198
Element: Uom Mult This field contains the multiplier for
converting this unit of measure to the
stock unit of measure.
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 18.5 AP198
Element: Intl Cost
MH1-LOCATION Alpha 5 AP198
Element: Location This field contains a valid stocking
location within the company inventory.
MH1-MATCH-OBJ-ID Numeric 12 AP198
Element: Obj Id 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.
MH1-ENT-UOM Alpha 4 AP198
Element: Uom This field contains the valid stock
unit of measure for this item.
MH1-ENT-UOM-MULT Signed 13.7 AP198
Element: Uom Mult This field contains the multiplier for
converting this unit of measure to the
stock unit of measure.
MH1-TRAN-ND Numeric 1 AP198
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
MH1-REC-SOURCE Alpha 2 AP198
Element: Rec Source
MH1-TOT-DIST-AMT Signed 18.2 AP198
Element: Intl Amt
MH1-TOT-BASE-AMT Signed 18.2 AP198
Element: Intl Amt
MH1-STATUS Numeric 1 AP198
Element: Status This field displays the status of the
transaction.
MH1-API-OBJ-ID Numeric 12 AP198
Element: Obj Id 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.
MH1-MA-REC-NBR Numeric 10 AP198
Element: Rec Number The receiver number. Assigned when
this receiving information was added.
MH1-MA-LINE-NBR Numeric 6 AP198
Element: Line Nbr This field contains the line number.
MH1-MATCH-SEQ-NBR Numeric 4 AP198
Element: Match Seq Nbr
MH1-MTCH-EXC-PROC Numeric 1 AP198
Element: Mtch Exc Proc
MH1-INVOICE-TYPE Alpha 1 AP198
Element: Invoice Type 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.
MH1-DISTRIB-DATE Numeric 8 (yyyymmdd) AP198
Element: Date This field displays the system date
when this was created.
MH1-UPDATE-DATE Numeric 8 (yyyymmdd) AP198
Element: Update Date This field contains the date the record
was updated.
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 This field contains the desired
quantity.
MH1-WEIGHT Signed 9.3 AP198
Element: Weight This field contains the unit weight of
the item based on the stocking UOM.
MH1-TERMS-CD Alpha 5 AP198
Element: Terms Cd
MH1-DISC-RATE Percent 5.3 (Percent) AP198
Element: Disc Rate
MH1-DISC-DATE Numeric 8 (yyyymmdd) AP198
Element: Disc Date
MH1-FLEX-FLAG Alpha 1 AP198
Element: Flex Flag
MH1-PREPAY-QTY Signed 13.4 AP198
Element: Prepay Qty
MH1-XREF-VENDOR Alpha 9 (Right Justified)
Element: Xref Vendor 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 Numeric 2 AP198
Element: Match Err TypeThis is the reason the match was not
successful.
MH1-CATCH-WGT-COST Signed 18.5 AP198
Element: Intl Cost
MH1-REASON-CODE Alpha 4 AP198
Element: Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
MH1-CHARGEBACK-FL Alpha 1 AP198
Element: Chargeback Fl
MH1-IR-DIFF-AMT Signed 18.2 AP198
Element: Intl Amt
MH1-MATCH-EXT-COST Derived
Element: Match Ext Cost
MH1-AGREEMENT-REF Alpha 30 AP198
Element: Agreement Ref
MH1-LAST-MSG-SEQ Numeric 6
Element: Seq Number A unique number assigned to each
transaction to be interfaced into the
Lawson system.
MH1-SUPLMNTARY-UOM Alpha 4
Element: Uom This field contains the valid stock
unit of measure for this item.
MH1-PRPY-UNIT-CST Signed 18.5
Element: Intl Cost
MH1-PRPY-TAX-CODE Alpha 10
Element: Prpy Tax Code
MH1-PRPY-TAX-AMT Signed 18.2
Element: Intl Amt
MH1-PRPY-RTL-UCST Signed 18.5
Element: Intl Cost
MH1-PREPAY-DATE Numeric 8 (yyyymmdd)
Element: Prepay Date
MH1-INVC-TAX-AMT Signed 18.2
Element: Intl Amt
MH1-ACCR-TAX-AMT Signed 18.2
Element: Intl Amt
MH1-COMMODITY-CODE Alpha 35 AP198
Element: Commodity Code
MAMADHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MH1SET1 COMPANY AM19.1 AM19.2
VENDOR AP115 AP125
INVOICE AP126 AP131
SUFFIX AP180 AP181
PO-NUMBER AP190 AP20.1
PO-RELEASE AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
LINE-NBR AP20.7 AP21.1
AOC-CODE AP220 AP23.1
SEQ-NBR AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP300 AP305
AP45.1 API1.1
...
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 AM19.1 AM19.2
API-OBJ-ID AP115 AP125
PO-NUMBER AP126 AP131
PO-RELEASE AP20.1 AP20.2
PO-CODE AP20.3 AP20.4
LOCATION AP20.5 AP20.7
MATCH-DTL-KEY AP21.1 AP220
LINE-NBR AP23.1 AP25.1
AOC-CODE AP25.2 AP26.1
SEQ-NBR AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
...
MH1SET9 COMPANY KeyChange, Subset AM19.1 AM19.2
MATCH-OBJ-ID Where INVOICE-TYPE = Spaces AP115 AP125
MATCH-SEQ-NBR AP126 AP131
VENDOR AP20.1 AP20.2
INVOICE AP20.3 AP20.4
SUFFIX AP20.5 AP20.7
PO-NUMBER AP21.1 AP220
PO-RELEASE AP23.1 AP25.1
PO-CODE AP25.2 AP26.1
LINE-NBR AP27.1 AP30.2
AOC-CODE AP30.4 AP305
SEQ-NBR API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
...
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
|