JSData & Media Start a project

← All connectors

Schema · Entity relationship diagram

Target tables and relationships

Target Business Partner Data feeds - daily/weekly sales, inventory, purchase orders, gross margin, forecast, PO plans, item and store dimensions - read from your Target file-sharing folder using your brand's own Target login.

Live16 tables · 22 relationships
ConnectEnter a login
Default schematarget
Source API docspartnersonline.com
DestinationsAmazon Redshift, Google BigQuery, Snowflake, PostgreSQL, Amazon S3
  • Columns are Target's feed headers in snake_case (the union of the vendor-level and brand-level file layouts).
  • Each delivered file replaces its own slice of the table (a date, a file, or the whole table for dimension feeds), so a re-sent file never double counts.
  • item_master and location_attributes are the item and store dimensions the fact feeds join to.
SYNC LOGdaily_sales.tcin → item_master.tcinweekly_sales.tcin → item_master.tcindaily_inventory.tcin → item_master.tcinweekly_inventory.tcin → item_master.tcindaily_orders.tcin → item_master.tcinweekly_gross_margin.tcin → item_master.tcinitem_loc_forecast_weekly.tcin → item_master.tcinpo_planning_item_dc.tcin → item_master.tcinpo_plan_daily_tcin.tcin → item_master.tcinitem_mta.tcin → item_master.tcinhistory_sales_weekly.tcin → item_master.tcinhistory_gm_weekly.tcin → item_master.tcinhistory_inv_weekly.tcin → item_master.tcindaily_sales.location_id → location_attributes.location_numberweekly_sales.location_id → location_attributes.location_numberdaily_inventory.location_id → location_attributes.location_numberweekly_inventory.location_id → location_attributes.location_numberweekly_gross_margin.location_id → location_attributes.location_numberitem_loc_forecast_weekly.location_id → location_attributes.location_numberhistory_sales_weekly.location_id → location_attributes.location_numberhistory_gm_weekly.location_id → location_attributes.location_numberhistory_inv_weekly.location_id → location_attributes.location_numberdaily_ordersdaily_orders52key_id VARCHAR(256) · primary keykey_idvarchartcin VARCHAR(256) · → item_master.tcintcinvarcharsnapshot_d DATEsnapshot_ddatepurchase_order_create_d DATEpurchase_order_create_ddatepurchase_order_id VARCHAR(256)purchase_order_idvarcharpurchase_order_active_f VARCHAR(256)purchase_order_active_fvarcharimport_order_f VARCHAR(256)import_order_fvarcharvendor_id VARCHAR(256)vendor_idvarcharupc VARCHAR(256)upcvarchardepartment_id VARCHAR(256)department_idvarcharclass_id VARCHAR(256)class_idvarcharitem_id VARCHAR(256)item_idvarchardpci VARCHAR(256)dpcivarcharvendor_style_id VARCHAR(256)vendor_style_idvarcharproduct_description VARCHAR(1024)product_descriptionvarcharreceiving_location_id VARCHAR(256)receiving_location_idvarcharreceiving_location_type_c VARCHAR(256)receiving_location_type_cvarcharoriginal_order_q DECIMAL(18,3)original_order_qdecimalrevised_order_q DECIMAL(18,3)revised_order_qdecimalcancel_remaining_order_q DECIMAL(18,3)cancel_remaining_order_qdecimalvendor_casepack_q DECIMAL(18,3)vendor_casepack_qdecimalstore_shippack_q DECIMAL(18,3)store_shippack_qdecimalitem_assortment_f VARCHAR(256)item_assortment_fvarcharitem_change_d DATEitem_change_ddateoriginal_ship_begin_d DATEoriginal_ship_begin_ddateoriginal_ship_end_d DATEoriginal_ship_end_ddaterevised_ship_begin_d DATErevised_ship_begin_ddaterevised_ship_end_d DATErevised_ship_end_ddateoriginal_estimated_arrival_d DATEoriginal_estimated_arrival_ddaterevised_estimated_arrival_d DATErevised_estimated_arrival_ddateimports_in_store_d DATEimports_in_store_ddatereceipt_d DATEreceipt_ddateitem_received_total_cost_a DECIMAL(18,3)item_received_total_cost_adecimalitem_received_total_retail_a DECIMAL(18,3)item_received_total_retail_adecimalitem_received_q DECIMAL(18,3)item_received_qdecimalpurchase_order_cancel_d DATEpurchase_order_cancel_ddatepurchase_order_canceled_f VARCHAR(256)purchase_order_canceled_fvarcharearly_ship_daily_received_q DECIMAL(18,3)early_ship_daily_received_qdecimalon_order_1_week_out_q DECIMAL(18,3)on_order_1_week_out_qdecimalon_order_2_week_out_q DECIMAL(18,3)on_order_2_week_out_qdecimalon_order_3_week_out_q DECIMAL(18,3)on_order_3_week_out_qdecimalon_order_4_8_week_out_q DECIMAL(18,3)on_order_4_8_week_out_qdecimalon_order_9_week_out_q DECIMAL(18,3)on_order_9_week_out_qdecimalcarry_over_original_eta_q DECIMAL(18,3)carry_over_original_eta_qdecimalcarry_over_revised_eta_q DECIMAL(18,3)carry_over_revised_eta_qdecimalbrand_id VARCHAR(256)brand_idvarcharbrand_n VARCHAR(1024)brand_nvarcharsource_file VARCHAR(256)source_filevarcharloaded_at TIMESTAMPloaded_attimestamp_slice VARCHAR(256)_slicevarchar_row_id VARCHAR(32)_row_idvarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestampfiles_loaded — One row per Target file seen (loaded, unmapped feed, or skipped BV_ twin of a BR_ feed).files_loaded9file_id VARCHAR(64) · primary keyfile_idvarcharname VARCHAR(256)namevarcharmodified TIMESTAMPmodifiedtimestampsize_bytes BIGINTsize_bytesbigintfeed_table VARCHAR(64)feed_tablevarcharstatus VARCHAR(32)statusvarcharrows_loaded BIGINTrows_loadedbigintloaded_at TIMESTAMPloaded_attimestamp_jsdata_synced TIMESTAMP_jsdata_syncedtimestampitem_mtaitem_mta23_row_id VARCHAR(32) · primary key_row_idvarchartcin VARCHAR(256) · → item_master.tcintcinvarcharprocessed_ct_date DATEprocessed_ct_datedatelaunch_utc_date DATElaunch_utc_datedatedpci VARCHAR(256)dpcivarchardepartment_id VARCHAR(256)department_idvarcharclass_id VARCHAR(256)class_idvarcharitem_state VARCHAR(256)item_statevarcharmta_id VARCHAR(256)mta_idvarcharmta_n VARCHAR(256)mta_nvarcharmta_value_id VARCHAR(256)mta_value_idvarcharmta_value_n VARCHAR(1024)mta_value_nvarcharmta_value_uom VARCHAR(256)mta_value_uomvarcharintended_selling_channels_arr VARCHAR(1024)intended_selling_channels_arrvarcharestore_item_status_n VARCHAR(256)estore_item_status_nvarcharprimary_vendor_id VARCHAR(256)primary_vendor_idvarcharvendor_n VARCHAR(256)vendor_nvarcharbrand_id VARCHAR(256)brand_idvarcharbrand_n VARCHAR(1024)brand_nvarcharsource_file VARCHAR(256)source_filevarcharloaded_at TIMESTAMPloaded_attimestamp_slice VARCHAR(256)_slicevarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestamphistory_inv_weeklyhistory_inv_weekly58_row_id VARCHAR(32) · primary key_row_idvarchartcin VARCHAR(256) · → item_master.tcintcinvarcharlocation_id VARCHAR(256) · → location_attributes.location_numberlocation_idvarcharweek_end_d DATEweek_end_ddateprimary_vendor_id VARCHAR(256)primary_vendor_idvarchardepartment_id VARCHAR(256)department_idvarcharclass_id VARCHAR(256)class_idvarcharitem_id VARCHAR(256)item_idvarchardpci VARCHAR(256)dpcivarcharmanufacturer_style VARCHAR(256)manufacturer_stylevarcharitem_description VARCHAR(1024)item_descriptionvarcharbeginning_on_hand_a DECIMAL(18,3)beginning_on_hand_adecimalbeginning_on_hand_q DECIMAL(18,3)beginning_on_hand_qdecimalending_on_hand_a DECIMAL(18,3)ending_on_hand_adecimalending_on_hand_q DECIMAL(18,3)ending_on_hand_qdecimalbeginning_on_transfer_a DECIMAL(18,3)beginning_on_transfer_adecimalbeginning_on_transfer_q DECIMAL(18,3)beginning_on_transfer_qdecimalending_on_transfer_a DECIMAL(18,3)ending_on_transfer_adecimalending_on_transfer_q DECIMAL(18,3)ending_on_transfer_qdecimalbeginning_on_purchase_a DECIMAL(18,3)beginning_on_purchase_adecimalbeginning_on_purchase_q DECIMAL(18,3)beginning_on_purchase_qdecimalending_on_purchase_a DECIMAL(18,3)ending_on_purchase_adecimalending_on_purchase_q DECIMAL(18,3)ending_on_purchase_qdecimalinstock_q DECIMAL(18,3)instock_qdecimalinstock_percentage DECIMAL(18,3)instock_percentagedecimalout_of_stock_q DECIMAL(18,3)out_of_stock_qdecimalout_of_stock_percentage DECIMAL(18,3)out_of_stock_percentagedecimalnon_pog_instock_q DECIMAL(18,3)non_pog_instock_qdecimalnon_pog_instock_percentage DECIMAL(18,3)non_pog_instock_percentagedecimalnon_pog_out_of_stock_q DECIMAL(18,3)non_pog_out_of_stock_qdecimalnon_pog_out_of_stock_percentage DECIMAL(18,3)non_pog_out_of_stock_percentagedecimalpog_instock_q DECIMAL(18,3)pog_instock_qdecimalpog_instock_percentage DECIMAL(18,3)pog_instock_percentagedecimalpog_out_of_stock_q DECIMAL(18,3)pog_out_of_stock_qdecimalpog_out_of_stock_percentage DECIMAL(18,3)pog_out_of_stock_percentagedecimaltracked_item_q DECIMAL(18,3)tracked_item_qdecimalnon_pog_tracked_item_q DECIMAL(18,3)non_pog_tracked_item_qdecimalpog_tracked_item_q DECIMAL(18,3)pog_tracked_item_qdecimalship_exclusion_item_location_q DECIMAL(18,3)ship_exclusion_item_location_qdecimalship_exclusion_out_of_stock_item_location_q DECIMAL(18,3)ship_exclusion_out_of_stock_item_location_qdecimalship_out_of_stock_item_location_q DECIMAL(18,3)ship_out_of_stock_item_location_qdecimalship_tracked_item_location_q DECIMAL(18,3)ship_tracked_item_location_qdecimaltracked_item_out_of_stock_q DECIMAL(18,3)tracked_item_out_of_stock_qdecimalfinal_presentation_minimum_a DECIMAL(18,3)final_presentation_minimum_adecimalfinal_presentation_minimum_q DECIMAL(18,3)final_presentation_minimum_qdecimalsales_volume_adjustment_q DECIMAL(18,3)sales_volume_adjustment_qdecimalpresentation_beginning_of_period_q DECIMAL(18,3)presentation_beginning_of_period_qdecimalpresentation_ending_of_period_q DECIMAL(18,3)presentation_ending_of_period_qdecimalpolicy_order_below_q DECIMAL(18,3)policy_order_below_qdecimaldemand_curve_coverage_q DECIMAL(18,3)demand_curve_coverage_qdecimalexcluded_item_q DECIMAL(18,3)excluded_item_qdecimalexcluded_item_out_of_stock_q DECIMAL(18,3)excluded_item_out_of_stock_qdecimalwalk_in_purchasability_percentage DECIMAL(18,3)walk_in_purchasability_percentagedecimalwalk_in_purchasable_item_locs_tracked VARCHAR(256)walk_in_purchasable_item_locs_trackedvarcharsource_file VARCHAR(256)source_filevarcharloaded_at TIMESTAMPloaded_attimestamp_slice VARCHAR(256)_slicevarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestamppo_plan_daily_tcinpo_plan_daily_tcin23_row_id VARCHAR(32) · primary key_row_idvarchartcin VARCHAR(256) · → item_master.tcintcinvarcharbusiness_d DATEbusiness_ddatevendor_id VARCHAR(256)vendor_idvarcharvendor_order_point_id VARCHAR(256)vendor_order_point_idvarchardepartment_id VARCHAR(256)department_idvarchardpci VARCHAR(256)dpcivarcharbarcode_number VARCHAR(256)barcode_numbervarcharorder_d DATEorder_ddatereceiving_location_id VARCHAR(256)receiving_location_idvarcharunit_of_measure_q DECIMAL(18,3)unit_of_measure_qdecimalunit_of_measure_type VARCHAR(256)unit_of_measure_typevarcharvendor_case_pack_q DECIMAL(18,3)vendor_case_pack_qdecimalnet_store_mean_demand_q DECIMAL(18,3)net_store_mean_demand_qdecimalordered_q DECIMAL(18,3)ordered_qdecimalreceived_q DECIMAL(18,3)received_qdecimalscheduled_receipt_q DECIMAL(18,3)scheduled_receipt_qdecimalbeginning_salesfloor_presentation_unit_q DECIMAL(18,3)beginning_salesfloor_presentation_unit_qdecimalending_salesfloor_presentation_unit_q DECIMAL(18,3)ending_salesfloor_presentation_unit_qdecimalsource_file VARCHAR(256)source_filevarcharloaded_at TIMESTAMPloaded_attimestamp_slice VARCHAR(256)_slicevarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestampweekly_inventoryweekly_inventory61_row_id VARCHAR(32) · primary key_row_idvarchartcin VARCHAR(256) · → item_master.tcintcinvarcharlocation_id VARCHAR(256) · → location_attributes.location_numberlocation_idvarcharbusiness_d DATEbusiness_ddateprimary_vendor_id VARCHAR(256)primary_vendor_idvarchardepartment_id VARCHAR(256)department_idvarcharclass_id VARCHAR(256)class_idvarcharitem_id VARCHAR(256)item_idvarchardpci VARCHAR(256)dpcivarcharmanufacturer_style VARCHAR(256)manufacturer_stylevarcharitem_description VARCHAR(1024)item_descriptionvarcharbeginning_on_hand_a DECIMAL(18,3)beginning_on_hand_adecimalbeginning_on_hand_q DECIMAL(18,3)beginning_on_hand_qdecimalending_on_hand_a DECIMAL(18,3)ending_on_hand_adecimalending_on_hand_q DECIMAL(18,3)ending_on_hand_qdecimalbeginning_on_transfer_a DECIMAL(18,3)beginning_on_transfer_adecimalbeginning_on_transfer_q DECIMAL(18,3)beginning_on_transfer_qdecimalending_on_transfer_a DECIMAL(18,3)ending_on_transfer_adecimalending_on_transfer_q DECIMAL(18,3)ending_on_transfer_qdecimalbeginning_on_purchase_a DECIMAL(18,3)beginning_on_purchase_adecimalbeginning_on_purchase_q DECIMAL(18,3)beginning_on_purchase_qdecimalending_on_purchase_a DECIMAL(18,3)ending_on_purchase_adecimalending_on_purchase_q DECIMAL(18,3)ending_on_purchase_qdecimalinstock_q DECIMAL(18,3)instock_qdecimalinstock_percentage DECIMAL(18,3)instock_percentagedecimalout_of_stock_q DECIMAL(18,3)out_of_stock_qdecimalout_of_stock_percentage DECIMAL(18,3)out_of_stock_percentagedecimalnon_pog_instock_q DECIMAL(18,3)non_pog_instock_qdecimalnon_pog_instock_percentage DECIMAL(18,3)non_pog_instock_percentagedecimalnon_pog_out_of_stock_q DECIMAL(18,3)non_pog_out_of_stock_qdecimalnon_pog_out_of_stock_percentage DECIMAL(18,3)non_pog_out_of_stock_percentagedecimalpog_instock_q DECIMAL(18,3)pog_instock_qdecimalpog_instock_percentage DECIMAL(18,3)pog_instock_percentagedecimalpog_out_of_stock_q DECIMAL(18,3)pog_out_of_stock_qdecimalpog_out_of_stock_percentage DECIMAL(18,3)pog_out_of_stock_percentagedecimaltracked_item_q DECIMAL(18,3)tracked_item_qdecimalnon_pog_tracked_item_q DECIMAL(18,3)non_pog_tracked_item_qdecimalpog_tracked_item_q DECIMAL(18,3)pog_tracked_item_qdecimalship_exclusion_item_location_q DECIMAL(18,3)ship_exclusion_item_location_qdecimalship_exclusion_out_of_stock_item_location_q DECIMAL(18,3)ship_exclusion_out_of_stock_item_location_qdecimalship_out_of_stock_item_location_q DECIMAL(18,3)ship_out_of_stock_item_location_qdecimalship_tracked_item_location_q DECIMAL(18,3)ship_tracked_item_location_qdecimaltracked_item_out_of_stock_q DECIMAL(18,3)tracked_item_out_of_stock_qdecimalfinal_presentation_minimum_a DECIMAL(18,3)final_presentation_minimum_adecimalfinal_presentation_minimum_q DECIMAL(18,3)final_presentation_minimum_qdecimalsales_volume_adjustment_q DECIMAL(18,3)sales_volume_adjustment_qdecimalitem_locations_base_count DECIMAL(18,3)item_locations_base_countdecimalpresentation_beginning_of_period_q DECIMAL(18,3)presentation_beginning_of_period_qdecimalpresentation_ending_of_period_q DECIMAL(18,3)presentation_ending_of_period_qdecimalpolicy_order_below_q DECIMAL(18,3)policy_order_below_qdecimaldemand_curve_coverage_q DECIMAL(18,3)demand_curve_coverage_qdecimalexcluded_item_q DECIMAL(18,3)excluded_item_qdecimalexcluded_item_out_of_stock_q DECIMAL(18,3)excluded_item_out_of_stock_qdecimalwalk_in_purchasability_percentage DECIMAL(18,3)walk_in_purchasability_percentagedecimalwalk_in_purchasable_item_locs_tracked VARCHAR(256)walk_in_purchasable_item_locs_trackedvarcharbrand_id VARCHAR(256)brand_idvarcharbrand_name VARCHAR(1024)brand_namevarcharsource_file VARCHAR(256)source_filevarcharloaded_at TIMESTAMPloaded_attimestamp_slice VARCHAR(256)_slicevarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestampweekly_gross_marginweekly_gross_margin46_row_id VARCHAR(32) · primary key_row_idvarchartcin VARCHAR(256) · → item_master.tcintcinvarcharlocation_id VARCHAR(256) · → location_attributes.location_numberlocation_idvarcharfiscal_week_end_d DATEfiscal_week_end_ddatevendor_id VARCHAR(256)vendor_idvarchardepartment_id VARCHAR(256)department_idvarcharclass_id VARCHAR(256)class_idvarcharitem_id VARCHAR(256)item_idvarchardpci VARCHAR(256)dpcivarcharchannel_originated VARCHAR(256)channel_originatedvarcharlocation_id_originated VARCHAR(256)location_id_originatedvarcharchannel_fulfilled VARCHAR(256)channel_fulfilledvarcharfulfillment_type VARCHAR(256)fulfillment_typevarcharfulfillment_subtype VARCHAR(256)fulfillment_subtypevarcharfreight_a DECIMAL(18,3)freight_adecimalvendor_income_a DECIMAL(18,3)vendor_income_adecimalnet_sales_a DECIMAL(18,3)net_sales_adecimalnet_sales_q DECIMAL(18,3)net_sales_qdecimalclearance_a_markdown_a DECIMAL(18,3)clearance_a_markdown_adecimalunsaleable_b_markdown_a DECIMAL(18,3)unsaleable_b_markdown_adecimalunsaleable_b_markdown_q DECIMAL(18,3)unsaleable_b_markdown_qdecimalcompetitor_c_markdown_a DECIMAL(18,3)competitor_c_markdown_adecimalpromotion_d_markdown_a DECIMAL(18,3)promotion_d_markdown_adecimalemployee_discount_a DECIMAL(18,3)employee_discount_adecimalytd_adjusted_gross_margin_a DECIMAL(18,3)ytd_adjusted_gross_margin_adecimalmisc_other_cost_of_sales DECIMAL(18,3)misc_other_cost_of_salesdecimaladjusted_gross_margin_a DECIMAL(18,3)adjusted_gross_margin_adecimalship_revenue_a DECIMAL(18,3)ship_revenue_adecimalnet_ship_expense_a DECIMAL(18,3)net_ship_expense_adecimalfree_ship_discount_a DECIMAL(18,3)free_ship_discount_adecimalnet_ship_margin_a DECIMAL(18,3)net_ship_margin_adecimalbeg_inventory_retail_a DECIMAL(18,3)beg_inventory_retail_adecimalbeg_inventory_cost_a DECIMAL(18,3)beg_inventory_cost_adecimalending_inventory_retail_a DECIMAL(18,3)ending_inventory_retail_adecimalending_inventory_cost_a DECIMAL(18,3)ending_inventory_cost_adecimalcumulative_inventory_retail_a DECIMAL(18,3)cumulative_inventory_retail_adecimalcumulative_inventory_cost_a DECIMAL(18,3)cumulative_inventory_cost_adecimalreturn_ship_expense_a DECIMAL(18,3)return_ship_expense_adecimaladjusted_gross_margin_with_net_ship_margin_a DECIMAL(18,3)adjusted_gross_margin_with_net_ship_margin_adecimalroundel_ad_revenue_a DECIMAL(18,3)roundel_ad_revenue_adecimalbrand_id VARCHAR(256)brand_idvarcharbrand_name VARCHAR(1024)brand_namevarcharsource_file VARCHAR(256)source_filevarcharloaded_at TIMESTAMPloaded_attimestamp_slice VARCHAR(256)_slicevarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestampitem_masteritem_master52tcin VARCHAR(256) · primary keytcinvarcharupc VARCHAR(256)upcvarchardpci VARCHAR(256)dpcivarcharitem_state VARCHAR(256)item_statevarchardescription VARCHAR(1024)descriptionvarcharmodel_number VARCHAR(256)model_numbervarcharvendor_id VARCHAR(256)vendor_idvarcharvendor_name VARCHAR(1024)vendor_namevarcharbrand_name VARCHAR(1024)brand_namevarcharbrand_type VARCHAR(256)brand_typevarcharmdse_category VARCHAR(256)mdse_categoryvarchargroup_no VARCHAR(256)group_novarchargroup_description VARCHAR(1024)group_descriptionvarchardiv_no VARCHAR(256)div_novarchardivision_description VARCHAR(1024)division_descriptionvarchardept_no VARCHAR(256)dept_novarchardept_description VARCHAR(1024)dept_descriptionvarcharclass_no VARCHAR(256)class_novarcharclass_description VARCHAR(1024)class_descriptionvarcharsubclass_id VARCHAR(256)subclass_idvarcharsubclass_description VARCHAR(1024)subclass_descriptionvarcharitem_type_name VARCHAR(1024)item_type_namevarcharcolor_shade VARCHAR(256)color_shadevarchargender VARCHAR(256)gendervarcharsize VARCHAR(256)sizevarcharpackage_qty DECIMAL(18,3)package_qtydecimalpackage_height VARCHAR(256)package_heightvarcharpackage_width VARCHAR(256)package_widthvarcharpackage_depth VARCHAR(256)package_depthvarcharpackage_weight VARCHAR(256)package_weightvarcharweight_uom VARCHAR(256)weight_uomvarcharnet_content_quantity_code VARCHAR(256)net_content_quantity_codevarcharnet_content_quantity_value VARCHAR(256)net_content_quantity_valuevarcharunit_of_measure VARCHAR(256)unit_of_measurevarcharimport_designation VARCHAR(256)import_designationvarcharlaunch_date TIMESTAMPlaunch_datetimestamplast_update_date TIMESTAMPlast_update_datetimestampbusiness_partner_name VARCHAR(1024)business_partner_namevarcharreturn_method VARCHAR(256)return_methodvarcharparent_tcin VARCHAR(256)parent_tcinvarcharis_flammable_flag VARCHAR(256)is_flammable_flagvarcharproduct_type_name VARCHAR(256)product_type_namevarcharproduct_sub_type_name VARCHAR(256)product_sub_type_namevarcharitem_type_category_type VARCHAR(256)item_type_category_typevarcharstyle_code VARCHAR(256)style_codevarcharstyle_name VARCHAR(1024)style_namevarcharbrand_id VARCHAR(256)brand_idvarcharsource_file VARCHAR(256)source_filevarcharloaded_at TIMESTAMPloaded_attimestamp_slice VARCHAR(256)_slicevarchar_row_id VARCHAR(32)_row_idvarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestampdaily_salesdaily_sales49_row_id VARCHAR(32) · primary key_row_idvarchartcin VARCHAR(256) · → item_master.tcintcinvarcharlocation_id VARCHAR(256) · → location_attributes.location_numberlocation_idvarcharsales_date DATEsales_datedatevendor_id VARCHAR(256)vendor_idvarcharbarcode VARCHAR(256)barcodevarchardpci VARCHAR(256)dpcivarcharmanufacturer_style VARCHAR(256)manufacturer_stylevarchardept VARCHAR(256)deptvarcharclass VARCHAR(256)classvarcharitem_description VARCHAR(1024)item_descriptionvarcharorigination_channel VARCHAR(256)origination_channelvarcharreporting_channel VARCHAR(256)reporting_channelvarcharfulfillment_type VARCHAR(256)fulfillment_typevarchardrive_up_sale_a DECIMAL(18,3)drive_up_sale_adecimaldrive_up_sale_q DECIMAL(18,3)drive_up_sale_qdecimalsale_amount DECIMAL(18,3)sale_amountdecimalsale_quantity DECIMAL(18,3)sale_quantitydecimalcircular_sale_amount DECIMAL(18,3)circular_sale_amountdecimalcircular_sale_quantity DECIMAL(18,3)circular_sale_quantitydecimalclearance_sale_amount DECIMAL(18,3)clearance_sale_amountdecimalclearance_sale_quantity DECIMAL(18,3)clearance_sale_quantitydecimalpromo_sale_amount DECIMAL(18,3)promo_sale_amountdecimalpromo_sale_quantity DECIMAL(18,3)promo_sale_quantitydecimalregular_sale_amount DECIMAL(18,3)regular_sale_amountdecimalregular_sale_quantity DECIMAL(18,3)regular_sale_quantitydecimalcircle_sale_amount DECIMAL(18,3)circle_sale_amountdecimalcircle_sale_quantity DECIMAL(18,3)circle_sale_quantitydecimalmature_sale_amount DECIMAL(18,3)mature_sale_amountdecimalmature_sale_quantity DECIMAL(18,3)mature_sale_quantitydecimalcomparable_sale_amount DECIMAL(18,3)comparable_sale_amountdecimalcomparable_sale_quantity DECIMAL(18,3)comparable_sale_quantitydecimalad_comparable_sale_amount DECIMAL(18,3)ad_comparable_sale_amountdecimalad_comparable_sale_quantity DECIMAL(18,3)ad_comparable_sale_quantitydecimalreturn_guest_amount DECIMAL(18,3)return_guest_amountdecimalreturn_guest_quantity DECIMAL(18,3)return_guest_quantitydecimaloriginal_location_id VARCHAR(256)original_location_idvarcharoriginal_reporting_channel VARCHAR(256)original_reporting_channelvarcharoriginal_origination_channel VARCHAR(256)original_origination_channelvarcharshipt_app_sale_a DECIMAL(18,3)shipt_app_sale_adecimalshipt_app_sale_q DECIMAL(18,3)shipt_app_sale_qdecimalshipt_target_sale_a DECIMAL(18,3)shipt_target_sale_adecimalshipt_target_sale_q DECIMAL(18,3)shipt_target_sale_qdecimalbrand_id VARCHAR(256)brand_idvarcharbrand_name VARCHAR(1024)brand_namevarcharsource_file VARCHAR(256)source_filevarcharloaded_at TIMESTAMPloaded_attimestamp_slice VARCHAR(256)_slicevarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestamppo_planning_item_dcpo_planning_item_dc27_row_id VARCHAR(32) · primary key_row_idvarchartcin VARCHAR(256) · → item_master.tcintcinvarcharbusiness_d DATEbusiness_ddatevendor_id VARCHAR(256)vendor_idvarcharvendor_order_point_id VARCHAR(256)vendor_order_point_idvarchardepartment_id VARCHAR(256)department_idvarchardpci VARCHAR(256)dpcivarcharbarcode_number VARCHAR(256)barcode_numbervarcharorder_d DATEorder_ddatereceiving_location_id VARCHAR(256)receiving_location_idvarcharunit_of_measure_q DECIMAL(18,3)unit_of_measure_qdecimalunit_of_measure_type VARCHAR(256)unit_of_measure_typevarcharvendor_case_pack_q DECIMAL(18,3)vendor_case_pack_qdecimalnet_store_mean_demand_q DECIMAL(18,3)net_store_mean_demand_qdecimalordered_q DECIMAL(18,3)ordered_qdecimalreceived_q DECIMAL(18,3)received_qdecimalscheduled_receipt_q DECIMAL(18,3)scheduled_receipt_qdecimalbeginning_salesfloor_presentation_unit_q DECIMAL(18,3)beginning_salesfloor_presentation_unit_qdecimalending_salesfloor_presentation_unit_q DECIMAL(18,3)ending_salesfloor_presentation_unit_qdecimaltotal_order_cost_a DECIMAL(18,3)total_order_cost_adecimalproduct_cost_a DECIMAL(18,3)product_cost_adecimalinitial_store_inventory_q DECIMAL(18,3)initial_store_inventory_qdecimalpurchasing_lead_time_q DECIMAL(18,3)purchasing_lead_time_qdecimalsource_file VARCHAR(256)source_filevarcharloaded_at TIMESTAMPloaded_attimestamp_slice VARCHAR(256)_slicevarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestampdaily_inventorydaily_inventory66_row_id VARCHAR(32) · primary key_row_idvarchartcin VARCHAR(256) · → item_master.tcintcinvarcharlocation_id VARCHAR(256) · → location_attributes.location_numberlocation_idvarcharbusiness_d DATEbusiness_ddateprimary_vendor_id VARCHAR(256)primary_vendor_idvarchardepartment_id VARCHAR(256)department_idvarcharclass_id VARCHAR(256)class_idvarcharitem_id VARCHAR(256)item_idvarchardpci VARCHAR(256)dpcivarcharmanufacturer_style VARCHAR(256)manufacturer_stylevarcharitem_description VARCHAR(1024)item_descriptionvarcharbeginning_on_hand_a DECIMAL(18,3)beginning_on_hand_adecimalbeginning_on_hand_q DECIMAL(18,3)beginning_on_hand_qdecimalending_on_hand_a DECIMAL(18,3)ending_on_hand_adecimalending_on_hand_q DECIMAL(18,3)ending_on_hand_qdecimalbeginning_on_transfer_a DECIMAL(18,3)beginning_on_transfer_adecimalbeginning_on_transfer_q DECIMAL(18,3)beginning_on_transfer_qdecimalending_on_transfer_a DECIMAL(18,3)ending_on_transfer_adecimalending_on_transfer_q DECIMAL(18,3)ending_on_transfer_qdecimalbeginning_on_purchase_a DECIMAL(18,3)beginning_on_purchase_adecimalbeginning_on_purchase_q DECIMAL(18,3)beginning_on_purchase_qdecimalending_on_purchase_a DECIMAL(18,3)ending_on_purchase_adecimalending_on_purchase_q DECIMAL(18,3)ending_on_purchase_qdecimalinstock_q DECIMAL(18,3)instock_qdecimalinstock_percentage DECIMAL(18,3)instock_percentagedecimalout_of_stock_q DECIMAL(18,3)out_of_stock_qdecimalout_of_stock_percentage DECIMAL(18,3)out_of_stock_percentagedecimalnon_pog_instock_q DECIMAL(18,3)non_pog_instock_qdecimalnon_pog_instock_percentage DECIMAL(18,3)non_pog_instock_percentagedecimalnon_pog_out_of_stock_q DECIMAL(18,3)non_pog_out_of_stock_qdecimalnon_pog_out_of_stock_percentage DECIMAL(18,3)non_pog_out_of_stock_percentagedecimalpog_instock_q DECIMAL(18,3)pog_instock_qdecimalpog_instock_percentage DECIMAL(18,3)pog_instock_percentagedecimalpog_out_of_stock_q DECIMAL(18,3)pog_out_of_stock_qdecimalpog_out_of_stock_percentage DECIMAL(18,3)pog_out_of_stock_percentagedecimaltracked_item_q DECIMAL(18,3)tracked_item_qdecimalnon_pog_tracked_item_q DECIMAL(18,3)non_pog_tracked_item_qdecimalpog_tracked_item_q DECIMAL(18,3)pog_tracked_item_qdecimalship_exclusion_item_location_q DECIMAL(18,3)ship_exclusion_item_location_qdecimalship_exclusion_out_of_stock_item_location_q DECIMAL(18,3)ship_exclusion_out_of_stock_item_location_qdecimalship_out_of_stock_item_location_q DECIMAL(18,3)ship_out_of_stock_item_location_qdecimalship_tracked_item_location_q DECIMAL(18,3)ship_tracked_item_location_qdecimaltracked_item_out_of_stock_q DECIMAL(18,3)tracked_item_out_of_stock_qdecimalorder_to_level_q DECIMAL(18,3)order_to_level_qdecimalorder_point_q DECIMAL(18,3)order_point_qdecimallead_time_days_q DECIMAL(18,3)lead_time_days_qdecimalreview_time_days_q DECIMAL(18,3)review_time_days_qdecimalsafety_stock_q DECIMAL(18,3)safety_stock_qdecimalreorder_frequency_q DECIMAL(18,3)reorder_frequency_qdecimalfinal_presentation_minimum_a DECIMAL(18,3)final_presentation_minimum_adecimalfinal_presentation_minimum_q DECIMAL(18,3)final_presentation_minimum_qdecimalsales_volume_adjustment_q DECIMAL(18,3)sales_volume_adjustment_qdecimalpresentation_beginning_of_period_q DECIMAL(18,3)presentation_beginning_of_period_qdecimalpresentation_ending_of_period_q DECIMAL(18,3)presentation_ending_of_period_qdecimalpolicy_order_below_q DECIMAL(18,3)policy_order_below_qdecimaldemand_curve_coverage_q DECIMAL(18,3)demand_curve_coverage_qdecimalexcluded_item_q DECIMAL(18,3)excluded_item_qdecimalexcluded_item_out_of_stock_q DECIMAL(18,3)excluded_item_out_of_stock_qdecimalwalk_in_purchasability_percentage DECIMAL(18,3)walk_in_purchasability_percentagedecimalwalk_in_purchasable_item_locs_tracked VARCHAR(256)walk_in_purchasable_item_locs_trackedvarcharbrand_id VARCHAR(256)brand_idvarcharbrand_name VARCHAR(1024)brand_namevarcharsource_file VARCHAR(256)source_filevarcharloaded_at TIMESTAMPloaded_attimestamp_slice VARCHAR(256)_slicevarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestamphistory_gm_weeklyhistory_gm_weekly44_row_id VARCHAR(32) · primary key_row_idvarchartcin VARCHAR(256) · → item_master.tcintcinvarcharlocation_id VARCHAR(256) · → location_attributes.location_numberlocation_idvarcharfiscal_week_end_date DATEfiscal_week_end_datedatevendor_id VARCHAR(256)vendor_idvarchardepartment_id VARCHAR(256)department_idvarcharclass_id VARCHAR(256)class_idvarcharitem_id VARCHAR(256)item_idvarchardpci VARCHAR(256)dpcivarcharchannel_originated VARCHAR(256)channel_originatedvarcharlocation_id_originated VARCHAR(256)location_id_originatedvarcharchannel_fulfilled VARCHAR(256)channel_fulfilledvarcharfulfillment_type VARCHAR(256)fulfillment_typevarcharfulfillment_subtype VARCHAR(256)fulfillment_subtypevarcharfreight_a DECIMAL(18,3)freight_adecimalvendor_income_a DECIMAL(18,3)vendor_income_adecimalnet_sales_a DECIMAL(18,3)net_sales_adecimalnet_sales_q DECIMAL(18,3)net_sales_qdecimalclearance_a_markdown_a DECIMAL(18,3)clearance_a_markdown_adecimalunsaleable_b_markdown_a DECIMAL(18,3)unsaleable_b_markdown_adecimalunsaleable_b_markdown_q DECIMAL(18,3)unsaleable_b_markdown_qdecimalcompetitor_c_markdown_a DECIMAL(18,3)competitor_c_markdown_adecimalpromotion_d_markdown_a DECIMAL(18,3)promotion_d_markdown_adecimalemployee_discount_a DECIMAL(18,3)employee_discount_adecimalytd_adjusted_gross_margin_a DECIMAL(18,3)ytd_adjusted_gross_margin_adecimalmisc_other_cost_of_sales DECIMAL(18,3)misc_other_cost_of_salesdecimaladjusted_gross_margin_a DECIMAL(18,3)adjusted_gross_margin_adecimalship_revenue_a DECIMAL(18,3)ship_revenue_adecimalnet_ship_expense_a DECIMAL(18,3)net_ship_expense_adecimalfree_ship_discount_a DECIMAL(18,3)free_ship_discount_adecimalnet_ship_margin_a DECIMAL(18,3)net_ship_margin_adecimalbeg_inventory_retail_a DECIMAL(18,3)beg_inventory_retail_adecimalbeg_inventory_cost_a DECIMAL(18,3)beg_inventory_cost_adecimalending_inventory_retail_a DECIMAL(18,3)ending_inventory_retail_adecimalending_inventory_cost_a DECIMAL(18,3)ending_inventory_cost_adecimalcumulative_inventory_retail_a DECIMAL(18,3)cumulative_inventory_retail_adecimalcumulative_inventory_cost_a DECIMAL(18,3)cumulative_inventory_cost_adecimalreturn_ship_expense_a DECIMAL(18,3)return_ship_expense_adecimaladjusted_gross_margin_with_net_ship_margin_a DECIMAL(18,3)adjusted_gross_margin_with_net_ship_margin_adecimalroundel_ad_revenue_a DECIMAL(18,3)roundel_ad_revenue_adecimalsource_file VARCHAR(256)source_filevarcharloaded_at TIMESTAMPloaded_attimestamp_slice VARCHAR(256)_slicevarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestamplocation_attributeslocation_attributes33location_number VARCHAR(256) · primary keylocation_numbervarcharlocation_type VARCHAR(256)location_typevarcharlocation_subtype VARCHAR(256)location_subtypevarcharlocation_name VARCHAR(1024)location_namevarcharaddress_1 VARCHAR(1024)address_1varcharaddress_2 VARCHAR(1024)address_2varcharcity VARCHAR(256)cityvarcharstate VARCHAR(256)statevarcharzip_code VARCHAR(256)zip_codevarcharservicing_rdc VARCHAR(256)servicing_rdcvarcharservicing_fdc VARCHAR(256)servicing_fdcvarcharregion VARCHAR(256)regionvarchardistrict VARCHAR(256)districtvarchargroup_id VARCHAR(256)group_idvarcharstore_format VARCHAR(256)store_formatvarcharlast_remodel_date DATElast_remodel_datedatenext_remodel_date DATEnext_remodel_datedatestore_size VARCHAR(256)store_sizevarcharlatitude DECIMAL(18,6)latitudedecimallongitude DECIMAL(18,6)longitudedecimalstore_open_date DATEstore_open_datedatestore_close_date DATEstore_close_datedatestore_status VARCHAR(256)store_statusvarcharoptical_in_store VARCHAR(256)optical_in_storevarcharpharmacy_in_store VARCHAR(256)pharmacy_in_storevarcharis_mature_store_f VARCHAR(256)is_mature_store_fvarcharfresh_grocery_available_f VARCHAR(256)fresh_grocery_available_fvarcharmature_store_begin_date DATEmature_store_begin_datedatesource_file VARCHAR(256)source_filevarcharloaded_at TIMESTAMPloaded_attimestamp_slice VARCHAR(256)_slicevarchar_row_id VARCHAR(32)_row_idvarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestampweekly_salesweekly_sales49_row_id VARCHAR(32) · primary key_row_idvarchartcin VARCHAR(256) · → item_master.tcintcinvarcharlocation_id VARCHAR(256) · → location_attributes.location_numberlocation_idvarcharsales_date DATEsales_datedatevendor_id VARCHAR(256)vendor_idvarcharbarcode VARCHAR(256)barcodevarchardpci VARCHAR(256)dpcivarcharmanufacturer_style VARCHAR(256)manufacturer_stylevarchardept VARCHAR(256)deptvarcharclass VARCHAR(256)classvarcharitem_description VARCHAR(1024)item_descriptionvarcharorigination_channel VARCHAR(256)origination_channelvarcharreporting_channel VARCHAR(256)reporting_channelvarcharfulfillment_type VARCHAR(256)fulfillment_typevarchardrive_up_sale_a DECIMAL(18,3)drive_up_sale_adecimaldrive_up_sale_q DECIMAL(18,3)drive_up_sale_qdecimalsale_amount DECIMAL(18,3)sale_amountdecimalsale_quantity DECIMAL(18,3)sale_quantitydecimalcircular_sale_amount DECIMAL(18,3)circular_sale_amountdecimalcircular_sale_quantity DECIMAL(18,3)circular_sale_quantitydecimalclearance_sale_amount DECIMAL(18,3)clearance_sale_amountdecimalclearance_sale_quantity DECIMAL(18,3)clearance_sale_quantitydecimalpromo_sale_amount DECIMAL(18,3)promo_sale_amountdecimalpromo_sale_quantity DECIMAL(18,3)promo_sale_quantitydecimalregular_sale_amount DECIMAL(18,3)regular_sale_amountdecimalregular_sale_quantity DECIMAL(18,3)regular_sale_quantitydecimalcircle_sale_amount DECIMAL(18,3)circle_sale_amountdecimalcircle_sale_quantity DECIMAL(18,3)circle_sale_quantitydecimalmature_sale_amount DECIMAL(18,3)mature_sale_amountdecimalmature_sale_quantity DECIMAL(18,3)mature_sale_quantitydecimalcomparable_sale_amount DECIMAL(18,3)comparable_sale_amountdecimalcomparable_sale_quantity DECIMAL(18,3)comparable_sale_quantitydecimalad_comparable_sale_amount DECIMAL(18,3)ad_comparable_sale_amountdecimalad_comparable_sale_quantity DECIMAL(18,3)ad_comparable_sale_quantitydecimalreturn_guest_amount DECIMAL(18,3)return_guest_amountdecimalreturn_guest_quantity DECIMAL(18,3)return_guest_quantitydecimaloriginal_location_id VARCHAR(256)original_location_idvarcharoriginal_reporting_channel VARCHAR(256)original_reporting_channelvarcharoriginal_origination_channel VARCHAR(256)original_origination_channelvarcharshipt_app_sale_a DECIMAL(18,3)shipt_app_sale_adecimalshipt_app_sale_q DECIMAL(18,3)shipt_app_sale_qdecimalshipt_target_sale_a DECIMAL(18,3)shipt_target_sale_adecimalshipt_target_sale_q DECIMAL(18,3)shipt_target_sale_qdecimalbrand_id VARCHAR(256)brand_idvarcharbrand_name VARCHAR(1024)brand_namevarcharsource_file VARCHAR(256)source_filevarcharloaded_at TIMESTAMPloaded_attimestamp_slice VARCHAR(256)_slicevarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestampitem_loc_forecast_weeklyitem_loc_forecast_weekly16_row_id VARCHAR(32) · primary key_row_idvarchartcin VARCHAR(256) · → item_master.tcintcinvarcharlocation_id VARCHAR(256) · → location_attributes.location_numberlocation_idvarcharlast_update_d DATElast_update_ddatedepartment_id VARCHAR(256)department_idvarcharclass_id VARCHAR(256)class_idvarchardpci VARCHAR(256)dpcivarcharselected_forecast_q DECIMAL(18,3)selected_forecast_qdecimalvendor_id VARCHAR(256)vendor_idvarcharfiscal_week_begin_d DATEfiscal_week_begin_ddatebrand_n VARCHAR(1024)brand_nvarcharbrand_id VARCHAR(256)brand_idvarcharsource_file VARCHAR(256)source_filevarcharloaded_at TIMESTAMPloaded_attimestamp_slice VARCHAR(256)_slicevarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestamphistory_sales_weeklyhistory_sales_weekly47_row_id VARCHAR(32) · primary key_row_idvarchartcin VARCHAR(256) · → item_master.tcintcinvarcharlocation_id VARCHAR(256) · → location_attributes.location_numberlocation_idvarcharsales_date DATEsales_datedatevendor_id VARCHAR(256)vendor_idvarcharbarcode VARCHAR(256)barcodevarchardpci VARCHAR(256)dpcivarcharmanufacturer_style VARCHAR(256)manufacturer_stylevarchardept VARCHAR(256)deptvarcharclass VARCHAR(256)classvarcharitem_description VARCHAR(1024)item_descriptionvarcharorigination_channel VARCHAR(256)origination_channelvarcharreporting_channel VARCHAR(256)reporting_channelvarcharfulfillment_type VARCHAR(256)fulfillment_typevarchardrive_up_sale_a DECIMAL(18,3)drive_up_sale_adecimaldrive_up_sale_q DECIMAL(18,3)drive_up_sale_qdecimalsale_amount DECIMAL(18,3)sale_amountdecimalsale_quantity DECIMAL(18,3)sale_quantitydecimalcircular_sale_amount DECIMAL(18,3)circular_sale_amountdecimalcircular_sale_quantity DECIMAL(18,3)circular_sale_quantitydecimalclearance_sale_amount DECIMAL(18,3)clearance_sale_amountdecimalclearance_sale_quantity DECIMAL(18,3)clearance_sale_quantitydecimalpromo_sale_amount DECIMAL(18,3)promo_sale_amountdecimalpromo_sale_quantity DECIMAL(18,3)promo_sale_quantitydecimalregular_sale_amount DECIMAL(18,3)regular_sale_amountdecimalregular_sale_quantity DECIMAL(18,3)regular_sale_quantitydecimalcircle_sale_amount DECIMAL(18,3)circle_sale_amountdecimalcircle_sale_quantity DECIMAL(18,3)circle_sale_quantitydecimalmature_sale_amount DECIMAL(18,3)mature_sale_amountdecimalmature_sale_quantity DECIMAL(18,3)mature_sale_quantitydecimalcomparable_sale_amount DECIMAL(18,3)comparable_sale_amountdecimalcomparable_sale_quantity DECIMAL(18,3)comparable_sale_quantitydecimalad_comparable_sale_amount DECIMAL(18,3)ad_comparable_sale_amountdecimalad_comparable_sale_quantity DECIMAL(18,3)ad_comparable_sale_quantitydecimalreturn_guest_amount DECIMAL(18,3)return_guest_amountdecimalreturn_guest_quantity DECIMAL(18,3)return_guest_quantitydecimaloriginal_location_id VARCHAR(256)original_location_idvarcharoriginal_reporting_channel VARCHAR(256)original_reporting_channelvarcharoriginal_origination_channel VARCHAR(256)original_origination_channelvarcharshipt_app_sale_a DECIMAL(18,3)shipt_app_sale_adecimalshipt_app_sale_q DECIMAL(18,3)shipt_app_sale_qdecimalshipt_target_sale_a DECIMAL(18,3)shipt_target_sale_adecimalshipt_target_sale_q DECIMAL(18,3)shipt_target_sale_qdecimalsource_file VARCHAR(256)source_filevarcharloaded_at TIMESTAMPloaded_attimestamp_slice VARCHAR(256)_slicevarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestamp
Primary keyForeign keyReferencesJoins on (not a key)

