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 Group Display Name: Bill of Materials Transactions
Physical Name: BM10200
Technical Name: bmTrx
Group Technical Name: bmTrxGroup
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | TRX_ID  | TRX ID | String | STR17_TRX_ID | 17 | |
| 2 | BM_Trx_Status | BM Trx Status | Integer | DDL_BM_Trx_Status | 0 | |
| 3 | BCHSOURC | Batch Source | String | STR15 | 15 | |
| 4 | BACHNUMB | Batch Number | String | STR15_LBAU | 15 | |
| 5 | Batch_ID_Note_Index | Batch ID Note Index | Currency | DLR14 | 14 | |
| 6 | Completion_Date | Completion Date | Date | DT | 8 | |
| 7 | BM_Start_Date | TRX Start Date | Date | DT_Date | 6 | |
| 8 | TRXDATE | TRX Date | Date | DT_Date | 6 | |
| 9 | PSTGDATE | Posting Date | Date | DT | 8 | |
| 10 | REFRENCE | Reference | String | STR30 | 30 | |
| 11 | Quantity_Shortage_Status | Quantity Shortage Status | Integer | INT1 | 1 | |
| 12 | BM_Trx_Errors | BM Trx Errors | Long Integer | ML_BM_Trx_Errors | 0 | |
| 13 | BM_Component_Errors | BM Component Errors | Long Integer | ML_BM_Component_Errors | 0 | |
| 14 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['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 | ||||||
| 15 | MODIFDT | Modified Date | Date | DT | 8 | |
| 16 | USER2ENT | User To Enter | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | ||||||
| 17 | CREATDDT | Created Date | Date | DT | 8 | |
| 18 | PTDUSRID | Posted User ID | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | ||||||
| 19 | POSTEDDT | Posted Date | Date | DATE | 6 | |
| 20 | TRXSORCE | TRX Source | String | STR13 | 13 | |
| 21 | USERDEF1 | User Defined 1 | String | STR20 | 20 | |
| 22 | USERDEF2 | User Defined 2 | String | STR20 | 20 | |
| 23 | USRDEF03 | User Defined 3 | String | STR20 | 20 | |
| 24 | USRDEF04 | User Defined 4 | String | STR20 | 20 | |