ISI Software Oil & Gas System

 

Section 8 - Work Station Operator Procedures

 

A.          General Processing Requirements

 

The additions or updates to the Master File must be performed prior to processing any other application. Listed below are some additional notes pertaining to the Master File Application:

 

Chart of Accounts

 

When a new account number is assigned, determine if it is required to be added to the control records. For example, if a new series of primary accounts that require a valid name and address number are assigned, the primary account number must be added to the Name and Address Primary Accounts Control Record.

 

Multiple Updates

 

The first position of records in the Master File is used to keep multiple work stations from updating the same record at the same time. The first position of a record is flagged with an active indicator when a record is read for update. If another work station tries to update the record, the message '**RECORD NOT AVAILABLE AT THIS TIME**' is displayed and the record is not made available until the first work station has updated or released the record.

 

If a program that has read a record for update is canceled due to a power failure or other abnormal end of job, the record will be incorrectly flagged as active. The work station operator may free the record by using F5 instead of the ENTER key.

 

Deleted Records

 

The various master file transactions allow records to be deleted. The record CANNOT be reinstated!

It must be added again.

 

B.      Sign-On Procedure

 

A terminal operator may sign on a work station and select the Master File Menu using the following procedure:

 

1.     Execute the ISI batch file in the \SS directory using the correct parameters. The sign on screen below will be displayed:

                                                ISI Accounting System

                                    User identification             CLIFF

                                    Password                              ..............

                                    Workstation ID                    W2

                                    Client prefix                         ZZ

                                    Drive letter                           D:

                                    Debug ?                               Y

 

                                    Copyright 1987 (c) Cliff Buchanan

                                                                                                                                                               

2.     Enter the following data on the screen:

 

3.     After the sign-on data is entered, press the ENTER key and the General Accounting Application Menu will be displayed.

 

4.     Select Master Files and press the ENTER key to display the Master File Application Menu.

 

5.     Review Section 5 for available menus.

 

C.      Date and Printer Information Screen

 

When the workstation operator requests a report to be printed the Date and Printer Information Screen is displayed. For most reports the operator needs only to verify or change the report date. The application instructions specify any additional data that may need to be changed. The screen and data field definitions are included below:

 

*** Date and Printer Information  ***

Report Date                                                ______

Date Run                                          ______

Printer-ID                                          __

# of Copies?                                                01

Quantity                                           __________

Alpha                                                            ___________________________________

Forms Length                                              __________

User:                                                   CLIFF

Workstation ID                                __________

System Time                                     11:37 AM

 

 


FIELD                     EXPLANATION

 

REPORT DATE - The ending accounting report date in MMDDYY format. If an accounting report is being requested, the month and year will determine the ending accounting month date that will be used for the report. A date will be displayed; however, the date should be reviewed and changed if it is not correct.

 

DATE RUN - The current date is displayed and should not be changed

 

PRINTER ID - The default printer ID is displayed and is normally not changed. The ID may be changed to print on another printer.

 

# OF COPIES - The default is one copy. If you need multiple copies, enter the number required.

 

QUANTITY - This field is only used if joint interest billing invoices are being printed and the starting invoice number must be changed.

 

ALPHA - If an edit report is being reprinted, PRINTALL must be entered.

 

FORMS LENGTH - The forms length is displayed.

 

USER - The user ID is displayed.

 

WORKSTATION ID - Workstation ID is displayed.

 

SYSTEM TIME - The system time is displayed.

 

After any required data is entered, press the ENTER key and the requested report will be printed.

 

D.          Update Chart of Accounts

 

1.                    From Menu MF#02 select Option 1 'Update Chart of Account

 

2.                    Enter the general ledger account number and press the ENTER key to display the update screen.

 

3.                    Enter or Modify the following fields:

 

 


FIELD                     DESCRIPTION

 

DESCRIPTION - The account description.

 

P/L CODE - The P&L code that references a financial statement heading record used to format financial statements.

 

CATEGORY - This field controls selection and accumulation for  revenue reports.

 

4.     After all data is entered, press ENTER to process the data and return to the Account Number Screen.

 