Drag to pan, scroll or pinch to zoom, click a table to see what it joins to.

Table reference

16 tables · click a table for its columns
daily_sales49 columns · Salesshow in diagram

Primary key: _row_id

ColumnTypeKeyDescription
sales_datedate
vendor_idvarchar(256)
barcodevarchar(256)
tcinReferences item_master.tcin.varchar(256)FKReferences item_master.tcin.
dpcivarchar(256)
manufacturer_stylevarchar(256)
deptvarchar(256)
classvarchar(256)
item_descriptionvarchar(1024)
origination_channelvarchar(256)
reporting_channelvarchar(256)
fulfillment_typevarchar(256)
drive_up_sale_adecimal(18,3)
drive_up_sale_qdecimal(18,3)
location_idReferences location_attributes.location_number.varchar(256)FKReferences location_attributes.location_number.
sale_amountdecimal(18,3)
sale_quantitydecimal(18,3)
circular_sale_amountdecimal(18,3)
circular_sale_quantitydecimal(18,3)
clearance_sale_amountdecimal(18,3)
clearance_sale_quantitydecimal(18,3)
promo_sale_amountdecimal(18,3)
promo_sale_quantitydecimal(18,3)
regular_sale_amountdecimal(18,3)
regular_sale_quantitydecimal(18,3)
circle_sale_amountdecimal(18,3)
circle_sale_quantitydecimal(18,3)
mature_sale_amountdecimal(18,3)
mature_sale_quantitydecimal(18,3)
comparable_sale_amountdecimal(18,3)
comparable_sale_quantitydecimal(18,3)
ad_comparable_sale_amountdecimal(18,3)
ad_comparable_sale_quantitydecimal(18,3)
return_guest_amountdecimal(18,3)
return_guest_quantitydecimal(18,3)
original_location_idvarchar(256)
original_reporting_channelvarchar(256)
original_origination_channelvarchar(256)
shipt_app_sale_adecimal(18,3)
shipt_app_sale_qdecimal(18,3)
shipt_target_sale_adecimal(18,3)
shipt_target_sale_qdecimal(18,3)
brand_idvarchar(256)
brand_namevarchar(1024)
source_fileThe delivered file this row came from.varchar(256)The delivered file this row came from.
loaded_atWhen the file was loaded.timestampWhen the file was loaded.
_sliceThe slice a delivered file replaces (date, file or "all").varchar(256)The slice a delivered file replaces (date, file or "all").
_row_idPrimary key.varchar(32)PK Primary key.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
weekly_sales49 columns · Salesshow in diagram

