UTILITY USAGE DETAIL Table
View exposing utility-related usage and financial detail including amounts, units, BTU values, vendor references, purchasing attributes, and posting information used for utility cost and consumption reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_COLLECTOR_FP_KEY |
Identifier representing the cost collector at the fiscal-period level. |
VARCHAR2 |
12 |
COST_COLLECTOR_FY_KEY |
Identifier representing the cost collector at the fiscal-year level. |
VARCHAR2 |
12 |
COST_COLLECTOR_KEY |
Identifier for the cost collector associated with the utility transaction. |
VARCHAR2 |
12 |
DOCUMENT_DATE |
Date the financial document was created. |
DATE |
|
DOCUMENT_LINE_DATE |
Date associated with the document line item. |
DATE |
|
DOCUMENT_LINE_ITEM |
Line item number within the financial document. |
NUMBER |
3 |
DOCUMENT_NUMBER |
Identifier of the financial document. |
VARCHAR2 |
10 |
DOCUMENT_TYPE_KEY |
Identifier for the document type. |
VARCHAR2 |
3 |
GL_ACCOUNT_KEY |
Identifier for the general ledger account associated with the utility transaction. |
VARCHAR2 |
10 |
LINE_ITEM_TEXT |
Descriptive text for the document line item. |
VARCHAR2 |
50 |
NUMBER_OF_BTU |
Energy usage measured in BTU associated with the transaction. |
NUMBER |
34,3 |
NUMBER_OF_UNITS |
Number of usage units associated with the transaction. |
NUMBER |
26,3 |
OFFSET_COST_COLLECTOR_KEY |
Identifier for the offsetting cost collector associated with the transaction. |
VARCHAR2 |
12 |
PARKED_BY_USER_NAME |
User identifier for the individual who parked the document. |
VARCHAR2 |
12 |
POSTING_DATE |
Date the transaction was posted to the general ledger. |
DATE |
|
PURCHASE_ORDER_ACCT_ASSIGNMENT |
Account assignment number for the purchase order line item. |
NUMBER |
2 |
PURCHASE_ORDER_ITEM |
Line item number within the purchase order. |
NUMBER |
5 |
PURCHASE_ORDER_NUMBER |
Purchase order number associated with the transaction. |
VARCHAR2 |
10 |
RECORD_COUNTER |
Counter indicating record sequencing or versioning. |
NUMBER |
1 |
REFERENCE_DOCUMENT_NUMBER |
Reference document number associated with the transaction. |
VARCHAR2 |
16 |
REFERENCE_TEXT |
Reference text associated with the financial document. |
VARCHAR2 |
50 |
TIME_MONTH_KEY |
Identifier representing the fiscal month associated with the utility transaction. |
VARCHAR2 |
6 |
TRANSACTION_CODE |
Code identifying the transaction type or process. |
VARCHAR2 |
20 |
UNIT_OF_MEASURE |
Unit of measure for the utility usage quantity. |
VARCHAR2 |
5 |
USER_NAME |
User identifier for the individual who created or posted the document. |
VARCHAR2 |
12 |
UTILITY_USAGE_AMOUNT |
Amount associated with the utility usage transaction. |
NUMBER |
13,2 |
VENDOR_KEY |
Identifier for the vendor associated with the utility transaction. |
VARCHAR2 |
11 |
VENDOR_NAME |
Name of the vendor associated with the utility transaction. |
VARCHAR2 |
144 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |