Sha256: 9e629a79640f2dd78a290f75da58673e0d1011bf25af647c2eb4b760bf5c5641

Contents?: true

Size: 1.92 KB

Versions: 3

Compression:

Stored size: 1.92 KB

Contents

Sequel.migration do
  change do
    create_table :reg_c170 do
      column :id, :Bignum, primary_key: true
      column :id_pai, :Bignum, index: true, null: false
      column :num_item, String, size: 3
      column :cod_item, String, size: 60
      column :descr_compl, String, size: 1000
      column :qtd, BigDecimal, size: [18, 5]
      column :unid, String, size: 6
      column :vl_item, BigDecimal, size: [18, 2]
      column :vl_desc, BigDecimal, size: [18, 2]
      column :ind_mov, String, size: 1
      column :cst_icms, String, size: 3
      column :cfop, String, size: 4
      column :cod_nat, String, size: 10
      column :vl_bc_icms, BigDecimal, size: [18, 2]
      column :aliq_icms, BigDecimal, size: [18, 2]
      column :vl_icms, BigDecimal, size: [18, 2]
      column :vl_bc_icms_st, BigDecimal, size: [18, 2]
      column :aliq_st, BigDecimal, size: [18, 2]
      column :vl_icms_st, BigDecimal, size: [18, 2]
      column :ind_apur, String, size: 1
      column :cst_ipi, String, size: 2
      column :cod_enq, String, size: 3
      column :vl_bc_ipi, BigDecimal, size: [18, 2]
      column :aliq_ipi, BigDecimal, size: [18, 2]
      column :vl_ipi, BigDecimal, size: [18, 2]
      column :cst_pis, String, size: 2
      column :vl_bc_pis, BigDecimal, size: [18, 2]
      column :aliq_pis, BigDecimal, size: [18, 4]
      column :quant_bc_pis, BigDecimal, size: [18, 3]
      column :aliq_pis_quant, BigDecimal, size: [18, 4]
      column :vl_pis, BigDecimal, size: [18, 2]
      column :cst_cofins, String, size: 2
      column :vl_bc_cofins, BigDecimal, size: [18, 2]
      column :aliq_cofins, BigDecimal, size: [18, 4]
      column :quant_bc_cofins, BigDecimal, size: [18, 3]
      column :aliq_cofins_quant, BigDecimal, size: [18, 4]
      column :vl_cofins, BigDecimal, size: [18, 2]
      column :cod_cta, String, size: 255
      column :cnpj_pai, String, size: 14, index: true
    end
  end
end

Version data entries

3 entries across 1 versions & 1 rubygems

Version Path
sped2db-1.2.0 migrations/contrib/v003/050_create_table_reg_c170.rb
sped2db-1.2.0 migrations/contrib/v004/050_create_table_reg_c170.rb
sped2db-1.2.0 migrations/contrib/v005/051_create_table_reg_c170.rb