E.          Update Company Identification Masters

 

1.             From Menu MF#01 'Master File Application Menu' select Option 1.

From Menu MF#02 select Option 2 'Update Company Identification Masters'.

2.             The Company Number Screen is displayed to allow entry of the company identification number.

3.             Enter the seven digit company/division/branch number and press the ENTER key to display the update screen.

4.             Enter or Modify the following fields:

 

FIELD                     DESCRIPTION

 

COMPANY NAME - The company, division or branch name.

 

NAME AND ADDRESS# - The company's name and address number.

 

FISCAL YEAR STARTING MONTH - The two digit first month of the fiscal year.

 

TYPE OF ENTITY - The one character entity code.  (I,P,C,F,T)

 

DATE ORIGINATED - The Origination date in "MMDDYY" format.

 

TAX BASIS ACCOUNTING METHOD - The one character tax basis code. (A,C U)

 

NET INCOME ACCT# - The general ledger account to which earnings are closed to at year end.

 

OIL & GAS ACCOUNTING METHOD - The two character accounting method code. (FC,SE)

 

WAGE EXPENSE ACCT# - The payroll wage account number if the company does payroll.

 

 

CO/DV/BR TO CHARGE PAYROLL EXPENSE - The company ID to be charged if the company does payroll.

 

5.     After all data is entered, press ENTER to process the data and return to the Company Number Screen.

 

F.          Update Name and Address Masters

 

1.                    From Menu MF#02 select Option 3 'Update Name and Address Masters'.

 

2.                    The Name and Address Number Screen is displayed to allow entry of the name and address number or the name.

 

3.                    To inquire or update an existing record, key in the seven digit name and address number in the NAME AND ADDRESS # field and press ENTER to display the update screen. Go to step five to review or update data.

 

4.                    There are two options for adding records:

 

a. If the name and address number is manually assigned, enter the number in the NAME AND ADDRESS # field and press ENTER to display the add screen. Go to step five add the record.

 

b. If the system is to automatically assign the new name an address number in alphabetic sequence:

 

1. Press the FIELD + key to set the NAME AND ADDRESS # field to zeros.

2. Enter the most significant name in the ALPHA LOOK UP # 1 field. For example, if the name is O. K. Brock enter BROCK in the field. If the name is The I.S.I. Oil & Gas Company, enter ISI in the field.

3. If the name is a common name, enter a second name in the APLHA LOOK UP #2 field. For example, if there are multiple BROCK names in the file and the name being added is O. K. Brock, enter OK in the field.

 

5.     Press the ENTER key to display the number that was assigned. Press ENTER to display the add screen.

 

Note: In some cases unique numbers may not be assigned. For example, there may be multiple O.K. Brocks. If this occurs, the existing O.K. Brock record will be displayed instead of an add screen. In this case use F1 key to return to the Name and Address Number Screen and either add additional data in the ALPHA LOOK UP # 2 field or manually assign the number. To manually assign the number, add 1 to the number that is displayed in the NAME AND ADDRESS # field. If additional data is entered in ALPHA LOOK UP # 2 field to allow the system to assign the number, the FIELD + key must be used on the NAME AND ADDRESS # field to remove the displayed number.


 

6.             Enter or Modify the following fields.

 

FIELD                     DESCRIPTION

 

NAME -  The 24 character name.

 

EXPANDED NAME FIELDS -  Four additional name fields are available for the Lease Records Application or Revenue Application.

 

CARE OF - This field may contain a care of name or it may be used to extend the regular name or address.

 

ADDRESS - The 19 character address.

 

CITY - The 11 character city name.

 

STATE - The two character state abbreviation.

 

ZIP - The five digit zip code.

 

PHONE NUMBER - The telephone number.

A/C                                The three digit area code.

Phone no.                The 7 digit exchange and phone number.

EXT                                The three digit extension.

 

INSURANCE DATE - Reserved

 

SOCIAL SECURITY # - The nine digit social security number or federal ID number. Use the FIELD + key to enter a social security number or the FIELD - key to enter a federal ID number.

 

