Fixed Assets table in Microsoft Dynamics 365 Business Central. 45 fields, 0 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Journal Template Name, Journal Batch Name, Line No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Journal Template Name PK | Code | Normal | → FA Journal Template #5619 |
| 2 | Journal Batch Name PK | Code | Normal | → FA Journal Batch #5620 |
| 3 | Line No. PK | Integer | Normal | |
| 4 | Depreciation Book Code | Code | Normal | → Depreciation Book #5611 |
| 5 | FA Posting Type | Option | Normal | |
| 6 | FA No. | Code | Normal | → Fixed Asset #5600 |
| 7 | FA Posting Date | Date | Normal | |
| 8 | Posting Date | Date | Normal | |
| 9 | Document Type | Option | Normal | |
| 10 | Document Date | Date | Normal | |
| 11 | Document No. | Code | Normal | |
| 12 | External Document No. | Code | Normal | |
| 13 | Description | Text | Normal | |
| 14 | Amount | Decimal | Normal | |
| 15 | Debit Amount | Decimal | Normal | |
| 16 | Credit Amount | Decimal | Normal | |
| 17 | Salvage Value | Decimal | Normal | |
| 18 | Quantity | Decimal | Normal | |
| 19 | Correction | Boolean | Normal | |
| 20 | No. of Depreciation Days | Integer | Normal | |
| 21 | Depr. until FA Posting Date | Boolean | Normal | |
| 22 | Depr. Acquisition Cost | Boolean | Normal | |
| 24 | FA Posting Group | Code | Normal | → FA Posting Group #5606 |
| 26 | Maintenance Code | Code | Normal | → Maintenance #5626 |
| 27 | Shortcut Dimension 1 Code | Code | Normal | → Dimension Value #349 |
| 28 | Shortcut Dimension 2 Code | Code | Normal | → Dimension Value #349 |
| 30 | Insurance No. | Code | Normal | → Insurance #5628 |
| 31 | Budgeted FA No. | Code | Normal | → Fixed Asset #5600 |
| 32 | Use Duplication List | Boolean | Normal | |
| 33 | Duplicate in Depreciation Book | Code | Normal | → Depreciation Book #5611 |
| 34 | FA Reclassification Entry | Boolean | Normal | |
| 35 | FA Error Entry No. | Integer | Normal | → FA Ledger Entry #5601 |
| 36 | Reason Code | Code | Normal | → Reason Code #231 |
| 37 | Source Code | Code | Normal | → Source Code #230 |
| 38 | Recurring Method | Option | Normal | |
| 39 | Recurring Frequency | DateFormula | Normal | |
| 41 | Expiration Date | Date | Normal | |
| 42 | Index Entry | Boolean | Normal | |
| 43 | Posting No. Series | Code | Normal | → No. Series #308 |
| 480 | Dimension Set ID | Integer | Normal | → Dimension Set Entry #480 |
| 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 |
Tables referenced by fields on the FA Journal Line table through TableRelation properties.