SAP Business One SDK 10.0 - Database Tables Reference
-
Table Name: OCTR
Table Description: Service Contracts
| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| ContractID |
Contract No. |
Int |
11 |
- |
|
|
|
| CstmrCode |
Business Partner Code |
nVarChar |
15 |
OCRD |
|
|
|
| CstmrName |
Business Partner Name |
nVarChar |
200 |
- |
|
|
|
| CntctCode |
Contact Person Code |
Int |
11 |
OCPR |
|
|
|
| Owner |
Owner |
Int |
6 |
OUSR |
|
|
|
| Status |
Contract Status |
VarChar |
1 |
- |
D |
A |
Approved |
| |
|
|
|
|
|
F |
On Hold |
| |
|
|
|
|
|
D |
Draft |
| |
|
|
|
|
|
T |
Terminated |
| CntrcTmplt |
Contract Template |
nVarChar |
20 |
OCTT |
|
|
|
| CntrcType |
Contract Type |
VarChar |
1 |
- |
S |
C |
Business Partner |
| |
|
|
|
|
|
G |
Item Group |
| |
|
|
|
|
|
S |
Serial Number |
| Renewal |
Renewal |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RemindVal |
Reminder Time |
Int |
6 |
- |
|
|
|
| RemindUnit |
Remind Unit |
VarChar |
1 |
- |
D |
D |
Day(s) |
| |
|
|
|
|
|
W |
Week(s) |
| |
|
|
|
|
|
M |
Month(s) |
| Duration |
Duration of Coverage |
Int |
6 |
- |
|
|
|
| StartDate |
Start Date |
Date |
8 |
- |
|
|
|
| EndDate |
End Date |
Date |
8 |
- |
|
|
|
| ResponsVal |
Resolution Time |
Int |
6 |
- |
|
|
|
| ResponsUnt |
Resolution Unit |
VarChar |
1 |
- |
D |
D |
Day(s) |
| |
|
|
|
|
|
H |
Hour(s) |
| Descriptio |
Description |
nVarChar |
254 |
- |
|
|
|
| SrcDocType |
Source Document Type |
VarChar |
1 |
- |
I |
Q |
Sales Quotation |
| |
|
|
|
|
|
O |
Sales Order |
| |
|
|
|
|
|
D |
Delivery |
| |
|
|
|
|
|
I |
A/R Invoice |
| DocNum |
Source Document |
Int |
11 |
- |
|
|
|
| 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 |
- |
|
|
|
| Remarks1 |
Template Remarks |
Text |
16 |
- |
|
|
|
| Remarks2 |
Remarks |
Text |
16 |
- |
|
|
|
| RemindFlg |
Reminder Sent |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CTR1Count |
CTR1 Counter |
Int |
11 |
- |
0 |
|
|
| DocEntry |
Linked Document No. |
Int |
11 |
- |
|
|
|
| RemTmDays |
Remind Time in Days |
Int |
11 |
- |
|
|
|
| ResTmHours |
Response Time in Hours |
Int |
11 |
- |
|
|
|
| InclHldays |
Include Holidays |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| SrvcType |
Service Type |
VarChar |
1 |
- |
R |
R |
Regular |
| |
|
|
|
|
|
W |
Warranty |
| TermDate |
Termination Date |
Date |
8 |
- |
|
|
|
| ResponseV |
Response Time |
Int |
6 |
- |
|
|
|
| ResponseU |
Response Unit |
VarChar |
1 |
- |
H |
D |
Day(s) |
| |
|
|
|
|
|
H |
Hour(s) |
| AtcEntry |
Attachment Entry |
Int |
11 |
OATC |
|
|
|
| Transfered |
Year Transfer |
VarChar |
1 |
- |
N |
|
|
| Instance |
Instance |
Int |
6 |
- |
0 |
|
|
| BPType |
BP Type |
VarChar |
1 |
- |
R |
R |
Sales |
| |
|
|
|
|
|
P |
Purchasing |
| OwnerCode |
Service Contract Owner |
Int |
11 |
OHEM |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| ObjType |
Object Type - History |
nVarChar |
20 |
- |
190 |
|
|
| LogInstanc |
Log Instance - History |
Int |
11 |
- |
|
|
|
| UserSign2 |
Updating User - History |
Int |
6 |
OUSR |
|
|
|
| UpdateDate |
Date of Update - History |
Date |
8 |
- |
|
|
|
| DPPStatus |
Data Protection Status |
VarChar |
1 |
- |
N |
N |
None |
| |
|
|
|
|
|
D |
Erased |
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|
| Printed |
Printed |
VarChar |
1 |
- |
N |
|
|
| Key |
Unique |
Field |
| PRIMARY |
Yes |
ContractID |