| 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 | 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=No, Y=Yes | Allow NULL? |
| 14 | DocType | Linked Document | nvarchar | 20 | 0 | | -1 | -1, 0, 132=Correction Invoice, 13=A/R Invoice, 140000009=Outgoing Excise Invoice, 140000010=Incoming Excise Invoice, 14=A/R Credit Memo, 15=Delivery notes, 162=Material Revaluation, 163=Correction A/P Invoice, 164=Correction A/P Invoice Reversal, 165=Correction A/R Invoice, 166=Correction A/R Invoice Reversal, 16=A/R Return, 17=Sales Order | 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=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 | 6 | 0 | OSLP | -1 | | Allow NULL? |
| 23 | Action | Activity | char | 1 | 0 | | C | C=Phone Call, E=Note, M=Meeting, N=Other, T=Task | 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=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? |