SAP Business One SDK 10.0 - Database Tables Reference
-
Table Name: CPRF
Table Description: Column Preferences
| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| FormID |
Form ID |
nVarChar |
20 |
- |
|
|
|
| ItemID |
Item Number |
nVarChar |
50 |
- |
|
|
|
| ColID |
Column |
nVarChar |
60 |
- |
|
|
|
| Width |
Width |
Int |
11 |
- |
|
|
|
| VisInForm |
Visible in Form |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| VisualIndx |
Tabs Layout |
Int |
11 |
- |
|
|
|
| EditInForm |
Editable in Form |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| VisInExpnd |
Visible in Expanded |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ExpandIndx |
Expanded Index |
Int |
11 |
- |
|
|
|
| EditInEXP |
Editable in Expanded |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Folded |
Folder |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| ExtDisable |
Externally Disabled |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| ExtInvsbl |
Externally Invisible |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| TPLId |
Template ID |
Int |
6 |
UICU |
0 |
|
|
| TableName |
Table Name |
nVarChar |
20 |
- |
|
|
|
| ItemUID |
ItemUID |
nVarChar |
32 |
- |
|
|
|
| Key |
Unique |
Field |
| PRIMARY |
Yes |
UserSign |
| |
|
FormID |
| |
|
ItemID |
| |
|
ColID |
| |
|
TPLId |