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

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodenVarChar
8
PRIMARYYes
NameNamenVarChar
20
WarehouseWarehousenVarChar
8OWHS
Warehouses
SalePersonSales EmployeeInt
11OSLP
Sales Employee		-1
ICTCardBP for Invoice + PaymentnVarChar
15OCRD
Business Partner
CashAcctCash AccountnVarChar
15
CheckAcctCurrent AccountnVarChar
15
CreditCardCredit CardInt
6OCRC
Credit Cards
PrintRcptPrint ReceiptVarChar
N) No
A) Only When Adding
Y) Always
1
N
ShortRcptPrint Payment & Invoice in SuccessionVarChar
Y) Yes
N) No
1
N
ColorWindows ColorInt
0
1) Classic
2) Gray
3) Violet
4) Blue
5) Green
6) Yellow
7) Orange
8) Red
9) Brown
6
1
AddressAddressnVarChar
127
CountryCountrynVarChar
3OCRY
Countries
PrintHeadrPrinting HeadernVarChar
100
Phone1Telephone Number 1nVarChar
20
Phone2Telephone Number 2nVarChar
20
FaxFax NumbernVarChar
20
E_MailE-MailnVarChar
100
FrgnAddrAddress in Foreign LanguagenVarChar
127
FrnPrntHdrPrinting Header in Foreign LannVarChar
100
FrgnPhone1Telephone Number 1 (Foreign Lang.)nVarChar
20
FrgnPhone2Telephone Number 2 (Foreign Lang.)nVarChar
20
FrgnFaxFax Number (Foreign Lang.)nVarChar
20
DflTaxCodeDefault Tax CodenVarChar
8OSTC
Sales Tax Codes
FreeZoneNoAdditional ID NumbernVarChar
32
UserSignUser SignatureInt
6OUSR
Users
free1Free1VarChar
1
UseTaxUse TaxVarChar
Y) Yes
N) No
1
AdrsFromWhUse Warehouse Address in A/P DocumentsVarChar
Y) Yes
N) No
1
N
LanguageLanguageInt
11
FontFontnVarChar
50
FontSizeFont SizeInt
11
BPLIdDefault BranchInt
11OBPL
Business Place
AssetInDocAllow Creation of Asset in Doc.VarChar
Y) Yes
N) No
1
N
AttachPathAttachments PathText
16
DflPTICodeDefault POI CodenVarChar
5OPTI
Point of Issue

Table relationship map

SELECT statement

SELECT OUDG.Code AS 'Code', OUDG.Name AS 'Name', OUDG.Warehouse AS 'Warehouse', OUDG.SalePerson AS 'Sales Employee', OUDG.ICTCard AS 'BP for Invoice + Payment', OUDG.CashAcct AS 'Cash Account', OUDG.CheckAcct AS 'Current Account', OUDG.CreditCard AS 'Credit Card', OUDG.PrintRcpt AS 'Print Receipt', OUDG.ShortRcpt AS 'Print Payment & Invoice in Succession', OUDG.Color AS 'Windows Color', OUDG.Address AS 'Address', OUDG.Country AS 'Country', OUDG.PrintHeadr AS 'Printing Header', OUDG.Phone1 AS 'Telephone Number 1', OUDG.Phone2 AS 'Telephone Number 2', OUDG.Fax AS 'Fax Number', OUDG.E_Mail AS 'E-Mail', OUDG.FrgnAddr AS 'Address in Foreign Language', OUDG.FrnPrntHdr AS 'Printing Header in Foreign Lan', OUDG.FrgnPhone1 AS 'Telephone Number 1 (Foreign Lang.)', OUDG.FrgnPhone2 AS 'Telephone Number 2 (Foreign Lang.)', OUDG.FrgnFax AS 'Fax Number (Foreign Lang.)', OUDG.DflTaxCode AS 'Default Tax Code', OUDG.FreeZoneNo AS 'Additional ID Number', OUDG.UserSign AS 'User Signature', OUDG.free1 AS 'Free1', OUDG.UseTax AS 'Use Tax', OUDG.AdrsFromWh AS 'Use Warehouse Address in A/P Documents', OUDG.Language AS 'Language', OUDG.Font AS 'Font', OUDG.FontSize AS 'Font Size', OUDG.BPLId AS 'Default Branch', OUDG.AssetInDoc AS 'Allow Creation of Asset in Doc.', OUDG.AttachPath AS 'Attachments Path', OUDG.DflPTICode AS 'Default POI Code' FROM OUDG AS OUDG

Related information


User Default Groups UserDefaultGroups Object· Table: OUDG
The UserDefaultGroups object enables to define default values (such as, default documents, default address in printed documents, windows color, and so on). These default values can be applied to specific user or group of users by setting the...

OUDG SQL Table

Business Place OBPL SQL Table

Countries OCRY SQL Table

Credit Cards OCRC SQL Table

Point of Issue OPTI SQL Table

Sales Tax Codes OSTC SQL Table

Business Partner OCRD SQL Table

Sales Employee OSLP SQL Table

Warehouses OWHS 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