118 lines
5.2 KiB
Ruby
118 lines
5.2 KiB
Ruby
class CreatePriceLines < ActiveRecord::Migration[6.0]
|
|
def change
|
|
create_table :price_lines do |t|
|
|
t.boolean :archived
|
|
t.integer :price_line_block_id
|
|
t.integer :position
|
|
t.string :line_type
|
|
t.integer :ac_accounting_zone_id
|
|
t.integer :cc_accounting_zone_id
|
|
t.string :ac_accounting_zone_name
|
|
t.string :cc_accounting_zone_name
|
|
t.integer :ac_tva_account_id
|
|
t.integer :cc_tva_account_id
|
|
t.decimal :ac_tva_account_value, :precision => 5, :scale => 2
|
|
t.decimal :cc_tva_account_value, :precision => 5, :scale => 2
|
|
t.integer :p_product_id
|
|
t.integer :p_product_variante_id
|
|
t.integer :p_product_alt_id
|
|
t.integer :p_product_alt_variante_id
|
|
t.integer :p_product_ref_id
|
|
t.integer :p_product_ref_variante_id
|
|
t.string :ct_ref
|
|
t.string :ac_ref
|
|
t.string :cc_ref
|
|
t.string :ct_title
|
|
t.string :ac_title
|
|
t.string :cc_title
|
|
|
|
t.boolean :ac_product_remise_enrobage_ok
|
|
t.boolean :cc_product_remise_enrobage_ok
|
|
|
|
t.string :ac_uv
|
|
t.string :cc_uv
|
|
|
|
|
|
t.text :ct_description
|
|
t.text :ac_description
|
|
t.text :cc_description
|
|
|
|
|
|
|
|
|
|
t.decimal :ct_u_price_ht, :precision => 14, :scale => 2
|
|
t.decimal :ac_price_u_ht, :precision => 14, :scale => 2
|
|
t.decimal :cc_price_u_ht, :precision => 14, :scale => 2
|
|
t.decimal :ac_price_u_tva, :precision => 14, :scale => 2
|
|
t.decimal :cc_price_u_tva, :precision => 14, :scale => 2
|
|
t.decimal :ac_price_u_ttc, :precision => 14, :scale => 2
|
|
t.decimal :cc_price_u_ttc, :precision => 14, :scale => 2
|
|
t.integer :qte
|
|
t.decimal :ac_tot_line_ht, :precision => 14, :scale => 2
|
|
t.decimal :cc_tot_line_ht, :precision => 14, :scale => 2
|
|
t.decimal :ac_tot_line_tva, :precision => 14, :scale => 2
|
|
t.decimal :cc_tot_line_tva, :precision => 14, :scale => 2
|
|
t.decimal :ac_tot_line_ttc, :precision => 14, :scale => 2
|
|
t.decimal :cc_tot_line_ttc, :precision => 14, :scale => 2
|
|
|
|
|
|
|
|
t.decimal :ac_discount_market_percent, :precision => 14, :scale => 2
|
|
t.decimal :cc_discount_market_percent, :precision => 14, :scale => 2
|
|
t.decimal :ac_discount_market_ht, :precision => 14, :scale => 2
|
|
t.decimal :cc_discount_market_ht, :precision => 14, :scale => 2
|
|
|
|
t.decimal :ac_discount_qte_percent, :precision => 14, :scale => 2
|
|
t.decimal :cc_discount_qte_percent, :precision => 14, :scale => 2
|
|
t.decimal :ac_discount_qte_ht, :precision => 14, :scale => 2
|
|
t.decimal :cc_discount_qte_ht, :precision => 14, :scale => 2
|
|
|
|
t.decimal :ac_discount_delay_percent, :precision => 14, :scale => 2
|
|
t.decimal :cc_discount_delay_percent, :precision => 14, :scale => 2
|
|
t.decimal :ac_discount_delay_ht, :precision => 14, :scale => 2
|
|
t.decimal :cc_discount_delay_ht, :precision => 14, :scale => 2
|
|
|
|
t.decimal :ac_discount_enrobage_percent, :precision => 14, :scale => 2
|
|
t.decimal :cc_discount_enrobage_percent, :precision => 14, :scale => 2
|
|
t.decimal :ac_discount_enrobage_ht, :precision => 14, :scale => 2
|
|
t.decimal :cc_discount_enrobage_ht, :precision => 14, :scale => 2
|
|
|
|
t.decimal :ac_discount_ecole_percent, :precision => 14, :scale => 2
|
|
t.decimal :cc_discount_ecole_percent, :precision => 14, :scale => 2
|
|
t.decimal :ac_discount_ecole_ht, :precision => 14, :scale => 2
|
|
t.decimal :cc_discount_ecole_ht, :precision => 14, :scale => 2
|
|
|
|
t.decimal :ac_discount_comptant_percent, :precision => 14, :scale => 2
|
|
t.decimal :cc_discount_comptant_percent, :precision => 14, :scale => 2
|
|
t.decimal :ac_discount_comptant_ht, :precision => 14, :scale => 2
|
|
t.decimal :cc_discount_comptant_ht, :precision => 14, :scale => 2
|
|
|
|
|
|
|
|
|
|
t.decimal :ac_tot_discount_ht, :precision => 14, :scale => 2
|
|
t.decimal :cc_tot_discount_ht, :precision => 14, :scale => 2
|
|
t.decimal :ac_tot_discount_tva, :precision => 14, :scale => 2
|
|
t.decimal :cc_tot_discount_tva, :precision => 14, :scale => 2
|
|
t.decimal :ac_tot_discount_ttc, :precision => 14, :scale => 2
|
|
t.decimal :cc_tot_discount_ttc, :precision => 14, :scale => 2
|
|
t.decimal :ac_tot_amount_ht, :precision => 14, :scale => 2
|
|
t.decimal :cc_tot_amount_ht, :precision => 14, :scale => 2
|
|
t.decimal :ac_tot_amount_tva, :precision => 14, :scale => 2
|
|
t.decimal :cc_tot_amount_tva, :precision => 14, :scale => 2
|
|
t.decimal :ac_tot_amount_ttc, :precision => 14, :scale => 2
|
|
t.decimal :cc_tot_amount_ttc, :precision => 14, :scale => 2
|
|
t.integer :p_cter_id
|
|
|
|
t.decimal :ct_weight_u, :precision => 14, :scale => 2
|
|
t.decimal :ac_weight_u, :precision => 14, :scale => 2
|
|
t.decimal :cc_weight_u, :precision => 14, :scale => 2
|
|
|
|
t.decimal :ac_weight_tot, :precision => 14, :scale => 2
|
|
t.decimal :cc_weight_tot, :precision => 14, :scale => 2
|
|
|
|
t.timestamps
|
|
end
|
|
end
|
|
end
|