biuan SAP® BUSINESS ONE SDK
API OMTC
OMTC - Bank Statement - Matching Criteria Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
MatchID KEY UNIQUEForm Type IndexInt
1) Documents
2) Internal Reconciliation
3) External Reconciliation
6
1MATCH_TYPEYes
RoundRoundingInt
1) Round 1
2) Round 2
3) Round 3
6
MtcRuleMatching RuleInt
6
0
MtcAliasMatching AliasnVarChar
18
DiffernceDifferenceInt
11
0
DiffAmntAmount DifferenceNum
20
RuleIndexRule IndexInt
6

SELECT statement

SELECT OMTC.DocEntry AS 'Internal Number', OMTC.MatchID AS 'Form Type Index', OMTC.Round AS 'Rounding', OMTC.MtcRule AS 'Matching Rule', OMTC.MtcAlias AS 'Matching Alias', OMTC.Differnce AS 'Difference', OMTC.DiffAmnt AS 'Amount Difference', OMTC.RuleIndex AS 'Rule Index' FROM OMTC AS OMTC

Related information




SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates