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 TypeLength
1TYPEOFRECPT SearchType of ReceiptINT1_RBUInteger1
2POPRCTNM SearchPOP Receipt NumberSTR17_POP_NumberString17
3PONUMBER SearchPO NumberSTR17_POP_NumberString17
4POLNENUM SearchPO Line NumberLI_Sequence_NumberLong Integer10
5RCPTLNNM SearchReceipt Line NumberLI_Sequence_NumberLong Integer10
6QAQCNEEDED_I SearchQA/QC NeededCB_QA_SequenceBoolean0
7QACOMPLETED SearchQA CompletedCBBoolean0
8Passed_Inspection SearchPassed InspectionCB_Passed_FailedBoolean0
9QA_Item_Tracking_Group SearchQA_Item_Tracking_GroupGBInteger0
10BASEUOFM SearchBase U Of MU_Of_MString8
11nsrnum SearchNSR NumberSTR20_Document_NumberString20
12SCAR_Number SearchSCAR NumberSTR20_Document_NumberString20
13Procedure_Number SearchProcedure NumberSTR10_Procedure_NumberString10
14QAPROCREVLEVI SearchQA Procedure Revision LevelINT4Integer4
15READYTOPOSTI SearchReady to PostCBBoolean0
16SAVEDTOBATCHI SearchSaved to BatchCBBoolean0
17POSTEDTOINVI SearchPosted to InventoryCBBoolean0
18QTYPASSED_I SearchQTY PassedDLR17_QTY_RBU2Currency17
19QTYFAILED_I SearchQTY FailedDLR17_QTY_RBU2Currency17
20QTY_Destroyed_in_Testing SearchQTY Destroyed in TestingDLR17_QTY_RBU2Currency17
21MFGNOTEINDEX_I SearchMFG Note IndexDLR14Currency14
22MFGNOTEINDEX2_I SearchMFG Note Index2DLR14Currency14
23MFGNOTEINDEX3_I SearchMFG Note Index3DLR14Currency14
24DEX_ROW_ID Searchintint10

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 *