Customer - Information
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
-
2007/04/24 21:06:54.196
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
Client InputSelect valuesY Select valuesMerge JoinY Row denormaliserMerge JoinY Merge JoinModified Java Script ValueY Modified Java Script ValueCustomer OutputY Client Phone NumbersSelect values 2Y Select values 2Row denormaliserY
Client Input
TableInput
Y
1
none
RxWorks
select * from client
0
N
N
105
172
Y
Client Phone Numbers
TableInput
Y
1
none
RxWorks
select * from [client phone numbers]
0
N
N
106
307
Y
Customer Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsCLIENTIDSURNAME<party.customerperson>lastNametruetrueFIRSTNAME<party.customerperson>firstNametruetrueTITLE<party.customerperson>titletruetrueINITIALS<party.customerperson>initialstruetrueADDRESS<party.customerperson>contacts[0]<contact.location>addresstruefalseADDRESS3<party.customerperson>contacts[0]<contact.location>suburbtruefalseSTATE<party.customerperson>contacts[0]<contact.location>statetruefalsePOSTCODE<party.customerperson>contacts[0]<contact.location>postcodetruefalseFAX<party.customerperson>contacts[1]<contact.faxNumber>faxNumbertruefalseWORK<party.customerperson>contacts[2]<contact.phoneNumber>telephoneNumbertruefalseHOME<party.customerperson>contacts[3]<contact.phoneNumber>telephoneNumbertruefalseEMAIL<party.customerperson>contacts[1]<contact.email>emailAddresstruefalseACCOUNTTYPE<party.customerperson>type[0]true<lookup.customerAccountType>$valuefalsetruetrue1000
675
215
Y
Merge Join
MergeJoin
Y
1
none
LEFT OUTER
Select values
Row denormaliser
CLIENTID
CLIENTID
392
217
Y
Modified Java Script Value
ScriptValueMod
Y
1
none
0
Script 1
//Script here
if (SURNAME.getString() == null || SURNAME.getString() == "") {
SURNAME.setString("No Name");
}
var ADDRESS = ""
if (ADDRESS1.getString() != null && ADDRESS2.getString() != null) {
ADDRESS = ADDRESS1.getString() + "\n" + ADDRESS2.getString();
}
else if (ADDRESS1.getString() != null) {
ADDRESS = ADDRESS1.getString();
}
var ACTIVE = !DEACTIVATED.getBool()
ACCOUNTTYPE.setString(replace(upper(ACCOUNTTYPE.getString())," ","_"))
ADDRESS
ADDRESS
String
-1
-1
ACTIVE
ACTIVE
Boolean
-1
-1
525
217
Y
Row denormaliser
Denormaliser
Y
1
none
PHONENAME
CLIENTID
PHONENUMBER
Fax
FAX
String
50
-1
-
PHONENUMBER
Work
WORK
String
50
-1
-
PHONENUMBER
Home
HOME
String
50
-1
-
PHONENUMBER
Email
EMAIL
String
50
-1
-
312
304
Y
Select values
SelectValues
Y
1
none
Client Number
CLIENTID
-2
-2
Surname
SURNAME
-2
-2
First Name
FIRSTNAME
-2
-2
Title
TITLE
-2
-2
Initials
INITIALS
-2
-2
Company
COMPANY
-2
-2
Address 1
ADDRESS1
-2
-2
Address 2
ADDRESS2
-2
-2
Address 3
ADDRESS3
-2
-2
State
STATE
-2
-2
Postcode
POSTCODE
-2
-2
Account Type
ACCOUNTTYPE
-2
-2
Deactivated Client
DEACTIVATED
-2
-2
225
174
Y
Select values 2
SelectValues
Y
1
none
Client Number
CLIENTID
-2
-2
Phone Name
PHONENAME
-2
-2
Phone Number
PHONENUMBER
-2
-2
216
306
Y