OMTC - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Banking / Bank Statement - Matching Criteria

API OMTC

OMTC - Bank Statement - Matching Criteria Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
DocEntry ^KEY ^UNIQUE	Internal Number	Int		11		PRIMARY	Yes
MatchID ^KEY ^UNIQUE	Form Type Index	Int	1) Documents 2) Internal Reconciliation 3) External Reconciliation	6	1	MATCH_TYPE	Yes
Round	Rounding	Int	1) Round 1 2) Round 2 3) Round 3	6
MtcRule	Matching Rule	Int		6	0
MtcAlias	Matching Alias	nVarChar		18
Differnce	Difference	Int		11	0
DiffAmnt	Amount Difference	Num		20
RuleIndex	Rule Index	Int		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

biuan SAP® BUSINESS ONE

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