Spreadsheet: chris_stokley__3906__Global EES Risk Book Settlements Billing AR AP CF Data Needs
Sheet: Sheet1

Data Item | Risk Management | Billing | Cash Forecasting | Receivables Management | Operational Analysis-GAS/POWER/GNO | Accounting
1 | EES Entity transacting Business | Data Source Identification |  | Source System Name
2 |  | Data Source Identification |  | Source System ID Number
3 | Covered Service (e.g. commodity, projects, AOPS) | Customer | Customer Name | Customer Name
4 |  |  |  | System Customer ID Number
5 |  |  | GCP ID (Customer) Number | GCP ID (Customer) Number
6 |  |  |  | CMS Customer ID Number
7 |  |  |  | DUNS ID Number
8 |  |  |  | Customer Account (Site) ID Number
9 |  | Site |  | Customer Account (Site) Name
10 |  |  |  | Customer Account (Site) Street Address
11 |  |  |  | Customer Account (Site) Street Address2
12 |  |  |  | Customer Account (Site) City
13 |  |  |  | Customer Account (Site) County
14 |  |  |  | Customer Account (Site) State
15 |  |  |  | Customer Account (Site) zip
16 |  |  |  | Customer Account (Site) zip + 4
17 |  |  |  | Customer Contact Name for collections (site?)
18 |  |  |  | Customer Contact Telephone number for collections (site?)
19 | Commodity (e.g. power, gas) | Product (Gas, Electric Water) | Commodity (Gas, Power, Water, Steam, Bundled) | Commodity (Gas, Power, Water, Steam)
 |  |  |  | Product Type (Physical, Financial) | Product Type (Physical, Financial)
