📚 SAP Business One SDK Help

Table Name: OCLG

Table Description: Activities

Field Description Type Size Related Default Value Constraints
ClgCode Activity Number Int 11 -      
CardCode BP Code nVarChar 15 OCRD      
Notes Remarks Text 16 -      
CntctDate System Date Date 8 -      
CntctTime Time Int 11 -      
Recontact Activity Date Date 8 -      
Closed Closed Activity VarChar 1 - N Y Closed
            N Open
CloseDate Closing Date Date 8 -      
ContactPer Contact Person Name nVarChar 90 -      
Tel Telephone nVarChar 50 -      
Fax Fax nVarChar 50 -      
CntctSbjct Activity Subject Int 6 OCLS -1    
Transfered Transfered to Next Year VarChar 1 - N Y Yes
            N No
DocType Linked Document nVarChar 20 - -1 13 A/R Invoice
            14 A/R Credit Memo
            15 Delivery
            16 Return
            17 Sales Order
            18 A/P Invoice
            19 A/P Credit Memo
            20 Goods Receipt PO
            21 Goods Return
            22 Purchase Order
            23 Sales Quotation
            24 Incoming Payment
            25 Deposit
            30 Journal Entry
            46 Outgoing Payment
            57 Checks for Payment
            59 Goods Receipt
            60 Goods Issue
            1250000001 Inventory Transfer Request
            67 Inventory Transfer
            68 Work Order
            69 Landed Costs
            132 Correction Invoice
            162 Material Revaluation
            202 Production Order
            203 A/R Down Payment
            204 A/P Down Payment
            140000009 Outgoing Excise Invoice
            140000010 Incoming Excise Invoice
            -1  
            0  
            4 Items
            163 A/P Correction Invoice
            164 A/P Correction Invoice Reversal
            165 A/R Correction Invoice
            166 A/R Correction Invoice Reversal
            1320000012 Campaign
            540000006 Purchase Quotation
            1250000025 Blanket Agreements
            1470000113 Purchase Request
            112 Document Drafts
            140 Payment Drafts
            123 Checks for Payment Drafts
            254000065 Self Invoice
            254000066 Self Credit Memo
            234000031 Return Request
            234000032 Goods Return Request
            1250000026 Sales Blanket Agreement
            1250000027 Purchasing Blanket Agreement
DocNum Linked Document Number nVarChar 50 -      
DocEntry Linked Document Entry nVarChar 50 -      
Attachment Attachment Text 16 -      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
AttendUser Dealt by Int 6 OUSR      
CntctCode Contact Person Int 11 OCPR      
UserSign User Signature Int 6 -      
SlpCode Sales Employee Int 11 OSLP -1    
Action Activity VarChar 1 - C C Phone Call
            M Meeting
            T Task
            L E-Mail
            E Note
            P Campaign
            N Other
Details Details nVarChar 100 -      
CntctType Activity Type Int 6 OCLT -1    
Location Location Int 6 OCLO -1    
BeginTime Start Time Int 11 -      
Duration Activity Duration Num 19.6 -      
DurType Duration UoM VarChar 1 - M S Seconds
            M Minutes
            H Hours
            D Days
ENDTime End Time Int 11 -      
Priority Priority VarChar 1 - 1 0 Low
            1 Normal
            2 High
Reminder Reminder VarChar 1 - N Y Yes
            N No
RemQty Reminder Quantity Num 19.6 -      
RemType Reminder Units VarChar 1 - M S Seconds
            M Minutes
            H Hours
            D Days
OprId Opportunity - Key Int 11 -      
OprLine Row No. - Opportunity Int 6 -      
RemDate Reminder Date Date 8 -      
RemTime Reminder Time Int 6 -      
RemSented Reminder Was Sent VarChar 1 - N Y Yes
            N No
Instance Instance Int 6 - 0    
endDate End/Due Date Date 8 -      
status Status Int 11 OCLA      
personal Personal Flag VarChar 1 - N Y Yes
            N No
inactive Inactive Flag VarChar 1 - N Y Yes
            N No
emailed Emailed Flag VarChar 1 - N Y Yes
            N No
tentative Tentative Flag VarChar 1 - N Y Yes
            N No
street Street nVarChar 100 -      
city City nVarChar 100 -      
country Country/Region nVarChar 3 OCRY      
state State nVarChar 3 OCST      
room Room nVarChar 50 -      
parentType Parent Object Type nVarChar 20 -   97 Opportunity
            191 Service Call
parentId Parent Object ID Int 11 -      
prevActvty Previous Activity Int 11 -      
AtcEntry Attachment Entry Int 11 -      
RecurPat Recurrence Pattern VarChar 1 - N N None
            D Daily
            W Weekly
            M Monthly
            A Annually
EndType Recurrence End Type VarChar 1 - N N No End Date
            C By Counter
            D By Date
SeStartDat Series Start Date Date 8 -      
SeEndDat Series End Date Date 8 -      
MaxOccur Max Occurrences Int 11 -      
Interval Interval Int 11 - 1    
Sunday Sunday VarChar 1 - N N No
            Y Yes
Monday Monday VarChar 1 - N N No
            Y Yes
Tuesday Tuesday VarChar 1 - N N No
            Y Yes
Wednesday Wednesday VarChar 1 - N N No
            Y Yes
Thursday Thursday VarChar 1 - N N No
            Y Yes
Friday Friday VarChar 1 - N N No
            Y Yes
Saturday Saturday VarChar 1 - N N No
            Y Yes
SubOption Suboption VarChar 1 - 1 1 Option 1
            2 Option 2
DayInMonth Repeat Day in Month Int 11 -      
Month Repeat Month Int 11 -      
DayOfWeek Repeat Day of Week Int 11 -      
Week Repeat Week in Month Int 11 -   1 first
            2 second
            3 third
            4 fourth
            5 last
SeriesNum Series Number Int 11 -      
OrigDate Original Date Date 8 -      
IsRemoved Removed Flag VarChar 1 - N N No
            Y Yes
LastRemind Last Reminder Date Date 8 -      
AssignedBy Assigned By Int 6 OUSR      
AddrName Address Name nVarChar 50 -      
AddrType Address Type VarChar 1 - S S Ship To
            B Bill To
AttendEmpl Dealt by Employee Int 11 OHEM      
NextDate Date of Next Occurrence Date 8 -      
NextTime Time of Next Occurrence Int 6 -      
OwnerCode Activities Owner Int 11 OHEM      
AttendReci Attend Recipient Int 11 ORCI      
ActType Activity Type Int 11 PMC5      
LaborItem Labor Item No. nVarChar 50 -      
ResCode Resource Code from ORSC nVarChar 50 ORSC      
FIPROJECT Financial Project nVarChar 20 OPRJ      
UpdateDate Date of Update Date 8 -      
LogInstanc Log Instance Int 11 - 0    
UserSign2 Updating User Int 6 OUSR      
DPPStatus Data Protection Status VarChar 1 - N N None
            D Erased
CreateDate Creation Date Date 8 -      
EncryptIV Encrypt IV nVarChar 100 -      
DataVers Data Version Int 11 - 1    
Of365EvtId Office 365 Event ID nVarChar 200 -      
AssigneeTy Assignee Type Int 11 - 12 12 User
            171 Employee
            234000033 Recipient List
            -1 Multiple Recipients
VersionNum Version Number nVarChar 13 -      
Key Unique Field
PRIMARY Yes ClgCode
CRD_CODE No CardCode
OPPORT No OprId
    OprLine