biuan SAP® BUSINESS ONE SDK
SQL Banking / Filter for Query MTH
API MTH3V
MTH3V - Filter for Query MTH Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
absEntryInternal NumberInt
11
AcctCdeFrmAccount Code FromnVarChar
15
AcctCdeToAccount Code TonVarChar
15
IsInternalReconciliation TypeVarChar
I) Internal
E) External
1
E
IsCardSelect BP or AccountVarChar
A) G/L Account
C) BP
1
A
MatchNumFrReconciliation No. FromInt
11
MatchNumToReconciliation No. ToInt
11
MthDateFrmReconciliation Date FromDate
8
MthDateToReconciliation Date ToDate
8
MthAcctCod KEY UNIQUEAccount CodenVarChar
15
PRIMARYYes
MatchNumReconciliation No.Int
11

SELECT statement

SELECT MTH3V.absEntry AS 'Internal Number', MTH3V.AcctCdeFrm AS 'Account Code From', MTH3V.AcctCdeTo AS 'Account Code To', MTH3V.IsInternal AS 'Reconciliation Type', MTH3V.IsCard AS 'Select BP or Account', MTH3V.MatchNumFr AS 'Reconciliation No. From', MTH3V.MatchNumTo AS 'Reconciliation No. To', MTH3V.MthDateFrm AS 'Reconciliation Date From', MTH3V.MthDateTo AS 'Reconciliation Date To', MTH3V.MthAcctCod AS 'Account Code', MTH3V.MatchNum AS 'Reconciliation No.' FROM MTH3V AS MTH3V

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