ISM_BASE_TABLE_CREATES.sql

/*DROP TABLE SCRIPTS IF NEED TO RERUN TABLE CREATES*/
/*
DROP TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."AccountDimSystem";
DROP TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."CompanySiteDimSystem";	
DROP TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."ContractDimSystem";
DROP TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."CostCenterDimSystem";
DROP TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."PartDimSystem";
DROP TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."SourceSystemDimSystem";
DROP TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."UNSPSCDimSystemView";
DROP TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."SupplierDimSystem";	
DROP TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."InvoiceLineItemFactSystem";	
DROP TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."POLineItemFactSystem";	
*/

CREATE COLUMN TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."AccountDimSystem"(	
"source_system"	NVARCHAR(5000),
"major_account_name" NVARCHAR(5000),
"major_account_id" NVARCHAR(5000),
"company_code_rank" NVARCHAR(5000),
"company_code" NVARCHAR(5000),
"chart_of_accounts_name" NVARCHAR(5000),
"chart_of_accounts_id" NVARCHAR(5000),
"account_name_rank" NVARCHAR(5000),
"account_name" NVARCHAR(5000),
"account_id_rank" NVARCHAR(5000),
"account_id" NVARCHAR(5000)
);

CREATE COLUMN TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."CompanySiteDimSystem"(	
"street_address" NVARCHAR(5000),
"state" NVARCHAR(5000),
"source_system" NVARCHAR(5000),
"site_name" NVARCHAR(5000),
"site_id" NVARCHAR(5000),
"region" NVARCHAR(5000),
"postal_code" NVARCHAR(5000),
"flex_field3" NVARCHAR(5000),
"flex_field2" NVARCHAR(5000),
"flex_field1" NVARCHAR(5000),
"country" NVARCHAR(5000),
"company_level3" NVARCHAR(5000),
"company_level2" NVARCHAR(5000),
"company_level1" NVARCHAR(5000),
"company_level0" NVARCHAR(5000),
"city" NVARCHAR(5000)
);

CREATE COLUMN TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."ContractDimSystem"(	
"agreement_date" LONGDATE,
"effective_date" LONGDATE,
"expiration_date" LONGDATE,
"is_evergreen" NVARCHAR(5000),
"source_system" NVARCHAR(5000),
"release_type" NVARCHAR(5000),
"related_id" NVARCHAR(5000),
"parent_contract_id" NVARCHAR(5000),
"min_limit" NVARCHAR(5000),
"max_limit" NVARCHAR(5000),
"contract_type" NVARCHAR(5000),
"contract_name_l1" NVARCHAR(5000),
"contract_name" NVARCHAR(5000),
"contract_level" NVARCHAR(5000),
"contract_id_l1" NVARCHAR(5000),
"contract_id" NVARCHAR(5000),
"contract_currency" NVARCHAR(5000),
"savings_percentage" DOUBLE,
"proposed_amount" DOUBLE,
"amount" DOUBLE,
"acl_id" DOUBLE
);

CREATE COLUMN TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."CostCenterDimSystem"(	
"source_system" NVARCHAR(5000),	
"management_l8" NVARCHAR(5000),	
"management_l7" NVARCHAR(5000),	
"management_l6" NVARCHAR(5000),	
"management_l5" NVARCHAR(5000),	
"management_l4" NVARCHAR(5000),	
"management_l3" NVARCHAR(5000),	
"management_l2" NVARCHAR(5000),	
"management_l1" NVARCHAR(5000),	
"cost_center_name" NVARCHAR(5000),	
"cost_center_id" NVARCHAR(5000),	
"company_code" NVARCHAR(5000)	
);

