GPSOPPaymentWorkHist #4072

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

32
Fields
0
Records
3
Primary key
0
FlowFields
2
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.FIELDTYPECLASSRELATION
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