biuan SAP® BUSINESS ONE SDK
SQL Banking / Bank Statements of External Reconciliation
API MTH2V
MTH2V - Bank Statements 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
BnkAcctCod KEY UNIQUEAccount CodenVarChar
15
SECONDARYYes
SequenceSequence No.Int
11
DueDateDue DateDate
8
RefReferencenVarChar
27
DebAmountDebit AmountNum
20
MemoDetailsnVarChar
127

SELECT statement

SELECT MTH2V.MthAcctCod AS 'Account Code', MTH2V.IsInternal AS 'Reconciliation Type', MTH2V.MatchNum AS 'Reconciliation No.', MTH2V.BnkAcctCod AS 'Account Code', MTH2V.Sequence AS 'Sequence No.', MTH2V.DueDate AS 'Due Date', MTH2V.Ref AS 'Reference', MTH2V.DebAmount AS 'Debit Amount', MTH2V.Memo AS 'Details' FROM MTH2V AS MTH2V

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