GPSOPPaymentWorkHist #4072

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

The GPSOPPaymentWorkHist table (ID 4072) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 32 fields, with a primary key of SOP Type, SOP Number, Sequence Number. 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, Sequence Number.

All fields (32)

GPSOPPaymentWorkHist — FIELDS

NO.	FIELD	TYPE	CLASS
1	SOP Type PK	Option	Normal
2	SOP Number PK	Text	Normal
3	Sequence Number PK	Integer	Normal
4	Payment Type	Option	Normal
5	Document Number	Text	Normal
6	RM Document Type-All	Option	Normal
7	Checkbook ID	Text	Normal
8	Check Number	Text	Normal
9	Card Name	Text	Normal
10	Receipt Number Credit Card	Text	Normal
11	Authorization Code	Text	Normal
12	Amount Paid	Decimal	Normal
13	Originating Amount Paid	Decimal	Normal
14	Amount Remaining	Decimal	Normal
15	Originating Amount Remaining	Decimal	Normal
16	Document Date	Date	Normal
17	Expiration Date	Date	Normal
18	Currency ID	Text	Normal
19	Currency Index	Integer	Normal
20	TRX Source	Text	Normal
21	Deposit Status	Option	Normal
22	Delete	Boolean	Normal
23	GL Posting Date	Date	Normal
24	Cash Index	Integer	Normal
25	Deposits Index	Integer	Normal
26	EFT Flag	Boolean	Normal
27	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