Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $table->string('document_no')->index();
- $table->string('order_no')->index()->nullable();
- $table->string('currency_code')->index()->default('SEK');
- $table->string('payment_method')->index()->nullable();
- $table->string('shipment_method')->index()->nullable();
- $table->string('customer_no')->index()->nullable();
- $table->string('customer_name')->index()->nullable();
- $table->string('zip_code')->index()->nullable();
- $table->string('city')->index()->nullable();
- $table->integer('total_sales')->index()->nullable();
- $table->integer('total_cost')->index()->nullable();
- $table->integer('total_profit')->index()->nullable();
- $table->integer('total_margin')->index()->nullable();
- $table->string('included_brands')->nullable()->index();
- $table->string('included_categories')->nullable()->index();
- $table->string('included_skus')->nullable()->index();
- $table->date('date')->index();
- //Lines
- $table->string('sales_channel')->nullable()->index();
- $table->integer('qty')->index()->default(0);
- $table->integer('line_sales_amount')->index();
- $table->integer('line_cost_amount')->index();
- $table->integer('profit')->index();
- $table->integer('margin')->index();
- //Products
- $table->string('parent_sku')->index()->nullable();
- $table->string('main_category')->index()->nullable();
- $table->string('brand')->index()->nullable();
- $table->string('wheel_size')->nullable()->index();
- $table->string('frame_type')->nullable()->index();
- $table->string('edrive_motor')->nullable()->index();
- $table->string('edrive_motor_placement')->nullable()->index();
- $table->string('edrive_brand')->nullable()->index();
- $table->string('travel_front')->nullable()->index();
- $table->string('e_bike')->nullable()->index();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement