biuan SAP® BUSINESS ONE SDK
SQL Service / Service Contracts / Service Contract - Items
DTW Service Contract - Items
API Service Contracts / Service Contract Lines
CTR1 - Service Contract - Items Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ContractID KEY UNIQUEContract No.Int
11OCTR
Service Contracts		PRIMARYYes
LineRowInt
6
ManufSNMfr Serial No.nVarChar
36
InternalSNSerial NumbernVarChar
36
ItemCodeItem No.nVarChar
20OITM
Items
ItemNameItem DescriptionnVarChar
100
ItemGroupItem GroupInt
6OITB
Item Groups
StartDateStart DateDate
8
EndDateEnd DateDate
8
ItmGrpNameItem Group NamenVarChar
20
InsIDCustomer Equipment Card IDInt
11OINS
Customer Equipment Card
TermDateTermination DateDate
8

Table relationship map

SELECT statement

SELECT CTR1.ContractID AS 'Contract No.', CTR1.Line AS 'Row', CTR1.ManufSN AS 'Mfr Serial No.', CTR1.InternalSN AS 'Serial Number', CTR1.ItemCode AS 'Item No.', CTR1.ItemName AS 'Item Description', CTR1.ItemGroup AS 'Item Group', CTR1.StartDate AS 'Start Date', CTR1.EndDate AS 'End Date', CTR1.ItmGrpName AS 'Item Group Name', CTR1.InsID AS 'Customer Equipment Card ID', CTR1.TermDate AS 'Termination Date' FROM CTR1 AS CTR1

Related information


Service Contract Lines ServiceContract_Lines Object· Table: CTR1
ServiceContract_Lines is a child object of the ServiceContracts object that represents the line entries of each service contract. This object is part of the Service module. Source table: CTR1.
   Parent: Service Contracts ServiceContracts Object· Table: OCTR
Service Contracts OCTR SQL Table

Customer Equipment Card OINS SQL Table

Items OITM SQL Table

Item Groups OITB 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