biuan SAP® BUSINESS ONE SDK
API OEJB
OEJB - Wizard Run Details for ERV-JAb Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WizardId KEY UNIQUEWizard IDInt
11
PRIMARYYes
WizardNameWizard NamenVarChar
100
FromDateFrom DateDate
8
ToDateTo DateDate
8
PFromDatePrevious Year From DateDate
8
PToDatePrevious Year To DateDate
8
DateOfRunDate of RunDate
8
StatusStatusVarChar
O) Open
C) Closed
1
O
ActYearClClassifictn in Actual YrVarChar
1
FormFinStForm of Financial StatementInt
0
1) Small GmbH (UGB Form 2,3)
2) Small GmbH with Balance Sheet
3) Medium Large GmbH
4) AG (Eng. PLC)
11
0
EBSTmplE-Balance Sheet TemplateInt
11OFRT
Financial Report Templates
EPaLTmplE-P&L TemplateInt
11OFRT
Financial Report Templates
OverwrFinSOverwrite Financial StatementVarChar
Y) Yes
N) No
1
N
ReferenceReferencenVarChar
25
HBCodeHouse Bank CodeInt
11DSC1
House Bank Accounts
PayRefPayment ReferencenVarChar
12
SndrRoleSender RoleInt
0
1) 1 - Sole Company Representative and Signatory
2) 2 - Sole Authorized Company Representative
3) 3 - One of Authorized Company Representatives
11
0
CRegNumberCommercial Register NumbernVarChar
7
LFBSheetDLegal Form on Actl Bal Sht DtenVarChar
3
LFBSheetPrLgl Form on Bal Sht Dte Prv YrnVarChar
3
RegNumReg. No. of Partner CompanynVarChar
7
CmpanyNameCompany NameText
16
XMLFileXML File StorageText
16
TimeOfRunTime of RunInt
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates