Table Name | AEINVTRY |
Long Name | Inventory File |
Description | This table contains assistive technology inventory data |
Prefix | IV |
Field Name | Length | Type | Description | Comments |
---|---|---|---|---|
iv_status | 1 | char | ||
iv_status | 1 | char | ||
iv_number | 9 | char | ||
iv_number | 9 | char | ||
iv_domain | 6 | char | ||
iv_domain | 6 | char | ||
iv_item | 6 | char | ||
iv_itemnum | 12 | char | ||
iv_itemnum | 12 | char | ||
iv_serial | 15 | char | ||
iv_serial | 15 | char | ||
iv_datep | 8 | datetime | ||
iv_datep | 8 | datetime | ||
iv_cost | 5 | decimal | ||
iv_cost | 5 | decimal | ||
iv_funding | 1 | char | ||
iv_funding | 1 | char | ||
iv_po | 9 | char | ||
iv_po | 9 | char | ||
iv_key | 10 | char | ||
iv_key | 10 | char | ||
iv_datein | 8 | datetime | ||
iv_datein | 8 | datetime | ||
iv_dateout | 8 | datetime | ||
iv_dateout | 8 | datetime | ||
iv_staff | 10 | char | ||
iv_staff | 10 | char | ||
iv_chid | 15 | char | ||
iv_chid | 15 | char | ||
iv_bldg | 4 | char | ||
iv_bldg | 4 | char | ||
iv_group | 6 | char | ||
iv_group | 6 | char | ||
iv_comment | 16 | text | ||
iv_comment | 16 | text | ||
iv_name | 100 | char | ||
iv_name | 100 | char | ||
iv_dist | 4 | char | ||
iv_dist | 4 | char | ||
iv_agency | 4 | char | ||
iv_agency | 4 | char | ||
iv_udate | 8 | datetime | ||
iv_udate | 8 | datetime | ||
iv_utime | 8 | char | ||
iv_utime | 8 | char | ||
iv_uid | 10 | char | ||
iv_uid | 10 | char | ||
iv_sysid | 10 | char | ||
iv_sysid | 10 | char |