|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Filter for Query MTH
Table Name: MTH3V
Table Description: Filter for Query MTH
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| absEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| AcctCdeFrm | Account Code From | nVarChar | 15 | - | Â | Â | Â |
| AcctCdeTo | Account Code To | nVarChar | 15 | - | Â | Â | Â |
| IsInternal | Reconciliation Type | VarChar | 1 | - | E | I | Internal |
| Â | Â | Â | Â | Â | Â | E | External |
| IsCard | Select BP or Account | VarChar | 1 | - | A | A | G/L Account |
| Â | Â | Â | Â | Â | Â | C | BP |
| MatchNumFr | Reconciliation No. From | Int | 11 | - | Â | Â | Â |
| MatchNumTo | Reconciliation No. To | Int | 11 | - | Â | Â | Â |
| MthDateFrm | Reconciliation Date From | Date | 8 | - | Â | Â | Â |
| MthDateTo | Reconciliation Date To | Date | 8 | - | Â | Â | Â |
| MthAcctCod | Account Code | nVarChar | 15 | - | Â | Â | Â |
| MatchNum | Reconciliation No. | Int | 11 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | MthAcctCod |
| Â | Â | IsInternal |
| Â | Â | MatchNum |