Spreadsheet: chris_stokley__3909__CSC-Work Request - Ranger Attachment
Sheet: Sheet1

Project:  [NAME]  (CSC Power only)
Frequency:  Daily or whenever data is interfaced into the G/L
[NAME]:  Flat File delimited with “|”
Interface via:  FTP
Specifics:  Data fields not available from source system should be filled
in with null values.  [NAME] should have [NAME]/dd/yyyy formats.
The following is only a suggested format.
Accounts Master:  (pow_acct_master)
Header or footer record:
EES Company (EESO or EEMC)
Number of records
Extract date
[NAME]:
EES Company (EESO or EEMC)
Source System Name
Extract Date
Customer ID
Customer name
Enron Account ID
Account Description
UDC #
[NAME]
UDC Account number
Account Description
Physical Location Address 1
Physical Location Address 2
City
State
County
Zip + 4
Account Status code and description
Physical or non-physical indicator
Start Date
End Date
Evergreen (if applicable)
Rate Schedule
Commodity type   (Power)
Customer type
Invoicing day
Product type
Accounts Receivable [NAME]:   (pow_acctrec_detail)
Header or footer record:
EES Company (EESO or EEMC)
Number of records
Extract date
Total usage volumes (in STAT normally volumes associated with glcode 4300)
Total dollars
[NAME]:
EES Company (EESO or EEMC)
Source System Name
Extract Date
*Enron Account ID
*UDC #
UDC Account number
*From date
*To date
Invoicing group id
*Invoice number
LDC bill id
*Line item description
*Units
Rate
*Amount
Currency type (U.S.)
Unit of measure
Volume type (nomination, actual, estimate)
Glcode   (need both sides A/R and offsetting accounts)
Oracle Financial Account code  (both sides)
*Issue date
Total invoice amount  (this amount should equal the sum of all detail line items)
GL Month (format yyyy/mm)
Accounts Receivable Manual Detail:   (pow_acctrec_manual)
Header or footer record:
EES Company (EESO or EEMC)
Number of records
Extract date
Total usage volumes
Total dollars
[NAME]:
EES Company (EESO or EEMC)
Source System Name
Extract Date
Enron Account ID
UDC #
UDC Account number
From date
To date
Invoicing group id
Invoice number
LDC bill id
Line item description
Units
Rate
Amount
Currency type (U.S.)
Unit of measure
Volume type (nomination, actual, estimate)
Glcode   (need both sides A/R and offsetting accounts)
Oracle Financial Account code  (both sides)
Issue date
Total invoice amount  (this amount should equal the sum of all detail line items)
GL Month (format yyyy/mm)
Reason
Accounts Payable Detail:  (pow_acctpay_detail)
Header or footer record:
Number of records
Extract date
Total usage volumes
Total dollars
[NAME]:   (should come from STAT, [NAME], and HP for PECO, and other source systems)
Source System Name
Extract Date
Enron Account ID
UDC #
UDC Account number
LDC bill id
From date
To date
Invoice number  (if applicable)
Line item description
Units
Rate
Amount
Currency type (U.S.)
Unit of measure
Volume type (nomination, actual, estimate)
Glcode
Oracle Financial Account Code
Date paid
Total bill amount  (this amount should equal the sum of all detail line items)
Origination   ([NAME] or invoice)
GL Month (format yyyy/mm)
Accounts Payable Manual Detail:  (pow_acctpay_manual)
Header or footer record:
Number of records
Extract date
Total usage volumes
Total dollars
[NAME]:  (should be from OF; known data filled in )
Source System Name
Extract Date
Enron Account ID
UDC #
UDC Account number
LDC bill id
From date
To date
Invoice number  (if applicable)
Line item description
Units
Rate
Amount
Currency type (U.S.)
Unit of measure
Volume type (nomination, actual, estimate)
Glcode
Oracle Financial Account Code
Date paid or date sent for payment processing
Total bill amount  (this amount should equal the sum of all detail line items)
Origination   ([NAME] or invoice)
GL Month (format yyyy/mm)
Reason