The number assigned to an employee, customer, vendor or product for identification. Although it may contain only numeric digits, account numbers are often defined and stored as a character field, also known as a "string" or "alphanumeric field," so that parts of the number can be searched independently.
For example, if the first two digits in a customer number were a state code, and the next three were the city code, state and city could be easily searched. Take the case of searching for state code "44" and city code "111" on a 14-digit account number defined as the following three subfields:
Subfield Positions in Field State Code 1-2 City Code 3-5 Customer # 6-14
If the field were defined as characters (a string), the query would be LOOK FOR "44111" IN CHARACTERS 1-5. If the field were defined as a numeric field, the entire number has to be taken into consideration, making it awkward. The query would have to be GREATER THAN 44110999999999 AND LESS THAN 44112000000000. See string.
Download Computer Desktop Encyclopedia to your PC, iPhone or Android.
| Account Executive, Account, Accord and Satisfaction | |
| Account Statement, Accountability, Accountancy |
The primary identifier for ownership of an account, whether a vendor account, a checking or brokerage account, or a loan account. An account number is used whether or not the identifier uses letters or numbers.
Investopedia Says:
At one time, it was common to use a Social Security number as the primary identifier, particularly for employees (for payroll or human-resources identification). Because of the proliferation of identity theft, however, this practice has been all but eradicated. It is not a good idea to use a Social Security number for any type of account, or as a user name or password for electronic identification.
Related Links:
You get multiple managers, affordable diversification, customization and consolidated reporting all under one roof. Introduction To Multi-Discipline Accounts
Follow this sound advice and plan for a comfortable future. 10 Tips For Achieving Financial Security
Don't be a victim of this disturbing crime. Get insight into how perpetrators commit this form of fraud. Identity Theft: How To Avoid It
If your identity is stolen, it's critical to act fast. Find out what to do if it happens. Identity Theft: Who To Call For Help