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

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocCodeCodenVarChar
8
DocNameReport NamenVarChar
64
AuthorAuthornVarChar
32
NotesRemarksnVarChar
127
WidthWidthInt
6
595
HeightHeightInt
6
842
LMarginLeft MarginInt
6
10
RMarginRight MarginInt
6
30
TMarginTop MarginInt
6
10
BMarginBottom MarginInt
6
10
CanChangeChangableInt
1) TRUE
0
6
1
PaperSizePaper SizenVarChar
100
A4 210 x 297 mm
OreintOrientationVarChar
P) Vertical
L) Horizontal
1
P
GridSizeGrid SizeInt
6
10
GridTypeGrid TypeVarChar
1) Compbination
2) Continuous line
3) Broken line
4) Dots
1
1
ShowGridDisplay GridVarChar
1) TRUE
0
1
1
SnapGridNext to GridVarChar
1) TRUE
0
1
1
PicturePictureText
16
TypeCode KEYType CodenVarChar
4
TYPENo
FrgnReportForeign Language ReportVarChar
1) TRUE
0
1
0
CanSortSortableInt
1) TRUE
0
6
1
LeaderCodeLeader ReportnVarChar
8
FollowCodeFollow-Up ReportnVarChar
8
SwapOnScrnConvert Font in Print PreviewInt
1) Yes
0
6
0
ScreenFontPreview Printing FontnVarChar
50
Arial
ScrFOffsetChange Font Size in Preview PrInt
6
-1
SwpInEmailConvert Font for E-mailInt
1) Yes
0
6
0
EmailFontE-Mail FontnVarChar
50
Arial
EmFOffsetChange Font Size for E-MailInt
6
-1
QStringQueryText
16
QTypeQuery TypeVarChar
R) Regular
W) Wizard
1
R
LanguageLanguageInt
6
RobjCodeImp Exp Obj CodeInt
11
0
ExtNameExtension NameText
16
ExtOnErrAction Taken On Ext ErrorVarChar
S) Stop
I) Ignore
P) Promt
1
S
NumRepArsNumber of Repetitive AreasInt
6
1
AlgnFooterAllign Footer to ButtomVarChar
Y) Yes
N) No
1
N
LocalLocalizationnVarChar
2
NumeratorNumeratorInt
6
NextAppIdNext Item AppIdInt
6
1
CreatedCreation DateDate
8
UpdatedUpdated DateDate
8
UsrSgnStrUser Sign For Strings ChangeInt
11
-1
UsrSgnAttrUser Sign For Attribs ChangeInt
11
-1
TimeFormatTime TemplateVarChar
0
1) 24H
2) 12H
1
0
DateFormatDate TemplateVarChar
0
1) DD/MM/YY
2) DD/MM/CCYY
3) MM/DD/YY
4) MM/DD/CCYY
5) CCYY/MM/DD
6) DD/Month/YYYY
1
0
DateSepDate SeparatorVarChar
1
DecSepDecimal SeparatorVarChar
1
ThousSepThousands SeparatorVarChar
1
PrinterPrinternVarChar
100
NumLayPageNumber of Layout PagesInt
11
NumCopyNumber of CopiesInt
11
1
GbiSupportGBI settings supportedVarChar
Y) Yes
N) No
1
N
Use1stPrtrUse 1st page printerVarChar
Y) Yes
N) No
1
N
Prtr1stPrinter for First PagenVarChar
100
ShadingPrint item backgroundsVarChar
Y) Yes
N) No
1
Y
ForceExpXXForce Export XX ReportVarChar
Y) Yes
N) No
1
N
ResCodeResource Code from RSBDInt
11
-1
RevCodeRevision CodeInt
11
-1
UseSysPrefUse System PreferenceVarChar
Y) Yes
N) No
1
Y

SELECT statement

SELECT DOCR.DocCode AS 'Code', DOCR.DocName AS 'Report Name', DOCR.Author AS 'Author', DOCR.Notes AS 'Remarks', DOCR.Width AS 'Width', DOCR.Height AS 'Height', DOCR.LMargin AS 'Left Margin', DOCR.RMargin AS 'Right Margin', DOCR.TMargin AS 'Top Margin', DOCR.BMargin AS 'Bottom Margin', DOCR.CanChange AS 'Changable', DOCR.PaperSize AS 'Paper Size', DOCR.Oreint AS 'Orientation', DOCR.GridSize AS 'Grid Size', DOCR.GridType AS 'Grid Type', DOCR.ShowGrid AS 'Display Grid', DOCR.SnapGrid AS 'Next to Grid', DOCR.Picture AS 'Picture', DOCR.TypeCode AS 'Type Code', DOCR.FrgnReport AS 'Foreign Language Report', DOCR.CanSort AS 'Sortable', DOCR.LeaderCode AS 'Leader Report', DOCR.FollowCode AS 'Follow-Up Report', DOCR.SwapOnScrn AS 'Convert Font in Print Preview', DOCR.ScreenFont AS 'Preview Printing Font', DOCR.ScrFOffset AS 'Change Font Size in Preview Pr', DOCR.SwpInEmail AS 'Convert Font for E-mail', DOCR.EmailFont AS 'E-Mail Font', DOCR.EmFOffset AS 'Change Font Size for E-Mail', DOCR.QString AS 'Query', DOCR.QType AS 'Query Type', DOCR.Language AS 'Language', DOCR.RobjCode AS 'Imp Exp Obj Code', DOCR.ExtName AS 'Extension Name', DOCR.ExtOnErr AS 'Action Taken On Ext Error', DOCR.NumRepArs AS 'Number of Repetitive Areas', DOCR.AlgnFooter AS 'Allign Footer to Buttom', DOCR.Local AS 'Localization', DOCR.Numerator AS 'Numerator', DOCR.NextAppId AS 'Next Item AppId', DOCR.Created AS 'Creation Date', DOCR.Updated AS 'Updated Date', DOCR.UsrSgnStr AS 'User Sign For Strings Change', DOCR.UsrSgnAttr AS 'User Sign For Attribs Change', DOCR.TimeFormat AS 'Time Template', DOCR.DateFormat AS 'Date Template', DOCR.DateSep AS 'Date Separator', DOCR.DecSep AS 'Decimal Separator', DOCR.ThousSep AS 'Thousands Separator', DOCR.Printer AS 'Printer', DOCR.NumLayPage AS 'Number of Layout Pages', DOCR.NumCopy AS 'Number of Copies', DOCR.GbiSupport AS 'GBI settings supported', DOCR.Use1stPrtr AS 'Use 1st page printer', DOCR.Prtr1st AS 'Printer for First Page', DOCR.Shading AS 'Print item backgrounds', DOCR.ForceExpXX AS 'Force Export XX Report', DOCR.ResCode AS 'Resource Code from RSBD', DOCR.RevCode AS 'Revision Code', DOCR.UseSysPref AS 'Use System Preference' FROM DOCR AS DOCR

Related information




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