GP Checkbook Transactions – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGP Checkbook Transactions

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

Table Type: Company

Table Name: GP Checkbook Transactions
Database Table Name:

Table Number: 40101

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 Transactions 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 Transactions]
LEFT JOIN
   [User] AS [User]
      ON
         [GP Checkbook Transactions].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [GP Checkbook Transactions].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in GP Checkbook Transactions table

Field No.	Field Name	Field Caption	Class	Type	Length
1	CMRECNUM	CMRECNUM	Normal	Decimal	12
2	sRecNum	sRecNum	Normal	Text	21
3	RCRDSTTS	RCRDSTTS	Normal	Integer	4
4	CHEKBKID	CHEKBKID	Normal	Text	15
5	CMTrxNum	CMTrxNum	Normal	Text	21
6	CMTrxType	CMTrxType	Normal	Integer	4
7	TRXDATE	TRXDATE	Normal	Date	4
8	GLPOSTDT	GLPOSTDT	Normal	Date	4
9	TRXAMNT	TRXAMNT	Normal	Decimal	12
10	CURNCYID	CURNCYID	Normal	Text	15
11	CMLinkID	CMLinkID	Normal	Text	15
12	paidtorcvdfrom	paidtorcvdfrom	Normal	Text	65
13	DSCRIPTN	DSCRIPTN	Normal	Text	31
14	Recond	Recond	Normal	Boolean	4
15	RECONUM	RECONUM	Normal	Decimal	12
16	ClrdAmt	ClrdAmt	Normal	Decimal	12
17	clearedate	clearedate	Normal	Date	4
18	VOIDED	VOIDED	Normal	Boolean	4
19	VOIDDATE	VOIDDATE	Normal	Date	4
20	VOIDPDATE	VOIDPDATE	Normal	Date	4
21	VOIDDESC	VOIDDESC	Normal	Text	31
22	NOTEINDX	NOTEINDX	Normal	Decimal	12
23	AUDITTRAIL	AUDITTRAIL	Normal	Text	13
24	DEPTYPE	DEPTYPE	Normal	Integer	4
25	SOURCDOC	SOURCDOC	Normal	Text	11
26	SRCDOCTYP	SRCDOCTYP	Normal	Integer	4
27	SRCDOCNUM	SRCDOCNUM	Normal	Text	21
28	POSTEDDT	POSTEDDT	Normal	Date	4
29	PTDUSRID	PTDUSRID	Normal	Text	15
30	MODIFDT	MODIFDT	Normal	Date	4
31	MDFUSRID	MDFUSRID	Normal	Text	15
32	USERDEF1	USERDEF1	Normal	Text	21
33	USERDEF2	USERDEF2	Normal	Text	21
34	ORIGAMT	ORIGAMT	Normal	Decimal	12
35	Checkbook_Amount	Checkbook_Amount	Normal	Decimal	12
36	RATETPID	RATETPID	Normal	Text	15
37	EXGTBLID	EXGTBLID	Normal	Text	15
38	XCHGRATE	XCHGRATE	Normal	Decimal	12
39	EXCHDATE	EXCHDATE	Normal	Date	4
40	TIME1	TIME1	Normal	Time	4
41	RTCLCMTD	RTCLCMTD	Normal	Integer	4
42	EXPNDATE	EXPNDATE	Normal	Date	4
43	CURRNIDX	CURRNIDX	Normal	Integer	4
44	DECPLCUR	DECPLCUR	Normal	Integer	4
45	DENXRATE	DENXRATE	Normal	Decimal	12
46	MCTRXSTT	MCTRXSTT	Normal	Integer	4
47	Xfr_Record_Number	Xfr_Record_Number	Normal	Decimal	12
48	EFTFLAG	EFTFLAG	Normal	Boolean	4
49	VNDCHKNM	VNDCHKNM	Normal	Text	65
50	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 Transactions].[] ,[User].[User Security ID] FROM [] AS [GP Checkbook Transactions] LEFT JOIN [User] AS [User] ON [GP Checkbook Transactions].[] = [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 Transactions

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 Transactions table

Show/hide example query

Leave a Reply Cancel reply