|
|
API OEJB
OEJB - Wizard Run Details for ERV-JAb Table
OEJB SQL Table
Financial Report Templates OFRT SQL Table
House Bank Accounts DSC1 SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | WizardId KEY UNIQUE | Wizard ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| 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 | O) Open C) Closed | 1 | O | |||
| ActYearCl | Classifictn in Actual Yr | VarChar | 1 | |||||
| FormFinSt | Form of Financial Statement | Int | 0 1) Small GmbH (UGB Form 2,3) 2) Small GmbH with Balance Sheet 3) Medium Large GmbH 4) AG (Eng. PLC) | 11 | 0 | |||
| EBSTmpl | E-Balance Sheet Template | Int | 11 | OFRT Financial Report Templates | ||||
| EPaLTmpl | E-P&L Template | Int | 11 | OFRT Financial Report Templates | ||||
| OverwrFinS | Overwrite Financial Statement | VarChar | Y) Yes N) No | 1 | N | |||
| Reference | Reference | nVarChar | 25 | |||||
| HBCode | House Bank Code | Int | 11 | DSC1 House Bank Accounts | ||||
| PayRef | Payment Reference | nVarChar | 12 | |||||
| SndrRole | Sender Role | Int | 0 1) 1 - Sole Company Representative and Signatory 2) 2 - Sole Authorized Company Representative 3) 3 - One of Authorized Company Representatives | 11 | 0 | |||
| CRegNumber | Commercial Register Number | nVarChar | 7 | |||||
| LFBSheetD | Legal Form on Actl Bal Sht Dte | nVarChar | 3 | |||||
| LFBSheetPr | Lgl Form on Bal Sht Dte Prv Yr | nVarChar | 3 | |||||
| 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 |
Table relationship map
SELECT statement
SELECT
OEJB.WizardId AS 'Wizard ID',
OEJB.WizardName AS 'Wizard Name',
OEJB.FromDate AS 'From Date',
OEJB.ToDate AS 'To Date',
OEJB.PFromDate AS 'Previous Year From Date',
OEJB.PToDate AS 'Previous Year To Date',
OEJB.DateOfRun AS 'Date of Run',
OEJB.Status AS 'Status',
OEJB.ActYearCl AS 'Classifictn in Actual Yr',
OEJB.FormFinSt AS 'Form of Financial Statement',
OEJB.EBSTmpl AS 'E-Balance Sheet Template',
OEJB.EPaLTmpl AS 'E-P&L Template',
OEJB.OverwrFinS AS 'Overwrite Financial Statement',
OEJB.Reference AS 'Reference',
OEJB.HBCode AS 'House Bank Code',
OEJB.PayRef AS 'Payment Reference',
OEJB.SndrRole AS 'Sender Role',
OEJB.CRegNumber AS 'Commercial Register Number',
OEJB.LFBSheetD AS 'Legal Form on Actl Bal Sht Dte',
OEJB.LFBSheetPr AS 'Lgl Form on Bal Sht Dte Prv Yr',
OEJB.RegNum AS 'Reg. No. of Partner Company',
OEJB.CmpanyName AS 'Company Name',
OEJB.XMLFile AS 'XML File Storage',
OEJB.TimeOfRun AS 'Time of Run'
FROM OEJB AS OEJB
Related information
OEJB SQL Table
Financial Report Templates OFRT SQL Table
House Bank Accounts DSC1 SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
