@@ -70,25 +85,106 @@ Uploaded files can be CSV (comma-separated value) files or Excel spreadsheets.
Default with agent_custid format has the following field order: agent_custid<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire
+Default with existing location format has the following field order: custnum<%$req%>, locationnum, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire
+
+
+All dates format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, order_date, start_date, setup, bill, last_bill, susp, adjourn, resume, cancel, expire, contract_end, dundate
+
+
+All dates with agent_custid format has the following field order: agent_custid<%$req%>, pkgpart<%$req%>, discountnum, order_date, start_date, setup, bill, last_bill, susp, adjourn, resume, cancel, expire, contract_end, dundate
+
+
+All dates with existing location format has the following field order: custnum<%$req%>, locationnum, pkgpart<%$req%>, discountnum, order_date, start_date, setup, bill, last_bill, susp, adjourn, resume, cancel, expire, contract_end, dundate
+
+
Account service format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, username, _password, domsvc
Account service with agent_custid format has the following field order: agent_custid<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, username, _password, domsvc
-Phone sevice format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, countrycode, phonenum, sip_password, pin
+Account service with existing location format has the following field order: custnum<%$req%>, locationnum, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, username, _password, domsvc
+
+
+Broadband service format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, ip_addr<%$req%>, description, routernum, blocknum, sectornum, speed_up, speed_down
+
+
+Phone service format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, countrycode, phonenum, sip_password, pin
Phone service with agent_custid format has the following field order: agent_custid<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, countrycode, phonenum, sip_password, pin
-External sevice format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, id, title
+Phone service with existing location format has the following field order: custnum<%$req%>, locationnum, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, countrycode, phonenum, sip_password, pin
+
+
+Bulk phone service format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, countrycode, start_phonenum-end_phonenum, sip_password, pin
+
+
+Bulk phone service with agent_custid format has the following field order: agent_custid<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, countrycode, start_phonenum-end_phonenum, sip_password, pin
+
+
+Bulk phone service with existing location format has the following field order: custnum<%$req%>, locationnum, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, countrycode, start_phonenum-end_phonenum, sip_password, pin
+
+
+External service format has the following field order: custnum<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, id, title
External service with agent_custid format has the following field order: agent_custid<%$req%>, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, id, title
-<%$req%> Required fields
+External service with existing location format has the following field order: custnum<%$req%>, locationnum, pkgpart<%$req%>, discountnum, start_date, setup, bill, last_bill, susp, adjourn, cancel, expire, id, title
+
+
+Location format has the following field order: custnum<%$req%>,
+pkgpart<%$req%>, discountnum,
+start_date, setup, bill, last_bill, susp, adjourn, cancel, expire,
+address1<%$req%>, address2, city<%$req%>, state<%$req%>, zip<%$req%>, country<%$req%>
+
+
+
+Location with agent_custid format has the following field order: agent_custid<%$req%>,
+pkgpart<%$req%>, discountnum,
+start_date, setup, bill, last_bill, susp, adjourn, cancel, expire,
+address1<%$req%>, address2, city<%$req%>, state<%$req%>, zip<%$req%>, country<%$req%>
+
+
+
+Location with agent_custid and agent_pkgid format has the following field order: agent_custid<%$req%>, agent_pkgid,
+pkgpart<%$req%>, discountnum,
+start_date, setup, bill, last_bill, susp, adjourn, cancel, expire,
+address1<%$req%>, address2, city<%$req%>, state<%$req%>, zip<%$req%>, country<%$req%>
+
+
+
+Location, quantity and price customizations with phone service format has the following field order: custnum<%$req%>,
+pkgpart<%$req%>, discountnum,
+start_date, setup, bill, last_bill, susp, adjourn, cancel, expire,
+address1<%$req%>, address2, city<%$req%>, state<%$req%>, zip<%$req%>, country<%$req%>,
+quantity, setup_fee, recur_fee, invoice_details,
+countrycode, phonenum, sip_password, pin
+
+
+
+Location, quantity and price customizations with phone service and agent_custid format has the following field order: agent_custid<%$req%>,
+pkgpart<%$req%>, discountnum,
+start_date, setup, bill, last_bill, susp, adjourn, cancel, expire,
+address1<%$req%>, address2, city<%$req%>, state<%$req%>, zip<%$req%>, country<%$req%>,
+quantity, setup_fee, recur_fee, invoice_details,
+countrycode, phonenum, sip_password, pin
+
+
+
+Location, quantity and price customizations with phone service and agent_custid and agent_pkgid format has the following field order: agent_custid<%$req%>, agent_pkgid,
+pkgpart<%$req%>, discountnum,
+start_date, setup, bill, last_bill, susp, adjourn, cancel, expire,
+address1<%$req%>, address2, city<%$req%>, state<%$req%>, zip<%$req%>, country<%$req%>,
+quantity, setup_fee, recur_fee, invoice_details,
+countrycode, phonenum, sip_password, pin
+
+
+
+<%$req%> Required fields (for address fields, required if an address is specified)
Field information:
@@ -99,6 +195,8 @@ Field information:
agent_custid: This specifies an existing customer record by agent_custid.
+ agent_pkgid: This specifies an existing customer record by agent_custid.
+
pkgpart: Package definition. Configuration -> Packages -> Package definitions
discountnum: Optional discount. Configuration -> Packages -> Discounts
@@ -119,6 +217,14 @@ Field information:
expire: Indicates a future cancellation on this date.
+ quantity
+
+ setup_fee: Including this fee implements per-customer custom pricing for this package, overriding package definition pricing
+
+ recur_fee: Including this fee implements per-customer custom pricing for this package, overriding package definition pricing
+
+ invoice_details: Package invoice details (optionally, can include multiple lines of details separated by a vertical bar)
+
@@ -129,11 +235,25 @@ Field information:
title: External service identifier, text
+ locationnum: Existing location (cust_location.locationnum)
+
+ address1: Service address, number and street, text
+
+ address2: Service address, suite/unit/building identifier, text
+
+ city: Service address, name of city, text
+
+ state: Service address, state/province, abbreviated
+
+ zip: Service address, postal code
+
+ country: Service address, country, 2-letter code
+
-<% include('/elements/footer.html') %>
+<& /elements/footer.html &>
<%once>
|