BM30200 - Assembly Transaction History
Dynamics GP table BM30200 (Assembly Transaction History) contains 23 columns including TRX_ID, BM_Trx_Status, BCHSOURC....
SQL Query Builder
23 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| TRX_ID | TRX ID | String | 20 | |
| BM_Trx_Status | BM Trx Status | Integer | 2 | |
| BCHSOURC | Batch Source | String | 16 | |
| BACHNUMB | Batch Number | String | 16 | |
| Batch_ID_Note_Index | Batch ID Note Index | Currency | 10 | |
| Completion_Date | Completion Date | Date | 4 | |
| BM_Start_Date | TRX Start Date | Date | 4 | |
| TRXDATE | TRX Date | Date | 4 | |
| PSTGDATE | Posting Date | Date | 4 | |
| REFRENCE | Reference | String | 32 | |
| BM_Trx_Errors | BM Trx Errors | Long Integer | 4 | |
| BM_Component_Errors | BM Component Errors | Long Integer | 4 | |
| NOTEINDX | Note Index | Currency | 10 | |
| MODIFDT | Modified Date | Date | 4 | |
| USER2ENT | User To Enter | String | 16 | |
| CREATDDT | Created Date | Date | 4 | |
| PTDUSRID | Posted User ID | String | 16 | |
| POSTEDDT | Posted Date | Date | 4 | |
| TRXSORCE | TRX Source | String | 14 | |
| USERDEF1 | User Defined 1 | String | 22 | |
| USERDEF2 | User Defined 2 | String | 22 | |
| USRDEF03 | User Defined 3 | String | 22 | |
| USRDEF04 | User Defined 4 | String | 22 |
Related Tables
Tables that share columns with BM30200. Click "Join" to add to your query.