Contents

require 'skr/db/migration_helpers'

class CreateSkrPtLines < ActiveRecord::Migration
    def change

        create_skr_table "pt_lines" do |t|
            t.skr_reference :pick_ticket, single: true
            t.skr_reference :so_line,     single: true
            t.skr_reference :sku_loc,     single: true
            t.skr_currency  "price",      null: false
            t.string   "sku_code",        null: false
            t.string   "description",     null: false
            t.string   "uom_code",        null: false
            t.string   "bin",             null: true
            t.integer  "uom_size",        null: false, limit: 2
            t.integer  "position",        null: false, limit: 2
            t.decimal  "qty",             null: false, precision: 15, scale: 2
            t.integer  "qty_invoiced",    null: false, default: 0, precision: 15, scale: 2
            t.boolean  "is_complete",     null: false, default: false
        end

    end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
stockor-0.5.0	db/migrate/20140327202209_create_skr_pt_lines.rb
stockor-0.4.0	db/migrate/20140327202209_create_skr_pt_lines.rb
stockor-0.3.0	db/migrate/20140327202209_create_skr_pt_lines.rb
stockor-0.2	db/migrate/20140327202209_create_skr_pt_lines.rb