AFFILIATED CO/DV/BR - The company identification - company, division and branch number for affiliated entities. The Joint Interest Billing and Revenue Applications generate automatic accounting entries for affiliated entities.

 

BANK CHARGE - The depository bank charge for rental checks produced by the Lease Records Application.

 

 

7.     After all data is entered, press ENTER to process the data and return to the Name and Address Number Screen.

 

G.          Update Lease Masters (MF84)

 

1.             From Menu MF#02 select Option 4 'Update Lease Masters'.

 

2.             The Lease Number Screen is displayed to allow entry of the lease number or the lease name.

 

3.             To inquire or update an existing record, key in the seven character lease number in the LEASE NUMBER field and press the ENTER key to display the update screen. Go to step five to review or update data.

 

4.             There are two options for adding records:

 

a.        If the lease number is manually assigned, enter the number in the LEASE NUMBER field and press ENTER to display the add screen. Go to step five to add the record.

 

b. If the system is to automatically assign the new lease number in alphabetic sequence:

 

1.            Press the FIELD + key to set the LEASE NUMBER field to zeros.

2.            Enter the lease name in the ALPHA LOOK UP # 1 field.

3. Press the ENTER key to display the number that was assigned. Press the ENTER key to display the add screen.

Note: In some cases unique numbers may not be assigned. For example, there may be multiple leases with the same name. If this occurs, the existing lease record will be displayed instead of an add screen. In this case, use F7 key to return to the Lease Number Screen and either add additional data in the ALPHA LOOK UP #1 field or manually assign the number. To manually assign the number add 1 to the five character lease number in the LEASE NUMBER field. If additional data is entered in ALPHA LOOK UP # 1 field to allow the system to assign the number, the FIELD + key must be used on the LEASE NUMBER field to remove the displayed number.


 

5.             Press the ENTER key to display the number that was assigned.. Press ENTER to display the add screen.

 

6.             Enter or Modify the following fields:

 

FIELD                     EXPLANATION

 

LEASE NUMBER - The seven character lease number sub-divided into a five character primary or base lease number and a two character suffix. The base number identifies a specific lease and the suffix identifies subdivisions within the lease such as wells.

 

LEASE NAME - The 24 character lease name.

 

STATE CODE - The two character state code.

 

COUNTY CODE - The three digit county code.

 

OPERATOR NUMBER - The seven digit name and address number of the lease operator.

 

FIELD - The five digit field number. This field is optional. If field numbers are used, the associated field master records are normally set up.

 

# OF WELLS - The number of wells on the lease. The Joint Interest Billing Application uses the number of wells to allocate pumper overhead charges.

 

OIL TYPE - Type of oil recovery. The codes may be user defined and are for information purposes. For example:

P - Primary

S - Secondary

T - Transferred

R - Regulated

 

GAS TYPE - Type of gas recovery. The codes may be user defined and are for information purposes. For example:

P - Primary

S - Secondary

T - Transferred

R - Regulated

 

PRODUCTION DATE - The date of the first production from the lease in MMDDYY format.  The date is for used by the Depletion Application.

 

DATE ACQUIRED - The date the lease was acquired in MMDDYY format. The date is for information purposes.

 

CONTRACT DATE - The gas contract date for the lease in MMDDYY format. The date is for information purposes.

 

LEASE SEVERANCE TAX RATE - The 5 decimal digit severance tax rate for the states where the rate may vary by lease; i.e., Alabama, Colorado, Louisiana and New Mexico. The rates for states such as Texas that do not vary by lease are maintained in program tables. The rate is used in the calculation of windfall profit tax.

 

GAS ID # - The 10 digit comptroller's gas identification. The number is for information purposes.

 

USER DATA - 4 characters of user data for informational purposes.

 

PURCHASER # - The name and address number of the purchaser. The number may be set up for information purposes. If the Revenue Application is installed, the purchaser number is in the Division of Interest Master and there may be multiple purchasers for the different products produced from the lease.

 

FASTAX - The 4 character FASTAX number. Used to sequence the X26B FASTAX report.

 

