📚 SAP Business One SDK Help

Table Name: DOCR

Field Description Type Size Related Default Value Constraints
DocCode Code nVarChar 8 -      
DocName Report Name nVarChar 64 -      
Author Author nVarChar 32 -      
Notes Remarks nVarChar 254 -      
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 Changable Int 6 - 1 1 TRUE
            0 FALSE
PaperSize Paper Size nVarChar 100 - A4 210 x 297 mm    
Oreint Orientation VarChar 1 - P P Vertical
            L Horizontal
GridSize Grid Size Int 6 - 10    
GridType Grid Type VarChar 1 - 1 1 Compbination
            2 Continuous line
            3 Broken line
            4 Dots
ShowGrid Display Grid VarChar 1 - 1 1 TRUE
            0 FALSE
SnapGrid Next to Grid VarChar 1 - 1 1 TRUE
            0 FALSE
Picture Picture Text 16 -      
TypeCode Type Code nVarChar 4 -      
FrgnReport Foreign Language Report VarChar 1 - 0 1 TRUE
            0 FALSE
CanSort Sortable Int 6 - 1 1 TRUE
            0 FALSE
LeaderCode Leader Report nVarChar 8 -      
FollowCode Follow-Up Report nVarChar 8 -      
SwapOnScrn Convert Font in Print Preview Int 6 - 0 1 Yes
            0 FALSE
ScreenFont Preview Printing Font nVarChar 50 - Arial    
ScrFOffset Change Font Size in Preview Pr Int 6 - -1    
SwpInEmail Convert Font for E-mail Int 6 - 0 1 Yes
            0 FALSE
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 1 - R R Regular
            W Wizard
Language Language Int 6 -      
RobjCode Imp Exp Obj Code Int 11 - 0    
ExtName Extension Name Text 16 -      
ExtOnErr Action Taken On Ext Error VarChar 1 - S S Stop
            I Ignore
            P Promt
NumRepArs Number of Repetitive Areas Int 6 - 1    
AlgnFooter Allign Footer to Buttom VarChar 1 - N Y Yes
            N No
Local Localization nVarChar 2 -      
Numerator Numerator Int 6 -      
NextAppId Next Item AppId Int 6 - 1    
Created Creation Date Date 8 -      
Updated Updated Date Date 8 -      
UsrSgnStr User Sign For Strings Change Int 11 - -1    
UsrSgnAttr User Sign For Attribs Change Int 11 - -1    
TimeFormat Time Template VarChar 1 - 0 0 Default
            1 24H
            2 12H
DateFormat Date Template VarChar 1 - 0 0 Default
            1 DD/MM/YY
            2 DD/MM/CCYY
            3 MM/DD/YY
            4 MM/DD/CCYY
            5 CCYY/MM/DD
            6 DD/Month/YYYY
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 1 - N Y Yes
            N No
Use1stPrtr Use 1st page printer VarChar 1 - N Y Yes
            N No
Prtr1st Printer for First Page nVarChar 100 -      
Shading Print item backgrounds VarChar 1 - Y Y Yes
            N No
ForceExpXX Force Export XX Report VarChar 1 - N Y Yes
            N No
ResCode Resource Code from RSBD Int 11 - -1    
RevCode Revision Code Int 11 - -1    
UseSysPref Use System Preference VarChar 1 - Y Y Yes
            N No
Key Unique Field
PRIMARY Yes TypeCode
    Local
    Numerator
    Language
    ResCode
    RevCode
TYP_LOC_NM No TypeCode
    Local
    Numerator
TYPE_LOC No TypeCode
    Local
TYPE No TypeCode