GP Checkbook Transactions #40101

Name: GP Checkbook Transactions — Business Central Table #40101
Creator: Xpertly Ltd

Other table in Microsoft Dynamics 365 Business Central. 55 fields, 0 records in Cronus demo.

Fields

Records

Primary key

FlowFields

Relations

Primary key

The primary key uniquely identifies each record in this table. It consists of: CMRECNUM.

GP Checkbook Transactions — FIELDS

NO.	FIELD	TYPE	CLASS
1	CMRECNUM PK	Decimal	Normal
2	sRecNum	Text	Normal
3	RCRDSTTS	Integer	Normal
4	CHEKBKID	Text	Normal
5	CMTrxNum	Text	Normal
6	CMTrxType	Integer	Normal
7	TRXDATE	Date	Normal
8	GLPOSTDT	Date	Normal
9	TRXAMNT	Decimal	Normal
10	CURNCYID	Text	Normal
11	CMLinkID	Text	Normal
12	paidtorcvdfrom	Text	Normal
13	DSCRIPTN	Text	Normal
14	Recond	Boolean	Normal
15	RECONUM	Decimal	Normal
16	ClrdAmt	Decimal	Normal
17	clearedate	Date	Normal
18	VOIDED	Boolean	Normal
19	VOIDDATE	Date	Normal
20	VOIDPDATE	Date	Normal
21	VOIDDESC	Text	Normal
22	NOTEINDX	Decimal	Normal
23	AUDITTRAIL	Text	Normal
24	DEPTYPE	Integer	Normal
25	SOURCDOC	Text	Normal
26	SRCDOCTYP	Integer	Normal
27	SRCDOCNUM	Text	Normal
28	POSTEDDT	Date	Normal
29	PTDUSRID	Text	Normal
30	MODIFDT	Date	Normal
31	MDFUSRID	Text	Normal
32	USERDEF1	Text	Normal
33	USERDEF2	Text	Normal
34	ORIGAMT	Decimal	Normal
35	Checkbook_Amount	Decimal	Normal
36	RATETPID	Text	Normal
37	EXGTBLID	Text	Normal
38	XCHGRATE	Decimal	Normal
39	EXCHDATE	Date	Normal
40	TIME1	Time	Normal
41	RTCLCMTD	Integer	Normal
42	EXPNDATE	Date	Normal
43	CURRNIDX	Integer	Normal
44	DECPLCUR	Integer	Normal
45	DENXRATE	Decimal	Normal
46	MCTRXSTT	Integer	Normal
47	Xfr_Record_Number	Decimal	Normal
48	EFTFLAG	Boolean	Normal
49	VNDCHKNM	Text	Normal
50	DEX_ROW_ID	Integer	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal