Difference between revisions of "Data Import/InflightInstallements"
From Emersion
(→In flight Installments Importer) |
(→In flight Installments Importer) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
The purpose of this importer is to permit you to import a purchase installment plan that has not started, or is currently flight. Attached is a sample data file. | The purpose of this importer is to permit you to import a purchase installment plan that has not started, or is currently flight. Attached is a sample data file. | ||
| + | [[File:Test In Flight Importer.csv|thumbnail]] | ||
| Line 13: | Line 14: | ||
| serial_number || Serial Number of the purchase. Can contain text or numbers. | | serial_number || Serial Number of the purchase. Can contain text or numbers. | ||
|- | |- | ||
| − | | service_id|| Service ID against which the purchase is being made against. This is <b> NOT <b> the service identifier (i.e. phone number). It is the service ID. | + | | service_id|| Service ID against which the purchase is being made against. This is <b> NOT </b> the service identifier (i.e. phone number). It is the service ID. |
|- | |- | ||
| installments_remaining || Number of installments remaining | | installments_remaining || Number of installments remaining | ||
Latest revision as of 10:53, 1 April 2016
In flight Installments Importer
The purpose of this importer is to permit you to import a purchase installment plan that has not started, or is currently flight. Attached is a sample data file.
File:Test In Flight Importer.csv
| Column Header | Value Accepted |
|---|---|
| product_id | Product ID, against which the purchase installment plan is being made. |
| serial_number | Serial Number of the purchase. Can contain text or numbers. |
| service_id | Service ID against which the purchase is being made against. This is NOT the service identifier (i.e. phone number). It is the service ID. |
| installments_remaining | Number of installments remaining |
| installment_period_length | The length of time between each installment (i.e. when it falls due). |
| installment_amount | Amount per installment. |
| inst_tot_amnt_rem | The total amount of all installments remainining i.e. if you had 10 installments remaining at $500 each, it would be 5000. |
| inst_total_amount | The total amount of all installments. i.e. 12 installments at $500 = 6000. |
| buying_account_id | Account ID of which customer account is making the purchase. |
| next_installment_date | Date of the next installment. Format will be year-month-day (YYYY-MM-DD) |
| invoice_method | To be completed. |
| installment_method | To Be completed. |
| total_instalments | Total number of installments for the plan. |