Primary key: _row_id

ColumnTypeKeyDescription
sales_datedate
vendor_idvarchar(256)
barcodevarchar(256)
tcinReferences item_master.tcin.varchar(256)FKReferences item_master.tcin.
dpcivarchar(256)
manufacturer_stylevarchar(256)
deptvarchar(256)
classvarchar(256)
item_descriptionvarchar(1024)
origination_channelvarchar(256)
reporting_channelvarchar(256)
fulfillment_typevarchar(256)
drive_up_sale_adecimal(18,3)
drive_up_sale_qdecimal(18,3)
location_idReferences location_attributes.location_number.varchar(256)FKReferences location_attributes.location_number.
sale_amountdecimal(18,3)
sale_quantitydecimal(18,3)
circular_sale_amountdecimal(18,3)
circular_sale_quantitydecimal(18,3)
clearance_sale_amountdecimal(18,3)
clearance_sale_quantitydecimal(18,3)
promo_sale_amountdecimal(18,3)
promo_sale_quantitydecimal(18,3)
regular_sale_amountdecimal(18,3)
regular_sale_quantitydecimal(18,3)
circle_sale_amountdecimal(18,3)
circle_sale_quantitydecimal(18,3)
mature_sale_amountdecimal(18,3)
mature_sale_quantitydecimal(18,3)
comparable_sale_amountdecimal(18,3)
comparable_sale_quantitydecimal(18,3)
ad_comparable_sale_amountdecimal(18,3)
ad_comparable_sale_quantitydecimal(18,3)
return_guest_amountdecimal(18,3)
return_guest_quantitydecimal(18,3)
original_location_idvarchar(256)
original_reporting_channelvarchar(256)
original_origination_channelvarchar(256)
shipt_app_sale_adecimal(18,3)
shipt_app_sale_qdecimal(18,3)
shipt_target_sale_adecimal(18,3)
shipt_target_sale_qdecimal(18,3)
brand_idvarchar(256)
brand_namevarchar(1024)
source_fileThe delivered file this row came from.varchar(256)The delivered file this row came from.
loaded_atWhen the file was loaded.timestampWhen the file was loaded.
_sliceThe slice a delivered file replaces (date, file or "all").varchar(256)The slice a delivered file replaces (date, file or "all").
_row_idPrimary key.varchar(32)PK Primary key.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
daily_inventory66 columns · Inventoryshow in diagram

