QA_HIST_Incoming_HDR (QA010032)

azurecurveProductsManufacturing (346)3rd PartyQA_HIST_Incoming_HDR (QA010032)

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

Product: Manufacturing (346)
Series: 3rd Party

Display Name: QA_HIST_Incoming_HDR
Physical Name: QA010032
Technical Name: QA_HIST_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
2RECEIVINGNUMBER_I SearchReceiving NumberSTR20_Document_NumberString20
3RECTRANSNUMBER_I SearchReceiving Transaction NumberINT4Integer4
4PORDNMBR SearchPurchase Order NumberPurchase Order NumberString20
5QAQCNEEDED_I SearchQA/QC NeededCB_QA_SequenceBoolean0
6QACOMPLETED SearchQA CompletedCBBoolean0
7Passed_Inspection SearchPassed InspectionCB_Passed_FailedBoolean0
8QA_Item_Tracking_Group SearchQA_Item_Tracking_GroupGBInteger0
9BASEUOFM SearchBase U Of MU_Of_MString8
10nsrnum SearchNSR NumberSTR20_Document_NumberString20
11SCAR_Number SearchSCAR NumberSTR20_Document_NumberString20
12Procedure_Number SearchProcedure NumberSTR10_Procedure_NumberString10
13QAPROCREVLEVI SearchQA Procedure Revision LevelINT4Integer4
14READYTOPOSTI SearchReady to PostCBBoolean0
15SAVEDTOBATCHI SearchSaved to BatchCBBoolean0
16POSTEDTOINVI SearchPosted to InventoryCBBoolean0
17QTYPASSED_I SearchQTY PassedDLR17_QTY_RBU2Currency17
18QTYFAILED_I SearchQTY FailedDLR17_QTY_RBU2Currency17
19QTY_Destroyed_in_Testing SearchQTY Destroyed in TestingDLR17_QTY_RBU2Currency17
20MFGNOTEINDEX_I SearchMFG Note IndexDLR14Currency14
21MFGNOTEINDEX2_I SearchMFG Note Index2DLR14Currency14
22MFGNOTEINDEX3_I SearchMFG Note Index3DLR14Currency14
23DEX_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.

azurecurveProductsManufacturing (346)3rd PartyQA_HIST_Incoming_HDR (QA010032)

Leave a Reply

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