Activities - History - SAP B1 SDK Help

Table Name: ACLG

Table Description: Activities - History

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	Yes
						N	No
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	Transferred 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
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
						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
		LogInstanc
CRD_CODE	No	CardCode
OPPORT	No	OprId
		OprLine