| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | ClgCode | Activity Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | CardCode | BP Code | nvarchar | 15 | 0 | OCRD | | | Allow NULL? |
| 3 | Notes | Remarks | text | 16 | 0 | | | | |
| 4 | CntctDate | System Date | date | 8 | 0 | | | | |
| 5 | CntctTime | Time | int | 11 | 0 | | | | Allow NULL? |
| 6 | Recontact | Activity Date | date | 8 | 0 | | | | |
| 7 | Closed | Closed Activity | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 8 | CloseDate | Closing Date | date | 8 | 0 | | | | |
| 9 | ContactPer | Contact Person Name | nvarchar | 90 | 0 | | | | Allow NULL? |
| 10 | Tel | Telephone | nvarchar | 20 | 0 | | | | Allow NULL? |
| 11 | Fax | Fax | nvarchar | 20 | 0 | | | | Allow NULL? |
| 12 | CntctSbjct | Activity Subject | int | 6 | 0 | OCLS | -1 | | Allow NULL? |
| 13 | Transfered | Transfered to Next Year | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 14 | DocType | Linked Document | nvarchar | 20 | 0 | | -1 | -1, 0, 1250000001, 13, 132, 1320000012, 14, 140000009, 140000010, 15, 16, 162, 163, 164, 165, 166, 17, 18, 19, 20, 202, 203, 204, 21, 22, 23, 24, 25, 30, 4, 46, 540000006, 57, 59, 60, 67, 68, 69 | Allow NULL? |
| 15 | DocNum | Linked Document Number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 16 | DocEntry | Linked Document Entry | nvarchar | 20 | 0 | | | | Allow NULL? |
| 17 | Attachment | Attachment | text | 16 | 0 | | | | |
| 18 | DataSource | Data Source | char | 1 | 0 | | N | A, D, I, M, N, O, P, T, U | Allow NULL? |
| 19 | AttendUser | Dealt by | int | 6 | 0 | OUSR | | | Allow NULL? |
| 20 | CntctCode | Contact Person | int | 11 | 0 | OCPR | | | Allow NULL? |
| 21 | UserSign | User Signature | int | 6 | 0 | | | | Allow NULL? |
| 22 | SlpCode | Sales Employee | int | 6 | 0 | OSLP | -1 | | Allow NULL? |
| 23 | Action | Activity | char | 1 | 0 | | C | C, E, M, N, P, T | Allow NULL? |
| 24 | Details | Details | nvarchar | 60 | 0 | | | | Allow NULL? |
| 25 | CntctType | Activity Type | int | 6 | 0 | OCLT | -1 | | Allow NULL? |
| 26 | Location | Location | int | 6 | 0 | OCLO | -1 | | Allow NULL? |
| 27 | BeginTime | Start Time | int | 11 | 0 | | | | Allow NULL? |
| 28 | Duration | Activity Duration | num | 19 | 6 | | | | Allow NULL? |
| 29 | DurType | Duration UoM | char | 1 | 0 | | M | D, H, M | Allow NULL? |
| 30 | ENDTime | End Time | int | 11 | 0 | | | | Allow NULL? |
| 31 | Priority | Priority | char | 1 | 0 | | 1 | 0, 1, 2 | Allow NULL? |
| 32 | Reminder | Reminder | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 33 | RemQty | Reminder Quantity | num | 19 | 6 | | | | Allow NULL? |
| 34 | RemType | Reminder Units | char | 1 | 0 | | M | D, H, M | Allow NULL? |
| 35 | OprId | Opportunity - Key | int | 11 | 0 | | | | Allow NULL? |
| 36 | OprLine | Row No. - Opportunity | int | 6 | 0 | | | | Allow NULL? |
| 37 | RemDate | Reminder Date | date | 8 | 0 | | | | |
| 38 | RemTime | Reminder Time | int | 6 | 0 | | | | Allow NULL? |
| 39 | RemSented | Reminder Was Sent | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 40 | Instance | Instance | int | 6 | 0 | | 0 | | Allow NULL? |
| 41 | endDate | End/Due Date | date | 8 | 0 | | | | |
| 42 | status | Status | int | 11 | 0 | OCLA | | | Allow NULL? |
| 43 | personal | Personal Flag | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 44 | inactive | Inactive Flag | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 45 | tentative | Tentative Flag | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 46 | street | Street | nvarchar | 100 | 0 | | | | Allow NULL? |
| 47 | city | City | nvarchar | 100 | 0 | | | | Allow NULL? |
| 48 | country | Country | nvarchar | 3 | 0 | OCRY | | | Allow NULL? |
| 49 | state | State | nvarchar | 3 | 0 | OCST | | | Allow NULL? |
| 50 | room | Room | nvarchar | 50 | 0 | | | | Allow NULL? |
| 51 | parentType | Parent Object Type | nvarchar | 20 | 0 | | | | Allow NULL? |
| 52 | parentId | Parent Object ID | int | 11 | 0 | | | | Allow NULL? |
| 53 | prevActvty | Previous Activity | int | 11 | 0 | | | | Allow NULL? |
| 54 | AtcEntry | Attachment Entry | int | 11 | 0 | | | | Allow NULL? |
| 55 | RecurPat | Recurrence Pattern | char | 1 | 0 | | N | A, D, M, N, W | Allow NULL? |
| 56 | EndType | Recurrence End Type | char | 1 | 0 | | N | C, D, N | Allow NULL? |
| 57 | SeStartDat | Series Start Date | date | 8 | 0 | | | | |
| 58 | SeEndDat | Series End Date | date | 8 | 0 | | | | |
| 59 | MaxOccur | Max Occurrences | int | 11 | 0 | | | | Allow NULL? |
| 60 | Interval | Interval | int | 11 | 0 | | 1 | | Allow NULL? |
| 61 | Sunday | Sunday | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 62 | Monday | Monday | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 63 | Tuesday | Tuesday | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 64 | Wednesday | Wednesday | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 65 | Thursday | Thursday | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 66 | Friday | Friday | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 67 | Saturday | Saturday | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 68 | SubOption | Suboption | char | 1 | 0 | | 1 | 1, 2 | Allow NULL? |
| 69 | DayInMonth | Repeat Day in Month | int | 11 | 0 | | | | Allow NULL? |
| 70 | Month | Repeat Month | int | 11 | 0 | | | | Allow NULL? |
| 71 | DayOfWeek | Repeat Day of Week | int | 11 | 0 | | | | Allow NULL? |
| 72 | Week | Repeat Week in Month | int | 11 | 0 | | | 1, 2, 3, 4, 5 | Allow NULL? |
| 73 | SeriesNum | Series Number | int | 11 | 0 | | | | Allow NULL? |
| 74 | OrigDate | Original Date | date | 8 | 0 | | | | |
| 75 | IsRemoved | Removed Flag | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 76 | LastRemind | Last Reminder Date | date | 8 | 0 | | | | |
| 77 | AssignedBy | Assigned By | int | 6 | 0 | OUSR | | | Allow NULL? |
| 78 | AddrName | Address Name | nvarchar | 50 | 0 | | | | Allow NULL? |
| 79 | AddrType | Address Type | char | 1 | 0 | | S | B, S | Allow NULL? |
| 80 | AttendEmpl | Dealt by Employee | int | 11 | 0 | OHEM | | | Allow NULL? |
