|
|
SQL Service / Service Contracts
API OCTR / / Service Contracts
OCTR - Service Contracts Table
Service Contracts ServiceContracts Object· Table: OCTR
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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ContractID KEY UNIQUE | Contract No. | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CstmrCode | Customer Code | nVarChar | 15 | OCRD Business Partner | ||||
| CstmrName | Customer Name | nVarChar | 100 | OCRD Business Partner | ||||
| CntctCode | Contact Person Code | Int | 11 | OCPR Contact Persons | ||||
| Owner | Owner | Int | 6 | OUSR Users | ||||
| Status | Contract Status | VarChar | A) Approved F) On Hold D) Draft T) Terminated | 1 | D | |||
| CntrcTmplt | Contract Template | nVarChar | 20 | OCTT Contract Template | ||||
| CntrcType | Contract Type | VarChar | C) Customer G) Item Group S) Serial Number | 1 | S | |||
| Renewal | Renewal | VarChar | Y) Yes N) No | 1 | N | |||
| RemindVal | Reminder Time | Int | 6 | |||||
| RemindUnit | Remind Unit | VarChar | D) Day(s) W) Week(s) M) Month(s) | 1 | D | |||
| 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 | D) Day(s) H) Hour(s) | 1 | D | |||
| Descriptio | Description | nVarChar | 127 | |||||
| SrcDocType | Source Document Type | VarChar | Q) Sales Quotation O) Sales Order D) Delivery I) A/R Invoice | 1 | I | |||
| DocNum | Source Document | Int | 11 | |||||
| MonEnabled | Monday Enabled | VarChar | Y) Yes N) No | 1 | Y | |||
| TueEnabled | Tuesday Enabled | VarChar | Y) Yes N) No | 1 | Y | |||
| WedEnabled | Wednesday Enabled | VarChar | Y) Yes N) No | 1 | Y | |||
| ThuEnabled | Thursday Enabled | VarChar | Y) Yes N) No | 1 | Y | |||
| FriEnabled | Friday Enabled | VarChar | Y) Yes N) No | 1 | Y | |||
| SatEnabled | Saturday Enabled | VarChar | Y) Yes N) No | 1 | Y | |||
| SunEnabled | Sunday Enabled | VarChar | Y) Yes N) No | 1 | Y | |||
| 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 | N) No Y) Yes | 1 | N | |||
| InclWork | Include Labor | VarChar | N) No Y) Yes | 1 | N | |||
| InclTravel | Include Travel | VarChar | N) No Y) Yes | 1 | N | |||
| Attachment | Attachments | Text | 16 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| Remarks1 | Template Remarks | Text | 16 | |||||
| Remarks2 | Remarks | Text | 16 | |||||
| RemindFlg | Reminder Sent | VarChar | Y) Yes N) No | 1 | N | |||
| 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 | N) No Y) Yes | 1 | N | |||
| SrvcType | Service Type | VarChar | R) Regular W) Warranty | 1 | R | |||
| TermDate | Termination Date | Date | 8 | |||||
| ResponseV | Response Time | Int | 6 | |||||
| ResponseU | Response Unit | VarChar | D) Day(s) H) Hour(s) | 1 | H | |||
| AtcEntry | Attachment Entry | Int | 11 | OATC Attachments | ||||
| Transfered | Year Transfer | VarChar | 1 | N | ||||
| Instance | Instance | Int | 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
ServiceContracts
Enumeration
Method
Object
Property
ContactCode
DB
ContractID
DB
ContractType
DB
CustomerCode
DB
CustomerName
DB
Description
DB
EndDate
DB
FridayEnd
DB
FridayStart
DB
IncludeLabor
DB
IncludeParts
DB
MondayEnd
DB
MondayStart
DB
Owner
DB
Remarks
DB
ReminderTime
DB
RemindUnit
DB
Renewal
DB
ResponseTime
DB
ResponseUnit
DB
SaturdayEnd
DB
ServiceType
DB
StartDate
DB
Status
DB
SundayEnd
DB
SundayStart
DB
ThursdayEnd
DB
TuesdayEnd
DB
TuesdayStart
DB
WednesdayEnd
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
