!!!WHERE CLAUSE CREATOR DIALOG

The Where Clause Creator Dialog [MMWCC] screen allows you to create a Where Clause.  The data in the dialog is stored on the [P2K_AM_WHERE_CLAUSES] and [P2K_AM_CONDITIONS] tables.

Where Clause
Data Source Name
Where Clause Usage
Description
Type
Predefined
Column
Operator
Value
Test Where Clause

;[Table Note is Attached| ]:
;[User Notes For| ]:
;[Note Type|NOTE_TYPE_CODE]:The type of note is defined in this field.
;[File Name (on Server)|FILE_NAME]:
;[File Name (in DB)|FILE_NAME]:
;[Start Date|NOTE_START_DATE]/[End Date|NOTE_END_DATE]:The start and end dates of the note are defined in these fields.
;[Note Text|NOTE_TEXT]:The actual note text is provided in this field.
;[Created By|CREATE_USER]:The individual who created the note is identified in this field.
;[Create Date|CREATE_DATE]:The date the note was created is indicated in this field.
;[Last Change User|CHANGE_USER]:The last user to change the note is identified in this field.
;[Last Change Date|CHANGE_DATE]:The date the note was last changed is indicated in this field.

[cleanup]

----
![Notes|Edit:Internal.MMWCC] 	
[{InsertPage page='Internal.MMWCC' default='Click to create a new notes page'}]