|
|
MAMTCHRULE FILE
Matching Rules
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 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.4
AP510 API1.1 API2.1 API3.1 API4.1 IC28.1
IC840 MA01.1 MA180 MA205 MA310 MA41.2
MA41.7 MA43.1 MA43.2 MA43.3 MA43.9 MA530
MA531 MA540 MA60.2 MA60.3 MA60.5 MA61.1
MA63.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.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAU-MATCH-RULE Alpha 10 MA00.4
Element: Match Rule
MAU-DESCRIPTION Alpha 30 (Lower Case) MA00.4
Element: Description This field displays the description.
MAU-MATCH-LEVEL Alpha 3 Occurs 6 Times MA00.4
Element: Match Level IM = Invoice Match
LIM = Line Invoice Match
DM = Detail Match
MAU-MA-RULE-TYPE Alpha 3 Occurs 6 Times MA00.4
Element: Ma Rule Type 1-1 = One to One
1-A = One to All
A-1 = All to One
A-A = All to All
MAU-ORDER Numeric 2 Occurs 6 Times MA00.4
Element: Field Order Number
MAU-UNDER-TOL-AMT Signed 15.2 Occurs 6 Times MA00.4
Element: Invoice AmountAdd a dollar amount which will be used a
as the match tolerance. If the receipt
and invoice match within this dollar
amount the match will be successful.
MAU-UNDER-TOL-PCT Percent 7.5 (Percent) Occurs 6 Times MA00.4
Element: Po Over Pct Enter a specific percent tolerance. If
the difference between the receipt and
invoice fall within that percent the
match is successful.
MAU-UNDER-COND Alpha 3 Occurs 6 Times MA00.4
Element: Po Over Cond The AND tolerance means that both the
dollar and percent will be considered
when the match is attempted. The OR
tolerance means if the difference
between the receipt and the invoice
falls outside of the dollar or the
percent the match will not be successful
MAU-OVER-TOL-AMT Signed 15.2 Occurs 6 Times MA00.4
Element: Invoice AmountAdd a dollar amount which will be used
as the match tolerance. If the receipt
and invoice match within this dollar
amount the match will be successful.
MAU-OVER-TOL-PCT Percent 7.5 (Percent) Occurs 6 Times MA00.4
Element: Po Over Pct Enter a specific percent tolerance. If
the difference between the receipt and
the invoice fall within that percent the
match will be successful
MAU-OVER-COND Alpha 3 Occurs 6 Times MA00.4
Element: Po Over Cond And/Or-The and/or tolerance means that
both the dolalr and the percent will be
considered when the match is attempted.
The system will add the dollar tolerance
and the percent tolerance. If the
difference is between the receipt and
the invoice is less than the total, the
match will be within the tolerances. The
Or tolerance means if the difference
between the receipt and the invoice
falls outside of the dollar or the
percent tolerance that match will not be
successful.
MAU-TOLERANCE-OPT Numeric 1 Occurs 6 Times MA00.4
Element: Tolerance Opt 1 = Extended Amount
2 = Unit Cost
MAU-CHARGEBACK-FL Alpha 1 Occurs 6 Times MA00.4
Element: Account Flag N = No Chargeback
Y = Yes Generate Chargeback
MAU-OVER-COST-AMT Signed 15.2 Occurs 6 Times MA00.4
Element: Invoice AmountAdd a dollar amount which will be used
as the match tolerance. If the receipt
and invoice match within this dollar
amount the match will be successful
MAU-OVER-COST-COND Alpha 3 Occurs 6 Times MA00.4
Element: Po Over Cond And/Or-The and/or tolerance means that
both the dollar and the percent will be
considered when the match is attempted.
And tolerance means that both the dollar
and the percent will be considered when
the match is attempted. The Or tolerance
means if the difference between the
receipt and the invoice falls outside
the dollar or percent tolerance the
match will not be successful.
MAU-OVER-COST-PCT Percent 7.5 (Percent) Occurs 6 Times MA00.4
Element: Po Over Pct Enter a specific percent tolerance. If
the difference between the receipt and
invoice fall within that percent the
match is successful.
MAU-UNDER-COST-AMT Signed 15.2 Occurs 6 Times MA00.4
Element: Invoice AmountAdd a dollar amount which will be used
as the match tolerance. If the receipt
and invoice match within this dollar
amount the match will be successful.
MAU-UNDER-COST-CON Alpha 3 Occurs 6 Times MA00.4
Element: Po Over Cond ANd/Or-The and/or tolerance means that
both the dollar and the percent will be
considered when the match is attempted.
And tolerance means that both the dollar
and the percent will be considered when
the match is attempted. The Of
tolerance means if the difference
between the receipt and the invoice
falls outside the dollar or the percent
tolerance the match will not be
successful.
MAU-UNDER-COST-PCT Percent 7.5 (Percent) Occurs 6 Times MA00.4
Element: Po Over Pct Enter a specific percent tolerance. If
the difference between the receipt and
invoice fall within that percent the
match is successful.
MAU-COST-OPEN-MSG Alpha 1 Occurs 6 Times MA00.4
Element: Po Cost Msg FlCreate an open message for under
difference. So the receipt is greater
than the invoice
MAU-COST-CLO-MSG Alpha 1 Occurs 6 Times MA00.4
Element: Po Cost Msg FlCreate a closed message for under
differences. When the receipt is
greater than the invoice.
MAU-COST-REASON-CD Alpha 4 Occurs 6 Times MA00.4
Accounts Receivable For a closed message a reason code can
Code be assigned.
MAU-OVER-QTY-AMT Signed 15.2 Occurs 6 Times MA00.4
Element: Invoice AmountAdd a dollar amount which will be used
as the match tolerance. If the receipt
and invoice match within this dollar
amount the match will be successful.
MAU-OVER-QTY-COND Alpha 3 Occurs 6 Times MA00.4
Element: Po Over Cond And/Or-The and/or tolerance means that
both the dollar and the percent will be
considered when the match is attempted.
AND tolerance means that dollar AND
percent will be considered. The Or
tolerance means if the difference
between the receipt and the invoice
falls outside the match will not be
successful.
MAU-OVER-QTY-PCT Percent 7.5 (Percent) Occurs 6 Times MA00.4
Element: Po Over Pct Enter a specific percent tolerance. If
the difference between the invoice and
the receipt fall within that percent the
match is successful.
MAU-UNDER-QTY-AMT Signed 15.2 Occurs 6 Times MA00.4
Element: Invoice AmountAdd a dollar amount which will be used
as the match tolerance. If the receipt
and invoice match within this dollar
amount the match will be successful.
MAU-UNDER-QTY-COND Alpha 3 Occurs 6 Times MA00.4
Element: Po Over Cond And/Or-The and/or tolerance means that
both the dollar and the percent will be
considered when the match is attempted.
And will use both the dollar and the
ercent. Or tolerance means if the
difference between the receipt and the
invoice fall soutside the dollar amount
or percent the match will not be
successful.
MAU-UNDER-QTY-PCT Percent 7.5 (Percent) Occurs 6 Times MA00.4
Element: Po Over Pct Enter a specific percent tolerance. If
the difference between the receipt and
invoice fall within that percent the
match is successful.
MAU-QTY-OPEN-MSG Alpha 1 Occurs 6 Times MA00.4
Element: Po Cost Msg FlCreate an open message for under
differences. So the receipt is greater
than the invoice.
MAU-QTY-CLO-MSG Alpha 1 Occurs 6 Times MA00.4
Element: Po Cost Msg FlCreate a closed message for under
differences. When the receipt is
greater than the invoice.
MAU-QTY-REASON-CD Alpha 4 Occurs 6 Times MA00.4
Accounts Receivable For a closed message a reason code can
Code be assigned
MAMTCHRULE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MAUSET1 MATCH-RULE 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 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.4
...
MAMTCHRULE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Mamsgtol MAMSGTOL Required
MAU-MATCH-RULE -> MGT-MATCH-RULE
|