Primary key: _row_id

ColumnTypeKeyDescription
business_ddate
primary_vendor_idvarchar(256)
tcinReferences item_master.tcin.varchar(256)FKReferences item_master.tcin.
department_idvarchar(256)
class_idvarchar(256)
item_idvarchar(256)
dpcivarchar(256)
manufacturer_stylevarchar(256)
item_descriptionvarchar(1024)
location_idReferences location_attributes.location_number.varchar(256)FKReferences location_attributes.location_number.
beginning_on_hand_adecimal(18,3)
beginning_on_hand_qdecimal(18,3)
ending_on_hand_adecimal(18,3)
ending_on_hand_qdecimal(18,3)
beginning_on_transfer_adecimal(18,3)
beginning_on_transfer_qdecimal(18,3)
ending_on_transfer_adecimal(18,3)
ending_on_transfer_qdecimal(18,3)
beginning_on_purchase_adecimal(18,3)
beginning_on_purchase_qdecimal(18,3)
ending_on_purchase_adecimal(18,3)
ending_on_purchase_qdecimal(18,3)
instock_qdecimal(18,3)
instock_percentagedecimal(18,3)
out_of_stock_qdecimal(18,3)
out_of_stock_percentagedecimal(18,3)
non_pog_instock_qdecimal(18,3)
non_pog_instock_percentagedecimal(18,3)
non_pog_out_of_stock_qdecimal(18,3)
non_pog_out_of_stock_percentagedecimal(18,3)
pog_instock_qdecimal(18,3)
pog_instock_percentagedecimal(18,3)
pog_out_of_stock_qdecimal(18,3)
pog_out_of_stock_percentagedecimal(18,3)
tracked_item_qdecimal(18,3)
non_pog_tracked_item_qdecimal(18,3)
pog_tracked_item_qdecimal(18,3)
ship_exclusion_item_location_qdecimal(18,3)
ship_exclusion_out_of_stock_item_location_qdecimal(18,3)
ship_out_of_stock_item_location_qdecimal(18,3)
ship_tracked_item_location_qdecimal(18,3)
tracked_item_out_of_stock_qdecimal(18,3)
order_to_level_qdecimal(18,3)
order_point_qdecimal(18,3)
lead_time_days_qdecimal(18,3)
review_time_days_qdecimal(18,3)
safety_stock_qdecimal(18,3)
reorder_frequency_qdecimal(18,3)
final_presentation_minimum_adecimal(18,3)
final_presentation_minimum_qdecimal(18,3)
sales_volume_adjustment_qdecimal(18,3)
presentation_beginning_of_period_qdecimal(18,3)
presentation_ending_of_period_qdecimal(18,3)
policy_order_below_qdecimal(18,3)
demand_curve_coverage_qdecimal(18,3)
excluded_item_qdecimal(18,3)
excluded_item_out_of_stock_qdecimal(18,3)
walk_in_purchasability_percentagedecimal(18,3)
walk_in_purchasable_item_locs_trackedvarchar(256)
brand_idvarchar(256)
brand_namevarchar(1024)
source_fileThe delivered file this row came from.varchar(256)The delivered file this row came from.
loaded_atWhen the file was loaded.timestampWhen the file was loaded.
_sliceThe slice a delivered file replaces (date, file or "all").varchar(256)The slice a delivered file replaces (date, file or "all").
_row_idPrimary key.varchar(32)PK Primary key.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
weekly_inventory61 columns · Inventoryshow in diagram

