SOP10106 - Sales User Defined (Work & History)
Stores user-defined field values for sales documents.
SQL Query Builder
18 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| SOPTYPE | smallint 0 | ||||
SOP Document Type values (6) 1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order | |||||
| SOPNUMBE | char(21) '' | ||||
| USRDAT01 | datetime '1/1/1900' | ||||
| USRDAT02 | datetime '1/1/1900' | ||||
| USRTAB01 | char(21) '' | ||||
| USRTAB09 | char(21) '' | ||||
| USRTAB03 | char(21) '' | ||||
| USERDEF1 | char(21) '' | ||||
| USERDEF2 | char(21) '' | ||||
| USRDEF03 | char(21) '' | ||||
| USRDEF04 | char(21) '' | ||||
| USRDEF05 | char(21) '' | ||||
| COMMENT_1 | char(51) '' | ||||
| COMMENT_2 | char(51) '' | ||||
| COMMENT_3 | char(51) '' | ||||
| COMMENT_4 | char(51) '' | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
| CMMTTEXT | text | ||||
Reporting Tips
- - Join on SOPNUMBE and SOPTYPE
Related Tables
Tables that share columns with SOP10106. Click "Join" to add to your query.