| |||
SQL Service / Contract Template DTW Administration / Setup / Service / Contract Templates API OCTT / Contract Templates | |||
OCTT - Contract Template Table SBO SQL database table detailsSELECT statementSELECT
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 informationContract 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 |