Difference between revisions of "Import/Finance"

From Emersion
Jump to: navigation, search
(Redirected page to Data Import/Payments)
 
(15 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
+
#REDIRECT [[Data_Import/Payments]]
==Emersion Bulk Format==
 
*ACCOUNT_ID (Emersion Account ID)
 
*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
 
*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_ALLOCATION_LIST
 
 
 
 
 
===PAYMENT_METHOD===
 
*ID|| PAYMENT_METHOD ||Description
 
*1|| DIRECTDEBIT ||Direct Debit
 
*2|| EFT|| EFT or Direct Deposit
 
*3|| EFTPOS|| EFTPOS
 
*4|| CASH|| Cash
 
*5|| CHEQUE|| Cheque
 
*6|| MORDER|| Money Order
 
*7|| BPAY|| BPay
 
*8|| PAYBYPHONE|| Pay By Phone
 
*9|| POSTBILLPAY|| Australia Post Bill Pay
 
*11|| AGENT|| Agent Collected
 
*12|| INTERNAL|| Internal Charge
 
*13|| VISA_MC|| Credit Card - VISA/MASTERCARD
 
*14|| AMEX|| Credit Card - AMEX
 
*15|| DINERS|| Credit Card - DINERS
 
*16|| CONTRA|| Contra
 

Latest revision as of 15:03, 28 September 2016