biuan SAP® BUSINESS ONE SDK
SQL Banking / Journal Entries of External Reconciliation
API MTH1V
MTH1V - Journal Entries of External Reconciliation 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
TransIDTransaction No.Int
11
Line_IDRow NumberInt
11
RefDatePosting DateDate
8
DueDateDue DateDate
8
Ref1Reference 1nVarChar
100
Ref2Reference 2nVarChar
100
Ref3LineReference 3nVarChar
27
DebitDebit AmountNum
20
CreditCredit AmountNum
20
SYSDebSystem Debit AmountNum
20
SYSCredSystem Credit AmountNum
20
FCDebitForeign Debit AmountNum
20
FCCreditForeign Credit AmountNum
20
CurrencyCurrencynVarChar
3
LineMemoRow DetailsnVarChar
127

SELECT statement

SELECT MTH1V.MthAcctCod AS 'Account Code', MTH1V.IsInternal AS 'Reconciliation Type', MTH1V.MatchNum AS 'Reconciliation No.', MTH1V.TransID AS 'Transaction No.', MTH1V.Line_ID AS 'Row Number', MTH1V.RefDate AS 'Posting Date', MTH1V.DueDate AS 'Due Date', MTH1V.Ref1 AS 'Reference 1', MTH1V.Ref2 AS 'Reference 2', MTH1V.Ref3Line AS 'Reference 3', MTH1V.Debit AS 'Debit Amount', MTH1V.Credit AS 'Credit Amount', MTH1V.SYSDeb AS 'System Debit Amount', MTH1V.SYSCred AS 'System Credit Amount', MTH1V.FCDebit AS 'Foreign Debit Amount', MTH1V.FCCredit AS 'Foreign Credit Amount', MTH1V.Currency AS 'Currency', MTH1V.LineMemo AS 'Row Details' FROM MTH1V AS MTH1V

Related information
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