When a valid Attribute has been selected, a window will appear that contains all valid field selections as defined under Attribute Master file maintenance. See sample screen below:
Select the desired Attribute field. The attribute field will be saved but will not show on the screen. A potentially truncated Attribute field description will be moved to the Col Heading for this Column. Save the CSV layout when finished adding columns.
Please note that when running the Custom CSV Export report, the value entered in field 6. Item Has Attribute, will only affect the selection of items for the report. The columns defined thru the AR Type will not be affected.
The following is a sample CSV export. Please note that the value in the Attribute column could be the following:
- The value that's stored in the corresponding item attribute
- Blank - if the item does not have such an Attribute, or if the reference value is blank, or if the date field = 00/00/00 or amount = 0
- Invalid - if the Attribute Type does not exist (deleted), or if the Attribute no longer has such a field