biuan SAP® BUSINESS ONE SDK
SQL Administration / User Defaults / User Defaults - Documents
DTW Administration / Setup / General / User Default Groups / User Defaults - Documents
API User Default Groups / Default Documents
UDG1 - User Defaults - Documents Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodenVarChar
8
PRIMARYYes
ObjTypeObject TypenVarChar
20
CopiesNo. of CopiesInt
6
1
PrintOnAddAdd & PrintVarChar
Y) Yes
N) No
1
N
ExprtOnAddAdd & ExportVarChar
Y) Yes
N) No
1
N
RoundSumsTotals RoundingVarChar
Y) Yes
N) No
1
N
RemarkPermanent RemarkText
16
PrintSumsPrint TotalsVarChar
Y) Yes
N) No
1
Y
VndrNumPrint Mfr Catalog No.VarChar
Y) Yes
N) No
1
N
PrnDscntPrint Discount DataVarChar
Y) Yes
N) No
1
Y
HandCopiesNo. of Copies for Manual Doc.Int
6
1
EngKBItemEnglish Keyboard Entering Item No.VarChar
Y) Yes
N) No
1
N
EngKBCardEnglish Keyboard Entering BP CodeVarChar
Y) Yes
N) No
1
N
EmailOnAddAdd & E-MailVarChar
Y) Yes
N) No
1
N
PDFOnAddAdd & Export to PDFVarChar
Y) Yes
N) No
1
N

SELECT statement

SELECT UDG1.Code AS 'Code', UDG1.ObjType AS 'Object Type', UDG1.Copies AS 'No. of Copies', UDG1.PrintOnAdd AS 'Add & Print', UDG1.ExprtOnAdd AS 'Add & Export', UDG1.RoundSums AS 'Totals Rounding', UDG1.Remark AS 'Permanent Remark', UDG1.PrintSums AS 'Print Totals', UDG1.VndrNum AS 'Print Mfr Catalog No.', UDG1.PrnDscnt AS 'Print Discount Data', UDG1.HandCopies AS 'No. of Copies for Manual Doc.', UDG1.EngKBItem AS 'English Keyboard Entering Item No.', UDG1.EngKBCard AS 'English Keyboard Entering BP Code', UDG1.EmailOnAdd AS 'Add & E-Mail', UDG1.PDFOnAdd AS 'Add & Export to PDF' FROM UDG1 AS UDG1

Related information


Default Documents DefaultDocuments Object· Table: UDG1
The DefaultDocuments is a child object of the UserDefaultGroups object. It enables to set default settings for printing documents per user or users group. Source table: UDG1.
   Parent: User Default Groups UserDefaultGroups Object· Table: OUDG


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