Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT00150
Product: Extender (3107)
Series: Project
Display Name: v11 - Extender List Notes Group Display Name: Extender Notes
Physical Name: EXT00150
Technical Name: PT_Extender_List_Notes
Group Technical Name: Extender Notes
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | Extender_Type  | Extender Type | INT5 | Integer | 4 | |
| 2 | Extender_ID | Extender ID | STR15_LBAU | String | 15 | |
| 3 | Window_Number | Window Number | INT5 | Integer | 4 | |
| 4 | PT_UD_Key | PT UD Key | STR200 | String | 200 | |
| 5 | LNITMSEQ | Line Item Sequence | LI_Sequence_Number | Long Integer | 10 | |
| 6 | DATE1 | Date | DT6 | Date | 6 | |
| 7 | TIME1 | Time | TM6 | Time | 6 | |
| 8 | USERID | User ID | STR15_User_ID | String | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['v11 - Extender List Notes'].USERID AS 'v11 - Extender List Notes-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
EXT00150 AS ['v11 - Extender List Notes']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['v11 - Extender List Notes'].USERID = ['Users Master'].USERID | ||||||
| 9 | Note_Type | Note Type | INT | Integer | 0 | |
| 10 | TXTFIELD | Text Field | TX32000 | Text | 32000 | |