| X | PK | 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 | AssetTable | | Type | String | | Visible | Yes |
|
| FK | 2 | AssetGroup | Fixed asset group | AssetGroupId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetGroupId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | Yes | | Name | AssetGroup | | SaveContents | Yes | | StringSize | 10 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| FK | 3 | DEL_Dimension | Department | Dimension | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | Dimension | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_Dimension | | SaveContents | Yes | | StringSize | 10 | | Table | AssetTable | | Type | String | | Visible | No |
|
| | 4 | DEL_Status | Status | AssetStatus | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | EnumType | AssetStatus | | ExtendedDataType | | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_Status | | SaveContents | Yes | | Table | AssetTable | | Type | Enum | | Visible | No |
|
| | 5 | Name | Name | AssetName | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetName | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Name | | SaveContents | Yes | | StringSize | 30 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| FK | 6 | Location | Location | AssetLocationId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetLocationId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Location | | SaveContents | Yes | | StringSize | 10 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| | 7 | DEL_AcquisitionDate | Acquisition date | AssetAcquisitionDate | Date | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | AssetAcquisitionDate | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_AcquisitionDate | | SaveContents | Yes | | Table | AssetTable | | Type | Date | | Visible | No |
|
| | 8 | DEL_AcquisitionPrice | Acquisition price | AssetAcquisitionPrice | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | AssetAcquisitionPrice | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_AcquisitionPrice | | SaveContents | Yes | | Table | AssetTable | | Type | Real | | Visible | No |
|
| | 9 | DEL_ScrapValue | Expected scrap value | AssetScrapValue | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | AssetScrapValue | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_ScrapValue | | SaveContents | Yes | | Table | AssetTable | | Type | Real | | Visible | No |
|
| | 10 | DEL_DisposalDate | Disposal date | AssetDisposalDate | Date | Show |
| AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | AssetDisposalDate | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_DisposalDate | | SaveContents | Yes | | Table | AssetTable | | Type | Date | | Visible | No |
|
| | 11 | DEL_DepreciationStartDate | Depreciation run date | AssetDepreciationStartDate | Date | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | AssetDepreciationStartDate | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_DepreciationStartDate | | SaveContents | Yes | | Table | AssetTable | | Type | Date | | Visible | No |
|
| | 12 | Documents | Document location | Filename | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | Filename | | GroupPrompt | | | HelpText | @SYS67387 (Location of documents regarding the fixed asset) | | Label | @SYS67386 (Document location) | | Mandatory | No | | Name | Documents | | SaveContents | Yes | | StringSize | 260 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| | 13 | SerialNum | Serial number | Num | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | Num | | GroupPrompt | | | HelpText | @SYS67388 (Serial number for this fixed asset.) | | Label | @SYS477 (Serial number) | | Mandatory | No | | Name | SerialNum | | SaveContents | Yes | | StringSize | 20 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| | 14 | InsurancePolicyNum | Policy number | AssetInsurancePolicyNum | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetInsurancePolicyNum | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | InsurancePolicyNum | | SaveContents | Yes | | StringSize | 20 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| | 15 | InsuredValue | Insured value | AssetInsuredValue | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetInsuredValue | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | InsuredValue | | SaveContents | Yes | | Table | AssetTable | | Type | Real | | Visible | Yes |
|
| | 16 | Make | Make | Name | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | Name | | GroupPrompt | | | HelpText | @SYS67390 (Name of the manufacturer of the item) | | Label | @SYS67389 (Make) | | Mandatory | No | | Name | Make | | SaveContents | Yes | | StringSize | 30 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| | 17 | Model | Model | Name | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | Name | | GroupPrompt | | | HelpText | @SYS67391 (Model number of the item) | | Label | @SYS9923 (Model) | | Mandatory | No | | Name | Model | | SaveContents | Yes | | StringSize | 30 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| | 18 | GuaranteeDate | Guarantee date | AssetTransDate | Date | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetTransDate | | GroupPrompt | | | HelpText | @SYS67393 (Date of the start of the guarantee for this fixed asset) | | Label | @SYS67392 (Guarantee date) | | Mandatory | No | | Name | GuaranteeDate | | SaveContents | Yes | | Table | AssetTable | | Type | Date | | Visible | Yes |
|
| | 19 | MainAssetId | Main fixed asset | AssetIdMain | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetIdMain | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | MainAssetId | | SaveContents | Yes | | StringSize | 10 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| | 20 | DEL_CapAllowance | Capital allowance | NoYes | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | EnumType | NoYes | | ExtendedDataType | | | GroupPrompt | | | HelpText | @SYS67395 (Capital allowance for this fixed asset) | | Label | @SYS67394 (Capital allowance) | | Mandatory | No | | Name | DEL_CapAllowance | | SaveContents | Yes | | Table | AssetTable | | Type | Enum | | Visible | No |
|
| | 21 | DEL_GrantValue | Grant value | Price | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | Price | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | @SYS67397 (Grant value for this fixed asset) | | Label | @SYS67396 (Grant value) | | Mandatory | No | | Name | DEL_GrantValue | | SaveContents | Yes | | Table | AssetTable | | Type | Real | | Visible | No |
|
| | 22 | Responsible | Responsible | AssetEmplId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetEmplId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Responsible | | SaveContents | Yes | | StringSize | 10 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| FK | 23 | DEL_DepreciationProfile | Depreciation profile | AssetDepreciationProfileId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | AssetDepreciationProfileId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_DepreciationProfile | | SaveContents | Yes | | StringSize | 10 | | Table | AssetTable | | Type | String | | Visible | No |
|
| | 24 | AssetType | Type | AssetType | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | AssetType | | ExtendedDataType | | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | AssetType | | SaveContents | Yes | | Table | AssetTable | | Type | Enum | | Visible | Yes |
|
| | 25 | DEL_Depreciation | Depreciation | AssetDepreciate | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | EnumType | NoYes | | ExtendedDataType | AssetDepreciate | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_Depreciation | | SaveContents | Yes | | Table | AssetTable | | Type | Enum | | Visible | No |
|
| | 26 | DEL_Lifetime | Service life | AssetLifeTime | Integer | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | AssetLifeTime | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_Lifetime | | SaveContents | Yes | | Table | AssetTable | | Type | Integer | | Visible | No |
|
| FK | 27 | DEL_PostingProfile | Posting profile | AssetPostingProfile | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | AssetPostingProfile | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_PostingProfile | | SaveContents | Yes | | StringSize | 10 | | Table | AssetTable | | Type | String | | Visible | No |
|
| | 28 | DEL_SaleValue | Sales value | AssetSaleValue | Real | Show |
| AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | AssetSaleValue | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_SaleValue | | SaveContents | Yes | | Table | AssetTable | | Type | Real | | Visible | No |
|
| | 29 | DEL_LastDepreciationDate | Date when depreciation was last run | AssetLastDepreciationDate | Date | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | AssetLastDepreciationDate | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_LastDepreciationDate | | SaveContents | Yes | | Table | AssetTable | | Type | Date | | Visible | No |
|
| | 30 | Barcode | Bar code | AssetBarcode | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetBarcode | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Barcode | | SaveContents | Yes | | StringSize | 20 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| FK | 31 | DEL_CustAccount | Customer account | CustAccount | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | CustAccount | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_CustAccount | | SaveContents | Yes | | StringSize | 10 | | Table | AssetTable | | Type | String | | Visible | No |
|
| FK | 32 | DEL_VendAccount | Vendor account | VendAccount | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | VendAccount | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_VendAccount | | SaveContents | Yes | | StringSize | 10 | | Table | AssetTable | | Type | String | | Visible | No |
|
| | 33 | InsuranceDate1 | Insurance date 1 | AssetInsuranceDate1 | Date | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetInsuranceDate1 | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | InsuranceDate1 | | SaveContents | Yes | | Table | AssetTable | | Type | Date | | Visible | Yes |
|
| | 34 | InsuranceDate2 | Insurance date 2 | AssetInsuranceDate2 | Date | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetInsuranceDate2 | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | InsuranceDate2 | | SaveContents | Yes | | Table | AssetTable | | Type | Date | | Visible | Yes |
|
| FK | 35 | DEL_PurchId | Purchase order | PurchId | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | PurchId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_PurchId | | SaveContents | Yes | | StringSize | 20 | | Table | AssetTable | | Type | String | | Visible | No |
|
| FK | 36 | DEL_CustInvoiceId | Invoice | CustInvoiceId | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | CustInvoiceId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_CustInvoiceId | | SaveContents | Yes | | StringSize | 20 | | Table | AssetTable | | Type | String | | Visible | No |
|
| | 37 | DEL_VendInvoiceId | Invoice | VendInvoiceId | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | VendInvoiceId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_VendInvoiceId | | SaveContents | Yes | | StringSize | 20 | | Table | AssetTable | | Type | String | | Visible | No |
|
| FK | 38 | DEL_SalesId | Sales order | SalesId | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | SalesId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_SalesId | | SaveContents | Yes | | StringSize | 20 | | Table | AssetTable | | Type | String | | Visible | No |
|
| | 39 | AssetReplaceCost | Replacement cost | AssetReplaceCost | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetReplaceCost | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | AssetReplaceCost | | SaveContents | Yes | | Table | AssetTable | | Type | Real | | Visible | Yes |
|
| | 40 | DEL_LifeTimeRest | Service life remaining | AssetLifeTimeRest | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | AssetLifeTimeRest | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_LifeTimeRest | | SaveContents | Yes | | Table | AssetTable | | Type | Real | | Visible | No |
|
| FK | 41 | SortingId | Sort field 1 | AssetSortingId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetSortingId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | SortingId | | SaveContents | Yes | | StringSize | 10 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| | 42 | TaxCountyNO | Municipality | AssetTaxCountyNO | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetTaxCountyNO | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | TaxCountyNO | | SaveContents | Yes | | StringSize | 30 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| | 43 | SubventionNO | Taxable contribution | AssetSubventionNO | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetSubventionNO | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | SubventionNO | | SaveContents | Yes | | Table | AssetTable | | Type | Real | | Visible | Yes |
|
| | 44 | SubventionTaxFreeNO | Tax-free contribution | AssetSubventionTaxFreeNO | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetSubventionTaxFreeNO | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | SubventionTaxFreeNO | | SaveContents | Yes | | Table | AssetTable | | Type | Real | | Visible | Yes |
|
| | 45 | AssessmentNO | Tax assessment value | AssetAssessmentNO | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetAssessmentNO | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | AssessmentNO | | SaveContents | Yes | | Table | AssetTable | | Type | Real | | Visible | Yes |
|
| | 46 | AssessmentTaxNO | Value for tax purposes | AssetAssessmentTaxNO | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetAssessmentTaxNO | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | AssessmentTaxNO | | SaveContents | Yes | | Table | AssetTable | | Type | Real | | Visible | Yes |
|
| | 47 | AcquisitionValueNO | Acquisition price for tax purposes | AssetAcquisitionValueNO | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetAcquisitionValueNO | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | AcquisitionValueNO | | SaveContents | Yes | | Table | AssetTable | | Type | Real | | Visible | Yes |
|
| | 48 | ValueAt19840101NO | Value as on 1/1/1984 | AssetValueAt19840101NO | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetValueAt19840101NO | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | ValueAt19840101NO | | SaveContents | Yes | | Table | AssetTable | | Type | Real | | Visible | Yes |
|
| | 49 | ReturnOnInvestmentsNO | Origin for return on capital | AssetReturnOnInvestmentsNO | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetReturnOnInvestmentsNO | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | ReturnOnInvestmentsNO | | SaveContents | Yes | | Table | AssetTable | | Type | Real | | Visible | Yes |
|
| FK | 50 | SortingId2 | Sort field 2 | AssetSortingId2 | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetSortingId2 | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | SortingId2 | | SaveContents | Yes | | StringSize | 10 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| FK | 51 | SortingId3 | Sort field 3 | AssetSortingId3 | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetSortingId3 | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | SortingId3 | | SaveContents | Yes | | StringSize | 10 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| | 52 | NameAlias | Search name | AssetNameAlias | String | Show |
| Adjustment | Left | | AliasFor | AssetId | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetNameAlias | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | NameAlias | | SaveContents | Yes | | StringSize | 20 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| | 53 | TechInfo1 | Technical info 1 | AssetTechInfo | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetTechInfo | | GroupPrompt | | | HelpText | @SYS71330 (Field for technical information.) | | Label | @SYS71201 (Technical info 1) | | Mandatory | No | | Name | TechInfo1 | | SaveContents | Yes | | StringSize | 254 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| | 54 | TechInfo2 | Technical info 2 | AssetTechInfo | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetTechInfo | | GroupPrompt | | | HelpText | @sys71330 (Field for technical information.) | | Label | @SYS71202 (Technical info 2) | | Mandatory | No | | Name | TechInfo2 | | SaveContents | Yes | | StringSize | 254 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| | 55 | TechInfo3 | Technical info 3 | AssetTechInfo | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetTechInfo | | GroupPrompt | | | HelpText | @sys71330 (Field for technical information.) | | Label | @SYS71203 (Technical info 3) | | Mandatory | No | | Name | TechInfo3 | | SaveContents | Yes | | StringSize | 254 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| | 56 | LastMaintenance | Last maintenance | AssetLastMaintenance | Date | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetLastMaintenance | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | LastMaintenance | | SaveContents | Yes | | Table | AssetTable | | Type | Date | | Visible | Yes |
|
| | 57 | NextMaintenance | Next maintenance | AssetNextMaintenance | Date | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetNextMaintenance | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | NextMaintenance | | SaveContents | Yes | | Table | AssetTable | | Type | Date | | Visible | Yes |
|
| | 58 | MaintenanceInfo1 | Info 1 | AssetMaintenanceInfo | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetMaintenanceInfo | | GroupPrompt | | | HelpText | | | Label | @SYS71204 (Info 1) | | Mandatory | No | | Name | MaintenanceInfo1 | | SaveContents | Yes | | StringSize | 254 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| | 59 | MaintenanceInfo2 | Info 2 | AssetMaintenanceInfo | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetMaintenanceInfo | | GroupPrompt | | | HelpText | | | Label | @SYS71205 (Info 2) | | Mandatory | No | | Name | MaintenanceInfo2 | | SaveContents | Yes | | StringSize | 254 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| | 60 | MaintenanceInfo3 | Info 3 | AssetMaintenanceInfoMemo | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetMaintenanceInfoMemo | | GroupPrompt | | | HelpText | | | Label | @SYS71206 (Info 3) | | Mandatory | No | | Name | MaintenanceInfo3 | | SaveContents | Yes | | StringSize | (Memo) | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| | 61 | PhysicalInventory | Physical inventory | AssetPhysicalInventory | Date | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetPhysicalInventory | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | PhysicalInventory | | SaveContents | Yes | | Table | AssetTable | | Type | Date | | Visible | Yes |
|
| | 62 | Reference | Reference | AssetReference | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetReference | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Reference | | SaveContents | Yes | | StringSize | 254 | | Table | AssetTable | | Type | String | | Visible | Yes |
|
| | 63 | Notes | Comments | AssetNotes | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetNotes | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Notes | | SaveContents | Yes | | StringSize | (Memo) | | Table | AssetTable | | Type | String | | Visible | Yes |
|