CREATE COLUMN TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."PartDimSystem"(	
"stock_indicator" NVARCHAR(5000),	
"supplier_part_number" NVARCHAR(5000),	
"supplier_part_auxiliary_id" NVARCHAR(5000),	
"source_system" NVARCHAR(5000),	
"part_name_rank" NVARCHAR(5000),	
"part_name" NVARCHAR(5000),	
"part_key3" NVARCHAR(5000),	
"part_key2" NVARCHAR(5000),	
"part_key1" NVARCHAR(5000),	
"part_flex_text3" NVARCHAR(5000),	
"part_flex_text2" NVARCHAR(5000),	
"part_flex_text1" NVARCHAR(5000),	
"origin_country" NVARCHAR(5000),	
"material_composition" NVARCHAR(5000),	
"manufacturer" NVARCHAR(5000),	
"man_part_number" NVARCHAR(5000),	
"lead_time" NVARCHAR(5000),	
"internal_number_revision" NVARCHAR(5000),	
"internal_number" NVARCHAR(5000),	
"description2" NVARCHAR(5000),	
"description1" NVARCHAR(5000),	
"common_supplier_id" NVARCHAR(5000),	
"standard_cost" DOUBLE,	
"forecast_usage3" DOUBLE,	
"forecast_usage2" DOUBLE,	
"forecast_usage1" DOUBLE,	
"flex_field3" DOUBLE,	
"flex_field2" DOUBLE,	
"flex_field1" DOUBLE	
);

CREATE COLUMN TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."SourceSystemDimSystem"(	
"source_system_type" NVARCHAR(5000),	
"source_system_id" NVARCHAR(5000),	
"source_system" NVARCHAR(5000)	
);

CREATE COLUMN TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."UNSPSCDimSystemView"(	
"ariba_code_enabled" NVARCHAR(5000),
"parent_code_id" NVARCHAR(5000),
"custom_category_l6" NVARCHAR(5000),
"custom_category_l5" NVARCHAR(5000),
"custom_category_l4" NVARCHAR(5000),
"custom_category_l3" NVARCHAR(5000),
"custom_category_l2" NVARCHAR(5000),
"custom_category_l1" NVARCHAR(5000),
"custom_category2_l6" NVARCHAR(5000),
"custom_category2_l5" NVARCHAR(5000),
"custom_category2_l4" NVARCHAR(5000),
"custom_category2_l3" NVARCHAR(5000),
"custom_category2_l2" NVARCHAR(5000),
"custom_category2_l1" NVARCHAR(5000),
"custom_category1_l6" NVARCHAR(5000),
"custom_category1_l5" NVARCHAR(5000),
"custom_category1_l4" NVARCHAR(5000),
"custom_category1_l3" NVARCHAR(5000),
"custom_category1_l2" NVARCHAR(5000),
"custom_category1_l1" NVARCHAR(5000),
"code_name" NVARCHAR(5000),
"code_id" NVARCHAR(5000),
"category_l3" NVARCHAR(5000),
"category_l2" NVARCHAR(5000),
"category_l1" NVARCHAR(5000),
"category_id_l3" NVARCHAR(5000),
"category_id_l2" NVARCHAR(5000),
"category_id_l1" NVARCHAR(5000),
"ariba_parent_code_id" NVARCHAR(5000),
"ariba_code_version" NVARCHAR(5000),
"ariba_code_name" NVARCHAR(5000),
"ariba_code_id" NVARCHAR(5000),
"ariba_code_display_id" NVARCHAR(5000),
"ariba_category_l5" NVARCHAR(5000),
"ariba_category_l4" NVARCHAR(5000),
"ariba_category_l3" NVARCHAR(5000),
"ariba_category_l2" NVARCHAR(5000),
"ariba_category_l1" NVARCHAR(5000),
"ariba_category_id_l5" NVARCHAR(5000),
"ariba_category_id_l4" NVARCHAR(5000),
"ariba_category_id_l3" NVARCHAR(5000),
"ariba_category_id_l2" NVARCHAR(5000),
"ariba_category_id_l1" NVARCHAR(5000),
"code_supplier_opt_cost_percentage" DOUBLE,
"code_supplier_count" DOUBLE,
"code_sum_of_supplier_opt_cost" DOUBLE,
"code_sum_of_price_var_cost" DOUBLE,
"code_sum_of_line_item_count" DOUBLE,
"code_sum_of_invoice_count" DOUBLE,
"code_sum_of_amount" DOUBLE,
"code_price_var_cost_percentage" DOUBLE,
"code_part_count" DOUBLE,
"code_line_items_per_invoice"DOUBLE,
"code_level_id" DOUBLE,
"code_invoice_spend_variance" DOUBLE,
"code_invoice_spend_percentile" DOUBLE,
"code_invoice_spend_per_supplier" DOUBLE,
"code_invoice_spend_per_part" DOUBLE,
"code_invoice_spend_per_line_item" DOUBLE,
"code_invoice_spend_per_invoice" DOUBLE,
"code_invoice_spend_per_cost_center" DOUBLE,
"code_erpsupplier_count_per_enriched_supplier" DOUBLE,
"code_cost_center_count" DOUBLE
);

