MAINVDTL

Invoice Line 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
AP133 AP295 AP33.1 API5.1 MA236 MA26.1
MA540 PO278 POA3.1 MM280 MM80.1 MM80.2
PO139 PO64.1 AP97.1 AP97.2 PO295 POD0.1
MA168 MAED.1 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 AP305 AP45.1 AP510
API1.1 API2.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC12.1 IC140 IC141 IC142 IC145
IC243 IC330 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC83.1 MA126 MA180 MA278 MA41.1 MA41.2
MA41.4 MA41.7 MA42.1 MA42.2 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA44.1 MA44.2
MA53.1 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 MA67.1 MA68.2 MA68.3
MA68.4 MA68.5 MA69.1 MA70.1 MA75.1 MA80.1
MAI1.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PD570 PO04.1 PO04.2 PO10.1 PO10.2
PO100 PO101 PO115 PO120 PO122 PO131
PO132 PO136 PO15.1 PO15.2 PO15.4 PO150
PO17.1 PO190 PO20.1 PO20.6 PO20.9 PO204
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.3 PO22.4 PO220 PO222 PO224 PO225
PO229 PO23.1 PO230 PO234 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO251 PO26.3 PO26.7
PO26.9 PO27.2 PO27.3 PO27.4 PO275 PO276
PO277 PO28.2 PO280 PO29.1 PO30.1 PO30.2
PO30.3 PO30.4 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 PO54.5 POCP.1 POI3.1 POID.1
POII.1 POIJ.1 RQ01.1 RQ10.1 RQ10.2 RQ10.3
RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1
RQII.1 RQIJ.1 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830 AP198 AP300 MA167 MA90.2 MA90.3
MA90.5 MA90.6 PO135 POIF.1 POIG.1

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.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-SUFFIX
Element: Suffix
Numeric 3
This is the suffix for the invoice.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-PO-NUMBER
Element: Po Number
Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-PO-RELEASE
Element: Po Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
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.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-ITEM-TYPE
Element: Item Type
Alpha 1
This field identifies the line item type.
I = Inventoried
N = Non-stock
S = Service
X = Special
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-VEN-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-ITEM-DESC
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA126 MA180
MA278 MA41.1
MA41.2 MA41.4
MAD-MATCHED-QTY
Element: Matched Quantity
Signed 13.4
The quantity of items that have been matched.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-MATCH-UNIT-CST
Element: Intl Cost
Signed 18.5
THis unit cost is updated at match
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-VPRI-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
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.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-ENTERED-QTY
Element: Quantity
Signed 13.4
THis is the VBUY quantity
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
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.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-TAX-TYPE
Element: Tax Type
Alpha 1
The type of tax.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA126 MA180
MA278 MA41.1
MA41.2 MA41.4
MAD-TAX-AMOUNT
Element: Intl Amt
Signed 18.2
The tax amount for the invoice.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-VBUY-MATCH-QTY
Element: Matched Quantity
Signed 13.4
The quantity of items that have been matched in VBUY measure terms.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-VBUY-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
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.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-NO-TAX-FLAG
Element: Taxable Invoice Flag
Alpha 1
Indicates if the invoice is taxable.
N = No
Y = Yes
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-MATCH-CLASS
Element: Match Class
Alpha 10
Match class. A user-defined matching key structure consisting of matching elements.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-MATCH-DTL-KEY
Element: Match Detail Key
Alpha 85
Match detail key. Combines all Matching Elements into a single element.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-RTL-UNIT-COST
Element: Retail Unit Cost
Signed 18.5
The retail unit cost of the item.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-MATCH-OBJ-ID
Element: Matching Object ID
Numeric 12
A system generated matching object identifier.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-ENT-UOM
Entered Unit of
Measure
Alpha 4
Entered unit of measure.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
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.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-TRAN-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
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
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-TOT-DIST-AMT
Total Distribution
Amount
Signed 18.2
The total amount of the distribution.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-TOT-BASE-AMT
Element: Total Base Amount
Signed 18.2
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-STATUS
Element: Status
Numeric 1
The transaction status. Valid values are: 0 = Unmatched 1 = Matched
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-API-OBJ-ID
Element: API Object ID
Numeric 12
A subsystem object interface identification number.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-MA-REC-NBR
Element: Receipt Number
Numeric 10
The receipt number an invoice detail was matched to in a detail match.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-MA-LINE-NBR
Element: Receipt Line Number
Numeric 6
Receipt line number.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-MATCH-SEQ-NBR
Matching Sequence
Number
Numeric 4
Matching sequence number. Used to keep records unique.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-MTCH-EXC-PROC
Element: Mtch Exc Proc
Numeric 1