Primary key: _row_id

ColumnTypeKeyDescription
business_ddate
primary_vendor_idvarchar(256)
tcinReferences item_master.tcin.varchar(256)FKReferences item_master.tcin.
department_idvarchar(256)
class_idvarchar(256)
item_idvarchar(256)
dpcivarchar(256)
manufacturer_stylevarchar(256)
item_descriptionvarchar(1024)
location_idReferences location_attributes.location_number.varchar(256)FKReferences location_attributes.location_number.
beginning_on_hand_adecimal(18,3)
beginning_on_hand_qdecimal(18,3)
ending_on_hand_adecimal(18,3)
ending_on_hand_qdecimal(18,3)
beginning_on_transfer_adecimal(18,3)
beginning_on_transfer_qdecimal(18,3)
ending_on_transfer_adecimal(18,3)
ending_on_transfer_qdecimal(18,3)
beginning_on_purchase_adecimal(18,3)
beginning_on_purchase_qdecimal(18,3)
ending_on_purchase_adecimal(18,3)
ending_on_purchase_qdecimal(18,3)
instock_qdecimal(18,3)
instock_percentagedecimal(18,3)
out_of_stock_qdecimal(18,3)
out_of_stock_percentagedecimal(18,3)
non_pog_instock_qdecimal(18,3)
non_pog_instock_percentagedecimal(18,3)
non_pog_out_of_stock_qdecimal(18,3)
non_pog_out_of_stock_percentagedecimal(18,3)
pog_instock_qdecimal(18,3)
pog_instock_percentagedecimal(18,3)
pog_out_of_stock_qdecimal(18,3)
pog_out_of_stock_percentagedecimal(18,3)
tracked_item_qdecimal(18,3)
non_pog_tracked_item_qdecimal(18,3)
pog_tracked_item_qdecimal(18,3)
ship_exclusion_item_location_qdecimal(18,3)
ship_exclusion_out_of_stock_item_location_qdecimal(18,3)
ship_out_of_stock_item_location_qdecimal(18,3)
ship_tracked_item_location_qdecimal(18,3)
tracked_item_out_of_stock_qdecimal(18,3)
final_presentation_minimum_adecimal(18,3)
final_presentation_minimum_qdecimal(18,3)
sales_volume_adjustment_qdecimal(18,3)
item_locations_base_countdecimal(18,3)
presentation_beginning_of_period_qdecimal(18,3)
presentation_ending_of_period_qdecimal(18,3)
policy_order_below_qdecimal(18,3)
demand_curve_coverage_qdecimal(18,3)
excluded_item_qdecimal(18,3)
excluded_item_out_of_stock_qdecimal(18,3)
walk_in_purchasability_percentagedecimal(18,3)
walk_in_purchasable_item_locs_trackedvarchar(256)
brand_idvarchar(256)
brand_namevarchar(1024)
source_fileThe delivered file this row came from.varchar(256)The delivered file this row came from.
loaded_atWhen the file was loaded.timestampWhen the file was loaded.
_sliceThe slice a delivered file replaces (date, file or "all").varchar(256)The slice a delivered file replaces (date, file or "all").
_row_idPrimary key.varchar(32)PK Primary key.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
daily_orders52 columns · Orders & planningshow in diagram

