| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| DocCode |
Code |
nVarChar |
8 |
- |
|
|
|
| DocName |
Name |
nVarChar |
120 |
- |
|
|
|
| Author |
Author |
nVarChar |
155 |
- |
|
|
|
| Notes |
Remarks |
nVarChar |
254 |
- |
|
|
|
| Width |
Width |
Int |
6 |
- |
595 |
|
|
| Height |
Height |
Int |
6 |
- |
842 |
|
|
| LMargin |
Left Margin |
Int |
6 |
- |
10 |
|
|
| RMargin |
Right Margin |
Int |
6 |
- |
30 |
|
|
| TMargin |
Top Margin |
Int |
6 |
- |
10 |
|
|
| BMargin |
Bottom Margin |
Int |
6 |
- |
10 |
|
|
| CanChange |
Changeable |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PaperSize |
Paper Size |
nVarChar |
100 |
- |
A4 |
|
|
| Oreint |
Orientation |
VarChar |
1 |
- |
P |
P |
Vertical |
| |
|
|
|
|
|
L |
Horizontal |
| GridSize |
Grid Size |
Int |
6 |
- |
10 |
|
|
| GridType |
Grid Type |
VarChar |
1 |
- |
1 |
1 |
Combination |
| |
|
|
|
|
|
2 |
Continuous Line |
| |
|
|
|
|
|
3 |
Broken Line |
| |
|
|
|
|
|
4 |
Dots |
| ShowGrid |
Display Grid |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SnapGrid |
Next to Grid |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Picture |
Picture |
Text |
16 |
- |
|
|
|
| TypeCode |
Type Code |
nVarChar |
4 |
- |
|
|
|
| FrgnReport |
Foreign Language Report |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CanSort |
Sortable |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| LeaderCode |
Leader Report |
nVarChar |
8 |
- |
|
|
|
| FollowCode |
Follow-Up Report |
nVarChar |
8 |
- |
|
|
|
| SwapOnScrn |
Convert Font in Print Preview |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ScreenFont |
Preview Printing Font |
nVarChar |
50 |
- |
Arial |
|
|
| ScrFOffset |
Change Font Size in Print Preview |
Int |
6 |
- |
-1 |
|
|
| SwpInEmail |
Convert Font for E-Mail |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| EmailFont |
E-Mail Font |
nVarChar |
50 |
- |
Arial |
|
|
| EmFOffset |
Change Font Size for E-Mail |
Int |
6 |
- |
-1 |
|
|
| QString |
Query |
Text |
16 |
- |
|
|
|
| QType |
Query Type |
VarChar |
1 |
- |
R |
R |
Regular |
| |
|
|
|
|
|
W |
Wizard |
| Language |
Language |
Int |
11 |
OLNG |
|
|
|
| RobjCode |
Imp Exp Obj Code |
Int |
11 |
- |
0 |
|
|
| ExtName |
Extension Name |
Text |
16 |
- |
|
|
|
| ExtOnErr |
Action for extension error |
VarChar |
1 |
- |
S |
S |
Stop |
| |
|
|
|
|
|
I |
Ignore |
| |
|
|
|
|
|
P |
Prompt |
| NumRepArs |
Number of Repetitive Areas |
Int |
6 |
- |
1 |
|
|
| AlgnFooter |
Allign Footer to Buttom |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| TimeFormat |
Time Template |
VarChar |
1 |
- |
0 |
0 |
Default |
| |
|
|
|
|
|
1 |
24H |
| |
|
|
|
|
|
2 |
12H |
| DateFormat |
Date Template |
VarChar |
1 |
- |
0 |
0 |
Default |
| |
|
|
|
|
|
1 |
DD/MM/YY |
| |
|
|
|
|
|
2 |
DD/MM/CCYY |
| |
|
|
|
|
|
3 |
MM/DD/YY |
| |
|
|
|
|
|
4 |
MM/DD/CCYY |
| |
|
|
|
|
|
5 |
CCYY/MM/DD |
| |
|
|
|
|
|
6 |
DD/Month/YYYY |
| DateSep |
Date Separator |
VarChar |
1 |
- |
|
|
|
| DecSep |
Decimal Separator |
VarChar |
1 |
- |
|
|
|
| ThousSep |
Thousands Separator |
VarChar |
1 |
- |
|
|
|
| Printer |
Printer |
nVarChar |
100 |
- |
|
|
|
| NumLayPage |
Number of Layout Pages |
Int |
11 |
- |
|
|
|
| NumCopy |
Number of Copies |
Int |
11 |
- |
1 |
|
|
| GbiSupport |
GBI Settings Supported |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Use1stPrtr |
Use 1st Page Printer |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Prtr1st |
Printer for First Page |
nVarChar |
100 |
- |
|
|
|
| Shading |
Print Item Backgrounds |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Template |
Report Binary Data |
Text |
16 |
- |
|
|
|
| Category |
Category |
VarChar |
1 |
- |
P |
P |
PLD |
| |
|
|
|
|
|
C |
Crystal Reports |
| |
|
|
|
|
|
L |
Legal List |
| |
|
|
|
|
|
A |
Partner Type |
| |
|
|
|
|
|
E |
Electronic Files |
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| UserSign |
User Signature |
Int |
6 |
- |
|
|
|
| UserSign2 |
Updating User |
Int |
6 |
- |
|
|
|
| Status |
Status |
VarChar |
1 |
- |
A |
A |
Active |
| |
|
|
|
|
|
I |
Inactive |
| B1Version |
Required B1 Version |
nVarChar |
20 |
- |
|
|
|
| CRVersion |
Required Crystal Version |
nVarChar |
20 |
- |
|
|
|
| Local |
Localization |
nVarChar |
2 |
- |
|
|
|
| UseSysPref |
Use System Preference |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ForMobile |
Visible For Mobile |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| TypeDetail |
Type |
nVarChar |
254 |
- |
|
|
|
| IsIMCE |
Powered by SAP HANA |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CsUrl |
URL in Crystal Server |
nVarChar |
254 |
- |
|
|
|
| RptHash |
Hash for Report |
nVarChar |
254 |
- |
|
|
|