drawgrp (DW010100)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/DW010100

Product: Manufacturing (346)
Series:

Display Name: drawgrp
Physical Name: DW010100
Technical Name: drawgrp

Group Display Name: Manufacturing Misc.
Group Technical Name: Manufacturing Misc.

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1DWGNUM_I SearchDWG #StringSTR30_Item_Number30
2ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['drawgrp'].ITEMNMBR AS 'drawgrp-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       DW010100 AS ['drawgrp']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['drawgrp'].ITEMNMBR = ['Item Master'].ITEMNMBR

Leave a Reply

Your email address will not be published. Required fields are marked *