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. |
|
||
MH1-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. |
|||
MH1-INVOICE Element: Invoice | Alpha 22 Used to identify the invoice. |
|||
MH1-SUFFIX Element: Suffix | Numeric 3 This is the suffix for the invoice. |
|
||
MH1-PO-NUMBER Element: Po Number | Alpha 14 (Right Justified) This field contains the number representing the purchase order. |
|
||
MH1-PO-RELEASE Element: Po Release | Numeric 4 Used to identify a purchase order release (created from a Blanket or Standing order). |
|
||
MH1-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code. |
|
||
MH1-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the line number. |
|
||
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. |
|
||
MH1-ITEM-TYPE Element: Item Type | Alpha 1 This field identifies the line item type. |
|
||
MH1-ITEM Element: Item | Alpha 32 This field contains the item identifier. |
|
||
MH1-VEN-ITEM Element: Item | Alpha 32 This field contains the item identifier. |
|
||
MH1-ITEM-DESC Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
||
MH1-MATCHED-QTY Element: Quantity | Signed 13.4 This field contains the desired quantity. |
|
||
MH1-MATCH-UNIT-CST Element: Intl Cost | Signed 18.5 |
|
||
MH1-VPRI-UOM Element: Uom | Alpha 4 This field contains the valid stock unit of measure for this item. |
|
||
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. |
|
||
MH1-ENTERED-QTY Element: Quantity | Signed 13.4 This field contains the desired quantity. |
|
||
MH1-ENT-UNIT-CST Element: Intl Cost | Signed 18.5 |
|
||
MH1-TAX-CODE Element: Tax Code | Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code. |
|
||
MH1-TAX-TYPE Element: Tax Type | Alpha 1 The type of tax. |
|
||
MH1-TAX-AMOUNT Element: Intl Amt | Signed 18.2 |
|
||
MH1-VBUY-MATCH-QTY Element: Quantity | Signed 13.4 This field contains the desired quantity. |
|
||
MH1-VBUY-UOM Element: Uom | Alpha 4 This field contains the valid stock unit of measure for this item. |
|
||
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. |
|
||
MH1-NO-TAX-FLAG Element: Account Flag | Alpha 1 |
|
||
MH1-MATCH-CLASS Element: Match Class | Alpha 10 |
|
||
MH1-MATCH-DTL-KEY Element: Match Dtl Key | Alpha 85 |
|
||
MH1-RTL-UNIT-COST Element: Intl Cost | Signed 18.5 |
|
||
MH1-LOCATION Element: Location | Alpha 5 This field contains a valid stocking location within the company inventory. |
|
||
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. |
|
||
MH1-ENT-UOM Element: Uom | Alpha 4 This field contains the valid stock unit of measure for this item. |
|
||
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. |
|
||
MH1-TRAN-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||
MH1-REC-SOURCE Element: Rec Source | Alpha 2 |
|
||
MH1-TOT-DIST-AMT Element: Intl Amt | Signed 18.2 |
|
||
MH1-TOT-BASE-AMT Element: Intl Amt | Signed 18.2 |
|
||
MH1-STATUS Element: Status | Numeric 1 This field displays the status of the transaction. |
|
||
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. |
|
||
MH1-MA-REC-NBR Element: Rec Number | Numeric 10 The receiver number. Assigned when this receiving information was added. |
|
||
MH1-MA-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the line number. |
|
||
MH1-MATCH-SEQ-NBR Element: Match Seq Nbr | Numeric 4 |
|
||
MH1-MTCH-EXC-PROC Element: Mtch Exc Proc | Numeric 1 |
|
||
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. |
|
||
MH1-DISTRIB-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||
MH1-UPDATE-DATE Element: Update Date | Numeric 8 (yyyymmdd) This field contains the date the record was updated. |
|
||
MH1-UPDATE-TIME Element: Update Time | Numeric 6 This field contains the system time when the record was updated. |
|
||
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. |
|
||
MH1-ICN-CODE Element: Icn Code | Alpha 8 |
|
||
MH1-SUPLMNTARY-QTY Element: Quantity | Signed 13.4 This field contains the desired quantity. |
|
||
MH1-WEIGHT Element: Weight | Signed 9.3 This field contains the unit weight of the item based on the stocking UOM. |
|
||
MH1-TERMS-CD Element: Terms Cd | Alpha 5 |
|
||
MH1-DISC-RATE Element: Disc Rate | Percent 5.3 (Percent) |
|
||
MH1-DISC-DATE Element: Disc Date | Numeric 8 (yyyymmdd) |
|
||
MH1-FLEX-FLAG Element: Flex Flag | Alpha 1 |
|
||
MH1-PREPAY-QTY Element: Prepay Qty | Signed 13.4 |
|
||
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. |
|
||
MH1-CATCH-WGT-COST Element: Intl Cost | Signed 18.5 |
|
||
MH1-REASON-CODE Element: Reason Code | Alpha 4 This field contains the reason code, which indicates the cause for credit memos. |
|
||
MH1-CHARGEBACK-FL Element: Chargeback Fl | Alpha 1 |
|
||
MH1-IR-DIFF-AMT Element: Intl Amt | Signed 18.2 |
|
||
MH1-MATCH-EXT-COST Element: Match Ext Cost | Derived |
|
||
MH1-AGREEMENT-REF Element: Agreement Ref | Alpha 30 |
|
||
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 |
|
||
MH1-PROD-TAX-CAT Element: Prod Tax Cat | Alpha 15 |
|
||
MH1-GTIN Element: Gtin | Numeric 14 |
|
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 |
|
|||||||||||||||
MH1SET10 |
COMPANY PO-NUMBER PO-RELEASE PO-CODE LINE-NBR UPDATE-DATE* UPDATE-TIME* VENDOR INVOICE SUFFIX AOC-CODE SEQ-NBR |
|
| ||||||||||||||
MH1SET2 |
COMPANY PO-NUMBER PO-RELEASE PO-CODE LINE-NBR VENDOR INVOICE SUFFIX AOC-CODE SEQ-NBR |
|
|||||||||||||||
MH1SET8 |
COMPANY API-OBJ-ID PO-NUMBER PO-RELEASE PO-CODE LOCATION MATCH-DTL-KEY LINE-NBR AOC-CODE SEQ-NBR |
|
|||||||||||||||
MH1SET9 |
COMPANY MATCH-OBJ-ID MATCH-SEQ-NBR VENDOR INVOICE SUFFIX PO-NUMBER PO-RELEASE PO-CODE LINE-NBR AOC-CODE SEQ-NBR |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apapihist | APAPIHIST |
Required
| |||||||||||||||||||||
Maaoihist | MAAOIHIST |
Not Required
| |||||||||||||||||||||
Poline | POLINE |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Mmdist | MMDIST |
|
All trademarks and registered trademarks are the property of their
respective owners.