| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBanking |
| 1 | OITR | Internal Reconciliation | 3 | ReconType | Reconciliation Type | nVarChar | 2 | 0 | | 0=Manual, 10=Bank Statement Processing, 11=Period Closing, 12=Correction Invoice, 13=Inventory/Expense Allocation, 14=WIP, 15=Deferred Tax Interim Account, 16=Down Payment Allocation, 17=Auto. Conversion Difference, 18=Interim Document, 1=Automatic, 2=Semi-Automatic, 3=Payment, 4=Credit Memo, 5=Reversal, 6=Zero Value, 7=Cancellation, 8=BoE |
