UTILITY USAGE DETAIL WITH CUP Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_COLLECTOR_FP_KEY |
Key used to join historical Cost Collector tables and a fact table (Balances by Fiscal Period, Summary Statement Detail) when you want to bring up the cost collector data matching the fiscal period on the fact table. For the current fiscal period, the most recent data will be brought in. |
VARCHAR2 |
12 |
COST_COLLECTOR_FY_KEY |
Key used to join historical Cost Collector tables and a fact table (Balances, Balances by Fiscal Period, Summary Statement Detail) when you want to bring in cost collector data as it was at the end of fiscal year of the fact data. For the current fiscal year, the most recent data will be brought in. |
VARCHAR2 |
12 |
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
DOCUMENT_DATE |
The date entered by the user when creating the document. Generally the date the financial transaction occurred, but see also the definition for document line date. |
DATE |
|
DOCUMENT_LINE_DATE |
If not blank, the date the financial transaction occurred. If blank, the document date is the date the financial transaction occurred. |
DATE |
|
DOCUMENT_LINE_ITEM |
Document Line Item Number. |
NUMBER |
3 |
DOCUMENT_NUMBER |
The number in SAP that uniquely identifies a detailed transaction document. |
VARCHAR2 |
10 |
DOCUMENT_TYPE_KEY |
Key used to join the Document Type to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
3 |
GL_ACCOUNT_KEY |
Key used to join the GL_ACCOUNT to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
10 |
LINE_ITEM_TEXT |
The short description of the line item. Also appears on the SAP DTR for the cost collector associated with this financial detail. |
VARCHAR2 |
50 |
NUMBER_OF_BTU |
XXX |
NUMBER |
34,3 |
NUMBER_OF_UNITS |
For LIBRARY data: Number of individual items (units) being ordered; usually the number of copies. This number is multiplied by UNIT_PRICE to get LIBRARY_ORDER_AMOUNT. For Serial orders, this number is always 1. (Z68-NO-UNITS) For SUBJECT ENROLLMENT Data, this represent the number of units the student registered for the subject. |
NUMBER |
26,3 |
OFFSET_COST_COLLECTOR_KEY |
"Offset Cost Collector" is a field referring to a WBS element subject to Underrecovery of F&A costs. The Offset Cost Collector Key in the Financial Detail table can be joined to the Cost Collector Key in Cost Collector tables in queries related to tracking underrecovery of F&A costs. It is used only for joining tables, not on the Request line. |
VARCHAR2 |
12 |
PARKED_BY_USER_NAME |
Kerberos ID of the user who "parked" the document |
VARCHAR2 |
12 |
POSTING_DATE |
The date the financial document was posted in SAP. Effective date of posting, not actual date. For example, a costing sheet posting could be generated in early July, but posted to June 30, if so specified by an authorized users. |
DATE |
|
PURCHASE_ORDER_ACCT_ASSIGNMENT |
XXX |
NUMBER |
2 |
PURCHASE_ORDER_ITEM |
Number identifying a line item associated with a purchase order. |
NUMBER |
5 |
PURCHASE_ORDER_NUMBER |
Identifies the purchase order. In SAP this is the Document Number for a Purchasing Document. |
VARCHAR2 |
10 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
REFERENCE_DOCUMENT_NUMBER |
For FINANCIAL_DETAIL: The reference number of the associated financial document. A value of %N means that there is no backup for the journal voucher. For COMMITMENT tables, the document number from which the commitment was generated. |
VARCHAR2 |
16 |
REFERENCE_TEXT |
The document header text associated with a journal document. Not always completed by the JV document creator. |
VARCHAR2 |
50 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
TRANSACTION_CODE |
The code assigned to each transaction by SAP. It may be more meaningful to use the document type. |
VARCHAR2 |
20 |
UNIT_OF_MEASURE |
XXX |
VARCHAR2 |
5 |
USER_NAME |
Kerberos ID of the person who entered the purchasing financial detail record in SAP, usually the purchasing agent |
VARCHAR2 |
12 |
UTILITY_USAGE_AMOUNT |
XXX |
NUMBER |
13,2 |
VENDOR_KEY |
Key identifying an entry in the VENDOR master table. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
11 |
VENDOR_NAME |
In the Financial Detail Table, the Vendor to whom a Purchase Order was issued. |
VARCHAR2 |
144 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |