Spreadsheet: chris_stokley__3903__Cash Flow information ECR1122 Specs v5
Sheet: Trans Data

 |  |  |  |  | Transactions Affecting Receivables/Cash Management
# | Data Elements | Comments |  |  | OF Inv | OF CM | OF DM | OF Pay | OF Rev | OF Re | ST Inv | [NAME] In | ST Bill | Alt Inv | [NAME] In | [NAME] | LS Inv | [NAME] In | LS Bill | HP Inv | [NAME] | HP Adj | HP Bill | HP Pay | Call Note
 | General Information
1 | Source System Name | 11 systems |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2 | Source System ID Number |  |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
77 | Creation Date | File creation date |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
N1 | Status Code | New or status change |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | Referential Information
4 | System Customer ID Number | HP = contract #, others = customer # |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
8 | Customer Account (Site) ID Number | HP = UDC acct #, others = billing address reference # |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | Transactional Information
 | Generic Details
41 | Transaction Type | See columns --> |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
43 | Transaction Name | More specific description or purpose for the transaction type |  |  | X | X | X |  |  |  | X | X |  | X | X |  | X | X |  | X | X | X |  |  | X
31 | Transaction Number | Invoice #, check #, etc. |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
32 | Transaction Date | Invoice date, deposit date, etc. |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
34 | Transaction Amount | Current charges or credits, + = increases [NAME],   - = decreases AR |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
29 | Transaction Status | Normal, disputed, hold, bankruptcy, collection, etc. |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X1 | X1 | X1 | X1 | X1
 | Invoice Specific Details
37 | Due Date |  |  |  | X |  | X |  |  |  | X |  | X | X |  | X | X |  | X | X |  |  | X
65 | Dispute Date |  |  |  | X |  | X |  |  |  | X |  |  | X |  |  | X
36 | Customer Past Due Amount | Past due amout from invoice |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  | X
 | Payment Specific Details
51 | Payment Method | Check, wire, ACH, credit card |  |  |  |  |  | X | X | X
56 | Bank Name deposited to - Actual bank |  |  |  |  |  |  | X | X | X
57 | Account deposited to - Actual account |  |  |  |  |  |  | X | X | X
58 | Lockbox Number |  |  |  |  |  |  | X | X | X
N3 | Applied-to Source System ID |  |  |  |  | X |  | X | X | X |  | X |  |  | X |  |  | X |  |  |  |  |  | X | X
N4 | Applied-to Transaction Type |  |  |  |  | X |  | X | X | X |  | X |  |  | X |  |  | X |  |  |  |  |  | X | X
52 | Applied-to Transaction Number |  |  |  |  | X |  | X | X | X |  | X |  |  | X |  |  | X |  |  |  |  |  | X | X
 | Account Information
55 | Customer Account Balance | Sum of all open items, including disputes as of date created |  |  | X | X | X | X | X | X | X | X |  | X | X |  | X | X |  | X | X | X |  | X
55 | Customer Account Balance - no disputes | Does not include disputes |  |  | X | X | X | X | X | X | X | X |  | X | X |  | X | X |  | X | X | X |  | X
 | Other Notes
 | For payments and credit memos, there will be one record in the file for each application.  The sum of all applications = total payment amount.
 | For reversals, there will be one record in the file for each application that must be reversed.  The sum of all applications = negative of total payment amount.
 | For reapplications, there will be one record in the file for each reversal and one for each application.  The net change will be zero.
 | Unappled payments are recognized as payments where the applied-to section is blank
 | For call notes the note will be stored in the transaction name field.  If the note is tied to an invoice, the number will be in the applied-to fields.
 | Unidentified payments have no referential data. |  |  |  | Key:
 |  |  |  |  | Yellow box = Data element not applicable to this transaction
 |  |  |  |  | X = Data element is available for this transaction
 |  |  |  |  | X1 = Stored at account level for all transactions