FA00500 - Asset Lease Master
SQL Query Builder
12 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| ASSETINDEX | int 0 | |||
| LEASECOMPINDX | int 0 | |||
| LEASETYPE | smallint 0 | |||
| LEASECONTRACTID | char(15) '' | |||
| LEASEPAYMENT | numeric(19,5) 0.00 | |||
| LEASEINTRATE | smallint 0 | |||
| LEASEENDDATE | datetime '1/1/1900' | |||
| 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 FA00500. Click "Join" to add to your query.