|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Bank Statement - Matching Criteria
Table Name: OMTC
Table Description: Bank Statement - Matching Criteria
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| MatchID | Form Type Index | Int | 6 | - | 1 | 1 | Documents |
| Â | Â | Â | Â | Â | Â | 2 | Internal Reconciliation |
| Â | Â | Â | Â | Â | Â | 3 | External Reconciliation |
| Round | Rounding | Int | 6 | - | Â | 1 | Round 1 |
| Â | Â | Â | Â | Â | Â | 2 | Round 2 |
| Â | Â | Â | Â | Â | Â | 3 | Round 3 |
| Â | Â | Â | Â | Â | Â | Â | Â |
| MtcRule | Matching Rule | Int | 6 | - | 0 | Â | Â |
| MtcAlias | Matching Alias | nVarChar | 50 | - | Â | Â | Â |
| Differnce | Difference | Int | 11 | - | 0 | Â | Â |
| DiffAmnt | Amount Difference | Num | 19.6 | - | Â | Â | Â |
| RuleIndex | Rule Index | Int | 6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| MATCH_TYPE | Yes | MatchID |
| Â | Â | Round |
| Â | Â | RuleIndex |