SO Activity field specifications
This table lists the field-column specifications in the SO Activity import interface. Fields with the asterisk (*) symbol are required.
| Col. | Field Name | Type | Size/Format | Description |
|---|---|---|---|---|
| 1 | ACT_NAME* | Varchar2 | 40 | The name for the SO Activity. |
| 2 | SKDGRP_ID* | Number | 22 | The schedule group ID from the SO_SCHEDULE_GROUP table. |
| 3 | COLR_ID* | Number | 22 | The color ID from the COLOUR table. |
| 4 | TCODE_ID* | Number | 22 | The time code ID from the TIME_CODE table. |
| 5 | ACT_FLAG1 | Varchar2 | 1 | One-character flag for general use.
A {space} in one of the flag positions indicates no processing is to be done for that flag. An ampersand (&) in one of the flag positions indicates the flag is to be blanked. |
| 6 | ACT_FLAG2 | Varchar2 | 1 | One-character flag for general use. |
| 7 | ACT_FLAG3 | Varchar2 | 1 | One-character flag for general use. |
| 8 | ACT_FLAG4 | Varchar2 | 1 | One-character flag for general use. |
| 9 | ACT_FLAG5 | Varchar2 | 1 | One-character flag for general use. |
| 10 | ACT_UDF1 | Varchar2 | 40 | User defined field. |
| 11 | ACT_UDF2 | Varchar2 | 40 | User defined field. |
| 12 | ACT_UDF3 | Varchar2 | 40 | User defined field. |
| 13 | ACT_UDF4 | Varchar2 | 40 | User defined field. |
| 14 | ACT_UDF5 | Varchar2 | 40 | User defined field. |