38 lines
1.5 KiB
Ruby
38 lines
1.5 KiB
Ruby
class CreatePCustomerSheets < ActiveRecord::Migration[6.0]
|
|
def change
|
|
create_table :p_customer_sheets do |t|
|
|
t.references :p_customer, index: true
|
|
t.references :p_customer_site, index: true
|
|
t.string :state
|
|
t.string :comments
|
|
t.references :particular_bill, index: true
|
|
t.references :particular_send, index: true
|
|
t.date :wish_start
|
|
t.date :wish_stop
|
|
t.decimal :a_total_cost_ok, :precision => 14, :scale => 2
|
|
t.decimal :a_ok_total, :precision => 14, :scale => 2
|
|
t.boolean :stock_done, :default => false
|
|
t.integer :p_commercial_id
|
|
t.boolean :imported, :default => false
|
|
t.string :npiece
|
|
t.decimal :a_ok_total_ttc, :precision => 14, :scale => 2
|
|
t.boolean :billed, :default => false
|
|
t.decimal :a_total, :precision => 14, :scale => 2
|
|
t.decimal :a_total_ttc, :precision => 14, :scale => 2
|
|
t.boolean :comptant, :default => true
|
|
t.boolean :acompte, :default => false
|
|
t.decimal :acompte_percent, :precision => 14, :scale => 2
|
|
t.integer :payment_delais
|
|
t.boolean :payment_fin_de_mois, :default => false
|
|
t.datetime :paid_start_at
|
|
t.boolean :paid, :default => false
|
|
t.datetime :paid_at
|
|
t.references :p_payment_type, index: true
|
|
t.boolean :i_archive, :default => false
|
|
t.string :cust_ref
|
|
|
|
t.timestamps
|
|
end
|
|
end
|
|
end
|