Table 18633 "Fixed Asset Shift" (IN)
IN country layer · Microsoft.FixedAssets.FADepreciation
Across versions
- BC23-28not present
- BC29-30present
IN country layer · Microsoft.FixedAssets.FADepreciation · BC29-30 · source at ea08af5e · facts from BC29
An object of the IN localization, not part of W1.
Properties
| Property | Value |
|---|---|
| Caption | Fixed Asset Shift |
| Permissions | TableData “FA Ledger Entry” = r, TableData “Maintenance Ledger Entry” = r |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | FA No. | Code[20] | — | TableRelation Fixed Asset; NotBlank; DataClassification CustomerContent |
| 2 | Depreciation Book Code | Code[10] | — | NotBlank; DataClassification CustomerContent |
| 3 | Depreciation Method | enum “Depreciation Method” | — | enum Depreciation Method; DataClassification CustomerContent |
| 4 | Depreciation Starting Date | Date | — | DataClassification CustomerContent |
| 5 | Straight-Line % | Decimal | — | DataClassification CustomerContent |
| 6 | No. of Depreciation Years | Decimal | — | DataClassification CustomerContent |
| 7 | No. of Depreciation Months | Decimal | — | DataClassification CustomerContent |
| 8 | Fixed Depr. Amount | Decimal | — | DataClassification CustomerContent |
| 9 | Declining-Balance % | Decimal | — | DataClassification CustomerContent |
| 10 | Depreciation Table Code | Code[10] | — | TableRelation Depreciation Table Header; DataClassification CustomerContent |
| 11 | Final Rounding Amount | Decimal | — | DataClassification CustomerContent |
| 12 | ending Book Value | Decimal | — | DataClassification CustomerContent |
| 13 | FA Posting Group | Code[10] | — | obsolete Removed 26.0; #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 14 | Depreciation ending Date | Date | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 15 | Acquisition Cost | Decimal | — | #if not CLEANSCHEMA26; FlowField: sum(“FA Ledger Entry”.Amount where( “FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(” “), “FA Posting Type” = const(“Acquisition Cost”), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable |
| 16 | Depreciation | Decimal | — | #if not CLEANSCHEMA26; FlowField: sum(“FA Ledger Entry”.Amount where( “FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(” “), “FA Posting Type” = const(Depreciation), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable |
| 17 | Book Value | Decimal | — | #if not CLEANSCHEMA26; FlowField: sum(“FA Ledger Entry”.Amount where( “FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “Part of Book Value” = const(true), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable |
| 18 | Proceeds on Disposal | Decimal | — | #if not CLEANSCHEMA26; FlowField: sum(“FA Ledger Entry”.Amount where( “FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(” “), “FA Posting Type” = const(“Proceeds on Disposal”), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable |
| 19 | Gain/Loss | Decimal | — | #if not CLEANSCHEMA26; FlowField: sum(“FA Ledger Entry”.Amount where( “FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(” “), “FA Posting Type” = const(“Gain/Loss”), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable |
| 20 | Write-Down | Decimal | — | #if not CLEANSCHEMA26; FlowField: sum(“FA Ledger Entry”.Amount where( “FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(” “), “FA Posting Type” = const(“Write-Down”), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable |
| 21 | Appreciation | Decimal | — | #if not CLEANSCHEMA26; FlowField: sum(“FA Ledger Entry”.Amount where( “FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(” “), “FA Posting Type” = const(Appreciation), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable |
| 22 | Custom 1 | Decimal | — | #if not CLEANSCHEMA26; FlowField: sum(“FA Ledger Entry”.Amount where( “FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(” “), “FA Posting Type” = const(“Custom 1”), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable |
| 23 | Custom 2 | Decimal | — | #if not CLEANSCHEMA26; FlowField: sum(“FA Ledger Entry”.Amount where( “FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(” “), “FA Posting Type” = const(“Custom 2”), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable |
| 24 | Depreciable Basis | Decimal | — | #if not CLEANSCHEMA26; FlowField: sum(“FA Ledger Entry”.Amount where( “FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “Part of Depreciable Basis” = const(true), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable |
| 25 | Salvage Value | Decimal | — | #if not CLEANSCHEMA26; FlowField: sum(“FA Ledger Entry”.Amount where( “FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(” “), “FA Posting Type” = const(“Salvage Value”), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable |
| 26 | Book Value on Disposal | Decimal | — | #if not CLEANSCHEMA26; FlowField: sum(“FA Ledger Entry”.Amount where( “FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(Disposal), “FA Posting Type” = const(“Book Value on Disposal”), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable |
| 27 | Maintenance | Decimal | — | #if not CLEANSCHEMA26; FlowField: sum(“Maintenance Ledger Entry”.Amount where( “FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “Maintenance Code” = field(“Maintenance Code Filter”), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable |
| 28 | Maintenance Code Filter | Code[10] | — | #if not CLEANSCHEMA26; TableRelation Maintenance; FlowFilter |
| 29 | FA Posting Date Filter | Date | — | #if not CLEANSCHEMA26; FlowFilter |
| 30 | Acquisition Date | Date | — | #if not CLEANSCHEMA26; not editable; DataClassification CustomerContent |
| 31 | G/L Acquisition Date | Date | — | #if not CLEANSCHEMA26; not editable; DataClassification CustomerContent |
| 32 | Disposal Date | Date | — | #if not CLEANSCHEMA26; not editable; DataClassification CustomerContent |
| 33 | Last Acquisition Cost Date | Date | — | #if not CLEANSCHEMA26; not editable; DataClassification CustomerContent |
| 34 | Last Depreciation Date | Date | — | #if not CLEANSCHEMA26; not editable; DataClassification CustomerContent |
| 35 | Last Write-Down Date | Date | — | #if not CLEANSCHEMA26; not editable; DataClassification CustomerContent |
| 36 | Last Appreciation Date | Date | — | #if not CLEANSCHEMA26; not editable; DataClassification CustomerContent |
| 37 | Last Custom 1 Date | Date | — | #if not CLEANSCHEMA26; not editable; DataClassification CustomerContent |
| 38 | Last Custom 2 Date | Date | — | #if not CLEANSCHEMA26; not editable; DataClassification CustomerContent |
| 39 | Last Salvage Value Date | Date | — | #if not CLEANSCHEMA26; not editable; DataClassification CustomerContent |
| 40 | FA Exchange Rate | Decimal | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 41 | Fixed Depr. Amount below Zero | Decimal | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 42 | Last Date Modified | Date | — | #if not CLEANSCHEMA26; not editable; DataClassification CustomerContent |
| 43 | First User-Defined Depr. Date | Date | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 44 | Use FA Ledger Check | Boolean | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 45 | Last Maintenance Date | Date | — | #if not CLEANSCHEMA26; not editable; DataClassification CustomerContent |
| 46 | Depr. below Zero % | Decimal | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 47 | Projected Disposal Date | Date | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 48 | Projected Proceeds on Disposal | Decimal | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 50 | Depr. Starting Date (Custom 1) | Date | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 51 | Depr. ending Date (Custom 1) | Date | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 52 | Accum. Depr. % (Custom 1) | Decimal | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 53 | Depr. This Year % (Custom 1) | Decimal | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 54 | Property Class (Custom 1) | Enum “Property Class Custom 1” | — | #if not CLEANSCHEMA26; enum Property Class Custom 1; DataClassification CustomerContent |
| 55 | Description | Text[30] | — | #if not CLEANSCHEMA26; not editable; DataClassification CustomerContent |
| 56 | Main Asset/Component | Enum “Main Asset/Component” | — | #if not CLEANSCHEMA26; enum Main Asset/Component; not editable; DataClassification CustomerContent |
| 57 | Component of Main Asset | Code[20] | — | #if not CLEANSCHEMA26; TableRelation Fixed Asset; not editable; DataClassification CustomerContent |
| 58 | FA Add.-Currency Factor | Decimal | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 59 | Use Half-Year Convention | Boolean | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 60 | Use DB% First Fiscal Year | Boolean | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 61 | Temp. ending Date | Date | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 62 | Temp. Fixed Depr. Amount | Decimal | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 63 | Shift Type | Enum “Shift Type” | — | #if not CLEANSCHEMA26; enum Shift Type; DataClassification CustomerContent |
| 64 | Industry Type | Enum “Industry Type” | — | #if not CLEANSCHEMA26; enum Industry Type; DataClassification CustomerContent |
| 65 | Used No. of Days | Integer | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 66 | Line No. | Integer | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 70 | Fixed Asset Posting Group | Code[20] | — | #if not CLEANSCHEMA26; DataClassification CustomerContent |
| 100 | Calculate FA Depreciation | Boolean | — | #if not CLEANSCHEMA26; not editable; DataClassification CustomerContent |
Keys
- Key1: FA No., Depreciation Book Code, Line No. (clustered)
- Key2: Industry Type, FA No., Depreciation Book Code
Procedures
GetExchangeRate(): Decimal
Plus 11 local procedures.
Triggers
OnDelete, OnInsert
Deprecations
- field Accum. Depr. % (Custom 1): guarded (#if not CLEANSCHEMA26)
- field Acquisition Cost: guarded (#if not CLEANSCHEMA26)
- field Acquisition Date: guarded (#if not CLEANSCHEMA26)
- field Appreciation: guarded (#if not CLEANSCHEMA26)
- field Book Value: guarded (#if not CLEANSCHEMA26)
- field Book Value on Disposal: guarded (#if not CLEANSCHEMA26)
- field Calculate FA Depreciation: guarded (#if not CLEANSCHEMA26)
- field Component of Main Asset: guarded (#if not CLEANSCHEMA26)
- field Custom 1: guarded (#if not CLEANSCHEMA26)
- field Custom 2: guarded (#if not CLEANSCHEMA26)
- field Depr. below Zero %: guarded (#if not CLEANSCHEMA26)
- field Depr. ending Date (Custom 1): guarded (#if not CLEANSCHEMA26)
- field Depr. Starting Date (Custom 1): guarded (#if not CLEANSCHEMA26)
- field Depr. This Year % (Custom 1): guarded (#if not CLEANSCHEMA26)
- field Depreciable Basis: guarded (#if not CLEANSCHEMA26)
- field Depreciation: guarded (#if not CLEANSCHEMA26)
- field Depreciation ending Date: guarded (#if not CLEANSCHEMA26)
- field Description: guarded (#if not CLEANSCHEMA26)
- field Disposal Date: guarded (#if not CLEANSCHEMA26)
- field FA Add.-Currency Factor: guarded (#if not CLEANSCHEMA26)
- field FA Exchange Rate: guarded (#if not CLEANSCHEMA26)
- field FA Posting Date Filter: guarded (#if not CLEANSCHEMA26)
- field First User-Defined Depr. Date: guarded (#if not CLEANSCHEMA26)
- field Fixed Asset Posting Group: guarded (#if not CLEANSCHEMA26)
- field Fixed Depr. Amount below Zero: guarded (#if not CLEANSCHEMA26)
- field G/L Acquisition Date: guarded (#if not CLEANSCHEMA26)
- field Gain/Loss: guarded (#if not CLEANSCHEMA26)
- field Industry Type: guarded (#if not CLEANSCHEMA26)
- field Last Acquisition Cost Date: guarded (#if not CLEANSCHEMA26)
- field Last Appreciation Date: guarded (#if not CLEANSCHEMA26)
- field Last Custom 1 Date: guarded (#if not CLEANSCHEMA26)
- field Last Custom 2 Date: guarded (#if not CLEANSCHEMA26)
- field Last Date Modified: guarded (#if not CLEANSCHEMA26)
- field Last Depreciation Date: guarded (#if not CLEANSCHEMA26)
- field Last Maintenance Date: guarded (#if not CLEANSCHEMA26)
- field Last Salvage Value Date: guarded (#if not CLEANSCHEMA26)
- field Last Write-Down Date: guarded (#if not CLEANSCHEMA26)
- field Line No.: guarded (#if not CLEANSCHEMA26)
- field Main Asset/Component: guarded (#if not CLEANSCHEMA26)
- field Maintenance: guarded (#if not CLEANSCHEMA26)
- field Maintenance Code Filter: guarded (#if not CLEANSCHEMA26)
- field Proceeds on Disposal: guarded (#if not CLEANSCHEMA26)
- field Projected Disposal Date: guarded (#if not CLEANSCHEMA26)
- field Projected Proceeds on Disposal: guarded (#if not CLEANSCHEMA26)
- field Property Class (Custom 1): guarded (#if not CLEANSCHEMA26)
- field Salvage Value: guarded (#if not CLEANSCHEMA26)
- field Shift Type: guarded (#if not CLEANSCHEMA26)
- field Temp. ending Date: guarded (#if not CLEANSCHEMA26)
- field Temp. Fixed Depr. Amount: guarded (#if not CLEANSCHEMA26)
- field Use DB% First Fiscal Year: guarded (#if not CLEANSCHEMA26)
- field Use FA Ledger Check: guarded (#if not CLEANSCHEMA26)
- field Use Half-Year Convention: guarded (#if not CLEANSCHEMA26)
- field Used No. of Days: guarded (#if not CLEANSCHEMA26)
- field Write-Down: guarded (#if not CLEANSCHEMA26)
- field FA Posting Group: Removed 26.0 (#if not CLEANSCHEMA26), “New field introduced as Fixed Asset Posting Group”
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Fixed Asset Shift"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.
A IN country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.