|
|
DTW Document
API Report Layouts Service / Report Layout
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocCode KEY UNIQUE | Code | nVarChar | 8 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| DocName | Name | nVarChar | 120 | |||||
| Author | Author | nVarChar | 127 | |||||
| Notes | Remarks | nVarChar | 127 | |||||
| Width | Width | Int | 6 | 595 | ||||
| Height | Height | Int | 6 | 842 | ||||
| LMargin | Left Margin | Int | 6 | 10 | ||||
| RMargin | Right Margin | Int | 6 | 30 | ||||
| TMargin | Top Margin | Int | 6 | 10 | ||||
| BMargin | Bottom Margin | Int | 6 | 10 | ||||
| CanChange | Changeable | VarChar | Y) Yes N) No | 1 | Y | |||
| PaperSize | Paper Size | nVarChar | 100 | A4 | ||||
| Oreint | Orientation | VarChar | P) Vertical L) Horizontal | 1 | P | |||
| GridSize | Grid Size | Int | 6 | 10 | ||||
| GridType | Grid Type | VarChar | 1) Combination 2) Continuous Line 3) Broken Line 4) Dots | 1 | 1 | |||
| ShowGrid | Display Grid | VarChar | Y) Yes N) No | 1 | Y | |||
| SnapGrid | Next to Grid | VarChar | Y) Yes N) No | 1 | Y | |||
| Picture | Picture | Text | 16 | |||||
| TypeCode KEY | Type Code | nVarChar | 4 | TYPENAME | No | |||
| FrgnReport | Foreign Language Report | VarChar | Y) Yes N) No | 1 | N | |||
| CanSort | Sortable | VarChar | Y) Yes N) No | 1 | Y | |||
| LeaderCode | Leader Report | nVarChar | 8 | |||||
| FollowCode | Follow-Up Report | nVarChar | 8 | |||||
| SwapOnScrn | Convert Font in Print Preview | VarChar | Y) Yes N) No | 1 | N | |||
| ScreenFont | Preview Printing Font | nVarChar | 50 | Arial | ||||
| ScrFOffset | Change Font Size in Print Preview | Int | 6 | -1 | ||||
| SwpInEmail | Convert Font for E-Mail | VarChar | Y) Yes N) No | 1 | N | |||
| EmailFont | E-Mail Font | nVarChar | 50 | Arial | ||||
| EmFOffset | Change Font Size for E-Mail | Int | 6 | -1 | ||||
| QString | Query | Text | 16 | |||||
| QType | Query Type | VarChar | R) Regular W) Wizard | 1 | R | |||
| Language | Language | Int | 11 | OLNG User Language Table | ||||
| RobjCode | Imp Exp Obj Code | Int | 11 | 0 | ||||
| ExtName | Extension Name | Text | 16 | |||||
| ExtOnErr | Action for extension error | VarChar | S) Stop I) Ignore P) Prompt | 1 | S | |||
| NumRepArs | Number of Repetitive Areas | Int | 6 | 1 | ||||
| AlgnFooter | Allign Footer to Buttom | VarChar | Y) Yes N) No | 1 | N | |||
| TimeFormat | Time Template | VarChar | 0 1) 24H 2) 12H | 1 | 0 | |||
| DateFormat | Date Template | VarChar | 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 | |||
| DateSep | Date Separator | VarChar | 1 | |||||
| DecSep | Decimal Separator | VarChar | 1 | |||||
| ThousSep | Thousands Separator | VarChar | 1 | |||||
| Printer | Printer | nVarChar | 100 | |||||
| NumLayPage | Number of Layout Pages | Int | 11 | |||||
| NumCopy | Number of Copies | Int | 11 | 1 | ||||
| GbiSupport | GBI Settings Supported | VarChar | Y) Yes N) No | 1 | N | |||
| Use1stPrtr | Use 1st Page Printer | VarChar | Y) Yes N) No | 1 | N | |||
| Prtr1st | Printer for First Page | nVarChar | 100 | |||||
| Shading | Print Item Backgrounds | VarChar | Y) Yes N) No | 1 | Y | |||
| Template | Report Binary Data | Text | 16 | |||||
| Category | Category | VarChar | P) PLD C) Crystal Reports L) Legal List A) Partner Type | 1 | P | |||
| CreateDate | Creation Date | Date | 8 | |||||
| UpdateDate | Date of Update | Date | 8 | |||||
| UserSign | User Signature | Int | 6 | |||||
| UserSign2 | Updating User | Int | 6 | |||||
| Status | Status | VarChar | A) Active I) Inactive | 1 | A | |||
| B1Version | Required B1 Version | nVarChar | 20 | |||||
| CRVersion | Required Crystal Version | nVarChar | 20 | |||||
| Local | Localization | nVarChar | 2 | |||||
| UseSysPref | Use System Preference | VarChar | Y) Yes N) No | 1 | Y | |||
| ForMobile | Visible For Mobile | VarChar | Y) Yes N) No | 1 | Y | |||
| TypeDetail | Type | nVarChar | 127 | |||||
| IsIMCE | Powered by SAP HANA | VarChar | Y) Yes N) No | 1 | N | |||
| CsUrl | URL in Crystal Server | nVarChar | 127 | |||||
| RptHash | Hash for Report | nVarChar | 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
ReportLayoutsService
Object
ReportLayout
Collection
Enumeration
Method
Property
Author
DB
B1Version
DB
BottomMargin
DB
Category
DB
CRVersion
DB
Editable
DB
EMailFont
DB
GridSize
DB
GridType
DB
Height
DB
language
DB
LayoutCode
DB
LeaderReport
DB
LeftMargin
DB
Localization
DB
Name
DB
Orientation
DB
PaperSize
DB
Picture
DB
Printer
DB
Query
DB
QueryType
DB
Remarks
DB
RightMargin
DB
ShowGrid
DB
SnapToGrid
DB
Sortable
DB
TopMargin
DB
TypeCode
DB
Width
DB
Method
Property
Name
9.0 DB
ProblemTypeID
9.0 DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates