| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | AWACTIVID | Activity ID | String | Generic Edit | 36 | 0 | Allow NULL? |
| 2 | AWSNKY | Session Key | String | Generic Edit | 32 | 0 | Allow NULL? |
| 3 | AWINDID | Identifier ID | String | Generic Edit | 16 | 0 | Allow NULL? |
| 4 | AWINDIDTY | Identifier ID Type | String | UDC (01 IT) | 50 | 0 | Allow NULL? |
| 5 | AWCALTY | Calendar Type | String | UDC (01 CY) | 50 | 0 | Allow NULL? |
| 6 | AWPACTVID | Group Activity ID | String | Generic Edit | 37 | 0 | Allow NULL? |
| 7 | AWACTVPSF | Activity Post Synchronization Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 8 | AWACTVTYP | Activity Type | String | UDC (01 AC) | 41 | 0 | Allow NULL? |
| 9 | AWSUBJECT | Subject | String | Generic Edit | 51 | 0 | Allow NULL? |
| 10 | AWACTVDESC | Description | String | Generic Edit | 1999 | 0 | Allow NULL? |
| 11 | AWLOCATION | Location | String | Generic Edit | 51 | 0 | Allow NULL? |
| 12 | AWORIGNTOR | Originator | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 13 | AWTDSTR | Time Date Start | JDE UTime | Generic Edit | 11 | 0 | |
| 14 | AWTDEND | Time Date End | JDE UTime | Generic Edit | 11 | 0 | |
| 15 | AWALRM | Alarm for activity | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 16 | AWLEADTIME | Lead Time | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 17 | AWLEADTMEU | Lead Time Unit | String | UDC (01 LT) | 41 | 0 | Allow NULL? |
| 18 | AWACTCAT | Category | String | UDC (01 CG) | 51 | 0 | Allow NULL? |
| 19 | AWCOMITLVL | Commitment Level | Numeric | UDC (01 PT) | 1 | 0 | Allow NULL? |
| 20 | AWADI | All Day Indicator | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 21 | AWRECURID | Recurrence ID | String | Generic Edit | 36 | 0 | Allow NULL? |
| 22 | AWRCCUR | Recurrence master flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 23 | AWACTPRV | Private Activity | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | AWACTCMPL | Completed Activity | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 25 | AWTDCMPL | Date Completed | JDE UTime | Generic Edit | 11 | 0 | |
| 26 | AWTDLDS | Last Date Synch | JDE UTime | Generic Edit | 11 | 0 | |
| 27 | AWINTE | Internal origination | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 28 | AWSTPIM | Synch to PIM server | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 29 | AWDOCAL | Display Activity On Calendar | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 30 | AWACCNT | Address Book1 for an activity | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 31 | AWPARTN | Address Book2 for an activity | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 32 | AWACCNTC | Address Book1 Contact for an activity | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 33 | AWPARTNC | Address Book2 contact for an activity | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 34 | AWPLNTY | Plan type for an activity | String | UDC (01 PL) | 3 | 0 | Allow NULL? |
| 35 | AWISTODO | Is To Do | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 36 | AWATVCD1 | Category Code 1 | String | UDC (01 AD) | 3 | 0 | Allow NULL? |
| 37 | AWATVCD2 | Category Code 2 | String | UDC (01 AE) | 3 | 0 | Allow NULL? |
| 38 | AWATVCD3 | Category Code 3 | String | UDC (01 AF) | 3 | 0 | Allow NULL? |
| 39 | AWATVCD4 | Category Code 4 | String | UDC (01 AG) | 3 | 0 | Allow NULL? |
| 40 | AWATVCD5 | Category Code 5 | String | UDC (01 AH) | 3 | 0 | Allow NULL? |
| 41 | AWURCH | Time Zone | String | Generic Edit | 50 | 0 | Allow NULL? |
| 42 | AWURNUM | User Reserved Numeric | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 43 | AWURTIME | User Reserved Time | JDE UTime | Generic Edit | 11 | 0 | |
| 44 | AWACTGHST | Is Activity A Ghost Activity | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 45 | AWUDTTM | Updated Date Time | JDE UTime | Generic Edit | 11 | 0 | |
| 46 | AWUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 47 | AWEDATE | Date Entered | JDE UTime | Generic Edit | 11 | 0 | |
| 48 | AWMKEY | Machine Key | String | Generic Edit | 15 | 0 | Allow NULL? |
| 49 | AWENTDBY | Entered By | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 50 | AWPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |