biuan SAP® BUSINESS ONE SDK
DTW Document
API Report Layouts Service / Report Layout
RDOC - Document Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocCode KEY UNIQUECodenVarChar
8
PRIMARYYes
DocNameNamenVarChar
120
AuthorAuthornVarChar
127
NotesRemarksnVarChar
127
WidthWidthInt
6
595
HeightHeightInt
6
842
LMarginLeft MarginInt
6
10
RMarginRight MarginInt
6
30
TMarginTop MarginInt
6
10
BMarginBottom MarginInt
6
10
CanChangeChangeableVarChar
Y) Yes
N) No
1
Y
PaperSizePaper SizenVarChar
100
A4
OreintOrientationVarChar
P) Vertical
L) Horizontal
1
P
GridSizeGrid SizeInt
6
10
GridTypeGrid TypeVarChar
1) Combination
2) Continuous Line
3) Broken Line
4) Dots
1
1
ShowGridDisplay GridVarChar
Y) Yes
N) No
1
Y
SnapGridNext to GridVarChar
Y) Yes
N) No
1
Y
PicturePictureText
16
TypeCode KEYType CodenVarChar
4
TYPENAMENo
FrgnReportForeign Language ReportVarChar
Y) Yes
N) No
1
N
CanSortSortableVarChar
Y) Yes
N) No
1
Y
LeaderCodeLeader ReportnVarChar
8
FollowCodeFollow-Up ReportnVarChar
8
SwapOnScrnConvert Font in Print PreviewVarChar
Y) Yes
N) No
1
N
ScreenFontPreview Printing FontnVarChar
50
Arial
ScrFOffsetChange Font Size in Print PreviewInt
6
-1
SwpInEmailConvert Font for E-MailVarChar
Y) Yes
N) No
1
N
EmailFontE-Mail FontnVarChar
50
Arial
EmFOffsetChange Font Size for E-MailInt
6
-1
QStringQueryText
16
QTypeQuery TypeVarChar
R) Regular
W) Wizard
1
R
LanguageLanguageInt
11OLNG
User Language Table
RobjCodeImp Exp Obj CodeInt
11
0
ExtNameExtension NameText
16
ExtOnErrAction for extension errorVarChar
S) Stop
I) Ignore
P) Prompt
1
S
NumRepArsNumber of Repetitive AreasInt
6
1
AlgnFooterAllign Footer to ButtomVarChar
Y) Yes
N) No
1
N
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
TemplateReport Binary DataText
16
CategoryCategoryVarChar
P) PLD
C) Crystal Reports
L) Legal List
A) Partner Type
1
P
CreateDateCreation DateDate
8
UpdateDateDate of UpdateDate
8
UserSignUser SignatureInt
6
UserSign2Updating UserInt
6
StatusStatusVarChar
A) Active
I) Inactive
1
A
B1VersionRequired B1 VersionnVarChar
20
CRVersionRequired Crystal VersionnVarChar
20
LocalLocalizationnVarChar
2
UseSysPrefUse System PreferenceVarChar
Y) Yes
N) No
1
Y
ForMobileVisible For MobileVarChar
Y) Yes
N) No
1
Y
TypeDetailTypenVarChar
127
IsIMCEPowered by SAP HANAVarChar
Y) Yes
N) No
1
N
CsUrlURL in Crystal ServernVarChar
127
RptHashHash for ReportnVarChar
127

Table relationship map

SELECT statement

SELECT RDOC.DocCode AS 'Code', RDOC.DocName AS 'Name', RDOC.Author AS 'Author', RDOC.Notes AS 'Remarks', RDOC.Width AS 'Width', RDOC.Height AS 'Height', RDOC.LMargin AS 'Left Margin', RDOC.RMargin AS 'Right Margin', RDOC.TMargin AS 'Top Margin', RDOC.BMargin AS 'Bottom Margin', RDOC.CanChange AS 'Changeable', RDOC.PaperSize AS 'Paper Size', RDOC.Oreint AS 'Orientation', RDOC.GridSize AS 'Grid Size', RDOC.GridType AS 'Grid Type', RDOC.ShowGrid AS 'Display Grid', RDOC.SnapGrid AS 'Next to Grid', RDOC.Picture AS 'Picture', RDOC.TypeCode AS 'Type Code', RDOC.FrgnReport AS 'Foreign Language Report', RDOC.CanSort AS 'Sortable', RDOC.LeaderCode AS 'Leader Report', RDOC.FollowCode AS 'Follow-Up Report', RDOC.SwapOnScrn AS 'Convert Font in Print Preview', RDOC.ScreenFont AS 'Preview Printing Font', RDOC.ScrFOffset AS 'Change Font Size in Print Preview', RDOC.SwpInEmail AS 'Convert Font for E-Mail', RDOC.EmailFont AS 'E-Mail Font', RDOC.EmFOffset AS 'Change Font Size for E-Mail', RDOC.QString AS 'Query', RDOC.QType AS 'Query Type', RDOC.Language AS 'Language', RDOC.RobjCode AS 'Imp Exp Obj Code', RDOC.ExtName AS 'Extension Name', RDOC.ExtOnErr AS 'Action for extension error', RDOC.NumRepArs AS 'Number of Repetitive Areas', RDOC.AlgnFooter AS 'Allign Footer to Buttom', RDOC.TimeFormat AS 'Time Template', RDOC.DateFormat AS 'Date Template', RDOC.DateSep AS 'Date Separator', RDOC.DecSep AS 'Decimal Separator', RDOC.ThousSep AS 'Thousands Separator', RDOC.Printer AS 'Printer', RDOC.NumLayPage AS 'Number of Layout Pages', RDOC.NumCopy AS 'Number of Copies', RDOC.GbiSupport AS 'GBI Settings Supported', RDOC.Use1stPrtr AS 'Use 1st Page Printer', RDOC.Prtr1st AS 'Printer for First Page', RDOC.Shading AS 'Print Item Backgrounds', RDOC.Template AS 'Report Binary Data', RDOC.Category AS 'Category', RDOC.CreateDate AS 'Creation Date', RDOC.UpdateDate AS 'Date of Update', RDOC.UserSign AS 'User Signature', RDOC.UserSign2 AS 'Updating User', RDOC.Status AS 'Status', RDOC.B1Version AS 'Required B1 Version', RDOC.CRVersion AS 'Required Crystal Version', RDOC.Local AS 'Localization', RDOC.UseSysPref AS 'Use System Preference', RDOC.ForMobile AS 'Visible For Mobile', RDOC.TypeDetail AS 'Type', RDOC.IsIMCE AS 'Powered by SAP HANA', RDOC.CsUrl AS 'URL in Crystal Server', RDOC.RptHash AS 'Hash for Report' FROM RDOC AS RDOC

Related information


Report Layout ReportLayout Object· Table: RDOC
Represents a layout for PLD or a layout/report for Crystal Reports. Source table: RDOC
   Parent: Report Layouts Service ReportLayoutsService Service· Table: RDOC

Report Layouts Service ReportLayoutsService Service· Table: RDOC
The ReportLayoutsService service enables you to do the following: Copy a PLD report layout from one company to another. Add a Crystal Reports layout or standalone report. Source table: RDOC (report layouts) and RDFL (associates default...

RDOC SQL Table

User Language Table OLNG 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