Property

1 to 10-character property code.  The property code must be previously defined in Property Maintenance.

Deck/Deck description

Enter the Billing Deck number for the DOI being entered.  

PLEASE NOTE:  Bill Decks are an optional part of the Revenue/Billing system.  You do not have to use rev/bill decks if they are not applicable to a specific well.  Also, you have the option of using rev/bill decks on some wells and not on others.  If you choose not to use rev/bill decks on a specific well leave the billing deck number blank.    

Active

Gives you the option to make your deck active/inactive, yet your history is maintained.  

Internal Description

When inactivating your deck, it is recommended to place a description in this field.  This will only show on internal reports.  May be used with both active and inactive decks.  

Account

Enter the account number of the accounts receivable account the system should use when creating A/R entries for each owner.

Owner/Name

1 to 10-character owner code.  The owner code must be previously defined using the Owner Maintenance Function [F12].

Int type

Choose the1 character code identifying the type of ownership from the drop down list - W, R, O, P, C, N, or S.  You can have more than one Working, Royalty, Overriding, Production Payment, or Carried Working Interest for an owner.  

NOTES:  

•The "P" (production payments), "C" (carried working interest), and "N" (unleased mineral interest owners) type will be treated the same as a working interest owner. These additional codes allow you to run listings easily for just different types of working interest.

•The "S" is for Non-Participating Royalty Interest Owners. This interest type is treated the same as any other royalty or override owner.

Extra Susp Code

If an owner is in legal suspense, you have the option to add additional legal suspense codes for additional reasons. The first Legal Suspense code in the "Susp Code" box is the primary code by which all the suspense history is associated with. All the "extra susp" is for documentation purposes to note additional reasons the owner would be in suspense.

Susp Code

Enter the suspense code for this interest. If changing the suspense code (edit mode) the system notes any suspended items matching.  You will be prompted to change the suspense items that match that criteria and all other suspense percentages.

Billing %

Enter the billing percent interest (as a decimal) the owner has in this lease. Supports a zero pct WI owner.  Typically used as an additional management report for Pumpers to list a detail of current month charges billed on the well. To utilize the zero percent WI option, be sure to select the "Print Detail for Zero % WI owners on the General Tab of the Revenue Billing Extract.

Revenue %

Enter the revenue percent interest (as a decimal) that each owner has in the lease.

Deleted Interest

Select which product type is NOT distributed to this owner.  If you disburse oil to an owner but not gas, then select GAS as the deleted interest product type (while in edit mode).

Exemptions

Select which Billing or Revenue G/L accounts are excluded from this owner's distribution cycle (while in edit mode). If an owner is exempt from any charge, the charge will be proportionately charged to all other owners.

Overhead

Select which Overhead Maintenance accounts are excluded from this owner's distribution cycle. If owner is exempt from an overhead charge the amount of the overhead charge will be reduced and only the chargeable owners amount will be billed.

Edit Mode: Suspense

Records and Amount

Displays the number of suspense records and net amount payable for the currently assigned suspense status. Only displayed in Edit mode.

Effective Date

From/Thru

Displays the effective dates of the owner's DOI.  'Blank' thru 12/9999 means no date sensitive DOI exists.        

Roll Group

Gives the option to roll up properties for individual owners on statements and net cash flow reports. See Partnership Groups.

Ext Info

Used with the Division Order Process

Doc

Right-click on the owner to add/view/delete doc.

Mass Change

Ability to redistribute an owner's interest for multiple leases.  Allows the user to specify the owner's new interest breakout (with each new owner, percent, and suspense code) and the selected leases in which to apply the change.

Mass Copy

Ability to copy from one DOI to another.  Enter the Property and effective date to copy from and to and select OK.  To delete the original DOI after copying, check the "instead of copy, "move" lease/deck instead" box.  Also have the ability to just copy Working Interest, Royalty Interest and/or Overrides.  This enables the user to setup a new deck (i.e. not copy to an existing deck) that excludes WI owners. When copying to, the new lease should already be setup without any existing DOI information.

Mass Delete

This utility provides the ability to delete a range of DOI's.

Mass Add to Division Orders

This allows owners to be queued up to the pending division order process. This function would be used if an operator acquired new properties and needed to send division order letters to a series of properties.  This will allow for a range or multi select of non-sequential properties.  

Import DOIs

The import format must be XLS, XLSX, or CSV. This imports supports adding new DOI’s only. DOI changes are NOT supported. In the Import Type Box, select either DOI Only or DOI and Owners (by Tax ID). Refer to the on-screen directions for each Import Type to determine the Required Columns needed and Optional Columns available.

Import Type - DOI Only:

•RevenuePct is the revenue percent for each owner. PctInterest is the billing percent for each owner.

•Effective Date: Use to Import a complete DOI with effective date changes that updates the current DOI if it exists. The column will be labeled "Effective Date". If the column is blank, the change will be treated as a "Use Latest" DOI change.  If the column is populated with a date, the change will be treated as an "Effective Date" change. If the DOI does not exist in the system, the import will not include effective dates even if they are populated.  This import only supports one effective date to be used per DOI in an import file.

•Deleted Interests: Use the three character product code or ALL for all products.

•Exemptions: The account number MUST exist first. Use the characters of the Revenue Categories; TAXES, OTHER and/or account number. (When needing more than account exemption use a semicolon (;) in-between each account.)

•Overhead Billings: The Overhead Maintenance MUST exist first. (When needing more than account exemption use a semicolon (;) in-between each account.)

Import Type - DOI and Owners (by Tax ID):

•Import Existing DOI’s Effective: You can import with an effective data as well as import with date sensitivity if there is already an existing DOI.

•Generate Owners #s starting at: To import owners then you must be using the Auto-Assign Sub-Account # option on the Sub-Table Definition Maintenance. This import will auto-generate the Owner Numbers creating the Sub-Account in the Owner Maintenance and creating the DOI.  You must enter the next number available for the owner number.

•Use first owner if Multiple TaxIDs match: This allows you to enter all owners on the DOI import even if they already exist and instead of creating a new owner Sub-Account code the system will locate the Sub-Account code that has the matching TaxID and use that one.

•If you want to use a custom Sub-Account coding scheme, you must first import the owners (located on the Owner (F12) Sub-Account) and then import the DOI.

Remove Date sensitive owners

Removes all date sensitive owners from the DOI and retains the "latest" most current owners only.

Combine Like interest types

Combines owners with multiple interests in the same property/deck of the same type together. Example: Within a Property/Deck, if an owner has both a W1 and W2 interest types, check to make sure both have everything else exactly the same (except for PctInterest and BillingPct). Also check to make sure owner does NOT have any suspense with that Owner, Property, Deck, Interest Type combination.  Combine (add 2 pairs of pcts together) into the lowest of the two sequence #s; if the zero seq # doesn't exist for that type of interest, then change the seq to 0 on those that are combined. (i.e. if owner has W1 and W2 and doesn't have a W0, then Combine W2 into W1, then rename W1 into W0.) Any changes made by this utility will be logged to the DOI Change History Log.