Other table in Microsoft Dynamics 365 Business Central. 37 fields, 0 records in Cronus demo.
The GP PM20000 table (ID 40129) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 37 fields, with a primary key of VCHRNMBR, DOCTYPE. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: VCHRNMBR, DOCTYPE.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | VCHRNMBR PK | Text | Normal | |
| 2 | VENDORID | Text | Normal | |
| 3 | DOCTYPE PK | Integer | Normal | |
| 4 | DOCDATE | Date | Normal | |
| 5 | DOCNUMBR | Text | Normal | |
| 6 | DOCAMNT | Decimal | Normal | |
| 7 | CURTRXAM | Decimal | Normal | |
| 8 | DISTKNAM | Decimal | Normal | |
| 11 | BACHNUMB | Text | Normal | |
| 12 | TRXSORCE | Text | Normal | |
| 13 | BCHSOURC | Text | Normal | |
| 15 | DUEDATE | Date | Normal | |
| 16 | PORDNMBR | Text | Normal | |
| 17 | TEN99AMNT | Decimal | Normal | |
| 18 | WROFAMNT | Decimal | Normal | |
| 20 | TRXDSCRN | Text | Normal | |
| 25 | VOIDED | Boolean | Normal | |
| 28 | DINVPDOF | DateTime | Normal | |
| 33 | POSTEDDT | DateTime | Normal | |
| 34 | PTDUSRID | Text | Normal | |
| 40 | TRDISAMT | Decimal | Normal | |
| 41 | MSCCHAMT | Decimal | Normal | |
| 42 | FRTAMNT | Decimal | Normal | |
| 43 | TAXAMNT | Decimal | Normal | |
| 44 | TTLPYMTS | Decimal | Normal | |
| 45 | CURNCYID | Text | Normal | |
| 46 | PYMTRMID | Text | Normal | |
| 47 | SHIPMTHD | Text | Normal | |
| 73 | TEN99TYPE | Integer | Normal | |
| 74 | TEN99BOXNUMBER | Integer | Normal | |
| 75 | PONUMBER | Text | Normal | |
| 80 | 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 |