Version: 8.5 and Above

Currently, the User Defined CSV Export column heading is predefined and is static. Sometimes a CSV layout is defined to compare current month, last month, and prior month. For example, if current month is December, last month is November, prior month is October. In the layout, you can specify the month as "CP" = Current Period, LP=Last Period, PP=Prior Period. But You can't put December, November, and October as the column headings, since next month the column headings will change. Therefore, with this feature we support the following variables in the column heading:
* <MON>: The three digits month like Jan, Feb, Mar...etc.
* <MONTH>: The full month name like January, February....etc.
* <MM>: Two digits month like 01, 02...,11, 12.
* <YR>: The two digit year.
* <YEAR>: The 4 digit year.
* <TODAY>: System date in MM/DD/YY format.

These variables must be in upper case and can be combined with other constants or variables. If the column heading has any characters other than the above variables, the variable will be replaced by the appropriate "To" period month or year value.

If the "From" and "To" dates are the same, only one value will appear in the column heading. Ex: "<MONTH>, <YEAR>" would become November, 2020.

If the "From" and "To" dates are not the same, the column heading will show both dates. Ex: "<MON>/<YR> to " would become Sep/20 to Nov/20

Keep in mind that the maximum column heading in layout maintenance is 17 digits. You must define the heading including variables with less than 17 digits. It is not an issue If the translated result from variables yields a heading longer than 17 digits since the actual CSV heading has no limit.

In the column heading, the application offers an "F7=Heading Variable Help" option which displays a window of the possible variables and how to combine them. Nothing will return back from F7.

In the attached example, the column heading of the following in December 2022 would be:

* Column 24: SafetyStk <TODAY> 
* Column 25: Use <MM>/<YR> to
* Column 26: Use <MONTH> <YR>
* Column 27: QtyInv <MM>/<YR>-
will become:
* Column 24: SafetyStk 12/30/22
* Column 25: Use 01/22 to 12/22
* Column 26: Use December/22
* Column 27: QtyInv 10/22-12/22

The variable <TODAY> in the column heading is used to indicate the date when the CSV is created. 

It is possible that a variable value can't be rendered. In that case, the variable will be kept as it is and displayed in the heading.

Programs Modified: CSVOUTPT.WS, IMCCLMNT, IMSLSHCP

CLS