Differences between Progression and Macola ES/10 customer schema

×

Customers upgrading from Macola Progression to ES or 10 may be familiar with the fact that Progression stores customer and ship to information in two tables:

  • ARCusFil_sql - Customer data
  • ARAltAdr_sql - Ship to data

To get a simple customer and ship to address list you would query like this:

select c.cus_no,c.cus_name,s.cus_alt_adr_cd,s.cus_name
from ARCusFil_sql c
left join ARAltAdr_sql s on s.cus_no=c.cus_no
where c.cus_no='000000000100'


The ES/10 customer schema is a bit more complicated and is stored in three tables:

  • cicmpy - Customer data
  • Addresses - Address data
  • cicntp - Contact data

To get a simple customer and ship to address list you would query like this:

select top 10 customer.cmp_code,customer.debcode,customer.cmp_name
,Addresses.Type,Addresses.KeepSameAsVisit,Addresses.Main
,contact.FullName
from cicmpy customer
left join Addresses on Addresses.Account=customer.cmp_wwn
left join cicntp contact on contact.cmp_wwn=customer.cmp_wwn and contact.cnt_id=Addresses.ContactPerson
where debcode='                 100'