| 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 |
| |
|
|
|
|
|
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 |
| 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 |
- |
|
|
|