Assembly Transaction History (BM30200)

azurecurveProductsMicrosoft Dynamics GP (0)InventoryAssembly Transaction History (BM30200)

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

Product: Microsoft Dynamics GP (0)
Series: Inventory

Display Name: Assembly Transaction History
Physical Name: BM30200
Technical Name: bmTrxHist

Group Display Name: Bill of Materials Transaction History
Group Technical Name: bmTrxHistGroup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1TRX_ID SearchTRX IDSTR17_TRX_IDString2017
2BM_Trx_Status SearchBM Trx StatusDDL_BM_Trx_StatusInteger20
3BCHSOURC SearchBatch SourceSTR15String1615
4BACHNUMB SearchBatch NumberSTR15_LBAUString1615
5Batch_ID_Note_Index SearchBatch ID Note IndexDLR14Currency1014
6Completion_Date SearchCompletion DateDTDate48
7BM_Start_Date SearchTRX Start DateDT_DateDate46
8TRXDATE SearchTRX DateDT_DateDate46
9PSTGDATE SearchPosting DateDTDate48
10REFRENCE SearchReferenceSTR30String3230
11BM_Trx_Errors SearchBM Trx ErrorsML_BM_Trx_ErrorsLong Integer40
12BM_Component_Errors SearchBM Component ErrorsML_BM_Component_ErrorsLong Integer40
13NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Assembly Transaction History'].NOTEINDX AS 'Assembly Transaction History-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       BM30200 AS ['Assembly Transaction History']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Assembly Transaction History'].NOTEINDX = ['Record Notes Master'].NOTEINDX
14MODIFDT SearchModified DateDTDate48
15USER2ENT SearchUser To EnterSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Assembly Transaction History'].USER2ENT AS 'Assembly Transaction History-User To Enter'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       BM30200 AS ['Assembly Transaction History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Assembly Transaction History'].USER2ENT = ['Users Master'].USERID
16CREATDDT SearchCreated DateDTDate48
17PTDUSRID SearchPosted User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Assembly Transaction History'].PTDUSRID AS 'Assembly Transaction History-Posted User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       BM30200 AS ['Assembly Transaction History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Assembly Transaction History'].PTDUSRID = ['Users Master'].USERID
18POSTEDDT SearchPosted DateDATEDate46
19TRXSORCE SearchTRX SourceSTR13String1413
20USERDEF1 SearchUser Defined 1STR20String2220
21USERDEF2 SearchUser Defined 2STR20String2220
22USRDEF03 SearchUser Defined 3STR20String2220
23USRDEF04 SearchUser Defined 4STR20String2220
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.

azurecurveProductsMicrosoft Dynamics GP (0)InventoryAssembly Transaction History (BM30200)

Leave a Reply

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