| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | WizardId | Wizard ID | int | 11 | 0 | | | | Allow NULL? |
| 2 | WizardName | Wizard Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 3 | FromDate | From Date | date | 8 | 0 | | | | |
| 4 | ToDate | To Date | date | 8 | 0 | | | | |
| 5 | PFromDate | Previous Year From Date | date | 8 | 0 | | | | |
| 6 | PToDate | Previous Year To Date | date | 8 | 0 | | | | |
| 7 | DateOfRun | Date of Run | date | 8 | 0 | | | | |
| 8 | Status | Status | char | 1 | 0 | | O | C=Closed, O=Open | Allow NULL? |
| 9 | ActYearCl | Classifictn in Actual Yr | char | 1 | 0 | | | L=Large, M=Medium, S=Small | Allow NULL? |
| 10 | FormFinSt | Form of Financial Statement | int | 11 | 0 | | 0 | 0, 1=Small GmbH (UGB Form 2,3), 2=Small GmbH with Balance Sheet, 3=Medium Large GmbH, 4=AG (Eng. PLC) | Allow NULL? |
| 11 | EBSTmpl | E-Balance Sheet Template | int | 11 | 0 | OFRT | | | Allow NULL? |
| 12 | EPaLTmpl | E-P&L Template | int | 11 | 0 | OFRT | | | Allow NULL? |
| 13 | OverwrFinS | Overwrite Financial Statement | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 14 | Reference | Reference | nvarchar | 25 | 0 | | | | Allow NULL? |
| 15 | HBCode | House Bank Code | int | 11 | 0 | DSC1 | | | Allow NULL? |
| 16 | PayRef | Payment Reference | nvarchar | 12 | 0 | | | | Allow NULL? |
| 17 | SndrRole | Sender Role | int | 11 | 0 | | 0 | 0, 1=1 - Sole Company Representative and Signatory, 2=2 - Sole Authorized Company Representative, 3=3 - One of Authorized Company Representatives | Allow NULL? |
| 18 | CRegNumber | Commercial Register Number | nvarchar | 7 | 0 | | | | Allow NULL? |
| 19 | LFBSheetD | Legal Form on Actl Bal Sht Dte | nvarchar | 3 | 0 | | | AG=Public Limited Company (AG), GEN=Industrial Cooperative Society, GES=Limited Liability Company (GmbH), KG=Limited Partnership, OG=Open Company, SC=European Cooperative Society (SCE), SE=Company under European Law (SE, Societa Europaea) | Allow NULL? |
| 20 | LFBSheetPr | Lgl Form on Bal Sht Dte Prv Yr | nvarchar | 3 | 0 | | | AG=Public Limited Company (AG), GEN=Industrial Cooperative Society, GES=Limited Liability Company (GmbH), KG=Limited Partnership, OG=Open Company, SC=European Cooperative Society (SCE), SE=Company under European Law (SE, Societa Europaea) | Allow NULL? |
| 21 | RegNum | Reg. No. of Partner Company | nvarchar | 7 | 0 | | | | Allow NULL? |
| 22 | CmpanyName | Company Name | text | 16 | 0 | | | | |
| 23 | XMLFile | XML File Storage | text | 16 | 0 | | | | |
| 24 | TimeOfRun | Time of Run | int | 6 | 0 | | | | Allow NULL? |
