Practice - Suppliers
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
-
2007/10/02 14:57:18.461
openvpms
localhost
MYSQL
Native
openvpms-setup
3306
openvpms
Encrypted 2be98afc86aa7f2e4a409ab7ec882a2c9
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
PORT_NUMBER3306
STREAM_RESULTSY
USE_POOLINGN
Select valuesModified Java Script ValueY Modified Java Script ValueSuppliersY Text file inputSelect valuesY
Modified Java Script Value
ScriptValueMod
Y
1
none
0
Script 1
//Script here
var ACTIVE = true
ACTIVE
ACTIVE
Boolean
-1
-1
300
113
Y
Select values
SelectValues
Y
1
none
SUPPLIERID
-2
-2
CODE
-2
-2
NAME
-2
-2
DESCRIPTION
-2
-2
PHONE1
-2
-2
PHONE2
-2
-2
ADDRESS1
-2
-2
TOWN
-2
-2
STATE
-2
-2
POSTCODE
-2
-2
191
113
Y
Suppliers
OpenVPMSLoaderPlugin
Y
1
none
openvpmsCODENAME<party.supplierorganisation>namefalsefalseACTIVE<party.supplierorganisation>activefalsefalseADDRESS1<party.supplierorganisation>contacts[0]<contact.location>addresstruefalseTOWN<party.supplierorganisation>contacts[0]<contact.location>suburbtruefalsePOSTCODE<party.supplierorganisation>contacts[0]<contact.location>postcodetruefalseSTATE<party.supplierorganisation>contacts[0]<contact.location>statetruefalsePHONE1<party.supplierorganisation>contacts[1]<contact.phoneNumber>telephoneNumbertruefalsePHONE2<party.supplierorganisation>contacts[2]<contact.phoneNumber>telephoneNumbertruefalsetruetrue1000
431
114
Y
Text file input
TextFileInput
Y
1
none
N
,
"
N
1
1
N
1
N
80
0
Y
N
N
N
DOS
${NETVET_DATA}/suppliers.txt
CSV
None
SUPPLIERID
Integer
$
.
,
-
-1
6
0
none
N
CODE
String
-
-1
8
-1
none
N
NAME
String
-
-1
50
-1
none
N
DESCRIPTION
String
-
-1
50
-1
none
N
PHONE1
String
ddMMyyyy
$
.
,
-
-1
15
-1
none
N
PHONE2
String
yyyy/MM/dd HH:mm:ss.SSS
$
.
,
-
-1
15
-1
none
N
ADDRESS1
String
$
.
,
-
-1
50
0
none
N
TOWN
String
-
-1
30
-1
none
N
STATE
String
-
-1
30
-1
none
N
POSTCODE
String
$
.
,
-
-1
15
0
none
N
0
N
N
warning
error
line
Y
en_au
86
119
Y