QA_Incoming_HDR (QAD10032)

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

Product: Manufacturing (346)
Series: 3rd Party

Display Name: QA_Incoming_HDR
Physical Name: QAD10032
Technical Name: QA_Incoming_HDR

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1TYPEOFRECPT SearchType of ReceiptINT1_RBUInteger21
2POPRCTNM SearchPOP Receipt NumberSTR17_POP_NumberString1817
3PONUMBER SearchPO NumberSTR17_POP_NumberString1817
4POLNENUM SearchPO Line NumberLI_Sequence_NumberLong Integer410
5RCPTLNNM SearchReceipt Line NumberLI_Sequence_NumberLong Integer410
6QAQCNEEDED_I SearchQA/QC NeededCB_QA_SequenceBoolean20
7QACOMPLETED SearchQA CompletedCBBoolean20
8Passed_Inspection SearchPassed InspectionCB_Passed_FailedBoolean20
9QA_Item_Tracking_Group SearchQA_Item_Tracking_GroupGBInteger20
10BASEUOFM SearchBase U Of MU_Of_MString108
11nsrnum SearchNSR NumberSTR20_Document_NumberString2220
12SCAR_Number SearchSCAR NumberSTR20_Document_NumberString2220
13Procedure_Number SearchProcedure NumberSTR10_Procedure_NumberString1210
14QAPROCREVLEVI SearchQA Procedure Revision LevelINT4Integer24
15READYTOPOSTI SearchReady to PostCBBoolean20
16SAVEDTOBATCHI SearchSaved to BatchCBBoolean20
17POSTEDTOINVI SearchPosted to InventoryCBBoolean20
18QTYPASSED_I SearchQTY PassedDLR17_QTY_RBU2Currency1017
19QTYFAILED_I SearchQTY FailedDLR17_QTY_RBU2Currency1017
20QTY_Destroyed_in_Testing SearchQTY Destroyed in TestingDLR17_QTY_RBU2Currency1017
21MFGNOTEINDEX_I SearchMFG Note IndexDLR14Currency1014
22MFGNOTEINDEX2_I SearchMFG Note Index2DLR14Currency1014
23MFGNOTEINDEX3_I SearchMFG Note Index3DLR14Currency1014
24DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

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