Table and field numbers for the form object

Table 25 lists the table numbers for T records and field numbers for V records for the form object. Each number corresponds to a particular part of the form.

Field 3080, a V record, acts as a "trigger" for the break panels that follow it. This record appears once for every break panel in your form. The value of the field reflects the number of the break panel that the fields following field 3080 describe.

Table 25. Table and field numbers for exported form object
Table or field number Record type Description Form panel
1110 T Column headings table FORM.COLUMNS
1112 R Column data type 4 FORM.COLUMNS
1113 R Column heading FORM.COLUMNS
1114 R Column usage code FORM.COLUMNS
1115 R Column indentation FORM.COLUMNS
1116 R Column width FORM.COLUMNS
1117 R Column edit code FORM.COLUMNS
1118 R Column sequence FORM.COLUMNS
1119 R Column heading alignment 5 FORM.COLUMNS
1120 R Column data alignment 5 FORM.COLUMNS
1121 R Column definition 5 FORM.COLUMNS
1122 R Pass nulls on column definition 5 FORM.COLUMNS
       
1180 T Summary calculations table FORM.CALC
1182 R Calculation identification number FORM.CALC
1183 R Summary calculation expression FORM.CALC
1184 R Summary calculation width FORM.CALC
1185 R Summary calculation edit code FORM.CALC
1186 R Pass nulls on calculation 5 FORM.CALC  
1201 V Blank lines before heading FORM.PAGE
1202 V Blank lines after heading FORM.PAGE
1210 T Page heading table FORM.PAGE
1212 R Page heading line number FORM.PAGE
1213 R Page heading alignment FORM.PAGE
1214 R Page heading text FORM.PAGE  
1301 V Blank lines before footing FORM.PAGE
1302 V Blank lines after footing FORM.PAGE
1310 T Page foot table FORM.PAGE
1312 R Page footing line number FORM.PAGE
1313 R Page footing alignment FORM.PAGE
1314 R Page footing text FORM.PAGE  
1401 V New page for final text FORM.FINAL
1402 V Final summary line number FORM.FINAL
1403 V Blank lines before final text FORM.FINAL
1410 T Final text table FORM.FINAL
1412 R Final text line number FORM.FINAL
1413 R Final text alignment FORM.FINAL
1414 R Final text FORM.FINAL  
1501 V Detail line spacing FORM.OPTIONS
1502 V Outlining for break columns FORM.OPTIONS
1503 V Default break text FORM.OPTIONS
1504 V Function name in column heading for grouping FORM.OPTIONS
1505 V Column-wrapped lines kept on a page FORM.OPTIONS
1506 V Across-summary column FORM.OPTIONS
1507 V Separators for column heading FORM.OPTIONS
1508 V Separators for break summary FORM.OPTIONS
1509 V Separators for across heading FORM.OPTIONS
1510 V Separators for final summary FORM.OPTIONS
1511 V Width of wrapped report lines FORM.OPTIONS
1512 V Page re-numbering at breaks FORM.OPTIONS
1513 V Width of break or final text FORM.OPTIONS
1514 V Column re-ordering FORM.OPTION
1515 V Fixed columns FORM.OPTIONS  
2790 V Detail variation number FORM.DETAIL
2791 V Detail variation selection FORM.DETAIL
2805 V Include column heading FORM.DETAIL
2810 T Detail heading table FORM.DETAIL
2812 R Detail heading text line FORM.DETAIL
2813 R Detail heading alignment FORM.DETAIL
2814 R Detail heading text FORM.DETAIL
2901 V New page for detail text FORM.DETAIL
2902 V Line number of column data FORM.DETAIL
2904 V Number of lines to skip after detail text FORM.DETAIL
2906 V Repeat detail heading FORM.DETAIL
2907 V Number of detail text lines to keep together FORM.DETAIL
2910 T Detail text table FORM.DETAIL
2912 R Detail text line number FORM.DETAIL
2913 R Detail text alignment FORM.DETAIL
2914 R Detail text FORM.DETAIL  
3080 V Break panel number 5 FORM.BREAKn
3101 V New page for break heading 5 FORM.BREAKn
3102 V Repeat break heading 5 FORM.BREAKn
3103 V Number of lines to skip before break heading 5 FORM.BREAKn
3104 V Number of lines to skip after break heading 5 FORM.BREAKn
3110 T Break heading text table 5 FORM.BREAKn
3112 R Break heading line number 5 FORM.BREAKn
3113 R Break heading alignment 5 FORM.BREAKn
3114 R Break heading text 5 FORM.BREAKn  
3201 V New page for break text 5 FORM.BREAKn
3202 V Break text summary line 5 FORM.BREAKn
3203 V Number of lines to skip before break text 5 FORM.BREAKn
3204 V Number of lines to skip after break text 5 FORM.BREAKn
3210 T Break text table 5 FORM.BREAKn
3212 R Break text line 5 FORM.BREAKn
3213 R Break text alignment 5 FORM.BREAKn
3214 R Break text 5 FORM.BREAKn  
3310 T Conditions table 5 FORM.CONDITIONS
3312 R Condition identification number 5 FORM.CONDITIONS
3313 R Conditional expression 5 FORM.CONDITIONS
3314 R Pass nulls on conditions panel 5 FORM.CONDITIONS