20 |  | EES SAP Company Code | SAP Company Number if known 890, 20R, etc. | SAP Company Number if known 890, 20R, etc.
21 |  |  | Company Number used by [NAME] (01-06) | Company Number used by [NAME] (01-06)
22 |  |  |  | Company Name (EESO GASS, EESO ELECTRIC, EESO NON-COM, EEMC GAS, EEMC POWER
23 |  |  | Type of customer (Commercial, Industrial, Residential) | Type of customer (Commercial, Industrial, Residential)
24 |  |  | Strategic customers flag / indicator | Strategic customers flag / indicator
25 |  |  | Top 25, top 50, etc. customer indicators | Top 25, top 50, etc. customer indicators
26 |  |  | Mid-Market indicator ("Sales Rep." Field at CSC) | Mid-Market indicator ("Sales Rep." Field at CSC)
27 |  |  | GNO indicator | GNO indicator
28 |  |  | Fast-track customer indicator | Fast-track customer indicator
29 |  |  |  | Status of Account (current / past due)
30 |  |  |  | Hold Code
31 |  |  |  | Invoice Number
32 |  |  | Invoice Date | Invoice Date
33 |  |  | Total customer owes all A/R ages, plus current, plus unbilled. | Total customer owes all A/R ages, plus current, plus unbilled.
34 |  |  |  | Invoice Amount (customer balance all ages, incl. current)
35 |  |  |  | Customer current amount
36 |  |  | Customer past due amount (previously billed) | Customer past due amount (previously billed)
37 |  |  | Invoice Due Date | Invoice Due Date
38 |  |  | Invoice Discount Due Date | Invoice Discount Due Date
39 |  |  | Invoice Discount Percentage or amount | Invoice Discount Percentage or amount
40 |  |  |  | Invoice Payment Terms
41 |  |  | Transaction Type (Invoice, Cash Receipt, Adjustment, etc.) | Transaction Type (Invoice, Cash Receipt, Adjustment, etc.)
42 |  |  |  | Adjustment Type
43 |  |  |  | Adjustment Name
44 |  |  |  | Adjustment Amount
45 |  |  |  | Adjustment Date
46 |  |  |  | Credit Memo Number
47 |  |  |  | Credit Memo Date
48 |  |  |  | Credit Memo Amount
49 |  |  | Remittance (deposit) Date | Remittance (deposit) Date
50 |  |  | [NAME] | [NAME]
51 |  |  | Remittance Type (Check, Wire, Direct Debit, Credit Card) | Remittance Type (Check, Wire, Direct Debit, Credit Card)
52 |  |  | Invoice Number Remittance was Applied to | Invoice Number Remittance was Applied to
53 |  |  |  | Cash Applied Date
54 |  |  |  | Customer check/wire/credit card or direct deposit confirmation number
55 |  |  | Balance Due | Balance Due
56 |  |  | Bank Name deposited to - Actual bank (not default) | Bank Name deposited to - Actual bank (not default)
57 |  |  | Account deposited to - Actual account (not default) | Account deposited to - Actual account (not default)
58 |  |  | Lockbox Number | Lockbox Number
59 |  |  | Type of payment/receipt (i.e. operating/investing/financing) | Type of payment/receipt (i.e. operating/investing/financing)
60 |  |  | Payment Pattern (weekly, monthly, etc.) | Payment Pattern (weekly, monthly, etc.)
61 |  |  | Unapplied Cash Remittance Amount | Unapplied Cash Remittance Amount
63 |  |  |  | Unapplied Cash Customer ID Number
64 |  |  |  | Unapplied Cash Customer Site Account ID Number
65 |  |  |  | Dispute Date
66 |  |  |  | Number of Days Dispute outstanding
67 |  |  | Customers on Payment Plan Flag | Customers on Payment Plan Flag
68 |  |  |  | Customer Final Notice Flag
69 |  |  |  | Customer Terminated Flag
70 |  |  |  | Attorney [NAME]
71 |  |  |  | Customer Bankruptcy Flag
72 |  |  | Comments/Notes/Other from the source systems | Comments/Notes/Other from the source systems
73 |  |  |  | Status of Account (current / past due)
74 |  |  |  | Utility Name
75 |  |  |  | Utility Number (if any)
76 |  |  |  | Extract Date
77 |  |  |  | Create Data
78 |  |  |  | Error Flag
79 |  | EES SAP GL Code | G/L coding for source A/R systems, [NAME], SAP? | G/L coding for source A/R systems, [NAME], SAP?
80 |  |  |  | EES Comments (for RM comments only)
81 |  | Utility Account # | Customer's Utility Account Number | Customer's Utility Account Number
82 | Flow Begin Date | Service Period - Start Date | Customer's "From Date" from Invoice | Customer's "From Date" from Invoice
83 | Flow End Date | Service Period - End Date | Customer's "To Date" from Invoice | Customer's "To Date" from Invoice
84 |  |  |  | Estimated [NAME]
85 |  |  |  | Difference between Estimate and Actual [NAME]
86 |  | Meter #
87 | Price Type (e.g. Commodity, Tax, ...) | [NAME] (Commodity, Tax, T&D, [NAME] )
88 |  | $ Amount Per Line Item
89 | Volume | Volume (Quantity)
90 |  | Volume (Unit of Measure)
91 | Volume Frequency (e.g. daily, monthly, total for period)
92 | Volume Status (e.g. estimated, actual) | Volume Type (Nomination, Accrual, Actual)
93 |  | EES SAP Accounting Date
94 |  | EES SAP STAT Code
95 |  | A/P vs A/R Identification
96 | Rate Schedule (if applicable -e.g. Name of Utility Rate Class)
97 | Rate Name (if applicable -e.g. IF-Transco/Z6 New York Restricted)
98 | Pass Through Fee (Yes/No)
99 | Price (Per Unit)/Rate  (e.g. Per Unit $50.00 USD/MWH or Rate $100,000 USD)
100 | Price Currency (e.g. USD, CAD, etc.)
101 | Total Amount (Price * Volume)
102 | Total Amount Currency (e.g. USD, CAD, etc.)
103