|
|
| (2 intermediate revisions by 2 users not shown) |
| Line 1: |
Line 1: |
| − | | + | #REDIRECT [[Data_Import/Payments]] |
| − | ==Emersion Bulk Format==
| |
| − | *ACCOUNT_ID (Emersion Account ID e.g 123456)
| |
| − | *PAYMENT_DATE (YYYY-MM-DD)
| |
| − | *PAYMENT_TIME (HH:MM:SS)
| |
| − | *BPAY_BILLER_CODE
| |
| − | *BPAY_REFERENCE
| |
| − | *CUST_REFERENCE
| |
| − | *AMOUNT (INC TAX)
| |
| − | *SURCHARGE_AMOUNT (EX TAX)
| |
| − | *SURCHARGE_PERCENT (As a whole Number e.g 3% = '3')
| |
| − | *PAYMENT_METHOD (See Below Ref Table)
| |
| − | *PAYMENT_NOTE
| |
| − | *INVOICE_LIST (Pipe Delimited list e.g 123456 | 1234466)(If blank will be Unallocated Payment. Where INVOICE_LIST and INVOICE_ALLOCATION_LIST are pipe delimited fields including which invoices are to be paid, and how much is meant to be allocated.)
| |
| − | *INVOICE_ALLOCATION_LIST (Pipe Delimited list if $ amounts in the same order as the Invoices in the Invoice List e.g 120 | 230)
| |
| − | *SURCHARGE_IN_AMOUNT (true - when the surcharge is contained in the amount)
| |
| − | *SURCHARGE_AMOUNT_INC_TAX (true - when the surcharge (amount) already includes tax)
| |
| − | | |
| − | | |
| − | '''Sample record:'''
| |
| − | ACCOUNT_ID,PAYMENT_DATE,PAYMENT_TIME,BPAY_BILLER_CODE,BPAY_REFERENCE,CUST_REFERENCE,AMOUNT,SURCHARGE_AMOUNT,SURCHARGE_PERCENT,PAYMENT_METHOD,PAYMENT_NOTE,INVOICE_LIST,INVOICE_ALLOCATION_LIST,SURCHARGE_IN_AMOUNT,SURCHARGE_AMOUNT_INC_TAX
| |
| − | 5999999,2013-12-01,,,,516361...954,65.58,0.94,,VISA_MC,IVR,,,true,true
| |
| − | 5999998,2013-12-01,,,,123456,50.00,,,VISA_MC,IVR,123456|123457,20|30,true,true
| |
| − | | |
| − | '''Sample file:'''
| |
| − | [[Media:Payment bulk import sample file.csv]] | |
| − | | |
| − | | |
| − | ===PAYMENT_METHOD===
| |
| − | *PAYMENT_METHOD ||Description
| |
| − | *DIRECTDEBIT ||Direct Debit
| |
| − | *EFT|| EFT or Direct Deposit
| |
| − | *EFTPOS|| EFTPOS
| |
| − | *CASH|| Cash
| |
| − | *CHEQUE|| Cheque
| |
| − | *MORDER|| Money Order
| |
| − | *BPAY|| BPay
| |
| − | *PAYBYPHONE|| Pay By Phone
| |
| − | *POSTBILLPAY|| Australia Post Bill Pay
| |
| − | *AGENT|| Agent Collected
| |
| − | *INTERNAL|| Internal Charge
| |
| − | *VISA_MC|| Credit Card - VISA/MASTERCARD
| |
| − | *AMEX|| Credit Card - AMEX
| |
| − | *DINERS|| Credit Card - DINERS
| |
| − | *CONTRA|| Contra
| |
