SAP Business One SDK 10.0 - Database Tables Reference
-
Table Name: OUQR
Table Description: Queries
| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| IntrnalKey |
Internal Key |
Int |
11 |
- |
|
|
|
| QCategory |
Query Category |
Int |
11 |
OQCN |
|
|
|
| QName |
Query Description |
nVarChar |
100 |
- |
|
|
|
| QString |
Query |
Text |
16 |
- |
|
|
|
| QType |
Query Type |
VarChar |
1 |
- |
W |
R |
Regular |
| |
|
|
|
|
|
W |
Wizard |
| |
|
|
|
|
|
G |
Report Generator |
| |
|
|
|
|
|
S |
Stored Procedure |
| ColumnSize |
Column Size |
nVarChar |
100 |
- |
|
|
|
| DBType |
DB Type |
Int |
11 |
- |
|
|
|
| QLastDate |
Last Upload Date |
Date |
8 |
- |
|
|
|
| QLastTime |
Last Upload Time |
Int |
6 |
- |
|
|
|
| Xslt |
XSLT Transformation |
Text |
16 |
- |
|
|
|
| MenuItem |
Specify Menu Item |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| MenuCapt |
Menu Caption |
nVarChar |
254 |
- |
|
|
|
| FatherMenu |
Parent Menu ID |
Int |
11 |
- |
|
|
|
| MenuPos |
Menu Position |
Int |
6 |
- |
|
|
|
| MenuUid |
Menu UID |
nVarChar |
32 |
- |
|
|
|
| CommandID |
Menu Command ID |
Int |
11 |
- |
|
|
|
| UpdateDate |
Last Update Date |
Date |
8 |
- |
|
|
|
| LastUpdate |
Last Update Time |
Int |
11 |
- |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| CreateDate |
Created On |
Date |
8 |
- |
|
|
|
| ChangeDate |
Change Date |
Date |
8 |
- |
|
|
|
| CreateTS |
Creatn Time - Incl. Secs |
Int |
11 |
- |
|
|
|
| UpdateTS |
Update Full Time |
Int |
11 |
- |
|
|
|
| UserSign |
Created By |
Int |
6 |
- |
|
|
|
| UserSign2 |
Updated By |
Int |
6 |
- |
|
|
|
| AnaActive |
Analytics Active |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DisplTile |
Display UDQ as Tile |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Key |
Unique |
Field |
| PRIMARY |
Yes |
IntrnalKey |
| |
|
QCategory |
| QNAME_K |
Yes |
QName |
| |
|
QCategory |