biuan SAP® BUSINESS ONE SDK
API OWPK
OWPK - Dashboard Packages Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal KeyInt
11
PRIMARYYes
PackagCode KEY UNIQUEPackage CodenVarChar
32
CODEYes
PackagNamePackage NamenVarChar
100
NotePackage DescriptionText
16
ContentPackage ContentText
16
AuthorCreatornVarChar
32
VersionVersionnVarChar
13
CreateDateCreate DateDate
8
CreateTimeCreate TimeInt
6
IsSystemIs SystemVarChar
N) No
Y) Yes
1
N
PackagTypePackage TypeVarChar
D) Dashboard
M) Mobile
P) Pervasive
1
D
ISIMDBIS IMDBVarChar
N) No
Y) Yes
1
N
StraTypeStrategy TypenVarChar
127
none
StraParaStrategy ParametersnVarChar
127
SourceTypeQuery Source TypenVarChar
20
normal
ViewNameView's NamenVarChar
127
ViewCtgView's CatalognVarChar
127
ViewSynView's SynonymnVarChar
127
ViewidQuery NumberInt
11

SELECT statement

SELECT OWPK.AbsEntry AS 'Internal Key', OWPK.PackagCode AS 'Package Code', OWPK.PackagName AS 'Package Name', OWPK.Note AS 'Package Description', OWPK.Content AS 'Package Content', OWPK.Author AS 'Creator', OWPK.Version AS 'Version', OWPK.CreateDate AS 'Create Date', OWPK.CreateTime AS 'Create Time', OWPK.IsSystem AS 'Is System', OWPK.PackagType AS 'Package Type', OWPK.ISIMDB AS 'IS IMDB', OWPK.StraType AS 'Strategy Type', OWPK.StraPara AS 'Strategy Parameters', OWPK.SourceType AS 'Query Source Type', OWPK.ViewName AS 'View's Name', OWPK.ViewCtg AS 'View's Catalog', OWPK.ViewSyn AS 'View's Synonym', OWPK.Viewid AS 'Query Number' FROM OWPK AS OWPK

Related information


OWPK SQL Table



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