GP Checkbook MSTR – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGP Checkbook MSTR

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/40099

Table Type: Company

Table Name: GP Checkbook MSTR
Database Table Name:

Table Number: 40099

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how GP Checkbook MSTR can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   []

Show/hide an example select of all columns by name

SELECT



FROM

   []

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [] AS [GP Checkbook MSTR]
LEFT JOIN
   [User] AS [User]
      ON
         [GP Checkbook MSTR].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [GP Checkbook MSTR].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in GP Checkbook MSTR table

Field No.	Field Name	Field Caption	Class	Type	Length
1	CHEKBKID	CHEKBKID	Normal	Text	15
2	DSCRIPTN	DSCRIPTN	Normal	Text	31
3	BANKID	BANKID	Normal	Text	15
4	CURNCYID	CURNCYID	Normal	Text	15
5	ACTINDX	ACTINDX	Normal	Integer	4
6	BNKACTNM	BNKACTNM	Normal	Text	15
7	NXTCHNUM	NXTCHNUM	Normal	Text	21
8	Next_Deposit_Number	Next_Deposit_Number	Normal	Text	21
9	INACTIVE	INACTIVE	Normal	Boolean	4
10	DYDEPCLR	DYDEPCLR	Normal	Integer	4
11	XCDMCHPW	XCDMCHPW	Normal	Text	11
12	MXCHDLR	MXCHDLR	Normal	Decimal	12
13	DUPCHNUM	DUPCHNUM	Normal	Boolean	4
14	OVCHNUM1	OVCHNUM1	Normal	Boolean	4
15	LOCATNID	LOCATNID	Normal	Text	15
16	NOTEINDX	NOTEINDX	Normal	Decimal	12
17	CMUSRDF1	CMUSRDF1	Normal	Text	21
18	CMUSRDF2	CMUSRDF2	Normal	Text	21
19	Last_Reconciled_Date	Last_Reconciled_Date	Normal	Date	4
20	Last_Reconciled_Balance	Last_Reconciled_Balance	Normal	Decimal	12
21	CURRBLNC	CURRBLNC	Normal	Decimal	12
22	CREATDDT	CREATDDT	Normal	Date	4
23	MODIFDT	MODIFDT	Normal	Date	4
24	Recond	Recond	Normal	Boolean	4
25	Reconcile_In_Progress	Reconcile_In_Progress	Normal	Decimal	12
26	Deposit_In_Progress	Deposit_In_Progress	Normal	Text	21
27	CHBKPSWD	CHBKPSWD	Normal	Text	15
28	CURNCYPD	CURNCYPD	Normal	Text	15
29	CRNCYRCD	CRNCYRCD	Normal	Text	15
30	ADPVADLR	ADPVADLR	Normal	Decimal	12
31	ADPVAPWD	ADPVAPWD	Normal	Text	11
32	DYCHTCLR	DYCHTCLR	Normal	Integer	4
33	CMPANYID	CMPANYID	Normal	Integer	4
34	CHKBKTYP	CHKBKTYP	Normal	Integer	4
35	DDACTNUM	DDACTNUM	Normal	Text	17
36	DDINDNAM	DDINDNAM	Normal	Text	23
37	DDTRANS	DDTRANS	Normal	Text	3
38	PaymentRateTypeID	PaymentRateTypeID	Normal	Text	15
39	DepositRateTypeID	DepositRateTypeID	Normal	Text	15
40	CashInTransAcctIdx	CashInTransAcctIdx	Normal	Integer	4
41	DEX_ROW_ID	DEX_ROW_ID	Normal	Integer	4
2000000000	$systemId	System ID	Normal	GUID	16
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8
2000000002	SystemCreatedBy	Created By	Normal	GUID	16
	Key to join to the User table. Show/hide example query SELECT [GP Checkbook MSTR].[] ,[User].[User Security ID] FROM [] AS [GP Checkbook MSTR] LEFT JOIN [User] AS [User] ON [GP Checkbook MSTR].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16

Dynamics 365 BC Table Reference Tables Company Tables GGP Checkbook MSTR

Show/hide an example select of all columns

Show/hide an example select of all columns by name

Show/hide an example select of all columns including those from all joined tables

Show/hide columns in GP Checkbook MSTR table

Show/hide example query

Leave a Reply Cancel reply