FA00600 - Asset Insurance Master
SQL Query Builder
14 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| ASSETINDEX | int 0 | |||
| INSCLASSINDX | int 0 | |||
| INSURANCEYEAR | smallint 0 | |||
| INSURANCEVALUE | numeric(19,5) 0.00 | |||
| REPLACEMENTCOST | numeric(19,5) 0.00 | |||
| REPROCOST | numeric(19,5) 0.00 | |||
| DEPRREPROCOST | numeric(19,5) 0.00 | |||
| EXCLUSIONAMT | numeric(19,5) 0.00 | |||
| EXCLUSIONTYPE | char(15) '' | |||
| NOTEINDX | numeric(19,5) 0.00 | |||
| LASTMNTDDATE | datetime '1/1/1900' | |||
| LASTMNTDTIME | datetime '1/1/1900' | |||
| LASTMNTDUSERID | char(15) '' | |||
| DEX_ROW_ID | int auto number (1,1) |
Related Tables
Tables that share columns with FA00600. Click "Join" to add to your query.