GPSOPDepositHist #4069

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

The GPSOPDepositHist table (ID 4069) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 39 fields, with a primary key of SOP Type, SOP Number, Line Item Sequence, TRX Source. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: SOP Type, SOP Number, Line Item Sequence, TRX Source.

All fields (39)

GPSOPDepositHist — FIELDS

NO.	FIELD	TYPE	CLASS
1	SOP Type PK	Option	Normal
2	SOP Number PK	Text	Normal
3	Line Item Sequence PK	Integer	Normal
4	Customer Number	Text	Normal
5	Customer Name	Text	Normal
6	Document Date	Date	Normal
7	Document Number	Text	Normal
8	RM Document Type-All	Option	Normal
9	Payment Type	Option	Normal
10	Amount Paid	Decimal	Normal
11	Originating Amount Paid	Decimal	Normal
12	Checkbook ID	Text	Normal
13	Check Number	Text	Normal
14	Card Name	Text	Normal
15	Receipt Number Credit Card	Text	Normal
16	Expiration Date	Date	Normal
17	Authorization Code	Text	Normal
18	Payment Date	Date	Normal
19	GL Posting Date	Date	Normal
20	Cash Index	Integer	Normal
21	Deposits Index	Integer	Normal
22	Delete	Boolean	Normal
23	Currency ID	Text	Normal
24	Currency Index	Integer	Normal
25	Exchange Rate	Decimal	Normal
26	Denomination Exchange Rate	Decimal	Normal
27	Rate Type ID	Text	Normal
28	Rate Calculation Method	Option	Normal
29	Exchange Table ID	Text	Normal
30	Exchange Date	Date	Normal
31	MC Transaction State	Option	Normal
32	Time	DateTime	Normal
33	TRX Source PK	Text	Normal
34	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