Import: Customer Split

The following import data entities enable Subscription Billing data to be used with Subscription Billing.

Tip: As a best practice before importing data, export data to the file in the format you want. This export file serves as a template or sample, so that you can ensure that the import file you have matches the correct format.

Customer Split Header

Target entity: BssiArcbCustomerSplitTableHeaderEntity

Include the following data entities to import data: 

Column Name	Data Type	Required	Description
SCHEDULENUMBER	String	Required
LINENUMBER	Integer
BILLINGADDRESSNAME	String
BILLINGENDDATE	Date
BILLINGSTARTDATE	Date
CONTACTPERSON	String
CUSTACCOUNT	String
CUSTOMERREF	String
CUSTOMERREQUISITION	String
DELIVERYADDRESSNAME	String
EMAIL	String
INTERNETADDRESS	String
INVOICEACCOUNT	String
PAYMENTMETHOD	String
PAYMENTSCHEDULE	String
PAYMENTTERMID	String
PERCENTAGE	Number
PROJID	String

Customer Split Lines

Target entity: BssiArcbCustomerSplitTableLineEntity

This data entity only adds new records. Importing updates to existing records is currently not available.

Include the following data entities to import data: 

Column Name	Data Type	Required	Description
SCHEDULENUMBER	String	Required
SCHEDULELINENUM	Integer
LINENUM	Integer		This value can be empty. After the file is uploaded, go to the staging and select the Auto check box to automatically generate the sequence of records.
BILLINGADDRESSNAME	String
BILLINGENDDATE	Date
BILLINGSTARTDATE	Date
CONTACTPERSON	String
CUSTACCOUNT	String
CUSTOMERREF	String
CUSTOMERREQUISITION
DELIVERYADDRESSNAME	String
EMAIL	String
INTERNETADDRESS	String
INVOICEACCOUNT	String
PAYMENTMODE	String
PAYMENTSCHEDULE	String
PAYMENTTERMID	String
PERCENTAGE	Number
PROJID	String