Primary key: key_id

ColumnTypeKeyDescription
snapshot_ddate
purchase_order_create_ddate
purchase_order_idvarchar(256)
purchase_order_active_fvarchar(256)
import_order_fvarchar(256)
vendor_idvarchar(256)
upcvarchar(256)
tcinReferences item_master.tcin.varchar(256)FKReferences item_master.tcin.
department_idvarchar(256)
class_idvarchar(256)
item_idvarchar(256)
dpcivarchar(256)
vendor_style_idvarchar(256)
product_descriptionvarchar(1024)
receiving_location_idvarchar(256)
receiving_location_type_cvarchar(256)
original_order_qdecimal(18,3)
revised_order_qdecimal(18,3)
cancel_remaining_order_qdecimal(18,3)
vendor_casepack_qdecimal(18,3)
store_shippack_qdecimal(18,3)
item_assortment_fvarchar(256)
item_change_ddate
original_ship_begin_ddate
original_ship_end_ddate
revised_ship_begin_ddate
revised_ship_end_ddate
original_estimated_arrival_ddate
revised_estimated_arrival_ddate
imports_in_store_ddate
receipt_ddate
item_received_total_cost_adecimal(18,3)
item_received_total_retail_adecimal(18,3)
item_received_qdecimal(18,3)
purchase_order_cancel_ddate
purchase_order_canceled_fvarchar(256)
early_ship_daily_received_qdecimal(18,3)
on_order_1_week_out_qdecimal(18,3)
on_order_2_week_out_qdecimal(18,3)
on_order_3_week_out_qdecimal(18,3)
on_order_4_8_week_out_qdecimal(18,3)
on_order_9_week_out_qdecimal(18,3)
carry_over_original_eta_qdecimal(18,3)
carry_over_revised_eta_qdecimal(18,3)
brand_idvarchar(256)
brand_nvarchar(1024)
key_idPrimary key.varchar(256)PK Primary key.
source_fileThe delivered file this row came from.varchar(256)The delivered file this row came from.
loaded_atWhen the file was loaded.timestampWhen the file was loaded.
_sliceThe slice a delivered file replaces (date, file or "all").varchar(256)The slice a delivered file replaces (date, file or "all").
_row_idRow hash: md5(file | row number).varchar(32)Row hash: md5(file | row number).
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
item_loc_forecast_weekly16 columns · Orders & planningshow in diagram

