search

pavithrapurushan / TpMobilePos

1 stars 0 forks source link

Customer IDs an corresponding tables need checking #2

Open pavithrapurushan opened 4 years ago

pavithrapurushan commented 4 years ago

Cust ID of customer has three connotations depending on whether they are taken from

  1. Sales Customer
  2. AdHoc Customer
  3. Loyalty Customer

Check if each customer has the corresponding codes. What are the values of cust ID when Customer in question is a Loyalty customer?

Is CustID for Adhoc customer always 0?