The Matching Invoice Detail file contains line item, miscellaneous add on
cost, and line item add on cost approval information by invoice and purchase
order.
FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
MAD-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.
|
|
MAD-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code.
|
|
MAD-INVOICE Element: Invoice | Alpha 22 Used to identify the invoice.
|
|
MAD-SUFFIX Element: Suffix | Numeric 3 This is the suffix for the invoice.
|
|
MAD-PO-NUMBER Element: Po Number | Alpha 14 (Right Justified) This field contains the number
representing the purchase order.
|
|
MAD-PO-RELEASE Element: Po Release | Numeric 4 Used to identify a purchase order
release (created from a Blanket or
Standing order).
|
|
MAD-PO-CODE Element: Purchase Order Code | Alpha 4 Purchase order number code. Used to
keep purchase orders unique. Can also be
used for reporting purposes.
|
|
MAD-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the line number.
|
|
MAD-SEQ-NBR Element: Seq Nbr | Numeric 4 An automatically assigned sequence
number.
|
|
MAD-ITEM-TYPE Element: Item Type | Alpha 1 This field identifies the line item
type.
I = Inventoried N = Non-stock S = Service X = Special |
|
MAD-ITEM Element: Item | Alpha 32 This field contains the item
identifier.
|
|
MAD-VEN-ITEM Element: Item | Alpha 32 This field contains the item
identifier.
|
|
MAD-ITEM-DESC Element: Description | Alpha 30 (Lower Case) This field displays the description.
|
|
MAD-MATCHED-QTY Element: Matched Quantity | Signed 13.4 The quantity of items that have been
matched.
|
|
MAD-MATCH-UNIT-CST Element: Intl Cost | Signed 18.5 THis unit cost is updated at match
|
|
MAD-VPRI-UOM Element: Uom | Alpha 4 This field contains the valid stock
unit of measure for this item.
|
|
MAD-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.
|
|
MAD-ENTERED-QTY Element: Quantity | Signed 13.4 THis is the VBUY quantity
|
|
MAD-ENT-UNIT-CST Element: Intl Cost | Signed 18.5 The entered unit cost in vendor price
unit of measure terms. This value may
be entered on line or calculated from
entry of cost in buy unit of measure
terms.
|
|
MAD-TAX-CODE Element: Tax Code | Alpha 10 This field contains a code representing
specific tax information. This must be
valid Tax Code.
|
|
MAD-TAX-TYPE Element: Tax Type | Alpha 1 The type of tax.
|
|
MAD-TAX-AMOUNT Element: Intl Amt | Signed 18.2 The tax amount for the invoice.
|
|
MAD-VBUY-MATCH-QTY Element: Matched Quantity | Signed 13.4 The quantity of items that have been
matched in VBUY measure terms.
|
|
MAD-VBUY-UOM Element: Uom | Alpha 4 This field contains the valid stock
unit of measure for this item.
|
|
MAD-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.
|
|
MAD-NO-TAX-FLAG Element: Taxable Invoice Flag | Alpha 1 Indicates if the invoice is taxable.
N = No Y = Yes |
|
MAD-MATCH-CLASS Element: Match Class | Alpha 10 Match class. A user-defined matching
key structure consisting of matching
elements.
|
|
MAD-MATCH-DTL-KEY Element: Match Detail Key | Alpha 85 Match detail key. Combines all Matching
Elements into a single element.
|
|
MAD-RTL-UNIT-COST Element: Retail Unit Cost | Signed 18.5 The retail unit cost of the item.
|
|
MAD-LOCATION Element: Location | Alpha 5 This field contains a valid stocking
location within the company inventory.
|
|
MAD-MATCH-OBJ-ID Element: Matching Object ID | Numeric 12 A system generated matching object
identifier.
|
|
MAD-ENT-UOM Entered Unit of Measure | Alpha 4 Entered unit of measure.
|
|
MAD-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.
|
|
MAD-TRAN-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a
particular account as determined by the
account currency.
|
|
MAD-REC-SOURCE Element: Record Source | Alpha 2 Indicates where the detail record was
created.
Valid values are:
IN = Invoice
" " = PO Entry
LM = Line Match (MA43)
IM = internal match details IS = Created by AOC spread from PO " " = PO Entry MA = Created within match MS = Generated by AOC spread |
|
MAD-TOT-DIST-AMT Total Distribution Amount | Signed 18.2 The total amount of the distribution.
|
|
MAD-TOT-BASE-AMT Element: Total Base Amount | Signed 18.2
|
|
MAD-STATUS Element: Status | Numeric 1 The transaction status.
Valid values are:
0 = Unmatched
1 = Matched
|
|
MAD-API-OBJ-ID Element: API Object ID | Numeric 12 A subsystem object interface
identification number.
|
|
MAD-MA-REC-NBR Element: Receipt Number | Numeric 10 The receipt number an invoice detail was
matched to in a detail match.
|
|
MAD-MA-LINE-NBR Element: Receipt Line Number | Numeric 6 Receipt line number.
|
|
MAD-MATCH-SEQ-NBR Matching Sequence Number | Numeric 4 Matching sequence number. Used to keep
records unique.
|
|
MAD-MTCH-EXC-PROC Element: Mtch Exc Proc | Numeric 1
0 = No excess quantity 1 = Chargeback 2 = Write off 3 = Matched no rec |
|
MAD-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.
C = Credit Memo " " = Regular |
|
MAD-DISTRIB-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date
when this was created.
|
|
MAD-UPDATE-DATE Element: Update Date | Numeric 8 (yyyymmdd) This field contains the date the record
was updated.
|
|
MAD-UPDATE-TIME Element: Update Time | Numeric 6 This field contains the system time
when the record was updated.
|
|
MAD-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.
|
|
MAD-LAST-MSG-SEQ Element: Seq Number | Numeric 6 A unique number assigned to each
transaction to be interfaced into the
Lawson system.
|
|
MAD-ICN-CODE Element: Icn Code | Alpha 8
|
|
MAD-SUPLMNTARY-QTY Element: Quantity | Signed 13.4 This field contains the desired
quantity.
|
|
MAD-SUPLMNTARY-UOM Element: Uom | Alpha 4 This field contains the valid stock
unit of measure for this item.
|
|
MAD-WEIGHT Element: Weight | Signed 9.3 This field contains the unit weight of
the item based on the stocking UOM.
|
|
MAD-TERMS-CD Element: Terms Cd | Alpha 5
|
|
MAD-DISC-RATE Element: Disc Rate | Percent 5.3 (Percent)
|
|
MAD-DISC-DATE Element: Disc Date | Numeric 8 (yyyymmdd)
|
|
MAD-FLEX-FLAG Element: Flex Flag | Alpha 1 Terms has been overriden with a flexible
term
|
|
MAD-PREPAY-QTY Element: Prepay Qty | Signed 13.4 For prepayment invoices this quantity
will be used
|
|
MAD-PRPY-UNIT-CST Element: Intl Cost | Signed 18.5 For prepayment invoice this unit cost
will be used
|
|
MAD-PRPY-TAX-CODE Element: Prpy Tax Code | Alpha 10 For prepayment invoices this tax code
will be used
|
|
MAD-PRPY-TAX-AMT Element: Intl Amt | Signed 18.2 FOr prepayment invoice this tax amount
will be used.
|
|
MAD-PRPY-RTL-UCST Element: Intl Cost | Signed 18.5
|
|
MAD-PREPAY-DATE Element: Prepay Date | Numeric 8 (yyyymmdd)
|
|
MAD-MATCH-ERR-TYPE Element: Match Err Type | Numeric 2 This is the reason the match was not
successful.
01 = cost error 02 = quantity error 03 = item error |
|
MAD-CATCH-WGT-COST Element: Intl Cost | Signed 18.5
|
|
MAD-REASON-CODE Element: Reason Code | Alpha 4 This field contains the reason code,
which indicates the cause for credit
memos.
|
|
MAD-CHARGEBACK-FL Element: Chargeback Fl | Alpha 1 THis flag notes that there is a
chargeback associated with this invoice
line.
0 = no 1 = yes |
|
MAD-IR-DIFF-AMT Element: Intl Amt | Signed 18.2
|
|
MAD-MATCH-EXT-COST Element: Intl Cost | Signed 18.5 THis is the extended cost of the line
updated at match
|
|
MAD-AGREEMENT-REF Element: Agreement Ref | Alpha 30 This is for contracts(agreements) coming
from the PO system. Used to denote
message with contract associated.
|
|
MAD-INVC-TAX-AMT Element: Intl Amt | Signed 18.2
|
|
MAD-ACCR-TAX-AMT Element: Intl Amt | Signed 18.2
|
|
MAD-COMMODITY-CODE Element: Commodity Code | Alpha 35
|
|
MAD-RET-PCT Element: Pct | Percent 5.2 (Percent)
|
|
MAD-PVN-OBJ-ID Element: Obj Id | Numeric 12
|
|
MAD-TAXBL-UNT-CST Element: Intl Cost | Signed 18.5
|
|
MAD-PROD-TAX-CAT Element: Prod Tax Cat | Alpha 15
|
|
MAD-GTIN Element: Gtin | Numeric 14
|
|
MAD-EAM-OPER-NBR Element: Operation Nbr | Numeric 4
|
|
MAD-EAM-SEQ-NBR Element: Seq Nbr | Numeric 4
|
|
MAD-EAM-WO-NBR Element: Work Order | Numeric 8
|
|
MAD-CREATED-BY Element: Operator | Alpha 10
|
|
MAD-LAST-UPDT-DATE Element: Date | Numeric 8 (yyyymmdd)
|
|
MAD-LAST-UPDT-TIME Element: Time | Numeric 8
|
|
MAD-LAST-UPDATE-BY Element: Operator | Alpha 10
|
|
MAD-GLBL-LINE-TYPE Element: Glbl Line Type | Alpha 15
|
|
MAD-COST-OPTION Element: Cost Option | Alpha 1
" " = Default from PO line 1 = Cost Required 2 = No Charge 3 = Vendor Determined |
|