Table 26 shows fields that are valid for objects that were created before Version 3 Release 1. QMF accepts these fields on input, but does not create them on output. There is a unique set of field numbers for each break panel.

Table 26. Field numbers for exported form object, before QMF 3.1
Table or field number Record type Description Form panel
1601 V BREAK1: New page for heading FORM.BREAK1
1602 V BREAK1: Repeat column headings FORM.BREAK1
1603 V BREAK1: Blank lines before heading FORM.BREAK1
1604 V BREAK1: Blank lines after heading FORM.BREAK1
1610 T BREAK1: Heading table FORM.BREAK1
1612 R BREAK1: Heading lines FORM.BREAK1
1612 R BREAK1: Heading alignment FORM.BREAK1
1614 R BREAK1: Heading text FORM.BREAK1
 
1701 V BREAK1: New page for footing FORM.BREAK1
1702 V BREAK1: Repeat column footings FORM.BREAK1
1703 V BREAK1: Blank lines before footing FORM.BREAK1
1704 V BREAK1: Blank lines after footing FORM.BREAK1
1710 T BREAK1: Footing table FORM.BREAK1
1712 R BREAK1: Footing lines FORM.BREAK1
1713 R BREAK1: Footing alignment FORM.BREAK1
1714 R BREAK1: Footing text FORM.BREAK1
 
1801 V BREAK2: New page for heading FORM.BREAK2
1802 V BREAK2: Repeat column headings FORM.BREAK2
1803 V BREAK2: Blank lines before heading FORM.BREAK2
1804 V BREAK2: Blank lines after heading FORM.BREAK2
1810 T BREAK2: Heading table FORM.BREAK2
1812 R BREAK2: Heading lines FORM.BREAK2
1813 R BREAK2: Heading alignment FORM.BREAK2
1814 R BREAK2: Heading text FORM.BREAK2
 
1901 V BREAK2: New page for footing FORM.BREAK2
1902 V BREAK2: Repeat column footings FORM.BREAK2
1903 V BREAK2: Blank lines before footing FORM.BREAK2
1904 V BREAK2: Blank lines after footing FORM.BREAK2
1910 T BREAK2: Footing table FORM.BREAK2
1912 R BREAK2: Footing lines FORM.BREAK2
1913 R BREAK2: Footing alignment FORM.BREAK2
1914 R BREAK2: Footing text FORM.BREAK2
 
2001 V BREAK3: New page for heading FORM.BREAK3
2002 V BREAK3: Repeat column headings FORM.BREAK3
2003 V BREAK3: Blank lines before heading FORM.BREAK3
2004 V BREAK3: Blank lines after heading FORM.BREAK3
2010 T BREAK3: Heading table FORM.BREAK3
2012 R BREAK3: Heading lines FORM.BREAK3
2013 V BREAK3: Heading alignment FORM.BREAK3
2014 R BREAK3: Heading text FORM.BREAK3
 
