|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Journal Entries of External Reconciliation
Table Name: MTH1V
Table Description: Journal Entries of External Reconciliation
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| MthAcctCod | Account Code | nVarChar | 15 | - | Â | Â | Â |
| IsInternal | Reconciliation Type | VarChar | 1 | - | E | I | Internal |
| Â | Â | Â | Â | Â | Â | E | External |
| MatchNum | Reconciliation No. | Int | 11 | - | Â | Â | Â |
| TransID | Transaction No. | Int | 11 | - | Â | Â | Â |
| Line_ID | Row Number | Int | 11 | - | Â | Â | Â |
| RefDate | Posting Date | Date | 8 | - | Â | Â | Â |
| DueDate | Due Date | Date | 8 | - | Â | Â | Â |
| Ref1 | Reference 1 | nVarChar | 200 | - | Â | Â | Â |
| Ref2 | Reference 2 | nVarChar | 200 | - | Â | Â | Â |
| Ref3Line | Reference 3 | nVarChar | 200 | - | Â | Â | Â |
| Debit | Debit Amount | Num | 19.6 | - | Â | Â | Â |
| Credit | Credit Amount | Num | 19.6 | - | Â | Â | Â |
| SYSDeb | System Debit Amount | Num | 19.6 | - | Â | Â | Â |
| SYSCred | System Credit Amount | Num | 19.6 | - | Â | Â | Â |
| FCDebit | Foreign Debit Amount | Num | 19.6 | - | Â | Â | Â |
| FCCredit | Foreign Credit Amount | Num | 19.6 | - | Â | Â | Â |
| Currency | Currency | nVarChar | 3 | - | Â | Â | Â |
| LineMemo | Row Details | nVarChar | 254 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | MthAcctCod |
| Â | Â | IsInternal |
| Â | Â | MatchNum |
| Â | Â | TransID |
| Â | Â | Line_ID |