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
|
|
RELATION
NAME |
RELATED FILE |
INTEGRITY RULES / FIELD MATCH |
| Apbatch |
APBATCH |
Not Required
| MAD-COMPANY | -> | APB-COMPANY |
| API-BATCH-NUM | -> | APB-BATCH-NUM |
|
| Apcompany |
APCOMPANY |
Required
|
| Apinvoice |
APINVOICE |
Required
| MAD-COMPANY | -> | API-COMPANY |
| MAD-VENDOR | -> | API-VENDOR |
| MAD-INVOICE | -> | API-INVOICE |
| MAD-SUFFIX | -> | API-SUFFIX |
| Zeroes | -> | API-CANCEL-SEQ |
|
| Apvenmast |
APVENMAST |
Required
| CPY-VENDOR-GROUP | -> | VEN-VENDOR-GROUP |
| MAD-VENDOR | -> | VEN-VENDOR |
|
| Commcodes |
COMMCODES |
Required
| ICC-ITEM-GROUP | -> | ISC-ITEM-GROUP |
| MAD-COMMODITY-CODE | -> | ISC-COMMODITY-CODE |
|
| Iccompany |
ICCOMPANY |
Required
|
| Icitemgtin |
ICITEMGTIN |
Required
| ICC-ITEM-GROUP | -> | GTI-ITEM-GROUP |
| MAD-ITEM | -> | GTI-ITEM |
| MAD-GTIN | -> | GTI-GTIN |
|
| Itemloc |
ITEMLOC |
Required
| MAD-COMPANY | -> | ITL-COMPANY |
| MAD-LOCATION | -> | ITL-LOCATION |
| MAD-ITEM | -> | ITL-ITEM |
|
| Itemmast |
ITEMMAST |
Required
| When | | MAD-ITEM-TYPE | = | "I" | |
| Or | | MAD-ITEM-TYPE | = | "N" | |
| ICC-ITEM-GROUP | -> | ITE-ITEM-GROUP |
| MAD-ITEM | -> | ITE-ITEM |
|
| Location |
ICLOCATION |
Required
| MAD-COMPANY | -> | ICL-COMPANY |
| MAD-LOCATION | -> | ICL-LOCATION |
|
| Macompany |
MACOMPANY |
Required
|
| Mapoinv |
MAPOINV |
Not Required
| MAD-COMPANY | -> | AOI-COMPANY |
| MAD-PO-NUMBER | -> | AOI-PO-NUMBER |
| MAD-PO-RELEASE | -> | AOI-PO-RELEASE |
| MAD-PO-CODE | -> | AOI-PO-CODE |
| MAD-VENDOR | -> | AOI-VENDOR |
| MAD-INVOICE | -> | AOI-INVOICE |
| MAD-SUFFIX | -> | AOI-SUFFIX |
|
| Mmuaval |
MMUAVAL |
Required
| MAD-COMPANY | -> | MUA-COMPANY |
| "AP" | -> | MUA-SYSTEM-CD |
| MAD-LOCATION | -> | MUA-LOCATION |
| "IN" | -> | MUA-DOC-TYPE |
| Spaces | -> | MUA-DOC-NUMBER |
| Zeroes | -> | MUA-DOC-NBR-NUM |
| Spaces | -> | MUA-PO-CODE |
| MAD-LINE-NBR | -> | MUA-LINE-NBR |
| MAD-API-OBJ-ID | -> | MUA-API-OBJ-ID |
| MAD-SEQ-NBR | -> | MUA-SEQ-NBR |
|
| Pocompany |
POCOMPANY |
Required
|
| Poitemven |
POITEMVEN |
Required
| PCY-PROCURE-GROUP | -> | PIV-PROCURE-GROUP |
| MAD-VENDOR | -> | PIV-VENDOR |
| MAD-ITEM | -> | PIV-ITEM |
| MAD-VEN-ITEM | -> | PIV-VEN-ITEM |
|
| Poline |
POLINE |
Not Required
| MAD-COMPANY | -> | PLI-COMPANY |
| MAD-PO-NUMBER | -> | PLI-PO-NUMBER |
| MAD-PO-RELEASE | -> | PLI-PO-RELEASE |
| MAD-PO-CODE | -> | PLI-PO-CODE |
| MAD-LINE-NBR | -> | PLI-LINE-NBR |
|
| Purchorder |
PURCHORDER |
Required
| MAD-COMPANY | -> | PCR-COMPANY |
| MAD-PO-CODE | -> | PCR-PO-CODE |
| MAD-PO-NUMBER | -> | PCR-PO-NUMBER |
| MAD-PO-RELEASE | -> | PCR-PO-RELEASE |
|
| Vendor |
APVENMAST |
Required
| CPY-VENDOR-GROUP | -> | VEN-VENDOR-GROUP |
| MAD-VENDOR | -> | VEN-VENDOR |
|