Primary key: _row_id

ColumnTypeKeyDescription
last_update_ddate
tcinReferences item_master.tcin.varchar(256)FKReferences item_master.tcin.
department_idvarchar(256)
class_idvarchar(256)
dpcivarchar(256)
location_idReferences location_attributes.location_number.varchar(256)FKReferences location_attributes.location_number.
selected_forecast_qdecimal(18,3)
vendor_idvarchar(256)
fiscal_week_begin_ddate
brand_nvarchar(1024)
brand_idvarchar(256)
source_fileThe delivered file this row came from.varchar(256)The delivered file this row came from.
loaded_atWhen the file was loaded.timestampWhen the file was loaded.
_sliceThe slice a delivered file replaces (date, file or "all").varchar(256)The slice a delivered file replaces (date, file or "all").
_row_idPrimary key.varchar(32)PK Primary key.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
po_planning_item_dc27 columns · Orders & planningshow in diagram

Primary key: _row_id

ColumnTypeKeyDescription
business_ddate
vendor_idvarchar(256)
vendor_order_point_idvarchar(256)
department_idvarchar(256)
dpcivarchar(256)
tcinReferences item_master.tcin.varchar(256)FKReferences item_master.tcin.
barcode_numbervarchar(256)
order_ddate
receiving_location_idvarchar(256)
unit_of_measure_qdecimal(18,3)
unit_of_measure_typevarchar(256)
vendor_case_pack_qdecimal(18,3)
net_store_mean_demand_qdecimal(18,3)
ordered_qdecimal(18,3)
received_qdecimal(18,3)
scheduled_receipt_qdecimal(18,3)
beginning_salesfloor_presentation_unit_qdecimal(18,3)
ending_salesfloor_presentation_unit_qdecimal(18,3)
total_order_cost_adecimal(18,3)
product_cost_adecimal(18,3)
initial_store_inventory_qdecimal(18,3)
purchasing_lead_time_qdecimal(18,3)
source_fileThe delivered file this row came from.varchar(256)The delivered file this row came from.
loaded_atWhen the file was loaded.timestampWhen the file was loaded.
_sliceThe slice a delivered file replaces (date, file or "all").varchar(256)The slice a delivered file replaces (date, file or "all").
_row_idPrimary key.varchar(32)PK Primary key.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
po_plan_daily_tcin23 columns · Orders & planningshow in diagram

Primary key: _row_id

ColumnTypeKeyDescription
business_ddate
vendor_idvarchar(256)
vendor_order_point_idvarchar(256)
department_idvarchar(256)
dpcivarchar(256)
tcinReferences item_master.tcin.varchar(256)FKReferences item_master.tcin.
barcode_numbervarchar(256)
order_ddate
receiving_location_idvarchar(256)
unit_of_measure_qdecimal(18,3)
unit_of_measure_typevarchar(256)
vendor_case_pack_qdecimal(18,3)
net_store_mean_demand_qdecimal(18,3)
ordered_qdecimal(18,3)
received_qdecimal(18,3)
scheduled_receipt_qdecimal(18,3)
beginning_salesfloor_presentation_unit_qdecimal(18,3)
ending_salesfloor_presentation_unit_qdecimal(18,3)
source_fileThe delivered file this row came from.varchar(256)The delivered file this row came from.
loaded_atWhen the file was loaded.timestampWhen the file was loaded.
_sliceThe slice a delivered file replaces (date, file or "all").varchar(256)The slice a delivered file replaces (date, file or "all").
_row_idPrimary key.varchar(32)PK Primary key.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
weekly_gross_margin46 columns · Marginshow in diagram

Primary key: _row_id

ColumnTypeKeyDescription
fiscal_week_end_ddate
vendor_idvarchar(256)
tcinReferences item_master.tcin.varchar(256)FKReferences item_master.tcin.
department_idvarchar(256)
class_idvarchar(256)
item_idvarchar(256)
dpcivarchar(256)
channel_originatedvarchar(256)
location_id_originatedvarchar(256)
location_idReferences location_attributes.location_number.varchar(256)FKReferences location_attributes.location_number.
channel_fulfilledvarchar(256)
fulfillment_typevarchar(256)
fulfillment_subtypevarchar(256)
freight_adecimal(18,3)
vendor_income_adecimal(18,3)
net_sales_adecimal(18,3)
net_sales_qdecimal(18,3)
clearance_a_markdown_adecimal(18,3)
unsaleable_b_markdown_adecimal(18,3)
unsaleable_b_markdown_qdecimal(18,3)
competitor_c_markdown_adecimal(18,3)
promotion_d_markdown_adecimal(18,3)
employee_discount_adecimal(18,3)
ytd_adjusted_gross_margin_adecimal(18,3)
misc_other_cost_of_salesdecimal(18,3)
adjusted_gross_margin_adecimal(18,3)
ship_revenue_adecimal(18,3)
net_ship_expense_adecimal(18,3)
free_ship_discount_adecimal(18,3)
net_ship_margin_adecimal(18,3)
beg_inventory_retail_adecimal(18,3)
beg_inventory_cost_adecimal(18,3)
ending_inventory_retail_adecimal(18,3)
ending_inventory_cost_adecimal(18,3)
cumulative_inventory_retail_adecimal(18,3)
cumulative_inventory_cost_adecimal(18,3)
return_ship_expense_adecimal(18,3)
adjusted_gross_margin_with_net_ship_margin_adecimal(18,3)
roundel_ad_revenue_adecimal(18,3)
brand_idvarchar(256)
brand_namevarchar(1024)
source_fileThe delivered file this row came from.varchar(256)The delivered file this row came from.
loaded_atWhen the file was loaded.timestampWhen the file was loaded.
_sliceThe slice a delivered file replaces (date, file or "all").varchar(256)The slice a delivered file replaces (date, file or "all").
_row_idPrimary key.varchar(32)PK Primary key.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
item_master52 columns · Items & storesshow in diagram

Primary key: tcin

ColumnTypeKeyDescription
upcvarchar(256)
tcinPrimary key. Target item number (TCIN). One row per item in the latest item feed.varchar(256)PK Primary key. Target item number (TCIN). One row per item in the latest item feed.
dpcivarchar(256)
item_statevarchar(256)
descriptionvarchar(1024)
model_numbervarchar(256)
vendor_idvarchar(256)
vendor_namevarchar(1024)
brand_namevarchar(1024)
brand_typevarchar(256)
mdse_categoryvarchar(256)
group_novarchar(256)
group_descriptionvarchar(1024)
div_novarchar(256)
division_descriptionvarchar(1024)
dept_novarchar(256)
dept_descriptionvarchar(1024)
class_novarchar(256)
class_descriptionvarchar(1024)
subclass_idvarchar(256)
subclass_descriptionvarchar(1024)
item_type_namevarchar(1024)
color_shadevarchar(256)
gendervarchar(256)
sizevarchar(256)
package_qtydecimal(18,3)
package_heightvarchar(256)
package_widthvarchar(256)
package_depthvarchar(256)
package_weightvarchar(256)
weight_uomvarchar(256)
net_content_quantity_codevarchar(256)
net_content_quantity_valuevarchar(256)
unit_of_measurevarchar(256)
import_designationvarchar(256)
launch_datetimestamp
last_update_datetimestamp
business_partner_namevarchar(1024)
return_methodvarchar(256)
parent_tcinvarchar(256)
is_flammable_flagvarchar(256)
product_type_namevarchar(256)
product_sub_type_namevarchar(256)
item_type_category_typevarchar(256)
style_codevarchar(256)
style_namevarchar(1024)
brand_idvarchar(256)
source_fileThe delivered file this row came from.varchar(256)The delivered file this row came from.
loaded_atWhen the file was loaded.timestampWhen the file was loaded.
_sliceThe slice a delivered file replaces (date, file or "all").varchar(256)The slice a delivered file replaces (date, file or "all").
_row_idRow hash: md5(file | row number).varchar(32)Row hash: md5(file | row number).
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
item_mta23 columns · Items & storesshow in diagram

Primary key: _row_id

