|
|
MAMATCHTBL FILE
Match Table
The Match Table file contains the definition of a match table and its
associated processing rules. Match tables are defined in MA00.1 (Match Table).
REFERENCED BY
AM115 AM15.1 AM15.2 AM15.3 AM15.4 AM20.1
AM20.3 AM21.1 AM21.3 AM500 AM51.1 AM551
AM97.1 AP10.1 AP110 AP115 AP125 AP126
AP131 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1
AP30.2 AP30.4 AP305 AP510 API1.1 API2.1
API3.1 API4.1 IC28.1 IC840 MA01.1 MA126
MA180 MA205 MA310 MA41.1 MA41.2 MA41.7
MA43.1 MA43.2 MA43.3 MA43.4 MA43.5 MA43.7
MA43.8 MA43.9 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA66.3
MA67.1 MA67.2 MA70.1 MA75.1 MA80.1 MAI1.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
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 POI3.1 POII.1 POIJ.1 PR05.1
PR05.3 PR226 PR247 PR26.1 PR47.1 PR514
UK47.1 RQ10.1 RQ10.2 RQ10.3 RQIE.1 WH20.2
WH20.7
UPDATED BY
MA00.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAM-MATCH-TABLE Alpha 10 MA00.1
Element: Match Table A code representing the matching table.
MAM-DESCRIPTION Alpha 30 (Lower Case) MA00.1
Match Table A description of the matching table.
Description
MAM-MATCH-TYPE Alpha 1 MA00.1
Element: Match Table TyIndicates which at which level
(company, vendor, or both) the record is
available for matching. Valid values
are:
C = Company
V = Vendor
B = Both
MAM-RULE-1 Alpha 10 MA00.1
Element: Rule 1
MAM-RULE-2 Alpha 10 MA00.1
Element: Rule 1
MAM-RULE-3 Alpha 10 MA00.1
Element: Rule 1
MAM-CB-TYPE Alpha 1 MA00.1
Element: Cb Type This flag denotes if the chargeback
created will be for the net difference
between the invoice and the receipt or
the amount the invoice is over the
receipt-overbill only. For example if
there is a multiple line match and one
of the lines is greater on the invoice
by $5 and one of the lines is less on
the invoice by $5, the net selection
would not generate a chargeback where as
the overbill would create a $5
chargeback
N = Net
O = Overbill
MAMATCHTBL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MAMSET1 MATCH-TABLE AM115 AM15.1
AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP10.1
AP110 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
...
|
