QA_HIST_Incoming_LINE (QA010332)

azurecurveProductsManufacturing (346)3rd PartyQA_HIST_Incoming_LINE (QA010332)

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

Product: Manufacturing (346)
Series:

Display Name: QA_HIST_Incoming_LINE
Physical Name: QA010332
Technical Name: QA_HIST_Incoming_LINE

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

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

Click to show/hide

SELECT
       ['QA_HIST_Incoming_LINE'].USERID AS 'QA_HIST_Incoming_LINE-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       QA010332 AS ['QA_HIST_Incoming_LINE']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['QA_HIST_Incoming_LINE'].USERID = ['Users Master'].USERID
21MFGNOTEINDEX2_I SearchMFG Note Index2CurrencyDLR1414
azurecurveProductsManufacturing (346)3rd PartyQA_HIST_Incoming_LINE (QA010332)

Leave a Reply

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