0 = No excess quantity
1 = Chargeback
2 = Write off
3 = Matched no rec
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
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
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-DISTRIB-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
...
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 AP305
AP45.1 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
MAD-UPDATE-DATE
Element: Update Date
Numeric 8 (yyyymmdd)
This field contains the date the record was updated.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-UPDATE-TIME
Element: Update Time
Numeric 6
This field contains the system time when the record was updated.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
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.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-LAST-MSG-SEQ
Element: Seq Number
Numeric 6
A unique number assigned to each transaction to be interfaced into the Lawson system.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA126 MA180
MA278 MA41.1
MA41.2 MA41.4
MAD-ICN-CODE
Element: Icn Code
Alpha 8
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-SUPLMNTARY-QTY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-SUPLMNTARY-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA126 MA180
MA278 MA41.1
MA41.2 MA41.4
MAD-WEIGHT
Element: Weight
Signed 9.3
This field contains the unit weight of the item based on the stocking UOM.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
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.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA126 MA180
MA278 MA41.1
MA41.2 MA41.4
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.
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA126 MA180
MA278 MA41.1
MA41.2 MA41.4
MAD-INVC-TAX-AMT
Element: Intl Amt
Signed 18.2
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA126 MA180
MA278 MA41.1
MA41.2 MA41.4
MAD-ACCR-TAX-AMT
Element: Intl Amt
Signed 18.2
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA126 MA180
MA278 MA41.1
MA41.2 MA41.4
MAD-COMMODITY-CODE
Element: Commodity Code
Alpha 35
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA126 MA180
MA278 MA41.1
MA41.2 MA41.4
MAD-RET-PCT
Element: Pct
Percent 5.2 (Percent)
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA126 MA180
MA278 MA41.1
MA41.2 MA41.4
MAD-PVN-OBJ-ID
Element: Obj Id
Numeric 12
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA126 MA180
MA278 MA41.1
MA41.2 MA41.4
MAD-TAXBL-UNT-CST
Element: Intl Cost
Signed 18.5
MAD-PROD-TAX-CAT
Element: Prod Tax Cat
Alpha 15
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA126 MA180
MA278 MA41.1
MA41.2 MA41.4
MAD-GTIN
Element: Gtin
Numeric 14
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
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
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MAD-LAST-UPDT-DATE
Element: Date
Numeric 8 (yyyymmdd)
...
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 AP305
AP45.1 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
MAD-LAST-UPDT-TIME
Element: Time
Numeric 8
...
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 AP305
AP45.1 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
MAD-LAST-UPDATE-BY
Element: Operator
Alpha 10
...
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 AP305
AP45.1 AP510
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
MAD-GLBL-LINE-TYPE
Element: Glbl Line Type
Alpha 15
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC140
IC141 IC142
IC145 IC243
IC330 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC83.1
MA126 MA180
MA278 MA41.1
MA41.2 MA41.4
MAD-COST-OPTION
Element: Cost Option
Alpha 1

" " = Default from PO line
1 = Cost Required
2 = No Charge
3 = Vendor Determined


MAINVDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MADSET1 COMPANY
VENDOR
INVOICE
SUFFIX
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
SEQ-NBR
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP133 AP195
AP198 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
AP295 AP30.2
AP30.4 AP300
AP305 AP33.1
AP510 API1.1
MADSET10 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
UPDATE-DATE*
UPDATE-TIME*
VENDOR
INVOICE
SUFFIX
SEQ-NBR
KeyChange, Subset
WhereSTATUS =1
AP30.4 MA278
MA70.1 MA75.1
PO135 PO139
PO222 PO64.1
MADSET11 COMPANY
DISTRIB-DATE
UPDATE-DATE
UPDATE-TIME
LAST-UPDT-DATE
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
VENDOR
INVOICE
SUFFIX
SEQ-NBR
KeyChange
MADSET2 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
VENDOR
INVOICE
SUFFIX
SEQ-NBR
KeyChange
...
AM19.1 AM19.2
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
AP510 AP97.1
AP97.2 API1.1
API2.1 CX100
CX20.1 CX20.2
MADSET3 COMPANY
API-OBJ-ID
PO-NUMBER
PO-RELEASE
PO-CODE
MATCH-DTL-KEY
LINE-NBR
SEQ-NBR
KeyChange
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
MADSET4 COMPANY
VENDOR
INVOICE
SUFFIX
PO-NUMBER
PO-RELEASE
PO-CODE
ITEM
LINE-NBR
SEQ-NBR
KeyChange
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
MADSET5 PVN-OBJ-ID
MATCH-OBJ-ID
COMPANY
VENDOR
INVOICE
SUFFIX
SEQ-NBR
Subset
WherePVN-OBJ-ID !=Zeroes
MADSET8 COMPANY
API-OBJ-ID
PO-NUMBER
PO-RELEASE
PO-CODE
LOCATION
MATCH-DTL-KEY
LINE-NBR
SEQ-NBR
KeyChange
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
MADSET9 COMPANY
MATCH-OBJ-ID
MATCH-SEQ-NBR
VENDOR
INVOICE
SUFFIX
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
SEQ-NBR
KeyChange, Subset
WhereINVOICE-TYPE =Spaces
...
AM19.1 AM19.2
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5


MAINVDTL FILE RELATIONS


ONE TO ONE RELATIONS

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
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
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
MAD-COMPANY->ICC-COMPANY
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"
OrMAD-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
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


MAINVDTL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apdistpay APDISTPAY
MAD-COMPANY->DTY-COMPANY
MAD-PO-NUMBER->DTY-PO-NUMBER
MAD-PO-RELEASE->DTY-PO-RELEASE
MAD-PO-CODE->DTY-PO-CODE
MAD-LINE-NBR->DTY-LINE-NBR
MAD-SEQ-NBR->DTY-MAD-SEQ-NBR
MAD-VENDOR->DTY-VENDOR
MAD-INVOICE->DTY-INVOICE
MAD-SUFFIX->DTY-SUFFIX
  DTY-PMT-SEQ-NBR
  DTY-DIST-SEQ-NBR
Apdistpay 1 APDISTPAY
MAD-VENDOR->DTY-VENDOR
MAD-AGREEMENT-REF->DTY-VEN-AGRMT-REF
MAD-PVN-OBJ-ID->DTY-PVN-OBJ-ID
  DTY-COMPANY
  DTY-PO-NUMBER
  DTY-PO-RELEASE
  DTY-PO-CODE
  DTY-INVOICE
  DTY-SUFFIX
  DTY-PMT-SEQ-NBR
  DTY-LINE-NBR
  DTY-MAD-SEQ-NBR
  DTY-DIST-SEQ-NBR
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
Mmdistfive MMDIST
Valid When MMD- =MAD-
MAD-COMPANY->MMD-COMPANY
MAD-API-OBJ-ID->MMD-API-OBJ-ID
MAD-LINE-NBR->MMD-LINE-NBR
  MMD-AOC-CODE
  MMD-LINE-SEQ
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


File created: Thu Jun 09 02:22:52 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.