|
|
SAP Business One SDK 10.0 - Database Tables Reference |
User Defaults
Table Name: OUDG
Table Description: User Defaults
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| Code | Code | nVarChar | 8 | - | Â | Â | Â |
| Name | Name | nVarChar | 20 | - | Â | Â | Â |
| Warehouse | Warehouse | nVarChar | 8 | OWHS | Â | Â | Â |
| SalePerson | Sales Employee | Int | 11 | OSLP | -1 | Â | Â |
| ICTCard | BP for Invoice + Payment | nVarChar | 15 | OCRD | Â | Â | Â |
| CashAcct | Cash Account | nVarChar | 15 | - | Â | Â | Â |
| CheckAcct | Current Account | nVarChar | 15 | - | Â | Â | Â |
| CreditCard | Credit Card | Int | 6 | OCRC | Â | Â | Â |
| PrintRcpt | Print Receipt | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | A | Only When Adding |
| Â | Â | Â | Â | Â | Â | Y | Always |
| ShortRcpt | Print Payment & Invoice in Succession | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Color | Windows Color | Int | 6 | - | Â | 0 | Combined |
| Â | Â | Â | Â | Â | Â | 1 | Classic |
| Â | Â | Â | Â | Â | Â | 2 | Gray |
| Â | Â | Â | Â | Â | Â | 3 | Violet |
| Â | Â | Â | Â | Â | Â | 4 | Blue |
| Â | Â | Â | Â | Â | Â | 5 | Green |
| Â | Â | Â | Â | Â | Â | 6 | Yellow |
| Â | Â | Â | Â | Â | Â | 7 | Orange |
| Â | Â | Â | Â | Â | Â | 8 | Red |
| Â | Â | Â | Â | Â | Â | 9 | Brown |
| Address | Address | nVarChar | 254 | - | Â | Â | Â |
| Country | Country/Region | nVarChar | 3 | OCRY | Â | Â | Â |
| PrintHeadr | Printing Header | nVarChar | 100 | - | Â | Â | Â |
| Phone1 | Telephone Number 1 | nVarChar | 50 | - | Â | Â | Â |
| Phone2 | Telephone Number 2 | nVarChar | 50 | - | Â | Â | Â |
| Fax | Fax Number | nVarChar | 50 | - | Â | Â | Â |
| E_Mail | nVarChar | 100 | - | Â | Â | Â | |
| FrgnAddr | Address in Foreign Language | nVarChar | 254 | - | Â | Â | Â |
| FrnPrntHdr | Printing Header in Foreign Lan | nVarChar | 100 | - | Â | Â | Â |
| FrgnPhone1 | Telephone Number 1 (Foreign Lang.) | nVarChar | 50 | - | Â | Â | Â |
| FrgnPhone2 | Telephone Number 2 (Foreign Lang.) | nVarChar | 50 | - | Â | Â | Â |
| FrgnFax | Fax Number (Foreign Lang.) | nVarChar | 50 | - | Â | Â | Â |
| DflTaxCode | Default Tax Code | nVarChar | 8 | OSTC | Â | Â | Â |
| FreeZoneNo | Additional ID Number | nVarChar | 32 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| free1 | Free1 | VarChar | 1 | - | Â | Â | Â |
| UseTax | Use Tax | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AdrsFromWh | Use Warehouse Address in A/P Documents | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Language | Language | Int | 11 | OLNG | Â | Â | Â |
| Font | Font | nVarChar | 50 | - | Â | Â | Â |
| FontSize | Font Size | Int | 11 | - | Â | Â | Â |
| BPLId | Default Branch | Int | 11 | OBPL | Â | Â | Â |
| AssetInDoc | Allow Creation of Asset in Doc. | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AttachPath | Attachments Path | Text | 16 | - | Â | Â | Â |
| DflPTICode | Default POI Code | nVarChar | 5 | OPTI | Â | Â | Â |
| Free4 | unused | VarChar | 1 | - | Â | Â | Â |
| Free2 | unused | VarChar | 1 | - | Â | Â | Â |
| Free3 | unused | VarChar | 1 | - | Â | Â | Â |
| DflPosCR | Default POS/Cash Register | Int | 11 | OPCM | Â | Â | Â |
| TimeFormat | Time Template | VarChar | 1 | - | Â | 0 | 24H |
| Â | Â | Â | Â | Â | Â | 1 | 12H |
| DateFormat | Date Template | VarChar | 1 | - | Â | 0 | DD/MM/YY |
| Â | Â | Â | Â | Â | Â | 1 | DD/MM/YYYY |
| Â | Â | Â | Â | Â | Â | 2 | MM/DD/YY |
| Â | Â | Â | Â | Â | Â | 3 | MM/DD/YYYY |
| Â | Â | Â | Â | Â | Â | 4 | CCYY/MM/DD |
| Â | Â | Â | Â | Â | Â | 5 | DD/Month/YYYY |
| Â | Â | Â | Â | Â | Â | 6 | YY/MM/DD |
| DateSep | Date Separator | VarChar | 1 | - | Â | Â | Â |
| DecSep | Decimal Separator | VarChar | 1 | - | Â | Â | Â |
| ThousSep | Thousands Separator | VarChar | 1 | - | Â | Â | Â |
| WallPaper | Wallpaper | Text | 16 | - | Â | Â | Â |
| WllPprDsp | Wallpaper Display | nVarChar | 6 | - | Â | 1 | Centralized |
| Â | Â | Â | Â | Â | Â | 2 | Full Screen |
| Â | Â | Â | Â | Â | Â | 3 | Tile |
| SkinType | Skin Type | nVarChar | 254 | - | Â | Â | Â |
| CharMonth | Number of Characters in Month | Int | 11 | - | Â | Â | Â |
| HandleEDoc | Can Take Control of eDoc Processing in Electronic Document Monitor | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | Code |