Other table in Microsoft Dynamics 365 Business Central. 40 fields, 0 records in Cronus demo.
The Hist. Payables Apply table (ID 40913) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 40 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 | Vendor No. | Code | Normal | |
| 3 | Vendor Name | Text | Normal | |
| 4 | Document Type | Option | Normal | |
| 5 | Apply To Voucher No. | Code | Normal | |
| 6 | Apply To Document No. | Code | Normal | |
| 7 | Apply To Document Type | Option | Normal | |
| 8 | Apply To Document Date | Date | Normal | |
| 9 | Voucher No. | Code | Normal | |
| 10 | Document Amount | Decimal | Normal | |
| 11 | Currency Code | Code | Normal | |
| 12 | Disc. Taken Amount | Decimal | Normal | |
| 13 | Write Off Amount | Decimal | Normal | |
| 14 | Orig. Applied Amount | Decimal | Normal | |
| 15 | Orig. Discount Taken Amount | Decimal | Normal | |
| 16 | Orig. Discount Available Taken | Decimal | Normal | |
| 17 | Orig. Write Off Amount | Decimal | Normal | |
| 18 | Apply To Post Date | Date | Normal | |
| 19 | Apply From Document No. | Code | Normal | |
| 20 | Apply From GL Posting Date | Date | Normal | |
| 21 | Apply From Currency ID | Code | Normal | |
| 22 | Apply From Apply Amount | Decimal | Normal | |
| 23 | Apply From Discount Taken Amount | Decimal | Normal | |
| 24 | Apply From Discount Available Taken | Decimal | Normal | |
| 25 | Apply From Write Off Amount | Decimal | Normal | |
| 26 | Actual Apply To Amount | Decimal | Normal | |
| 27 | Actual Discount Taken Amount | Decimal | Normal | |
| 28 | Actual Discount Available Taken | Decimal | Normal | |
| 29 | Actual Write Off Amount | Decimal | Normal | |
| 30 | Apply From Exchange Rate | Decimal | Normal | |
| 31 | Apply From Denomination Exchange Rate | Decimal | Normal | |
| 32 | PPS Amount Deducted | Decimal | Normal | |
| 33 | GST Discount Amount | Decimal | Normal | |
| 34 | 1099 Amount | Decimal | Normal | |
| 35 | Credit 1099 Amount | Decimal | 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 |