GP PM30300 #40143

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

The GP PM30300 table (ID 40143) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 69 fields, with a primary key of VCHRNMBR, DOCTYPE, APTVCHNM, APTODCTY. 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: VCHRNMBR, DOCTYPE, APTVCHNM, APTODCTY.

All fields (69)

GP PM30300 — FIELDS

NO.	FIELD	TYPE	CLASS
1	VENDORID	Text	Normal
2	DOCDATE	DateTime	Normal
3	DATE1	DateTime	Normal
4	GLPOSTDT	DateTime	Normal
5	TIME1	DateTime	Normal
6	VCHRNMBR PK	Text	Normal
7	DOCTYPE PK	Integer	Normal
8	APFRDCNM	Text	Normal
9	ApplyFromGLPostDate	DateTime	Normal
10	FROMCURR	Text	Normal
11	APFRMAPLYAMT	Decimal	Normal
12	APFRMDISCTAKEN	Decimal	Normal
13	APFRMDISCAVAIL	Decimal	Normal
14	APFRMWROFAMT	Decimal	Normal
15	ActualApplyToAmount	Decimal	Normal
16	ActualDiscTakenAmount	Decimal	Normal
17	ActualDiscAvailTaken	Decimal	Normal
18	ActualWriteOffAmount	Decimal	Normal
19	APFRMEXRATE	Decimal	Normal
20	APFRMDENRATE	Decimal	Normal
21	APFRMRTCLCMETH	Integer	Normal
22	APFRMMCTRXSTT	Integer	Normal
23	APTVCHNM PK	Text	Normal
24	APTODCTY PK	Integer	Normal
25	APTODCNM	Text	Normal
26	APTODCDT	DateTime	Normal
27	ApplyToGLPostDate	DateTime	Normal
28	CURNCYID	Text	Normal
29	CURRNIDX	Integer	Normal
30	APPLDAMT	Decimal	Normal
31	DISTKNAM	Decimal	Normal
32	DISAVTKN	Decimal	Normal
33	WROFAMNT	Decimal	Normal
34	ORAPPAMT	Decimal	Normal
35	ORDISTKN	Decimal	Normal
36	ORDATKN	Decimal	Normal
37	ORWROFAM	Decimal	Normal
38	APTOEXRATE	Decimal	Normal
39	APTODENRATE	Decimal	Normal
40	APTORTCLCMETH	Integer	Normal
41	APTOMCTRXSTT	Integer	Normal
42	PPSAMDED	Decimal	Normal
43	GSTDSAMT	Decimal	Normal
44	TAXDTLID	Text	Normal
45	POSTED	Boolean	Normal
46	TEN99AMNT	Decimal	Normal
47	RLGANLOS	Decimal	Normal
48	APYFRMRNDAMT	Decimal	Normal
49	APYTORNDAMT	Decimal	Normal
50	APYTORNDDISC	Decimal	Normal
51	OAPYFRMRNDAMT	Decimal	Normal
52	OAPYTORNDAMT	Decimal	Normal
53	OAPYTORNDDISC	Decimal	Normal
54	Settled_Gain_CreditCurrT	Decimal	Normal
55	Settled_Loss_CreditCurrT	Decimal	Normal
56	Settled_Gain_DebitCurrTr	Decimal	Normal
57	Settled_Loss_DebitCurrTr	Decimal	Normal
58	Settled_Gain_DebitDiscAv	Decimal	Normal
59	Settled_Loss_DebitDiscAv	Decimal	Normal
60	Revaluation_Status	Integer	Normal
61	Credit1099Amount	Decimal	Normal
62	DEFTEN99TYPE	Integer	Normal
63	DEFTEN99BOXNUMBER	Integer	Normal
64	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