If string: Existing header name in the table where the total values are located which need to be distributed.
If numeral: This will be the generalized total value applicable for all table rows.

If string: Existing header name in the table where the batch sizes are located which need to be distributed.
If numeral: This will be the generalized batch size applicable for all table rows.

If string: Existing header name in the table where the start dates are specified for every row.
If date: This will be the generalized start date applicable for all table rows.

If string: Existing header name in the table where the end dates are specified for every row.
If date: This will be the generalized end date applicable for all table rows.
If numeral: Capacity (number of units) per day, applicable for all table rows.

Attention: In case a table column for end dates is specified, then only the table rows containing valid end dates as well as end dates not earlier than start dates or valid capacity per day values will be processed. Otherwise, the rows will be skipped. No exceptions (error messages) are asserted. This feature may be useful to skip specific rows intentionally.

This parameter determinse if you want to do a plan on daily, weekly, monthly or other basis. Note that a daily planning is the most fine-grained option and produces the biggest and most detailed plans.
Valid values are: days, weeks, whole weeks, months, whole months, quarters, whole quarters, quarters whole moths, years, whole years, years whole months, years whole quarters.
Theese values are exaplined listed in the 5th parameter of the function distribute().

Usance is a work and trade practice parameter which is used in association with the 5th function parameter Intervals.
Valid values are: calendar, mon_fri, mon_sat, 30_360.
Theese values are exaplined listed in the 6th parameter of the function distribute().

This value specifies the starting date for the output to generate. If 5th parameter is not 'days', then the date will be moved back to the begin of the chosen interval (weeks, months, quarters, years). E.g. if '31.05.2017' is specified for months, then the whole month of May will be considered.

This value specifies the ending date for the output to generate. If 5th parameter is not 'days', then the date will be moved forward to the end of the chosen interval (weeks, months, quarters, years). E.g. if '01.05.2017' is specified for months, then the whole month May will be considered.

Specify '' (single quotation marks) or {} (empty set) for standard date format YYYY-MM-DD
Specify 1 value (1 element in parameter set, or 1 string) to specify the formatting template as specified in numeral to string conversion and formatting.
Specify 2 values (parameter set or softquoted string, values separated by comma) where the 2nd value is the locale value (formatting option), (exmaple: en_US).
Specify 3 values (like above) where the 3rd value is the placeholder symbol, also defined in numeral to string conversion and formatting.

Specify the column name or column number where to insert the distributed values. Use -1 (negative indexing is supported) to append the values on the right hand side of the table.
Attention: Column insertion takes place regardless if the column with same date line names do already exist or not. All other columns further to the right will be shifted accordingly to avoid overwriting existing contents. Exception to the rule: If the unquoted or softquoted string '#existing' (use no quotation or single quotation marks, but not double quotation marks) is specified, then B4P looks for the existing column names along the time line. The existing columns must be in the same sequence as the new ones being created. This allows you to call the function table distribute followed by table distribute accumulate on the same table where the distributed values are added up. See table columns as function parameters for general ruling for this parameter.
Specific rules apply for this function:

• Only 1 header name or column number may be specified.

Specify at most 1 column header name or column number where to insert the values which lie before the range specified between output start date (8th function parameter). See table columns as function parameters for general ruling for this parameter.
Specific rules apply for this function:

• At most 1 header name or column number may be specified.

Specify at most 1 column header name or column number where to insert the values which lie after the range specified between output end date (9th function parameter). See table columns as function parameters for general ruling for this parameter.
Specific rules apply for this function:

• At most 1 header name or column number may be specified.

A set of dates may be supplied to declare specific days as bank holidays so these days will not be counted. This parameter is rejected if the Usance '30_360' is chosen. The dates may be provided as data type date or string containing legitimate dates. Type conversion to dates takes place automatically.

Use the year 1900 (lies well in the past and this is good so) in order to declare bank holidays as anually repeating bank holidays. Example: "1900-07-14" declares French national holiday for every year.

A set of dates may be supplied to declare school holidays (vacation days). This parameter is rejected if the Usance '30_360' is chosen. The dates may be provided as data type date or string containing legitimate dates. Type conversion to dates takes place automatically. An even number of dates must be specified as the first date describes the first vacation day and the next date describes the last vacation day.

Use the year 1900 (lies well in the past and this is good so) in order to declare school holidays (vacation) as anually repeating events.
Example: "1900-07-01", "1900-07-21" declares the first 3 weeks of every July as vacation.

true if all values have been distributed successfully into the date columns or columns designated for earlier sums or later sums as defined with the 12th and 13th function parameters.
falseAt least in one table row, the total value cannot be distributed into the tiven output range. Either the earlier sums / later sums have not been provided, or all days are blocked (e.g. time range consisting just of weekends, bank holidays or school holidays (vacation)), or end dates lie before start dates.