QA_Incoming_LINE (QAD10332)

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

Product: Manufacturing (346)
Series:

Display Name: QA_Incoming_LINE
Physical Name: QAD10332
Technical Name: QA_Incoming_LINE

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1POPRCTNM SearchPOP Receipt NumberStringSTR17_POP_Number17
2RCPTLNNM SearchReceipt Line NumberLong IntegerLI_Sequence_Number10
3PONUMBER SearchPO NumberStringSTR17_POP_Number17
4POLNENUM SearchPO Line NumberLong IntegerLI_Sequence_Number10
5QALOTNUM SearchQA Lot NumberStringSTR2020
6QALOTSEQNUMI SearchQA Lot SEQ NumberLong IntegerLI_Sequence_Number10
7Procedure_stepnumber SearchProcedure stepnumberIntegerINT4_RB_U04
8SERLTNUM SearchSerial/Lot NumberStringSTR2020
9Passed_Inspection SearchPassed InspectionBooleanCB_Passed_Failed0
10Destroyed_in_Testing SearchDestroyed in TestingBooleanDestroyed in Testing0
11defcode SearchDefect CodeStringSTR10_LBAU10
12Disposition_Code SearchDisposition CodeStringSTR10_LBAU10
13Inspector_ID SearchInspector IDStringSTR10_LBAU10
14DATEINSPECTED_I SearchDate InspectedDateDATE6
15SLTSQNUM SearchSerial/Lot SEQ NumberLong IntegerLI_Sequence_Number10
16SERLTQTY SearchSerial/Lot QTYCurrencyDLR17_QTY_RBS0_UTR17
17Actual_Measurement SearchActual MeasurementCurrencyDLR5_QA_RHV11
18Measurement_Unit SearchMeasurement UnitStringSTR1515
19MEASUREMENTQTYI SearchMeasurement QuantityCurrencyDLR12_QTYU12
20Time_Inspected SearchTime InspectedTimeTM6
21CHANGEDATE_I SearchChange DateDateDT8
22USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['QA_Incoming_LINE'].USERID AS 'QA_Incoming_LINE-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       QAD10332 AS ['QA_Incoming_LINE']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['QA_Incoming_LINE'].USERID = ['Users Master'].USERID
23MFGNOTEINDEX2_I SearchMFG Note Index2CurrencyDLR1414

Leave a Reply

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