| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MthAcctCod | Account Code | nvarchar | 15 | 0 | | | | Allow NULL? |
| 2 | IsInternal | Reconciliation Type | char | 1 | 0 | | E | E=External, I=Internal | Allow NULL? |
| 3 | MatchNum | Reconciliation No. | int | 11 | 0 | | | | Allow NULL? |
| 4 | Totals | Recon. Amount (One Side) | num | 19 | 6 | | | | Allow NULL? |
| 5 | IsCard | Select BP or Account | char | 1 | 0 | | A | A=G/L Account, C=BP | Allow NULL? |
| 6 | MatchType | Reconciliation Type | nvarchar | 2 | 0 | | 0 | 0=Manual, 10=Ref. 2 + Due Date, 11=Ref. 3 + Due Date, 12=By Total, 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 | Allow NULL? |
| 7 | TransId | Reconciliation Transaction No. | int | 11 | 0 | | -1 | | Allow NULL? |
| 8 | MatchDate | Reconciliation Date | date | 8 | 0 | | | | |
| 9 | CurrType | Currency Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | DataSource | Data Source | char | 1 | 0 | | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update | Allow NULL? |
| 11 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 12 | createDate | Creation Date | date | 8 | 0 | | | | |
