Data transfer layout
Query
Query Asset_1:
SELECT AHD_man.id AS ManID, [type]+' '+[modele] AS
Sym, dbo_equipement.part_number, dbo_equipement.categorie,
dbo_equipement.num_serie, dbo_equipement.pere,
dbo_equipement.feature0, dbo_equipement.feature1,
dbo_equipement.feature2, dbo_equipement.feature3,
dbo_equipement.feature4, dbo_equipement.feature5,
dbo_equipement.feature6, dbo_equipement.feature7,
dbo_equipement.feature8, dbo_equipement.feature9,
dbo_equipement.feature10, dbo_equipement.feature11,
dbo_equipement.clef, dbo_equipement.installateur,
dbo_equipement.date_installation, dbo_equipement.date_reception,
dbo_equipement.date_fin_garantie, dbo_equipement.date_commande,
dbo_equipement.bon_commande, dbo_equipement.vendeur,
dbo_equipement.prix_bef, dbo_equipement.prix,
dbo_equipement.sous_categorie, dbo_equipement.bc_item,
dbo_equipement.demande, dbo_equipement.date_inv,
dbo_equipement.status_inv, dbo_equipement.owner
FROM dbo_equipement LEFT JOIN AHD_man ON
dbo_equipement.constructeur = AHD_man.sym;
Query Asset_2:
SELECT Asset_1.ManID, AHD_man_mod.id AS ModelID,
AHD_man_mod.mdl_grc, Asset_1.part_number, Asset_1.categorie,
Asset_1.sous_categorie, Asset_1.num_serie, Asset_1.pere,
Asset_1.feature0, Asset_1.feature1, Asset_1.feature2,
Asset_1.feature3, Asset_1.feature4, Asset_1.feature5,
Asset_1.feature6, Asset_1.feature7, Asset_1.feature8,
Asset_1.feature9, Asset_1.feature10, Asset_1.feature11,
Asset_1.clef, Asset_1.installateur, Asset_1.date_installation,
Asset_1.date_reception, Asset_1.date_fin_garantie,
Asset_1.date_commande, Asset_1.bon_commande, Asset_1.vendeur,
Asset_1.prix_bef, Asset_1.prix, Asset_1.bc_item, Asset_1.demande,
Asset_1.demande, Asset_1.date_inv, Asset_1.status_inv,
Asset_1.owner
FROM (AHD_man_mod INNER JOIN Asset_1 ON AHD_man_mod.mdl_sym =
Asset_1.Sym) INNER JOIN AHD_man ON (AHD_man_mod.mdl_mfr_id =
AHD_man.id) AND (Asset_1.ManID = AHD_man.id);
Import text header
TABLE Network_Resource
nr_prim_search_key, nr_mdl_id,
nr_mfr_id, nr_serial_num, nr_inst_dt, nr_wrty_end_dt, nr_grc_id,
nr_family, nr_financial_id
TABLE Asset_Assignment
hier_parent, hier_log_date,
hier_child
1. Hardware Requirements
