Lawson Insight Technical Documentation |
|
MAINVDTL
MAINVDTL FILE
Matching Invoice Detail
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.
REFERENCED BY
AP295 MA126 MA167 MA236 MA310 MA540
MA69.1 MA69.2 MA69.3 MA69.4 MA69.5 MA69.6
MA90.1 MA90.2 MA90.3 MA90.5 PO136 PO278
POA3.1 MM280 MM80.1 MM80.2 MA278 PO135
PO139 PO64.1 PO295 POD0.1 MA168 PO58.2
UPDATED BY
AM19.1 AM19.2 AP115 AP125 AP126 AP131
AP180 AP181 AP190 AP195 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.4
MA60.5 MA61.1 MA63.1 MA64.6 MA65.1 MA66.2
MA66.3 MA67.2 MA67.3 MA68.2 MA68.3 MA68.4
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 AP198
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAD-COMPANY Numeric 4 AM19.1 AM19.2
Element: Company Identifies the AP company if the AP115 AP125
resource type = V. Identifies the HR AP126 AP131
company if the resource type = E. It is AP180 AP181
blank for type A, P or Q resources. AP190 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
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
...
MAD-VENDOR Alpha 9 (Right Justified) AM19.1 AM19.2
Element: Vendor The vendor's identification code. AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-INVOICE Alpha 22 AM19.1 AM19.2
Element: Invoice Used to identify the invoice. AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-SUFFIX Numeric 3 AM19.1 AM19.2
Element: Suffix This is the suffix for the invoice. AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-PO-NUMBER Alpha 14 (Right Justified) AM19.1 AM19.2
Element: Po Number This field contains the number AP115 AP125
representing the purchase order. AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-PO-RELEASE Numeric 4 AM19.1 AM19.2
Element: Po Release Used to identify a purchase order AP115 AP125
release (created from a Blanket or AP126 AP131
Standing order). AP180 AP181
AP190 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
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
...
MAD-PO-CODE Alpha 4 AM19.1 AM19.2
Element: Purchase OrderPurchase order number code. Used to AP115 AP125
keep purchase orders unique. Can also be AP126 AP131
used for reporting purposes. AP180 AP181
AP190 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
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
...
MAD-LINE-NBR Numeric 6 AM19.1 AM19.2
Element: Line Nbr This field contains the line number. AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
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 MA236
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
...
MAD-SEQ-NBR Numeric 4 AM19.1 AM19.2
Element: Seq Nbr An automatically assigned sequence AP115 AP125
number. AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-ITEM-TYPE Alpha 1 AM19.1 AM19.2
Element: Item Type This field identifies the line item AP115 AP125
type. AP126 AP131
AP180 AP181
I = Inventoried AP190 AP20.1
N = Non-stock AP20.2 AP20.3
S = Service AP20.4 AP20.5
X = Special AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
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
...
MAD-ITEM Alpha 32 AM19.1 AM19.2
Element: Item This field contains the item AP115 AP125
identifier. AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-VEN-ITEM Alpha 32 AM19.1 AM19.2
Element: Item This field contains the item AP115 AP125
identifier. AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-ITEM-DESC Alpha 30 (Lower Case) AM19.1 AM19.2
Element: Description This field displays the description. AP115 AP125
AP126 AP131
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 MA68.2
...
MAD-MATCHED-QTY Signed 13.4 AM19.1 AM19.2
Element: Matched QuantiThe quantity of items that have been AP115 AP125
matched. AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-MATCH-UNIT-CST Signed 18.5 AM19.1 AM19.2
Element: Intl Cost THis unit cost is updated at match AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-VPRI-UOM Alpha 4 AM19.1 AM19.2
Element: Uom This field contains the valid stock AP115 AP125
unit of measure for this item. AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-VPRI-UOM-MULT Signed 13.7 AM19.1 AM19.2
Element: Uom Mult This field contains the multiplier for AP115 AP125
converting this unit of measure to the AP126 AP131
stock unit of measure. AP180 AP181
AP190 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
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
...
MAD-ENTERED-QTY Signed 13.4 AM19.1 AM19.2
Element: Quantity THis is the VBUY quantity AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-ENT-UNIT-CST Signed 18.5 AM19.1 AM19.2
Element: Intl Cost The entered unit cost in vendor price AP115 AP125
unit of measure terms. This value may AP126 AP131
be entered on line or calculated from AP180 AP181
entry of cost in buy unit of measure AP190 AP20.1
terms. 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
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
...
MAD-TAX-CODE Alpha 10 AM19.1 AM19.2
Element: Tax Code This field contains a code representing AP115 AP125
specific tax information. This must be AP126 AP131
valid Tax Code. AP180 AP181
AP190 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
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
...
MAD-TAX-TYPE Alpha 1 AM19.1 AM19.2
Element: Tax Type The type of tax. AP115 AP125
AP126 AP131
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 MA68.2
...
MAD-TAX-AMOUNT Signed 18.2 AM19.1 AM19.2
Element: Intl Amt The tax amount for the invoice. AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-VBUY-MATCH-QTY Signed 13.4 AM19.1 AM19.2
Element: Matched QuantiThe quantity of items that have been AP115 AP125
matched in VBUY measure terms. AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-VBUY-UOM Alpha 4 AM19.1 AM19.2
Element: Uom This field contains the valid stock AP115 AP125
unit of measure for this item. AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-VBUY-UOM-MULT Signed 13.7 AM19.1 AM19.2
Element: Uom Mult This field contains the multiplier for AP115 AP125
converting this unit of measure to the AP126 AP131
stock unit of measure. AP180 AP181
AP190 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
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
...
MAD-NO-TAX-FLAG Alpha 1 AM19.1 AM19.2
Element: Taxable InvoicIndicates if the invoice is taxable. AP115 AP125
N = No AP126 AP131
Y = Yes AP180 AP181
AP190 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
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
...
MAD-MATCH-CLASS Alpha 10 AM19.1 AM19.2
Element: Match Class Match class. A user-defined matching AP115 AP125
key structure consisting of matching AP126 AP131
elements. AP180 AP181
AP190 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
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
...
MAD-MATCH-DTL-KEY Alpha 85 AM19.1 AM19.2
Element: Match Detail KMatch detail key. Combines all Matching AP115 AP125
Elements into a single element. AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-RTL-UNIT-COST Signed 18.5 AM19.1 AM19.2
Element: Retail Unit CoThe retail unit cost of the item. AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-LOCATION Alpha 5 AM19.1 AM19.2
Element: Location This field contains a valid stocking AP115 AP125
location within the company inventory. AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-MATCH-OBJ-ID Numeric 12 AM19.1 AM19.2
Element: Matching ObjecA system generated matching object AP115 AP125
identifier. AP126 AP131
AP180 AP181
AP190 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
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.4
MA60.5 MA61.1
...
MAD-ENT-UOM Alpha 4 AM19.1 AM19.2
Entered Unit of Entered unit of measure. AP115 AP125
Measure AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-ENT-UOM-MULT Signed 13.7 AM19.1 AM19.2
Element: Uom Mult This field contains the multiplier for AP115 AP125
converting this unit of measure to the AP126 AP131
stock unit of measure. AP180 AP181
AP190 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
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
...
MAD-TRAN-ND Numeric 1 AM19.1 AM19.2
Element: Acct Nd The number of decimals assigned to a AP115 AP125
particular account as determined by the AP126 AP131
account currency. AP180 AP181
AP190 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
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
...
MAD-REC-SOURCE Alpha 2 AM19.1 AM19.2
Element: Record Source Indicates where the detail record was AP115 AP125
created. AP126 AP131
AP180 AP181
Valid values are: AP190 AP20.1
AP20.2 AP20.3
IN = Invoice AP20.4 AP20.5
" " = PO Entry AP20.7 AP21.1
LM = Line Match (MA43) AP220 AP23.1
IM = internal match details AP25.1 AP25.2
IS = Created by AOC spread from PO AP26.1 AP27.1
" " = PO Entry AP28.1 AP28.2
MA = Created within match AP30.2 AP30.4
MS = Generated by AOC spread 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
...
MAD-TOT-DIST-AMT Signed 18.2 AM19.1 AM19.2
Total Distribution The total amount of the distribution. AP115 AP125
Amount AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-TOT-BASE-AMT Signed 18.2 AM19.1 AM19.2
Element: Total Base Amount AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-STATUS Numeric 1 AM19.1 AM19.2
Element: Status The transaction status. AP115 AP125
AP126 AP131
Valid values are: AP180 AP181
AP190 AP20.1
0 = Unmatched AP20.2 AP20.3
1 = Matched 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
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
...
MAD-API-OBJ-ID Numeric 12 AM19.1 AM19.2
Element: API Object ID A subsystem object interface AP115 AP125
identification number. AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-MA-REC-NBR Numeric 10 AM19.1 AM19.2
Element: Receipt NumberThe receipt number an invoice detail was AP115 AP125
matched to in a detail match. AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-MA-LINE-NBR Numeric 6 AM19.1 AM19.2
Element: Receipt Line NReceipt line number. AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-MATCH-SEQ-NBR Numeric 4 AM19.1 AM19.2
Matching Sequence Matching sequence number. Used to keep AP115 AP125
Number records unique. AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-MTCH-EXC-PROC Numeric 1 AM19.1 AM19.2
Element: Mtch Exc Proc 0 = No excess quantity AP115 AP125
1 = Chargeback AP126 AP131
2 = Write off AP180 AP181
3 = Matched no rec AP190 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
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
...
MAD-INVOICE-TYPE Alpha 1 AM19.1 AM19.2
Element: Invoice Type THis field will be filled in from the AP115 AP125
Invoice based on PO number. This is a AP126 AP131
carrier for the field. The PORECEIVE AP180 AP181
file will have to be updated with this AP190 AP20.1
field. AP20.2 AP20.3
C = Credit Memo AP20.4 AP20.5
" " = Regular AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
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
...
MAD-DISTRIB-DATE Numeric 8 (yyyymmdd) AM19.1 AM19.2
Element: Date This field displays the system date AP115 AP125
when this was created. AP126 AP131
AP180 AP181
AP190 AP195
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 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
...
MAD-UPDATE-DATE Numeric 8 (yyyymmdd) AM19.1 AM19.2
Element: Update Date This field contains the date the record AP115 AP125
was updated. AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-UPDATE-TIME Numeric 6 AM19.1 AM19.2
Element: Update Time This field contains the system time AP115 AP125
when the record was updated. AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-TAX-USAGE-CD Alpha 10 AM19.1 AM19.2
Element: Tax Usage Cd The tax usage coe for the vendor. This AP115 AP125
filed is required if the AP Company AP126 AP131
inidcates that VAT reporting required. AP180 AP181
AP190 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
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
...
MAD-LAST-MSG-SEQ Numeric 6 AM19.1 AM19.2
Element: Seq Number A unique number assigned to each AP115 AP125
transaction to be interfaced into the AP126 AP131
Lawson system. 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
MA64.6 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
...
MAD-ICN-CODE Alpha 8 AM19.1 AM19.2
Element: Icn Code AP115 AP125
AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-SUPLMNTARY-QTY Signed 13.4 AM19.1 AM19.2
Element: Quantity This field contains the desired AP115 AP125
quantity. AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-SUPLMNTARY-UOM Alpha 4 AM19.1 AM19.2
Element: Uom This field contains the valid stock AP115 AP125
unit of measure for this item. AP126 AP131
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 MA68.2
...
MAD-WEIGHT Signed 9.3 AM19.1 AM19.2
Element: Weight This field contains the unit weight of AP115 AP125
the item based on the stocking UOM. AP126 AP131
AP180 AP181
AP190 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
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
...
MAD-TERMS-CD Alpha 5
Element: Terms Cd
MAD-DISC-RATE Percent 5.3 (Percent)
Element: Disc Rate
MAD-DISC-DATE Numeric 8 (yyyymmdd)
Element: Disc Date
MAD-FLEX-FLAG Alpha 1
Element: Flex Flag Terms has been overriden with a flexible
term
MAD-PREPAY-QTY Signed 13.4
Element: Prepay Qty For prepayment invoices this quantity
will be used
MAD-PRPY-UNIT-CST Signed 18.5
Element: Intl Cost For prepayment invoice this unit cost
will be used
MAD-PRPY-TAX-CODE Alpha 10
Element: Prpy Tax Code For prepayment invoices this tax code
will be used
MAD-PRPY-TAX-AMT Signed 18.2
Element: Intl Amt FOr prepayment invoice this tax amount
will be used.
MAD-PRPY-RTL-UCST Signed 18.5
Element: Intl Cost
MAD-PREPAY-DATE Numeric 8 (yyyymmdd)
Element: Prepay Date
MAD-MATCH-ERR-TYPE Numeric 2
Element: Match Err TypeThis is the reason the match was not
successful.
01 = cost error
02 = quantity error
03 = item error
MAD-CATCH-WGT-COST Signed 18.5
Element: Intl Cost
MAD-REASON-CODE Alpha 4 AM19.1 AM19.2
Element: Reason Code This field contains the reason code, AP115 AP125
which indicates the cause for credit AP126 AP131
memos. 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 MA68.2
...
MAD-CHARGEBACK-FL Alpha 1
Element: Chargeback Fl THis flag notes that there is a
chargeback associated with this invoice
line.
0 = no
1 = yes
MAD-IR-DIFF-AMT Signed 18.2
Element: Intl Amt
MAD-MATCH-EXT-COST Signed 18.5
Element: Intl Cost THis is the extended cost of the line
updated at match
MAD-AGREEMENT-REF Alpha 30 MA43.1 MA43.4
Element: Agreement Ref This is for contracts(agreements) coming MA43.6
from the PO system. Used to denote
message with contract associated.
MAD-INVC-TAX-AMT Signed 18.2 AM19.1 AM19.2
Element: Intl Amt AP115 AP125
AP126 AP131
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 MA68.2
...
MAD-ACCR-TAX-AMT Signed 18.2 AM19.1 AM19.2
Element: Intl Amt AP115 AP125
AP126 AP131
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 MA68.2
...
MAD-COMMODITY-CODE Alpha 35 API1.1 MA43.1
Element: Commodity Code POI3.1
MAINVDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MADSET1 COMPANY AM19.1 AM19.2
VENDOR AP115 AP125
INVOICE AP126 AP131
SUFFIX AP195 AP198
PO-NUMBER AP20.1 AP20.2
PO-RELEASE AP20.3 AP20.4
PO-CODE AP20.5 AP20.7
LINE-NBR AP21.1 AP220
SEQ-NBR AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP295
AP30.2 AP30.4
AP300 AP305
API1.1 API2.1
BL120 BL122
...
MADSET10 COMPANY KeyChange, Subset AP30.4 MA278
PO-NUMBER Where STATUS = 1 MA70.1 MA75.1
PO-RELEASE PO135 PO139
PO-CODE PO64.1
LINE-NBR
UPDATE-DATE*
UPDATE-TIME*
VENDOR
INVOICE
SUFFIX
SEQ-NBR
MADSET2 COMPANY KeyChange AM19.1 AM19.2
PO-NUMBER AP115 AP125
PO-RELEASE AP126 AP131
PO-CODE AP20.1 AP20.2
LINE-NBR AP20.3 AP20.4
VENDOR AP20.5 AP20.7
INVOICE AP21.1 AP220
SUFFIX AP23.1 AP25.1
SEQ-NBR AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
...
MADSET3 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
MATCH-DTL-KEY AP20.5 AP20.7
SEQ-NBR 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
...
MADSET4 COMPANY KeyChange AM19.1 AM19.2
VENDOR AP115 AP125
INVOICE AP126 AP131
SUFFIX AP20.1 AP20.2
PO-NUMBER AP20.3 AP20.4
PO-RELEASE AP20.5 AP20.7
PO-CODE AP21.1 AP220
ITEM AP23.1 AP25.1
SEQ-NBR AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
...
MADSET8 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
SEQ-NBR AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
...
MADSET9 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
SEQ-NBR AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
...
MAINVDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apbatch APBATCH Not Required
MAD-COMPANY -> APB-COMPANY
API-BATCH-NUM -> APB-BATCH-NUM
Apcompany APCOMPANY Required
MAD-COMPANY -> CPY-COMPANY
Apinvoice APINVOICE Required
MAD-COMPANY -> API-COMPANY
MAD-VENDOR -> API-VENDOR
MAD-INVOICE -> API-INVOICE
MAD-SUFFIX -> API-SUFFIX
Zeroes -> API-CANCEL-SEQ
Iccompany ICCOMPANY Required
MAD-COMPANY -> ICC-COMPANY
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
MAD-COMPANY -> MAY-COMPANY
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
MAD-COMPANY -> PCY-COMPANY
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
MAINVDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apvendiv APVENDIV
CPY-VENDOR-GROUP -> VDC-VENDOR-GROUP
MAD-VENDOR -> VDC-VENDOR
API-LOCATION -> VDC-LOCATION-CODE
VDC-DIVERSE-CODE
VDC-DCERT-DATE
Maaocdtl MAAOCDTL
MAD-COMPANY -> MAA-COMPANY
MAD-VENDOR -> MAA-VENDOR
MAD-INVOICE -> MAA-INVOICE
MAD-SUFFIX -> MAA-SUFFIX
MAD-PO-NUMBER -> MAA-PO-NUMBER
MAD-PO-RELEASE -> MAA-PO-RELEASE
MAD-PO-CODE -> MAA-PO-CODE
MAD-LINE-NBR -> MAA-LINE-NBR
MAA-AOC-CODE
MAA-SEQ-NBR
Mainvmsg MAINVMSG
MAD-COMPANY -> MAG-COMPANY
MAD-VENDOR -> MAG-VENDOR
MAD-INVOICE -> MAG-INVOICE
MAD-SUFFIX -> MAG-SUFFIX
Zeroes -> MAG-CANCEL-SEQ
MAD-SEQ-NBR -> MAG-MAD-SEQ-NBR
MAG-SEQ-NBR
Mmdist MMDIST
Valid When MAD-ITEM-TYPE != "I"
MAD-COMPANY -> MMD-COMPANY
"PO" -> MMD-SYSTEM-CD
MAD-LOCATION -> MMD-LOCATION
"PT" -> MMD-DOC-TYPE
MAD-PO-NUMBER -> MMD-DOC-NUMBER
MAD-PO-RELEASE -> MMD-DOC-NBR-NUM
MAD-PO-CODE -> MMD-PO-CODE
MAD-LINE-NBR -> MMD-LINE-NBR
Zeroes -> MMD-COMPONENT-SEQ
Spaces -> MMD-AOC-CODE
MMD-LINE-SEQ
MMD-REQ-LOCATION
MMD-API-OBJ-ID
Porecline PORECLINE
MAD-COMPANY -> PRL-COMPANY
MAD-PO-CODE -> PRL-PO-CODE
MAD-PO-NUMBER -> PRL-PO-NUMBER
MAD-PO-RELEASE -> PRL-PO-RELEASE
MAD-LOCATION -> PRL-LOCATION
MAD-MATCH-DTL-KEY -> PRL-MATCH-DTL-KEY
PRL-PO-LINE-NBR
PRL-REC-NUMBER
PRL-LINE-NBR
|