Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Scripts to be run against the AerosCMC_Classic DB Migrate DB created from Convert CMC AP Data to ERP AP Step.

Run SQL Script '1 - CMC Import - Create Scrub Tables,sql'

Run SQL Script '2 - CMC Import - Voucher Scrub.sql'

Run Pre Requisite Company / Division Conversion Section at top of Script 2.

Run SQL Script '3 - CMC Import - Vouchers Insert.sql'

Run SQL Script '4 - CMC Import - Cancelled Vouchers Insert.sql'

Run SQL Script '5 - CMC Import - Cancelled Vouchers KeyOffs.sql'

Run SQL Script '6 - CMC Import - Payments Scrub.sql'

Run SQL Script '7 - CMC Import - Payments Insert.sql'