📚 SAP Business One SDK Help

Table Name: OSCL

Table Description: Service Calls

Field Description Type Size Related Default Value Constraints
callID Call ID Int 11 -      
subject Subject nVarChar 254 -      
customer Business Partner Code nVarChar 15 OCRD      
custmrName Business Partner Name nVarChar 200 -      
contctCode Contact Person Int 11 OCPR      
manufSN Mfr Serial No. nVarChar 36 -      
internalSN Serial Number nVarChar 36 -      
contractID Contract No. Int 11 OCTR      
cntrctDate Contract End Date Date 8 -      
resolDate Resolution Date Date 8 -      
resolTime Resolution Time Int 6 -      
free_1 Warranty VarChar 1 - N Y Yes
            N No
free_2 Warranty End Date Date 8 -      
origin Origin Int 6 OSCO      
itemCode Item No. nVarChar 50 OITM      
itemName Item Description nVarChar 200 -      
itemGroup Item Group Int 6 OITB      
status Status Int 6 OSCS -3    
priority Priority VarChar 1 - L L Low
            M Medium
            H High
callType Call Type Int 6 OSCT      
problemTyp Problem Type Int 6 OSCP      
assignee Handled By Int 6 OUSR      
descrption Description Text 16 -      
objType Object Type nVarChar 20 - 191    
logInstanc Log Instance Int 11 -      
userSign Creating User Int 6 OUSR      
createDate Creation Date Date 8 -      
createTime Creation Time Int 6 -      
closeDate Closing Date Date 8 -      
closeTime Closing Time Int 6 -      
userSign2 Updating User Int 6 OUSR      
updateDate Date of Update Date 8 -      
SCL1Count InternalSCL1Count Int 11 - 0    
SCL2Count InternalSCL2Count Int 11 - 0    
isEntitled Entitle for Service VarChar 1 - N N Not Entitled
            C Valid contract exists
insID Install Card No. Int 11 OINS      
technician Technician Int 11 OHEM      
resolution Resolution Text 16 -      
Scl1NxtLn SCL1 Next Line Int 11 -      
Scl2NxtLn SCL2 Next Line Int 11 -      
Scl3NxtLn SCL3 Next Line Int 11 -      
Scl4NxtLn SCL4 Next Line Int 11 -      
Scl5NxtLn SCL5 Next Line Int 11 -      
isQueue Belongs to a Queue VarChar 1 - N N No
            Y Yes
Queue Queue nVarChar 20 OQUE      
resolOnDat Resolution on Date Date 8 -      
resolOnTim Resolution on Time Int 6 -      
respByDate Response by Date Date 8 -      
respByTime Response by Time Int 6 -      
respOnDate Response on Date Date 8 -      
respOnTime Response on Time Int 6 -      
respAssign Assigned for Response Int 6 OUSR      
AssignDate Assigned Date Date 8 -      
AssignTime Assigned Time Int 6 -      
UpdateTime Updated Time Int 6 -      
responder Responder Int 6 OUSR      
Transfered Year Transfer VarChar 1 - N    
Instance Instance Int 6 - 0    
DocNum Document Number Int 11 -      
Series Series Int 11 NNM1      
Handwrtten Manual Numbering VarChar 1 - N Y Yes
            N No
PIndicator Period Indicator nVarChar 10 OPID ' '    
StartDate Start Date Date 8 -      
StartTime Start Time Int 11 -      
EndDate End Date Date 8 -      
EndTime End Time Int 11 -      
Duration Service Call Duration Num 19.6 -      
DurType Duration UoM VarChar 1 - M S Seconds
            M Minutes
            H Hours
            D Days
Reminder Reminder VarChar 1 - N Y Yes
            N No
RemQty Reminder Quantity Num 19.6 -      
RemType Reminder UoM VarChar 1 - M S Seconds
            M Minutes
            H Hours
            D Days
RemDate Reminder Date Date 8 -      
RemSent Reminder Sent VarChar 1 - N Y Yes
            N No
RemTime Reminder Time Int 6 -      
Location Location Int 6 OCLO -1    
AddrName Address Name nVarChar 50 -      
AddrType Address Type VarChar 1 - S S Ship To
            B Bill To
Street Street nVarChar 100 -      
City City nVarChar 100 -      
Room Room nVarChar 50 -      
State State nVarChar 3 OCST      
Country Country/Region nVarChar 3 OCRY      
DisplInCal Display in Calendar VarChar 1 - N Y Yes
            N No
SupplCode Supplementary Code nVarChar 254 -      
Attachment Attachment Text 16 -      
AtcEntry Attachment Entry Int 11 -      
NumAtCard Business Partner Ref. No. nVarChar 200 -      
ProSubType Problem Subtype Int 6 OPST      
BPType Business Partner Type VarChar 1 - R R Sales
            P Purchasing
Telephone Phone Number nVarChar 50 -      
BPPhone1 BP Phone Number1 nVarChar 50 -      
BPPhone2 BP Phone Number1 nVarChar 50 -      
BPCellular BP Mobile Phone Number nVarChar 50 -      
BPFax BP Fax Number nVarChar 50 -      
BPShipCode BP Ship-to Code nVarChar 50 -      
BPShipAddr BP Ship-to Address nVarChar 254 -      
BPBillCode BP Bill-to Code nVarChar 50 -      
BPBillAddr BP Bill-to Address nVarChar 254 -      
BPTerrit Business Partner Territory Int 11 -      
BPE_Mail Business Partner E-Mail nVarChar 100 -      
BPProjCode Business Partner Project Code nVarChar 20 OPRJ      
BPContact BP Contact Person nVarChar 245 -      
OwnerCode Service Call Owner Int 11 OHEM      
DPPStatus Data Protection Status VarChar 1 - N N None
            D Erased
EncryptIV Encrypt IV nVarChar 100 -      
Printed Printed VarChar 1 - N    
DataVers Data Version Int 11 - 1    
VersionNum Version Number nVarChar 13 -      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Upgrade
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Auto Summary
            D Restore Wizard
            P Partner Implementation
            T Year of Transfer
Key Unique Field
PRIMARY Yes callID
NUM Yes DocNum
    Instance
    PIndicator
SERIES No Series
REMDATE No RemDate
REMTIME No RemTime