| X | TR FK | 1 | AssetId | Fixed asset number | AssetId | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | Yes | | Name | AssetId | | SaveContents | Yes | | StringSize | 10 | | Table | AssetBook | | Type | String | | Visible | Yes |
|
| X | TR FK | 2 | BookId | Value model | AssetBookId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetBookId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | Yes | | Name | BookId | | SaveContents | Yes | | StringSize | 10 | | Table | AssetBook | | Type | String | | Visible | Yes |
|
| FK | 3 | SortingId | Sort field 1 | AssetSortingId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | AssetSortingId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | SortingId | | SaveContents | Yes | | StringSize | 10 | | Table | AssetBook | | Type | String | | Visible | Yes |
|
| FK | 4 | AssetGroup | Fixed asset group | AssetGroupId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetGroupId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | AssetGroup | | SaveContents | Yes | | StringSize | 10 | | Table | AssetBook | | Type | String | | Visible | Yes |
|
| | 5 | Status | Status | AssetStatus | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | AssetStatus | | ExtendedDataType | | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Status | | SaveContents | Yes | | Table | AssetBook | | Type | Enum | | Visible | Yes |
|
| FK | 6 | Dimension | Department | Dimension | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | Dimension | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Dimension | | SaveContents | Yes | | StringSize | 10 | | Table | AssetBook | | Type | String | | Visible | Yes |
|
| FK | 7 | ReserveTypeId | Type | AssetReserveTypeId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetReserveTypeId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | ReserveTypeId | | SaveContents | Yes | | StringSize | 10 | | Table | AssetBook | | Type | String | | Visible | Yes |
|
| FK | 8 | RevaluationGroupId | Revaluation group | AssetRevaluationGroupId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetRevaluationGroupId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | RevaluationGroupId | | SaveContents | Yes | | StringSize | 10 | | Table | AssetBook | | Type | String | | Visible | Yes |
|
| FK | 9 | PostingProfile | Posting profile | AssetPostingProfile | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetPostingProfile | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | Yes | | Name | PostingProfile | | SaveContents | Yes | | StringSize | 10 | | Table | AssetBook | | Type | String | | Visible | Yes |
|
| | 10 | Depreciation | Depreciation | AssetDepreciate | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | NoYes | | ExtendedDataType | AssetDepreciate | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Depreciation | | SaveContents | Yes | | Table | AssetBook | | Type | Enum | | Visible | Yes |
|
| | 11 | LifeTime | Service life | AssetLifeTime | Integer | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetLifeTime | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | LifeTime | | SaveContents | Yes | | Table | AssetBook | | Type | Integer | | Visible | Yes |
|
| | 12 | LifeTimeRest | Service life remaining | AssetLifeTimeRest | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetLifeTimeRest | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | LifeTimeRest | | SaveContents | Yes | | Table | AssetBook | | Type | Real | | Visible | Yes |
|
| | 13 | DepreciationStartDate | Depreciation run date | AssetDepreciationStartDate | Date | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetDepreciationStartDate | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DepreciationStartDate | | SaveContents | Yes | | Table | AssetBook | | Type | Date | | Visible | Yes |
|
| | 14 | ScrapValue | Expected scrap value | AssetScrapValue | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetScrapValue | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | ScrapValue | | SaveContents | Yes | | Table | AssetBook | | Type | Real | | Visible | Yes |
|
| | 15 | LastDepreciationDate | Date when depreciation was last run | AssetLastDepreciationDate | Date | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetLastDepreciationDate | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | LastDepreciationDate | | SaveContents | Yes | | Table | AssetBook | | Type | Date | | Visible | Yes |
|
| FK | 16 | ConsumptionFactorId | Consumption factor | AssetConsumptionFactorId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetConsumptionFactorId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | ConsumptionFactorId | | SaveContents | Yes | | StringSize | 10 | | Table | AssetBook | | Type | String | | Visible | Yes |
|
| FK | 17 | ConsumptionUnitId | Unit | AssetConsumptionUnitId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetConsumptionUnitId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | ConsumptionUnitId | | SaveContents | Yes | | StringSize | 10 | | Table | AssetBook | | Type | String | | Visible | Yes |
|
| | 18 | DepreciationAmountUnit | Unit depreciation | AssetDepreciationAmountUnit | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetDepreciationAmountUnit | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DepreciationAmountUnit | | SaveContents | Yes | | Table | AssetBook | | Type | Real | | Visible | Yes |
|
| | 19 | ConsumptionQtyEstimated | Estimated consumption | AssetConsumptionQtyEstimated | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetConsumptionQtyEstimated | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | ConsumptionQtyEstimated | | SaveContents | Yes | | Table | AssetBook | | Type | Real | | Visible | Yes |
|
| | 20 | Section179Amount | Section 179 | AssetSection179Amount | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | CSEUnitedStates | | ExtendedDataType | AssetSection179Amount | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Section179Amount | | SaveContents | Yes | | Table | AssetBook | | Type | Real | | Visible | Yes |
|
| | 21 | Section179Done | Has section 179 been executed? | AssetSection179Done | Enum | Show |
| AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | CSEUnitedStates | | EnumType | NoYes | | ExtendedDataType | AssetSection179Done | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Section179Done | | SaveContents | Yes | | Table | AssetBook | | Type | Enum | | Visible | Yes |
|
| FK | 22 | VendAccount | Vendor account | VendAccount | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | VendAccount | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | VendAccount | | SaveContents | Yes | | StringSize | 10 | | Table | AssetBook | | Type | String | | Visible | Yes |
|
| FK | 23 | PurchId | Purchase order | PurchId | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | PurchId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | PurchId | | SaveContents | Yes | | StringSize | 20 | | Table | AssetBook | | Type | String | | Visible | Yes |
|
| | 24 | VendInvoiceId | Invoice | VendInvoiceId | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | VendInvoiceId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | VendInvoiceId | | SaveContents | Yes | | StringSize | 20 | | Table | AssetBook | | Type | String | | Visible | Yes |
|
| | 25 | AcquisitionPrice | Acquisition price | AssetAcquisitionPrice | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetAcquisitionPrice | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | AcquisitionPrice | | SaveContents | Yes | | Table | AssetBook | | Type | Real | | Visible | Yes |
|
| | 26 | AcquisitionDate | Acquisition date | AssetAcquisitionDate | Date | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetAcquisitionDate | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | AcquisitionDate | | SaveContents | Yes | | Table | AssetBook | | Type | Date | | Visible | Yes |
|
| FK | 27 | CustAccount | Customer account | CustAccount | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | CustAccount | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | CustAccount | | SaveContents | Yes | | StringSize | 10 | | Table | AssetBook | | Type | String | | Visible | Yes |
|
| FK | 28 | CustInvoiceId | Invoice | CustInvoiceId | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | CustInvoiceId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | CustInvoiceId | | SaveContents | Yes | | StringSize | 20 | | Table | AssetBook | | Type | String | | Visible | Yes |
|
| | 29 | DisposalDate | Disposal date | AssetDisposalDate | Date | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetDisposalDate | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DisposalDate | | SaveContents | Yes | | Table | AssetBook | | Type | Date | | Visible | Yes |
|
| | 30 | SaleValue | Sales value | AssetSaleValue | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetSaleValue | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | SaleValue | | SaveContents | Yes | | Table | AssetBook | | Type | Real | | Visible | Yes |
|
| FK | 31 | SortingId2 | Sort field 2 | AssetSortingId2 | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | AssetSortingId2 | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | SortingId2 | | SaveContents | Yes | | StringSize | 10 | | Table | AssetBook | | Type | String | | Visible | Yes |
|
| FK | 32 | SortingId3 | Sort field 3 | AssetSortingId3 | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | AssetSortingId3 | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | SortingId3 | | SaveContents | Yes | | StringSize | 10 | | Table | AssetBook | | Type | String | | Visible | Yes |
|