QA_Item_MSTR (QAD30000)

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

Product: Manufacturing (346)
Series:

Display Name: QA_Item_MSTR
Physical Name: QAD30000
Technical Name: QA_Item_MSTR

Group Display Name: Manufacturing QA
Group Technical Name: Manufacturing QA

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1POPRCTNM SearchPOP Receipt NumberStringSTR17_POP_Number17
2ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['QA_Item_MSTR'].ITEMNMBR AS 'QA_Item_MSTR-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       QAD30000 AS ['QA_Item_MSTR']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['QA_Item_MSTR'].ITEMNMBR = ['Item Master'].ITEMNMBR
3TYPEOFRECPT SearchType of ReceiptIntegerINT1_RBU1
4QACOMPLETED SearchQA CompletedBooleanCB0
5TOPOST_I SearchTo PostBooleanCB0

Leave a Reply

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