|
Table Owner |
Table Name |
Table Comment |
Table Column Name |
Table Column Datatype |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|---|---|---|---|---|---|---|---|
|
dbo |
ainf_asset_class_mst |
This table will store all asset classes created in the system. |
asset_class_code |
sql_variant |
Asset Class Code |
Yes |
No |
|
|
|
|
ou_id |
int |
Organization Unit Id |
|
|
|
|
|
|
timestamp |
|
Time Stamp |
No |
|
|
|
|
|
asset_class_desc |
sql_variant |
Asset Class Description |
|
|
|
|
|
|
depreciable |
|
Depreciable |
|
|
|
|
|
|
inv_cycle |
|
Invoice Cycle |
|
|
|
|
|
|
asset_class_status |
|
Asset Class Status. Values A-Active,I-Inactive,F-Fresh |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
|
|
asset_group_code |
sql_variant |
Asset Group Code |
|
|
|
|
ainf_asset_class_tmp |
|
timestamp |
int |
Time Stamp |
|
|
|
|
|
|
ou_id |
|
Organization Unit Id |
|
|
|
|
|
|
guid |
sql_variant |
Guid |
|
|
|
|
|
|
asset_class |
|
Asset Class |
|
|
|
|
|
|
asset_class_desc |
|
Asset Class Description |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
ainf_asset_group_mst |
This table will store all asset groups created in the system. |
asset_group_code |
sql_variant |
Asset Group Code |
Yes |
|
|
|
|
|
timestamp |
int |
Time Stamp |
No |
|
|
|
|
|
asset_group_desc |
sql_variant |
Asset Group Description |
|
|
|
|
|
|
parent_group |
|
Parent Group |
|
|
|
|
|
|
asset_group_status |
|
Asset Group Status. Values A-Active,I-Inactive |
|
|
|
|
|
|
ou_id |
int |
Organization Unit Id |
|
|
|
|
|
|
createdby |
sql_variant |
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
ainf_asset_group_tmp |
|
timestamp |
int |
Time Stamp |
|
|
|
|
|
|
guid |
sql_variant |
Guid |
|
|
|
|
|
|
asset_group_code |
|
Asset Group Code |
|
|
|
|
|
|
ou_id |
int |
Organization Unit Id |
|
|
|
|
|
|
asset_group_desc |
sql_variant |
Asset Group Description |
|
|
|
|
|
|
parent_group |
|
Parent Group |
|
|
|
|
|
|
asset_group_status |
|
Asset Group Status |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
ainf_inter_tmp |
|
timestamp |
int |
Time Stamp |
|
|
|
|
|
|
guid |
sql_variant |
Guid |
|
|
|
|
|
|
asset_group_code |
|
Asset Group Code |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|