| accept_date |
DATETIME |
Date of acceptance of the company |
| asset_tag |
NVARCHAR (400) |
CI Inventory Label Identifier |
| author_id |
INT |
Identifier of the author who registered the CI, reference the table AFW_USERS.user_id |
| barcode |
NVARCHAR (400) |
Barcode |
| brand_id |
INT |
CI brand identifier, reference table AFW_CATALOG_CODE.code_id |
| category_id |
INT |
Category identifier, reference table ASMS_MODEL.id |
| checkin_date |
DATETIME |
Date of registration or entry |
| checkout_date |
DATETIME |
Departure Date |
| closed_date |
DATETIME |
Date on which an IC reaches an end state |
| costcenter_id |
INT |
Cost center ID, reference table ASMS_COST_CENTER.id |
| created_date |
DATETIME |
IC creation date |
| depreciation_method |
INT |
Depreciation Method 1 = Indicates that depreciation will be calculated using the straight-line method 2 = Indicates that depreciation will be calculated using the method of summing the digits of the years |
| description |
NVARCHAR (2000) |
Description of the IC |
| file_id |
INT |
ID of the CI image, reference to table ASMS_FILE. Id |
| id* |
INT |
Unique ID |
| impact_id |
INT |
Identifier of the impact of the CI on the organization, reference the table AFW_CATALOG_CODE.code_id |
| installation_date |
DATETIME |
Installation Date |
| integration_id |
INT |
Integration ID, reference table ASMS_INTEGRATIONS.id |
| interface_id |
NVARCHAR (200) |
Identifier of the source system associated with the CI, this is given by integration |
| license_number |
NVARCHAR (200) |
IC License Number |
| location_id |
INT |
Identifier of the CI location, reference the ASMS_LOCATION.id table |
| manufacturer_id |
INT |
IC Manufacturer Identifier, reference table ASMS_COMPANY.id |
| model_id |
INT |
Model ID, reference to table AFW_CATALOG_CODE.code_id |
| modified_date |
DATETIME |
Last Date IC Changed |
| modifier_id |
INT |
Identifier of the last user who modified the CI, references the AFW_USERS.user_id table |
| name* |
NVARCHAR (400) |
Name of the IC, unique in the table |
| previous_status_id |
INT |
Identifier of the last state of the CI before it was closed |
| price |
NUMERIC |
Price or monetary value of IQ |
| provider_id |
INT |
CI provider identifier, reference table ASMS_COMPANY.id |
| reason_id |
INT |
Identifier of the reason why it is in the current state, reference the table ASMS_STATUS_REASON.reas_id |
| reponsible_date |
DATETIME |
Date the user became responsible for the CI |
| residual_value |
NUMERIC |
Residual value of the IC price relative to its original price |
| responsible_id |
INT |
CI Owner ID, reference table AFW_USERS.user_id |
| rfid |
NVARCHAR (400) |
Radio frequency identifier for IC |
| risk_level |
INT |
Risk level (1 = Low, 2 = Medium, 3 = High) |
| serial |
NVARCHAR (160) |
IC serial number |
| state_id |
INT |
CI status identifier, reference table ASMS_STATUS.stat_id |
| type_id |
INT |
Identifier of the type of the IC. (21 = CI, 48 = Packet), reference the ASMS_TYPES.id table |
| unit_id |
INT |
IC unit of measure identifier, reference table AFW_CATALOG_CODE.code_id Ex: inches |
| unit_size |
NVARCHAR (140) |
IC size value, for example: 17 inches |
| useful_life |
INT |
Lifetime value of the IC, to calculate depreciation |
| version |
INT |
Current CI Version Identifier |
