 |
Lawson Insight Technical Documentation |
|
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
MA310 MA67.1 MA67.2 POA3.1 MA278 PO135
PO64.1 IC28.1 MA180 MA530 MA531 PO100
PO101 PO122 PO131 PO20.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO29.1 PO295
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.2 PO33.1 PO34.1 PO35.1 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 POIE.1
POII.1 POIJ.1 RQ10.1 RQ10.2 WH20.2 WH20.7
PO25.2 PO25.6 PO25.7 PO25.8
UPDATED BY
AP115 AP125 AP126 AP131 AP180 AP181
AP190 AP198 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 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 MA126 MA41.1
MA41.2 MA41.4 MA43.1 MA43.2 MA43.3 MA43.4
MA43.5 MA43.7 MA43.8 MA60.2 MA60.3 MA60.4
MA61.1 MA63.1 MA64.6 MA65.1 MA66.2 MA66.3
MA68.1 MA70.1 MAI1.1 POI3.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAD-COMPANY Numeric 4 AP115 AP125
Company The company number represents an AP126 AP131
established company and is entered on AP180 AP181
all function codes. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-VENDOR Alpha 9 (Right Justified) AP115 AP125
Vendor ID The vendor's identification code. AP126 AP131
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-INVOICE Alpha 22 AP115 AP125
Invoice Number Used to identify the invoice. AP126 AP131
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-SUFFIX Numeric 3 AP115 AP125
Invoice Suffix This is the suffix for the invoice. AP126 AP131
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-PO-NUMBER Alpha 14 (Right Justified) AP115 AP125
PO Number This field contains the number AP126 AP131
representing the purchase order. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-PO-RELEASE Numeric 4 AP115 AP125
PO Release Number Used to identify a purchase order AP126 AP131
release (created from a Blanket or AP180 AP181
Standing order). AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-PO-CODE Alpha 4 AP115 AP125
Purchase Order Code Purchase order number code. Used to AP126 AP131
keep purchase orders unique. Can also be AP180 AP181
used for reporting purposes. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-LINE-NBR Numeric 6 AP115 AP125
Line Number This field contains the line number. AP126 AP131
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-AOC-CODE Alpha 2 AP115 AP125
Add On Cost Code This field contains the identifier for AP126 AP131
the add on cost associated with this AP180 AP181
line item. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-SEQ-NBR Numeric 4 AP115 AP125
Sequence Number An automatically assigned sequence AP126 AP131
number. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-ITEM-TYPE Alpha 1 AP115 AP125
Item Type This field identifies the line item AP126 AP131
type. AP180 AP181
I = Inventoried AP190 AP20.1
N = Non-stock AP20.2 AP20.3
S = Service AP20.4 AP20.5
X = Special AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-ITEM Alpha 32 AP115 AP125
Item Number This field contains the item AP126 AP131
identifier. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-VEN-ITEM Alpha 32 AP115 AP125
Vendor Item The vendor's item identifer. AP126 AP131
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-MATCHED-QTY Signed 13.4 AP115 AP125
Matched Quantity The quantity of items that have been AP126 AP131
matched. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-MATCH-UNIT-CST Signed 13.5 AP115 AP125
Match Unit Cst AP126 AP131
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-VPRI-UOM Alpha 4 AP115 AP125
Vendor Price Unit This is the vendor pricing unit of AP126 AP131
of Measure measure. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-VPRI-UOM-MULT Signed 13.7 AP115 AP125
Vendor Price UOM This is the vendor pricing unit of AP126 AP131
Multiplier measure multiplier. It is used to AP180 AP181
convert unit cost to stock unit of AP190 AP20.1
measure terms. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-ENTERED-QTY Signed 13.4 AP115 AP125
Entered Qty AP126 AP131
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-ENT-UNIT-CST Signed 13.5 AP115 AP125
Entered Unit Cost The entered unit cost. AP126 AP131
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-TAX-CODE Alpha 10 AP115 AP125
Tax Code This field contains a code representing AP126 AP131
specific tax information. This must be AP180 AP181
valid Tax Code. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-TAX-TYPE Alpha 1 AP115 AP125
Tax Type The type of tax. AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-TAX-AMOUNT Signed 13.5 AP115 AP125
Tax Amount The tax amount for the invoice. AP126 AP131
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-VBUY-MATCH-QTY Signed 13.4 AP115 AP125
Matched Quantity The quantity of items that have been AP126 AP131
matched. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-VBUY-UOM Alpha 4 AP115 AP125
Vendor Buy Unit of The vendor's buying unit of measure. AP126 AP131
Measure AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-VBUY-UOM-MULT Signed 13.7 AP115 AP125
Vendor Buy UOM Vendor Buy Unit Of Measure Multiplier. AP126 AP131
Multiplier Used to convert quantity and unit cost. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-NO-TAX-FLAG Alpha 1 AP115 AP125
Taxable Invoice Flag Indicates if the invoice is taxable. AP126 AP131
N = No AP180 AP181
Y = Yes AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
MAD-MATCH-CLASS Alpha 10 AP115 AP125
Match Class Match class. A user-defined matching AP126 AP131
key structure consisting of matching AP180 AP181
elements. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-MATCH-DTL-KEY Alpha 55 AP115 AP125
Match Detail Key Match detail key. Combines all Matching AP126 AP131
Elements into a single element. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-RTL-UNIT-COST Signed 13.5 AP115 AP125
Retail Unit Cost The retail unit cost of the item. AP126 AP131
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-LOCATION Alpha 5 AP115 AP125
Location Code This field contains a valid stocking AP126 AP131
location within the company inventory. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-MATCH-OBJ-ID Numeric 12 AP115 AP125
Matching Object ID A system generated matching object AP126 AP131
identifier. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA60.4
MA61.1 MA63.1
MA65.1 MA66.2
MA68.1 MA70.1
MAI1.1 POI3.1
MAD-ENT-UOM Alpha 4 AP115 AP125
Entered Unit of Entered unit of measure. AP126 AP131
Measure AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-ENT-UOM-MULT Signed 13.7 AP115 AP125
Entered UOM This is the multiplier that relates the AP126 AP131
Multiplier entered UOM to stock UOM. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-TRAN-ND Numeric 1 AP115 AP125
Transaction Number The number of decimal positions defined AP126 AP131
of Decimals for the transaction currency. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-REC-SOURCE Alpha 2 AP115 AP125
Record Source Indicates where the detail record was AP126 AP131
created. AP180 AP181
AP190 AP20.1
Valid values are: AP20.2 AP20.3
AP20.4 AP20.5
IN = Invoice AP20.7 AP220
" " = PO Entry AP23.1 AP25.1
LM = Line Match (MA43) AP25.2 AP26.1
" " = PO Entry AP27.1 AP28.1
MA = Created within match AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-TOT-DIST-AMT Signed 15.2 AP115 AP125
Total Distribution The total amount of the distribution. AP126 AP131
Amount AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-TOT-BASE-AMT Signed 15.2 AP115 AP125
Total Base Amount This defines the total distributed AP126 AP131
approval amount in the company base AP180 AP181
currency. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-STATUS Numeric 1 AP115 AP125
Status The transaction status. AP126 AP131
AP180 AP181
Valid values are: AP190 AP20.1
AP20.2 AP20.3
0 = Unmatched AP20.4 AP20.5
1 = Matched AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-API-OBJ-ID Numeric 12 AP115 AP125
API Object ID A subsystem object interface AP126 AP131
identification number. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-MA-REC-NBR Numeric 10 AP115 AP125
Receipt Number The receipt number an invoice detail was AP126 AP131
matched to in a detail match. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
MAD-MA-LINE-NBR Numeric 6 AP115 AP125
Receipt Line Number Receipt line number. AP126 AP131
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
MAD-MATCH-SEQ-NBR Numeric 4 AP115 AP125
Matching Sequence Matching sequence number. Used to keep AP126 AP131
Number records unique. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
MAD-MTCH-EXC-PROC Numeric 1 AP115 AP125
Mtch Exc Proc 0 = No excess quantity AP126 AP131
1 = Chargeback AP180 AP181
2 = Write off AP190 AP20.1
3 = Matched no rec AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
MAD-INVOICE-TYPE Alpha 1 AP115 AP125
Invoice Type C = Credit Memo AP126 AP131
" " = Regular AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
MAD-DISTRIB-DATE Numeric 8 (yyyymmdd) AP115 AP125
Distribution Date The date used for posting the AP126 AP131
transactions to the general ledger. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-UPDATE-DATE Numeric 8 (yyyymmdd) AP115 AP125
Update Date This field contains the date the record AP126 AP131
was updated. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
MAD-UPDATE-TIME Numeric 6 AP115 AP125
Update Time This field contains the system time AP126 AP131
when the record was updated. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
MAD-TAX-USAGE-CD Alpha 10 AP115 AP125
Tax Usage Cd The tax usage coe for the vendor. This AP126 AP131
filed is required if the AP Company AP180 AP181
inidcates that VAT reporting required. AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
MAD-LAST-MSG-SEQ Numeric 6 AP115 AP125
Last Message AP126 AP131
Sequence Number AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA64.6
MA65.1 MA66.2
MA66.3 MA67.1
MA68.1 MA70.1
MAI1.1 POI3.1
MAD-ICN-CODE Alpha 8 AP115 AP125
Icn Code AP126 AP131
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-SUPLMNTARY-QTY Signed 13.4 AP115 AP125
Suplmntary Qty AP126 AP131
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-SUPLMNTARY-UOM Alpha 4 AP115 AP125
Suplmntary Uom AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-WEIGHT Signed 9.3 AP115 AP125
Unit Weight This field contains the unit weight of AP126 AP131
the item based on the stocking UOM. AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP28.1
AP28.2 AP30.2
AP30.4 AP305
AP45.1 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
MA43.8 MA60.2
MA60.3 MA61.1
MA63.1 MA65.1
MA66.2 MA68.1
MA70.1 MAI1.1
POI3.1
MAD-MATCH-EXT-COST Derived
Match Ext Cost
MAINVDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MADSET1 COMPANY AP115 AP125
VENDOR AP126 AP131
INVOICE AP198 AP20.1
SUFFIX AP20.2 AP20.3
PO-NUMBER AP20.4 AP20.5
PO-RELEASE AP20.7 AP220
PO-CODE AP23.1 AP25.1
LINE-NBR AP25.2 AP26.1
AOC-CODE AP27.1 AP30.2
SEQ-NBR AP30.4 AP300
AP305 API1.1
MA126 MA310
MA41.1 MA41.2
MA41.4 MA43.1
MA43.2 MA43.3
...
MADSET10 COMPANY KeyChange, Subset MA278 PO135
PO-NUMBER Where STATUS = 1 PO64.1
PO-RELEASE
PO-CODE
LINE-NBR
UPDATE-DATE*
UPDATE-TIME*
VENDOR
INVOICE
SUFFIX
AOC-CODE
SEQ-NBR
MADSET2 COMPANY KeyChange AP115 AP125
PO-NUMBER AP126 AP131
PO-RELEASE AP20.1 AP20.2
PO-CODE AP20.3 AP20.4
LINE-NBR AP20.5 AP20.7
VENDOR AP220 AP23.1
INVOICE AP25.1 AP25.2
SUFFIX AP26.1 AP27.1
AOC-CODE AP30.2 AP30.4
SEQ-NBR AP305 API1.1
IC28.1 MA126
MA180 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
...
MADSET3 COMPANY KeyChange AP115 AP125
API-OBJ-ID AP126 AP131
PO-NUMBER AP20.1 AP20.2
PO-RELEASE AP20.3 AP20.4
PO-CODE AP20.5 AP20.7
MATCH-DTL-KEY AP220 AP23.1
SEQ-NBR AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
...
MADSET4 COMPANY KeyChange AP115 AP125
VENDOR AP126 AP131
INVOICE AP20.1 AP20.2
SUFFIX AP20.3 AP20.4
PO-NUMBER AP20.5 AP20.7
PO-RELEASE AP220 AP23.1
PO-CODE AP25.1 AP25.2
ITEM AP26.1 AP27.1
SEQ-NBR AP30.2 AP30.4
AP305 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
...
MADSET6 COMPANY KeyChange AP125 AP126
PO-NUMBER AP131 AP25.1
PO-RELEASE AP25.2 AP26.1
PO-CODE AP27.1 IC28.1
LINE-NBR MA180 MA41.1
VENDOR MA43.9 MA530
AOC-CODE MA531 MA60.2
INVOICE MA60.3 MA60.5
SUFFIX MA61.1 MA66.3
SEQ-NBR MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
...
MADSET7 COMPANY KeyChange, Subset MA61.1
API-OBJ-ID Where AOC-CODE = Spaces
PO-NUMBER
PO-RELEASE
PO-CODE
LOCATION
MATCH-DTL-KEY
LINE-NBR
AOC-CODE
SEQ-NBR
MADSET8 COMPANY KeyChange AP115 AP125
API-OBJ-ID AP126 AP131
PO-NUMBER AP20.1 AP20.2
PO-RELEASE AP20.3 AP20.4
PO-CODE AP20.5 AP20.7
LOCATION AP220 AP23.1
MATCH-DTL-KEY AP25.1 AP25.2
LINE-NBR AP26.1 AP27.1
AOC-CODE AP30.2 AP30.4
SEQ-NBR AP305 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
...
MADSET9 COMPANY KeyChange, Duplicates, Subset AP115 AP125
MATCH-OBJ-ID Where INVOICE-TYPE = Spaces AP126 AP131
MATCH-SEQ-NBR AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
MA126 MA41.1
MA41.2 MA41.4
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
...
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
Poaocmast POAOCMAST Required
When ((MAD-AOC-CODE != Spaces )
And (MAD-TAX-CODE = Spaces ))
MAD-COMPANY -> PAM-COMPANY
MAD-AOC-CODE -> PAM-AOC-CODE
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
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
MAD-AOC-CODE -> 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
|