TELEPHONE DETAIL Table
View exposing detailed telephone charge transactions by cost collector, general ledger account, fiscal month, billing number, and charge type including amount, calls, minutes, originating and destination phone information, international-call indicator, call date and time, billing date, and equipment-charge description.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BILLING_DATE |
Date associated with billing. |
DATE |
|
CHARGE_AMOUNT |
Charge amount associated with the record. |
NUMBER |
11,2 |
CHARGE_COUNTER |
Charge counter associated with the record. |
NUMBER |
1 |
CHARGE_TYPE_KEY |
Surrogate key identifying the charge type. |
VARCHAR2 |
15 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
DATE_OF_CALL |
Date of call associated with the record. |
DATE |
|
DESTINATION_PHONE |
Destination phone associated with the record. |
VARCHAR2 |
15 |
EQUIPMENT_CHARGE_DESC |
Description of equipment charge. |
VARCHAR2 |
25 |
FROM_PLACE |
From place associated with the record. |
VARCHAR2 |
30 |
FROM_STATE |
From state associated with the record. |
VARCHAR2 |
2 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
IS_INTERNATIONAL_CALL |
Indicator identifying whether international call (Y/N). |
VARCHAR2 |
1 |
ORIGINATING_PHONE |
Originating phone associated with the record. |
VARCHAR2 |
10 |
PHONE_LOCATION |
Phone location associated with the record. |
VARCHAR2 |
15 |
TELEPHONE_BILLING_KEY |
Telephone billing key associated with the record. |
VARCHAR2 |
60 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
TIME_OF_CALL |
Time of call associated with the record. |
VARCHAR2 |
8 |
TOTAL_CALLS |
Total calls associated with the record. |
NUMBER |
5 |
TOTAL_MINUTES |
Total minutes associated with the record. |
NUMBER |
10,2 |
TO_PLACE |
To place associated with the record. |
VARCHAR2 |
10 |
TO_STATE |
To state associated with the record. |
VARCHAR2 |
2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |