biuan SAP® BUSINESS ONE SDK
DTW Business Partners / Activity / Activities
API Activities Service / Activity
OCLG - Activities Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ClgCode KEY UNIQUEActivity NumberInt
11
PRIMARYYes
CardCode KEYBP CodenVarChar
15OCRD
Business Partner
CRD_CODENo
NotesRemarksText
16
CntctDateSystem DateDate
8
CntctTimeTimeInt
11
RecontactActivity DateDate
8
ClosedClosed ActivityVarChar
Y) Yes
N) No
1
N
CloseDateClosing DateDate
8
ContactPerContact Person NamenVarChar
90
TelTelephonenVarChar
20
FaxFaxnVarChar
20
CntctSbjctActivity SubjectInt
6OCLS
Activity Subjects
-1
TransferedTransfered to Next YearVarChar
Y) Yes
N) No
1
N
DocTypeLinked DocumentnVarChar
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
20
-1
DocNumLinked Document NumbernVarChar
20
DocEntryLinked Document EntrynVarChar
20
AttachmentAttachmentText
16
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
AttendUserDealt byInt
6OUSR
Users
CntctCodeContact PersonInt
11OCPR
Contact Persons
UserSignUser SignatureInt
6
SlpCodeSales EmployeeInt
11OSLP
Sales Employee
-1
ActionActivityVarChar
C) Phone Call
M) Meeting
T) Task
E) Note
P) Campaign
N) Other
1
C
DetailsDetailsnVarChar
100
CntctTypeActivity TypeInt
6OCLT
Activity Types
-1
LocationLocationInt
6OCLO
Meetings Location
-1
BeginTimeStart TimeInt
11
DurationActivity DurationNum
20
DurTypeDuration UoMVarChar
M) Minutes
H) Hours
D) Days
1
M
ENDTimeEnd TimeInt
11
PriorityPriorityVarChar
0
1) Normal
2) High
1
1
ReminderReminderVarChar
Y) Yes
N) No
1
N
RemQtyReminder QuantityNum
20
RemTypeReminder UnitsVarChar
M) Minutes
H) Hours
D) Days
1
M
OprId KEYOpportunity - KeyInt
11
OPPORTNo
OprLineRow No. - OpportunityInt
6
RemDateReminder DateDate
8
RemTimeReminder TimeInt
6
RemSentedReminder Was SentVarChar
Y) Yes
N) No
1
N
InstanceInstanceInt
6
0
endDateEnd/Due DateDate
8
statusStatusInt
11OCLA
Activity Status
personalPersonal FlagVarChar
Y) Yes
N) No
1
N
inactiveInactive FlagVarChar
Y) Yes
N) No
1
N
tentativeTentative FlagVarChar
Y) Yes
N) No
1
N
streetStreetnVarChar
100
cityCitynVarChar
100
countryCountrynVarChar
3OCRY
Countries
stateStatenVarChar
3OCST
States
roomRoomnVarChar
50
parentTypeParent Object TypenVarChar
20
parentIdParent Object IDInt
11
prevActvtyPrevious ActivityInt
11
AtcEntryAttachment EntryInt
11
RecurPatRecurrence PatternVarChar
N) None
D) Daily
W) Weekly
M) Monthly
A) Annually
1
N
EndTypeRecurrence End TypeVarChar
N) No End Date
C) By Counter
D) By Date
1
N
SeStartDatSeries Start DateDate
8
SeEndDatSeries End DateDate
8
MaxOccurMax OccurrencesInt
11
IntervalIntervalInt
11
1
SundaySundayVarChar
N) No
Y) Yes
1
N
MondayMondayVarChar
N) No
Y) Yes
1
N
TuesdayTuesdayVarChar
N) No
Y) Yes
1
N
WednesdayWednesdayVarChar
N) No
Y) Yes
1
N
ThursdayThursdayVarChar
N) No
Y) Yes
1
N
FridayFridayVarChar
N) No
Y) Yes
1
N
SaturdaySaturdayVarChar
N) No
Y) Yes
1
N
SubOptionSuboptionVarChar
1) Option 1
2) Option 2
1
1
DayInMonthRepeat Day in MonthInt
11
MonthRepeat MonthInt
11
DayOfWeekRepeat Day of WeekInt
11
WeekRepeat Week in MonthInt
1) first
2) second
3) third
4) fourth
5) last
11
SeriesNumSeries NumberInt
11
OrigDateOriginal DateDate
8
IsRemovedRemoved FlagVarChar
N) No
Y) Yes
1
N
LastRemindLast Reminder DateDate
8
AssignedByAssigned ByInt
6OUSR
Users
AddrNameAddress NamenVarChar
50
AddrTypeAddress TypeVarChar
S) Ship To
B) Bill to
1
S
AttendEmplDealt by EmployeeInt
11OHEM
Employees
NextDateDate of Next OccurrenceDate
8
NextTimeTime of Next OccurrenceInt
6

Table relationship map

SELECT statement

SELECT OCLG.ClgCode AS 'Activity Number', OCLG.CardCode AS 'BP Code', OCLG.Notes AS 'Remarks', OCLG.CntctDate AS 'System Date', OCLG.CntctTime AS 'Time', OCLG.Recontact AS 'Activity Date', OCLG.Closed AS 'Closed Activity', OCLG.CloseDate AS 'Closing Date', OCLG.ContactPer AS 'Contact Person Name', OCLG.Tel AS 'Telephone', OCLG.Fax AS 'Fax', OCLG.CntctSbjct AS 'Activity Subject', OCLG.Transfered AS 'Transfered to Next Year', OCLG.DocType AS 'Linked Document', OCLG.DocNum AS 'Linked Document Number', OCLG.DocEntry AS 'Linked Document Entry', OCLG.Attachment AS 'Attachment', OCLG.DataSource AS 'Data Source', OCLG.AttendUser AS 'Dealt by', OCLG.CntctCode AS 'Contact Person', OCLG.UserSign AS 'User Signature', OCLG.SlpCode AS 'Sales Employee', OCLG.Action AS 'Activity', OCLG.Details AS 'Details', OCLG.CntctType AS 'Activity Type', OCLG.Location AS 'Location', OCLG.BeginTime AS 'Start Time', OCLG.Duration AS 'Activity Duration', OCLG.DurType AS 'Duration UoM', OCLG.ENDTime AS 'End Time', OCLG.Priority AS 'Priority', OCLG.Reminder AS 'Reminder', OCLG.RemQty AS 'Reminder Quantity', OCLG.RemType AS 'Reminder Units', OCLG.OprId AS 'Opportunity - Key', OCLG.OprLine AS 'Row No. - Opportunity', OCLG.RemDate AS 'Reminder Date', OCLG.RemTime AS 'Reminder Time', OCLG.RemSented AS 'Reminder Was Sent', OCLG.Instance AS 'Instance', OCLG.endDate AS 'End/Due Date', OCLG.status AS 'Status', OCLG.personal AS 'Personal Flag', OCLG.inactive AS 'Inactive Flag', OCLG.tentative AS 'Tentative Flag', OCLG.street AS 'Street', OCLG.city AS 'City', OCLG.country AS 'Country', OCLG.state AS 'State', OCLG.room AS 'Room', OCLG.parentType AS 'Parent Object Type', OCLG.parentId AS 'Parent Object ID', OCLG.prevActvty AS 'Previous Activity', OCLG.AtcEntry AS 'Attachment Entry', OCLG.RecurPat AS 'Recurrence Pattern', OCLG.EndType AS 'Recurrence End Type', OCLG.SeStartDat AS 'Series Start Date', OCLG.SeEndDat AS 'Series End Date', OCLG.MaxOccur AS 'Max Occurrences', OCLG.Interval AS 'Interval', OCLG.Sunday AS 'Sunday', OCLG.Monday AS 'Monday', OCLG.Tuesday AS 'Tuesday', OCLG.Wednesday AS 'Wednesday', OCLG.Thursday AS 'Thursday', OCLG.Friday AS 'Friday', OCLG.Saturday AS 'Saturday', OCLG.SubOption AS 'Suboption', OCLG.DayInMonth AS 'Repeat Day in Month', OCLG.Month AS 'Repeat Month', OCLG.DayOfWeek AS 'Repeat Day of Week', OCLG.Week AS 'Repeat Week in Month', OCLG.SeriesNum AS 'Series Number', OCLG.OrigDate AS 'Original Date', OCLG.IsRemoved AS 'Removed Flag', OCLG.LastRemind AS 'Last Reminder Date', OCLG.AssignedBy AS 'Assigned By', OCLG.AddrName AS 'Address Name', OCLG.AddrType AS 'Address Type', OCLG.AttendEmpl AS 'Dealt by Employee', OCLG.NextDate AS 'Date of Next Occurrence', OCLG.NextTime AS 'Time of Next Occurrence' FROM OCLG AS OCLG

Related information


Activity Activity Object· Table: OCLG
Activities refer to interactions you have with business partners, such as phone calls, meetings, tasks, and so on. All activities are automatically recorded in your calendar and in activity reports. In phone calls, meetings, and tasks, you can...
   Parent: Activities Service ActivitiesService Service· Table: OCLG

Activity Instance Params ActivityInstanceParams Object· Table: OCLG
Holds the key and date of an instance in a recurring activity. This object is used to pass keys to and retrieve keys from ActivitiesService methods. Source table: OCLG.
   Parent: Activities Service ActivitiesService Service· Table: OCLG

Activity Params ActivityParams Object· Table: OCLG
Holds the key of an activity. This object is used to pass keys to and retrieve keys from ActivitiesService methods. Source table: OCLG.
   Parent: Activities Service ActivitiesService Service· Table: OCLG

Activities Service ActivitiesService Service· Table: OCLG
The ActivitiesService service enables you to add, look up, remove, and update single activities and recurring activities. Source table: OCLG.


Contacts Contacts Object· Table: OCLG
Contacts is a business object that represents the activities with customers and vendors in the Business Partners module. This object enables you to: Add an activity. Retrieve an activity by its key. Update an activity. Save the object in...

OCLG SQL Table

Users OUSR SQL Table

Employees OHEM SQL Table

Business Partner OCRD SQL Table

Contact Persons OCPR SQL Table

Activity Subjects OCLS SQL Table

Activity Types OCLT SQL Table

Countries OCRY SQL Table

Meetings Location OCLO SQL Table

Sales Employee OSLP SQL Table

States OCST SQL Table

Activity Status OCLA 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