Fixed Assets table in Microsoft Dynamics 365 Business Central. 49 fields, 5 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Code.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Code PK | Code | Normal | |
| 2 | Acquisition Cost Account | Code | Normal | → G/L Account #15 |
| 3 | Accum. Depreciation Account | Code | Normal | → G/L Account #15 |
| 4 | Write-Down Account | Code | Normal | → G/L Account #15 |
| 5 | Appreciation Account | Code | Normal | → G/L Account #15 |
| 6 | Custom 1 Account | Code | Normal | → G/L Account #15 |
| 7 | Custom 2 Account | Code | Normal | → G/L Account #15 |
| 8 | Acq. Cost Acc. on Disposal | Code | Normal | → G/L Account #15 |
| 9 | Accum. Depr. Acc. on Disposal | Code | Normal | → G/L Account #15 |
| 10 | Write-Down Acc. on Disposal | Code | Normal | → G/L Account #15 |
| 11 | Appreciation Acc. on Disposal | Code | Normal | → G/L Account #15 |
| 12 | Custom 1 Account on Disposal | Code | Normal | → G/L Account #15 |
| 13 | Custom 2 Account on Disposal | Code | Normal | → G/L Account #15 |
| 14 | Gains Acc. on Disposal | Code | Normal | → G/L Account #15 |
| 15 | Losses Acc. on Disposal | Code | Normal | → G/L Account #15 |
| 16 | Book Val. Acc. on Disp. (Gain) | Code | Normal | → G/L Account #15 |
| 17 | Sales Acc. on Disp. (Gain) | Code | Normal | → G/L Account #15 |
| 18 | Write-Down Bal. Acc. on Disp. | Code | Normal | → G/L Account #15 |
| 19 | Apprec. Bal. Acc. on Disp. | Code | Normal | → G/L Account #15 |
| 20 | Custom 1 Bal. Acc. on Disposal | Code | Normal | → G/L Account #15 |
| 21 | Custom 2 Bal. Acc. on Disposal | Code | Normal | → G/L Account #15 |
| 22 | Maintenance Expense Account | Code | Normal | → G/L Account #15 |
| 23 | Maintenance Bal. Acc. | Code | Normal | → G/L Account #15 |
| 24 | Acquisition Cost Bal. Acc. | Code | Normal | → G/L Account #15 |
| 25 | Depreciation Expense Acc. | Code | Normal | → G/L Account #15 |
| 26 | Write-Down Expense Acc. | Code | Normal | → G/L Account #15 |
| 27 | Appreciation Bal. Account | Code | Normal | → G/L Account #15 |
| 28 | Custom 1 Expense Acc. | Code | Normal | → G/L Account #15 |
| 29 | Custom 2 Expense Acc. | Code | Normal | → G/L Account #15 |
| 30 | Sales Bal. Acc. | Code | Normal | → G/L Account #15 |
| 31 | Allocated Acquisition Cost % ⚡ FLOW | Decimal | FlowField | |
| 32 | Allocated Depreciation % ⚡ FLOW | Decimal | FlowField | |
| 33 | Allocated Write-Down % ⚡ FLOW | Decimal | FlowField | |
| 34 | Allocated Appreciation % ⚡ FLOW | Decimal | FlowField | |
| 35 | Allocated Custom 1 % ⚡ FLOW | Decimal | FlowField | |
| 36 | Allocated Custom 2 % ⚡ FLOW | Decimal | FlowField | |
| 37 | Allocated Sales Price % ⚡ FLOW | Decimal | FlowField | |
| 38 | Allocated Maintenance % ⚡ FLOW | Decimal | FlowField | |
| 39 | Allocated Gain % ⚡ FLOW | Decimal | FlowField | |
| 40 | Allocated Loss % ⚡ FLOW | Decimal | FlowField | |
| 41 | Allocated Book Value % (Gain) ⚡ FLOW | Decimal | FlowField | |
| 42 | Allocated Book Value % (Loss) ⚡ FLOW | Decimal | FlowField | |
| 43 | Sales Acc. on Disp. (Loss) | Code | Normal | → G/L Account #15 |
| 44 | Book Val. Acc. on Disp. (Loss) | Code | Normal | → G/L Account #15 |
| 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 Posting Group table through TableRelation properties.