Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/FA47204
Product: WennSoft Products (131)
Series: Financial
Display Name: FA_General_Information_Ext Group Display Name: Fixed Assets Master
Physical Name: FA47204
Technical Name: FA_General_Information_Ext
Group Technical Name: Fixed Assets Master
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | ASSETINDEX  | Asset Index | LI9_Asset_Index | Long Integer | 9 | |
Key to the Asset General Information Master (FA00100).
Click to show/hideSELECT
['FA_General_Information_Ext'].ASSETINDEX AS 'FA_General_Information_Ext-Asset Index'
,['Asset General Information Master'].ASSETINDEX AS 'Asset General Information Master-Asset Index'
FROM
FA47204 AS ['FA_General_Information_Ext']
INNER JOIN
FA00100 AS ['Asset General Information Master']
ON
['FA_General_Information_Ext'].ASSETINDEX = ['Asset General Information Master'].ASSETINDEX | ||||||
| 2 | Asset_Group_Code | Asset Group Code | STR15_LBAU | String | 15 | |
| 3 | Asset_Category_Code | Asset Category Code | STR15_LBAU | String | 15 | |
| 4 | Asset_Type_Code | Asset Type Code | STR15_LBAU | String | 15 | |
| 5 | Asset_Size_Code | Asset Size Code | STR15_LBAU | String | 15 | |
| 6 | Auctionable | Auctionable | RG_Auctionable_FA | Integer | 0 | |
| 7 | Dealer | Dealer | STR30 | String | 30 | |
| 8 | Year_Purchased | Year Purchased | Year | Integer | 4 | |
| 9 | Job_Depreciation_Rate | Job Depreciation Rate | DLR14_RBS2_T | Currency | 14 | |