Other table in Microsoft Dynamics 365 Business Central. 57 fields, 0 records in Cronus demo.
The Hist. Receivables Apply table (ID 40914) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 57 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 | Customer No. | Code | Normal | |
| 3 | Customer Name | Text | Normal | |
| 4 | Corporate Customer No. | Code | Normal | |
| 5 | Date | Date | Normal | |
| 6 | GL Posting Date | Date | Normal | |
| 7 | Apply To Document No. | Code | Normal | |
| 8 | Apply To Document Type | Option | Normal | |
| 9 | Apply To Document Date | Date | Normal | |
| 10 | Apply To GL Posting Date | Date | Normal | |
| 11 | Currency Code | Code | Normal | |
| 12 | Apply To Amount | Decimal | Normal | |
| 13 | Discount Taken Amount | Decimal | Normal | |
| 14 | Discount Available Taken | Decimal | Normal | |
| 15 | Write Off Amount | Decimal | Normal | |
| 16 | Originating Apply To Amount | Decimal | Normal | |
| 17 | Originating Discount Taken Amount | Decimal | Normal | |
| 18 | Originating Discount Available Taken | Decimal | Normal | |
| 19 | Originating Write Off Amount | Decimal | Normal | |
| 20 | Apply To Exchange Rate | Decimal | Normal | |
| 21 | Apply To Denom. Exchange Rate | Decimal | Normal | |
| 22 | Apply From Document No. | Code | Normal | |
| 23 | Apply From Document Type | Option | Normal | |
| 24 | Apply From Document Date | Date | Normal | |
| 25 | Apply From GL Posting Date | Date | Normal | |
| 26 | Apply From Currency Code | Code | Normal | |
| 27 | Apply From Apply Amount | Decimal | Normal | |
| 28 | Apply From Discount Taken Amount | Decimal | Normal | |
| 29 | Apply From Discount Avail. Taken | Decimal | Normal | |
| 30 | Apply From Write Off Amount | Decimal | Normal | |
| 31 | Actual Apply To Amount | Decimal | Normal | |
| 32 | Actual Discount Taken Amount | Decimal | Normal | |
| 33 | Actual Discount Avail. Taken | Decimal | Normal | |
| 34 | Actual Write Off Amount | Decimal | Normal | |
| 35 | Apply From Exchange Rate | Decimal | Normal | |
| 36 | Apply From Denom. Exch. Rate | Decimal | Normal | |
| 37 | Apply From Round Amount | Decimal | Normal | |
| 38 | Apply To Round Amount | Decimal | Normal | |
| 39 | Apply To Round Discount | Decimal | Normal | |
| 40 | Originating Apply From Round Amount | Decimal | Normal | |
| 41 | Originating Apply To Round Amount | Decimal | Normal | |
| 42 | Originating Apply To Round Discount | Decimal | Normal | |
| 43 | GST Discount Amount | Decimal | Normal | |
| 44 | PPS Amount Deducted | Decimal | Normal | |
| 45 | Realized Gain-Loss Amount | Decimal | Normal | |
| 46 | Settled Gain CreditCurrTrx | Decimal | Normal | |
| 47 | Settled Loss CreditCurrTrx | Decimal | Normal | |
| 48 | Settled Gain DebitCurrTrx | Decimal | Normal | |
| 49 | Settled Loss DebitCurrTrx | Decimal | Normal | |
| 50 | Settled Gain DebitDiscAvail | Decimal | Normal | |
| 51 | Settled Loss DebitDiscAvail | Decimal | Normal | |
| 52 | Audit Code | 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 |