[DB] customer information

[ranilplus]

Please chek if mising. Customer id:auto generated unique number Customer name:this is also unique Ex Sampath Dehiwala supper Type:coperate/home/ngo/contractor.. Address: City:colombo 1,kandy District:colombo Rating: Number of units.

[AthulaDissanayaka]

In case customer wants to include google map in to this? Are you going to have it as a field? Customer name may not necessarily be unique as it's a text field. Please comment on this.

[ranilplus]

Customer name: i mean unique as you can't add same name for two customer ids Ex you can't have two sampth dehiwala supper, next should be sampath dehiwala metro or dehiwal 2. one customer can have many units,

google map location gose with Ac unit or the item, because some unit installed location different with billing address. eg: sampath bank petta having Atm at patte station, customer address is personal but unit is at office/ some where. also one customer can have many units in different locations.

we have to add contact information: Contact No, FaxNo, Email to this db.

[AthulaDissanayaka]

Yes, thanks I agree. Can you add contact details to the customer db. After that shall I send these fields to the customer for confirmation?

[ranilplus]

Yes sure.

[AthulaDissanayaka]

Please include the following fields to customer db. Not compulsary fields. If the customer is VAT registered then it has to be entered.

1. Customer registration number
2. VAT registration number
3. SVAT number

[ranilplus]

we can use Customer id: as Customer registration number. New field

NBT : charged / paid by idac

[AthulaDissanayaka]

No Ranil this is customer business registration number something like vat registration number. If customer provides it then enter it for future reference.