Sha256: 88d2a2aba02932ea7d410348a3e1bbe66cb8ee758bbcd8c34163df85f9055768

Contents?: true

Size: 1.09 KB

Versions: 8

Compression:

Stored size: 1.09 KB

Contents

require 'skr/db/migration_helpers'

class CreateSkrPoLines < ActiveRecord::Migration
    def change

        create_skr_table "po_lines" do |t|
            t.skr_reference :purchase_order, null: false, single: true
            t.skr_reference :sku_loc,        null: false, single: true
            t.skr_reference :sku_vendor,     null: false, single: true
            t.string   "part_code",          null: false
            t.string   "sku_code",           null: false
            t.string   "description",        null: false
            t.string   "uom_code",           null: false
            t.integer  "uom_size",           null: false, limit: 2
            t.integer  "position",           null: false, limit: 2
            t.integer  "qty",                null: false, default: 0
            t.integer  "qty_received",       null: false, default: 0
            t.integer  "qty_canceled",       null: false, default: 0
            t.skr_currency  "price",         null: false
            t.boolean  "is_revised",         null: false, default: false
            t.skr_track_modifications
        end

    end
end

Version data entries

8 entries across 8 versions & 1 rubygems

Version Path
stockor-0.5.0 db/migrate/20140327202107_create_skr_po_lines.rb
stockor-0.4.0 db/migrate/20140327202107_create_skr_po_lines.rb
stockor-0.3.0 db/migrate/20140327202107_create_skr_po_lines.rb
stockor-0.2 db/migrate/20140327202107_create_skr_po_lines.rb
stockor-0.1.9 db/migrate/20140327202107_create_skr_po_lines.rb
stockor-0.1.8 db/migrate/20140327202107_create_skr_po_lines.rb
stockor-0.1.7 db/migrate/20140327202107_create_skr_po_lines.rb
stockor-0.1.5 db/migrate/20140327202107_create_skr_po_lines.rb