Customer - Services /

YN 0.0 0.0 1000 1 1 N Y 5000 Y - 2007/06/03 14:20:22.718 Service InputAdd sequenceY Filter CreditsFilter PaymentsY Filter PaymentsFilter RefundsY Filter InvoicesFilter CreditsY Filter RefundsDummy (do nothing)Y Filter InvoicesInvoice Service OutputY Add sequenceTransform FieldsY Transform FieldsFilter InvoicesY Filter CreditsCredit Service OutputY Filter PaymentsFilter CashY Filter CashCash PaymentY Filter CashFilter ChequeY Filter ChequeFilter Credit CardY Filter Credit CardCredit Card PaymentY Filter Credit CardFilter EFTY Filter EFTEFT PaymentY Filter EFTFilter DiscountY Filter Refund CashCash RefundY Filter Refund CashFilter Refund ChequeY Filter Refund ChequeFilter Refund Credit CardY Filter Refund Credit CardCredit Card RefundY Filter Refund Credit CardFilter Refund EFTY Filter Refund EFTEFT RefundY Filter RefundsFilter Refund CashY Filter Refund EFTInvalid RefundY Filter Refund ChequeCheque RefundY Filter ChequeCheque PaymentY Filter DiscountDiscount PaymentY Filter DiscountInvalid PaymentY Add sequence Sequence Y 1 none SERVICEID N SEQ_ Y 1 1 9999999 167 73 Y Cash Payment OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDAMOUNT<act.customerAccountPaymentCash>amounttruefalseTRANSID<actRelationship.customerAccountPaymentItem>sourcetrue<act.customerAccountPayment>$valuefalseSERVICEID<actRelationship.customerAccountPaymentItem>targettrue<act.customerAccountPaymentCash>$valuefalsetruetrue1000 730 303 Y Cash Refund OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDAMOUNT<act.customerAccountRefundCash>amounttruefalseTRANSID<actRelationship.customerAccountRefundItem>sourcetrue<act.customerAccountRefund>$valuefalseSERVICEID<actRelationship.customerAccountRefundItem>targettrue<act.customerAccountRefundCash>$valuefalsetruetrue1000 729 743 Y Cheque Payment OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDAMOUNT<act.customerAccountPaymentCheque>amounttruefalseTRANSID<actRelationship.customerAccountPaymentItem>sourcetrue<act.customerAccountPayment>$valuefalseSERVICEID<actRelationship.customerAccountPaymentItem>targettrue<act.customerAccountPaymentCheque>$valuefalsetruetrue1000 729 379 Y Cheque Refund OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDAMOUNT<act.customerAccountRefundCheque>amounttruefalseTRANSID<actRelationship.customerAccountRefundItem>sourcetrue<act.customerAccountRefund>$valuefalseSERVICEID<actRelationship.customerAccountRefundItem>targettrue<act.customerAccountRefundCheque>$valuefalsetruetrue1000 733 812 Y Credit Card Payment OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDAMOUNT<act.customerAccountPaymentCredit>amounttruefalseTRANSID<actRelationship.customerAccountPaymentItem>sourcetrue<act.customerAccountPayment>$valuefalseSERVICEID<actRelationship.customerAccountPaymentItem>targettrue<act.customerAccountPaymentCredit>$valuefalsetruetrue1000 729 460 Y Credit Card Refund OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDAMOUNT<act.customerAccountRefundCredit>amounttruefalseTRANSID<actRelationship.customerAccountRefundItem>sourcetrue<act.customerAccountRefund>$valuefalseSERVICEID<actRelationship.customerAccountRefundItem>targettrue<act.customerAccountRefundCredit>$valuefalsetruetrue1000 733 880 Y Credit Service Output OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDDATE<act.customerAccountCreditItem>startTimetruefalseAMOUNT<act.customerAccountCreditItem>unitPricetruefalseTAXAMT<act.customerAccountCreditItem>taxtruefalseDISPFEE<act.customerAccountCreditItem>fixedPricetruefalseQTY<act.customerAccountCreditItem>quantitytruefalsePATIENTID<act.customerAccountCreditItem>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseSERVICEID<act.customerAccountCreditItem>patient[0]<participation.patient>acttrue<act.customerAccountCreditItem>$valuefalseITEM<act.customerAccountCreditItem>product[0]<participation.product>entitytrue<product.*>$valuefalseSERVICEID<act.customerAccountCreditItem>product[0]<participation.product>acttrue<act.customerAccountCreditItem>$valuefalseDOCTOR<act.customerAccountCreditItem>clinician[0]<participation.clinician>entitytrue<security.user>$valuefalseSERVICEID<act.customerAccountCreditItem>clinician[0]<participation.clinician>acttrue<act.customerAccountCreditItem>$valuefalseTRANSID<actRelationship.customerAccountCreditItem>sourcetrue<act.customerAccountChargesCredit>$valuefalseSERVICEID<actRelationship.customerAccountCreditItem>targettrue<act.customerAccountCreditItem>$valuefalsetruetrue1000 730 200 Y Discount Payment OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDAMOUNT<act.customerAccountPaymentDiscount>amounttruefalseTRANSID<actRelationship.customerAccountPaymentItem>sourcetrue<act.customerAccountPayment>$valuefalseSERVICEID<actRelationship.customerAccountPaymentItem>targettrue<act.customerAccountPaymentDiscount>$valuefalsetruetrue1000 730 624 Y Dummy (do nothing) Dummy Y 1 none 341 872 Y EFT Payment OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDAMOUNT<act.customerAccountPaymentEFT>amounttruefalseTRANSID<actRelationship.customerAccountPaymentItem>sourcetrue<act.customerAccountPayment>$valuefalseSERVICEID<actRelationship.customerAccountPaymentItem>targettrue<act.customerAccountPaymentEFT>$valuefalsetruetrue1000 728 543 Y EFT Refund OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDAMOUNT<act.customerAccountRefundEFT>amounttruefalseTRANSID<actRelationship.customerAccountRefundItem>sourcetrue<act.customerAccountRefund>$valuefalseSERVICEID<actRelationship.customerAccountRefundItem>targettrue<act.customerAccountRefundEFT>$valuefalsetruetrue1000 733 964 Y Filter Cash FilterRows Y 1 none Cash Payment Filter Cheque N ITEM = constantStringCASH-1-1N 512 305 Y Filter Cheque FilterRows Y 1 none Cheque Payment Filter Credit Card N ITEM = constantStringCHEQUE-1-1N 511 379 Y Filter Credit Card FilterRows Y 1 none Credit Card Payment Filter EFT N N ITEM = constantStringBNKCARD-1-1N N AND DESCRIPTION <> constantStringY-1-1N 510 459 Y Filter Credits FilterRows Y 1 none Credit Service Output Filter Payments N N TRANTYP = constantInteger 2-10N N AND PATIENTID <> constantInteger-1-10N N AND ITEM <> constantStringHCOM-1-1N 347 201 Y Filter Discount FilterRows Y 1 none Discount Payment Invalid Payment N N ITEM = constantStringDISCOUNT-1-1N 505 627 Y Filter EFT FilterRows Y 1 none EFT Payment Filter Discount N N ITEM = constantStringBNKCARD-1-1N 507 541 Y Filter Invoices FilterRows Y 1 none Invoice Service Output Filter Credits N N TRANTYP = constantInteger 0-10N N AND PATIENTID <> constantInteger-1-10N N AND ITEM <> constantStringHCOM-1-1N 348 76 Y Filter Payments FilterRows Y 1 none Filter Cash Filter Refunds N N TRANTYP = constantInteger 1-10N 344 304 Y Filter Refund Cash FilterRows Y 1 none Cash Refund Filter Refund Cheque N ITEM = constantStringCASH-1-1N 527 742 Y Filter Refund Cheque FilterRows Y 1 none Cheque Refund Filter Refund Credit Card N ITEM = constantStringCHEQUE-1-1N 523 811 Y Filter Refund Credit Card FilterRows Y 1 none Credit Card Refund Filter Refund EFT N N ITEM = constantStringBNKCARD-1-1N N AND DESCRIPTION <> constantStringY-1-1N 522 880 Y Filter Refund EFT FilterRows Y 1 none EFT Refund Invalid Refund N N ITEM = constantStringBNKCARD-1-1N 519 963 Y Filter Refunds FilterRows Y 1 none Filter Refund Cash Dummy (do nothing) N TRANTYP = constantInteger 6-10N 344 743 Y Invalid Payment Dummy Y 1 none 504 685 Y Invalid Refund Dummy Y 1 none 519 1031 Y Invoice Service Output OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDDATE<act.customerAccountInvoiceItem>startTimetruefalseAMOUNT<act.customerAccountInvoiceItem>unitPricetruefalseTAXAMT<act.customerAccountInvoiceItem>taxtruefalseDISPFEE<act.customerAccountInvoiceItem>fixedPricetruefalseQTY<act.customerAccountInvoiceItem>quantitytruefalsePATIENTID<act.customerAccountInvoiceItem>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseSERVICEID<act.customerAccountInvoiceItem>patient[0]<participation.patient>acttrue<act.customerAccountInvoiceItem>$valuefalseITEM<act.customerAccountInvoiceItem>product[0]<participation.product>entitytrue<product.*>$valuefalseSERVICEID<act.customerAccountInvoiceItem>product[0]<participation.product>acttrue<act.customerAccountInvoiceItem>$valuefalseDOCTOR<act.customerAccountInvoiceItem>clinician[0]<participation.clinician>entitytrue<security.user>$valuefalseSERVICEID<act.customerAccountInvoiceItem>clinician[0]<participation.clinician>acttrue<act.customerAccountInvoiceItem>$valuefalseTRANSID<actRelationship.customerAccountInvoiceItem>sourcetrue<act.customerAccountChargesInvoice>$valuefalseSERVICEID<actRelationship.customerAccountInvoiceItem>targettrue<act.customerAccountInvoiceItem>$valuefalsetruetrue1000 730 76 Y Service Input TextFileInput Y 1 none N , " N

Y

1 1 N 1 N 80 0 Y N N N DOS ${NETVET_DATA}\service.txt CSV None TRANSID Integer $ . , - -1 8 0 none N TRANTYP Integer $ . , - -1 2 0 none N PATIENTID Integer $ . , - -1 8 0 none N ITEM String - -1 10 -1 none N DOCTOR String - -1 5 -1 none N DEPART String - -1 5 -1 none N DATE Date dd/MM/yyyy $ . , -1 10 -1 none N AMOUNT Number #,##0.### $ . , - -1 10 3 left N RRPAMT Number #,##0.### $ . , - -1 10 3 left N TAXAMT Number #,##0.### $ . , - -1 10 3 left N COST Number #,##0.### $ . , - -1 10 3 left N QTY Number #,##0.### $ . , - -1 10 3 left N DISPFEE Number #,##0.### $ . , - -1 10 3 left N DESCRIPTION String - -1 50 -1 none N 0 N N warning error line Y en_au 43 73 Y Transform Fields ScriptValueMod Y 1 none