Section 11
Department/Transaction Codes
The
deptrans
table defines which
departments are permitted to process which transaction codes. In
order to process a
specific transaction code the system needs to first determine which
DEPT_CODE the register (or user) is
assigned to.
Once that is done, it then checks to see if the combination of
DEPT_CODE and
TRAN_CODE is
found
in the table. If no entry is found the user will not be able to
process that
TRAN_CODE.
This enables you to have some departments process some transaction
codes, and other
departments processes other transaction codes, yet they would not
see the codes
that "belong" to departments other than their own.
For more information related to how the system determines which
DEPT_CODE to use, see
DEPARTMENT-PRIORITY-MODE, which
controls which method is
used.
Each field in the table is listed, along with a short description,
below:
-
DEPT_CODE
This is the
department code.
-
TRAN_CODE
This is the
transaction code.
The database permits only one entry for each
combination of department/transaction. Attempts to add a duplicate
will result in a
"duplicate-key" message.
Here's an example of how this table is used. Suppose
you have 2 departments,
FIN and
REC. You might have some codes that
only
FIN registers (or users) should
process, and others that only
REC users would need to process. In
addition, there
might be some codes that users in both departments should be able to
use. To
implement this setup, you will need to make entries in the
DEPTTRANS table to cover all the valid
combinations... for
example:
| Dept_code
| Tran_Code
|
| FIN |
1000 |
| FIN |
1010 |
| FIN |
1020 |
| FIN |
1030 |
| FIN |
3000 |
| FIN |
3010 |
| FIN |
3020 |
| REC |
2000 |
| REC |
2010 |
| REC |
2020 |
| REC |
2030 |
| REC |
3000 |
| REC |
3010 |
| REC |
3020 |
In this example, the
1xxx series codes
would be able
to be used only by department
FIN users.
The
2xxx series codes would be accessible
only by users
in department
REC, and the
3xxx series codes will be available to both
departments.
By default, when you are add a new
Tran_Code
to
the
Transaction Codes Table, the program
will
automatically add an entry into this table for the department of the
user adding
the
tran_code. For example, if you are
assigned to
department
FIN, and add a new
tran_code the program will automatically
add an entry in the
depttrans table for you.
It will
NOT automatically add the
tran_code for any other departments. If you
want other
department users to be able to use the newly added
tran_code, you must manually make the
appropriate entries in
this table.
