biuan SAP® BUSINESS ONE SDK
SQL Banking / Reconciliation History / Reconciliation History
DTW Reconciliation History
API External Reconciliations Service / External Reconciliation
OMTH - Reconciliation History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
MthAcctCod KEY UNIQUEAccount CodenVarChar
15
PRIMARYYes
IsInternalReconciliation TypeVarChar
I) Internal
E) External
1
E
MatchNumReconciliation No.Int
11
TotalsRecon. Amount (One Side)Num
20
IsCardSelect BP or AccountVarChar
A) G/L Account
C) BP
1
A
MatchTypeReconciliation TypenVarChar
0
1) Ref. 1
2) Ref. 2
3) Ref. 3
4) Posting Date
5) Due Date
6) Ref. 1 + Posting Date
7) Ref. 2 + Posting Date
8) Ref. 3 + Posting Date
9) Ref. 1 + Due Date
10) Ref. 2 + Due Date
11) Ref. 3 + Due Date
12) By Total
2
0
TransIdReconciliation Transaction No.Int
11
-1
MatchDateReconciliation DateDate
8
CurrTypeCurrency TypenVarChar
3
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
createDateCreation DateDate
8

SELECT statement

SELECT OMTH.MthAcctCod AS 'Account Code', OMTH.IsInternal AS 'Reconciliation Type', OMTH.MatchNum AS 'Reconciliation No.', OMTH.Totals AS 'Recon. Amount (One Side)', OMTH.IsCard AS 'Select BP or Account', OMTH.MatchType AS 'Reconciliation Type', OMTH.TransId AS 'Reconciliation Transaction No.', OMTH.MatchDate AS 'Reconciliation Date', OMTH.CurrType AS 'Currency Type', OMTH.DataSource AS 'Data Source', OMTH.UserSign AS 'User Signature', OMTH.createDate AS 'Creation Date' FROM OMTH AS OMTH

Related information


External Reconciliation ExternalReconciliation Object· Table: OMTH
Represents external reconciliation, which is the comparison of open transactions within SAP Business One with an external account statement. Source table: OMTH.
   Parent: External Reconciliations Service ExternalReconciliationsService Service· Table: OMTH

External Reconciliations Service ExternalReconciliationsService Service· Table: OMTH
The ExternalReconciliationsService service enables you to add, look up, and cancel external reconciliations. Source table: OMTH.

Users OUSR SQL Table
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