Table 4069 "GPSOPDepositHist"

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	SOPTYPE	Option	SOP Type caption
2	SOPNUMBE	text[22]	SOP Number caption
3	LNITMSEQ	Integer	Line Item Sequence caption
4	CUSTNMBR	text[16]	Customer Number caption
5	CUSTNAME	text[66]	Customer Name caption
6	DOCDATE	Date	Document Date caption
7	DOCNUMBR	text[22]	Document Number caption
8	RMDTYPAL	Option	RM Document Type-All caption
9	PYMTTYPE	Option	Payment Type caption
10	AMNTPAID	Decimal	Amount Paid caption
11	OAMTPAID	Decimal	Originating Amount Paid caption
12	CHEKBKID	text[16]	Checkbook ID caption
13	CHEKNMBR	text[22]	Check Number caption
14	CARDNAME	text[16]	Card Name caption
15	RCTNCCRD	text[22]	Receipt Number Credit Card caption
16	EXPNDATE	Date	Expiration Date caption
17	AUTHCODE	text[16]	Authorization Code caption
18	PYMNTDAT	Date	Payment Date caption
19	GLPOSTDT	Date	GL Posting Date caption
20	CASHINDEX	Integer	Cash Index caption
21	DEPINDEX	Integer	Deposits Index caption
22	DELETE1	Boolean	Delete caption
23	CURNCYID	text[16]	Currency ID caption
24	CURRNIDX	Integer	Currency Index caption
25	XCHGRATE	Decimal	Exchange Rate caption
26	DENXRATE	Decimal	Denomination Exchange Rate caption
27	RATETPID	text[16]	Rate Type ID caption
28	RTCLCMTD	Option	Rate Calculation Method caption
29	EXGTBLID	text[16]	Exchange Table ID caption
30	EXCHDATE	Date	Exchange Date caption
31	MCTRXSTT	Option	MC Transaction State caption
32	TIME1	DateTime	Time caption
33	TRXSORCE	text[14]	TRX Source caption
34	DEX_ROW_ID	Integer	—

Keys

PK: TRXSORCE, SOPTYPE, SOPNUMBE, LNITMSEQ

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