Difference between revisions of "Import/Finance"
From Emersion
| Line 8: | Line 8: | ||
*CUST_REFERENCE | *CUST_REFERENCE | ||
*AMOUNT (INC TAX) | *AMOUNT (INC TAX) | ||
| − | *SURCHARGE_AMOUNT ( | + | *SURCHARGE_AMOUNT (EX TAX) |
*SURCHARGE_PERCENT (As a whole Number e.g 3% = '3') | *SURCHARGE_PERCENT (As a whole Number e.g 3% = '3') | ||
*PAYMENT_METHOD (See Below Ref Table) | *PAYMENT_METHOD (See Below Ref Table) | ||
Revision as of 13:29, 11 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 (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 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
