biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Service / Contract Templates
API OCTT / / Contract Templates
OCTT - Contract Template Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TmpltName KEY UNIQUETemplate NamenVarChar
20
PRIMARYYes
DeletedDeletedVarChar
Y) Yes
N) No
1
N
RenewalRenewalVarChar
Y) Yes
N) No
1
N
RemindValRemind Before RenewalInt
6
RemindUnitRemind UnitVarChar
D) Day(s)
W) Week(s)
M) Month(s)
1
D
DurationDuration of CoverageInt
6
ResponsValResolution ValueInt
6
ResponsUntResolution UnitVarChar
D) Day(s)
H) Hour(s)
1
D
DescriptioDescriptionnVarChar
127
PriceListPrice List No.Int
6
CntrctTypeContract TypeVarChar
C) Customer
G) Item Group
S) Serial Number
1
S
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
RemarkRemarksText
16
InclHldaysInclude HolidaysVarChar
N) No
Y) Yes
1
N
ResponseVResponse ValueInt
6
ResponseUResponse UnitVarChar
H) Hour(s)
D) Day(s)
1
H
AtcEntryAttachment EntryInt
11

SELECT statement

SELECT OCTT.TmpltName AS 'Template Name', OCTT.Deleted AS 'Deleted', OCTT.Renewal AS 'Renewal', OCTT.RemindVal AS 'Remind Before Renewal', OCTT.RemindUnit AS 'Remind Unit', OCTT.Duration AS 'Duration of Coverage', OCTT.ResponsVal AS 'Resolution Value', OCTT.ResponsUnt AS 'Resolution Unit', OCTT.Descriptio AS 'Description', OCTT.PriceList AS 'Price List No.', OCTT.CntrctType AS 'Contract Type', OCTT.MonEnabled AS 'Monday Enabled', OCTT.TueEnabled AS 'Tuesday Enabled', OCTT.WedEnabled AS 'Wednesday Enabled', OCTT.ThuEnabled AS 'Thursday Enabled', OCTT.FriEnabled AS 'Friday Enabled', OCTT.SatEnabled AS 'Saturday Enabled', OCTT.SunEnabled AS 'Sunday Enabled', OCTT.MonStart AS 'Monday Start', OCTT.MonEnd AS 'Monday End', OCTT.TueStart AS 'Tuesday Start', OCTT.TueEnd AS 'Tuesday End', OCTT.WedStart AS 'Wednesday Start', OCTT.WedEnd AS 'Wednesday End', OCTT.ThuStart AS 'Thursday Start', OCTT.ThuEnd AS 'Thursday End', OCTT.FriStart AS 'Friday Start', OCTT.FriEnd AS 'Friday End', OCTT.SatStart AS 'Saturday Start', OCTT.SatEnd AS 'Saturday End', OCTT.SunStrart AS 'Sunday Start', OCTT.SunEnd AS 'Sunday End', OCTT.InclParts AS 'Include Parts', OCTT.InclWork AS 'Include Labor', OCTT.InclTravel AS 'Include Travel', OCTT.Attachment AS 'Attachments', OCTT.CreateDate AS 'Creation Date', OCTT.Remark AS 'Remarks', OCTT.InclHldays AS 'Include Holidays', OCTT.ResponseV AS 'Response Value', OCTT.ResponseU AS 'Response Unit', OCTT.AtcEntry AS 'Attachment Entry' FROM OCTT AS OCTT

Related information


Contract Templates ContractTemplates Object· Table: OCTT
ContractTemplates is a business object that represents the contract templates in the Service module. This object enables you to: Add a contract template. Retrieve a contract template by its key. Update a contract template. Remove a...

OCTT SQL Table



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