📚 SAP Business One SDK Help

Table Name: OCTR

Table Description: Service Contracts

Field Description Type Size Related Default Value Constraints
ContractID Contract No. Int 11 -      
CstmrCode Business Partner Code nVarChar 15 OCRD      
CstmrName Business Partner Name nVarChar 200 -      
CntctCode Contact Person Code Int 11 OCPR      
Owner Owner Int 6 OUSR      
Status Contract Status VarChar 1 - D A Approved
            F On Hold
            D Draft
            T Terminated
CntrcTmplt Contract Template nVarChar 20 OCTT      
CntrcType Contract Type VarChar 1 - S C Business Partner
            G Item Group
            S Serial Number
Renewal Renewal VarChar 1 - N Y Yes
            N No
RemindVal Reminder Time Int 6 -      
RemindUnit Remind Unit VarChar 1 - D D Day(s)
            W Week(s)
            M Month(s)
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 1 - D D Day(s)
            H Hour(s)
Descriptio Description nVarChar 254 -      
SrcDocType Source Document Type VarChar 1 - I Q Sales Quotation
            O Sales Order
            D Delivery
            I A/R Invoice
DocNum Source Document Int 11 -      
MonEnabled Monday Enabled VarChar 1 - Y Y Yes
            N No
TueEnabled Tuesday Enabled VarChar 1 - Y Y Yes
            N No
WedEnabled Wednesday Enabled VarChar 1 - Y Y Yes
            N No
ThuEnabled Thursday Enabled VarChar 1 - Y Y Yes
            N No
FriEnabled Friday Enabled VarChar 1 - Y Y Yes
            N No
SatEnabled Saturday Enabled VarChar 1 - Y Y Yes
            N No
SunEnabled Sunday Enabled VarChar 1 - Y Y Yes
            N No
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 1 - N N No
            Y Yes
InclWork Include Labor VarChar 1 - N N No
            Y Yes
InclTravel Include Travel VarChar 1 - N N No
            Y Yes
Attachment Attachments Text 16 -      
CreateDate Creation Date Date 8 -      
Remarks1 Template Remarks Text 16 -      
Remarks2 Remarks Text 16 -      
RemindFlg Reminder Sent VarChar 1 - N Y Yes
            N No
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 1 - N N No
            Y Yes
SrvcType Service Type VarChar 1 - R R Regular
            W Warranty
TermDate Termination Date Date 8 -      
ResponseV Response Time Int 6 -      
ResponseU Response Unit VarChar 1 - H D Day(s)
            H Hour(s)
AtcEntry Attachment Entry Int 11 OATC      
Transfered Year Transfer VarChar 1 - N    
Instance Instance Int 6 - 0    
BPType BP Type VarChar 1 - R R Sales
            P Purchasing
OwnerCode Service Contract Owner Int 11 OHEM      
UserSign User Signature Int 6 OUSR      
ObjType Object Type - History nVarChar 20 - 190    
LogInstanc Log Instance - History Int 11 -      
UserSign2 Updating User - History Int 6 OUSR      
UpdateDate Date of Update - History Date 8 -      
DPPStatus Data Protection Status VarChar 1 - N N None
            D Erased
EncryptIV Encrypt IV nVarChar 100 -      
Printed Printed VarChar 1 - N    
Key Unique Field
PRIMARY Yes ContractID