biuan SAP® BUSINESS ONE SDK
API SEWIC
SEWIC - SEWIC Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CompanyNamCompanyNamenVarChar
100
SmpTableIdSmp Table IDnVarChar
3
EwaSentDatEWA Sent DatenVarChar
10
EwaSentTimEWA Sent TimenVarChar
8
CustNumberCustomer NumberVarChar
1
CustNameCustomer NameVarChar
1
CustConPerCustomer contact personVarChar
1
CustEmailCustomer EmailnVarChar
100
PartnerNamPartner NamenVarChar
100
PartConPerPartnercontact personVarChar
1
PartEmailPartner EmailnVarChar
100
PartEmail2Partner Email 2VarChar
1
CompDbName KEY UNIQUECompany DB NamenVarChar
100
PRIMARYYes
CompDbVerCompnay DB VersionnVarChar
32
SentUserSent UsernVarChar
30
B1VersionB1 VersionnVarChar
32
B1SuppackB1 Support PacknVarChar
127
B1PatchB1 PatchnVarChar
127
UiApiVerUI API VersionnVarChar
32
InstallNumInstallation NumbernVarChar
127
SystemNumSystem NumbernVarChar
127
LicenseNumLicense NumbernVarChar
127
SystemStatSystem StatusVarChar
1
DbTypeDB TypenVarChar
64
DbVersionDB VersionnVarChar
32
CommLogPatSBo-Common Log PathnVarChar
127
CommLogSizSBO-Common Log SizeInt
11
CommRecovMSBO-Common Recovery ModelnVarChar
32
AOFrameworAddon FramworkVarChar
1
AODtwAddon DTWVarChar
1
AOSupToolsAddon Support ToolsnVarChar
12
AODateVAddon Date VnVarChar
12
AOAldAddon AldnVarChar
12
AOBcSetsAddon BC SetsnVarChar
12
AOElsterAddon ElsternVarChar
12
AOFixAssetAddon Fixed AssetsnVarChar
12
AOIntrStatAddon Intra StatnVarChar
12
AOOutlookIAddon Outlook integrationnVarChar
12
AOPayEnginAddon Payment EnginenVarChar
12
AOStampItAddon Stamp itnVarChar
12
CompRecovMCompany Recover ModelnVarChar
32

SELECT statement

SELECT SEWIC.CompanyNam AS 'CompanyName', SEWIC.SmpTableId AS 'Smp Table ID', SEWIC.EwaSentDat AS 'EWA Sent Date', SEWIC.EwaSentTim AS 'EWA Sent Time', SEWIC.CustNumber AS 'Customer Number', SEWIC.CustName AS 'Customer Name', SEWIC.CustConPer AS 'Customer contact person', SEWIC.CustEmail AS 'Customer Email', SEWIC.PartnerNam AS 'Partner Name', SEWIC.PartConPer AS 'Partnercontact person', SEWIC.PartEmail AS 'Partner Email', SEWIC.PartEmail2 AS 'Partner Email 2', SEWIC.CompDbName AS 'Company DB Name', SEWIC.CompDbVer AS 'Compnay DB Version', SEWIC.SentUser AS 'Sent User', SEWIC.B1Version AS 'B1 Version', SEWIC.B1Suppack AS 'B1 Support Pack', SEWIC.B1Patch AS 'B1 Patch', SEWIC.UiApiVer AS 'UI API Version', SEWIC.InstallNum AS 'Installation Number', SEWIC.SystemNum AS 'System Number', SEWIC.LicenseNum AS 'License Number', SEWIC.SystemStat AS 'System Status', SEWIC.DbType AS 'DB Type', SEWIC.DbVersion AS 'DB Version', SEWIC.CommLogPat AS 'SBo-Common Log Path', SEWIC.CommLogSiz AS 'SBO-Common Log Size', SEWIC.CommRecovM AS 'SBO-Common Recovery Model', SEWIC.AOFramewor AS 'Addon Framwork', SEWIC.AODtw AS 'Addon DTW', SEWIC.AOSupTools AS 'Addon Support Tools', SEWIC.AODateV AS 'Addon Date V', SEWIC.AOAld AS 'Addon Ald', SEWIC.AOBcSets AS 'Addon BC Sets', SEWIC.AOElster AS 'Addon Elster', SEWIC.AOFixAsset AS 'Addon Fixed Assets', SEWIC.AOIntrStat AS 'Addon Intra Stat', SEWIC.AOOutlookI AS 'Addon Outlook integration', SEWIC.AOPayEngin AS 'Addon Payment Engine', SEWIC.AOStampIt AS 'Addon Stamp it', SEWIC.CompRecovM AS 'Company Recover Model' FROM SEWIC AS SEWIC

Related information




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