SAP Business One SDK 10.0 - Database Tables Reference
-
Table Name: OCTT
Table Description: Contract Template
| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| TmpltName |
Template Name |
nVarChar |
20 |
- |
|
|
|
| Deleted |
Deleted |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Renewal |
Renewal |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RemindVal |
Remind Before Renewal |
Int |
6 |
- |
|
|
|
| RemindUnit |
Remind Unit |
VarChar |
1 |
- |
D |
D |
Day(s) |
| |
|
|
|
|
|
W |
Week(s) |
| |
|
|
|
|
|
M |
Month(s) |
| Duration |
Duration of Coverage |
Int |
6 |
- |
|
|
|
| ResponsVal |
Resolution Value |
Int |
6 |
- |
|
|
|
| ResponsUnt |
Resolution Unit |
VarChar |
1 |
- |
D |
D |
Day(s) |
| |
|
|
|
|
|
H |
Hour(s) |
| Descriptio |
Description |
nVarChar |
254 |
- |
|
|
|
| PriceList |
Price List No. |
Int |
6 |
- |
|
|
|
| CntrctType |
Contract Type |
VarChar |
1 |
- |
S |
C |
Customer |
| |
|
|
|
|
|
G |
Item Group |
| |
|
|
|
|
|
S |
Serial Number |
| MonEnabled |
Monday Enabled |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| TueEnabled |
Tuesday Enabled |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| WedEnabled |
Wednesday Enabled |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ThuEnabled |
Thursday Enabled |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| FriEnabled |
Friday Enabled |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SatEnabled |
Saturday Enabled |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SunEnabled |
Sunday Enabled |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| MonStart |
Monday Start |
Int |
6 |
- |
800 |
|
|
| MonEnd |
Monday End |
Int |
6 |
- |
1700 |
|
|
| TueStart |
Tuesday Start |
Int |
6 |
- |
800 |
|
|
| TueEnd |
Tuesday End |
Int |
6 |
- |
1700 |
|
|
| WedStart |
Wednesday Start |
Int |
6 |
- |
800 |
|
|
| WedEnd |
Wednesday End |
Int |
6 |
- |
1700 |
|
|
| ThuStart |
Thursday Start |
Int |
6 |
- |
800 |
|
|
| ThuEnd |
Thursday End |
Int |
6 |
- |
1700 |
|
|
| FriStart |
Friday Start |
Int |
6 |
- |
800 |
|
|
| FriEnd |
Friday End |
Int |
6 |
- |
1700 |
|
|
| SatStart |
Saturday Start |
Int |
6 |
- |
0 |
|
|
| SatEnd |
Saturday End |
Int |
6 |
- |
2359 |
|
|
| SunStrart |
Sunday Start |
Int |
6 |
- |
0 |
|
|
| SunEnd |
Sunday End |
Int |
6 |
- |
2359 |
|
|
| InclParts |
Include Parts |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| InclWork |
Include Labor |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| InclTravel |
Include Travel |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| Attachment |
Attachments |
Text |
16 |
- |
|
|
|
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| Remark |
Remarks |
Text |
16 |
- |
|
|
|
| InclHldays |
Include Holidays |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| ResponseV |
Response Value |
Int |
6 |
- |
|
|
|
| ResponseU |
Response Unit |
VarChar |
1 |
- |
H |
H |
Hour(s) |
| |
|
|
|
|
|
D |
Day(s) |
| AtcEntry |
Attachment Entry |
Int |
11 |
- |
|
|
|
| Key |
Unique |
Field |
| PRIMARY |
Yes |
TmpltName |