Database Field Pre-Allocation
When you create a form template, the system pre-allocates database space for a set number of fields, regardless of whether you use them. You cannot add fields beyond the pre-allocated number.
The pre-allocated limit is per form template. For example, if the maximum number of Integer fields is 30, you can design form template A with 30 Integer fields and design form template B with 30 Integer fields.
Some field types share the same database space. For example, Text fields and Multiline Text fields share the same space and are stored as string fields. If the maximum for string fields is 40, you could have 30 Text fields and 10 Multiline Text fields, or any other combination of those fields, up to 40.
Header-Level vs Line-Level Fields
The system differentiates header-level and line-level fields. Header-level fields are fields that you add anywhere to your form template design, except in line-item tables. Line-level fields are fields that you add only to a line-item table.
The system keeps track of available, used, and total pre-allocated fields for each form template design. To see how many fields you have used, you must save your form template, but you do not have to publish it.
Procedure: Review Available and Total Pre-Allocated Fields for Form Templates
- Select Manage → Administration
- Select Customization Manager → Available Flex Fields
- For header-level fields, search for the name of the form template
- For line-level tables, search for the name of the table
Procedure: Review Available and Used Pre-Allocated Fields for Form Templates
- Select Manage → Administration
- Select Customization Manager → Class Browser
- For header-lever fields, search for the name of the form template
- For line-level tables, search for the name of the table
Pre-Allocated Header-Level Fields
The following table shows the pre-allocated header-level fields in a form template.
| Type in General Tab drop down | Corrsponding Type in Class Browser - Available Flex Fields | Pre-Allocated Number |
|---|---|---|
| Decimal Number | BigDecimal | 35* |
| Percentage | BigDecimal | |
| Boolean | Boolean | 30 |
| Commodity Multiple Select | CommodityCode Vector | 1 |
| Date | Date | 25* |
| Date (Calendar) | Date | |
| Department Multiple Select | Department Vector | 1 |
| Flex Master Data | DynamicFlexMasterData | 8 |
| Flex Master Data Multiple Select | DynamicFlexMasterData Vector | 3 |
| Integer | int | 30 |
| Money | Money | 20 |
| Supplier Multiple Select | Organization Vector | 1 |
| Product Multiple Select | Product Vector | 1 |
| Region Multiple Select | Region Vector | 1 |
| Long Text | ShortMultiLocaleString | 35* |
| Long Rich Text | ShortMultiLocaleString | |
| Multiline Text | String | 45* |
| Text | String | |
| URL Link | String | |
| Text Multiple Select | String Vector | 12 |
| User Multiple Select | User Vector | 5 |
Note
* Field types that share the same pre-allocated space.Pre-Allocated Line Level Fields
The following table shows the pre-allocated line-level fields in a form template.
| Type in general Tab drop down | Corresponding Type in Class Browser - Available Flex Fields | Pre-Allocated Number |
|---|---|---|
| Decimal Number | BigDecimal | 5* |
| Percentage | BigDecimal | |
| Boolean | Boolean | 5 |
| Commodity | CommodityCode | 1 |
| Date | Date | 3* |
| Date (Calendar) | Date | |
| Department | Department | 1 |
| Flex Master Data | DynamicFlexMasterData | 10 |
| Integer | int | 5 |
| Money | Money | 5 |
| Supplier | Organization | 1 |
| Product | Product | 1 |
| Region | Region | 1 |
| Long Text | ShortMultiLocaleString | 3* |
| Long Rich Text | ShortMultiLocaleString | |
| Multiline Text | String | 7* |
| Text | String | |
| URL Link | String | |
| User | User | 4 |
Note
*Field types that share the same Pre-Allocated space.