biuan SAP® BUSINESS ONE SDK
API OCTR / Service Contracts
OCTR - Service Contracts Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ContractID KEY UNIQUEContract No.Int
11
PRIMARYYes
CstmrCodeCustomer CodenVarChar
15OCRD
Business Partner
CstmrNameCustomer NamenVarChar
100OCRD
Business Partner
CntctCodeContact Person CodeInt
11OCPR
Contact Persons
OwnerOwnerInt
6OUSR
Users
StatusContract StatusVarChar
A) Approved
F) On Hold
D) Draft
T) Terminated
1
D
CntrcTmpltContract TemplatenVarChar
20OCTT
Contract Template
CntrcTypeContract TypeVarChar
C) Customer
G) Item Group
S) Serial Number
1
S
RenewalRenewalVarChar
Y) Yes
N) No
1
N
RemindValReminder TimeInt
6
RemindUnitRemind UnitVarChar
D) Day(s)
W) Week(s)
M) Month(s)
1
D
DurationDuration of CoverageInt
6
StartDateStart DateDate
8
EndDateEnd DateDate
8
ResponsValResolution TimeInt
6
ResponsUntResolution UnitVarChar
D) Day(s)
H) Hour(s)
1
D
DescriptioDescriptionnVarChar
127
SrcDocTypeSource Document TypeVarChar
Q) Sales Quotation
O) Sales Order
D) Delivery
I) A/R Invoice
1
I
DocNumSource DocumentInt
11
MonEnabledMonday EnabledVarChar
Y) Yes
N) No
1
Y
TueEnabledTuesday EnabledVarChar
Y) Yes
N) No
1
Y
WedEnabledWednesday EnabledVarChar
Y) Yes
N) No
1
Y
ThuEnabledThursday EnabledVarChar
Y) Yes
N) No
1
Y
FriEnabledFriday EnabledVarChar
Y) Yes
N) No
1
Y
SatEnabledSaturday EnabledVarChar
Y) Yes
N) No
1
Y
SunEnabledSunday EnabledVarChar
Y) Yes
N) No
1
Y
MonStartMonday StartInt
6
800
MonEndMonday EndInt
6
1700
TueStartTuesday StartInt
6
800
TueEndTuesday EndInt
6
1700
WedStartWednesday StartInt
6
800
WedEndWednesday EndInt
6
1700
ThuStartThursday StartInt
6
800
ThuEndThursday EndInt
6
1700
FriStartFriday StartInt
6
800
FriEndFriday EndInt
6
1700
SatStartSaturday StartInt
6
0
SatEndSaturday EndInt
6
2359
SunStrartSunday StartInt
6
0
SunEndSunday EndInt
6
2359
InclPartsInclude PartsVarChar
N) No
Y) Yes
1
N
InclWorkInclude LaborVarChar
N) No
Y) Yes
1
N
InclTravelInclude TravelVarChar
N) No
Y) Yes
1
N
AttachmentAttachmentsText
16
CreateDateCreation DateDate
8
Remarks1Template RemarksText
16
Remarks2RemarksText
16
RemindFlgReminder SentVarChar
Y) Yes
N) No
1
N
CTR1CountCTR1 CounterInt
11
0
DocEntryLinked Document No.Int
11
RemTmDaysRemind Time in DaysInt
11
ResTmHoursResponse Time in HoursInt
11
InclHldaysInclude HolidaysVarChar
N) No
Y) Yes
1
N
SrvcTypeService TypeVarChar
R) Regular
W) Warranty
1
R
TermDateTermination DateDate
8
ResponseVResponse TimeInt
6
ResponseUResponse UnitVarChar
D) Day(s)
H) Hour(s)
1
H
AtcEntryAttachment EntryInt
11OATC
Attachments
TransferedYear TransferVarChar
1
N
InstanceInstanceInt
6
0

Table relationship map

SELECT statement

SELECT OCTR.ContractID AS 'Contract No.', OCTR.CstmrCode AS 'Customer Code', OCTR.CstmrName AS 'Customer Name', OCTR.CntctCode AS 'Contact Person Code', OCTR.Owner AS 'Owner', OCTR.Status AS 'Contract Status', OCTR.CntrcTmplt AS 'Contract Template', OCTR.CntrcType AS 'Contract Type', OCTR.Renewal AS 'Renewal', OCTR.RemindVal AS 'Reminder Time', OCTR.RemindUnit AS 'Remind Unit', OCTR.Duration AS 'Duration of Coverage', OCTR.StartDate AS 'Start Date', OCTR.EndDate AS 'End Date', OCTR.ResponsVal AS 'Resolution Time', OCTR.ResponsUnt AS 'Resolution Unit', OCTR.Descriptio AS 'Description', OCTR.SrcDocType AS 'Source Document Type', OCTR.DocNum AS 'Source Document', OCTR.MonEnabled AS 'Monday Enabled', OCTR.TueEnabled AS 'Tuesday Enabled', OCTR.WedEnabled AS 'Wednesday Enabled', OCTR.ThuEnabled AS 'Thursday Enabled', OCTR.FriEnabled AS 'Friday Enabled', OCTR.SatEnabled AS 'Saturday Enabled', OCTR.SunEnabled AS 'Sunday Enabled', OCTR.MonStart AS 'Monday Start', OCTR.MonEnd AS 'Monday End', OCTR.TueStart AS 'Tuesday Start', OCTR.TueEnd AS 'Tuesday End', OCTR.WedStart AS 'Wednesday Start', OCTR.WedEnd AS 'Wednesday End', OCTR.ThuStart AS 'Thursday Start', OCTR.ThuEnd AS 'Thursday End', OCTR.FriStart AS 'Friday Start', OCTR.FriEnd AS 'Friday End', OCTR.SatStart AS 'Saturday Start', OCTR.SatEnd AS 'Saturday End', OCTR.SunStrart AS 'Sunday Start', OCTR.SunEnd AS 'Sunday End', OCTR.InclParts AS 'Include Parts', OCTR.InclWork AS 'Include Labor', OCTR.InclTravel AS 'Include Travel', OCTR.Attachment AS 'Attachments', OCTR.CreateDate AS 'Creation Date', OCTR.Remarks1 AS 'Template Remarks', OCTR.Remarks2 AS 'Remarks', OCTR.RemindFlg AS 'Reminder Sent', OCTR.CTR1Count AS 'CTR1 Counter', OCTR.DocEntry AS 'Linked Document No.', OCTR.RemTmDays AS 'Remind Time in Days', OCTR.ResTmHours AS 'Response Time in Hours', OCTR.InclHldays AS 'Include Holidays', OCTR.SrvcType AS 'Service Type', OCTR.TermDate AS 'Termination Date', OCTR.ResponseV AS 'Response Time', OCTR.ResponseU AS 'Response Unit', OCTR.AtcEntry AS 'Attachment Entry', OCTR.Transfered AS 'Year Transfer', OCTR.Instance AS 'Instance' FROM OCTR AS OCTR

Related information


Service Contracts ServiceContracts Object· Table: OCTR
ServiceContracts is a business object that represents the service contracts table in the Service module of SAP Business One application. This object enables you to: Add a service contract. Retrieve a service contract by its key. Update a...

OCTR SQL Table

Attachments OATC SQL Table

Contact Persons OCPR SQL Table

Contract Template OCTT SQL Table

Business Partner OCRD SQL Table

Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates