1143211_B20_Systems_Data_Manager_Training_Guide_Oct82 1143211 B20 Systems Data Manager Training Guide Oct82

1143211_B20_Systems_Data_Manager_Training_Guide_Oct82 1143211_B20_Systems_Data_Manager_Training_Guide_Oct82

User Manual: 1143211_B20_Systems_Data_Manager_Training_Guide_Oct82

Open the PDF directly: View PDF .
Page Count: 171

Download
Open PDF In Browser	View PDF

Burroughs

PRICED ITEM

Printed in U.S.A.

October 1982

1143211

Burroughs

B20 Systems
Data Manager

TRAINING GUIDE

PRICED ITEM

~----------------------------/
Printed in U.S.A.

October 1982

1143211

"The names used in this publication are not of individuals
living or otherwise.
Any similarity or likeness of the
names used in this publication with the names of any
individuals, living or otherwise, is purely coincidental and
not intentional."

Burroughs believes that the application package described in
this manual is accurate and reliable and much care has been
taken in its preparation.
However, no responsibility,
financial or otherwise, can be accepted for any consequences
arising out of the use of this material, inclu~ing loss of
profit, indirect, special or consequential damages. There
are
no warranties
which extend
beyond
the. program
s pe ci fica ti 0 n.
The customer should exercise care to assure that use of the
application package will be in full compliance with laws,
rules and regulations of the jurisdiction with respect to
which it is used.
The information contained herein is subject to change.
Revisions may be is sued fr om time to time to advise of
changes and/or additions.
Any comments or suggestions regarding this document should
be forwarded to Documentation, Systems Development Group,
Burroughs Corporation, 3519 West Warner Avenue, Santa Ana,.
CA, 92704.

TABLE

Q£

CONTENTS

INTRODUCT ION. • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • •
OBJECTIVES FOR TRAINING GUIDE....................

SECTION 1. OVERVIEW..................................

1-1

SECTION 2. FIRST STEPS IN CREATING PROGRAMS.........
CREATING AN APPLICATION DISK DIRECTORy...........
CREATING A PROGRAM LIBRARY.......................

2-1
2-1
2-1

SECTION 3. NAMELIST. (PROGRAM 1; PRELIMINARY PROGRAM)
FIELD DEFINITION FORM............................
CHANGING A DATA MANAGER PROGRAM..................
DMRUN MODULE.....................................
DMRUN FUNCTION·KEYS..........................
DMRUN INSTRUCTIONS...........................

3-1
3-5
3-11
3-14
3-15
3-16

SECTION 4. PRODUTIL.
(PROGRAM 2; FILE MAINTENANCE PROGRAM) •••••••••
DMRUN MODULE.....................................

4-1
4-12

·SECTION 5. STOCKINQ. (PROGRAM 3; INQUIRY PROGRAM) ••••

5-1

SECTION 6. PERIOD END.
(PROGRAM 4; FILE MAINTENANCE PROGRAM) •••••••••

6-1

SECTION 7. ISSUES.
(PROGRAM 5; REAL-TIME UPDATE PROGRAM) •••••••••

7-1

SECTION 8. PR-ENTRY. (PROGRAM 6; MAINTENANCE PROGRAM
FOR BATCH DATA ENTRY) •••••••••••••••••••••••••

8-1

SECTION 9. PR-UPDATE.
(PROGRAM 7; BA'OCH UPDATE PROGRAM) • • • • • • • • • • • • •

9-1

SECTION 10. PR-JOURNAL.
(PROGRAM 8; PURCHASES AND RECEIPTS JOURNAL) •••

10-1

SECTION 11. LOWSTOCK.

9; REPORT PROGRAM) ••••

11-1

SECTION 12. PRE-PRODLIST.
(PROGRAM 10; RUN-TIME UPDATE PROGRAM) •••••••••

12-1

SECTION 13. PRODLIST. (PROGRAM 11; REPORT PROGRAM) •••

13-1

SECTION 14. ICMENU. (PROGRAM 12; MENU PROGRAM) •••••••

14-1

(PROG~AM

iii

vii

APPENDIX A. DMCREATE AND DMRUN FUNCTION KEyS.........

A-I

APPENDIX B. PROGRAM OUTPUT...........................

B-1

INTRODUCTION
The purpose of this training guide is to teach experienced
applications programmers how to use the programming forms of
the B20 Data Manager.
By completing the sample programs,
you will learn how quickly you can create programs with Data
Manager.
Before you begin working through this guide, read Sections
1-4 of the Data Manager Programmer's Manual. Install the
Data Manager Development system on your B20 and become
familiar with the operational features of DMCREATE and
DMRUN.
This manual has several parts.
This introduction also
includes a specific statement of course objectives. Next is
an overview of Data Manager, with information on how to read
the instructions.
Following are step-by-step instructions
for creating 12 different programs using Data Manager.
These programs provide examples of some of the different
types of programs that you can create with B20 Data Manager,
such as file maintenance, batch update, run-time data entry,
and report programs.
At the end of the Guide are two Appendices.
Appendix A
contains
information
on Data Manager function
keys.
Appendix B contains the output of all of the Data Manager
programs in the guide, with the exception of the preliminary
progr am.
The programs in this guide pertain to a typical business
problem:
inventory control. Their purpose is to acquaint
you with the features of B20 Data Manager.
Other documentation which may be helpful to you includes:
•

B20 Data
1143195.

Manager

Capabilities

Manual,

form

•

B20 Data
1143203.

Manager

Programmer's

Manual,

form

•

B20 Operations, Part II, Learning
System Software, form 1148400.

to Use

the

B20 System
1148772.

Software

Operations

Guide,

form

~ ~

OBJECTIVES FOR
MANAGER TRAINING GUlpE

This
Training Guide has been written for experienced
applications
programmers
who are familiar
with data
processing concepts and with programming languages.
They
also should have same background in systems analysis and
design. B20 Data Manager is a programming facilitation tool
which will allow programmers to implement their applications
systems more quickly and efficiently.
The major objective of the Training Guide is therefore to
familiarize experienced programmers with the operation of
the Data Manager and with its programming forms by having
the programmer execute the steps and complete the forms to
create and run twel ve Data Manage·r programs.
More specifically, in completing the major objective of this
Training Guide, the programmer will:
1.

Create a Program Library.

Locate and use Data Manager function keys.

Use Field Helps and Form Helps.

List the various program types that can be created
with DMCREATE.

Change entries made in DMCREATE.

Delete entries made in DMCREATE.

Specify numeric and alphanumeric range checking in
DMCREATE.

Define fields in a record using DMCREATE.

Use both programmer-defined Field Descriptions and
Standard Field Descriptions in DMCREATE.

10.

Create the following types of fields:
a.

Mandatory Entry fields.

Allow Entry fields.

Include in Record fields.
vii

Fields having Field Duplication.

Fields having Automatic Increment.

11.

Create primary-key fields in DMCREATE.

12.

Create Help forms for the application-user.

13.

Use Data
together.

14.

Run programs using DMRUN.

15.

Use the Direct Program Select feature of DMRUN.

16.

Complete
DMCREATE programming
forms
following specific types of programs:

Manager

link

several

programs

for

the

A File Maintenance program for a master file.

An Inquiry program.

A simple Batch-Update program.

A Real-time Update program.

A File
entry.

A Batch Update program
product master file.

A simple Report program which lists
transactions in a transaction file.

A Report program which uses record selection.

A Run-time Data program.

A Report
program
which
uses
Run-time
parameters
to report selectively on the
product master file.

A Menu program.

Maintenance

program

for batch

which

data

updates

a
the

Once the programmers are familiar with the operation of
the Data Manager through completing the programs in the
Training Guide, they should then consult the Data
Manager Programmer's Manual for specific assistance in

viii

using Data Manager to implement
design.

programs of their own

SECTION

OVERVIEW

Programming with Burroughs B20 Data Manager is much faster
and easier than traditional programming.
Once you become
familiar with the Data Manager, you will be able to
implement many kinds of typical application programs in
minutes rather than days.
To use the Data Manager to implement your programming, you
need to be familiar with the operation of the Data Manager
and with its programming forms. The programs which you will
create using this Guide are sample programs designed to
acquaint you with Data Manager.
Several features have been included to help you as you
proceed through the Guide. Function Key information has
been included in Appendix A. In addition, if you have
questions on a programming form as you are working on it,
you may press the HELP key.
The first time you press the HELP key, DMCREATE displays an
explanation of the specific field you are working on. If
you press HELP again, in most cases you will see a general
explanation of the entire form.
On some of the shorter forms, the FIELD HELP and FORM HELPS
have been combined.
On these forms all information will
appear the first time you press the HELP key.
Then to
return from a Help form to a programming form, press the GO
key.
To enable you check your programs, output for each of the
programs (with the exception of the preliminary program) has
been included in Appendix B.
The. programs you are about to create present examples of a
typical Data Manager programming environment.
To give you
an idea of both the Data Manager programming environment and
of the Data Manager application user environment, these
programs were patterned after a sample inventory-control
system.

- I

As you create these programs, try to concentrate on ~ ~
Manager ~~ rather than on the inventory-control features
of
the programs.
First create the programs exactly
according to the instructions and take the time to run them
as a system.
You might then want to modify the system to
incorporate your own ideas and perhaps some additioQal
application features.
There is one warm-up program to introduce the Data Manager
Development system and eleven additional programs which make
up the inventory-control applications.
This sounds as if
you will be doing a great deal of programming, but the
entire system can usually be completed in less than a day.
Allow yourself plenty of time, however, since you will want
to run your programs as you complete them. By the time you
complete these programs, you will be thoroughly acquainted
with the Data Manager and its important features.
Here are the programs you will create:
1.

NAMELIST

This is the warm-up or introductory
program.
It is a file maintenance
utility program which is used only as
an
introduction
to the
DMCREATE
module.
It
is not
one of the
inventory-control programs.

PRODUTIL

A file maintenance utility for the
product master file (PRODUCTS). This
file 1S used to store static and
balance information for all products.

STOCKINQ

An
inquiry program which extracts
stock-on-hand and pr ice information
from the product master file.

PERIOD-END

A simple batch update program that
clears the period-to-date balances in
the product master file.

ISSUES

A program which allows an operator to
enter stock issue transactions (sales)
and immediately update the product
master file balances to reflect each
transaction.

1 - 2

PR-ENTRY

A maintenance program used for batch
data entry of purchase and receipt
transactions.
This program creates a
transaction file called PRTRANS.

PR-UPDATE

Another, more typical batch update
program
which updates the product
master file according to the purchase
and receipt transactions in PRTRANS.

PR-JOURNAL

A
simple
report which
transactions in PRTRANS.

LOWSTOCK

A more complicated report which prints
a "buyer's guide" of items in the
PRODUCTS
file that
have
on-hand
balances
less than their
reorder
points.

lists

the

10.

PRE-PRODLIST

A run-time data program which allows
the operator to enter values to be
used by the PRODLIST report.

11.

PRODLIST

A
report
which
uses
run-time
parameters to report selectively on
the product master file.

12.

ICMENUI

A menu program which is the initial
menu
for your
Inventory
Control
Program Library.
It allows you to
access all of the inventory-control
programs (Programs 2-12) through the
Data Manager Menu interface.

You
will create these programs
by following
simple
step-by-step instructions. An example of the format of the
instructions is given below.
This is only an example, so
just read through the following material. Do not make any
entries here.
You will actually begin to create your
programs in SECTION 2.

1 - 3

FORMAT OF INsrRUCTIONS
1.

The first information given is the name of the
DMCREATE form on which you are entering data.
Example:

MAINTENANCE PROGRAM SECTIONS

From time to time, some information which will
help you understand an entry will be given before
the actual prompt.
2.

The second item, which is indented under the name
of the form, is the prompt. The prompt tells you
what data is requested.
Example:

The third item of information, given next to the
prompt, is the entry. This is the actual data you
are to enter.
Example:

SECTION

"1 "

The last item of information, given to the right
of the data to enter, is the instruction on which
key to press to move to the next entry.
Example:

press GO
SAMPLE ENTRY

Here is a sample entry, with the parts labeled:
MAINTENANCE PROGRAM SECTIONS
[The entry above is the name of the form on which you
are working. ]

1 - 4

If this form is not on the screen, see the Programmer's
Manual.
[The entry above is a typical comment.
SECTION
. (Prompt)

(pres s GO)

(Data to enter)

(Key to use)

1 - 5

SECTION .2.
FIRST STEPS IN CREATING PROGRAMS NIX[

DATA MANAGER

The
preceding information explained how the invento~y
control programs are organized and how the material 1S
presented.
In the section which follows, you will actually
complete Data Manager forms.
To create programs with B20 Data Manager, you first need to
create an Application Disk Directory and a Program Library.
The following instructions will show you how to create an
Application Disk Directory and a Program Library.
Follow
the instructions and enter data on the DMCREATE forms when
you are directed to do so.
CREATING AN APPLICATION

CATEGORY

(press RETURN)

STD DESCRIPTION

(press RETURN)

Where you are not given specific data to enter, use the
system defaults.
Use the RETURN key to tab through
fields where you do not need to enter data.
lvlANDATORY ENTRY

(press RETURN)

Press
the
RETURN
key
to move
to the
FIELD
DUPLICATION/INCREMENT entry. If you are not sure what
field duplication is, press the HELP key.
FIELD DUP/INCREMENT

(press RETURN)

In the RANGE CHECKING entry, you indicate that you want
the first set of ranges that you entered on the NUMERIC
RANGE TABLE to be used as a range check on the CATEGORY
field.
RANGE 1

(press GO)

FIELD DEFINITION 3
Note that you need
DEFINITION 3.

to make

only

2 entries

on FIELD

FIELD NAME

BIN LOCATION

(press RETURN)

STD DESCRIPTION

(press GO)

FIELD DEFINITION 4
4 -

FIELD NAME

DESCRIPTION

(pres s RETURN)

STD DESCRIPTION

(pr es s RETURN)

MANDATORY ENTRY

(press GO)

FIELD DEFINITION 5
These next entries cause a blank line to appear on the
STANDARD FO~l for this program.
FIELD NAME

Leave blank

(press RETURN)

STD DESCRIPTION

(press RETURN)

INCLUDE IN RECORD

(press RETURN)

ALLOW ENTRY

(press GO)

FIELD NAME

ON HAND

(press RETURN)

STD DESCRIPTION

(press RETURN)

MANDATORY ENTRY

(press GO)

ON ORDER

( pr es s RETU RN)

FIELD DEFINITION 6

FIELD DEFINITION 7
FIELD NAME

4 - 6

STD DESCRIPTION

(press GO)

FIELD NAME

REORDER POINT

(press RETURN)

SlrD DESCRI PT ION

(pr es s RETURN)

HANDATORY ENTRY

(press GO)

FIELD DEFINITION 8

FIELD DEFINITION 9
STANDARD
DESCRIPTION
14 is
a special
STANDARD
DESCRIPTION which causes automatic date validation to
be applied to this field.

FIELD

FIELD NAME

DELIVERY DATE

( pr es s RETU RN)

STD DESCRIPTION

(press GO)

DE~INITION

These entries cause a blank line on the STANDARD
for this program.

FORM

FIELD NAME

Leave blank

(press RETURN)

STD DESCRIPTION

(press RETURN)

4 - 7

INCLUDE IN RECORD

(pr es s RETURN)

ALLOW ENTRY

(press GO)

FIELD NAME

UNIT

(press RETURN)

STD DESCRIPTION

(pr es s RETURN)

MANDATORY ENTRY

(press GO)

FIELD NAME

PRICE

(pr es s RETURN)

STD DESCRIPTION

(press RETURN)

RANGE 1

(press GO)

FIELD NAME

REPLACEMENT COST

(press RETURN)

STD DESCRIPTION

(pr ess RETURN)

MANDATORY ENTRY

(press RETURN)

RANGE 1

(press GO)

FIELD DEFINITION 11

FIELD DEFINITION 12

FIELD DEFINITION 13

4 - 8

FIELD DEFINITION 14
FIELD NAME

DISCOUNr CODE

(press RETURN)

STD DESCRIPTION

(pr es s RETURN)

RANGE 1

(press GO)

FIELD NAME

Leave blank

(pr es s RETURN)

STD DESCRIPTION

(press RETURN)

INCLUDE IN RECORD

(press RETURN)

ALLOW ENTRY

(press GO)

FIELD NAME

LAST ISSUE DATE

(press RETURN)

STD DESCRIPTION

(press GO)

FIELD NAME

UNIT SALES PTD

(press RETURN)

STD DESCRIPTION

(press GO)

FIELD DEFINITION 15

FIELD DEFINITION 16

FIELD DEFINITION 17

4 -

FIELD DEFINITION 18
FIELD NAME

$ SALES PTD

( pr es s RE TURN)

STD DESCRIPTION

(press GO)

FIELD NAME

$ COST PTD

(press RETURN)

STD DESCRIPTION

(press GO)

FIELD DEFINITION 19

FIELD DEFINITION 20
You have completed all the entries that you need for
this program.
You should now return to the Program
Section menu.
FI:E:LD NAME

Leave blank

(press FINISH)

MAINTENANCE PROGRAM SECTIONS
Unless you need to change any of your specifications
for this program, you should return to the Programming
Activity Selection menu.
SECTION

No change

CREATE/MAINTAIN DM PROGRAM
LIBRARY AND PROGRAM INFORMATION

4 - 10

(press FINISH)

LIBRARY FILE ID:

No change

(press FINISH)

PROGRAMMING ACTIVITY SELECTION
You have now completed the second program and may run
this program using DMRUN.
ACTIVITY NUMBER

(press GO)

4 - 11

DMRUN MODULE
BURROOGHS B20 DATA MANAGER
LIBRARY SELECTIONS
You will again run your
Program Selection feature.

program

using

the

Direct

(press GO)

PROGRAM TYPE

(press RETURN)

LIBRARY FILE ID:

XXXLIB

(pr es s RETURN)

PROGRAM NAME

PRODUTIL

(press GO)

ENTER SELECTION

DIRECT PROGRAM SELECTION

The next form is the data entry form that you have just
created with your file maintenance program. Practice
entering some data on the form.
You should enter at
least five products into your data base. You will need
a few records in the PRODUCTS file in order to test
your other programs. Entering these records will also
allow you to see how system features work. Some of the
system features that you may observe here include
MANDATORY ENTRY and RANGE CHECKING.
Use RETURN to move down the page.
When you have
entered all the data you want on the form, press GO.
Pressing GO will give you another form.
When you have finished entering data, return to the
Library Selections menu by pressing the FINISH key.
Then press FINISH once again to return to DMCREATE.

BURROUGHS B20 DATA MANAGER
4 - 12

LIBRARY SELECTIONS
You should now return to DMCREATE.
ENTER SELECTION

Leave blank

4 - 13

(pr es s FIN! SH)

SECTION
(PROGRAM

STOCKINO

INOUIRY PROGRAM)

The purpose of the next section is to introduce you to the
Data Manager programming forms for an Inquiry program.
STOCKINQ is a short program which extracts ·stock-on-hand and
price information from the master file.
The procedures for creating the inquiry program are similar
to the procedures you followed to make the two earlier
programs.
Once again, you will be given only the data you need to
enter.
Use RETURN key to skip over fields in which you do
not need to make entries.
(If you have not already done so, begin the DMCREATE
program. In the lighted COMMAND field, enter: DMCREATE.)
When
the DMCREATE PROGRAMMING ACTIVITY SELECTION
appears, begin creating your inquiry program.

5 - 1

PROGRAMMING ACTIVITY SELECTION
ACTIVITY NUMBER:

No change

(press GO)

CREATE/MAINTAIN DM PROGRAM
LIBRARY AND PROGRAM INFORMATION
L'IBRARY FI LE ID:

XXXLIB

(press REWRN)

PROGRAM NAME:

STOCKINQ

(press GO)

PROGRAM TYPE
PROGRAM TYPE SELECTION:4

(press GO)

INQUIRY PROGRAM SECTIONS
SECTION

No change

(press GO)

PRIMARY FILE RECORD DESCRIPTION PROGRAM
When you created your maintenance program, PRODUTIL,
you defined the disk file id and record description for
the PRODUCTS file. This inquiry program also needs
that information.
When you create an inquiry, rather
than
re-enter information
that is already in a
maintenance program, enter the name of the maintenance
program only.
DMRUN will then extract the required
information from the maintenance program at run-time.
PROGRAM NAME:

PRODUTIL

5 - 2

(press GO)

SECONDARY FILES RECORD DESCRIPTION PROGRAMS
Leave blank

(press GO)

FORMS SELECTION
SELECTION NUMBER:

STANDARD FORM
FORM HEADING
HEADING

STOCK/PRICE INQUIRY (press GO)

NUMERIC RANGE TABLE
Since neither numeric nor alphanumeric ranges are used
in this program, use F3 to skip to the next program
section.
RANGE I

Leave blank

(press F3)

STOCK NIJrtlBER

(press RETURN)

FIELD DEFINITION I
FIELD NAME

The SOURCE entry tells DMRUN that you want information
displayed in a field. This entry also tells the origin
of that information.
Because STOCK NUMBER is the first field we defined in
the primary (nAif) file, we use the SOURCE code AI. Al
refers to afield in a record.
Therefore it is a
5 - 3

special kind of variable called a Field Idehtifier. In
this
program, all your SOURCE entries are Field
Identifiers.
SOURCE

(press RETURN)

At least one primary
ENTRY field.

key field should

be a MANDATORY

MANDATORY ENTRY

(press RETURN)

PRIMARY KEY

(press GO)

FIELD NAME

DESCRIPTION

(press RETURN)

SOURCE

("press GO)

FIELD NAME

ON HAND

(press RETURN)

SOURCE

(pr es s GO)

FIELD NAME

PRICE

(press RETURN)

SOURCE

Al2

(press GO)

FIELD DEFINITION 2

FIELD DEFINITION 3

FIELD DEF!NITION 4

5 - 4

FIELD DEFINITION 5
FIELD NAME

DISCOUNr CODE

(press RETURN)

SOURCE

Al4

(press GO)

FIELD DEFINITION 6
You have completed
inquiry program.
FIELD NAME

all the

entries

needed

for the

Leave blank

(press FINISH)

No change

(press FINISH)

INQUIRY PROGRAM SECTIONS
SECTION

CREATE/MAINTAIN DM PROGRAM
LIBRARY AND PROGRA~ INFORMATION
LIBRARY FILE ID:

No change

5 - 5

(pr es s FINI SH)

PROGRAMMING ACTIVITY SELECTIONS
You may now test your inquiry program, STOCKINQ.
Use
the Direct Program Selection feature of the LIBRARY
SELECTION menu of DMRUN to start your program.
When
you have finished testing your program, press FINISH to
return to the LIBRARY SELECTION menu. Press FINISH
again to return to DMCREATE.
ACTIVITY NUMBER

(press GO)

5 - 6

SECTION
(PROGRAM

..4J..

PERIOD-END

BATCH UPDATE PROGRAM)

The purpose of this section is to introduce you to the Data
Manager programing forms for a batch-update program. This
program is a simple batch update program that clears the
period-to-date balances in the product master file.

6 - 1

PROGRAMMING ACTIVITY SELECTION
ACTIVITY NUMBER

No change

(pr es s GO)

CREATE/MAINTAIN DM PROGRAM
LIBRARY AND PROGRAM INFOmlATION
LIBRARY FILE ID:

XXXLIB

(press RETURN)

PROGRAM NAME:

PERIOD-END

(press GO)

PROGRAM TYPE
This 'is a batch update program.
PROGRAM TYPE

(press GO)

BATCH UPDATE PROGRAM SECTIONS
SECTION

No change

(press GO)

PRIMARY FILE RECORD DESCRIPTION PROGRAM
PROGRAM NAME:

PRODUTIL

(press GO)

SECONDARY FILES RECORD DESCRIPTION PROGRAMS
PROGRAM NAME

Leave blank

6 - 2

(press GO)

INITIAL FUNCTION
Leave blank

STATEMENT 1

(pres s GO)

UPDATE FUNCTION
In
your last program, STOCKINQ,
you used Field
Identifiers to tell DMRUN the SOURCE of a data field.
Here you are using Field Identifiers to tell DMRUN
which fields to update in DM programs. References to
data fields in files are made by Field Identifiers.
NOTE
The character "I" should be typed
as an exclamation pOint.
#

STATEMENT

A16

010199 IRESET DT

(press RETURN)

A17

0 ! UNITS PTD

(press RETURN)

A18

0 !SALES PTD

(press RETURN)

A19

0 !CaST PTD

(press GO)

PROGRAM/UTILITY LINKAGE
PROG/FILE NAME

Leave blank

BATCH UPDATE PROGRAM SECTIONS

6 - 3

(pr es s FINI SH)

SECTION

No change

(pr es s FINISH)

CREATE/MAINTAIN DM PROGRAM
LIBRARY AND PROGRAM INFORMATION
LIBRARY FILE ID

No change

6 - 4

(pr es s FINI SH)

PROGRAMMING ACTIVITY SELECTION
You may now test your batch update program, PERIOD-END.
If you do not have any balances in your PRODUCTS file
for the fields which PERIOD-END updates, you might want
to run the PRODUTIL program (Program 2) again and make
some entries for those fields which are updated by
PERIOD-END.
When you run PERIOD-END, DMRUN displays the message:
"DATA MANAGER IS PROCESSING YOUR SELECTION." DMRUN
displays this message during Batch Update and Report
programs. This message lets you know that your program
is running.
When you r prog r am ends, Dl-:1RUN dis plays the LIBRARY
SELECTION menu. If there is no error message on the
menu, your program has terminated normally. From the
LIBRARY SELECTION menu, you can either press FINISH to
return to the DMCREATE program, or you can run PRODUTIL
again to check the results of the update.
ACTIVITY NUMBER

6 - 5

(press GO)

SECTION
(PROGRAM

ISSUES

REAL-TIME UPDATE PROGRAM)

The purpose of this program is to introduce you to the Data
Manager programming forms for a real-time update program.
This program allows an operator to enter stock issue
transactions (sales)
and immediately update the product
master file balances to reflect each transaction.
The ISSUES program is similar ,to the programs you have
elready created, except it uses secondary files and Function
~tatements.

7 - 1

PROGRAMMING ACTIVITY SELECTION
ACTIVITY NUMBER:

No change

(pres s GO)

CREATE/MAINTAIN DM PROGRAM
LIBRARY AND PROGRAM INFORMATION
LIBRARY FILE ID:

XXXLIB

(press RETURN)

PROGRAM NAME:

ISSUES

(press GO)

PROGRAM TYPE
You are creating a real-time update program.
PROGRAM TYPE

(press GO)

)

REAL TIME UPDATE PROORAM SECTIONS
SECTION

No change

(press GO)

TRANSACTION LOG
If you wanted DMRUN to create a log of some or all
fields involved in inventory issue transactions, you
could enter the name of the log file here. Creating a
transaction log is an optional feature which you do not
need for this program.
FILE ID

Leave blank

7 - 2

(press GO)

SECONDARY FILES RECORD DESCRIPTION PROGRAMS
In this entry, you specify the DM maintenance programs
which define the file you want to update.
FILE

PROGRAM NAME

PRODUTIL

(press RETURN)

Entering a "yn under CRITICAL tells DMRUN you want the
transaction halted and an error message displayed if an
attempt to access this file is unsuccessful.
CRITICAL

Y (default)

(press GO)

INVENTORY ISSUES

(press GO)

FORM SELECTION
SELECTION NUMBER

STANDARD FORM
FORM HEADING
HEADING

NUMERIC RANGE TABLE
As in the Inquiry program,
Field Definition section.
RANGE I

Leave blank

7 - 3

you use F3 to skip to the

(press F3)

FIELD DEFINITION 1
Once again you will be given only the data you need to
enter. Use RETURN key to "tab through" fields in which
you do not make an entry.
FIELD NAME

STOCK NUMBER

(press RETURN)

STD DESCRIPTION

Leave blank

(press RETURN)

For an explanation
HELP.

of the

DESCRIPTION

entry,

press

DESCRIPTION

8.0

(pr es s RETU RN)

MANDATORY ENTRY

(press GO)

FIELD NAME

DESCRIPTION

( pr es s RETU RN)

STD DESCRIPTION

(press RETURN)

FIELD DEFINITION 2

You want the product description to appear on the form,
but you don't need to save it for update purposes.
INCLUDE IN RECORD

(press RETURN)

The product description is displayed to provide visual
verification
that the correct product number was
entered.
You don't want the application user to be
able to change the de scr iption. An "N" entry here will
tell DMRUN not to position the cursor in this field or
allow anything to be entered.

7 - 4

ALLOW ENTRY

(press RETURN)

This entry indicates that the information for this
FIELD DEFINITION is found in the fourth field of the
PRODUCTS file, (secondary file B)
SOURCE

(press GO)

FIELD DEFINITION 3
purpose
of this field
is also for visual
The
verification only. You therefore use the INCLUDE IN
RECORD and ALLOW ENTRY parameters in the same way as in
FIELD DEFINITION 2.
FIELD NAME

UNIT

(press RETURN)

STD DESCRIPTION

(press RETURN)

INCLUDE IN RECORD

(press RETURN)

ALLOW ENTRY

( pr es s RETU RN)

SOURCE

Bll

(press GO)

FIELD NAME

QUANTITY SOLD

(press RETURN)

STD DESCRIPTION

(press RETURN)

MANDATORY ENTRY

(press GO)

FIELD DEFINITION 4

7 - 5

FIELD DEFINITION 5
Here you are defining a field which will obtain default
data from the twelfth field of the "B" file. You want
to save the en try in this field fo r upda te purposes, so
leave
INCLUDE
RECORD
= Y. You also want the
application user to be able to override the default
price, so leave ALLOW ENTRY = Y.
FIELD NAME

PRICE

(press REWRN)

STD DESCRIPTION

(press RETURN)

MANDATORY ENTRY

(press RETURN)

SOURCE

B12

(press GO)

FIELD DEFINITION 6
FIELD NAME

TRANS DATE

(press RETURN)

STD DESCRIPTION

(press RETURN)

MANDATORY ENTRY

(press REWRN)

When you run this program, notice that the date you
enter on the first form will appear as a default each
time the form is repeated.
It will remain the same
until you change it.
FIELD DUP/INCREMENT

(press REWRN)

INCREMENT AMOUNT

No change

(press F3)

PRIMARY FILE FIELDS USED FOR
7 - 6

SECONDARY FILE KEY - FILE B
The next entry asks you which field(s) in this program
should be used to compose a key for secondary file B.
FIELD NUMBER

(press GO)

Leave blank

(press GO)

INITIAL FUNCTION
STATEMENT 1

REPEATING FUNCTION
In the following entries, you specify the Function
Statements that you want executed to do the real-time
update.
(A refers to the fields in this program, B to the
secondary
file, and P to the Program
registers
available to the program for temporary storage.
The
information after the "!" is a comment which explains
the calculation further.)
NOTE
The character "I" should be typed
as an exclamation point.
STATEMENT 1

B6=B6-A4 IDEDUCT ISSUE
( pr es s RE TURN)

STATEMENT 2

B17=B17+A4 IPTD UNITS
( pr es s RE TURN)

7 - 7

STATEMENT 3

Pl=A4*A5 !SALES EXTEN •
(pr es s RETURN)

STATEMENT 4

B18=B18+Pl !PTD SLS
(press RETURN)

STATEMENT 5

P2=A4*B13 !COST EXTEN.
(pr es s RE TURN)

STATEMENT 6

B19=B19+P2 !PTD COST
(press RETURN)

STATEr1ENT 7

B16=A6 !TRANS DATE
(press GO)

PROGRAM/UTILITY LINKAGE
You do not need
program •
PROG/FILE NAME

to make

any

Leave blank

entries

for this

(press FINISH)

REAL TIME UPDATE PROGRAM SECTIONS
SECTION

No change

7 - 8

(press FINISH)

CREATE/MAINTAIN LIBRARY PROGRAM
LIBRARY AND PROGRAM INFORMATION
No entry

(press FINISH)

PROGRAMMING ACTIVITY SELECTION
You are now ready to run your program using DMRUN.
This program references the PRODUCTS file as a critical
secondary file.
Therefore you will be able to enter
transactions only for those products you already added
to that file when you ran your PRODUTIL program. First
use DMRUN to run the ISSUES program.
Enter a few
transactions with your program. Then run your PRODUTIL
program again (using DMRUN) to make sure that the
balances are being updated correctly. If not, you can
easily
return
to
DMCREATE
and
correct
your
specifications for this program.
ACTIVITY

(press GO)

7 - 9

SECTION

PR-ENTRY

(PROGRAM ~ MAINTENANCE PROGRAM
FOR BATCH DATA ENTRY)

As you create the following program, you will learn how to
make a file maintenance program which creates a transaction
file.
The following program is a file maintenance program
used
for batch data entry
of purchase
and receipt
transactions.
This program creates a transaction file
called PRTRANS.
This program is similar to the file maintenance program
you've created before, except it uses a secondary file. It
also
uses range checking and Function Statements for
additional transaction validation.
By now you are familiar with the RETURN, GO, UP ARROW, and
FINISH keys. Therefore in succeeding programs, you will no
longer be given instructions on which key to press. If you
have problems, refer to Appendix A of this manual.
If you find yourself on the wrong form once you are past the
PROGRAM SECTIONS menu, press FINISH to return to that menu
and then select the section in which you had the problem.
If necessary, you may also start the whole PROGRAM CREATE
activity over. This will enable you to correct or revise
your entries.

8 - 1

PROGRAMMING ACTIVITY SELECTION
ACTIVITY NUMBER:

No change

CREATE/MAINTAIN DM PROGRAM
LIBRARY AND PROGRAM INFORMATION
LIBRARY FILE ID:

XXXLIB

PROGRAM NAME:

PR-ENTRY

PROGRAM TYPE
This is a file maintenance program.
PROGRAM TYPE:

MAINTENANCE PROGRAM SECTIONS
SECTION

No change

PRIMARY DATA FILE
This is the transaction file created by this program.
Enter your initials in place of XXX.
PRIMARY FILE ID:

XXXPRTRANS

FILE MANAGEMENT
8 - 2

SELECTION NUMBER:

SECONDARY FILES RECORD DESCRIPTION PROGRAMS
The program which defines the secondary file here is
the product master file maintenance program, PRODUTIL.
For the other entry, CRITICAL, use the system default
of nyn.
FILE

PROGRAM NAME

PRODUTIL

CRITICAL

Y (default)

FORM SELECTION
SELECTION NUMBER

STANDARD FORM
FORM HEADING
HEADING

INVENTORY PURCHASE/RECEIPT TRANSACTIONS

NUMERIC RANGE TABLE
In most of your previous programs, you have been using
F3 here to skip to the next section.
This time you
want to enter some alphanumeric ranges on the next
form.
To see the next form in the Ranges section, use
GO this time.

8 - 3

Leave blank

RANGE 1

ALPHANUMERIC RANGE TABLE
RANGE i

LOWER

UPPER

FIELD DEFINITION 1
FIELD NAME

TRANSACTION NBR

STD DESCRIPTION

MANDATORY ENTRY

PRIMARY KEY

This time, instead of just duplicating your TRANSACTION
NBR entry on each form, DMRUN will add 1 to your last
TRANSACTION NBR each time you add a record to the
transaction file. Changing previous records will not
cause the TRANSACTION NBR to be incremented.
FIELD DUP/INCREMENT
INCREMENT AMOUNT

Y
1

8 -

FIELD DEFINITION 2
FIELD NAME

TRANS TYPE (P,R)

STD DESCRIPTION

MANDATORY ENTRY

FIELD DUP/INCREMENT

RANGE CHECKING
RANGE 1

RANGE 2

FIELD DEFINITION 3
FIELD NAME

Leave blank

STD DESCRIPTION

INCLUDE IN RECORD

ALLOW ENTRY

FIELD DEFINITION 4

8 - 5

FIELD NAME

STOCK NUMBER

STD DESCRIPTION

Leave blank

DESCRIPTION

8.0

MANDATORY ENTRY

FIELD DEFINITION 5
This field and the next one are used for visual
verification of the STOCK NUMBER, just as in the ISSUES
program.
FIELD NAME

DESCRIPTION

STD DESCRIPTION

INCLUDE IN RECORD

ALLOW ENTRY

SOURCE

FIELD DEFINITION 6
FIELD NAME

UNIT

8 - 6

STD DESCRIPTION

INCLUDE IN RECORD

ALLOW ENTRY

SOURCE

Bll

FIELD DEFINITION 7
This field definition
standard form.

provides

FIELD NAME

Leave blank

STD DESCRIPTION

INCLUDE IN RECORD

ALLOW ENTRY

a blank

line on the

FIELD DEFINITION 8
This field definition will provide a sub-heading on the
standard
form.
The application user should make
entries for the next two fields only if a purchase
transaction is being entered.
FIELD NAME

**PURCHASES**

STD DESCRIPTION

8 - 7

INCLUDE IN RECORD

ALLOW ENTRY

FIELD DEFINITION 9
FIELD NAME

QTY ORDERED

STD DESCRIPTION

Your n~xt entry will cause DMRUN to alter the field
sequence conditionally. If the application user makes
a blank entry for QTY ORDERED, the cursor will skip
automatically to FIELD 13, QTY RECEIVED.
This saves
the application user from having to tab through both
the QTY ORDERED and the DELIVERY DATE fields to enter a
receipt transaction.
SKIP TO FIELD

FIELD DEFINITION 10
,FIELD NAME

STD DESCRIPTION

DELIVERY DATE

FIELD DEFINITION 11

8 - 8

This field definition also creates a blank line.
FIELD NAME

Leave blank

STD DESCRIPTION

INCLUDE IN RECORD

ALLOW ENTRY

FIELD DEFINITION 12
FIELD NAME

**RECEIPTS**

STD DESCRIPTION

INCLUDE IN RECORD

ALLOW ENTRY

FIELD DEFINITION 13
FIELD NAME

QTY RECEIVED

STD DESCRIPTION

FIELD DEFINITION 14
8 - 9

FIELD NAME

UNIT COST

STD DESCRIPTION

FIELD DEFINITION 15
This FIELD DEFINITION reserves space in the record for
the transaction date.
FIELD NAME

Leave blank

STD DESCRIPTION

This is the last FIELD DEFINITION here.
ALLOW ENTRY

(press GO)

Leave blank

(press F3)

FIELD DEFINITION 16
FIELD NAME

PRIMARY FILE FIELDS USED FOR
SECONDARY FILE KEY - FILE B
FIELD NUMBER

INITIAL FUNCTION
Leave blank
8 - 10

REPEATING FUNCTION

The
first statement is a conditional
branch to
statement 7 if the transaction type (the second field
defined in this program) contains a P.
NOTE

The character "1" should be typed as an
exclamation point.
STATEMENT
1

IF A2 EQ "P" 7 1IF PURCH

IVALIDATE RECEIPT

IF A9 NE 0 12 !QTY ORO

IF AI0 NE 0 12 !DLVY DT

GOTO 10 IGOOD TRANS

!VALIDATE PURCHASE

IF A13 NE

14 IQTY RCD

IF A14 NE

14 ICOST

IGOOD TRANSACTION

8 - 11

A15=Xl lINSERT DATE

EXIT !UPDATE PRTRANS

This statement will cause a standard error message to
appear on the screen.
The error message simply tells
the application user that "Validation Error 1" had
occurred.
In this case, Error 1 means that the
application user was processing a receipt, but made an
entry for Quantity Ordered or Delivery Date. Since
these fields only apply to purchases, the transaction
was not entered correctly.
You would normally create a Help form to explain this
error to the application user. However, since you are
the only user of this practice program, just remember
what this error indicates. Error 2 indicates that the
same situation has occurred in a purchase transaction.
12

ERROR 1 !INVALID RECPT

EXIT lREENTER TRANS

ERROR 2 !INVALID PURCH

PROGRAM/UTILITY LINKAGE
PROG/FILE NAME Leave blank

MAINTENANCE PROGRAM SECTIONS
SECTION

No change

8 - 12

CREATE/MAINTAIN
LIBRARY AND PROGRAM INFORMATION
LIBRARY FILE ID

No change

PROGRAMMING ACTIVITY SELECTIONS
You have now completed this program and may run it by
using
DMRUN.
When you ran the real-time update
program, ISSUES, you could only complete transactions
for STOCK NUMBERS which you had previously entered in
the PRODUCTS file.
Similarly, when you run this
program' you also can only complete transactions for
STOCK NUMBERS which you have previously entered in the
PRODUCTS file.

8 - 13

SECTION

PR-UPDATE

(PROGRAM 2L BATCH UPDATE PROGRAM)

The next program introduces you to the procedures for
creating a more typical batch update program. This program
updates the product master file according to the purchase
and receipt transactions in PRTRANS, the transaction file'
which you created in PROGRAM 6.

9 - 1

PROGRAMMING ACTIVITY SELECTION
ACTIVITY NUMBER:

No change

CREATE/MAINTAIN
LIBRARY AND PROGRAM INFORMATION
LIBRARY NAME:

XXXLIB

PROGRAM NAME:

PR-UPDATE

PROGRAM TYPE
PROGRAM TYPE:

BATCH UPDATE PROGRAM SECTIONS
SECTION

No change

PRIMARY FILE RECORD DESCRIPTION PROGRAM
PROGRAM NAME:

PR-ENTRY

Later you may want to change the next entry to Y. For
test purposes, however, you should enter an N as
indicated.
This will permit you to run this program
more than once without entering more transactions. You
also will need your PRTRANS file for the next program.
Enter N here.
DELETE PRIMARY FILE
AT END OF UPDATE? N
9 - 2

SECONDARY FILES RECORD DESCRIPTION PROGRAMS
FILE

PROGRAM NAME

PRODUTIL

CRITICAL

Y (default)

PRIMARY FILE FIELDS USED FOR SECONDARY FILE KEY - FILE B
This entry tells DMRUN that the key to secondary file B
is composed of only the fourth field in the primary
file.
FIELD NUMBER 4

INITIAL FUNCTION FUNCTION
STATEMENT 1

Leave blank.

UPDATE FUNCTION
The Function Statements below will be executed once for each
transaction in the primary file, PRTRANS.
For a purchase
transaction, the ON ORDER field in PRODUCTS will be updated.
The DELIVERY DATE field in PRODUCTS will also be replaced by
the DELIVERY DATE field from PRTRANS if it was entered in
the transaction.
NOTE
The character "I" should be typed as an
exclamation point.

9 - 3

STATEMENT

IF A2 EQ "R" 6 !RECEIPT

B7=B7+A9 ION ORDER

IF AIO EQ 0 5 IDT=O

B9=AIO IDELIVERY DT

EXIT

B6=B6+A13 ION HAND

B7=B7-A13 ION ORDER
8

B13=A14 I COST

PROGRAM/UTILITY LINKAGE
You
have now made all the required
PR-UPDATE. Use the FINISH key, as before,
the Programming Activity Selection menu.
test your program.
Afterward, you can
again to check the results of the update.

9 - 4

entries for
to return to
You may then
run PRODUTIL

SECTION
(PROGRAM

PURCHASES

PR-JOURNAL

ANQ

RECEIPTS JOURNAL)

This section introduces you to the Data Manager programming
forms for a report program.
The PURCHASES AND RECEIPTS
JOURNAL program produces a simple report which lists the
transactions in PRTRANS, the transaction file which you
created with PR-ENTRY.
To

see the output for this report, please refer to Appendix

Because the forms fo"r a report are slightly different from
the forms for the other programs you have been working on,
instructions on key use are given again in this program.

10 - 1

PROGRAMMING ACTIVITY SELECTION
ACTIVITY NUMBER:

No change

(press GO)

CREATE MAINTAIN PROGRAM
LIBRARY AND PROGRAM INFORMATION
LIBRARY FILE ID

XXXLIB

(press RETURN)

PROGRAM NAME:

PR-JOURNAL

(press GO)

PROGRAM TYPE
This is a report program.
PROGRAM TYPE:

(press GO)

No change

(press GO)

REPORT PROGRAM SECTIONS
SECTION

INPUT FILE RECORD DESCRIPTION PROGRAMS
After entering the program name for the input file
record description, PR-ENTRY, use the system defaults
for the other entries on this form.
FILE

PROGRAM NAME

PR-ENTRY

:LO - 2

(press GO)

SORT SPECIFICATIONS FOR CONTROL FILE
FIELD NUMBER

Leave blank

(press GO)

OUTPUT SPECIFICATIONS
If you don't have a printer on your system, you should
change the Output Device to 3 for Screen. If you have
a B22, you will then see the entire report normally
formatted.
If you have a B2l, one line of the report
will take up two lines on the screen.
The default
value, Spooler, will work whether or not you have the
spooler installed.
PHYSICAL PAGE SIZE No change

(press GO)

PRIMARY FILE RECORD SELECTION
STATEMENT 1

Leave blank

(press GO)

REPORT TEXT
In the following table, you provide the headings which
will appear on the report.
HEADING OR MESSAGE
There are 3 spaces between B 20 and D A T A.
01

B 2 0

MANAGER

D A T A

10 - 3

(press RETURN)
(press RETURN)

PAGE

(press RETURN)

INVENTORY

(press RETURN)

CONTROL SYSTEM

(press RETURN)

PURCHASES AND

(press RETURN)

RECEIPTS JOURNAL

(press RETURN)

There are 3 spaces between TRANS and TRANS.
one space between TRANS and DT.
008

TRANS

TRANS DT

There is

(press RETURN)

There are 3 spaces between TYPE and STOCK and one space
between STOCK and NBR.
STOCK NBR

(press RETURN)

TYPE

010

ORDER QTY

(press RETURN)

011

RECEIPT DT

(press RETURN)

012

QTY RECEIVED

(pr es s RETURN)

013

UNIT COST

(press GO)

REPORT HEADER OUTPUT ITEMS
SOURCE

Leave blank

PAGE HEADER OUTPur ITEMS
10 - 4

(press F3)

Your entries on the next forms define output items that
will appear at the top of each page of the report.
To complete the entries on the following form, you need
to use the RETURN key to "tab through" each field
(whether you make an entry in that field or not) •

Output Item 1
Xl refers to the Data Manager "X"
register contains the system date.

This

SOURCE

(press RETURN)

PRINT pas

(press RETURN)

Output Item 2
Rl refers to the first of your Report text entries.
This one contains the first part of the report title,
B 2 0
D A T A.
SOURCE

(pr es s RE TURN)

PRINT pas

(pr ess RETURN)

Output Item 3
R2 contains MAN AGE R.
SOURCE

( pr es s RE TURN)

PRINT pas

(pr es s RETURN)
10 - 5

Output Item 4
R3 contains page.
SOURCE

(press RETURN)

PRINT POS

(press RETURN)

Output Item 5
PI refers to program register 1, which you use to keep
a page count.
SOURCE

(press RETURN)

PRINT POS

(press RETURN)

OUTPUT DESC

2.0

(press RETURN)

LINE ADV

(press RETURN)

Output Item 6
Output items 6 and 7 make up the second
report title, INVENTORY CONTROL SYSTEM.

line of the

SOURCE

(press RETURN)

PRINT POS

(press RETURN)

Output Item 7

10 - 6

SOURCE

( pr es s RE TURN)

PRINT POS

(press RETURN)

LINE ADV

(pr es s RETURN)

Output Item 8

Output
items
8 and 9 define the third
line
report title, PURCHASES AND RECEIPTS JOURNAL.

of the

SOURCE

(press RETURN)

PRINT POS

(press RETURN)

SOURCE

(press RETURN)

PRINT POS

(press RETURN)

LINE ADV

(press RETURN)

Output Item 9

Output Item 10

Output
items 10 through 15 provide the column headings
for the report.
SOURCE

(press RETURN)

PRINT POS

(press GO)

10 -

The next form continues the PAGE HEADER OUTPUT ITEMS.
PAGE HEADER OUTPUT ITEMS

Output Item 11
SOURCE

(press RETURN)

PRINT POS

(press RETURN)

SOURCE

RIO

(press RETURN)

PRINT POS

(press RETURN)

SOURCE

Rll

(pr es s RETURN)

PRINT POS

(press RETURN)

SOURCE

R12

(press RETURN)

PRINT POS

(press RETURN)

Output Item 12

Output Item 13

Output Item 14

Output Item 15

10 - 8

SOURCE

R13

( pr es s RE TURN)

PRINT POS

(press RETURN)

LINE ADV

(press GO)

10 - 9

PAGE HEADER FUNCTION
This Function Statement will be executed each time
DMRUN begins to print a new page. The statement is
executed before the Page Header is printed.
For this
report, the following single statement is used to
update a page count. You use program register 1 for
this purpose, since that is the register you referred
to in Page Header Output Item 5 above.
NOTE
The character "I" should be typed as an
exclamation poin t.
STATEMENT

Pl=Pl+l I INCREMENT PG.

(press RETURN)

Leave blank

(press F3)

REPORT BODY STRUCTURE
On this form, you indicate whether or not you want the
detail elements of your report grouped for totals,
subtotals, or any other purpose.
In this report you
just want a simple list of the transactions with no
grouping.
Therefore, the only report body element you
will define is the DETAIL ELEMENT itself.
Use the
RETURN key to tab through the other entries until you
get to the field for DETAIL ELEMENT.
DETAIL ELEMENT

(press GO)

DETAIL ELEMENT OUTPUT ITEMS
On this form, you will specify output items which
represent the actual data that you want on the report.

10 - 10

Output Item 1
SOURCE Al represents the first field in the primary
("A") file.
In this case the first field in the
primary
file is the TRANSACTION NUMBER field in
PRTRANS.
SOURCE

(pr es s RETURN)

PRINT POS

(pr es s RETURN)

SOURCE

AIS

(press RETURN)

PRINT POS

(press RETURN)

SOURCE

(pr es s RE TURN)

PRINT POS

(press RETURN)

SOURCE

(pr es s RE TURN)

PRINT POS

(press RETURN)

Output Item 2

Output Item 3

Output Item 4

Output Item 5

10 - 11

SOURCE

(pr es s RE TURN)

PRINT POS

(press RETURN)

NUMERIC EDIT

(press RETURN)

SOURCE

A10

(press RETURN)

PRINT POS

(pr es s RETU RN)

SOURCE

A13

(pr es s RETURN)

PRINT POS

(press RETURN)

NUMERIC EDIT

(press RETURN

SOURCE

A14

(press RETURN)

PRINT POS

(press RETURN)

NUMERIC EDIT

(press RETURN)

LINE ADV

(press RETURN)

Output Item 6

Output Item 7

Output Item 8

10 - 12

Output Item 9
This entry completes your PR-JOURNAL.
SOURCE

Leave blank

(press F3)

PROGRAM/UTILITY LINKAGE
Use the
Activity
report.

FINISH key to return to
Selection menu.
You may

10 - 13

the Programming
then test your

SECTION

LOWSTOCK

(PROGRAM ..9.J.. REPORT PROGRAM)

The purpose of this section is to introduce you to the
procedures for creating a report program which uses record
selection.
Your second report program, LOWSTOCK, prints a
"buyer's guide" of items in stock having on-hand (plus on
order)
balances less than their re-order point. To see the
output for this report, please refer to. Appendix B.
You will notice that the information on key use has been
left out of the following instructions.
Be sure to check
the form title on the screen with the form title in the
instructions before you start to enter specifications.

11 - 1

PROGRAMMING ACTIVITY SELECTION
ACTIVITY NUMBER

No change

CREATE/MAINTAIN DM PROGRAM
LIBRARY AND PROGRAM INFORMATION
LIBRARY FILE ID:

XXXLIB

PROGRAM NAME:

LOWSTOCK

PROGRAM TYPE
This is a report program.
PROGRAM TYPE

REPORT PROGRAM SECTIONS
SECTION

No change

INPUT FILE RECORD DESCRIPTION "PROGRAMS
After entering the name of the MAINTENANCE PROGRAM, use
the system defaults for the other entries on this form.
FILE

PROGRAM NAME

PRODUTIL

11 - 2

SORT SPECIFICATIONS FOR CONTROL F'ILE - FILE A
FIELD NUMBER

leave blank

OUTPUT SPECIFICATIONS
As in the previous program, you may want to specify
screen for your output device if you don't have a
printer.
Physical Page Size

No change

PRIMARY FILE RECORD SELECT
In Data Manager report programs, record selection is
done by using the CANCEL statement.
In this example,
you can see the branch to the CANCEL statement for all
records that should NOT be selected.
NOTE
The character "1" should be typed as an
exclamation point.
#

STATEMENT

P2=A6+A7 ION HAND + ORD

IF P2 GT A8 4 IGT MIN

EXIT IPRINT RECORD

CANCEL lREAD NEXT REC

11 - 3

REPORT TEXT
On this form, you provide
appear on the report.

the headings

which

will

HEADING OR MESSAGE
There is one space between the B, 2, and the O.
are 3 spaces between B 2 0 and D A T A.
01

B 2 0

MAN AGE R

PAGE

INVENTORY

CONTROL SYSTEM

BUYER I S GUIDE

STOCK NUMBER

DESCRIPTION

PTD UNI TS SOLD

010

MINIMUM

011

ON HAND

012

ON ORDER

013

DELIVERY DATE

D A T A

11 - 4

There

REPORT HEADER OUTPUT ITEMS
No Report Header or Trailer will be specified for this
report. Do you remember which function key to press to
skip to the next section? (If you need to, look at the
function key information in Appendix A.)

PAGE HEADER OUTPUT ITEMS
Your entries on the next forms define output items that
will appear at the top of each page of the report.
To complete the entries on the following form, you need
to use the RETURN key to "tab through" each field
(whether you need to make an entry in that field or
not) •

Output Item 1
SOURCE

PRINT POS

Output Item 2
SOURCE

PRINT POS

Output Item 3

11 - 5

SOURCE

PRINT POS

Output Item 4
SOURCE

PRINT POS

III

Output Item 5
SOURCE

PRINT POS

116

OUTPUT DESC

2.0'

LINE ADV

Output Item 6
SOURCE

PRINT POS

Output Item 7

11 - 6

SOURCE

PRINT POS

LINE ADV

Output Item 8
SOURCE

PRINT POS

LINE ADV

Output Item 9
SOURCE

PRINT POS

Output Item 10
SOURCE

PRINT POS

The next form continues the PAGE HEADER OUTPUT ITEMS.

11 - 7

PAGE HEADER OUTPUT ITEMS

Output Item 11
SOURCE

PRINT POS

Output Item 12
SOURCE

RIO

PRINT POS

Output Item 13
SOURCE

Rl1

PRINT POS

Output Item 14
SOURCE

R12

PRINT POS

Output Item 15

11 - 8

SOURCE

R13

PRINT POS

105

LINE ADV

PAGE HEADER FUNCTION
#

STATEMENT
Pl=Pl+l

REPORT BODY STRUCTURE
Use system defaults here, except
which is changed to Y.
DETAIL ELEMENT

DETAIL ELEMENT OUTPUT ITEMS
Output Item 1
SOURCE

PRINT POS

Output Item 2
SOURCE

11 - 9

for DETAIL ELEMENT,

PRINT POS

Output Item 3
SOURCE

A17

PRINT POS

NUMERIC EDIT

Output Item 4
SOURCE

PRINT POS

NUMERIC EDIT

Output Item 5
SOURCE

PRINT POS

NUMERIC EDIT

Output Item 6

11 - 10

SOURCE

PRINT POS

NUMERIC EDIT

Output Item 7
SOURCE

PRINT POS

110

NUMERIC EDIT

LINE ADV

Output Item 8
No entry is required for this OUTPUT ITEM. You have
completed this program.
Press GO. This will process
the data you have just entered. Now press FINISH until
you return to the Programming Activity Selection menu.
From there you will be able to test your LOWSTOCK
program.
However, before you start it, you might want to run
your PRODUTIL program again and maintain the ON HAND,
ON ORDER, and REORDER POINT entries for your products.
Remember, product information will not be printed by
this report unless the sum of the ON HAND and ON ORDER
figure is less than the REORDER POINT.

11 - 11

SECTION

PRE-PRODLIST

(PROGRAM .l.O.1. RUN-TIME

PROGRAM>

Section 12 introduces you to the Data Manager programming
forms for a Run-time Data program.
PRE-PRODLIST is a
Run-time Data program which allows the application user to
enter values to be used by the PRODLIST report. (You will
be creating PRODLIST next.)

12 - 1

PROGRAMMING ACTIVITY SELECTION
ACTIVITY NUMBER

No change

CREATE/MAINTAIN DM PROGRAM
LIBRARY AND PROGRAM INFORMATION
LIBRARY FILE ID:

XXXLIB

PROGRAM NAME:

PRE-PRODLIST

PROGRAM TYPE
PROGRAM TYPE:

RUNTIME DATA PROGRAM SECTIONS
SECTION

No change

SECONDARY FILES RECORD DESCRIPTION PROGRAMS
PROGRAM NAME

leave blank

FORM SELECTION
SELECTION NUMBER

12 - 2

STANDARD FORM
FORM HEADING
HEADING:

PRODUCT INFORMATION REPORT

NUMERIC RANGE TABLE
RANGE i

LOWER

ALPHANUMERIC RANGE TABLE
RANGE

UPPER

leave blank

FIELD DEFINITION 1
FIELD NAME

STARTING PRODUCT

DESCRIPTION

8.0

MANDATORY ENTRY

12 - 3

FIELD DEFINITION 2
FIELD NAME

Leave blank

STD DESCRIPTION

INCLUDE IN RECORD

ALLOW ENTRY

FIELD DEFINITION 3
FIELD NAME

ENDING PRODUCT

DESCRIPTION

8.0

MANDATORY ENTRY

FIELD DEFINITION 4
FIELD NAME

Leave blank

STD DESCRIPTION

INCLUDE IN RECORD

ALLOW ENTRY

FIELD DEFINITION 5

12 - 4

FIELD NAME

SELECT CATEGORY

STD DESCRIPTION

INCLUDE IN RECORD

ALLOW ENTRY

FIELD DEFINITION 6
FIELD NAME

STD DESCRIPTION

= ALL

CATGYS)

RANGE CHECKING
RANGE 1

RANGE OF RECORDS - LOWER KEY FIELDS
FIELD NUMBER

12 - 5

RANGE OF RECORDS - UPPER KEY FIELDS
FIELD NUMBER

INITIAL FUNCTION
STATEMENT 1

Leave blank

REPEATING FUNCTION
In
order to save the value entered in Field 6
(CATEGORY) for the report program to reference, it is
assigned to program register 2. X Register 19 is set
to T, indicating that you are supplying range of
records information to the report.
STATEMENT
1

P2=A6

X19="T"

PROGRAM/UTILITY LINKAGE
Entries in this section tell DMRUN that you have
another program you want to run when this one ends.
#

PROG/FILE NAME

TYPE

PRODLIST

12 - 6

RUNTIME DATA PROGRAM SECTIONS
This program is now complete. Use FINISH key to return
to the Programming Activity Selection Menu. You may
test this program if you wish.
However, DMRUN will
display an error message.
The problem is that DMRUN
will not be able to link to PRODLIST because you have
not created it yet. Once PRODLIST is created, you can
run them both together.

12 - 7

SECTION

PROPLIST

(PROGRAM .l.lJ.. REPORT PROGRAM)

This section introduces you to the procedures for creating a
more complex report.
The last report program, PRODLIST,
uses run-time parameters to report selectively on the
product master file.

13 - 1

PROGRAMMING ACTIVITY SELECTION
ACTIVITY NUMBER

No change

CREATE/MAINTAIN DM PROGRAM
LIBRARY AND PROGRAM INFORMATION
LIBRARY FILE ID:

XXXLIB

PROGRAM NAME:

ICMENUI

PROGRAM TYPE
This is a standard menu program.
PROGRAM TYPE

STANDARD FORM MENU
HEADING

B20 DATA MANAGER INVENTORY CONTROL SYSTEM

SELECTION PROMPT:

SELECTION NUMBER (default)

Note that you do not need to make an entry under TYPE.
Use the system default of 1 for that entry.
(Each DESCRIPTION should be entered on one line, even
though it may be printed on two lines below.)

14 - 2

DESCRIPTION

PROG/FILE NAME

PRODUTIL

ENTER OR CHANGE
PRODUCT INFORMATION

STOCKINQ

STOCK ON HAND INQUIRY

ISSUES

INVENTORY ISSUE
TRANSACTIONS

PR-ENTRY

ENTER INVENTORY PURCHASES
AND RECEIPTS

PR-JOURNAL

PRINT PURCHASES
AND RECEIPTS JOURNAL

PR-UPDATE

UPDATE INVENTORY PURCHASES
AND RECEIPTS

LOWSTOCK

PRINT BUYER'S GUIDE

PRE-PRODLIST

PRINT PRODUCT
INFORMATION REPORT

PERIOD-END

PERIOD END UPDATE

This completes ICMENUI.
Now that you have seen many of the features of B20 DATA
MANAGER, it would be a good idea quickly to review the first
sections
of the Programmer's
Manual.
Much
of the
information there will be more meaningful now that you are
an experienced DM programmer.

14 - 3

Congratulations again! You have just completed the entire
Data Manager Inventory Control System. You can now run all
your programs by starting ICMENUI. Even better, select DM
utilities
on the DMRUN Library Selection
Menu.
Use
Install/Maintain Library Selections to install your
XXXLIB in DMRUN. You can then run all your programs just by
naming menu selections.
There are additional features and combinations of features
that have not been included in these sample programs. Some
of
these are discussed. in the last sections of the
Programmer's Manual. It will be well worth reading the rest
of the manual before you begin your application systems.
Good luck and good programming with B20 Data Manager.

14 - 4

APPENDIX A
DMCREATE

DMRUN FUNCTION KEYS

B20 Data Manager has 11 function keys which are used in
DMCREATE and DMRUN.
The function of some of these keys
changes when used during DMCREATE or DMRUN.
DMCREATE FUNCTION
There are 10 DMCREATE
described below:

function

keys.

These

keys

are

Function
DELETE

Character delete.

Down Arrow

Enter the selected
next field.

FINISH

Return to the previous form or to the
Program
Sections
menu,
or terminate
DMCREATE. This key will not cause data to
be entered in a specification.

Advance
to the next program
section
without entering any fields on the current
form. Available only when lit.

Print contents of screen. Available only
when lit for obtaining printed copies of a
Program Library directory.

FlO

Delete the last entry in a group of
identical fields. This is the only way to
delete field definitions, report output
items, etc.

Enter any remaining fields
with the values that they
continue to the next form.

HELP

Display all available help forms.

NEXT/RETURN

Enter the selected
next field.

A- I

field and select

the

on the form
contain and

field and select

the

Up Arrow

Return to the previous field.
DMRUN FUNCTION KEXa

There are 10 DMRUN function keys.
below:

These keys are described

Function
CANCEL

Void all entries on the current
without updating the data file.

DELETE

Character delete.

Down Arrow

Enter the selected
next field.

FINISH

Return
DMRUN.

Print contents of screen. Available only
when lit for inquiries and reports output
to screen.

FlO

Delete the current primary
Available only when lit.

file record.

Enter any rema1n1ng fields
with the values that they
continue to the next form.

on the form
contain and

HELP

Display all available help forms.

NEXT/RETURN

Enter the selected
next field.

Up Arrow

Return to the previous field.

field and select

to the previous

A - 2

menu.

form

the

Terminate

field and select

the

BUR R0 UGH 5 DATAM ANAG E R

PROGRAM NAME

PRQ[lUTIL

LIST OATE

CREATE VERSION

0.40

LIBRARY NAME

IeLlB

APPENDIX B

PROGRAN NAME

PRODUTIL

PROGRAM OUTPUT

PROGRAI1 SIZE

01224

FORN HEADING

PRODUCT INFORMATION

PROGRAI'I

TVPE

t'IAItHEt-iAt-iCE

PROGRAM HELP

ERROR HELP

PROGRAM I)ERSIOII
PRIMARY

DATA FILE

FILE UAHE

(Ic}PRODUCTS

RECORD SIZE
KE'i LENGTH

00119
00008

ALL0I4 ADD
ALLDW CHANGE
ALLOW DELETE

liES
ItES
I/E5

SECURITY ERROR HELP
LOG ERROR HELP
FILE UNAVAILABLE
NUMERIC

RANGE

RANGE TABLE
LOWER

UPPER

001

002

+99999.99

ALPHANUMERIC
RANGE

CREATE NEW FILE

LDWER

RANGE TABLE

UPPER
[)

B-1

08/27/82

0.40

LIST TINE 09:19:59

BUR Rn UGH S D A T A MAN AGE R
PROGRAM NAME

PROOUTIL

LIST DATE

FIELD
NAME

001 STOCK NUMBER
002 CATEGORY
oo~ BIN LOCATION
004 DESCRIPTION

S10
DESC DESC
12
04
09

" 08
N01
A04
A25

MANDATORY PRIMARY INCLUDE
ENTRV
KEY RECORD
y
'I

N
N

LIST TIME 09:19:59

DEF Ir~l TI Dl15

FIELD
FLD
NUM

08/27/82

0.40

ALl0l4 HELP SOURCE SKIP TO FIELD
INCR RANGES
DUP/INCR A~1T
EIHRY FORM
N

'i
'/
V

Y
N

POS IN REC
0001
0009
0010
0014

005

A 01

SN04

006 DN HAND
007 ON ORDER
008 REORDER POINT

5"04

'i
'I

H
N
N

0049
0053

0039
0044

N04

14
01

N
N

U
Y
If

N
'i
II

0063

N
ri
N
N

If
y

If
If

N
N

02
01

0071
0079

N
'i

N
Y

0080

0086
0096
0108

009 DELIVERY DATE
010
011 UNIT
012 PRICE

04
17

o 06
A01
A04
SN05.02

013 REPLACEMENT COST
014 DISCnutn COOE
015
016 LAST ISSUE DATE

17
01
01
14

5H05.02
A01
R01
D06

'i
N
N

017 UNIT SALES PTO
018 t SALES PTO
019 t COST PlO

16
18
18

SN09
SN09.02
SN09.02

Y
y

B-2

0059

BUR RDUG HS DAT A 'n ANAG E R
STOCKINQ

PRDGRAtt HAttE
CREATE VERSION

0.40

LIBRARY NAME

ICLIB

PROGRAM NAME

STOCKINQ

PRDGRAM SIZE

00440

FORM HEADING

STOCK/PRICE INQUIRY

PRDGRAM TYPE

INQUIRY

lIST DATE 08/26/82

0.40

LIST TIME 16:04:00

PROGRAM HELP
ERROR HELP
PROGRAM VERSION
PRI FILE PROGRAH PRODUTIL
FIELD
FLD
NUH

FIELD
NAME

001
002
003
004

STOCK NUMBER
DESCRIPTION
ON HAND
PRICE

005 DISCOUNT CODE

STD
DESC DESC

DEFINITlDrfS

MANDATORY PRIMARY INCLUDE IN ALLOW HELP SOURCE SKIP TO FIELD
INCR RANGES
KEY RECDRD
ENTRY
ENTRY FOR"
DUPIINCR AMT
Y
N
N

Y
N

N
N

Y
Y
Y

N
H

AOOI
A004
A006
ft012

A014

B-3

P~S

IN REC

BUR R0 UGH 5 DATAM ANAG E R
PROGRAM NAME
CREATE VERSION

0.40

LIBRARY

leLIS

NA~E

PROGRAM NAME
PRDGRA~

SIZE

PROGRAM TYPE

PERIOD-END

lIST DATE

PERIOD-EN~

00182
BATCH UPDATE

ERROR HELP
PROGRAM VERSION
PRJ FILE PRDGRAM PRDOUTIl
OElETE PRI"ARY FILE AT END OF UPDRTE
UPDATE

FUNCTION

001 A16 = 010199 !RESET"DT
002 A17 = 0 !UNITS PTD
003 Ale = 0 !SAlES PTD
004 A19 = 0 !COST PTO

B-4

08/26/82

0.40

lIST TIME 16:04:00

BUR R0 UGH 5 DATAM A" AGE R

PROGRAM NAME
POST FDRtl

ISSUES

LIST DATE

FUHCTlDN

001 B6=B6-A4 !DEDUCT ISSUE
002 B17=817+A4 !INC PTD UNIlr~
om Pl=A~A5 !SALES EXTEI-I.
004 B18=B18+Pl !PTO 5LS
005 p2=A4~n! COST EXTEN.
006 B19=B19+P2 !PTO CDST
007 B16=A6 !lRAUS DATE

B-5

08/26/82

0.40

LIST TIME 16:04:00

BUR R0 UGH S DATAM ANAG ER
ISSUES

PROGRA" NAME
CREATE VERSION

0.40

LIBRARY NAME

leLIB

PROGRAI1 NAME

ISSUES

PROGRAM SIZE

00778

FOR" HEADING

INVENTORY ISSUES

PROGRAM TYPE

REAL TIME UPDATE

LIST DATE

08/26/82

0.40

LIST TIKE 16:04:00

PROGRAH HELP
ERROR HELP
PROGRA" VERSION
SECONDARY FILES
FilE

MAIHTENAriCE

PROGRAM

CRITICAL

PRODUTIL

SECONDARV FILE KEY FIELDS
FIELD
FILE B NUMBER

POSITION IN
RECORD

LENGTH

001

FIELD
FLD
NUM
001
002
OOl
004

FIELD
riAME
STOCK HUMBER
DESCRIPTION
UNIT
QUANTITY SOLD

OOS PRICE
006 TRANS DATE

STD
DESC DESC

DEFlHITIONS

HANDATORV PRIHARY INCLUDE IN ALLOW HELP SOURCE SKIP TO FIELD
INCR RANGES
ENTRY
KEY RECORD
ENTRY FOR"
DUP/IHCR AMT

N08
09 A25
04 A04
13 H04

Y
N
N

17 5"05.02
14 D06

y
y

N
N
H

N
N
Y

N
V

B-6

8004
BOll
B012

N
H
H

POS IN REC
0001

0009

N
Y

0021

oon

BUR R0 UGH S DATAM Afl AGE R
PROGRAM NAME

LIST DATE

PR-ENTRV

CREATE VERSION

0.40

LIBRARY NAME

ICLIB

PROGRAM HAME

PR-EHTRY

PRDGRAM SIZE

01414

FORM HEADING

INVENTORY PURCHASE/RECEIPT TRANSACTIOnS

PROGRAM TYPE

MAINTENANCE

PRDGRAM HELP
ERROR HELP
PROGRAM VERS Ior.
PRIMARY DATA FILE
:0,~
>~(

FILE NAME

(IC}PRTRANS

RECORD SIZE
KEY LENGTH

ooon

ALLOW ADD
ALLOW CHANGE
ALLOW DELETE

YES
YES
YES

00004

SECURITY ERROR HELP
LOG ERROR HELP
FILE UNAVAILABLE

CREATE NEW FILE

SECONDARY FILES
FILE

MAINTENANCE

PROGRAM

CRITICAL

PROOUTIL

SECONDARY FILE KEY FIELDS
FIELD
FILE B NUMBER

POSITION IN
RECORD

LEnGTH

004

B-7

08/27/82

0.40

LIST TIME 09:29:39

BUR RDUG HS DATAM ANAG E R
PROGRAM NAME
ALPHANUMERIC
RANGE t
01
02

PR-ENTRY

LIST DATE

FLO

LDWER

UPPER

FIELD
NAME

STO

OESC OESC

001 TRANSACTION NBR B N04
002 TRANS TYPE (PIR) 01 A01
oo~
01 A01
004 STOCK NUMBER
t~ 08
005 DESCRIPTION
006 ur~IT
007
008 **PURCHASES**

09
04
01
01

A25
A04
A01
A01

5N04
D06
A01
A01

009 QTY ORDERED
010 DELIVERY DATE
011
012 **RECEIPTS**

01
01

013 QTY RECEIVED
014 UNIT COST
015

15 SH04
17 Sff05.02
14 o 06

POST FORM
001
002
003
004
005
006
007
008
009
010
011
012
013
014

LIST TIME 09:29:39

RANGE TABLE

FIELD

NUl'!

08/27/82

0.40

DEFINITIONS

MANDATDRY PRIMARY INCLUDE IN ALLOW HELP SOURCE SKIP TO FIELD
INCR RANGES
ENTRY
KEY RECORD
ENTRY FORM
OUP/INCR AI'IT
Y

N
N
N

N
N
N
H

N
N
N

Y
Y
N
t.

Y
Y

N
N

N
N
N
N
H
N

N
H
N

N
ti

t.
N

Y
Y

Y
Y
Y

Y
y
N
ti

H
r~

Y
y
N

FUUCTIOU

IF A2 EQ .p. 7!IF PURCH
!VALIDATE RECEIPT
IF A9 HE 0 12 !QTY ORO
IF AI0 HE 0 12 !DLVY DT
GOTO 10 !GOOD TRANS
!VALIDATE PURCHASE
IF All HE 0 14 !GTY RCO
IF A14 NE 0 14 !COST
!GODD TRANSACTIDN
A15= Xl !INSERT DATE
EXIT !UPDATE PRTRANS
ERROR 1 !INVALID RECPT
EXIT !REENTER TRANS
ERROR 2 !I NVAL I[l PURCH

B-8

8004
BOll

01 02

PDS IN REC
0001
0005
0006

H
fi
N
H

013

H
H
H
N

0014
0019

N
N

0025
0030
0018

BUR R0 UGH S DATA HAN AGE R
PROGRAM NAME
CREATE VERSION

0.40

LIBRARY NAME

ICLIB

PROGRAH HAHE

PR-UPDATE

PRDGRAM SIZE

00344

PROGRAH TYPE

BATCH UPDATE

PR-UPDATE

LIST DATE

ERRDR HELP
PROGRAI1 VERSION
PRI FILE PROGRAM PR-ENTRY
DELETE PRIMARY FILE AT END OF UPDATE

SECONDARY FILES
FILE

MAINTEnANCE

CRITICAL

PROGRA~t

PRODUTlL

SECONDARY FILE KEY FIELDS
FIELD
FILE B NUNBER

POSITION IN
RECDRD

LENGTH

004

UPDATE
001 IF

FUNCTION
A2

EQ DR" 6!RECEIPT

002 B7=B7+A9 !ON ORDER
003 IF AI0 EQ 0 5 !DT=O
004 B9=A10 !DELIVERY DT
005 EXIT

006 B6=B6+Al~ IDn HAND
007 B7=B7-All !ON ORDER
008 81l=A14 !COST

B-9

08/26/82

0.40

LIST TIHE 16:04:00

BUR RDUG HS OAT A " ANAG E R
PROGRAM NAME
CREATE YERSION

0.40

LIBRARY NAME

ICLIB

PROGRAM NAME

PR-JOURNAL

PRDGRAt1 5IZE

0075~

PROGRAM TYPE

REPORT

PR-JOURHAL

LIST DATE

ERRDR HELP
PROGRAM

lJERSIm~

INPUT FILE
FILE

SPEC IFICAT Im!S

tlAItHENANCE

PROGRAM

CRITICAL

PR-ENTRY

THE CONTROL FILE FOR THIS REPORT IS

OUTPUT

SPECIFICATIDNS

PHYSICAL PAGE
SIZE
66
NUMBER OF LINES SKIPPED AT THE TDP OF EACH PAGE
06
NUMBER DF LINES SKIPPED AT THE BOTTDM OF EACH PAGE 06
OUTPUT DEVICE
DATE SEPERATDR

SPODLER

FORti LOAD PROMPT
FORM UNLOAD PRHT
TEXT TABLE
HEADING OR MESSAGE
01

B 2 (I

02
03

t1 ANAG E R

04
05
06
07
08

09
10
11
12
13

HEADmG OR MESSAGE

[) AT A

PAGE
IN\JENTORY
CDNTRDL SYSTEM
PURCHASES AtfD
RECEIPTS JOURNAL
TRANS TRANS DT
TYPE STOCK NBR
ORDER QTY
RECEIPT DT
gTY RECEIVED
UNIT COST
B-IO

0.40

08126/82 lIST TIME 16:04:00

BUR R0 UGH 5 DATAM ANAG E R
PROGRAM NAME
PAGE HEADER
SOURCE
001
002
001
004
005
006
007
008
009
010

XOOI
ROOI
R002
R003
POOl
ROO4
R005
R006
R007
RODS

011
012
OB
014
015

R009
ROIO

PR-JOURHAL

LIST DATE

OUTPUT ITENS
PRUH
POS

OUTPUT
DESC

DUTPUT
EDIT

AeCUM
HUN

LIr~E

ADV

006

on
051
Q7S

084
036
046

N02

002
002

003

047

003
022
041
053
066
081

ROll

R012
ROB

002

NUMERIC EDIT
PRUiT IF ZERO
1 PRINT IF ZERO

CDOES :

rm COMMAS

COMMRS
NO COMMAS
3 BLANK IF ZERO COMMAS
4 ZERO REPL. PRDTECT rm COMMAS
5 ZERO REPL. PROTECT COHNAS
6 DATE PRINTED WITOUT SEPARATOR
2 BLANK IF ZERO

PAGE HEADER

FUNCTION

001 Pl=Pl+l !INCREMENT PG.

REPORT

BDDY

STRUCTURE

LEYEL 3 HEADER
N
lEVEL 2 HEADER
"
LEVEL 1 HEAOER N
DETAIL ITEM V
LEVEL I TRAILER N
LEVEL 2 TRAILER
H
LEVEL 1 TRAILER
N

B-II

08/26/82

0.40

lIST TIME 16:04:00

BUR R0 UGH 5 DAT A HA NAG E R
PROGRAM NAME

PR-JOURNAL

LIST DATE

FIELDS THAT TRIGGER THE PRINTING OF THE HEADERS AHD TRAILERS
SOURCE

FILE

POS

LENGTH

OUTPUT
EDIT

ACCUM
HUH

LEVEL 1

Ln'EL 1
lEt)El 2

LEVEl 5

DETAIL ELEMENT
SOURCE
001

OUTPUT ITEMS
PRINT
POS

003
004

R004

030

A009
006 AOIO
007 ROn
008 AOl4

044
054
072
080

005

LINE
ADV

004

A001
ROIS
AOO2

002

OUTPUT
DESC

011

024

NUMERI CED IT

j
j

08126/82

001

CODES :

PRINT IF ZERO NO COMMAS
1 PRINT IF. ZERO CO""AS
2 BLANK IF ZERO NO COMMAS
3 BLANK IF ZERD COMMAS
4 ZERD REPL. PROTECT NO COM MRS
5 ZERO REPL. PROTECT COMMAS
6 DATE PRINTED WITOUT SEPARATOR

B-12

0.40

LIST TIME 16:04:00

BUR R0 UGH 5 DATA " ANAG ER
PROGRAn NAME
CREATE VERSION

0.40

LIBRARY NAME

ICLIB

PROGRAM NAHE

LOHSTDCK

PROGRAM SIZE

00839

PROGRAM TYPE

REPORT

LIST DATE

lOWSTDCK

ERROR HELP
PROGRAM VERSION
INPUT FILE

SPECIFICATIONS
PROGRAM

FILE MAINTENANCE
A

CRITICAL

PRDDUTIL

THE CONTROL FILE FOR THIS REPORT IS

OUTPUT

SPECIFICATIONS

PHYSICAL PAGE
SIZE
66
NUMBER OF LINES SKIPPED AT THE TOP OF EACH PAGE
06
NUnBER OF LWES SKIPPED AT THE BOTTOtt OF EACH PAGE 06
OUTPUT DEVICE
DATE SEPERATDR

SPOOLER

FORn LOAD PROMPT
FORn UNLOAD PRMT
RECORD SELECTION
001 P2=A6+A7 !ON HAND + ORD
002 IF P2 GT A8 4 !GT HIN
001 EXIT !PRINT RECORD
004 CANCEL !READ NEXT REC

TEXT TABLE
HEADING OR MESSAGE
01

B 2 0 DA T A

02.

"A NAG ER
PAGE
INVENTORY
CONTROL SYSTEM

03
04
05

HEADING OR MESSAGE

B-13

08126/82

0.40

LIST TIME 16:04:00

BUR R0 UGH 5 DRT R HAN RGE R
PROGRAM NAME
HEADING DR MESSRGE
06
07

08
09

10
11
12

LOMSTOCK

LIST DATE

HEADING DR MESSAGE

BUVER'S GUIDE
STOCK HUMBER
DESCRIPTIDtI
PTD UNITS SOLO
HINH1UM
ON HAr!D
on ORDER
DELIVERY DATE

PAGE HEA[>ER
SOURCE

OUTPUT ITEMS
PRINT
POS

X001
002 R001
001 R002
004 ROOl
005 POOl
006 ROO4
007 ROOS
008 R006
009 R007
010 ROOS

014
051
069
111
116
054
064
059
014
029

011 R009
012 ROlO
013 ROll
014 ROl2
015 ROB

074
084

001

OUTPUT
DESC

OUTPUT
EDIT

U02

ACCUH
HUH

LINE
ADV

002
002
003

OS7
094
105

002

NUMERIC EDIT

CODES :

PRHlT IF ZERO UO COMMAS
I PRINT IF ZERO COMMAS
2 BLA'~K IF ZERD no COMMAS
1 BLANK IF ZERO COMMRS
4 ZERO REPL. PROTECT NO CO"MftS
5 ZERO ~EPL. PROTECT COMMAS
6 DATE PRINTED MITDUT SEPRRATOR

PAGE HEADER

FUNCTION

001 Pl=Pl+1

B-14

08/26/82

0.40

LIST TI"E 16:04:00

BUR RDUG H5 0 AT A HAN AGE R
PROGRAM NAME
REPORT

BODY

LOWSTOCK

LIST DATE

STRUCTURE

LEVEL 3 HEADER
LEVEL 2 HEADER
LEVEL 1 HEADER
DETAIL ITEM
LEVEL 1 TRAILER
LEVEL 2 TRAILER
LEVEL 3 TRAILER

N
H
N
Y
N
N
N

FIELDS THAT TRIGGER THE PRINTING OF THE HEADERS AHD TRAILERS
SOURCE

FILE

PDS

LENGTH

OUTPUT
EDIT

ReCUM
HUH

LEVEL 1

LEVEL 1
LEVEL 2
LEVEL 3

DETAIL ELEMENT OUTPUT ITEMS
SOURCE
001

AOOl
AOO4
om A01?
004 AOOS
005 AOO6
006 AOO?
OO? A009
002

08/26/82

PRINT
P~S

OUTPUT
DESC

018
029
059
Oil"
It<

085
097
110
NUNER ICED IT

LINE
ADY

3
3

3
~

001

CODES :

PRItH IF ZERD NO COMMAS
1 PRINT IF ZERO COttttAS
2 BLAr.K IF ZERO rm COMMAS
3 BLANK IF ZERO COMMAS
4 ZERO REPL. PRDTECT rm CDMMRS
5 ZERO REPL. PROTECT CON MAS
6 DATE PRINTED WITOUT SEPARATOR

B-15

0.40

LIST TIME 16:04:00

BUR R0 UGH S DAT A "A NAG E R
PRDGRAM HANE
CREATE

PRE-PRDDLIST

LIST DATE

08/26/82

0.40

LIST TIME 16:04:00

0.40

~ERSIOH

LIBRARY NAME

leLIS

PRDGRAM NAME

PRE-PRODLIST

PROGRAM SIZE

01170

FORM HEADING

PRODUCT IHFORMATION REPORT

PRDGRAM TYPE

RutHIME DATA

PROGRAM HELP
ERROR HELP

PROGRAM VERSIOH
NUMERIC

RAr~GE

RANGE I
001

TABLE

LOWER

UPPER

FIELD
FLD
HUM

FIELD
NAME

STD
DESC DESC

001 STARTING PRODUCT
002
01
003 EHDIHG PRDDUCT
004
01

DEFlHITIor~S

MANDATORY PRIMARY INCLUDE IH AllOW HELP SOURCE SKIP TO FIELD
IHCR RANGES
ErnRY
KEY RECORD
EtHRV FORM
DUPIIHCR A"T

H08
R01
H08
R01

H
N
H

Y
N

005 SELECT CATEGORY 01 A01
006 (0 = ALL CATGYS) 12 H01

H
N

H
U

H
V

ti
H

RANGE OF RECORDS LOWER KEV FIELDS
FIELD
NUMBER

PDSITION IN
RECORD

LENGTH

0001

B-16

POS IN REC
0001
0009

0017

BUR RDUG H5 DATAN AHAG E R
PROGRAM NAME
RANGE OF RECORDS

PRE-PRODLIST

LIST DATE

UPPER KEY FIELDS

FIELD
NUMBER

PDSITIDH IN
RECORD

LENGTH

0003

POST FORM

FUtiCTION

001 P2=A6
002 X19='P

PRDGRA" LINKAGE
PROGRAM NAME

01 PRDDlIST

LANGUAGE

B-17

08/26/82

0.40

LIST TIME 16:04:00

BUR R0 UGH S 0 ATAM A" AGE R
PROGRAM NAME
CREATE VERSION

0.40

LIBRARY NAME

ICLIB

PROGRAM NAME

PRDDLIST

PRDGRAr1 SIZE

01181

PROGRAM TYPE

REPORT

PRODLIST

LIST DATE

ERROR HELP
PROGRAM VERSION
INPUT FILE
FILE

SPECIFICATIons

MAINTENANCE

PROGRAM

CRITICAL

PRODUTIL

THE CONTROL FILE FOR THIS REPORT IS

OUTPUT

SPECIFICATIONS

PHYSICAL PAGE
SIZE
66
NUMBER OF LINES SKIPPED AT THE TOP OF EACH PAGE
06
NUMBER DF LINES SKIPPED fl.T THE BOTTOM DF EACH PAGE 06
OUTPUT DEVICE
DATE SEPERATDR

SPOOLER

FORM LOAD PROMPT
FORM UNLOAD PRHT
PRIHAR't FILE

RECDRD SELECTION

001 IF P2 EQ 0 4 !AlL CATS

002 IF A2 EQ P2 4 !GODD CAT
CANCEL !READ NEXT REC
004 EXIT
!PRINT RECDRD

003

TEXT TABLE
HEADING DR MESSAGE

01
02
03

04
05

B2 0 DATA
MAN AGE R
PAGE
IN\/'ENTDRY
CONTROL SYSTEM

HEADING DR MESSAGE
21

SALES PTO
COST Pro
B-18

08/27/82

0.40

LIST TIME

09:44:1~

BUR R0 UGH S DATAM ANAG E R
PROCRAn NANE
HEADING DR MESSAGE
06
07

08
09
10
11
12
13

14
15
16

17
18
19
20

XOOI
ROOI
R002

117

122

011

ROO9
ROlO

013 ROll
014 R012
015 ROB
016 R014
017 R015
018 R016
019 R017
020 ROle

021
021

024

HEADING OR MESSAGE

R019
R020
R021
R022

OUTPUT
OESC

OUTPUT
EDIT

ACCUN
NUM

LINE
ADV

006
051
069

ROO~

Rooa

022

P~S

POOl
ROO4
ROOS
ROO6
R007

010
012

08/27/82

OUTPUT ITEMS
PRUfT

SOURCE

009

LIST DAlE

PRODUCT INFORMAl
ION REPORT
STOC~ NunBER
CAT
DESCRIPTION
BIN
UNIT
PRICE
DISC CD
REPL COST
LAST ISSUE
ON HAND
HINInU" OH
ON ORDER
DELIVERY DT
PTO UNITS

PAGE HEADER

001
002
003
004
005
006
007
008

PRODLIST

054
064
05$
069
006

002

" 02

002
003

020
028
056
078
088
100
001

114

028
0~8

051
062
079

095
002

114

NUMERIC EDIT
PRINT
I PRINT
2 BLANK
1 BLANK

IF
IF
IF
IF

CODES :

ZERO rm COMnAS
ZERO COMMAS
ZERO rm CDH"AS
ZERO COMMAS

B-19

0.40

LIST TIME 09:44:13

BUR R0 UGH S DAT A "A" AGE R
PROGRAM NAME

PRDDLIST

LIST DATE

08/27/82

REPL. PROTECT rm CD ""AS
REPL. PRDTECT CO""AS
6 DATE PRINTED WITOUT SEPARATOR
4 ZERO
5 ZERO

PAGE HEA[lER

FUNCTION

001 Pl=P1tl

·REPORT

BODV

STRUCTURE

LEVEL 3 HEADER
t~
LEVEL 2 HEADER
"
LEVEL 1 HEADER N
DETAIL ITEM Y
LEVEL 1 TRAILER t.
lEVEL 2 TRAILER
N
LEVEL 3 TRAILER
N
FIELDS THAT TRIGGER THE PRINTING DF THE HEADERS AND TRAILERS
SOURCE

FILE

P~S

LENGTH

OUTPUT
EDIT

ACCU"
NUH

LEVEL 1

lEVel 1
LEVEL 2
lEVEL 3

DETAIL ELE"Etn

OUTPUT ITEns
PRINT

SOURCE
001
002
OOj
004
005
006
007
008
009
010

AOOt
A002
AOO4
AOO~

POS

OUTPUT
DESC

lUE
ADV

010
022
028
056

AOll
A012
A014
Aon
A016
A006

073
092
099

011 AOOS
012 A007
OB A009
014 AOl?
015 AOIS
016 A019

043
054
065
076
091
109

065

116

029

NU"ERIC EDIT

.,
~

001

1
3

3
1
1

002

CODES :
B-20

0.40

LIST TIME 09:44:13

BUR RDUG H5 DRT A "A" AGE R
PROGRAM NAME

PRODLIST

LIST DATE

08/27/82

PRINT IF ZERD NO COMMAS
1 PRINT IF ZERO COMMAS
2 BLAr~K 1F ZERO ND COMMAS
l BLANK IF ZERO COMMAS
4 ZERO REPL. PROTECT NO CO "MAS
5 ZERO REPL. PROTECT COMMAS
6 DATE PRIUTED WITDUT SEPARATOR

B-21

0.40

LIST TIME 09:44:11

BUR R0 UGH S DRTR "R NRGE R
PROGRAM NAME

ICHENUI

lIST DATE

CREATE VERSION

0.40

LIBRARY riAME

leLIB

PROGRAM NAME

ICMENU1

PROGRAM SIZE

00898

FORM HEADING

B20 DATA MANAGER INVENTORY CONTROL SYSTEM

PRDGRAM TYPE

STANDARD MENU

08/26/82

PRDGRAM HELP
ERROR HELP
PROGRAM VERSION
STANDARD FORM

"ENU

HERDING

B20 DATA MANAGER INVErnORY CONTROL SYSTEM

SELECTION PROMPT SELECTION NUMBER PROMPT HELP FORM
PROGRAM NAME
01 PRODUTIL
02 STOCKING
O~ ISSUES
04 PR-ENTRY
05 PR-JOURHAL
06 PR-UPDATE
07 lOWSTDCK
08 PRE-PRODLlST
09 PERIOD-END

DESCRIPTION

LANGUAGE

ENTER DR CHARGE PRODUCT INFORMATION
STOCK ON HAND INQUIRY
iNVENTORY ISSUE TRANSACTIONS
ENTER INVENTDRY PURCHASES AND RECEIPTS
PRINT PURCHASES AND RECEIPTS JOURNAL
UPDATE INVENTORY PURCHASES RHD RECEIPTS
PRINT BUYER'S GUIDE
PRINT PRODUCT INFORMATION REPORT
PERIOD END UPDATE

Dtt
OM
DH
DM
DM
DM
DH
DM
DH

B-22

0.40

LIST TIME 16:04:00

Source Exif Data:

File Type                       : PDF
File Type Extension             : pdf
MIME Type                       : application/pdf
PDF Version                     : 1.3
Linearized                      : No
XMP Toolkit                     : Adobe XMP Core 4.2.1-c043 52.372728, 2009/01/18-15:56:37
Producer                        : Adobe Acrobat 9.2 Paper Capture Plug-in
Modify Date                     : 2009:12:26 16:05:42-08:00
Create Date                     : 2009:12:26 16:05:42-08:00
Metadata Date                   : 2009:12:26 16:05:42-08:00
Format                          : application/pdf
Document ID                     : uuid:a5c40092-5cf0-4900-873c-5fcc20f35083
Instance ID                     : uuid:3566248a-f99b-4757-a3e2-9c020e9c7b29
Page Layout                     : SinglePage
Page Mode                       : UseNone
Page Count                      : 171

EXIF Metadata provided by EXIF.tools

1143211_B20_Systems_Data_Manager_Training_Guide_Oct82 1143211 B20 Systems Data Manager Training Guide Oct82

1143211_B20_Systems_Data_Manager_Training_Guide_Oct82 1143211_B20_Systems_Data_Manager_Training_Guide_Oct82

Navigation menu

Versions of this User Manual:

Views

Navigation