Table 40101 "GP Checkbook Transactions"

HybridGP · Microsoft.DataMigration.GP · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Extensible	false
DataClassification	CustomerContent
Permissions	tableData “Bank Account Ledger Entry” = rim

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

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

Keys

PK: CMRECNUM (clustered)

Procedures

ShouldFlipSign(): Boolean (internal)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "GP Checkbook Transactions"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.