MAMTCHRULE

Matching Rules

REFERENCED BY
AM115 AM117 AM15.1 AM15.2 AM15.3 AM15.4
AM19.1 AM19.2 AM20.1 AM20.3 AM21.1 AM21.3
AM500 AM51.1 AM551 AM97.1 AP00.3 AP03.3
AP10.1 AP110 AP115 AP125 AP126 AP131
AP150 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP21.1 AP210 AP220 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP305
AP510 AP90.1 AP91.1 API1.1 API2.1 API3.1
API4.1 MX123 MX500 MA05.1 MA205 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MA540 MAI1.1 PO10.1
PO136 PO190 PO300 PO520 POCP.1 POI3.1
POII.1 POIJ.1 PR05.1 PR05.3 PR226 PR247
PR26.1 PR47.1 PR514 UK47.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAU-MATCH-RULE
Element: Match Rule
Alpha 10
MAU-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
MAU-MATCH-LEVEL
Element: Match Level
Alpha 3 Occurs 6 Times

IM = Invoice Match
LIM = Line Invoice Match
DM = Detail Match
MAU-MA-RULE-TYPE
Element: Ma Rule Type
Alpha 3 Occurs 6 Times

1-1 = One to One
1-A = One to All
A-1 = All to One
A-A = All to All
MAU-ORDER
Element: Order
Numeric 2 Occurs 6 Times
MAU-UNDER-TOL-AMT
Element: Intl Amt
Signed 18.2 Occurs 6 Times
MAU-UNDER-TOL-PCT
Element: Po Over Pct
Percent 7.5 (Percent) Occurs 6 Times
MAU-UNDER-COND
Element: Po Over Cond
Alpha 3 Occurs 6 Times
MAU-OVER-TOL-AMT
Element: Intl Amt
Signed 18.2 Occurs 6 Times
MAU-OVER-TOL-PCT
Element: Po Over Pct
Percent 7.5 (Percent) Occurs 6 Times
MAU-OVER-COND
Element: Po Over Cond
Alpha 3 Occurs 6 Times
MAU-TOLERANCE-OPT
Element: Tolerance Opt
Numeric 1 Occurs 6 Times

1 = Extended Amount
2 = Unit Cost
MAU-QTY-OVER-AMT
Element: Tran Inv Amt
Signed 15.2 Occurs 6 Times
MAU-QTY-OVER-COND
Element: Po Over Cond
Alpha 3 Occurs 6 Times
MAU-QTY-OVER-PCT
Element: Po Over Pct
Percent 7.5 (Percent) Occurs 6 Times
MAU-QTY-UNDER-AMT
Element: Tran Inv Amt
Signed 15.2 Occurs 6 Times
MAU-QTY-UNDER-COND
Element: Po Over Cond
Alpha 3 Occurs 6 Times
MAU-QTY-UNDER-PCT
Element: Po Over Pct
Percent 7.5 (Percent) Occurs 6 Times
MAU-CHARGEBACK-FL
Element: Account Flag
Alpha 1 Occurs 6 Times

N = No Chargeback
Y = Yes Generate Chargeback
MAU-OVER-COST-AMT
Element: Intl Amt
Signed 18.2 Occurs 6 Times
MAU-OVER-COST-COND
Element: Po Over Cond
Alpha 3 Occurs 6 Times
MAU-OVER-COST-PCT
Element: Po Over Pct
Percent 7.5 (Percent) Occurs 6 Times
MAU-UNDER-COST-AMT
Element: Intl Amt
Signed 18.2 Occurs 6 Times
MAU-UNDER-COST-CON
Element: Po Over Cond
Alpha 3 Occurs 6 Times
MAU-UNDER-COST-PCT
Element: Po Over Pct
Percent 7.5 (Percent) Occurs 6 Times
MAU-COST-OPEN-MSG
Element: Po Cost Msg Fl
Alpha 1 Occurs 6 Times
MAU-COST-CLO-MSG
Element: Po Cost Msg Fl
Alpha 1 Occurs 6 Times
MAU-COST-REASON-CD
Element: Reason Code
Alpha 4 Occurs 6 Times
This field contains the reason code, which indicates the cause for credit memos.
MAU-OVER-QTY-AMT
Element: Intl Amt
Signed 18.2 Occurs 6 Times
MAU-OVER-QTY-COND
Element: Po Over Cond
Alpha 3 Occurs 6 Times
MAU-OVER-QTY-PCT
Element: Po Over Pct
Percent 7.5 (Percent) Occurs 6 Times
MAU-UNDER-QTY-AMT
Element: Intl Amt
Signed 18.2 Occurs 6 Times
MAU-UNDER-QTY-COND
Element: Po Over Cond
Alpha 3 Occurs 6 Times
MAU-UNDER-QTY-PCT
Element: Po Over Pct
Percent 7.5 (Percent) Occurs 6 Times
MAU-QTY-OPEN-MSG
Element: Po Cost Msg Fl
Alpha 1 Occurs 6 Times
MAU-QTY-CLO-MSG
Element: Po Cost Msg Fl
Alpha 1 Occurs 6 Times
MAU-QTY-REASON-CD
Element: Reason Code
Alpha 4 Occurs 6 Times
This field contains the reason code, which indicates the cause for credit memos.
MAU-REASON-CODE
Element: Reason Code
Alpha 4 Occurs 6 Times
This field contains the reason code, which indicates the cause for credit memos.


MAMTCHRULE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MAUSET1 MATCH-RULE
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP03.3
AP10.1 AP110
AP115 AP125
AP126 AP131
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5


MAMTCHRULE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Mamsgtol MAMSGTOL Required
MAU-MATCH-RULE->MGT-MATCH-RULE


File created: Wed Jun 08 20:50:10 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.