2101 V BREAK3: New page for footing FORM.BREAK3
2102 V BREAK3: Repeat column footings FORM.BREAK3
2103 V BREAK3: Blank lines before footing FORM.BREAK3
2104 V BREAK3: Blank lines after footing FORM.BREAK3
2110 T BREAK3: Footing table FORM.BREAK3
2112 R BREAK3: Footing lines FORM.BREAK3
2113 R BREAK3: Footing alignment FORM.BREAK3
2114 R BREAK3: Footing text FORM.BREAK3
 
2201 V BREAK4: New page for heading FORM.BREAK4
2202 V BREAK4: Repeat column headings FORM.BREAK4
2203 V BREAK4: Blank lines before heading FORM.BREAK4
2204 V BREAK4: Blank lines after heading FORM.BREAK4
2210 T BREAK4: Heading table FORM.BREAK4
2212 R BREAK4: Heading lines FORM.BREAK4
2213 R BREAK4: Heading alignment FORM.BREAK4
2214 R BREAK4: Heading text FORM.BREAK4
 
2301 V BREAK4: New page for footing FORM.BREAK4
2301 V BREAK4: Repeat column footings FORM.BREAK4
2303 V BREAK4: Blank lines before footing FROM.BREAK4
2304 V BREAK4: Blank lines after footing FORM.BREAK4
2310 T BREAK4: Footing table FORM.BREAK4
2312 R BREAK4: Footing lines FORM.BREAK4
2313 R BREAK4: Footing alignment FORM.BREAK4
2314 R BREAK4: Footing text FORM.BREAK4
 
2401 V BREAK5: New page for heading FORM.BREAK5
2402 V BREAK5: Repeat column headings FORM.BREAK5
2403 V BREAK5: Blank lines before heading FORM.BREAK5
2404 V BREAK5: Blank lines after heading FORM.BREAK5
2410 T BREAK5: Heading table FORM.BREAK5
2412 R BREAK5: Heading lines FORM.BREAK5
2413 R BREAK5: Heading alignment FORM.BREAK5
2414 R BREAK5: Heading text FORM.BREAK5
 
2501 V BREAK5: New page for footing FORM.BREAK5
2502 V BREAK5: Repeat column footings FORM.BREAK5
2503 V BREAK5: Blank lines before footing FORM.BREAK5
2504 V BREAK5: Blank lines after footing FORM.BREAK5
2510 T BREAK5: Footing table FORM.BREAK5
2512 R BREAK5: Footing lines FORM.BREAK5
2513 R BREAK5: Footing alignment FORM.BREAK5
2514 R BREAK5: Footing text FORM.BREAK5
 
2601 V BREAK6: New page for heading FORM.BREAK6
2602 V BREAK6: Repeat column headings FORM.BREAK6
2603 V BREAK6: Blank lines before heading FORM.BREAK6
2604 V BREAK6: Blank lines after heading FORM.BREAK6
2610 T BREAK6: Heading table FORM.BREAK6
2612 R BREAK6: Heading lines FORM.BREAK6
2613 R BREAK6: Heading alignment FORM.BREAK6
2614 R BREAK6: Heading text FORM.BREAK6
 
2701 V BREAK6: New page for footing FORM.BREAK6
2702 V BREAK6: Repeat column footings FORM.BREAK6
2703 V BREAK6: Blank lines before footing FORM.BREAK6
2704 V BREAK6: Blank lines after footing FORM.BREAK6
2710 T BREAK6: Footing table FORM.BREAK6
2712 R BREAK6: Footing lines FORM.BREAK6
2713 R BREAK6: Footing alignment FORM.BREAK6
2714 R BREAK6: Footing text FORM.BREAK6

4.
QMF does not display this field on the form panel.
5.
This field is new for Version 3.

[ Previous Page | Next Page | Contents | Index ]