Difference between revisions of "Import/Finance"
From Emersion
| Line 1: | Line 1: | ||
==Emersion Bulk Format== | ==Emersion Bulk Format== | ||
| − | *ACCOUNT_ID (Emersion Account ID) | + | *ACCOUNT_ID (Emersion Account ID e.g 123456) |
*PAYMENT_DATE (YYYY-MM-DD) | *PAYMENT_DATE (YYYY-MM-DD) | ||
*PAYMENT_TIME (HH:MM:SS) | *PAYMENT_TIME (HH:MM:SS) | ||
| Line 10: | Line 10: | ||
*SURCHARGE_AMOUNT (INC TAX) | *SURCHARGE_AMOUNT (INC TAX) | ||
*SURCHARGE_PERCENT (As a whole Number e.g 3% = '3') | *SURCHARGE_PERCENT (As a whole Number e.g 3% = '3') | ||
| − | *PAYMENT_METHOD | + | *PAYMENT_METHOD (See Below Ref Table) |
*PAYMENT_NOTE | *PAYMENT_NOTE | ||
| − | *INVOICE_LIST (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_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 | + | *INVOICE_ALLOCATION_LIST (Pipe Delimited list e.g 120 | 230) |
| + | |||
Revision as of 16:29, 10 December 2013
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
