| 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=No, Y=Yes | Allow NULL? |
| 8 | CloseDate | Closing Date | date | 8 | 0 | | | | |
| 9 | ContactPer | Contact Person Name | nvarchar | 90 | 0 | | | | Allow NULL? |
| 10 | Tel | Telephone | nvarchar | 50 | 0 | | | | Allow NULL? |
| 11 | Fax | Fax | nvarchar | 20 | 0 | | | | Allow NULL? |
| 12 | CntctSbjct | Activity Subject | int | 6 | 0 | OCLS | -1 | | Allow NULL? |
| 13 | Transfered | Transferred to Next Year | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 14 | DocType | Linked Document | nvarchar | 20 | 0 | | -1 | -1, 0, 112=Document Drafts, 123=Checks for Payment Drafts, 1250000001=Inventory Transfer Request, 1250000025=Blanket Agreements, 1320000012=Campaign, 132=Correction Invoice, 13=A/R Invoice, 140000009=Outgoing Excise Invoice, 140000010=Incoming Excise Invoice, 140=Payment Drafts, 1470000113=Purchase Request, 14=A/R Credit Memo, 15=Delivery, | Allow NULL? |
| 15 | DocNum | Linked Document Number | nvarchar | 50 | 0 | | | | Allow NULL? |
| 16 | DocEntry | Linked Document Entry | nvarchar | 50 | 0 | | | | Allow NULL? |
| 17 | Attachment | Attachment | text | 16 | 0 | | | | |
| 18 | DataSource | Data Source | char | 1 | 0 | | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update | 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 | 11 | 0 | OSLP | -1 | | Allow NULL? |
| 23 | Action | Activity | char | 1 | 0 | | C | C=Phone Call, E=Note, M=Meeting, N=Other, P=Campaign, T=Task | Allow NULL? |
| 24 | Details | Details | nvarchar | 100 | 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=Days, H=Hours, M=Minutes | Allow NULL? |
| 30 | ENDTime | End Time | int | 11 | 0 | | | | Allow NULL? |
| 31 | Priority | Priority | char | 1 | 0 | | 1 | 0=Low, 1=Normal, 2=High | Allow NULL? |
| 32 | Reminder | Reminder | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 33 | RemQty | Reminder Quantity | num | 19 | 6 | | | | Allow NULL? |
| 34 | RemType | Reminder Units | char | 1 | 0 | | M | D=Days, H=Hours, M=Minutes | 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=No, Y=Yes | 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=No, Y=Yes | Allow NULL? |
| 44 | inactive | Inactive Flag | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 45 | tentative | Tentative Flag | char | 1 | 0 | | N | N=No, Y=Yes | 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=Annually, D=Daily, M=Monthly, N=None, W=Weekly | Allow NULL? |
| 56 | EndType | Recurrence End Type | char | 1 | 0 | | N | C=By Counter, D=By Date, N=No End Date | 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=No, Y=Yes | Allow NULL? |
| 62 | Monday | Monday | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 63 | Tuesday | Tuesday | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 64 | Wednesday | Wednesday | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 65 | Thursday | Thursday | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 66 | Friday | Friday | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 67 | Saturday | Saturday | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 68 | SubOption | Suboption | char | 1 | 0 | | 1 | 1=Option 1, 2=Option 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=First, 2=Second, 3=Third, 4=Fourth, 5=Last | 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=No, Y=Yes | 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=Bill To, S=Ship To | Allow NULL? |
| 80 | AttendEmpl | Dealt by Employee | int | 11 | 0 | OHEM | | | Allow NULL? |
| 81 | NextDate | Date of Next Occurrence | date | 8 | 0 | | | | |
| 82 | NextTime | Time of Next Occurrence | int | 6 | 0 | | | | Allow NULL? |
| 83 | OwnerCode | Activities Owner | int | 11 | 0 | OHEM | | | Allow NULL? |
| 84 | AttendReci | Attend Recipient | int | 11 | 0 | ORCI | | | Allow NULL? |
| 85 | ActType | Activity Type | int | 11 | 0 | PMC5 | | | Allow NULL? |
| 86 | LaborItem | Labor Item No. | nvarchar | 50 | 0 | | | | Allow NULL? |
| 87 | ResCode | Resource Code from ORSC | nvarchar | 50 | 0 | ORSC | | | Allow NULL? |
| 88 | FIPROJECT | Financial Project | nvarchar | 20 | 0 | OPRJ | | | Allow NULL? |
| 89 | UpdateDate | Date of Update | date | 8 | 0 | | | | |
| 90 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 91 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 92 | DPPStatus | Data Protection Status | char | 1 | 0 | | N | D=Erased, N=None | Allow NULL? |
| 93 | CreateDate | Creation Date | date | 8 | 0 | | | | |