OLD AC # - Reserved

 

GROSS ACRES - The 5 digit gross acres contained in the lease. The data is for information purposes.

 

BILLABLE CODE - S-Will put JIB records into suspense ledger. R-Will release leases from suspense ledger

 

PROSPECT# - The 5 character Lease Records Application prospect number. The number is for information purposes.

 

OUR WORKING INTEREST - The company's working interest in the lease. This field is for information only and may be left blank. Actual working interest is normally obtained from the Joint Interest File and may vary for wells in the lease.

 

OUR REVENUE INTEREST - The company's revenue interest in the lease. This field is for information only and may be left blank. Actual revenue interest is normally obtained from the Division of Interest File maintained by the Revenue Application.

 

OIL RESERVES - Oil reserves in barrels. The field is 11 digits and contains 2 decimal places. The data is for information purposes.

 

GAS RESERVES - Gas reserves in MCF's. The field is 11 digits and contains no decimal places. The data is for information purposes and may be left blank.

 

REVENUE INTEREST BEFORE PAYOUT - The total revenue interests of all working interest owners before payout. This revenue interest may be set up to report only the revenue associated with working interest owners on the gross lease payout report; i.e., royalty revenue will not be reported. If the interest is not entered, the revenue reported on the Gross Lease Payout Report will include royalty revenue.

 

REVENUE INTEREST AFTER PAYOUT - See revenue interest before payout.

 

ALLOCATABLE CODE - The one character code to designate a lease as allocatable. (A, Blank)

 

EXPLORATORY DEVELOPMENT CODE - The one character code that designates a lease as Exploratory or Developmental (E,D,Blank).

 

ACTIVE OR INACTIVE CODE - The one character code that designates a lease as active or

                                 inactive (A,I,Blank).

 

7.     After all data is entered, press 'ENTER' to process the data and return to the Lease Number Screen.

 

H.          Create State and County Masters

 

1.             From Menu MF#02 select Option 5 'Create State and County Masters'.

 

2.             Enter the code for the desired state and press ENTER. If you desire to build additional states and counties enter desired codes when prompted by "Enter Missing Parameter".

 

3.             To end this job press ENTER when the prompt "Enter Missing Parameter" is displayed.

 

I.          Update State and County Masters

 

1.             From Menu MF#02 select Option 6 'Update State and County Masters'.

 

2.             Enter the official 2-character abbreviation for the state and the 3-digit county code number and press ENTER the display the update screen. If you are updating this state for payroll purposes use three zeros for the county code.

 

3.             After all data is entered, press ENTER to process the data and return to the State and County Number Screen.

 

 

J.          Update Field Masters

1.             From Menu MF#02 select Option 7 'Update Field Masters'.

 

2.             Enter the State and field code and press the ENTER key to display the update screen.

 

3.             After all data is entered, press ENTER to process the data and return to the State and Field Code Screen.

 

K.          Update Control Records

 

1.             From Menu MF#02 select Option 8 'Update Control Records'

 

2.             Refer to Sections I, Introduction, and II, Sample Forms, for information concerning the preparation of control record input forms.

 

3.             Enter the Record Key and press ENTER to display the update screen.

 

4.             The Record Key entered on the first screen will be displayed on the top line of the screen.

 

This Screen will have spaces numbered from '10' TO '128'. Enter the Control Record Data in the appropriate spaces. The sample input form for the control record being added or updated should be used to determine the correct spaces in which to enter data.

 

5.     After all data is entered, press ENTER to process the data and return to the Record Key Screen

 

L.      Print Chart of Accounts

 

1.             From Menu MF#03 select Option 1 'Print Chart of Account Masters'.

 

2.             Enter the following fields:

 

ENTER BEGINNING # - Enter the beginning number or leave this field blank to print a complete list.

 

ENTER ENDING # - Enter the ending number or leave this field set to '9999999' to print a complete list.

 

ENTER RECORD TYPE - This field defaults to '1'. Leave it as it is displayed.

 

3.             The 'Date and Printer Information' Screen will be displayed. Enter the desired information and press ENTER.

 

