Product - Reminders
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
admin
2007/04/09 17:01:13.040
RxWorks
MSACCESS
ODBC
RxWorks
-1
Encrypted
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
PORT_NUMBER-1
STREAM_RESULTSY
USE_POOLINGN
Item RemindersSelect valuesY Transform fieldsItem Reminders OutputY Select valuesTransform fieldsY
Item Reminders
TableInput
Y
1
none
RxWorks
select * from [Item List - Reminder System]
0
N
N
59
139
Y
Item Reminders Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsIDID<entityRelationship.productReminder>sourcetrue<product.*>$valuefalseREMINDERID<entityRelationship.productReminder>targettrue<entity.reminderType>$valuefalsePERIOD<entityRelationship.productReminder>periodtruefalseUNITS<entityRelationship.productReminder>periodUomtruefalsetruetrue1000
477
142
Y
Select values
SelectValues
Y
1
none
Item Code
ID
-2
-2
Item Reminder Code
REMINDERID
-2
-2
Item Default Period
PERIOD
-2
-2
Item Default Unit
UNITS
-2
-2
165
140
Y
Transform fields
ScriptValueMod
Y
1
none
0
Script 1
//Script here
UNITS.setString(upper(UNITS.getString()) + "S")
302
141
Y