Table 4065 "GPRMHist"

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

Properties

Property	Value
Extensible	false
DataClassification	CustomerContent

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	CUSTNMBR	text[16]	Customer Number caption
2	CPRCSTNM	text[16]	Corporate Customer Number caption
3	DOCNUMBR	text[22]	Document Number caption
4	CHEKNMBR	text[22]	Check Number caption
5	BACHNUMB	text[16]	Batch Number caption
6	BCHSOURC	text[16]	Batch Source caption
7	TRXSORCE	text[14]	TRX Source caption
8	RMDTYPAL	Option	RM Document Type-All caption
9	DUEDATE	Date	Due Date caption
10	DOCDATE	Date	Document Date caption
11	POSTDATE	Date	Post Date caption
12	PSTUSRID	text[16]	Post User ID caption
13	GLPOSTDT	Date	GL Posting Date caption
14	LSTEDTDT	Date	Last Edit Date caption
15	LSTUSRED	text[16]	Last User to Edit caption
16	ORTRXAMT	Decimal	Original Trx Amount caption
17	CURTRXAM	Decimal	Current Trx Amount caption
18	SLSAMNT	Decimal	Sales Amount caption
19	COSTAMNT	Decimal	Cost Amount caption
20	FRTAMNT	Decimal	Freight Amount caption
21	MISCAMNT	Decimal	Misc Amount caption
22	TAXAMNT	Decimal	Tax Amount caption
23	COMDLRAM	Decimal	Commission Dollar Amount caption
24	CASHAMNT	Decimal	Cash Amount caption
25	DISTKNAM	Decimal	Discount Taken Amount caption
26	DISAVAMT	Decimal	Discount Available Amount caption
27	DISCRTND	Decimal	Discount Returned caption
28	DISCDATE	Date	Discount Date caption
29	DSCDLRAM	Decimal	Discount Dollar Amount caption
30	DSCPCTAM	Integer	Discount Percent Amount caption
31	WROFAMNT	Decimal	Write Off Amount caption
32	TRXDSCRN	text[32]	Transaction Description caption
33	CSPORNBR	text[22]	Customer Purchase Order Number caption
34	SLPRSNID	text[16]	Salesperson ID caption
35	SLSTERCD	text[16]	Sales Territory Code caption
36	DINVPDOF	Date	Date Invoice Paid Off caption
37	PPSAMDED	Decimal	PPS Amount Deducted caption
38	GSTDSAMT	Decimal	GST Discount Amount caption
39	DELETE1	Boolean	Delete caption
40	TAXSCHID	text[16]	Tax Schedule ID caption
41	SLSCHDID	text[16]	Sales Schedule ID caption
42	FRTSCHID	text[16]	Freight Schedule ID caption
43	MSCSCHID	text[16]	Misc Schedule ID caption
44	CURNCYID	text[16]	Currency ID caption
45	SHIPMTHD	text[16]	Shipping Method caption
46	PYMTRMID	text[22]	Payment Terms ID caption
47	TRDISAMT	Decimal	Trade Discount Amount caption
48	NOTEINDX	Decimal	Note Index caption
49	VOIDSTTS	Option	Void Status caption
50	VOIDDATE	Date	Void Date caption
51	BALFWDNM	text[22]	Balance Forward Number caption
52	CSHRCTYP	Option	Cash Receipt Type caption
53	Tax_Date	Date	Tax Date caption
54	APLYWITH	Boolean	Apply Withholding caption
55	SALEDATE	Date	Sale Date caption
56	CORRCTN	Boolean	Correction caption
57	SIMPLIFD	Boolean	Simplified caption
58	Electronic	Boolean	—
59	ECTRX	Boolean	EC Transaction caption
60	BKTSLSAM	Decimal	Backout Sales Amount caption
61	BackoutTradeDisc	Decimal	Backout Trade Discount Amount caption
62	BKTFRTAM	Decimal	Backout Freight Amount caption
63	BKTMSCAM	Decimal	Backout Misc Amount caption
64	Factoring	Boolean	—
65	DIRECTDEBIT	Boolean	Direct Debit caption
66	ADRSCODE	text[16]	Address Code caption
67	EFTFLAG	Boolean	EFT Flag caption
68	DEX_ROW_TS	DateTime	—
69	DEX_ROW_ID	Integer	—

Keys

PK: CUSTNMBR, RMDTYPAL, DOCNUMBR
DueDate: DUEDATE
Key3: DEX_ROW_ID

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: "GPRMHist"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Across versions

Properties

Fields

Keys

Ask your agent

Evidence 1 sources