| 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=G/L Account, C=BP | Allow NULL? |
| 3 | ReconType | Reconciliation Type | nvarchar | 2 | 0 | | | 0=Manual, 10=Bank Statement Processing, 11=Period Closing, 12=Correction Invoice, 1=Automatic, 2=Semi-Automatic, 3=Payment, 4=Credit Memo, 5=Reversal, 6=Zero Value, 7=Cancellation, 8=BoE, 9=Deposit | 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=No, Y=Yes | Allow NULL? |
| 8 | CancelAbs | Canceling/-ed Reconciliation | int | 11 | 0 | OITR | 0 | | Allow NULL? |
| 9 | IsSystem | System or Manual | char | 1 | 0 | | | N=No, Y=Yes | 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=Auto Incr., D=Data Doc., I=Interface, M=Import, N=Unknown, O=OBServer, P=Partner Implementation, T=Year Transfer, U=Update | Allow NULL? |
| 15 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 16 | ReconRule1 | Reconciliation Rule 1 | nvarchar | 2 | 0 | | | 0=Posting Date, 1=Due Date, 2=Document Date, 3=Ref. 1, 4=Ref. 2, 5=Ref. 3, 6=Project Code, 7=Control Account Code, 8=Posting Period | Allow NULL? |
| 17 | ReconRule2 | Reconciliation Rule 2 | nvarchar | 2 | 0 | | | 0=Posting Date, 1=Due Date, 2=Document Date, 3=Ref. 1, 4=Ref. 2, 5=Ref. 3, 6=Project Code, 7=Control Account Code, 8=Posting Period | Allow NULL? |
| 18 | ReconRule3 | Reconciliation Rule 3 | nvarchar | 2 | 0 | | | 0=Posting Date, 1=Due Date, 2=Document Date, 3=Ref. 1, 4=Ref. 2, 5=Ref. 3, 6=Project Code, 7=Control Account Code, 8=Posting Period | Allow NULL? |
| 19 | IsMultiBP | Multiple BP Reconciliation | char | 1 | 0 | | N | N=No, Y=Yes | 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? |
