ACCOUNT
The Account table represents the contractual relationship between a customer and one or more quantities delivered at one or more service points. An account is referred to by its account number or ID. Most billing systems use account numbers as the primary mechanism to track loads and revenues.
|
Column name |
Column data type |
Character length |
Description |
|---|---|---|---|
|
ACCOUNTID |
VARCHAR2 |
400 |
A unique identifier for the account; an externally used value |
|
ACCOUNTKEY |
RAW |
16 |
A unique primary key for the entity, an internal value |
|
ACCOUNTNUMBER |
VARCHAR2 |
400 |
The number used in the billing system to represent the account; usually the same as account ID, but may not be unique if two billing systems have accounts with the same number |
|
ACCOUNTPROGRAMKEY |
RAW |
16 |
Foreign key to the AccountProgram table from which the Account row was derived |
|
ACCOUNTTYPEKEY |
RAW |
16 |
Can be used to distinguish generation, transmission, and so on |
|
APPLICATIONCODEKEY |
RAW |
16 |
A unique, customer-defined identifier for the application code |
|
DESCRIPTION |
VARCHAR2 |
400 |
A text description for this entity |
|
EFFECTIVEENDDATE |
TIMESTAMP(0) |
7 |
The end date after which this entity is no longer effective |
|
EFFECTIVESTARTDATE |
TIMESTAMP(0) |
7 |
The start date from which this entity is effective |
|
ENTITYSTATUSKEY |
RAW |
16 |
A primary key for the entity, an internal value |
|
ISTEMPLATE |
NUMBER |
22 |
Used by configuration to differentiate physical objects from configuration template objects |
|
LASTUPDATEDATE |
TIMESTAMP(3) |
11 |
The date this entity was last updated |
|
NAICSCODE |
VARCHAR2 |
400 |
The coding system that replaces the SIC system for classifying industries using the North American Industry Classification System |
|
NODEKEY |
RAW |
16 |
A unique key for an object within the IEE database; used internally for linking objects together |
|
REVENUECLASSKEY |
RAW |
16 |
The identifier for the revenue class: residential, commercial, and so on |
|
SICCODE |
VARCHAR2 |
400 |
A |
|
STRATUM |
VARCHAR2 |
400 |
An optional classification of accounts; often used in load research |
The ACCOUNT table references the following tables:
ACCOUNTPROGRAMKEY -> ACCOUNTPROGRAM(ACCOUNTPROGRAMKEY)
ACCOUNTTYPEKEY -> ACCOUNTTYPECODE(ACCOUNTTYPEKEY)
APPLICATIONCODEKEY -> APPLICATIONCODE(APPLICATIONCODEKEY)
ENTITYSTATUSKEY -> ENTITYSTATUS(ENTITYSTATUSKEY)
NODEKEY -> NODE(NODEKEY)
REVENUECLASSKEY -> REVENUECLASS(REVENUECLASSKEY)
and is referenced by:
BILL(ACCOUNTKEY) -> (ACCOUNTKEY)