blob: cc33c12d3acbf3ce95d3c58cd43ddbf7245a8ff6 [file] [log] [blame]
{ "cs1": { "cs_sold_date_sk": 2415027, "cs_sold_time_sk": 2, "cs_ship_date_sk": 2415027, "cs_bill_customer_sk": 3, "cs_bill_cdemo_sk": 6, "cs_bill_hdemo_sk": 4, "cs_bill_addr_sk": 10, "cs_ship_customer_sk": 8, "cs_ship_cdemo_sk": 5, "cs_ship_hdemo_sk": 2, "cs_ship_addr_sk": 2, "cs_call_center_sk": 1, "cs_catalog_page_sk": 2, "cs_ship_mode_sk": 3, "cs_warehouse_sk": 3, "cs_item_sk": 1, "cs_promo_sk": 10, "cs_order_number": 9, "cs_quantity": 30, "cs_wholesale_cost": 72.82, "cs_list_price": 88.84, "cs_sales_price": 71.07, "cs_ext_discount_amt": 533.1, "cs_ext_sales_price": 2132.1, "cs_ext_wholesale_cost": 2184.6, "cs_ext_list_price": 2665.2, "cs_ext_tax": 21.32, "cs_coupon_amt": 0.0, "cs_ext_ship_cost": 133.2, "cs_net_paid": 2132.1, "cs_net_paid_inc_tax": 2153.42, "cs_net_paid_inc_ship": 2265.3, "cs_net_paid_inc_ship_tax": 2286.62, "cs_net_profit": -52.5 }, "i1": { "i_item_sk": 1, "i_item_id": "AAAAAAAABAAAAAAA", "i_rec_start_date": "1997-10-27", "i_rec_end_date": null, "i_item_desc": "Powers will not get influences. Electoral ports should show low, annual chains. Now young visitors may pose now however final pages. Bitterly right children suit increasing, leading el", "i_current_price": 27.02, "i_wholesale_cost": 23.23, "i_brand_id": 5003002, "i_brand": "exportischolar #2", "i_class_id": 3, "i_class": "pop", "i_category_id": 5, "i_category": "Music", "i_manufact_id": 964, "i_manufact": "ableanti", "i_size": "N/A", "i_formulation": "3663peru009490160959", "i_color": "spring", "i_units": "Tsp", "i_container": "Unknown", "i_manager_id": 6, "i_product_name": "ought" } }
{ "cs1": { "cs_sold_date_sk": 2415027, "cs_sold_time_sk": 4, "cs_ship_date_sk": 2415029, "cs_bill_customer_sk": 3, "cs_bill_cdemo_sk": 2, "cs_bill_hdemo_sk": 5, "cs_bill_addr_sk": 5, "cs_ship_customer_sk": 1, "cs_ship_cdemo_sk": 5, "cs_ship_hdemo_sk": 2, "cs_ship_addr_sk": 3, "cs_call_center_sk": 1, "cs_catalog_page_sk": 4, "cs_ship_mode_sk": 4, "cs_warehouse_sk": 3, "cs_item_sk": 1, "cs_promo_sk": 8, "cs_order_number": 16, "cs_quantity": 38, "cs_wholesale_cost": 26.96, "cs_list_price": 51.22, "cs_sales_price": 35.85, "cs_ext_discount_amt": 584.06, "cs_ext_sales_price": 1362.3, "cs_ext_wholesale_cost": 1024.48, "cs_ext_list_price": 1946.36, "cs_ext_tax": 108.98, "cs_coupon_amt": 0.0, "cs_ext_ship_cost": 642.2, "cs_net_paid": 1362.3, "cs_net_paid_inc_tax": 1471.28, "cs_net_paid_inc_ship": 2004.5, "cs_net_paid_inc_ship_tax": 2113.48, "cs_net_profit": 337.82 }, "i1": { "i_item_sk": 1, "i_item_id": "AAAAAAAABAAAAAAA", "i_rec_start_date": "1997-10-27", "i_rec_end_date": null, "i_item_desc": "Powers will not get influences. Electoral ports should show low, annual chains. Now young visitors may pose now however final pages. Bitterly right children suit increasing, leading el", "i_current_price": 27.02, "i_wholesale_cost": 23.23, "i_brand_id": 5003002, "i_brand": "exportischolar #2", "i_class_id": 3, "i_class": "pop", "i_category_id": 5, "i_category": "Music", "i_manufact_id": 964, "i_manufact": "ableanti", "i_size": "N/A", "i_formulation": "3663peru009490160959", "i_color": "spring", "i_units": "Tsp", "i_container": "Unknown", "i_manager_id": 6, "i_product_name": "ought" } }
{ "cs1": { "cs_sold_date_sk": 2415028, "cs_sold_time_sk": 8, "cs_ship_date_sk": 2415023, "cs_bill_customer_sk": 10, "cs_bill_cdemo_sk": 1, "cs_bill_hdemo_sk": 5, "cs_bill_addr_sk": 6, "cs_ship_customer_sk": 1, "cs_ship_cdemo_sk": 4, "cs_ship_hdemo_sk": 6, "cs_ship_addr_sk": 3, "cs_call_center_sk": 4, "cs_catalog_page_sk": 1, "cs_ship_mode_sk": 1, "cs_warehouse_sk": 2, "cs_item_sk": 2, "cs_promo_sk": 1, "cs_order_number": 4, "cs_quantity": 50, "cs_wholesale_cost": 70.0, "cs_list_price": 205.1, "cs_sales_price": 188.69, "cs_ext_discount_amt": 820.5, "cs_ext_sales_price": 9434.5, "cs_ext_wholesale_cost": 3500.0, "cs_ext_list_price": 10255.0, "cs_ext_tax": 377.38, "cs_coupon_amt": 0.0, "cs_ext_ship_cost": 4307.0, "cs_net_paid": 9434.5, "cs_net_paid_inc_tax": 9811.88, "cs_net_paid_inc_ship": 13741.5, "cs_net_paid_inc_ship_tax": 14118.88, "cs_net_profit": 5934.5 }, "i1": { "i_item_sk": 2, "i_item_id": "AAAAAAAACAAAAAAA", "i_rec_start_date": "1997-10-27", "i_rec_end_date": "2000-10-26", "i_item_desc": "False opportunities would run alone with a views. Early approaches would show inc, european intentions; important, main passages shall know urban, ", "i_current_price": 1.12, "i_wholesale_cost": 0.38, "i_brand_id": 1001001, "i_brand": "amalgamalg #1", "i_class_id": 1, "i_class": "dresses", "i_category_id": 1, "i_category": "Women", "i_manufact_id": 294, "i_manufact": "esen stable", "i_size": "petite", "i_formulation": "516steel060826230906", "i_color": "rosy", "i_units": "Bunch", "i_container": "Unknown", "i_manager_id": 98, "i_product_name": "able" } }
{ "cs1": { "cs_sold_date_sk": 2415034, "cs_sold_time_sk": 5, "cs_ship_date_sk": 2415030, "cs_bill_customer_sk": 9, "cs_bill_cdemo_sk": 2, "cs_bill_hdemo_sk": 3, "cs_bill_addr_sk": 2, "cs_ship_customer_sk": 1, "cs_ship_cdemo_sk": 1, "cs_ship_hdemo_sk": 3, "cs_ship_addr_sk": 10, "cs_call_center_sk": 1, "cs_catalog_page_sk": 2, "cs_ship_mode_sk": 3, "cs_warehouse_sk": 3, "cs_item_sk": 2, "cs_promo_sk": 4, "cs_order_number": 8, "cs_quantity": 100, "cs_wholesale_cost": 49.56, "cs_list_price": 137.77, "cs_sales_price": 5.51, "cs_ext_discount_amt": 13226.0, "cs_ext_sales_price": 551.0, "cs_ext_wholesale_cost": 4956.0, "cs_ext_list_price": 13777.0, "cs_ext_tax": 0.0, "cs_coupon_amt": 0.0, "cs_ext_ship_cost": 3306.0, "cs_net_paid": 551.0, "cs_net_paid_inc_tax": 551.0, "cs_net_paid_inc_ship": 3857.0, "cs_net_paid_inc_ship_tax": 3857.0, "cs_net_profit": -4405.0 }, "cr1": { "cr_returned_date_sk": 2415031, "cr_returned_time_sk": 1, "cr_item_sk": 2, "cr_refunded_customer_sk": 10, "cr_refunded_cdemo_sk": 2, "cr_refunded_hdemo_sk": 3, "cr_refunded_addr_sk": 1, "cr_returning_customer_sk": 2, "cr_returning_cdemo_sk": 2, "cr_returning_hdemo_sk": 3, "cr_returning_addr_sk": 9, "cr_call_center_sk": 3, "cr_catalog_page_sk": 42, "cr_ship_mode_sk": 3, "cr_warehouse_sk": 4, "cr_reason_sk": 3, "cr_order_number": 8, "cr_return_quantity": 9, "cr_return_amount": 29.79, "cr_return_tax": 1.19, "cr_return_amt_inc_tax": 30.98, "cr_fee": 91.16, "cr_return_ship_cost": 59.67, "cr_refunded_cash": 0.0, "cr_reversed_charge": 20.85, "cr_store_credit": 8.94, "cr_net_loss": 152.02 }, "i1": { "i_item_sk": 2, "i_item_id": "AAAAAAAACAAAAAAA", "i_rec_start_date": "1997-10-27", "i_rec_end_date": "2000-10-26", "i_item_desc": "False opportunities would run alone with a views. Early approaches would show inc, european intentions; important, main passages shall know urban, ", "i_current_price": 1.12, "i_wholesale_cost": 0.38, "i_brand_id": 1001001, "i_brand": "amalgamalg #1", "i_class_id": 1, "i_class": "dresses", "i_category_id": 1, "i_category": "Women", "i_manufact_id": 294, "i_manufact": "esen stable", "i_size": "petite", "i_formulation": "516steel060826230906", "i_color": "rosy", "i_units": "Bunch", "i_container": "Unknown", "i_manager_id": 98, "i_product_name": "able" } }
{ "cs1": { "cs_sold_date_sk": 2415028, "cs_sold_time_sk": 6, "cs_ship_date_sk": 2415024, "cs_bill_customer_sk": 2, "cs_bill_cdemo_sk": 5, "cs_bill_hdemo_sk": 5, "cs_bill_addr_sk": 9, "cs_ship_customer_sk": 3, "cs_ship_cdemo_sk": 1, "cs_ship_hdemo_sk": 5, "cs_ship_addr_sk": 6, "cs_call_center_sk": 1, "cs_catalog_page_sk": 2, "cs_ship_mode_sk": 2, "cs_warehouse_sk": 10, "cs_item_sk": 2, "cs_promo_sk": 10, "cs_order_number": 10, "cs_quantity": 40, "cs_wholesale_cost": 94.56, "cs_list_price": 277.06, "cs_sales_price": 2.77, "cs_ext_discount_amt": 10971.6, "cs_ext_sales_price": 110.8, "cs_ext_wholesale_cost": 3782.4, "cs_ext_list_price": 11082.4, "cs_ext_tax": 2.21, "cs_coupon_amt": 0.0, "cs_ext_ship_cost": 664.8, "cs_net_paid": 110.8, "cs_net_paid_inc_tax": 113.01, "cs_net_paid_inc_ship": 775.6, "cs_net_paid_inc_ship_tax": 777.81, "cs_net_profit": -3671.6 }, "i1": { "i_item_sk": 2, "i_item_id": "AAAAAAAACAAAAAAA", "i_rec_start_date": "1997-10-27", "i_rec_end_date": "2000-10-26", "i_item_desc": "False opportunities would run alone with a views. Early approaches would show inc, european intentions; important, main passages shall know urban, ", "i_current_price": 1.12, "i_wholesale_cost": 0.38, "i_brand_id": 1001001, "i_brand": "amalgamalg #1", "i_class_id": 1, "i_class": "dresses", "i_category_id": 1, "i_category": "Women", "i_manufact_id": 294, "i_manufact": "esen stable", "i_size": "petite", "i_formulation": "516steel060826230906", "i_color": "rosy", "i_units": "Bunch", "i_container": "Unknown", "i_manager_id": 98, "i_product_name": "able" } }
{ "cs1": { "cs_sold_date_sk": 2415027, "cs_sold_time_sk": 8, "cs_ship_date_sk": 2415022, "cs_bill_customer_sk": 2, "cs_bill_cdemo_sk": 2, "cs_bill_hdemo_sk": 3, "cs_bill_addr_sk": 8, "cs_ship_customer_sk": 9, "cs_ship_cdemo_sk": 3, "cs_ship_hdemo_sk": 5, "cs_ship_addr_sk": 10, "cs_call_center_sk": 1, "cs_catalog_page_sk": 3, "cs_ship_mode_sk": 1, "cs_warehouse_sk": 3, "cs_item_sk": 2, "cs_promo_sk": 3, "cs_order_number": 12, "cs_quantity": 45, "cs_wholesale_cost": 5.95, "cs_list_price": 12.97, "cs_sales_price": 8.81, "cs_ext_discount_amt": 187.2, "cs_ext_sales_price": 396.45, "cs_ext_wholesale_cost": 267.75, "cs_ext_list_price": 583.65, "cs_ext_tax": 3.96, "cs_coupon_amt": 0.0, "cs_ext_ship_cost": 17.1, "cs_net_paid": 396.45, "cs_net_paid_inc_tax": 400.41, "cs_net_paid_inc_ship": 413.55, "cs_net_paid_inc_ship_tax": 417.51, "cs_net_profit": 128.7 }, "i1": { "i_item_sk": 2, "i_item_id": "AAAAAAAACAAAAAAA", "i_rec_start_date": "1997-10-27", "i_rec_end_date": "2000-10-26", "i_item_desc": "False opportunities would run alone with a views. Early approaches would show inc, european intentions; important, main passages shall know urban, ", "i_current_price": 1.12, "i_wholesale_cost": 0.38, "i_brand_id": 1001001, "i_brand": "amalgamalg #1", "i_class_id": 1, "i_class": "dresses", "i_category_id": 1, "i_category": "Women", "i_manufact_id": 294, "i_manufact": "esen stable", "i_size": "petite", "i_formulation": "516steel060826230906", "i_color": "rosy", "i_units": "Bunch", "i_container": "Unknown", "i_manager_id": 98, "i_product_name": "able" } }
{ "cs1": { "cs_sold_date_sk": 2415031, "cs_sold_time_sk": 8, "cs_ship_date_sk": 2415026, "cs_bill_customer_sk": 10, "cs_bill_cdemo_sk": 2, "cs_bill_hdemo_sk": 2, "cs_bill_addr_sk": 6, "cs_ship_customer_sk": 2, "cs_ship_cdemo_sk": 6, "cs_ship_hdemo_sk": 6, "cs_ship_addr_sk": 3, "cs_call_center_sk": 4, "cs_catalog_page_sk": 1, "cs_ship_mode_sk": 3, "cs_warehouse_sk": 4, "cs_item_sk": 3, "cs_promo_sk": 6, "cs_order_number": 1, "cs_quantity": 47, "cs_wholesale_cost": 27.7, "cs_list_price": 44.32, "cs_sales_price": 42.99, "cs_ext_discount_amt": 62.51, "cs_ext_sales_price": 2020.53, "cs_ext_wholesale_cost": 1301.9, "cs_ext_list_price": 2083.04, "cs_ext_tax": 101.02, "cs_coupon_amt": 0.0, "cs_ext_ship_cost": 1041.52, "cs_net_paid": 2020.53, "cs_net_paid_inc_tax": 2121.55, "cs_net_paid_inc_ship": 3062.05, "cs_net_paid_inc_ship_tax": 3163.07, "cs_net_profit": 718.63 }, "i1": { "i_item_sk": 3, "i_item_id": "AAAAAAAACAAAAAAA", "i_rec_start_date": "2000-10-27", "i_rec_end_date": null, "i_item_desc": "False opportunities would run alone with a views. Early approaches would show inc, european intentions; important, main passages shall know urban, ", "i_current_price": 7.11, "i_wholesale_cost": 0.38, "i_brand_id": 1001001, "i_brand": "brandbrand #4", "i_class_id": 7, "i_class": "decor", "i_category_id": 7, "i_category": "Home", "i_manufact_id": 294, "i_manufact": "esen stable", "i_size": "N/A", "i_formulation": "516steel060826230906", "i_color": "chiffon", "i_units": "Cup", "i_container": "Unknown", "i_manager_id": 1, "i_product_name": "pri" } }
{ "cs1": { "cs_sold_date_sk": 2415026, "cs_sold_time_sk": 7, "cs_ship_date_sk": 2415026, "cs_bill_customer_sk": 8, "cs_bill_cdemo_sk": 2, "cs_bill_hdemo_sk": 2, "cs_bill_addr_sk": 9, "cs_ship_customer_sk": 8, "cs_ship_cdemo_sk": 4, "cs_ship_hdemo_sk": 6, "cs_ship_addr_sk": 7, "cs_call_center_sk": 4, "cs_catalog_page_sk": 1, "cs_ship_mode_sk": 3, "cs_warehouse_sk": 2, "cs_item_sk": 3, "cs_promo_sk": 10, "cs_order_number": 2, "cs_quantity": 20, "cs_wholesale_cost": 87.55, "cs_list_price": 260.89, "cs_sales_price": 153.92, "cs_ext_discount_amt": 2139.4, "cs_ext_sales_price": 3078.4, "cs_ext_wholesale_cost": 1751.0, "cs_ext_list_price": 5217.8, "cs_ext_tax": 71.41, "cs_coupon_amt": 1292.92, "cs_ext_ship_cost": 1356.6, "cs_net_paid": 1785.48, "cs_net_paid_inc_tax": 1856.89, "cs_net_paid_inc_ship": 3142.08, "cs_net_paid_inc_ship_tax": 3213.49, "cs_net_profit": 34.48 }, "i1": { "i_item_sk": 3, "i_item_id": "AAAAAAAACAAAAAAA", "i_rec_start_date": "2000-10-27", "i_rec_end_date": null, "i_item_desc": "False opportunities would run alone with a views. Early approaches would show inc, european intentions; important, main passages shall know urban, ", "i_current_price": 7.11, "i_wholesale_cost": 0.38, "i_brand_id": 1001001, "i_brand": "brandbrand #4", "i_class_id": 7, "i_class": "decor", "i_category_id": 7, "i_category": "Home", "i_manufact_id": 294, "i_manufact": "esen stable", "i_size": "N/A", "i_formulation": "516steel060826230906", "i_color": "chiffon", "i_units": "Cup", "i_container": "Unknown", "i_manager_id": 1, "i_product_name": "pri" } }
{ "cs1": { "cs_sold_date_sk": 2415031, "cs_sold_time_sk": 2, "cs_ship_date_sk": 2415025, "cs_bill_customer_sk": 5, "cs_bill_cdemo_sk": 1, "cs_bill_hdemo_sk": 3, "cs_bill_addr_sk": 7, "cs_ship_customer_sk": 10, "cs_ship_cdemo_sk": 4, "cs_ship_hdemo_sk": 1, "cs_ship_addr_sk": 4, "cs_call_center_sk": 1, "cs_catalog_page_sk": 5, "cs_ship_mode_sk": 3, "cs_warehouse_sk": 1, "cs_item_sk": 3, "cs_promo_sk": 6, "cs_order_number": 6, "cs_quantity": 88, "cs_wholesale_cost": 20.08, "cs_list_price": 60.03, "cs_sales_price": 20.41, "cs_ext_discount_amt": 3486.56, "cs_ext_sales_price": 1796.08, "cs_ext_wholesale_cost": 1767.04, "cs_ext_list_price": 5282.64, "cs_ext_tax": 13.82, "cs_coupon_amt": 1598.51, "cs_ext_ship_cost": 1056.0, "cs_net_paid": 197.57, "cs_net_paid_inc_tax": 211.39, "cs_net_paid_inc_ship": 1253.57, "cs_net_paid_inc_ship_tax": 1267.39, "cs_net_profit": -1569.47 }, "i1": { "i_item_sk": 3, "i_item_id": "AAAAAAAACAAAAAAA", "i_rec_start_date": "2000-10-27", "i_rec_end_date": null, "i_item_desc": "False opportunities would run alone with a views. Early approaches would show inc, european intentions; important, main passages shall know urban, ", "i_current_price": 7.11, "i_wholesale_cost": 0.38, "i_brand_id": 1001001, "i_brand": "brandbrand #4", "i_class_id": 7, "i_class": "decor", "i_category_id": 7, "i_category": "Home", "i_manufact_id": 294, "i_manufact": "esen stable", "i_size": "N/A", "i_formulation": "516steel060826230906", "i_color": "chiffon", "i_units": "Cup", "i_container": "Unknown", "i_manager_id": 1, "i_product_name": "pri" } }
{ "cs1": { "cs_sold_date_sk": 2415029, "cs_sold_time_sk": 3, "cs_ship_date_sk": 2415028, "cs_bill_customer_sk": 8, "cs_bill_cdemo_sk": 6, "cs_bill_hdemo_sk": 4, "cs_bill_addr_sk": 5, "cs_ship_customer_sk": 4, "cs_ship_cdemo_sk": 4, "cs_ship_hdemo_sk": 6, "cs_ship_addr_sk": 9, "cs_call_center_sk": 1, "cs_catalog_page_sk": 3, "cs_ship_mode_sk": 3, "cs_warehouse_sk": 17, "cs_item_sk": 3, "cs_promo_sk": 2, "cs_order_number": 13, "cs_quantity": 34, "cs_wholesale_cost": 43.69, "cs_list_price": 105.29, "cs_sales_price": 82.12, "cs_ext_discount_amt": 787.78, "cs_ext_sales_price": 2792.08, "cs_ext_wholesale_cost": 1485.46, "cs_ext_list_price": 3579.86, "cs_ext_tax": 55.84, "cs_coupon_amt": 0.0, "cs_ext_ship_cost": 930.58, "cs_net_paid": 2792.08, "cs_net_paid_inc_tax": 2847.92, "cs_net_paid_inc_ship": 3722.66, "cs_net_paid_inc_ship_tax": 3778.5, "cs_net_profit": 1306.62 }, "i1": { "i_item_sk": 3, "i_item_id": "AAAAAAAACAAAAAAA", "i_rec_start_date": "2000-10-27", "i_rec_end_date": null, "i_item_desc": "False opportunities would run alone with a views. Early approaches would show inc, european intentions; important, main passages shall know urban, ", "i_current_price": 7.11, "i_wholesale_cost": 0.38, "i_brand_id": 1001001, "i_brand": "brandbrand #4", "i_class_id": 7, "i_class": "decor", "i_category_id": 7, "i_category": "Home", "i_manufact_id": 294, "i_manufact": "esen stable", "i_size": "N/A", "i_formulation": "516steel060826230906", "i_color": "chiffon", "i_units": "Cup", "i_container": "Unknown", "i_manager_id": 1, "i_product_name": "pri" } }
{ "cs1": { "cs_sold_date_sk": 2415027, "cs_sold_time_sk": 3, "cs_ship_date_sk": 2415029, "cs_bill_customer_sk": 3, "cs_bill_cdemo_sk": 5, "cs_bill_hdemo_sk": 4, "cs_bill_addr_sk": 4, "cs_ship_customer_sk": 1, "cs_ship_cdemo_sk": 2, "cs_ship_hdemo_sk": 4, "cs_ship_addr_sk": 8, "cs_call_center_sk": 4, "cs_catalog_page_sk": 2, "cs_ship_mode_sk": 4, "cs_warehouse_sk": 2, "cs_item_sk": 5, "cs_promo_sk": 3, "cs_order_number": 3, "cs_quantity": 19, "cs_wholesale_cost": 69.86, "cs_list_price": 88.72, "cs_sales_price": 29.27, "cs_ext_discount_amt": 1129.55, "cs_ext_sales_price": 556.13, "cs_ext_wholesale_cost": 1327.34, "cs_ext_list_price": 1685.68, "cs_ext_tax": 33.36, "cs_coupon_amt": 0.0, "cs_ext_ship_cost": 168.53, "cs_net_paid": 556.13, "cs_net_paid_inc_tax": 589.49, "cs_net_paid_inc_ship": 724.66, "cs_net_paid_inc_ship_tax": 758.02, "cs_net_profit": -771.21 }, "cr1": { "cr_returned_date_sk": 2415029, "cr_returned_time_sk": 1, "cr_item_sk": 5, "cr_refunded_customer_sk": 4, "cr_refunded_cdemo_sk": 5, "cr_refunded_hdemo_sk": 1, "cr_refunded_addr_sk": 3, "cr_returning_customer_sk": 3, "cr_returning_cdemo_sk": 3, "cr_returning_hdemo_sk": 1, "cr_returning_addr_sk": 9, "cr_call_center_sk": 2, "cr_catalog_page_sk": 75, "cr_ship_mode_sk": 3, "cr_warehouse_sk": 1, "cr_reason_sk": 5, "cr_order_number": 3, "cr_return_quantity": 44, "cr_return_amount": 2157.76, "cr_return_tax": 43.15, "cr_return_amt_inc_tax": 2200.91, "cr_fee": 46.29, "cr_return_ship_cost": 1280.84, "cr_refunded_cash": 1834.09, "cr_reversed_charge": 51.78, "cr_store_credit": 271.89, "cr_net_loss": 1370.28 }, "i1": { "i_item_sk": 5, "i_item_id": "AAAAAAAAEAAAAAAA", "i_rec_start_date": "1999-10-28", "i_rec_end_date": "2001-10-26", "i_item_desc": "Normal systems would join simply different theories. Full, new clothes may eat instead achievements. D", "i_current_price": 1.3, "i_wholesale_cost": 1.76, "i_brand_id": 2002002, "i_brand": "importoimporto #2", "i_class_id": 2, "i_class": "shirts", "i_category_id": 2, "i_category": "Men", "i_manufact_id": 220, "i_manufact": "barableable", "i_size": "petite", "i_formulation": "42214rosy28066558020", "i_color": "chiffon", "i_units": "Cup", "i_container": "Unknown", "i_manager_id": 27, "i_product_name": "anti" } }
{ "cs1": { "cs_sold_date_sk": 2415025, "cs_sold_time_sk": 8, "cs_ship_date_sk": 2415022, "cs_bill_customer_sk": 2, "cs_bill_cdemo_sk": 4, "cs_bill_hdemo_sk": 3, "cs_bill_addr_sk": 10, "cs_ship_customer_sk": 1, "cs_ship_cdemo_sk": 1, "cs_ship_hdemo_sk": 6, "cs_ship_addr_sk": 1, "cs_call_center_sk": 1, "cs_catalog_page_sk": 5, "cs_ship_mode_sk": 2, "cs_warehouse_sk": 18, "cs_item_sk": 5, "cs_promo_sk": 3, "cs_order_number": 15, "cs_quantity": 94, "cs_wholesale_cost": 41.36, "cs_list_price": 105.88, "cs_sales_price": 530.82, "cs_ext_discount_amt": 5175.64, "cs_ext_sales_price": 4777.08, "cs_ext_wholesale_cost": 3887.84, "cs_ext_list_price": 9952.72, "cs_ext_tax": 191.08, "cs_coupon_amt": 0.0, "cs_ext_ship_cost": 497.26, "cs_net_paid": 4777.08, "cs_net_paid_inc_tax": 4968.16, "cs_net_paid_inc_ship": 5274.34, "cs_net_paid_inc_ship_tax": 5465.42, "cs_net_profit": 889.24 }, "i1": { "i_item_sk": 5, "i_item_id": "AAAAAAAAEAAAAAAA", "i_rec_start_date": "1999-10-28", "i_rec_end_date": "2001-10-26", "i_item_desc": "Normal systems would join simply different theories. Full, new clothes may eat instead achievements. D", "i_current_price": 1.3, "i_wholesale_cost": 1.76, "i_brand_id": 2002002, "i_brand": "importoimporto #2", "i_class_id": 2, "i_class": "shirts", "i_category_id": 2, "i_category": "Men", "i_manufact_id": 220, "i_manufact": "barableable", "i_size": "petite", "i_formulation": "42214rosy28066558020", "i_color": "chiffon", "i_units": "Cup", "i_container": "Unknown", "i_manager_id": 27, "i_product_name": "anti" } }
{ "cs1": { "cs_sold_date_sk": 2415028, "cs_sold_time_sk": 3, "cs_ship_date_sk": 2415031, "cs_bill_customer_sk": 1, "cs_bill_cdemo_sk": 3, "cs_bill_hdemo_sk": 1, "cs_bill_addr_sk": 6, "cs_ship_customer_sk": 10, "cs_ship_cdemo_sk": 4, "cs_ship_hdemo_sk": 1, "cs_ship_addr_sk": 7, "cs_call_center_sk": 1, "cs_catalog_page_sk": 1, "cs_ship_mode_sk": 2, "cs_warehouse_sk": 15, "cs_item_sk": 5, "cs_promo_sk": 10, "cs_order_number": 17, "cs_quantity": 45, "cs_wholesale_cost": 9.54, "cs_list_price": 23.37, "cs_sales_price": 21.5, "cs_ext_discount_amt": 84.15, "cs_ext_sales_price": 967.5, "cs_ext_wholesale_cost": 429.3, "cs_ext_list_price": 1051.65, "cs_ext_tax": 21.76, "cs_coupon_amt": 725.62, "cs_ext_ship_cost": 294.3, "cs_net_paid": 241.88, "cs_net_paid_inc_tax": 263.64, "cs_net_paid_inc_ship": 536.18, "cs_net_paid_inc_ship_tax": 557.94, "cs_net_profit": -187.42 }, "i1": { "i_item_sk": 5, "i_item_id": "AAAAAAAAEAAAAAAA", "i_rec_start_date": "1999-10-28", "i_rec_end_date": "2001-10-26", "i_item_desc": "Normal systems would join simply different theories. Full, new clothes may eat instead achievements. D", "i_current_price": 1.3, "i_wholesale_cost": 1.76, "i_brand_id": 2002002, "i_brand": "importoimporto #2", "i_class_id": 2, "i_class": "shirts", "i_category_id": 2, "i_category": "Men", "i_manufact_id": 220, "i_manufact": "barableable", "i_size": "petite", "i_formulation": "42214rosy28066558020", "i_color": "chiffon", "i_units": "Cup", "i_container": "Unknown", "i_manager_id": 27, "i_product_name": "anti" } }
{ "cs1": { "cs_sold_date_sk": 2415023, "cs_sold_time_sk": 4, "cs_ship_date_sk": 2415022, "cs_bill_customer_sk": 2, "cs_bill_cdemo_sk": 2, "cs_bill_hdemo_sk": 1, "cs_bill_addr_sk": 2, "cs_ship_customer_sk": 2, "cs_ship_cdemo_sk": 5, "cs_ship_hdemo_sk": 1, "cs_ship_addr_sk": 9, "cs_call_center_sk": 1, "cs_catalog_page_sk": 3, "cs_ship_mode_sk": 5, "cs_warehouse_sk": 10, "cs_item_sk": 6, "cs_promo_sk": 9, "cs_order_number": 7, "cs_quantity": 31, "cs_wholesale_cost": 40.88, "cs_list_price": 51.91, "cs_sales_price": 6.22, "cs_ext_discount_amt": 1416.39, "cs_ext_sales_price": 192.82, "cs_ext_wholesale_cost": 1267.28, "cs_ext_list_price": 1609.21, "cs_ext_tax": 11.56, "cs_coupon_amt": 0.0, "cs_ext_ship_cost": 321.78, "cs_net_paid": 192.82, "cs_net_paid_inc_tax": 204.38, "cs_net_paid_inc_ship": 514.6, "cs_net_paid_inc_ship_tax": 526.16, "cs_net_profit": -1074.46 }, "i1": { "i_item_sk": 6, "i_item_id": "AAAAAAAAEAAAAAAA", "i_rec_start_date": "2001-10-27", "i_rec_end_date": null, "i_item_desc": "Normal systems would join simply different theories. Full, new clothes may eat instead achievements. D", "i_current_price": 0.85, "i_wholesale_cost": 1.76, "i_brand_id": 2002002, "i_brand": "exportiimporto #1", "i_class_id": 3, "i_class": "pants", "i_category_id": 2, "i_category": "Men", "i_manufact_id": 212, "i_manufact": "barableable", "i_size": "large", "i_formulation": "42214rosy28066558020", "i_color": "chiffon", "i_units": "Bundle", "i_container": "Unknown", "i_manager_id": 7, "i_product_name": "cally" } }
{ "cs1": { "cs_sold_date_sk": 2415030, "cs_sold_time_sk": 6, "cs_ship_date_sk": 2415025, "cs_bill_customer_sk": 2, "cs_bill_cdemo_sk": 1, "cs_bill_hdemo_sk": 3, "cs_bill_addr_sk": 5, "cs_ship_customer_sk": 3, "cs_ship_cdemo_sk": 1, "cs_ship_hdemo_sk": 4, "cs_ship_addr_sk": 7, "cs_call_center_sk": 1, "cs_catalog_page_sk": 3, "cs_ship_mode_sk": 3, "cs_warehouse_sk": 3, "cs_item_sk": 6, "cs_promo_sk": 9, "cs_order_number": 18, "cs_quantity": 41, "cs_wholesale_cost": 39.04, "cs_list_price": 108.92, "cs_sales_price": 75.15, "cs_ext_discount_amt": 1384.57, "cs_ext_sales_price": 3081.15, "cs_ext_wholesale_cost": 1600.64, "cs_ext_list_price": 4465.72, "cs_ext_tax": 215.68, "cs_coupon_amt": 0.0, "cs_ext_ship_cost": 1964.72, "cs_net_paid": 3081.15, "cs_net_paid_inc_tax": 3296.83, "cs_net_paid_inc_ship": 5045.87, "cs_net_paid_inc_ship_tax": 5261.55, "cs_net_profit": 1480.51 }, "i1": { "i_item_sk": 6, "i_item_id": "AAAAAAAAEAAAAAAA", "i_rec_start_date": "2001-10-27", "i_rec_end_date": null, "i_item_desc": "Normal systems would join simply different theories. Full, new clothes may eat instead achievements. D", "i_current_price": 0.85, "i_wholesale_cost": 1.76, "i_brand_id": 2002002, "i_brand": "exportiimporto #1", "i_class_id": 3, "i_class": "pants", "i_category_id": 2, "i_category": "Men", "i_manufact_id": 212, "i_manufact": "barableable", "i_size": "large", "i_formulation": "42214rosy28066558020", "i_color": "chiffon", "i_units": "Bundle", "i_container": "Unknown", "i_manager_id": 7, "i_product_name": "cally" } }
{ "cs1": { "cs_sold_date_sk": 2415030, "cs_sold_time_sk": 6, "cs_ship_date_sk": 2415025, "cs_bill_customer_sk": 1, "cs_bill_cdemo_sk": 1, "cs_bill_hdemo_sk": 3, "cs_bill_addr_sk": 5, "cs_ship_customer_sk": 3, "cs_ship_cdemo_sk": 1, "cs_ship_hdemo_sk": 4, "cs_ship_addr_sk": 7, "cs_call_center_sk": 1, "cs_catalog_page_sk": 3, "cs_ship_mode_sk": 3, "cs_warehouse_sk": 15, "cs_item_sk": 6, "cs_promo_sk": 9, "cs_order_number": 29, "cs_quantity": 41, "cs_wholesale_cost": 39.04, "cs_list_price": 108.92, "cs_sales_price": 75.15, "cs_ext_discount_amt": 1384.57, "cs_ext_sales_price": 3081.15, "cs_ext_wholesale_cost": 1600.64, "cs_ext_list_price": 4465.72, "cs_ext_tax": 215.68, "cs_coupon_amt": 0.0, "cs_ext_ship_cost": 1964.72, "cs_net_paid": 3081.15, "cs_net_paid_inc_tax": 3296.83, "cs_net_paid_inc_ship": 5045.87, "cs_net_paid_inc_ship_tax": 5261.55, "cs_net_profit": 1480.51 }, "i1": { "i_item_sk": 6, "i_item_id": "AAAAAAAAEAAAAAAA", "i_rec_start_date": "2001-10-27", "i_rec_end_date": null, "i_item_desc": "Normal systems would join simply different theories. Full, new clothes may eat instead achievements. D", "i_current_price": 0.85, "i_wholesale_cost": 1.76, "i_brand_id": 2002002, "i_brand": "exportiimporto #1", "i_class_id": 3, "i_class": "pants", "i_category_id": 2, "i_category": "Men", "i_manufact_id": 212, "i_manufact": "barableable", "i_size": "large", "i_formulation": "42214rosy28066558020", "i_color": "chiffon", "i_units": "Bundle", "i_container": "Unknown", "i_manager_id": 7, "i_product_name": "cally" } }
{ "cs1": { "cs_sold_date_sk": 2415022, "cs_sold_time_sk": 4, "cs_ship_date_sk": 2415022, "cs_bill_customer_sk": 2, "cs_bill_cdemo_sk": 5, "cs_bill_hdemo_sk": 5, "cs_bill_addr_sk": 8, "cs_ship_customer_sk": 2, "cs_ship_cdemo_sk": 4, "cs_ship_hdemo_sk": 3, "cs_ship_addr_sk": 2, "cs_call_center_sk": 1, "cs_catalog_page_sk": 1, "cs_ship_mode_sk": 5, "cs_warehouse_sk": 3, "cs_item_sk": 7, "cs_promo_sk": 5, "cs_order_number": 14, "cs_quantity": 59, "cs_wholesale_cost": 78.9, "cs_list_price": 84.42, "cs_sales_price": 82.73, "cs_ext_discount_amt": 99.71, "cs_ext_sales_price": 4881.07, "cs_ext_wholesale_cost": 4655.1, "cs_ext_list_price": 4980.78, "cs_ext_tax": 292.86, "cs_coupon_amt": 0.0, "cs_ext_ship_cost": 1444.32, "cs_net_paid": 4881.07, "cs_net_paid_inc_tax": 5173.93, "cs_net_paid_inc_ship": 6325.39, "cs_net_paid_inc_ship_tax": 6618.25, "cs_net_profit": 225.97 }, "i1": { "i_item_sk": 7, "i_item_id": "AAAAAAAAHAAAAAAA", "i_rec_start_date": "1997-10-27", "i_rec_end_date": null, "i_item_desc": "Anxious accounts must catch also years. Revolutionary, large directors used to embrace then mo", "i_current_price": 39.94, "i_wholesale_cost": 1.3, "i_brand_id": 3001002, "i_brand": "amalgexporti #2", "i_class_id": 1, "i_class": "newborn", "i_category_id": 3, "i_category": "Children", "i_manufact_id": 129, "i_manufact": "eseoughtable", "i_size": "petite", "i_formulation": "6moccasin24027188872", "i_color": "chiffon", "i_units": "Tsp", "i_container": "Unknown", "i_manager_id": 64, "i_product_name": "ation" } }
{ "cs1": { "cs_sold_date_sk": 2415023, "cs_sold_time_sk": 6, "cs_ship_date_sk": 2415027, "cs_bill_customer_sk": 5, "cs_bill_cdemo_sk": 1, "cs_bill_hdemo_sk": 4, "cs_bill_addr_sk": 8, "cs_ship_customer_sk": 9, "cs_ship_cdemo_sk": 4, "cs_ship_hdemo_sk": 2, "cs_ship_addr_sk": 8, "cs_call_center_sk": 1, "cs_catalog_page_sk": 2, "cs_ship_mode_sk": 3, "cs_warehouse_sk": 3, "cs_item_sk": 10, "cs_promo_sk": 7, "cs_order_number": 5, "cs_quantity": 56, "cs_wholesale_cost": 67.54, "cs_list_price": 166.82, "cs_sales_price": 18.35, "cs_ext_discount_amt": 8314.32, "cs_ext_sales_price": 1027.6, "cs_ext_wholesale_cost": 3782.24, "cs_ext_list_price": 9341.92, "cs_ext_tax": 0.0, "cs_coupon_amt": 0.0, "cs_ext_ship_cost": 3736.32, "cs_net_paid": 1027.6, "cs_net_paid_inc_tax": 1027.6, "cs_net_paid_inc_ship": 4763.92, "cs_net_paid_inc_ship_tax": 4763.92, "cs_net_profit": -2754.64 }, "i1": { "i_item_sk": 10, "i_item_id": "AAAAAAAAKAAAAAAA", "i_rec_start_date": "1997-10-27", "i_rec_end_date": "1999-10-27", "i_item_desc": "Classical services go trousers. However great galleries might say needs. Assumptions change very in favour of the notes. Teeth woul", "i_current_price": 8.94, "i_wholesale_cost": 4.11, "i_brand_id": 10008011, "i_brand": "namelessunivamalg #11", "i_class_id": 8, "i_class": "scanners", "i_category_id": 10, "i_category": "Electronics", "i_manufact_id": 350, "i_manufact": "barantipri", "i_size": "N/A", "i_formulation": "8159007505thistle447", "i_color": "pale", "i_units": "Tsp", "i_container": "Unknown", "i_manager_id": 34, "i_product_name": "barought" } }
{ "cs1": { "cs_sold_date_sk": 2415030, "cs_sold_time_sk": 2, "cs_ship_date_sk": 2415022, "cs_bill_customer_sk": 8, "cs_bill_cdemo_sk": 5, "cs_bill_hdemo_sk": 5, "cs_bill_addr_sk": 3, "cs_ship_customer_sk": 3, "cs_ship_cdemo_sk": 2, "cs_ship_hdemo_sk": 3, "cs_ship_addr_sk": 4, "cs_call_center_sk": 1, "cs_catalog_page_sk": 2, "cs_ship_mode_sk": 1, "cs_warehouse_sk": 16, "cs_item_sk": 10, "cs_promo_sk": 7, "cs_order_number": 11, "cs_quantity": 40, "cs_wholesale_cost": 25.96, "cs_list_price": 54.51, "cs_sales_price": 15.8, "cs_ext_discount_amt": 1548.4, "cs_ext_sales_price": 632.0, "cs_ext_wholesale_cost": 1038.4, "cs_ext_list_price": 2180.4, "cs_ext_tax": 22.75, "cs_coupon_amt": 176.96, "cs_ext_ship_cost": 1090.0, "cs_net_paid": 455.04, "cs_net_paid_inc_tax": 477.79, "cs_net_paid_inc_ship": 1545.04, "cs_net_paid_inc_ship_tax": 1567.79, "cs_net_profit": -583.36 }, "i1": { "i_item_sk": 10, "i_item_id": "AAAAAAAAKAAAAAAA", "i_rec_start_date": "1997-10-27", "i_rec_end_date": "1999-10-27", "i_item_desc": "Classical services go trousers. However great galleries might say needs. Assumptions change very in favour of the notes. Teeth woul", "i_current_price": 8.94, "i_wholesale_cost": 4.11, "i_brand_id": 10008011, "i_brand": "namelessunivamalg #11", "i_class_id": 8, "i_class": "scanners", "i_category_id": 10, "i_category": "Electronics", "i_manufact_id": 350, "i_manufact": "barantipri", "i_size": "N/A", "i_formulation": "8159007505thistle447", "i_color": "pale", "i_units": "Tsp", "i_container": "Unknown", "i_manager_id": 34, "i_product_name": "barought" } }