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 TypeLength
1TRX_ID SearchTRX IDSTR17_TRX_IDString17
2BM_Trx_Status SearchBM Trx StatusDDL_BM_Trx_StatusInteger0
3BCHSOURC SearchBatch SourceSTR15String15
4BACHNUMB SearchBatch NumberSTR15_LBAUString15
5Batch_ID_Note_Index SearchBatch ID Note IndexDLR14Currency14
6Completion_Date SearchCompletion DateDTDate8
7BM_Start_Date SearchTRX Start DateDT_DateDate6
8TRXDATE SearchTRX DateDT_DateDate6
9PSTGDATE SearchPosting DateDTDate8
10REFRENCE SearchReferenceSTR30String30
11BM_Trx_Errors SearchBM Trx ErrorsML_BM_Trx_ErrorsLong Integer0
12BM_Component_Errors SearchBM Component ErrorsML_BM_Component_ErrorsLong Integer0
13NOTEINDX SearchNote IndexDLR14Currency14
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 DateDTDate8
15USER2ENT SearchUser To EnterSTR15_User_IDString15
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 DateDTDate8
17PTDUSRID SearchPosted User IDSTR15String15
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 DateDATEDate6
19TRXSORCE SearchTRX SourceSTR13String13
20USERDEF1 SearchUser Defined 1STR20String20
21USERDEF2 SearchUser Defined 2STR20String20
22USRDEF03 SearchUser Defined 3STR20String20
23USRDEF04 SearchUser Defined 4STR20String20
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.

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

Leave a Reply

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