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 MA236 MA310 MA67.1 MA67.2
POA3.1 MM280 MM80.1 MM80.2 MA278 PO135
PO139 PO64.1 IC28.1 MA180 MA530 MA531
MA80.1 PO100 PO101 PO122 PO131 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO25.1 PO25.5 PO25.6 PO25.7 PO27.2
PO29.1 PO295 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 POD0.1 POII.1
POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQIE.1 WH20.2
WH20.7 API5.1 PO58.2
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 MA41.1 MA41.2
MA41.4 MA41.7 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 MA705 MA75.1 MAI1.1 POI3.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAD-COMPANY Numeric 4 AP115 AP125
Element: 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-VENDOR Alpha 9 (Right Justified) AP115 AP125
Element: 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-INVOICE Alpha 22 AP115 AP125
Element: Invoice NumberUsed 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-SUFFIX Numeric 3 AP115 AP125
Element: Invoice SuffixThis 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-PO-NUMBER Alpha 14 (Right Justified) AP115 AP125
Element: 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-PO-RELEASE Numeric 4 AP115 AP125
Element: PO Release NumUsed 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-PO-CODE Alpha 4 AP115 AP125
Element: Purchase OrderPurchase 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-LINE-NBR Numeric 6 AP115 AP125
Element: 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
MA236 MA41.1
MA41.2 MA41.4
MA41.7 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
MA75.1 MAI1.1
POI3.1
MAD-AOC-CODE Alpha 2 AP115 AP125
Element: Add On Cost CoThis 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-SEQ-NBR Numeric 4 AP115 AP125
Element: Sequence NumbeAn 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA705
MA75.1 MAI1.1
POI3.1
MAD-ITEM-TYPE Alpha 1 AP115 AP125
Element: 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-ITEM Alpha 32 AP115 AP125
Element: 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-VEN-ITEM Alpha 32 AP115 AP125
Element: Item 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-MATCHED-QTY Signed 13.4 AP115 AP125
Element: Matched QuantiThe 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-MATCH-UNIT-CST Signed 13.5 AP115 AP125
Element: Base 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-VPRI-UOM Alpha 4 AP115 AP125
Element: Unit of Measure 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-VPRI-UOM-MULT Signed 13.7 AP115 AP125
Unit of Measure AP126 AP131
Multiplier 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-ENTERED-QTY Signed 13.4 AP115 AP125
Element: Quantity 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-ENT-UNIT-CST Signed 13.5 AP115 AP125
Element: Base Cost The entered unit cost in vendor price AP126 AP131
unit of measure terms. This value may AP180 AP181
be entered on line or calculated from AP190 AP20.1
entry of cost in buy unit of measure AP20.2 AP20.3
terms. 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-TAX-CODE Alpha 10 AP115 AP125
Element: 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-TAX-TYPE Alpha 1 AP115 AP125
Element: 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-TAX-AMOUNT Signed 13.5 AP115 AP125
Element: Base Cost 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-VBUY-MATCH-QTY Signed 13.4 AP115 AP125
Element: Matched QuantiThe 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-VBUY-UOM Alpha 4 AP115 AP125
Element: Unit of Measure 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-VBUY-UOM-MULT Signed 13.7 AP115 AP125
Unit of Measure AP126 AP131
Multiplier 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-NO-TAX-FLAG Alpha 1 AP115 AP125
Element: Taxable InvoicIndicates 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-MATCH-CLASS Alpha 10 AP115 AP125
Element: 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-MATCH-DTL-KEY Alpha 85 AP115 AP125
Element: Match Detail KMatch 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-RTL-UNIT-COST Signed 13.5 AP115 AP125
Element: Retail Unit CoThe 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-LOCATION Alpha 5 AP115 AP125
Element: 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-MATCH-OBJ-ID Numeric 12 AP115 AP125
Element: Matching ObjecA 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
MA41.1 MA41.2
MA41.4 MA41.7
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
MA75.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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-ENT-UOM-MULT Signed 13.7 AP115 AP125
Unit of Measure AP126 AP131
Multiplier 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-TRAN-ND Numeric 1 AP115 AP125
Account Currency AP126 AP131
Code 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-REC-SOURCE Alpha 2 AP115 AP125
Element: 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-TOT-BASE-AMT Signed 15.2 AP115 AP125
Element: Total Base Amount 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-STATUS Numeric 1 AP115 AP125
Element: 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-API-OBJ-ID Numeric 12 AP115 AP125
Element: 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-MA-REC-NBR Numeric 10 AP115 AP125
Element: Receipt NumberThe 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-MA-LINE-NBR Numeric 6 AP115 AP125
Element: Receipt Line NReceipt 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1
MAD-MTCH-EXC-PROC Numeric 1 AP115 AP125
Element: 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1
MAD-INVOICE-TYPE Alpha 1 AP115 AP125
Element: 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-DISTRIB-DATE Numeric 8 (yyyymmdd) AP115 AP125
Element: Date 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-UPDATE-DATE Numeric 8 (yyyymmdd) AP115 AP125
Element: Date 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1
MAD-UPDATE-TIME Numeric 6 AP115 AP125
Element: 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1
MAD-TAX-USAGE-CD Alpha 10 AP115 AP125
Element: 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1
MAD-LAST-MSG-SEQ Numeric 6 AP115 AP125
Record Sequence AP126 AP131
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
MA41.1 MA41.2
MA41.4 MA41.7
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
MA75.1 MAI1.1
POI3.1
MAD-ICN-CODE Alpha 8 AP115 AP125
Element: 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-SUPLMNTARY-QTY Signed 13.4 AP115 AP125
Element: Quantity 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-SUPLMNTARY-UOM Alpha 4 AP115 AP125
Element: Unit of Measure 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-WEIGHT Signed 9.3 AP115 AP125
Element: 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
MA41.1 MA41.2
MA41.4 MA41.7
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 MA75.1
MAI1.1 POI3.1
MAD-MATCH-EXT-COST Derived
Element: 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 AP295
SEQ-NBR AP30.2 AP30.4
AP300 AP305
API1.1 MA126
MA236 MA310
MA41.1 MA41.2
MA41.4 MA41.7
...
MADSET10 COMPANY KeyChange, Subset AP30.4 MA278
PO-NUMBER Where STATUS = 1 PO135 PO139
PO-RELEASE PO64.1
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 MA180
MA41.1 MA41.2
MA41.4 MA41.7
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
MA41.1 MA41.2
MA41.4 MA41.7
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
MA236 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
...
MADSET6 COMPANY KeyChange AP125 AP126
PO-NUMBER AP131 AP20.1
PO-RELEASE AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
LINE-NBR AP20.7 AP23.1
VENDOR AP25.1 AP25.2
AOC-CODE AP26.1 AP27.1
INVOICE AP30.4 API1.1
SUFFIX API5.1 IC28.1
SEQ-NBR MA180 MA41.1
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
...
MADSET7 COMPANY KeyChange, Subset AP30.4 MA41.7
API-OBJ-ID Where AOC-CODE = Spaces MA61.1
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.5 MA43.7
...
MADSET9 COMPANY KeyChange, Subset AP115 AP125
MATCH-OBJ-ID Where INVOICE-TYPE = Spaces AP126 AP131
MATCH-SEQ-NBR AP20.1 AP20.2
VENDOR AP20.3 AP20.4
INVOICE AP20.5 AP20.7
SUFFIX AP220 AP23.1
PO-NUMBER AP25.1 AP25.2
PO-RELEASE AP26.1 AP27.1
PO-CODE AP30.2 AP30.4
LINE-NBR AP305 API1.1
AOC-CODE MA41.1 MA41.2
SEQ-NBR MA41.4 MA41.7
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
Pomatchobj POMATCHOBJ Not Required
MAD-COMPANY -> PMJ-COMPANY
MAD-MATCH-OBJ-ID -> PMJ-MATCH-OBJ-ID
MAD-MATCH-SEQ-NBR -> PMJ-MATCH-SEQ-NBR
MAD-MA-REC-NBR -> PMJ-REC-NUMBER
MAD-MA-LINE-NBR -> PMJ-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
|