CREATE COLUMN TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."SupplierDimSystem"(	
"deprevious_parent_change_date" LONGDATE,
"woman_owned_enterprise" NVARCHAR(5000),
"woman_owned" NVARCHAR(5000),
"vietnam_vo" NVARCHAR(5000),
"veteran_owned_enterprise" NVARCHAR(5000),
"veteran_owned" NVARCHAR(5000),
"minority_owned_enterprise" NVARCHAR(5000),
"minority_owned" NVARCHAR(5000),
"minority_other" NVARCHAR(5000),
"minority_na" NVARCHAR(5000),
"minority_is" NVARCHAR(5000),
"minority_hispanic" NVARCHAR(5000),
"minority_black" NVARCHAR(5000),
"minority_asian" NVARCHAR(5000),
"is_supplier" NVARCHAR(5000),
"is_customer" NVARCHAR(5000),
"diversity_small_business" NVARCHAR(5000),
"diversity_sdb" NVARCHAR(5000),
"diversity_sba8_a" NVARCHAR(5000),
"diversity_labor_surplus" NVARCHAR(5000),
"diversity_hubzone" NVARCHAR(5000),
"diversity_hbcu" NVARCHAR(5000),
"diversity_green" NVARCHAR(5000),
"diversity_glbtowned" NVARCHAR(5000),
"diversity_enterprise" NVARCHAR(5000),
"diversity_disabled_owned" NVARCHAR(5000),
"diversity_dvo" NVARCHAR(5000),
"diversity" NVARCHAR(5000),
"disadvantaged_enterprise" NVARCHAR(5000),
"dvoenterprise" NVARCHAR(5000),
"dewoman_owned_enterprise" NVARCHAR(5000),
"deveteran_owned_enterprise" NVARCHAR(5000),
"desubsidiary" NVARCHAR(5000),
"desmall_business_enterprise" NVARCHAR(5000),
"desdbenterprise" NVARCHAR(5000),
"desba8_aenterprise" NVARCHAR(5000),
"deminority_owned_enterprise" NVARCHAR(5000),
"delabor_surplus_enterprise" NVARCHAR(5000),
"dein_sdn" NVARCHAR(5000),
"dehub_zone_enterprise" NVARCHAR(5000),
"deheadquarter" NVARCHAR(5000),
"dehbcuenterprise" NVARCHAR(5000),
"deglbtowned_enterprise" NVARCHAR(5000),
"dediversity_woman_owned" NVARCHAR(5000),
"dediversity_veteran_owned" NVARCHAR(5000),
"dediversity_small_business" NVARCHAR(5000),
"dediversity_sdb" NVARCHAR(5000),
"dediversity_sba8_a" NVARCHAR(5000),
"dediversity_minority_owned" NVARCHAR(5000),
"dediversity_labor_surplus" NVARCHAR(5000),
"dediversity_hub_zone" NVARCHAR(5000),
"dediversity_hbcu" NVARCHAR(5000),
"dediversity_green" NVARCHAR(5000),
"dediversity_glbtowned" NVARCHAR(5000),
"dediversity_enterprise" NVARCHAR(5000),
"dediversity_disadvantaged" NVARCHAR(5000),
"dediversity_disabled_owned" NVARCHAR(5000),
"dediversity_dvo" NVARCHAR(5000),
"dediversity" NVARCHAR(5000),
"dedisadvantaged_enterprise" NVARCHAR(5000),
"dedisabled_owned_enterprise" NVARCHAR(5000),
"dedvoenterprise" NVARCHAR(5000),
"decertified_woman_owned" NVARCHAR(5000),
"decertified_veteran_owned" NVARCHAR(5000),
"decertified_small_business" NVARCHAR(5000),
"decertified_sdb" NVARCHAR(5000),
"decertified_sba8_a" NVARCHAR(5000),
"decertified_minority_owned" NVARCHAR(5000),
"decertified_labor_surplus" NVARCHAR(5000),
"decertified_hub_zone" NVARCHAR(5000),
"decertified_hbcu" NVARCHAR(5000),
"decertified_glbtowned" NVARCHAR(5000),
"decertified_diversity" NVARCHAR(5000),
"decertified_disadvantaged" NVARCHAR(5000),
"decertified_disabled_owned" NVARCHAR(5000),
"decertified_dvo" NVARCHAR(5000),
"certified_woman_owned" NVARCHAR(5000),
"certified_veteran_owned" NVARCHAR(5000),
"certified_sdb" NVARCHAR(5000),
"certified_sba8_a" NVARCHAR(5000),
"certified_minority_owned" NVARCHAR(5000),
"certified_hubzone" NVARCHAR(5000),
"certified_diversity" NVARCHAR(5000),
"certified_disadvantaged" NVARCHAR(5000),
"certified_disabled_owned" NVARCHAR(5000),
"backup_withholding_exempt" NVARCHAR(5000),
"vat_id" NVARCHAR(5000),
"us_tin" NVARCHAR(5000),
"supplier_type" NVARCHAR(5000),
"supplier_public_name" NVARCHAR(5000),
"supplier_name_rank" NVARCHAR(5000),
"supplier_name_l9" NVARCHAR(5000),
"supplier_name_l8" NVARCHAR(5000),
"supplier_name_l7" NVARCHAR(5000),
"supplier_name_l6" NVARCHAR(5000),
"supplier_name_l5" NVARCHAR(5000),
"supplier_name_l4" NVARCHAR(5000),
"supplier_name_l3" NVARCHAR(5000),
"supplier_name_l2" NVARCHAR(5000),
"supplier_name_l10" NVARCHAR(5000),
"supplier_name_l1" NVARCHAR(5000),
"supplier_name" NVARCHAR(5000),
"supplier_location_id" NVARCHAR(5000),
"supplier_id_rank" NVARCHAR(5000),
"supplier_id_l9" NVARCHAR(5000),
"supplier_id_l8" NVARCHAR(5000),
"supplier_id_l7" NVARCHAR(5000),
"supplier_id_l6" NVARCHAR(5000),
"supplier_id_l5" NVARCHAR(5000),
"supplier_id_l4" NVARCHAR(5000),
"supplier_id_l3" NVARCHAR(5000),
"supplier_id_l2" NVARCHAR(5000),
"supplier_id_l10" NVARCHAR(5000),
"supplier_id_l1" NVARCHAR(5000),
"supplier_id" NVARCHAR(5000),
"street_address" NVARCHAR(5000),
"stock_symbol" NVARCHAR(5000),
"state_tin" NVARCHAR(5000),
"state_of_incorporation" NVARCHAR(5000),
"state" NVARCHAR(5000),
"source_system" NVARCHAR(5000),
"short_description" NVARCHAR(5000),
"regional_tin" NVARCHAR(5000),
"procurement_unit_parent" NVARCHAR(5000),
"preferred_language" NVARCHAR(5000),
"postal_code" NVARCHAR(5000),
"payment_type" NVARCHAR(5000),
"parent_supplier_id" NVARCHAR(5000),
"organization_type" NVARCHAR(5000),
"order_routing_type" NVARCHAR(5000),
"legal_name" NVARCHAR(5000),
"global_location_number" NVARCHAR(5000),
"flex_field3" NVARCHAR(5000),
"flex_field2" NVARCHAR(5000),
"flex_field1" NVARCHAR(5000),
"fax_number" NVARCHAR(5000),
"ethnicity_enterprise" NVARCHAR(5000),
"diversity_ethnicity" NVARCHAR(5000),
"dunsnumber" NVARCHAR(5000),
"desupplier_parent_name" NVARCHAR(5000),
"desupplier_parent_id" NVARCHAR(5000),
"desupplier_name" NVARCHAR(5000),
"desupplier_id" NVARCHAR(5000),
"destreet_address" NVARCHAR(5000),
"destate" NVARCHAR(5000),
"deserscore_category" NVARCHAR(5000),
"derevenue_rating" NVARCHAR(5000),
"depublic_owned_code" NVARCHAR(5000),
"deprevious_parent_name" NVARCHAR(5000),
"deprevious_parent_id" NVARCHAR(5000),
"depostal_code" NVARCHAR(5000),
"dephone_number" NVARCHAR(5000),
"depayment_trends" NVARCHAR(5000),
"denational_id_type" NVARCHAR(5000),
"denational_id" NVARCHAR(5000),
"denaicscode_name4" NVARCHAR(5000),
"denaicscode_name3" NVARCHAR(5000),
"denaicscode_name2" NVARCHAR(5000),
"denaicscode_name1" NVARCHAR(5000),
"denaicscode4" NVARCHAR(5000),
"denaicscode3" NVARCHAR(5000),
"denaicscode2" NVARCHAR(5000),
"denaicscode1" NVARCHAR(5000),
"delocation_status_code" NVARCHAR(5000),
"delegal_status_code" NVARCHAR(5000),
"deindustry_siccode_name4" NVARCHAR(5000),
"deindustry_siccode_name3" NVARCHAR(5000),
"deindustry_siccode_name2" NVARCHAR(5000),
"deindustry_siccode_name" NVARCHAR(5000),
"deindustry_siccode4" NVARCHAR(5000),
"deindustry_siccode3" NVARCHAR(5000),
"deindustry_siccode2" NVARCHAR(5000),
"deindustry_siccode" NVARCHAR(5000),
"deisolevel" NVARCHAR(5000),
"deisoindicator" NVARCHAR(5000),
"deglobal_ultimate_name" NVARCHAR(5000),
"deglobal_ultimate_id" NVARCHAR(5000),
"defederal_tax_id" NVARCHAR(5000),
"defax_number" NVARCHAR(5000),
"deethnicity_enterprise" NVARCHAR(5000),
"deemployee_rating" NVARCHAR(5000),
"dedomestic_ultimate_name" NVARCHAR(5000),
"dedomestic_ultimate_id" NVARCHAR(5000),
"dediversity_ethnicity" NVARCHAR(5000),
"decredit_rating" NVARCHAR(5000),
"decountry" NVARCHAR(5000),
"decongressional_district" NVARCHAR(5000),
"deconfidence" NVARCHAR(5000),
"decity" NVARCHAR(5000),
"decertified_ethnicity" NVARCHAR(5000),
"country" NVARCHAR(5000),
"contact_phone_number" NVARCHAR(5000),
"contact_last_name" NVARCHAR(5000),
"contact_first_name" NVARCHAR(5000),
"contact_email" NVARCHAR(5000),
"common_supplier_name" NVARCHAR(5000),
"common_supplier_id" NVARCHAR(5000),
"city" NVARCHAR(5000),
"certified_ethnicity" NVARCHAR(5000),
"approval_status" NVARCHAR(5000),
"alias2" NVARCHAR(5000),
"alias1" NVARCHAR(5000),
"annumber" NVARCHAR(5000),
"year_founded" DOUBLE,
"number_of_employees" DOUBLE,
"deyear_started" DOUBLE,
"deserscore" DOUBLE,
"dehierarchy_code" DOUBLE,
"defssscore" DOUBLE,
"defsspercentile" DOUBLE,
"defssclass" DOUBLE,
"dediversity_status_enterprise" DOUBLE,
"dediversity_status" DOUBLE,
"decertified_diversity_status" DOUBLE,
"decssscore" DOUBLE,
"decsspercentile" DOUBLE,
"decssclass" DOUBLE
);