M.     Print Company Identification Masters

 

1.             From Menu MF#03 select Option 2 'Print Company Identification Masters'.

 

2.             The 'Date and Printer Information' Screen will be displayed. Enter the desired information and press ENTER.

 

N.      Print Name and Address Masters

 

1.             From Menu MF#03 select Option 3 'Print Name and Address Masters'.

 

2.             Enter the desired information and press the ENTER key to display the next screen.

 

3.             The 'Date and Printer Information' Screen will be displayed. Enter the desired information and press ENTER.

 

 


O.      Print Lease Master

 

1.             From Menu MF#03 select Option 4 'Print Lease Masters.

 

2.             Enter the following fields:

 

ENTER BEGINNING # - Enter the beginning lease number or leave this field blank if you wish to print a complete lease master list. Leave this field blank if you use alpha characters in your lease numbers.

 

ENTER ENDING # - Enter the ending lease number or leave this field set to 'ZZZZZZZ' if you wish to print a complete lease master list.

 

ENTER RECORD TYPE - This field defaults to 'L'. Leave it as it is displayed.

 

3.             The 'Date and Printer Information' Screen will be displayed. Enter the desired information and press ENTER.

 

 

P.      Print Alpha Lease Masters

 

1.             The following procedure may be used for printing the lease master records in alphabetical order.

 

2.             From Menu MF#03 select Option 5 'Print Alpha Lease Master.

 

3.             The following screen will be displayed to enter the desired information:

 

ENTER BEGINNING # - Enter the beginning lease number or leave this field blank if you wish to print a complete lease master list. Leave this field blank if you use alpha characters in your lease numbers.

 

ENTER ENDING # - Enter the ending lease number or leave this field set to 'ZZZZZZZ' if you wish to print a complete lease master list.

 

4.             The 'Date and Printer Information' Screen will be displayed. Enter the desired information and press ENTER.

 

Q.      Print State and County Masters

 

1.             From Menu MF#03 select Option 6 'Print State and County Masters'.

 

2.             Enter the following fields:

 

ENTER BEGINNING # - Leave this field blank.

 

ENTER ENDING # - Leave this field set at 'ZZZZZZZ'.

 

ENTER RECORD TYPE - This field defaults to 'S'.  Leave it as it is displayed.

 

3.             The 'Date and Printer Information' Screen will be displayed. Enter the desired information and press ENTER.

 

R.      Print Field Masters

 

1.             From Menu MF#03 select Option 7 'Print Field Masters'.

 

2.             Enter the following fields:

 

ENTER BEGINNING # - Leave this field blank.

 

ENTER ENDING # - Leave this field set at '9999999'.

 

ENTER RECORD TYPE - This field defaults to 'M'. Leave it as it is displayed.

 

3.             The 'Date and Printer Information' Screen will be displayed. Enter the desired information and press ENTER.

 

S.      Print Control Records

 

1.             From Menu MF#03 select Option 8 'Print Control Records'.

 

2.             The 'Date and Printer Information' Screen will be displayed. Enter the desired information and press ENTER.

 

T.      Print Lease or Name and Address Labels

 

1.             From Menu MF#03 select Option 9 'Print Lease or Name and Address Labels'.

 

2.             Enter the following fields:

 

ENTER "L" FOR LEASE LABELS OR "3" FOR N/A LABELS

 

Enter 'L' for Lease or '3' for name and address.

 

BEGINNING LEASE # OR N/A # (7A)/BLANK - Enter the beginning lease number, or name and address number. If you wish to print labels for all leases or names & address leave this field blank.

 

ENDING LEASE # OR N/A # (7A)/ZZZZZZZ - Enter the ending lease number or name and address number. If you wish to print labels for all leases or names & addresses leave this field set at 'ZZZZZZZ'.

 

3.     Enter the desired data and press ENTER to display the next screen.

 

4.     The 'Date and Printer Information' screen will be displayed. Enter the desired information and press ENTER.


 

Top

 

Return to Master File Table of Contents

 

 

 

 

Cliff Buchanan - 915-550-3302