|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Wizard Run Details for ERV-JAb
Table Name: OEJB
Table Description: Wizard Run Details for ERV-JAb
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| WizardId | Wizard ID | Int | 11 | - | Â | Â | Â |
| WizardName | Wizard Name | nVarChar | 100 | - | Â | Â | Â |
| FromDate | From Date | Date | 8 | - | Â | Â | Â |
| ToDate | To Date | Date | 8 | - | Â | Â | Â |
| PFromDate | Previous Year From Date | Date | 8 | - | Â | Â | Â |
| PToDate | Previous Year To Date | Date | 8 | - | Â | Â | Â |
| DateOfRun | Date of Run | Date | 8 | - | Â | Â | Â |
| Status | Status | VarChar | 1 | - | O | O | Open |
| Â | Â | Â | Â | Â | Â | C | Closed |
| ActYearCl | Classifictn in Actual Yr | VarChar | 1 | - | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | S | Small |
| Â | Â | Â | Â | Â | Â | M | Medium |
| Â | Â | Â | Â | Â | Â | L | Large |
| FormFinSt | Form of Financial Statement | Int | 11 | - | 0 | 0 | Â |
| Â | Â | Â | Â | Â | Â | 1 | Small GmbH (UGB Form 2,3) |
| Â | Â | Â | Â | Â | Â | 2 | Small GmbH with Balance Sheet |
| Â | Â | Â | Â | Â | Â | 3 | Medium Large GmbH |
| Â | Â | Â | Â | Â | Â | 4 | AG (Eng. PLC) |
| EBSTmpl | E-Balance Sheet Template | Int | 11 | OFRT | Â | Â | Â |
| EPaLTmpl | E-P&L Template | Int | 11 | OFRT | Â | Â | Â |
| OverwrFinS | Overwrite Financial Statement | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Reference | Reference | nVarChar | 25 | - | Â | Â | Â |
| HBCode | House Bank Code | Int | 11 | DSC1 | Â | Â | Â |
| PayRef | Payment Reference | nVarChar | 12 | - | Â | Â | Â |
| SndrRole | Sender Role | Int | 11 | - | 0 | 0 | Â |
| Â | Â | Â | Â | Â | Â | 1 | 1 - Sole Company Representative and Signatory |
| Â | Â | Â | Â | Â | Â | 2 | 2 - Sole Authorized Company Representative |
| Â | Â | Â | Â | Â | Â | 3 | 3 - One of Authorized Company Representatives |
| CRegNumber | Commercial Register Number | nVarChar | 7 | - | Â | Â | Â |
| LFBSheetD | Legal Form on Actl Bal Sht Dte | nVarChar | 3 | - | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | AG | Public Limited Company (AG) |
| Â | Â | Â | Â | Â | Â | SC | European Cooperative Society (SCE) |
| Â | Â | Â | Â | Â | Â | SE | Company under European Law (SE, Societa Europaea) |
| Â | Â | Â | Â | Â | Â | GEN | Industrial Cooperative Society |
| Â | Â | Â | Â | Â | Â | GES | Limited Liability Company (GmbH) |
| Â | Â | Â | Â | Â | Â | KG | Limited Partnership |
| Â | Â | Â | Â | Â | Â | OG | Open Company |
| LFBSheetPr | Lgl Form on Bal Sht Dte Prv Yr | nVarChar | 3 | - | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | AG | Public Limited Company (AG) |
| Â | Â | Â | Â | Â | Â | SC | European Cooperative Society (SCE) |
| Â | Â | Â | Â | Â | Â | SE | Company under European Law (SE, Societa Europaea) |
| Â | Â | Â | Â | Â | Â | GEN | Industrial Cooperative Society |
| Â | Â | Â | Â | Â | Â | GES | Limited Liability Company (GmbH) |
| Â | Â | Â | Â | Â | Â | KG | Limited Partnership |
| Â | Â | Â | Â | Â | Â | OG | Open Company |
| RegNum | Reg. No. of Partner Company | nVarChar | 7 | - | Â | Â | Â |
| CmpanyName | Company Name | Text | 16 | - | Â | Â | Â |
| XMLFile | XML File Storage | Text | 16 | - | Â | Â | Â |
| TimeOfRun | Time of Run | Int | 6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | WizardId |