CREATE COLUMN TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."InvoiceLineItemFactSystem"(	
"account_source_system" NVARCHAR(5000),	
"account_company_code" NVARCHAR(5000),	
"account_account_id" NVARCHAR(5000),	
"accounting_date_day" LONGDATE,	
"amount" DOUBLE,	
"amount_range_range_description" NVARCHAR(5000),	
"company_site_source_system" NVARCHAR(5000),	
"company_site_site_id" NVARCHAR(5000),	
"contract_source_system" NVARCHAR(5000),	
"contract_contract_id" NVARCHAR(5000),	
"contract_id" NVARCHAR(5000),	
"contract_line_number" NVARCHAR(5000),	
"cost_center_source_system" NVARCHAR(5000),	
"cost_center_cost_center_id" NVARCHAR(5000),	
"cost_center_company_code" NVARCHAR(5000),	
"deconfidence" NVARCHAR(5000),	
"demethod" NVARCHAR(5000),	
"descore" DOUBLE,	
"destatus" NVARCHAR(5000),	
"description" NVARCHAR(5000),	
"erpcommodity_source_system" NVARCHAR(5000),	
"erpcommodity_commodity_id" NVARCHAR(5000),	
"extra_invoice_key" NVARCHAR(5000),	
"extra_invoice_line_key" NVARCHAR(5000),	
"extra_pokey" NVARCHAR(5000),	
"extra_poline_key" NVARCHAR(5000),	
"feedback_request_request_id" DOUBLE,	
"flex_date1_day" LONGDATE,	
"flex_date2_day" LONGDATE,	
"flex_date3_day" LONGDATE,	
"flex_date4_day" LONGDATE,	
"flex_date5_day" LONGDATE,	
"flex_dimension1_source_system" NVARCHAR(5000),	
"flex_dimension1_field_id" NVARCHAR(5000),	
"flex_dimension10_source_system" NVARCHAR(5000),	
"flex_dimension10_field_id4" NVARCHAR(5000),	
"flex_dimension11_source_system" NVARCHAR(5000),	
"flex_dimension11_field_id4" NVARCHAR(5000),	
"flex_dimension12_source_system" NVARCHAR(5000),	
"flex_dimension12_field_id4" NVARCHAR(5000),	
"flex_dimension13_source_system" NVARCHAR(5000),	
"flex_dimension13_field_id8" NVARCHAR(5000),	
"flex_dimension14_source_system" NVARCHAR(5000),	
"flex_dimension14_field_id8" NVARCHAR(5000),	
"flex_dimension2_source_system" NVARCHAR(5000),	
"flex_dimension2_field_id" NVARCHAR(5000),	
"flex_dimension3_source_system" NVARCHAR(5000),	
"flex_dimension3_field_id" NVARCHAR(5000),	
"flex_dimension4_source_system" NVARCHAR(5000),	
"flex_dimension4_field_id" NVARCHAR(5000),	
"flex_dimension5_source_system" NVARCHAR(5000),	
"flex_dimension5_field_id" NVARCHAR(5000),	
"flex_dimension6_source_system" NVARCHAR(5000),	
"flex_dimension6_field_id4" NVARCHAR(5000),	
"flex_dimension7_source_system" NVARCHAR(5000),	
"flex_dimension7_field_id" NVARCHAR(5000),	
"flex_dimension8_source_system" NVARCHAR(5000),	
"flex_dimension8_field_id" NVARCHAR(5000),	
"flex_dimension9_source_system" NVARCHAR(5000),	
"flex_dimension9_field_id" NVARCHAR(5000),	
"flex_measure1" DOUBLE,	
"flex_measure2" DOUBLE,	
"flex_measure3" DOUBLE,	
"flex_measure4" DOUBLE,	
"flex_measure5" DOUBLE,	
"flex_string1" NVARCHAR(5000),	
"flex_string10" NVARCHAR(5000),	
"flex_string2" NVARCHAR(5000),	
"flex_string3" NVARCHAR(5000),	
"flex_string4" NVARCHAR(5000),	
"flex_string5" NVARCHAR(5000),	
"flex_string6" NVARCHAR(5000),	
"flex_string7" NVARCHAR(5000),	
"flex_string8" NVARCHAR(5000),	
"flex_string9" NVARCHAR(5000),	
"invoice_count" DOUBLE,	
"invoice_date_day" LONGDATE,	
"invoice_id" NVARCHAR(5000),	
"invoice_line_number" NVARCHAR(5000),	
"invoice_number" NVARCHAR(5000),	
"invoice_type" NVARCHAR(5000),	
"line_item_count" DOUBLE,	
"line_type" NVARCHAR(5000),	
"load_create_time" LONGDATE,	
"load_update_time" LONGDATE,	
"matched_contract_source_system" NVARCHAR(5000),	
"matched_contract_contract_id" NVARCHAR(5000),	
"old_unspsc_ariba_code_id" NVARCHAR(5000),	
"order_id" NVARCHAR(5000),	
"orig_amount" DOUBLE,	
"orig_currency_code" NVARCHAR(5000),	
"original_quantity" DOUBLE,	
"original_unit_of_measure" NVARCHAR(5000),	
"poamount" DOUBLE,	
"podescription" NVARCHAR(5000),	
"poid" NVARCHAR(5000),	
"poline_number" NVARCHAR(5000),	
"paid_date_day" LONGDATE,	
"part_source_system" NVARCHAR(5000),	
"part_part_key3" NVARCHAR(5000),	
"part_part_key2" NVARCHAR(5000),	
"part_part_key1" NVARCHAR(5000),	
"payment_terms" NVARCHAR(5000),	
"preview_unspsc_ariba_code_id" NVARCHAR(5000),	
"price_align_cost" DOUBLE,	
"price_var_cost" DOUBLE,	
"quantity" DOUBLE,	
"requester_user_id" NVARCHAR(5000),	
"requester_source_system" NVARCHAR(5000),	
"requester_password_adapter" NVARCHAR(5000),	
"source_system_source_system_id" NVARCHAR(5000),	
"split_accounting_number" DOUBLE,	
"std_cost_var" DOUBLE,	
"supplier_supplier_location_id" NVARCHAR(5000),	
"supplier_supplier_id" NVARCHAR(5000),	
"supplier_source_system" NVARCHAR(5000),	
"supplier_opt_cost" DOUBLE,	
"unspsc_ariba_code_id" NVARCHAR(5000),	
"unit_of_measure_unit_of_measure_id" NVARCHAR(5000)	
);

