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 MA236 MA310 MA531 MA67.1 MA67.2
POA3.1 MA278 PO135 PO64.1 BL120 BL122
BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1
BL29.2 BL520 BL820 BL92.1 IC28.1 MA180
MA530 MA80.1 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE111 OE113 OE114
OE116 OE129 OE13.2 OE13.3 OE13.5 OE13.6
OE14.4 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE510 OE530 OE81.1
OE810 OE830 OE90.1 OE90.2 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 MM280 RQ10.1 RQ10.2 WH20.2 WH20.7
PO25.1 PO25.6 PO25.7 PO36.1 PO36.2 PO536
PO58.2
UPDATED BY
AP115 AP125 AP126 AP131 AP180 AP181
AP190 AP198 AP220 AP25.1 AP25.2 AP26.1
AP27.1 AP28.1 AP28.2 AP30.2 AP30.4 AP300
AP305 AP45.1 API1.1 MA126 MA60.2 MA60.3
MA60.4 MA61.1 MA63.1 MA64.6 MA65.1 MA66.2
MA66.3 MA68.1 MA70.1 MA75.1 MAI1.1 POI3.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAD-COMPANY Numeric 4 AP115 AP125
Element: Company Identifies the AP company if the AP126 AP131
resource type = V. Identifies the HR AP180 AP181
company if the resource type = E. It is AP190 AP220
blank for type A, P or Q resources. AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA236 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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA60.2 MA60.3
MA61.1 MA63.1
MA65.1 MA66.2
MA68.1 MA70.1
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 AP220
N = Non-stock AP25.1 AP25.2
S = Service AP26.1 AP27.1
X = Special AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 The vendor's item identifer. AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA60.2 MA60.3
MA61.1 MA63.1
MA65.1 MA66.2
MA68.1 MA70.1
MA75.1 MAI1.1
POI3.1
MAD-ITEM-DESC Alpha 30 (Lower Case) AP115 AP125
Element: Description This field contains the description for AP126 AP131
stock and non-stock items. AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 MA126
MA60.2 MA60.3
MA61.1 MA63.1
MA65.1 MA66.2
MA68.1 MA70.1
MA75.1 MAI1.1
MAD-MATCHED-QTY Signed 13.4 AP115 AP125
Element: Matched QuantiThe quantity of items that have been AP126 AP131
matched. AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 18.5 AP115 AP125
Element: Intl Cost AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 MeasurThis is the vendor pricing unit of AP126 AP131
measure. AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 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 AP220
measure terms. AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 18.5 AP115 AP125
Element: Intl Cost The entered unit cost. AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 MA126
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 18.2 AP115 AP125
Element: Intl Amt The tax amount for the invoice. AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 MeasurThe vendor's buying unit of measure. AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 Vendor Buy Unit Of Measure Multiplier. AP126 AP131
Multiplier Used to convert quantity and unit cost. AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA60.2 MA60.3
MA61.1 MA63.1
MA65.1 MA66.2
MA68.1 MA70.1
MA75.1 MAI1.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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 18.5 AP115 AP125
Element: Retail Unit CoThe retail unit cost of the item. AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 This is the multiplier that relates the AP126 AP131
Multiplier entered UOM to stock UOM. AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 The number of decimal positions defined AP126 AP131
Code for the transaction currency. AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
Valid values are: AP25.1 AP25.2
AP26.1 AP27.1
IN = Invoice AP28.1 AP28.2
" " = PO Entry AP30.2 AP30.4
LM = Line Match (MA43) AP305 AP45.1
" " = PO Entry API1.1 MA126
MA = Created within match 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 18.2 AP115 AP125
Total Distribution The total amount of the distribution. AP126 AP131
Amount AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 18.2 AP115 AP125
Element: Total Base AmoThis defines the total distributed AP126 AP131
approval amount in the company base AP180 AP181
currency. AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
0 = Unmatched AP26.1 AP27.1
1 = Matched AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA60.2 MA60.3
MA61.1 MA63.1
MA65.1 MA66.2
MA68.1 MA70.1
MA75.1 MAI1.1
MAD-MA-LINE-NBR Numeric 6 AP115 AP125
Element: Receipt Line NReceipt line number. AP126 AP131
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA60.2 MA60.3
MA61.1 MA63.1
MA65.1 MA66.2
MA68.1 MA70.1
MA75.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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
3 = Matched no rec AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 THis field will be filled in from the AP126 AP131
Invoice based on PO number. This is a AP180 AP181
carrier for the field. The PORECEIVE AP190 AP220
file will have to be updated with this AP25.1 AP25.2
field. AP26.1 AP27.1
C = Credit Memo AP28.1 AP28.2
" " = Regular AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA60.2 MA60.3
MA61.1 MA63.1
MA65.1 MA66.2
MA68.1 MA70.1
MA75.1 MAI1.1
MAD-DISTRIB-DATE Numeric 8 (yyyymmdd) AP115 AP125
Element: Date The date used for posting the AP126 AP131
transactions to the general ledger. AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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: Update Date This field contains the date the record AP126 AP131
was updated. AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
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
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 MA126
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 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP305 AP45.1
API1.1 MA126
MA60.2 MA60.3
MA61.1 MA63.1
MA65.1 MA66.2
MA68.1 MA70.1
MA75.1 MAI1.1
POI3.1
MAD-TERMS-CD Alpha 5
Element: Terms Code
MAD-DISC-RATE Percent 5.3 (Percent)
Element: Discount Rate
MAD-DISC-DATE Numeric 8 (yyyymmdd)
Element: Discount Date
MAD-FLEX-FLAG Alpha 1
Element: Flex DeductionTerms has been overriden
MAD-PREPAY-QTY Signed 13.4
Element: Prepay Qty
MAD-PRPY-UNIT-CST Signed 18.5
Element: Intl Cost
MAD-PRPY-TAX-CODE Alpha 10
Element: Prpy Tax Code
MAD-PRPY-TAX-AMT Signed 18.2
Element: Intl Amt
MAD-PRPY-RTL-UCST Signed 18.5
Element: Intl Cost
MAD-PREPAY-DATE Numeric 8 (yyyymmdd)
Element: Prepay Date
MAD-MATCH-ERR-TYPE Numeric 2
Element: Match Err TypeThis is the reason the match was not
successful.
01 = cost error
02 = quantity error
03 = item error
MAD-CATCH-WGT-COST Signed 18.5
Element: Intl Cost
MAD-REASON-CODE Alpha 4
Element: Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
MAD-CHARGEBACK-FL Alpha 1
Element: Chargeback Fl 0 = no
1 = yes
MAD-IR-DIFF-AMT Signed 18.2
Element: Intl Amt THis is the field that will hold the
difference between the invoice and the
receipt in order to calculate the
chargeback
MAD-MATCH-EXT-COST Signed 18.5
Element: Intl Cost
MAD-AGREEMENT-REF Alpha 30
Element: Agreement Ref This is for contracts(agreements) coming
from the PO system. Used to denote
message with contract associated.
MAINVDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MADSET1 COMPANY AP115 AP125
VENDOR AP126 AP131
INVOICE AP198 AP220
SUFFIX AP25.1 AP25.2
PO-NUMBER AP26.1 AP27.1
PO-RELEASE AP295 AP30.2
PO-CODE AP30.4 AP300
LINE-NBR AP305 API1.1
SEQ-NBR MA126 MA236
MA310 MA531
MA60.2 MA60.3
MA60.4 MA61.1
MA63.1 MA64.1
MA64.2 MA64.3
MA64.4 MA65.1
...
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
SEQ-NBR
MADSET2 COMPANY KeyChange AP115 AP125
PO-NUMBER AP126 AP131
PO-RELEASE AP220 AP25.1
PO-CODE AP25.2 AP26.1
LINE-NBR AP27.1 AP30.2
VENDOR AP30.4 AP305
INVOICE API1.1 BL120
SUFFIX BL122 BL130
SEQ-NBR BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC28.1
MA126 MA180
MA530 MA531
...
MADSET3 COMPANY KeyChange AP115 AP125
API-OBJ-ID AP126 AP131
PO-NUMBER AP220 AP25.1
PO-RELEASE AP25.2 AP26.1
PO-CODE AP27.1 AP30.2
MATCH-DTL-KEY AP30.4 AP305
SEQ-NBR API1.1 MA126
MA60.2 MA60.3
MA61.1 MA63.1
MA65.1 MA66.2
MA68.1 MA70.1
MA75.1 MAI1.1
MADSET4 COMPANY KeyChange AP115 AP125
VENDOR AP126 AP131
INVOICE AP220 AP25.1
SUFFIX AP25.2 AP26.1
PO-NUMBER AP27.1 AP30.2
PO-RELEASE AP30.4 AP305
PO-CODE API1.1 MA126
ITEM MA236 MA60.2
SEQ-NBR MA60.3 MA61.1
MA63.1 MA64.6
MA65.1 MA66.1
MA66.2 MA66.3
MA66.8 MA68.1
MA70.1 MA75.1
MAI1.1 PO25.1
...
MADSET8 COMPANY KeyChange AP115 AP125
API-OBJ-ID AP126 AP131
PO-NUMBER AP220 AP25.1
PO-RELEASE AP25.2 AP26.1
PO-CODE AP27.1 AP30.2
LOCATION AP30.4 AP305
MATCH-DTL-KEY API1.1 MA126
LINE-NBR MA60.2 MA60.3
SEQ-NBR MA61.1 MA63.1
MA65.1 MA66.2
MA68.1 MA70.1
MA75.1 MAI1.1
MADSET9 COMPANY KeyChange, Subset AP115 AP125
MATCH-OBJ-ID Where INVOICE-TYPE = Spaces AP126 AP131
MATCH-SEQ-NBR AP220 AP25.1
VENDOR AP25.2 AP26.1
INVOICE AP27.1 AP30.2
SUFFIX AP30.4 AP305
PO-NUMBER API1.1 MA126
PO-RELEASE MA60.2 MA60.3
PO-CODE MA61.1 MA63.1
LINE-NBR MA65.1 MA66.2
SEQ-NBR MA68.1 MA70.1
MA75.1 MAI1.1
PO58.2 POA3.1
MAINVDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apbatch APBATCH Not Required
MAD-COMPANY -> APB-COMPANY
API-BATCH-NUM -> APB-BATCH-NUM
Apcompany APCOMPANY Required
MAD-COMPANY -> CPY-COMPANY
Apinvoice APINVOICE Required
MAD-COMPANY -> API-COMPANY
MAD-VENDOR -> API-VENDOR
MAD-INVOICE -> API-INVOICE
MAD-SUFFIX -> API-SUFFIX
Zeroes -> API-CANCEL-SEQ
Iccompany ICCOMPANY Required
MAD-COMPANY -> ICC-COMPANY
Itemloc ITEMLOC Required
MAD-COMPANY -> ITL-COMPANY
MAD-LOCATION -> ITL-LOCATION
MAD-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
When MAD-ITEM-TYPE = "I"
Or MAD-ITEM-TYPE = "N"
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
MAD-ITEM -> ITE-ITEM
Location ICLOCATION Required
MAD-COMPANY -> ICL-COMPANY
MAD-LOCATION -> ICL-LOCATION
Macompany MACOMPANY Required
MAD-COMPANY -> MAY-COMPANY
Mapoinv MAPOINV Not Required
MAD-COMPANY -> AOI-COMPANY
MAD-PO-NUMBER -> AOI-PO-NUMBER
MAD-PO-RELEASE -> AOI-PO-RELEASE
MAD-PO-CODE -> AOI-PO-CODE
MAD-VENDOR -> AOI-VENDOR
MAD-INVOICE -> AOI-INVOICE
MAD-SUFFIX -> AOI-SUFFIX
Mmuaval MMUAVAL Required
MAD-COMPANY -> MUA-COMPANY
"AP" -> MUA-SYSTEM-CD
MAD-LOCATION -> MUA-LOCATION
"IN" -> MUA-DOC-TYPE
Spaces -> MUA-DOC-NUMBER
Zeroes -> MUA-DOC-NBR-NUM
Spaces -> MUA-PO-CODE
MAD-LINE-NBR -> MUA-LINE-NBR
MAD-API-OBJ-ID -> MUA-API-OBJ-ID
MAD-SEQ-NBR -> MUA-SEQ-NBR
Pocompany POCOMPANY Required
MAD-COMPANY -> PCY-COMPANY
Poline POLINE Not Required
MAD-COMPANY -> PLI-COMPANY
MAD-PO-NUMBER -> PLI-PO-NUMBER
MAD-PO-RELEASE -> PLI-PO-RELEASE
MAD-PO-CODE -> PLI-PO-CODE
MAD-LINE-NBR -> PLI-LINE-NBR
Purchorder PURCHORDER Required
MAD-COMPANY -> PCR-COMPANY
MAD-PO-CODE -> PCR-PO-CODE
MAD-PO-NUMBER -> PCR-PO-NUMBER
MAD-PO-RELEASE -> PCR-PO-RELEASE
Vendor APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
MAD-VENDOR -> VEN-VENDOR
MAINVDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
MAA-AOC-CODE
MAA-SEQ-NBR
Mainvmsg MAINVMSG
MAD-COMPANY -> MAG-COMPANY
MAD-VENDOR -> MAG-VENDOR
MAD-INVOICE -> MAG-INVOICE
MAD-SUFFIX -> MAG-SUFFIX
Zeroes -> MAG-CANCEL-SEQ
MAD-SEQ-NBR -> MAG-MAD-SEQ-NBR
MAG-SEQ-NBR
Mmdist MMDIST
Valid When MAD-ITEM-TYPE != "I"
MAD-COMPANY -> MMD-COMPANY
"PO" -> MMD-SYSTEM-CD
MAD-LOCATION -> MMD-LOCATION
"PT" -> MMD-DOC-TYPE
MAD-PO-NUMBER -> MMD-DOC-NUMBER
MAD-PO-RELEASE -> MMD-DOC-NBR-NUM
MAD-PO-CODE -> MMD-PO-CODE
MAD-LINE-NBR -> MMD-LINE-NBR
Zeroes -> MMD-COMPONENT-SEQ
Spaces -> MMD-AOC-CODE
MMD-LINE-SEQ
MMD-REQ-LOCATION
MMD-API-OBJ-ID
Porecline PORECLINE
MAD-COMPANY -> PRL-COMPANY
MAD-PO-CODE -> PRL-PO-CODE
MAD-PO-NUMBER -> PRL-PO-NUMBER
MAD-PO-RELEASE -> PRL-PO-RELEASE
MAD-LOCATION -> PRL-LOCATION
MAD-MATCH-DTL-KEY -> PRL-MATCH-DTL-KEY
PRL-PO-LINE-NBR
PRL-REC-NUMBER
PRL-LINE-NBR
|