BM30100 - Assembly Batch History
Dynamics GP table BM30100 (Assembly Batch History) contains 15 columns including TRXSORCE, BACHNUMB, BCHSOURC....
SQL Query Builder
15 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| TRXSORCE | TRX Source | String | 14 | ||
| BACHNUMB | Batch Number | String | 16 | ||
| BCHSOURC | Batch Source | String | 16 | ||
| BCHCOMNT | Batch Comment | String | 62 | ||
| BACHFREQ | Batch Frequency1 = Single Use2 = Weekly3 = Biweekly4 = Semi monthly5 = Monthly6 = Bi Monthly7 = Quarterly8 = Miscellaneous | Integer | 2 | ||
Batch Frequency values (8) 1 = Single Use2 = Weekly3 = Biweekly4 = Semimonthly5 = Monthly6 = Bimonthly7 = Quarterly8 = Miscellaneous | |||||
| PSTGDATE | Posting Date | Date | 4 | ||
| NUMOFTRX | Number Of TRX | Long Integer | 4 | ||
| BCHTOTAL | Batch Total | Currency | 10 | ||
| NOTEINDX | Note Index | Currency | 10 | ||
| ORIGIN | Origin | Integer | 2 | ||
| APPROVL | Approval | Boolean | 2 | ||
| APRVLUSERID | Approval User ID | String | 16 | ||
| APPRVLDT | Approval Date | Date | 4 | ||
| CNTRLTRX | Control TRX Count | Long Integer | 4 | ||
| CNTRLTOT | Control Total | Currency | 10 | ||
Related Tables
Tables that share columns with BM30100. Click "Join" to add to your query.
APPROVL