Customer - Information / YN
0.0 0.0 1000 1 1 N Y 5000 Y admin 2007/04/09 10:47:14.000 Text file inputSelect FieldsY Select FieldsTransform FieldsY Transform FieldsCustomer OutputY Customer Output OpenVPMSLoaderPlugin Y 1 none openvpmsCLNUMBERCLTITLE<party.customerperson>titlefalsefalseCLFSTNAME<party.customerperson>firstNamefalsefalseCLSURNAME<party.customerperson>lastNamefalsefalseACTIVE<party.customerperson>activefalsefalseCLPHONENUM<party.customerperson>contacts[0]<contact.phoneNumber>telephoneNumbertruetrueCLPHONEAREA<party.customerperson>contacts[0]<contact.phoneNumber>areaCodetruetrueCLPHONENUM<party.customerperson>contacts[0]<contact.phoneNumber>purposes[0]true<lookup.contactPurpose>code=HOMEtrueWKPHONENUM<party.customerperson>contacts[1]<contact.phoneNumber>telephoneNumbertruetrueWKPHONEAREA<party.customerperson>contacts[1]<contact.phoneNumber>areaCodetruetrueWKPHONENUM<party.customerperson>contacts[1]<contact.phoneNumber>purposes[0]true<lookup.contactPurpose>code=WORKtrueCLADDRESS<party.customerperson>contacts[3]<contact.location>addresstruetrueCLSUBURB<party.customerperson>contacts[3]<contact.location>suburbtruetrueCLSTATE<party.customerperson>contacts[3]<contact.location>statetruetrueCLPOSTCODE<party.customerperson>contacts[3]<contact.location>postcodetruetrueRESADDRESS<party.customerperson>contacts[4]<contact.location>addresstruefalseRESTOWN<party.customerperson>contacts[4]<contact.location>suburbtruefalseCODE<party.customerperson>identities[0]<entityIdentity.code>codetruetrueACCTYPE<party.customerperson>type[0]true<lookup.customerAccountType>$valuefalsetruetrue1000 466 147 Y Select Fields SelectValues Y 1 none CLIENTID CLNUMBER -2 -2 SURNAME CLSURNAME -2 -2 FIRSTNAME CLFSTNAME -2 -2 TITLE CLTITLE -2 -2 HOMEPHONE CLPHONE -2 -2 WORKPHONE WKPHONE -2 -2 ADDRESS1 CLADDRESS1 -2 -2 TOWN CLSUBURB -2 -2 STATE CLSTATE -2 -2 POSTCODE CLPOSTCODE -2 -2 CODE -2 -2 RESSTREET -2 -2 RESSUBURB -2 -2 ACCTYPE -2 -2 212 147 Y Text file input TextFileInput Y 1 none N , " N
Y
1
N
1 N 1 N 80 0 Y N N N DOS ${NETVET_DATA}\client.txt CSV None CLIENTID Integer $ . , - -1 6 0 none N CODE String $ . , - -1 10 0 none N SURNAME String - -1 30 -1 none N FIRSTNAME String - -1 30 -1 none N TITLE String - -1 15 -1 none N HOMEPHONE String - -1 20 -1 none N WORKPHONE String - -1 20 -1 none N ADDRESS1 String - -1 50 -1 right N TOWN String - -1 50 -1 none N STATE String - -1 15 -1 none N POSTCODE String $ . , - -1 10 0 none N RESSTREET String -1 50 -1 none N RESSUBURB String -1 30 -1 none N ACCTYPE String -1 15 -1 none N 0 Y Y warning error line Y en_au 58 147 Y Transform Fields ScriptValueMod Y 1 none