CM Checkbook Master (CM00100)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CM00100

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: CM Checkbook Master
Physical Name: CM00100
Technical Name: CM_Checkbook_MSTR

Group Display Name: Checkbook Master
Group Technical Name: Checkbook Master

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CHEKBKID SearchCheckbook IDStringSTR15_Checkbook_ID15
2DSCRIPTN SearchDescriptionStringSTR3030
3BANKID SearchBank IDStringSTR15_Bank_ID15
4CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['CM Checkbook Master'].CURNCYID AS 'CM Checkbook Master-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       CM00100 AS ['CM Checkbook Master']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['CM Checkbook Master'].CURNCYID = ['Currency Setup'].CURNCYID
5ACTINDX SearchAccount IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['CM Checkbook Master'].ACTINDX AS 'CM Checkbook Master-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       CM00100 AS ['CM Checkbook Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['CM Checkbook Master'].ACTINDX = ['Account Index Master'].ACTINDX
6BNKACTNM SearchBank Account NumberStringSTR1515
7NXTCHNUM SearchNext Check NumberStringSTR20_Document_Number20
8Next_Deposit_Number SearchNext Deposit NumberStringSTR20_Document_Number20
9INACTIVE SearchInactiveBooleanCB_Inactive0
10DYDEPCLR SearchDays Deposits To ClearIntegerINT3_U03
11XCDMCHPW SearchExceed Max Check PasswordStringPassword10
12MXCHDLR SearchMaximum Check DollarCurrencyDLR19_RBSO_UTR$19
13DUPCHNUM SearchDuplicate Check NumbersBooleanCB_Duplicate_Check_Numbers0
14OVCHNUM1 SearchOverride Check Number 1BooleanCB_Override_Check_Number0
15LOCATNID SearchLocation IDStringSTR15_Location_ID15
16NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['CM Checkbook Master'].NOTEINDX AS 'CM Checkbook Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       CM00100 AS ['CM Checkbook Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['CM Checkbook Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
17CMUSRDF1 SearchCM User Defined 1StringSTR2020
18CMUSRDF2 SearchCM User Defined 2StringSTR2020
19Last_Reconciled_Date SearchLast Reconciled DateDateDT8
20Last_Reconciled_Balance SearchLast Reconciled BalanceCurrencyDLR19_$S219
21CURRBLNC SearchCurrent BalanceCurrencyDLR19_RBS0_STR$19
22CREATDDT SearchCreated DateDateDT8
23MODIFDT SearchModified DateDateDT8
24Recond SearchReconciledBooleanBoolean0
25Reconcile_In_Progress SearchReconcile In ProgressCurrencyDLR_Document_Number19
26Deposit_In_Progress SearchDeposit In ProgressStringSTR20_Document_Number20
27CHBKPSWD SearchCheckbook PasswordStringSTR1515
28CURNCYPD SearchCurrency PaidStringSTR15_Currency_ID15
29CRNCYRCD SearchCurrency ReceivedStringSTR15_Currency_ID15
30ADPVADLR SearchAllow Deposit Variance DollarCurrencyDLR17_RBS0_STR$17
31ADPVAPWD SearchAllow Deposit Variance PasswordStringPassword10
32DYCHTCLR SearchDays Checks To ClearIntegerINT3_U03
33CMPANYID SearchCompany IDIntegerINT54
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['CM Checkbook Master'].CMPANYID AS 'CM Checkbook Master-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       CM00100 AS ['CM Checkbook Master']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['CM Checkbook Master'].CMPANYID = ['Company Master'].CMPANYID
34CHKBKTYP SearchCheckbook TypeIntegerDDL_Checkbook_Type0
35DDACTNUM SearchDD Account NumberStringDD_STR1717
36DDINDNAM SearchDD Individual NameStringSTR2222
37DDTRANS SearchDD Transaction CodeStringSTR22
38PaymentRateTypeID SearchPayment Rate Type IDStringSTR15_LBAU15
39DepositRateTypeID SearchDeposit Rate Type IDStringSTR15_LBAU15
40CashInTransAcctIdx SearchCash In Transit Account IndexLong IntegerLI_1414

Leave a Reply

Your email address will not be published. Required fields are marked *