|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Reconciliation History
Table Name: OMTH
Table Description: Reconciliation History
| 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 | - | Â | Â | Â |
| Totals | Recon. Amount (One Side) | Num | 19.6 | - | Â | Â | Â |
| IsCard | Select BP or Account | VarChar | 1 | - | A | A | G/L Account |
| Â | Â | Â | Â | Â | Â | C | BP |
| MatchType | Reconciliation Type | nVarChar | 2 | - | 0 | 0 | Manual |
| Â | Â | Â | Â | Â | Â | 1 | Ref. 1 |
| Â | Â | Â | Â | Â | Â | 2 | Ref. 2 |
| Â | Â | Â | Â | Â | Â | 3 | Ref. 3 |
| Â | Â | Â | Â | Â | Â | 4 | Posting Date |
| Â | Â | Â | Â | Â | Â | 5 | Due Date |
| Â | Â | Â | Â | Â | Â | 6 | Ref. 1 + Posting Date |
| Â | Â | Â | Â | Â | Â | 7 | Ref. 2 + Posting Date |
| Â | Â | Â | Â | Â | Â | 8 | Ref. 3 + Posting Date |
| Â | Â | Â | Â | Â | Â | 9 | Ref. 1 + Due Date |
| Â | Â | Â | Â | Â | Â | 10 | Ref. 2 + Due Date |
| Â | Â | Â | Â | Â | Â | 11 | Ref. 3 + Due Date |
| Â | Â | Â | Â | Â | Â | 12 | By Total |
| TransId | Reconciliation Transaction No. | Int | 11 | - | -1 | Â | Â |
| MatchDate | Reconciliation Date | Date | 8 | - | Â | Â | Â |
| CurrType | Currency Type | nVarChar | 3 | - | Â | Â | Â |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | I | Interface |
| Â | Â | Â | Â | Â | Â | U | Update |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | A | Doc. Generation Wizard |
| Â | Â | Â | Â | Â | Â | D | Restore Wizard |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year Transfer |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| createDate | Creation Date | Date | 8 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | MthAcctCod |
| Â | Â | IsInternal |
| Â | Â | MatchNum |