Entry Column Dependencies Import File Format

# Header Description Req. Notes
1 PARENTTYPE Name of the field where the selections will drive filtering on the other columns. For example, the PARENTTYPE would be Activity if you wanted to set up filtering on the pay type options based on the Activity selected on a time entry screen. Y Field must match the name of an existing object (Entry Column name) in the Journyx database exactly, including capitalization.
2 PARENT The specific value or selection from the Entry Column that you want to filter on. For example, you might want to filter the bill type options for an Activity called "Technical Design". So, you would put Technical Design in this field. Y Selection name (specific Entry Column value) of the thing that you are filtering on. Must match the selection name exactly, including capitalization. You can include more than one value in this field by separating the values with a comma.
3 TYPE Name of the field where filtering will be applied based on the PARENTTYPE and PARENT. Y Field must match the name of an existing object (Entry Column name) in the Journyx database exactly, including capitalization.
4 OBJECT The specific value or selection from the Entry Column that you want to be included in the filtered list. For example, you can include a specific list of bill types that are eligible for the Technical Design activity mentioned in the example above. Y Selection name (specific Entry Column value) of the thing to included in the filtered list. Must match the selection name exactly, including capitalization. You can include more than one value in this field by separating the values with a comma.
5 ACTION This field can be used to remove existing column dependencies. N You can choose to delete an existing column dependency by placing the word "REMOVE" in all caps in this field. Otherwise this field is not needed or can be left blank.