CM20203 - Checkbook EFT Transaction Batch
Dynamics GP table CM20203 (Checkbook EFT Transaction Batch) contains 10 columns including CHEKBKID, BCHSOURC, BACHNUMB....
SQL Query Builder
10 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| CHEKBKID | Checkbook ID | String | 16 | ||
| BCHSOURC | Batch Source | String | 16 | ||
| BACHNUMB | Batch Number | String | 16 | ||
| POSTEDDT | Posted Date | Date | 4 | ||
| NUMOFTRX | Number Of TRX | Long Integer | 4 | ||
| BCHTOTAL | Batch Total | Currency | 10 | ||
| USERID | User ID | String | 16 | ||
| EFTGenerationTimestamp | EFT Generation Timestamp | String | 32 | ||
| EFT_Status | EFT Status | Integer | 2 | ||
| SERIES | Series1 = All2 = Financial3 = Sales4 = Purchasing5 = Inventory6 = Payroll - USA7 = Project | Integer | 2 | ||
Module Series values (8) 1 = All2 = Financial3 = Sales4 = Purchasing5 = Inventory6 = Payroll7 = Project10 = 3rd Party | |||||
Related Tables
Tables that share columns with CM20203. Click "Join" to add to your query.
NUMOFTRX
BCHTOTAL