|
|
MAMADHIST FILE
REFERENCED BY
MA278 PO64.1
UPDATED BY
AP115 AP125 AP126 AP131 AP180 AP181
AP190 AP198 AP220 AP25.1 AP25.2 AP26.1
AP27.1 AP28.1 AP28.2 AP30.2 AP30.4 AP300
AP305 AP45.1 API1.1 MA126 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 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) AP115 AP125
Element: Vendor ID The vendor's identification code. AP126 AP131
AP198 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
MA126 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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
MA126 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
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 The vendor's item identifer.
MH1-ITEM-DESC Alpha 30 (Lower Case)
Element: Description This field contains the description for
stock and non-stock items.
MH1-MATCHED-QTY Signed 13.4 AP198
Element: Quantity
MH1-MATCH-UNIT-CST Signed 18.5 AP198
Element: Intl Cost
MH1-VPRI-UOM Alpha 4 AP198
Element: Unit of MeasurThis is the vendor pricing unit of
measure.
MH1-VPRI-UOM-MULT Signed 13.7 AP198
Unit of Measure 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
Element: Quantity
MH1-ENT-UNIT-CST Signed 18.5 AP198
Element: Intl Cost The entered unit 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 18.2 AP198
Element: Intl Amt
MH1-VBUY-MATCH-QTY Signed 13.4 AP198
Element: Quantity
MH1-VBUY-UOM Alpha 4 AP198
Element: Unit of MeasurThe vendor's buying unit of measure.
MH1-VBUY-UOM-MULT Signed 13.7 AP198
Unit of Measure Vendor Buy Unit Of Measure Multiplier.
Multiplier Used to convert quantity and unit cost.
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 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 This is the multiplier that relates the
Multiplier entered UOM to stock UOM.
MH1-TRAN-ND Numeric 1 AP198
Account Currency The number of decimal positions defined
Code for the transaction 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 This defines the total distributed
approval amount in the company base
currency.
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: 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 The date used for posting the
transactions to the general ledger.
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
MH1-WEIGHT Signed 9.3 AP198
Element: Unit Weight This field contains the unit weight of
the item based on the stocking UOM.
MH1-TERMS-CD Alpha 5
Element: Terms Code
MH1-DISC-RATE Percent 5.3 (Percent)
Element: Discount Rate
MH1-DISC-DATE Numeric 8 (yyyymmdd)
Element: Discount Date
MH1-FLEX-FLAG Alpha 1
Element: Flex Deduction
MH1-PREPAY-QTY Signed 13.4
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
Element: Match Err TypeThis is the reason the match was not
successful.
MH1-CATCH-WGT-COST Signed 18.5
Element: Intl Cost
MH1-REASON-CODE Alpha 4
Element: Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
MH1-CHARGEBACK-FL Alpha 1
Element: Chargeback Fl
MH1-IR-DIFF-AMT Signed 18.2
Element: Intl Amt THis is the field that will hold the
difference between the invoice and the
receipt in order to calculate the
chargeback
MH1-MATCH-EXT-COST Derived
Element: Match Ext Cost
MH1-AGREEMENT-REF Alpha 30
Element: Agreement Ref
MAMADHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MH1SET1 COMPANY AP115 AP125
VENDOR AP126 AP131
INVOICE AP180 AP181
SUFFIX AP190 AP220
PO-NUMBER AP25.1 AP25.2
PO-RELEASE AP26.1 AP27.1
PO-CODE AP28.1 AP28.2
LINE-NBR AP30.2 AP30.4
AOC-CODE AP300 AP305
SEQ-NBR AP45.1 API1.1
MA126 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MA75.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 AP115 AP125
API-OBJ-ID AP126 AP131
PO-NUMBER AP220 AP25.1
PO-RELEASE AP25.2 AP26.1
PO-CODE AP27.1 AP30.2
LOCATION AP30.4 AP305
MATCH-DTL-KEY API1.1 MA126
LINE-NBR MA60.2 MA60.3
AOC-CODE MA61.1 MA63.1
SEQ-NBR MA65.1 MA66.2
MA68.1 MA70.1
MA75.1 MAI1.1
MH1SET9 COMPANY KeyChange, Subset AP115 AP125
MATCH-OBJ-ID Where INVOICE-TYPE = Spaces AP126 AP131
MATCH-SEQ-NBR AP220 AP25.1
VENDOR AP25.2 AP26.1
INVOICE AP27.1 AP30.2
SUFFIX AP30.4 AP305
PO-NUMBER API1.1 MA126
PO-RELEASE MA60.2 MA60.3
PO-CODE MA61.1 MA63.1
LINE-NBR MA65.1 MA66.2
AOC-CODE MA68.1 MA70.1
SEQ-NBR MA75.1 MAI1.1
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
|
