Other table in Microsoft Dynamics 365 Business Central. 38 fields, 0 records in Cronus demo.
The Hist. Payables Document table (ID 40905) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 38 fields, with a primary key of Primary Key. 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: Primary Key.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Primary Key PK | Integer | Normal | |
| 2 | Voucher No. | Code | Normal | |
| 3 | Vendor No. | Code | Normal | |
| 4 | Vendor Name | Text | Normal | |
| 5 | Document Type | Option | Normal | |
| 6 | Document No. | Code | Normal | |
| 7 | Document Date | Date | Normal | |
| 8 | Document Amount | Decimal | Normal | |
| 9 | Currency | Code | Normal | |
| 10 | Current Trx. Amount | Decimal | Normal | |
| 11 | Disc. Taken Amount | Decimal | Normal | |
| 12 | Batch No. | Code | Normal | |
| 13 | Batch Source | Text | Normal | |
| 14 | Due Date | Date | Normal | |
| 15 | Purchase No. | Code | Normal | |
| 16 | Audit Code | Code | Normal | |
| 17 | Trx. Description | Text | Normal | |
| 18 | Post Date | Date | Normal | |
| 19 | User | Text | Normal | |
| 20 | Misc. Amount | Decimal | Normal | |
| 21 | Freight Amount | Decimal | Normal | |
| 22 | Tax Amount | Decimal | Normal | |
| 23 | Total Payments | Decimal | Normal | |
| 24 | Voided | Boolean | Normal | |
| 25 | Invoice Paid Off Date | Date | Normal | |
| 26 | Ship Method | Text | Normal | |
| 27 | 1099 Amount | Decimal | Normal | |
| 28 | Write Off Amount | Decimal | Normal | |
| 29 | Trade Discount Amount | Decimal | Normal | |
| 30 | Payment Terms ID | Text | Normal | |
| 31 | 1099 Type | Text | Normal | |
| 32 | 1099 Box Number | Text | Normal | |
| 33 | PO Number | Code | 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 |