Objects/Tables/Table 5601 FA Ledger Entry
Table 5601 FA Ledger Entry in 26
Jonas Paprotka, Base Application 26.5.38752.40541, checked
- App
- Base Application
- Namespace
- Microsoft.FixedAssets.Ledger
Fields, 81Keys, 12Procedures, 6Events, 6
Versions171819202122232425262728latest
Source29
Fields, 81
| Id | Name | Type | Obsolete |
|---|
| 1 | Entry No. | Integer | - |
| 2 | G/L Entry No. | Integer | - |
| 3 | FA No. | Code[20] | - |
| 4 | FA Posting Date | Date | - |
| 5 | Posting Date | Date | - |
| 6 | Document Type | Enum Gen. Journal Document Type | - |
| 7 | Document Date | Date | - |
| 8 | Document No. | Code[20] | - |
| 9 | External Document No. | Code[35] | - |
| 10 | Description | Text[100] | - |
| 11 | Depreciation Book Code | Code[10] | - |
| 12 | FA Posting Category | Enum FA Ledger Posting Category | - |
| 13 | FA Posting Type | Enum FA Ledger Entry FA Posting Type | - |
| 14 | Amount | Decimal | - |
| 15 | Debit Amount | Decimal | - |
| 16 | Credit Amount | Decimal | - |
| 17 | Reclassification Entry | Boolean | - |
| 18 | Part of Book Value | Boolean | - |
| 19 | Part of Depreciable Basis | Boolean | - |
| 20 | Disposal Calculation Method | Option | - |
| 21 | Disposal Entry No. | Integer | - |
| 22 | No. of Depreciation Days | Integer | - |
| 23 | Quantity | Decimal | - |
| 24 | FA No./Budgeted FA No. | Code[20] | - |
| 25 | FA Subclass Code | Code[10] | - |
| 26 | FA Location Code | Code[10] | - |
| 27 | FA Posting Group | Code[20] | - |
| 28 | Global Dimension 1 Code | Code[20] | - |
| 29 | Global Dimension 2 Code | Code[20] | - |
| 30 | Location Code | Code[10] | - |
| 32 | User ID | Code[50] | - |
| 33 | Depreciation Method | Enum FA Depreciation Method | - |
| 34 | Depreciation Starting Date | Date | - |
| 35 | Straight-Line % | Decimal | - |
| 36 | No. of Depreciation Years | Decimal | - |
| 37 | Fixed Depr. Amount | Decimal | - |
| 38 | Declining-Balance % | Decimal | - |
| 39 | Depreciation Table Code | Code[10] | - |
| 40 | Journal Batch Name | Code[10] | - |
| 41 | Source Code | Code[10] | - |
| 42 | Reason Code | Code[10] | - |
| 43 | Transaction No. | Integer | - |
| 44 | Bal. Account Type | Enum Gen. Journal Account Type | - |
| 45 | Bal. Account No. | Code[20] | - |
| 46 | VAT Amount | Decimal | - |
| 47 | Gen. Posting Type | Enum General Posting Type | - |
| 48 | Gen. Bus. Posting Group | Code[20] | - |
| 49 | Gen. Prod. Posting Group | Code[20] | - |
| 50 | FA Class Code | Code[10] | - |
| 51 | FA Exchange Rate | Decimal | - |
| 52 | Amount (LCY) | Decimal | - |
| 53 | Result on Disposal | Option | - |
| 54 | Correction | Boolean | - |
| 55 | Index Entry | Boolean | - |
| 56 | Canceled from FA No. | Code[20] | - |
| 57 | Depreciation Ending Date | Date | - |
| 58 | Use FA Ledger Check | Boolean | - |
| 59 | Automatic Entry | Boolean | - |
| 60 | Depr. Starting Date (Custom 1) | Date | - |
| 61 | Depr. Ending Date (Custom 1) | Date | - |
| 62 | Accum. Depr. % (Custom 1) | Decimal | - |
| 63 | Depr. % this year (Custom 1) | Decimal | - |
| 64 | Property Class (Custom 1) | Option | - |
| 65 | No. Series | Code[20] | - |
| 66 | Tax Area Code | Code[20] | - |
| 67 | Tax Liable | Boolean | - |
| 68 | Tax Group Code | Code[20] | - |
| 69 | Use Tax | Boolean | - |
| 70 | VAT Bus. Posting Group | Code[20] | - |
| 71 | VAT Prod. Posting Group | Code[20] | - |
| 72 | Reversed | Boolean | - |
| 73 | Reversed by Entry No. | Integer | - |
| 74 | Reversed Entry No. | Integer | - |
| 480 | Dimension Set ID | Integer | - |
| 481 | Shortcut Dimension 3 Code | Code[20] | - |
| 482 | Shortcut Dimension 4 Code | Code[20] | - |
| 483 | Shortcut Dimension 5 Code | Code[20] | - |
| 484 | Shortcut Dimension 6 Code | Code[20] | - |
| 485 | Shortcut Dimension 7 Code | Code[20] | - |
| 486 | Shortcut Dimension 8 Code | Code[20] | - |
| 6210 | Non-Ded. VAT FA Cost | Boolean | - |
Keys, 12
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Entry No. | - |
| Key2 | FA No., Depreciation Book Code, FA Posting Date | - |
| Key3 | FA No., Depreciation Book Code, FA Posting Category, FA Posting Type, FA Posting Date, Part of Book Value, Reclassification Entry | - |
| Key4 | FA No., Depreciation Book Code, Part of Book Value, FA Posting Date | - |
| Key5 | FA No., Depreciation Book Code, Part of Depreciable Basis, FA Posting Date | - |
| Key6 | FA No., Depreciation Book Code, FA Posting Category, FA Posting Type, Posting Date | - |
| Key7 | Canceled from FA No., Depreciation Book Code, FA Posting Date | - |
| Key8 | Document No., Posting Date | - |
| Key9 | G/L Entry No. | - |
| Key10 | Document Type, Document No. | - |
| Key11 | Transaction No. | - |
| Key12 | FA No., Depreciation Book Code, FA Posting Category, FA Posting Type, Document No. | - |
Procedures, 6
| Name | Parameters | Returns | Access | Obsolete |
|---|
| GetLastEntryNo | () | Integer | public | - |
| MoveToGenJnl | (var Record Gen. Journal Line) | | public | - |
| MoveToFAJnl | (var Record FA Journal Line) | | public | - |
| ConvertPostingType | () | Option | public | - |
| ShowDimensions | () | | public | - |
| IsAcquisitionCost | () | Boolean | public | - |
Events, 6
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnAfterMoveToGenJnlLine | (var Record Gen. Journal Line, Record FA Ledger Entry) | - |
| Integration event | OnAfterMoveToFAJnlLine | (var Record FA Journal Line, Record FA Ledger Entry) | - |
| Integration event | OnAfterConvertPostingTypeElse | (var Record FA Journal Line, var Record FA Ledger Entry) | - |
| Integration event | OnAfterIsAcquisitionCost | (var Record FA Ledger Entry, var Boolean) | - |
| Integration event | OnMoveToGenJnlLineOnAfterInit | (var Record Gen. Journal Line, var Record FA Ledger Entry, var Boolean) | - |
| Integration event | OnMoveToFAJnlLineOnAfterInit | (var Record FA Journal Line, Record FA Ledger Entry, var Boolean) | - |