It is import to learn how these three fields work together.


1. When you choose an account you can right click on that account and click "View Account Form."  When you do this it will pull up the account form with all of your account details. On this form you will see your Account ID (table field name = PIDN) which is located at the very top above the account name. In this case your PIDN is L890646, also the same as "Account ID."


The Account ID must be unique to every record in the system.  


The Customer ID field (table field name = account) contains the customer number ASSIGNED onto this record.  When you assign the customer id on an account, the system will automatically insert the mailing name, address, etc.  You can not simply type the customer id in and expect the customer contact data to appear.  It must be assigned.  A customer id may be assigned onto multiple records so you can easily identify all the records associated with a customer.


The Location ID field (table field name = map) contains the location number ASSIGNED onto this record.  When you assign the location id on an account, the system will automatically insert the physical address.  You can not simply type the location id in and expect the address data to appear.  It must be assigned.  A location id may be assigned onto multiple records so you can easily identify all the records associated with a location.


 If you scroll down on your account form you will see "Location ID Map." 


There are three tables effected by these fields.  The Property table hold every record for each application like taxes, utilities, etc.  In the PROPERTY table the Account ID (PIDN) field is unique.


The Customer_table holds the customer data and it is attached to the Property record by assigning the Customer ID onto the record.


The Location_table holds the location data and it is attached to the Property record by assigning the location ID onto the record.  Many people refer to the location id as the MAP.