ColumnTypeKeyDescription
processed_ct_datedate
launch_utc_datedate
dpcivarchar(256)
department_idvarchar(256)
class_idvarchar(256)
tcinReferences item_master.tcin.varchar(256)FKReferences item_master.tcin.
item_statevarchar(256)
mta_idvarchar(256)
mta_nvarchar(256)
mta_value_idvarchar(256)
mta_value_nvarchar(1024)
mta_value_uomvarchar(256)
intended_selling_channels_arrvarchar(1024)
estore_item_status_nvarchar(256)
primary_vendor_idvarchar(256)
vendor_nvarchar(256)
brand_idvarchar(256)
brand_nvarchar(1024)
source_fileThe delivered file this row came from.varchar(256)The delivered file this row came from.
loaded_atWhen the file was loaded.timestampWhen the file was loaded.
_sliceThe slice a delivered file replaces (date, file or "all").varchar(256)The slice a delivered file replaces (date, file or "all").
_row_idPrimary key.varchar(32)PK Primary key.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
location_attributes33 columns · Items & storesshow in diagram

Primary key: location_number

ColumnTypeKeyDescription
location_typevarchar(256)
location_subtypevarchar(256)
location_numberPrimary key. Target location (store) number, matching location_id in the sales and inventory feeds.varchar(256)PK Primary key. Target location (store) number, matching location_id in the sales and inventory feeds.
location_namevarchar(1024)
address_1varchar(1024)
address_2varchar(1024)
cityvarchar(256)
statevarchar(256)
zip_codevarchar(256)
servicing_rdcvarchar(256)
servicing_fdcvarchar(256)
regionvarchar(256)
districtvarchar(256)
group_idvarchar(256)
store_formatvarchar(256)
last_remodel_datedate
next_remodel_datedate
store_sizevarchar(256)
latitudedecimal(18,6)
longitudedecimal(18,6)
store_open_datedate
store_close_datedate
store_statusvarchar(256)
optical_in_storevarchar(256)
pharmacy_in_storevarchar(256)
is_mature_store_fvarchar(256)
fresh_grocery_available_fvarchar(256)
mature_store_begin_datedate
source_fileThe delivered file this row came from.varchar(256)The delivered file this row came from.
loaded_atWhen the file was loaded.timestampWhen the file was loaded.
_sliceThe slice a delivered file replaces (date, file or "all").varchar(256)The slice a delivered file replaces (date, file or "all").
_row_idRow hash: md5(file | row number).varchar(32)Row hash: md5(file | row number).
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
history_sales_weekly47 columns · History backfillshow in diagram

Primary key: _row_id

ColumnTypeKeyDescription
sales_datedate
vendor_idvarchar(256)
barcodevarchar(256)
tcinReferences item_master.tcin.varchar(256)FKReferences item_master.tcin.
dpcivarchar(256)
manufacturer_stylevarchar(256)
deptvarchar(256)
classvarchar(256)
item_descriptionvarchar(1024)
origination_channelvarchar(256)
reporting_channelvarchar(256)
fulfillment_typevarchar(256)
drive_up_sale_adecimal(18,3)
drive_up_sale_qdecimal(18,3)
location_idReferences location_attributes.location_number.varchar(256)FKReferences location_attributes.location_number.
sale_amountdecimal(18,3)
sale_quantitydecimal(18,3)
circular_sale_amountdecimal(18,3)
circular_sale_quantitydecimal(18,3)
clearance_sale_amountdecimal(18,3)
clearance_sale_quantitydecimal(18,3)
promo_sale_amountdecimal(18,3)
promo_sale_quantitydecimal(18,3)
regular_sale_amountdecimal(18,3)
regular_sale_quantitydecimal(18,3)
circle_sale_amountdecimal(18,3)
circle_sale_quantitydecimal(18,3)
mature_sale_amountdecimal(18,3)
mature_sale_quantitydecimal(18,3)
comparable_sale_amountdecimal(18,3)
comparable_sale_quantitydecimal(18,3)
ad_comparable_sale_amountdecimal(18,3)
ad_comparable_sale_quantitydecimal(18,3)
return_guest_amountdecimal(18,3)
return_guest_quantitydecimal(18,3)
original_location_idvarchar(256)
original_reporting_channelvarchar(256)
original_origination_channelvarchar(256)
shipt_app_sale_adecimal(18,3)
shipt_app_sale_qdecimal(18,3)
shipt_target_sale_adecimal(18,3)
shipt_target_sale_qdecimal(18,3)
source_fileThe delivered file this row came from.varchar(256)The delivered file this row came from.
loaded_atWhen the file was loaded.timestampWhen the file was loaded.
_sliceThe slice a delivered file replaces (date, file or "all").varchar(256)The slice a delivered file replaces (date, file or "all").
_row_idPrimary key.varchar(32)PK Primary key.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
history_gm_weekly44 columns · History backfillshow in diagram

Primary key: _row_id

ColumnTypeKeyDescription
fiscal_week_end_datedate
vendor_idvarchar(256)
tcinReferences item_master.tcin.varchar(256)FKReferences item_master.tcin.
department_idvarchar(256)
class_idvarchar(256)
item_idvarchar(256)
dpcivarchar(256)
channel_originatedvarchar(256)
location_id_originatedvarchar(256)
location_idReferences location_attributes.location_number.varchar(256)FKReferences location_attributes.location_number.
channel_fulfilledvarchar(256)
fulfillment_typevarchar(256)
fulfillment_subtypevarchar(256)
freight_adecimal(18,3)
vendor_income_adecimal(18,3)
net_sales_adecimal(18,3)
net_sales_qdecimal(18,3)
clearance_a_markdown_adecimal(18,3)
unsaleable_b_markdown_adecimal(18,3)
unsaleable_b_markdown_qdecimal(18,3)
competitor_c_markdown_adecimal(18,3)
promotion_d_markdown_adecimal(18,3)
employee_discount_adecimal(18,3)
ytd_adjusted_gross_margin_adecimal(18,3)
misc_other_cost_of_salesdecimal(18,3)
adjusted_gross_margin_adecimal(18,3)
ship_revenue_adecimal(18,3)
net_ship_expense_adecimal(18,3)
free_ship_discount_adecimal(18,3)
net_ship_margin_adecimal(18,3)
beg_inventory_retail_adecimal(18,3)
beg_inventory_cost_adecimal(18,3)
ending_inventory_retail_adecimal(18,3)
ending_inventory_cost_adecimal(18,3)
cumulative_inventory_retail_adecimal(18,3)
cumulative_inventory_cost_adecimal(18,3)
return_ship_expense_adecimal(18,3)
adjusted_gross_margin_with_net_ship_margin_adecimal(18,3)
roundel_ad_revenue_adecimal(18,3)
source_fileThe delivered file this row came from.varchar(256)The delivered file this row came from.
loaded_atWhen the file was loaded.timestampWhen the file was loaded.
_sliceThe slice a delivered file replaces (date, file or "all").varchar(256)The slice a delivered file replaces (date, file or "all").
_row_idPrimary key.varchar(32)PK Primary key.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
history_inv_weekly58 columns · History backfillshow in diagram

Primary key: _row_id

ColumnTypeKeyDescription
week_end_ddate
primary_vendor_idvarchar(256)
tcinReferences item_master.tcin.varchar(256)FKReferences item_master.tcin.
department_idvarchar(256)
class_idvarchar(256)
item_idvarchar(256)
dpcivarchar(256)
manufacturer_stylevarchar(256)
item_descriptionvarchar(1024)
location_idReferences location_attributes.location_number.varchar(256)FKReferences location_attributes.location_number.
beginning_on_hand_adecimal(18,3)
beginning_on_hand_qdecimal(18,3)
ending_on_hand_adecimal(18,3)
ending_on_hand_qdecimal(18,3)
beginning_on_transfer_adecimal(18,3)
beginning_on_transfer_qdecimal(18,3)
ending_on_transfer_adecimal(18,3)
ending_on_transfer_qdecimal(18,3)
beginning_on_purchase_adecimal(18,3)
beginning_on_purchase_qdecimal(18,3)
ending_on_purchase_adecimal(18,3)
ending_on_purchase_qdecimal(18,3)
instock_qdecimal(18,3)
instock_percentagedecimal(18,3)
out_of_stock_qdecimal(18,3)
out_of_stock_percentagedecimal(18,3)
non_pog_instock_qdecimal(18,3)
non_pog_instock_percentagedecimal(18,3)
non_pog_out_of_stock_qdecimal(18,3)
non_pog_out_of_stock_percentagedecimal(18,3)
pog_instock_qdecimal(18,3)
pog_instock_percentagedecimal(18,3)
pog_out_of_stock_qdecimal(18,3)
pog_out_of_stock_percentagedecimal(18,3)
tracked_item_qdecimal(18,3)
non_pog_tracked_item_qdecimal(18,3)
pog_tracked_item_qdecimal(18,3)
ship_exclusion_item_location_qdecimal(18,3)
ship_exclusion_out_of_stock_item_location_qdecimal(18,3)
ship_out_of_stock_item_location_qdecimal(18,3)
ship_tracked_item_location_qdecimal(18,3)
tracked_item_out_of_stock_qdecimal(18,3)
final_presentation_minimum_adecimal(18,3)
final_presentation_minimum_qdecimal(18,3)
sales_volume_adjustment_qdecimal(18,3)
presentation_beginning_of_period_qdecimal(18,3)
presentation_ending_of_period_qdecimal(18,3)
policy_order_below_qdecimal(18,3)
demand_curve_coverage_qdecimal(18,3)
excluded_item_qdecimal(18,3)
excluded_item_out_of_stock_qdecimal(18,3)
walk_in_purchasability_percentagedecimal(18,3)
walk_in_purchasable_item_locs_trackedvarchar(256)
source_fileThe delivered file this row came from.varchar(256)The delivered file this row came from.
loaded_atWhen the file was loaded.timestampWhen the file was loaded.
_sliceThe slice a delivered file replaces (date, file or "all").varchar(256)The slice a delivered file replaces (date, file or "all").
_row_idPrimary key.varchar(32)PK Primary key.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
files_loaded9 columns · Sync logshow in diagram

One row per Target file seen (loaded, unmapped feed, or skipped BV_ twin of a BR_ feed).

Primary key: file_id

ColumnTypeKeyDescription
file_idPrimary key.varchar(64)PK Primary key.
namevarchar(256)
modifiedtimestamp
size_bytesbigint
feed_tablevarchar(64)
statusvarchar(32)
rows_loadedbigint
loaded_atWhen the file was loaded.timestampWhen the file was loaded.
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.

Connect Target All connectors