CREATE COLUMN TABLE "SAP_CONTENT#ARIBA_SPEND_ANALYSIS"."POLineItemFactSystem"(	
"account_source_system" NVARCHAR(5000),
"account_company_code" NVARCHAR(5000),
"account_account_id" NVARCHAR(5000),
"amount_range_range_description" NVARCHAR(5000),
"commodity_source_commodity_domain" NVARCHAR(5000),
"commodity_commodity_id" NVARCHAR(5000),
"company_site_source_system" NVARCHAR(5000),
"company_site_site_id" NVARCHAR(5000),
"contract_source_system" NVARCHAR(5000),
"contract_contract_id" NVARCHAR(5000),
"cost_center_source_system" NVARCHAR(5000),
"cost_center_cost_center_id" NVARCHAR(5000),
"cost_center_company_code" NVARCHAR(5000),
"erpcommodity_source_system" NVARCHAR(5000),
"erpcommodity_commodity_id" NVARCHAR(5000),
"flex_date1_day" LONGDATE,
"flex_date2_day" LONGDATE,
"flex_date3_day" LONGDATE,
"flex_date4_day" LONGDATE,
"flex_date5_day" LONGDATE,
"flex_dimension1_source_system"NVARCHAR(5000),
"flex_dimension1_field_id" NVARCHAR(5000),
"flex_dimension10_source_system" NVARCHAR(5000),
"flex_dimension10_field_id4" NVARCHAR(5000),
"flex_dimension11_source_system" NVARCHAR(5000),
"flex_dimension11_field_id4" NVARCHAR(5000),
"flex_dimension12_source_system" NVARCHAR(5000),
"flex_dimension12_field_id4" NVARCHAR(5000),
"flex_dimension13_source_system" NVARCHAR(5000),
"flex_dimension13_field_id8" NVARCHAR(5000),
"flex_dimension14_source_system" NVARCHAR(5000),
"flex_dimension14_field_id8" NVARCHAR(5000),
"flex_dimension2_source_system" NVARCHAR(5000),
"flex_dimension2_field_id" NVARCHAR(5000),
"flex_dimension3_source_system" NVARCHAR(5000),
"flex_dimension3_field_id" NVARCHAR(5000),
"flex_dimension4_source_system" NVARCHAR(5000),
"flex_dimension4_field_id" NVARCHAR(5000),
"flex_dimension5_source_system" NVARCHAR(5000),
"flex_dimension5_field_id" NVARCHAR(5000),
"flex_dimension6_source_system" NVARCHAR(5000),
"flex_dimension6_field_id4" NVARCHAR(5000),
"flex_dimension7_source_system" NVARCHAR(5000),
"flex_dimension7_field_id" NVARCHAR(5000),
"flex_dimension8_source_system" NVARCHAR(5000),
"flex_dimension8_field_id" NVARCHAR(5000),
"flex_dimension9_source_system" NVARCHAR(5000),
"flex_dimension9_field_id" NVARCHAR(5000),
"load_create_time" LONGDATE,
"load_update_time" LONGDATE,
"ordered_date_day" LONGDATE,
"part_source_system" NVARCHAR(5000),
"part_part_key3" NVARCHAR(5000),
"part_part_key2" NVARCHAR(5000),
"part_part_key1" NVARCHAR(5000),
"requester_user_id" NVARCHAR(5000),
"requester_source_system" NVARCHAR(5000),
"requester_password_adapter" NVARCHAR(5000),
"service_end_date_day" LONGDATE,
"service_start_date_day" LONGDATE,
"source_system_source_system_id" NVARCHAR(5000),
"supplier_supplier_location_id" NVARCHAR(5000),
"supplier_supplier_id" NVARCHAR(5000),
"supplier_source_system" NVARCHAR(5000),
"unspsc_ariba_code_id" NVARCHAR(5000),
"unit_of_measure_unit_of_measure_id" NVARCHAR(5000),
"poline_number" NVARCHAR(5000),
"poid" NVARCHAR(5000),
"original_unit_of_measure" NVARCHAR(5000),
"orig_currency_code" NVARCHAR(5000),
"open_po" NVARCHAR(5000),
"line_type" NVARCHAR(5000),
"flex_string9" NVARCHAR(5000),
"flex_string8" NVARCHAR(5000),
"flex_string7" NVARCHAR(5000),
"flex_string6" NVARCHAR(5000),
"flex_string5" NVARCHAR(5000),
"flex_string4" NVARCHAR(5000),
"flex_string3" NVARCHAR(5000),
"flex_string2" NVARCHAR(5000),
"flex_string10" NVARCHAR(5000),
"flex_string1" NVARCHAR(5000),
"extra_poline_key" NVARCHAR(5000),
"extra_pokey" NVARCHAR(5000),
"description" NVARCHAR(5000),
"contract_id" NVARCHAR(5000),
"split_accounting_number" DOUBLE,
"quantity" DOUBLE,
"price_var_cost" DOUBLE,
"pocount" DOUBLE,
"original_quantity" DOUBLE,
"orig_amount" DOUBLE,
"max_amount" DOUBLE,
"line_item_count" DOUBLE,
"flex_measure5" DOUBLE,
"flex_measure4" DOUBLE,
"flex_measure3" DOUBLE,
"flex_measure2" DOUBLE,
"flex_measure1" DOUBLE,
"estimated_savings" DOUBLE,
"duration" DOUBLE,
"amount" DOUBLE
);