Payments
Files
| File | Type | Description |
|---|---|---|
payments/payments.csv |
main |
The payments that will be imported |
payments/order_allocations.csv |
linked |
The allocations made to orders. |
payments/refund_allocations.csv |
linked |
The allocations made to refunds. |
Fields
payments/payment.csv
| Field | Required | Type | Description |
|---|---|---|---|
| receipt_number | required |
string |
The unique receipt number for the payment that is also used as it's id. |
| type | required |
payment-type |
Indicates wether it is a payment, credit, or a refund. |
| client.id | required |
relation:"clients.id" |
The ID of the client who made the payment. |
| amount | required |
money |
The full amount of the payment. |
| original_amount | required |
money |
Usually the same as amount, but if the payment was voided the amount should be 0 and this field should contain the original amount. |
| disbursement_method | required |
disbursement-method |
The payment method (or reason for a credit) of the disbursement. |
| remarks | optional |
string |
Any notes that should be attached to the payment. |
| paid_at | required |
date |
The date the payment was made. |
| voided_at | optional |
date |
The date the payment was voided. |
payments/order_allocations.csv
| Field | Required | Type | Description |
|---|---|---|---|
| payment_receipt_number | required |
linked-id |
The receipt number of the main payment this allocation is linked to. |
| order_number | required |
relation:"orders.order_number" |
The order number this allocation is linked to. |
| amount | required |
money |
The amount of the payment allocated towards the order. |
payments/refund_allocations.csv
| Field | Required | Type | Description |
|---|---|---|---|
| payment_receipt_number | required |
linked-id |
The receipt number of the main payment this allocation is linked to. |
| disbursement_receipt_number | required |
relation:"disbursements.receipt_number" |
The receipt number that this refund is allocated to. |
| amount | required |
money |
The allocated amount of the refund towards the payment. |
Required Rows
none