Customer - Transactions
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
admin
2007/04/09 10:47:12.000
Transaction InputSelect Transaction FieldsY Select Transaction FieldsTransform FieldsY Transform FieldsFilter InvoicesY Filter InvoicesInvoice OutputY Filter InvoicesFilter CreditsY Filter CreditsFilter PaymentsY Filter CreditsCredit OutputY Filter PaymentsPayment OutputY Filter PaymentsFilter RefundsY Filter RefundsRefund OutputY Filter RefundsFilter DebitY Filter DebitDebit OutputY Filter DebitFilter CreditY Filter CreditCredit Adj OutputY Filter CreditFilter InitY Filter InitInit OutputY Filter InitFilter BadY Filter BadBad OutputY Filter BadFilter StatementY Filter StatementDummy (do nothing)Y Filter StatementStatement OutputY
Bad Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountBadDebt>startTimetruefalseTRANSTAT<act.customerAccountBadDebt>statustruefalseAMOUNT<act.customerAccountBadDebt>amounttruefalseTAXAMT<act.customerAccountBadDebt>taxtruefalseREFERENCE<act.customerAccountBadDebt>referencetruefalseDESCRIPTION<act.customerAccountBadDebt>notesfalsefalseCLIENTID<act.customerAccountBadDebt>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountBadDebt>customer[0]<participation.customer>acttrue<act.customerAccountBadDebt>$valuefalsetruetrue1000
760
572
Y
Credit Adj Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountCreditAdjust>startTimetruefalseTRANSTAT<act.customerAccountCreditAdjust>statustruefalseAMOUNT<act.customerAccountCreditAdjust>amounttruefalseTAXAMT<act.customerAccountCreditAdjust>taxtruefalseREFERENCE<act.customerAccountCreditAdjust>referencetruefalseDESCRIPTION<act.customerAccountCreditAdjust>notesfalsefalseCLIENTID<act.customerAccountCreditAdjust>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountCreditAdjust>customer[0]<participation.customer>acttrue<act.customerAccountCreditAdjust>$valuefalsetruetrue1000
759
419
Y
Credit Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountChargesCredit>startTimetruefalseTRANSTAT<act.customerAccountChargesCredit>statustruefalseAMOUNT<act.customerAccountChargesCredit>amounttruefalseTAXAMT<act.customerAccountChargesCredit>taxtruefalseREFERENCE<act.customerAccountChargesCredit>referencetruefalseDESCRIPTION<act.customerAccountChargesCredit>notestruefalseCLIENTID<act.customerAccountChargesCredit>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountChargesCredit>customer[0]<participation.customer>acttrue<act.customerAccountChargesCredit>$valuefalsetruetrue1000
753
127
Y
Debit Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountDebitAdjust>startTimetruefalseTRANSTAT<act.customerAccountDebitAdjust>statustruefalseAMOUNT<act.customerAccountDebitAdjust>amounttruefalseTAXAMT<act.customerAccountDebitAdjust>taxtruefalseREFERENCE<act.customerAccountDebitAdjust>referencetruefalseDESCRIPTION<act.customerAccountDebitAdjust>notesfalsefalseCLIENTID<act.customerAccountDebitAdjust>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountDebitAdjust>customer[0]<participation.customer>acttrue<act.customerAccountDebitAdjust>$valuefalsetruetrue1000
758
354
Y
Dummy (do nothing)
Dummy
Y
1
none
467
725
Y
Filter Bad
FilterRows
Y
1
none
Bad Output
Filter Statement
N
TYPE
=
constantInteger 8-10N
465
574
Y
Filter Credit
FilterRows
Y
1
none
Credit Adj Output
Filter Init
N
TYPE
=
constantInteger 4-10N
464
424
Y
Filter Credits
FilterRows
Y
1
none
Credit Output
Filter Payments
N
TYPE
=
constantInteger 2-10N
464
130
Y
Filter Debit
FilterRows
Y
1
none
Debit Output
Filter Credit
N
TYPE
=
constantInteger 3-10N
465
353
Y
Filter Init
FilterRows
Y
1
none
Init Output
Filter Bad
N
TYPE
=
constantInteger 5-10N
464
498
Y
Filter Invoices
FilterRows
Y
1
none
Invoice Output
Filter Credits
N
TYPE
=
constantInteger 0-10N
465
57
Y
Filter Payments
FilterRows
Y
1
none
Payment Output
Filter Refunds
N
TYPE
=
constantInteger 1-10N
465
197
Y
Filter Refunds
FilterRows
Y
1
none
Refund Output
Filter Debit
N
TYPE
=
constantInteger 6-10N
468
273
Y
Filter Statement
FilterRows
Y
1
none
Statement Output
Dummy (do nothing)
N
TYPE
=
constantInteger 9-10N
467
644
Y
Init Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountInitialBalance>startTimetruefalseTRANSTAT<act.customerAccountInitialBalance>statustruefalseAMOUNT<act.customerAccountInitialBalance>amounttruefalseREFERENCE<act.customerAccountInitialBalance>referencetruefalseCLIENTID<act.customerAccountInitialBalance>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountInitialBalance>customer[0]<participation.customer>acttrue<act.customerAccountInitialBalance>$valuefalsetruetrue1000
761
496
Y
Invoice Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountChargesInvoice>startTimetruefalseTRANSTAT<act.customerAccountChargesInvoice>statustruefalseAMOUNT<act.customerAccountChargesInvoice>amounttruefalseTAXAMT<act.customerAccountChargesInvoice>taxtruefalseREFERENCE<act.customerAccountChargesInvoice>referencetruefalseDESCRIPTION<act.customerAccountChargesInvoice>notestruefalseCLIENTID<act.customerAccountChargesInvoice>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountChargesInvoice>customer[0]<participation.customer>acttrue<act.customerAccountChargesInvoice>$valuefalsetruetrue1000
750
56
Y
Payment Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountPayment>startTimetruefalseTRANSTAT<act.customerAccountPayment>statustruefalseAMOUNT<act.customerAccountPayment>amounttruefalseREFERENCE<act.customerAccountPayment>referencetruefalseCLIENTID<act.customerAccountPayment>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountPayment>customer[0]<participation.customer>acttrue<act.customerAccountPayment>$valuefalseCLIENTID<act.customerAccountPayment>till[0]<participation.till>entitytrue<party.organisationTill>1falseTRANSID<act.customerAccountPayment>till[0]<participation.till>acttrue<act.customerAccountPayment>$valuefalsetruetrue1000
754
197
Y
Refund Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountRefund>startTimetruefalseTRANSTAT<act.customerAccountRefund>statustruefalseAMOUNT<act.customerAccountRefund>amounttruefalseREFERENCE<act.customerAccountRefund>referencetruefalseCLIENTID<act.customerAccountRefund>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountRefund>customer[0]<participation.customer>acttrue<act.customerAccountRefund>$valuefalseCLIENTID<act.customerAccountRefund>till[0]<participation.till>entitytrue<party.organisationTill>1falseTRANSID<act.customerAccountRefund>till[0]<participation.till>acttrue<act.customerAccountRefund>$valuefalsetruetrue1000
753
272
Y
Select Transaction Fields
SelectValues
Y
1
none
CLIENTID
-2
-2
TRANSID
-2
-2
REFERENCE
-2
-2
DATE
-2
-2
TYPE
-2
-2
STATUS
-2
-2
AMOUNT
-2
-2
TAXAMT
-2
-2
RECEIVED
-2
-2
DISCOUNT
-2
-2
DESCRIPTION
-2
-2
214
55
Y
Statement Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountClosingBalance>startTimetruefalseTRANSTAT<act.customerAccountClosingBalance>statustruefalseAMOUNT<act.customerAccountClosingBalance>amounttruefalseCLIENTID<act.customerAccountClosingBalance>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountClosingBalance>customer[0]<participation.customer>acttrue<act.customerAccountClosingBalance>$valuefalseDATE<act.customerAccountOpeningBalance>startTimetruefalseTRANSTAT<act.customerAccountOpeningBalance>statustruefalseAMOUNT<act.customerAccountOpeningBalance>amounttruefalseCLIENTID<act.customerAccountOpeningBalance>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountOpeningBalance>customer[0]<participation.customer>acttrue<act.customerAccountOpeningBalance>$valuefalsetruetrue1000
761
643
Y
Transaction Input
TextFileInput
Y
1
none
N
,
"
N
1
1
N
1
N
80
0
Y
N
N
N
DOS
${NETVET_DATA}\transact.txt
CSV
None
CLIENTID
Integer
$
.
,
-
-1
8
0
none
N
TRANSID
Integer
$
.
,
-
-1
8
0
none
N
REFERENCE
String
$
.
,
-
-1
20
0
none
N
DATE
Date
dd/MM/yyyy
$
.
,
-1
10
-1
none
N
TYPE
Integer
$
.
,
-
-1
2
0
none
N
STATUS
Integer
$
.
,
-
-1
1
0
none
N
AMOUNT
Number
#,##0.###
$
.
,
-
-1
10
3
left
N
TAXAMT
Number
#,##0.###
$
.
,
-
-1
9
3
left
N
RECEIVED
Number
#,##0.###
$
.
,
-
-1
10
3
left
N
DISCOUNT
Number
#,##0.###
$
.
,
-
-1
7
2
left
N
DESCRIPTION
String
-
-1
4
-1
none
N
0
Y
Y
warning
error
line
Y
en_au
79
54
Y
Transform Fields
ScriptValueMod
Y
1
none
0
Script 1
//Script here
var TRANSTAT
if (TYPE.getInt() == 1 || TYPE.getInt() == 6)
TRANSTAT = "POSTED"
else {
if (STATUS.getInt() <=3)
TRANSTAT = "POSTED"
else
TRANSTAT = "IN_PROGRESS"
}
AMOUNT.setNumber(abs(AMOUNT.getNumber()))
TAXAMT.setNumber(abs(TAXAMT.getNumber()))
RECEIVED.setNumber(abs(RECEIVED.getNumber()))
TRANSTAT
TRANSTAT
String
-1
-1
339
57
Y