Assembly Transaction (BM10200)

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

Product: Microsoft Dynamics GP (0)
Series: Inventory

Display Name: Assembly Transaction
Physical Name: BM10200
Technical Name: bmTrx

Group Display Name: Bill of Materials Transactions
Group Technical Name: bmTrxGroup

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
11Quantity_Shortage_Status SearchQuantity Shortage StatusINT1Integer21
12BM_Trx_Errors SearchBM Trx ErrorsML_BM_Trx_ErrorsLong Integer40
13BM_Component_Errors SearchBM Component ErrorsML_BM_Component_ErrorsLong Integer40
14NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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