Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CM40100
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: CM Setup
Physical Name: CM40100
Technical Name: CM_SETP
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | CMRECNUM  | Record Number | Currency | DLR_Document_Number | 19 | |
| 2 | NXTNUM | Next Number | Long Integer | LI9_U0 | 9 | |
| 3 | CMHISTORY | CMMaintainHistory | Boolean | CB_CMHistory | 0 | |
| 4 | USRDFPR1 | User Defined Prompt 1 | String | STR15 | 15 | |
| 5 | USRDRPR2 | User Defined Prompt 2 | String | STR15 | 15 | |
| 6 | CHEKBKID | Checkbook ID | String | STR15_Checkbook_ID | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['CM Setup'].CHEKBKID AS 'CM Setup-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CM40100 AS ['CM Setup']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['CM Setup'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID | ||||||