📚 SAP Business One SDK Help

Table Name: RDOC

Table Description: Document

Field Description Type Size Related Default Value Constraints
DocCode Code nVarChar 8 -      
DocName Name nVarChar 120 -      
Author Author nVarChar 155 -      
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 Changeable VarChar 1 - Y Y Yes
            N No
PaperSize Paper Size nVarChar 100 - A4    
Oreint Orientation VarChar 1 - P P Vertical
            L Horizontal
GridSize Grid Size Int 6 - 10    
GridType Grid Type VarChar 1 - 1 1 Combination
            2 Continuous Line
            3 Broken Line
            4 Dots
ShowGrid Display Grid VarChar 1 - Y Y Yes
            N No
SnapGrid Next to Grid VarChar 1 - Y Y Yes
            N No
Picture Picture Text 16 -      
TypeCode Type Code nVarChar 4 -      
FrgnReport Foreign Language Report VarChar 1 - N Y Yes
            N No
CanSort Sortable VarChar 1 - Y Y Yes
            N No
LeaderCode Leader Report nVarChar 8 -      
FollowCode Follow-Up Report nVarChar 8 -      
SwapOnScrn Convert Font in Print Preview VarChar 1 - N Y Yes
            N No
ScreenFont Preview Printing Font nVarChar 50 - Arial    
ScrFOffset Change Font Size in Print Preview Int 6 - -1    
SwpInEmail Convert Font for E-Mail VarChar 1 - N Y Yes
            N No
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 11 OLNG      
RobjCode Imp Exp Obj Code Int 11 - 0    
ExtName Extension Name Text 16 -      
ExtOnErr Action for extension error VarChar 1 - S S Stop
            I Ignore
            P Prompt
NumRepArs Number of Repetitive Areas Int 6 - 1    
AlgnFooter Allign Footer to Buttom VarChar 1 - N Y Yes
            N No
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
Template Report Binary Data Text 16 -      
Category Category VarChar 1 - P P PLD
            C Crystal Reports
            L Legal List
            A Partner Type
            E Electronic Files
CreateDate Creation Date Date 8 -      
UpdateDate Date of Update Date 8 -      
UserSign User Signature Int 6 -      
UserSign2 Updating User Int 6 -      
Status Status VarChar 1 - A A Active
            I Inactive
B1Version Required B1 Version nVarChar 20 -      
CRVersion Required Crystal Version nVarChar 20 -      
Local Localization nVarChar 2 -      
UseSysPref Use System Preference VarChar 1 - Y Y Yes
            N No
ForMobile Visible For Mobile VarChar 1 - Y Y Yes
            N No
TypeDetail Type nVarChar 254 -      
IsIMCE Powered by SAP HANA VarChar 1 - N Y Yes
            N No
CsUrl URL in Crystal Server nVarChar 254 -      
RptHash Hash for Report nVarChar 254 -      
Key Unique Field
PRIMARY Yes DocCode
TYPE No TypeCode
TYPENAME No TypeCode
    DocName