| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | ReconNum | Reconciliation Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | IsCard | BP or Account | char | 1 | 0 | | | A, C | Allow NULL? |
| 3 | ReconType | Reconciliation Type | nvarchar | 2 | 0 | | | 0, 1, 10, 11, 12, 13, 14, 15, 16, 2, 3, 4, 5, 6, 7, 8, 9 | Allow NULL? |
| 4 | ReconDate | Reconciliation Date | date | 8 | 0 | | | | |
| 5 | Total | Total Reconciliation Amount | num | 19 | 6 | | | | Allow NULL? |
| 6 | ReconCurr | Reconciliation Currency | nvarchar | 3 | 0 | OCRN | | | Allow NULL? |
| 7 | Canceled | Cancelled | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 8 | CancelAbs | Canceling/-ed Reconciliation | int | 11 | 0 | OITR | 0 | | Allow NULL? |
| 9 | IsSystem | System or Manual | char | 1 | 0 | | | N, Y | Allow NULL? |
| 10 | InitObjTyp | Reconc. Initiator Object Type | nvarchar | 20 | 0 | | | | Allow NULL? |
| 11 | InitObjAbs | Reconc. Initiator Internal ID | int | 11 | 0 | | | | Allow NULL? |
| 12 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 13 | CreateTime | Creation Time | int | 6 | 0 | | | | Allow NULL? |
| 14 | DataSource | Data Source | char | 1 | 0 | | N | A, D, I, M, N, O, P, T, U | Allow NULL? |
| 15 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 16 | ReconRule1 | Reconciliation Rule 1 | nvarchar | 2 | 0 | | | 0, 1, 2, 3, 4, 5, 6, 7, 8 | Allow NULL? |
| 17 | ReconRule2 | Reconciliation Rule 2 | nvarchar | 2 | 0 | | | 0, 1, 2, 3, 4, 5, 6, 7, 8 | Allow NULL? |
| 18 | ReconRule3 | Reconciliation Rule 3 | nvarchar | 2 | 0 | | | 0, 1, 2, 3, 4, 5, 6, 7, 8 | Allow NULL? |
| 19 | IsMultiBP | Multiple BP Reconciliation | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 20 | VersionNum | Version Number | nvarchar | 11 | 0 | | | | Allow NULL? |
| 21 | OldMatNum | Previous Reconciliation Number | int | 11 | 0 | | 0 | | Allow NULL? |
| 22 | ReconJEId | JE no. created by reconciliatn | int | 11 | 0 | | | | Allow NULL? |
| 23 | BuildDesc | Build Descriptor | nvarchar | 50 | 0 | | | | Allow NULL? |
| 24 | BPLId | Branch | int | 11 | 0 | OBPL | | | Allow NULL? |
| 25 | BPLName | Branch Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 26 | VATRegNum | VAT Reg. Number | nvarchar | 32 | 0 | | | | Allow NULL? |
