98.2.1 ADD-FTBL

Create a user-specific format.
The format can contain any number of variable field elements.
The AMO enters the format and the description of any variable fields into the format tables.
A format consists of texts and variable fields. The variable fields start with the character ’#’. (’#’ means: variable field with one character.)
The number of ’@’ characters indicates how many characters the variable field contains plus 1 (character ’#’). (#@@@ means: variable field with 4 characters.)
Based on this code, the AMO determines whether variable fields are included in the format to be generated and then requests the field description for each variable field (e.g., alignment, comma character).
Since the following DIALOG activities cannot be taken into account during the generation process for ADD-FTBL, a branch parameter TYPE (input mode) was included in the parameter tree. If the value D (dialog)is declared for the parameter TYPE, then the field descriptions in the DIALOG are reloaded. If, however, the value B (batch) is declared, then no DIALOG activities are carried out, i.e. the user then carries the responsibility for ensuring that all the entries have been made (no operator prompting).
Formats 1 to 16: standard formats
These are formats that can be specifically selected by means of the parameters FORMBAS (format of base output device)and FORMRES (format of reserve output device) in AMO- SELG and AMO-GEZAB. All variable fields can occur in these formats.
Formats 17 to 24: formats for the start-of-block (basic device)
In AMO-SELG, the parameters BLBAS (block size of base device) and BLRES (block size of reserve device) can be used to define the block sizes for output. The block size indicates how many call data records are grouped into a continuous output. For each start of this type of block, formats 17-24 are entered into the corresponding selection groups 1 to4 (format 17 in selection group 1, format 18 in selection group 2, etc.).
Formats 25 to 32: formats for the start-of-block (reserve device)
See formats 17-24, but only for reserve devices.
Formats 33 to 40: formats for the end-of-block (basic device)
See formats 17-24, but only for end-of-block and basic devices.
Formats 41 to 48: formats for the end-of-block (reserve device)
See formats 17-24, but only for end-of-block and reserve devices.
By formats (17-48) for the selection groups remain gaps because the number of the selection groups are limited to 4.
Formats 49 to 56: formats for start-of-block (dialog/output by means of a call)
In AMO-GEZAB, the parameter BLKSIZE (block size, number of records per output block) can be used to define block sizes for output in interactive mode. Formats 49-56 are output at each start of this type of block for the corresponding dialog fields 1 to 8 (format 49 in dialog field 1, etc.).
Formats 57 to 64: formats for end-of-block (dialog/output by means of a call).
See formats 49-56, but only for end-of-block.
Formats 65 to 72: formats for end-of-data in a file (dialog/output by means of a call)
These formats are output when the actual call data output is ended.
Formats 73 to 80: formats for "empty files" (dialog/output by means of a call)
These formats are output when the selected file is empty.
Formats 81 to 88: formats for "deleted files" (dialog/output by means of a call)
The formats are output if the file is deleted after a delete job.
Formats 89 to 96: formats for ending the output
These formats are output if the system wishes to end the data output.
Formats 97 to 109: formats for station CDR output
These formats are needed for CDR output.
Only the variable data elements ’time of output’, ’block length’, and ’number of records per block’ are permitted in formats 17 to 96.
Procedure Overview
 
Command Code
Parameter
 
ADD-FTBL
FORMNO=<number>
 
 
,TYPE=D,FORMAT=<string>;
(1)
 
 
 
 
,TYPE=B,TBL=FORM,NO=<number>,END=Y/N,FORMAT=<string>;
(2)
 
 
 
 
      ,TBL=CTRL,NO=<number>,END=Y/N,CTLCHARS=<param>;
(3)
 
 
 
 
      ,TBL=FIELD,NOFELD=<number>,FLDNAME=<param>
      ,FILLTYPE=CHAR,FILLER=<string>
      ,FLDALIGN=L/R;
      ,FLDALIGN=LC/RC,COMPOS=<number>;
(4)
 
 
 
 
      ,FILLTYPE=NONE,FLDALIGN=L/R;
      ,FLDALIGN=LC/RC,COMPOS=<number>;
(5)
NOTE:
The value B (batch) should only be declared for the branch parameter TYPE (input mode) when using command stacks. For manual applications, the operator should continue to use the DIALOG procedure (TYPE=D).
Control characters can also be entered in the branch B (batch). However, care should be taken that they are entered in the correct position of the format.
The following example shows the function of the input.
Example:
Input of format 50 with a command batch.
The format should look like this:
+----------+
| |
+----------+
The individual lines should be terminated with a carriage return, and there should be a page feed at the start of the format.
Input:
ADD-FTBL:FORMNO=50,TYPE=B,TBL=CTRL,NO=1,END=N,CTLCHARS=FF;
ADD-FTBL:FORMNO=50,TYPE=B,TBL=FORM,NO=2,END=N,FORMAT=" +----------+";
ADD-FTBL:FORMNO=50,TYPE=B,TBL=CTRL,NO=3,END=N,CTLCHARS=CR;
ADD-FTBL:FORMNO=50,TYPE=B,TBL=CTRL,NO=4,END=N,CTLCHARS=LF;
ADD-FTBL:FORMNO=50,TYPE=B,TBL=FORM,NO=5,END=N,FORMAT=" | |";
ADD-FTBL:FORMNO=50,TYPE=B,TBL=CTRL,NO=6,END=N,CTLCHARS=CR;
ADD-FTBL:FORMNO=50,TYPE=B,TBL=CTRL,NO=7,END=N,CTLCHARS=LF;
ADD-FTBL:FORMNO=50,TYPE=B,TBL=FORM,NO=8,END=N,FORMAT=" +----------+";
ADD-FTBL:FORMNO=50,TYPE=B,TBL=CTRL,NO=9,END=N,CTLCHARS=CR;
ADD-FTBL:FORMNO=50,TYPE=B,TBL=CTRL,NO=10,END=Y,CTLCHARS=LF;
Branch: DIALOG FTBL
This procedure is a job for requesting the field description of the individual variable fields of the entered format.
The AMO checks to determine if the character ’#’ occurs in the entered format. If so, then variable fields are included in the format, and the AMO uses the prompt to request the field descriptions for the variable fields.
Example
Create format table 4 with the following fixed and variable data elements:
Trunk Number 4 characters, fill character "0", aligned to the right.
Paying Party 6 characters, fill character "0", aligned to the left.
Units 4 characters, fill character "0", aligned to the right.
Destination with 7 characters, fill character " ", aligned to the right.
The AMO requests the prompt that the parameters for the variable data fields be entered. The sequence is shown in the section for the command ADD-FTBL.
Input:
ADD-FTBL:FORMNO=4,TYPE=D,FORMAT=" SETNO.:#@@@ COSTNO.:#@@@@@ UNIT:#@@@ DESTNO.:#@@@@@@";
Output:
H01: ENTER FIELD DESCRIPTION FOR THE 1ST VARIABLE FIELD
FLDNAME =
Input:
RECNO
Output:
FILLTYPE =
Input:
CHAR
Output:
FILLER =
Input:
0
Output:
FLDALIGN =
Input:
R
Output:
COMPOS =
Input:
<carriage return>
Output:
H01: ENTER FIELD DESCRIPTION FOR THE 2ND VARIABLE FIELD
FLDNAME =
Input:
CHRGEE
Output:
FILLTYPE =
Input:
CHAR
Output:
FILLER =
Input:
0
Output:
FLDALIGN =
Input:
L
Output:
COMPOS =
Input:
<carriage return>
Output:
H01: ENTER FIELD DESCRIPTION FOR THE 3RD VARIABLE FIELD
FLDNAME =
Input:
CHRGUNIT
Output:
FILLTYPE =
Input:
CHAR
Output:
FILLER =
Input:
0
Output:
FLDALIGN =
Input:
L
Output:
COMPOS =
Input:
<carriage return>
Output:
H01: ENTER FIELD DESCRIPTION FOR THE 4TH VARIABLE FIELD
FLDNAME =
Input:
DESTPTY
Output:
FILLTYPE =
Input:
CHAR
Output:
FILLER =
Input:
" "
Output:
FLDALIGN =
Input:
R
Output:
COMPOS =
Input:
<carriage return>
NOTE:
The connection durations HOUR, MINUTE, and SECOND are entered right-justified with the fill character 0.
The parameters for the end-of-connection MONTH, DAY, HOUR, and MINUTE are entered right-justified and with the fill character 0.
OpenScape 4000 V10, Volume 1: AMO Descriptions, Service Documentation, Issue 5, ID: P31003H31A0S107057620
 © 09/2025 Mitel Networks Corporation. -  All rights reserved.
 Mitel and the Mitel logo are trademarks of Mitel Networks Corporation. Unify and associated marks are trademarks of Unify Software and Solutions GmbH&Co. KG. All other trademarks herein are the property of their respective owners.