asset_org_site |
Base Entity | asset_owner |
Attribute Name | site_code |
ColumnName | asset_org_site |
Definition | |
Note |
asset_org_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | NO |
asset_id |
Base Entity | asset_owner |
Attribute Name | asset_id |
ColumnName | asset_id |
Definition | |
Note |
asset_id Logical Attribute Properties |
Logical Attribute Name | asset_id |
Datatype | NUMERIC(10, 0) |
Nullable | NO |
gmt_purchased |
Base Entity | asset_owner |
Attribute Name | gmt_purchased |
ColumnName | gmt_purchased |
Definition | |
Note |
gmt_purchased Logical Attribute Properties |
Logical Attribute Name | gmt_purchased |
Datatype | TIMESTAMP/DATE |
Nullable | NO |
sold_to_site |
Base Entity | asset_owner |
Attribute Name | site_code |
ColumnName | sold_to_site |
Definition | |
Note |
sold_to_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | NO |
purch_from_site |
Base Entity | asset_owner |
Attribute Name | site_code |
ColumnName | purch_from_site |
Definition | |
Note |
purch_from_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
pc_db_site |
Base Entity | asset_owner |
Attribute Name | site_code |
ColumnName | pc_db_site |
Definition | |
Note |
pc_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
pc_db_id |
Base Entity | asset_owner |
Attribute Name | db_id |
ColumnName | pc_db_id |
Definition | |
Note |
pc_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
pc_type_code |
Base Entity | asset_owner |
Attribute Name | pc_type_code |
ColumnName | pc_type_code |
Definition | |
Note |
pc_type_code Logical Attribute Properties |
Logical Attribute Name | pc_type_code |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
asr_db_site |
Base Entity | asset_owner |
Attribute Name | site_code |
ColumnName | asr_db_site |
Definition | |
Note |
asr_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
asr_db_id |
Base Entity | asset_owner |
Attribute Name | db_id |
ColumnName | asr_db_id |
Definition | |
Note |
asr_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
asr_type_code |
Base Entity | asset_owner |
Attribute Name | asr_type_code |
ColumnName | asr_type_code |
Definition | |
Note |
asr_type_code Logical Attribute Properties |
Logical Attribute Name | asr_type_code |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
gmt_sold |
Base Entity | asset_owner |
Attribute Name | gmt_sold |
ColumnName | gmt_sold |
Definition | |
Note |
gmt_sold Logical Attribute Properties |
Logical Attribute Name | gmt_sold |
Datatype | TIMESTAMP/DATE |
Nullable | YES |
gmt_discarded |
Base Entity | asset_owner |
Attribute Name | gmt_discarded |
ColumnName | gmt_discarded |
Definition | |
Note |
gmt_discarded Logical Attribute Properties |
Logical Attribute Name | gmt_discarded |
Datatype | TIMESTAMP/DATE |
Nullable | YES |
gmt_last_updated |
Base Entity | asset_owner |
Attribute Name | gmt_last_updated |
ColumnName | gmt_last_updated |
Definition | |
Note |
gmt_last_updated Logical Attribute Properties |
Logical Attribute Name | gmt_last_updated |
Datatype | TIMESTAMP/DATE |
Nullable | YES |
last_upd_db_site |
Base Entity | asset_owner |
Attribute Name | site_code |
ColumnName | last_upd_db_site |
Definition | |
Note |
last_upd_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
last_upd_db_id |
Base Entity | asset_owner |
Attribute Name | db_id |
ColumnName | last_upd_db_id |
Definition | |
Note |
last_upd_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
rstat_type_code |
Base Entity | asset_owner |
Attribute Name | rstat_type_cod |
ColumnName | rstat_type_code |
Definition | |
Note |
rstat_type_code Logical Attribute Properties |
Logical Attribute Name | rstat_type_cod |
Datatype | NUMERIC(5, 0) |
Nullable | YES |