| 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 |