|
|
| (13 intermediate revisions by 3 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 (INC 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 e.g 120 | 230)
| |
| − | | |
| − | | |
| − | | |
| − | ===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
| |
