FA Ledger Entry #5601

Fixed Assets table in Microsoft Dynamics 365 Business Central. 86 fields, 0 records in Cronus demo.

86
Fields
0
Records
1
Primary key
6
FlowFields
28
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Entry No..

All fields (86)

FA Ledger Entry — FIELDS
NO.FIELDTYPECLASSRELATION
1 Entry No. PK Integer Normal
2 G/L Entry No. Integer Normal → G/L Entry #17
3 FA No. Code Normal → Fixed Asset #5600
4 FA Posting Date Date Normal
5 Posting Date Date Normal
6 Document Type Option Normal
7 Document Date Date Normal
8 Document No. Code Normal
9 External Document No. Code Normal
10 Description Text Normal
11 Depreciation Book Code Code Normal → Depreciation Book #5611
12 FA Posting Category Option Normal
13 FA Posting Type Option Normal
14 Amount Decimal Normal
15 Debit Amount Decimal Normal
16 Credit Amount Decimal Normal
17 Reclassification Entry Boolean Normal
18 Part of Book Value Boolean Normal
19 Part of Depreciable Basis Boolean Normal
20 Disposal Calculation Method Option Normal
21 Disposal Entry No. Integer Normal
22 No. of Depreciation Days Integer Normal
23 Quantity Decimal Normal
24 FA No./Budgeted FA No. Code Normal → Fixed Asset #5600
25 FA Subclass Code Code Normal → FA Subclass #5608
26 FA Location Code Code Normal → FA Location #5609
27 FA Posting Group Code Normal → FA Posting Group #5606
28 Global Dimension 1 Code Code Normal → Dimension Value #349
29 Global Dimension 2 Code Code Normal → Dimension Value #349
30 Location Code Code Normal → Location #14
32 User ID Code Normal
33 Depreciation Method Option Normal
34 Depreciation Starting Date Date Normal
35 Straight-Line % Decimal Normal
36 No. of Depreciation Years Decimal Normal
37 Fixed Depr. Amount Decimal Normal
38 Declining-Balance % Decimal Normal
39 Depreciation Table Code Code Normal → Depreciation Table Header #5642
40 Journal Batch Name Code Normal
41 Source Code Code Normal → Source Code #230
42 Reason Code Code Normal → Reason Code #231
43 Transaction No. Integer Normal
44 Bal. Account Type Option Normal
45 Bal. Account No. Code Normal
46 VAT Amount Decimal Normal
47 Gen. Posting Type Option Normal
48 Gen. Bus. Posting Group Code Normal → Gen. Business Posting Group #250
49 Gen. Prod. Posting Group Code Normal → Gen. Product Posting Group #251
50 FA Class Code Code Normal → FA Class #5607
51 FA Exchange Rate Decimal Normal
52 Amount (LCY) Decimal Normal
53 Result on Disposal Option Normal
54 Correction Boolean Normal
55 Index Entry Boolean Normal
56 Canceled from FA No. Code Normal → Fixed Asset #5600
57 Depreciation Ending Date Date Normal
58 Use FA Ledger Check Boolean Normal
59 Automatic Entry Boolean Normal
60 Depr. Starting Date (Custom 1) Date Normal
61 Depr. Ending Date (Custom 1) Date Normal
62 Accum. Depr. % (Custom 1) Decimal Normal
63 Depr. % this year (Custom 1) Decimal Normal
64 Property Class (Custom 1) Option Normal
65 No. Series Code Normal → No. Series #308
66 Tax Area Code Code Normal → Tax Area #318
67 Tax Liable Boolean Normal
68 Tax Group Code Code Normal → Tax Group #321
69 Use Tax Boolean Normal
70 VAT Bus. Posting Group Code Normal → VAT Business Posting Group #323
71 VAT Prod. Posting Group Code Normal → VAT Product Posting Group #324
72 Reversed Boolean Normal
73 Reversed by Entry No. Integer Normal → FA Ledger Entry #5601
74 Reversed Entry No. Integer Normal → FA Ledger Entry #5601
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
481 Shortcut Dimension 3 Code ⚡ FLOW Code FlowField
482 Shortcut Dimension 4 Code ⚡ FLOW Code FlowField
483 Shortcut Dimension 5 Code ⚡ FLOW Code FlowField
484 Shortcut Dimension 6 Code ⚡ FLOW Code FlowField
485 Shortcut Dimension 7 Code ⚡ FLOW Code FlowField
486 Shortcut Dimension 8 Code ⚡ FLOW Code FlowField
6210 Non-Deductible VAT FA Cost Boolean 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

Related tables (22)

Tables referenced by fields on the FA Ledger Entry table through TableRelation properties.

G/L Entry
#17 · Ledger Entries · via G/L Entry No.
Fixed Asset
#5600 · Fixed Assets · via FA No., FA No./Budgeted FA No., Canceled from FA No.
Depreciation Book
#5611 · Fixed Assets · via Depreciation Book Code
FA Subclass
#5608 · Fixed Assets · via FA Subclass Code
FA Location
#5609 · Fixed Assets · via FA Location Code
FA Posting Group
#5606 · Fixed Assets · via FA Posting Group
Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code
Location
#14 · General Ledger · via Location Code
Depreciation Table Header
#5642 · Other · via Depreciation Table Code
Source Code
#230 · Other · via Source Code
Reason Code
#231 · Other · via Reason Code
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
FA Class
#5607 · Fixed Assets · via FA Class Code
No. Series
#308 · Other · via No. Series
Tax Area
#318 · Other · via Tax Area Code
Tax Group
#321 · Other · via Tax Group Code
VAT Business Posting Group
#323 · Other · via VAT Bus. Posting Group
VAT Product Posting Group
#324 · Other · via VAT Prod. Posting Group
FA Ledger Entry
#5601 · Fixed Assets · via Reversed by Entry No., Reversed Entry No.
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID