SOP10106 - Sales User-Defined Work History - table structure
Great Plains Table Structure
- SOP10106 - Sales User-Defined Work History
- Technical Name - SOP_LINE_WORK
- Series - Sales
- Physical Name - SOP10106
| Name | Data Type | Description |
|---|---|---|
| SOPTYPE | smallint | SOP Type |
| SOPNUMBE | char(21) | SOP Number |
| USRDAT01 | datetime | User Defined Date 1 |
| USRDAT02 | datetime | User Defined Date 2 |
| USRTAB01 | char(21) | User Defined Table 1 |
| USRTAB09 | char(21) | User Defined Table 2 |
| USRTAB03 | char(21) | User Defined Table 3 |
| USERDEF1 | char(21) | User Defined 1 |
| USERDEF2 | char(21) | User Defined 2 |
| USRDEF03 | char(21) | User Defined 3 |
| USRDEF04 | char(21) | User Defined 4 |
| USRDEF05 | char(21) | User Defined 5 |
| COMMENT_1 | char(51) | Comment |
| COMMENT_2 | char(51) | Comment |
| COMMENT_3 | char(51) | Comment |
| COMMENT_4 | char(51) | Comment |
| DEX_ROW_ID | int | GPS_Reserved |
| CMMTTEXT | text | Comment Text |