Upstream/Midstream/Transportation Tie Out Processes
Zephyr Test Case | Batch Process | SME Dependency | Module | Level | Results Screens | Grouping to Consider | Numerical Column(s) to Compare | Comments | SME Contact* |
|---|---|---|---|---|---|---|---|---|---|
Apply DO | Yes | DO & Disbursements | Company | Owner Amounts | Owner number | ||||
Apply DO | Yes | DO & Disbursements | Company | Payable Results | Asset name | ||||
Apply DO | Yes | DO & Disbursements | Company | Payment Results | Owner number | ||||
DO Bank Interface | Yes | DO & Disbursements | Company | Payment Results | Owner number | ||||
DO Journal Interface | Yes | DO & Disbursements | Company | DO Journal Results | Owner number | ||||
Allocate | No | Revenue Accounting | Asset | Allocation Results | From Meter number | Quantity, Basis Quantity | |||
Calculate Taxes | Yes | Revenue Accounting | Asset | Tax Results | Contract Number | Trust Percent, Exempt Percent, Quantity, Base Amount, Exempt Base Amount, Gross Amount, Rate, Exempt Amount, Total Exempt Amount, Tax Result | |||
Cashout | Yes | Revenue Accounting | Asset | Cashout Results | Contract number | Cashout volume, Over/Underdeliver Rate Result, Tier Resolution, Cashout Value, Write off volume, Write off value, Carry volume, Carry value | |||
Cashout | Yes | Revenue Accounting | Asset | Carryover Results | Contract number | Volume, Carry Value | |||
Data Prep | No | Revenue Accounting | Asset | Leveled Analyses | Meter number | All columns (40+ columns for Mol %, GPMs, BTU Factors, etc.) | |||
Data Prep | No | Revenue Accounting | Asset | Leveled Run Tickets | Meter Number, Ticket number | All columns. | |||
Data Prep | No | Revenue Accounting | Asset | Leveled Volumes | Frequency Volume Type Ticket Number | Quantity | |||
Imbalance | Yes | Revenue Accounting | Asset | Imbalance Results | Contract number | Begin Cumulative Volume, Begin Cumulative Value, Current Imbalance Volume, Current Imbalance Value, End Cumulative Volume, End Cumulative Value, Over/Underdeliver Rate Result, Tier Resolution, Cumulative Revaluation Rate | |||
Value | No | Revenue Accounting | Asset | Contract Fixed Results | Contract Number | Quantity, Basis Quantity, Basis Percent | |||
Value | No | Revenue Accounting | Asset | Contract Split Results | Contract Number | Quantity, Basis Quantity, Basis Percent | |||
Value | No | Revenue Accounting | Asset | Valuation Results | Meter number | Quantity, Value, Rate Result, Producer Percent, Fixed Percent, Inflation | |||
AR/AP | Yes | Revenue Accounting | Asset | Accounting Details | Various per client based on config.yml settings Enlink: Row Code, Lease Number, Contract Number, Value Type, Formula Type, Product, Usage, AR/AP, Line Number | Volume, value, | |||
AR/AP | Yes | Revenue Accounting | Asset | Accounting Results | Various per client based on config.yml settings Enlink: Contract Party Name, Payment Party Name, Lease Number, Row Code, Line Number, Value Formula Unit, Fee Unit, Tax Unit, Volume Formula Unit, Product Code, Transaction Type | Volume Formula Result, Adjusted Value Formula Result, Value Formula Result, Fee, Tax, Net | |||
Journal Interface | Yes | Revenue Accounting | Asset | Journal Results | Various per client based on config.yml settings | ||||
Value | Yes | Revenue Accounting | Asset | Report Allocated Values | Various reporting tables with hundreds of columns, will need several checks | ||||
Value | Yes | Revenue Accounting | Asset | Report Contract Values | Various reporting tables with hundreds of columns, will need several checks | ||||
NM | Yes | Taxes | Company | ||||||
TX | Yes | Taxes | Company | ||||||
OK | Yes | Taxes | Company | ||||||
ND | Yes | Taxes | Company | ||||||
KS | Yes | Taxes | Company | ||||||
Data Prep | Yes | Terminal Management | Asset | Leveled Run Tickets | Ticket number | For tieouts: Check quantity Sum for each unit and compare it with run tickets grid. | |||
Data Prep | No | Terminal Management | Asset | Leveled Volumes | Frequency | ||||
Tank Management | Yes | Terminal Management | Asset | Daily Tank Details |
| ||||
Tank Management | Yes | Terminal Management | Asset | Terminal Inventory Transactions |
| ||||
Transport Value | Yes | Terminal Management | Asset | Valuation Results | Contract number | ||||
Daily Transport Allocate | Yes | Transportation | Asset | Available for Sale Results | Contract number | ||||
Daily Transport Allocate | Yes | Transportation | Asset | Book Inventory Transactions | Contract number | Receipts | |||
Daily Transport Allocate | Yes | Transportation | Asset | Inventory Balances | Contract number | ||||
Daily Transport Allocate | Yes | Transportation | Asset | Inventory History | Contract number | ||||
Daily Transport Allocate | Yes | Transportation | Asset | Movements | Contract number | ||||
Daily Transport Allocate | Yes | Transportation | Asset | Shipper Allocations | Contract number | ||||
Data Prep | No | Transportation | Asset | Leveled Run Tickets | Ticket number | ||||
Data Prep | No | Transportation | Asset | Leveled Volumes | Frequency | ||||
Monthly Transport Allocate | No | Transportation | Asset | Available for Sale Results | Contract number | ||||
Monthly Transport Allocate | Yes | Transportation | Asset | Bank Results | Contract | ||||
Monthly Transport Allocate | Yes | Transportation | Asset | Book Inventory Transactions | Contract number | Receipts | |||
Monthly Transport Allocate | Yes | Transportation | Asset | Inventory Balances | Contract number | ||||
Monthly Transport Allocate | Yes | Transportation | Asset | Inventory History | Contract number | ||||
Monthly Transport Allocate | Yes | Transportation | Asset | Movements | Contract number | ||||
Monthly Transport Allocate | Yes | Transportation | Asset | Shipper Allocations | Contract number | Total receipts and total deliveries should match. | |||
Transport Value | Yes | Transportation | Asset | Valuation Results | Contract number | ||||
Due Diligence | Yes | Revenue Accounting | Company | ||||||
Finalize Escheatment | Yes | Revenue Accounting | Company |