In this article

CSV Format: Billing Schedule Data

Billing schedule information can be exported and then imported from the SBS ARCB Billing Schedule List page in the CSV formats using the following actions: 

  • Billing schedule headers
  • Billing schedule lines
  • Billing schedule line min-max free details
  • Billing schedule line deferral details
  • Billing schedule line MERA headers
  • Billing schedule line MERA details
  • Billing schedule price adjustment
  • Billing schedule usage items (import only)

General Workflow

To create or update billing schedule information, follow these general steps: 

  1. On the SBS ARCB Billing Schedule List, select the export action you want (Export > CSV > Export).

    You can save the file to the default download location.

  2. Open the file in a String editor, and make changes as needed.
  3. Back on the SBS ARCB Billing Schedule List, select the import action for the same data type you exported (Import > CSV > Import).
  4. When updating data, prompts asking whether you want to roll down the start and end dates, the frequency, and the interval, appear. Select Yes or No to the prompts.

The following tables provide information on the file formats for importing data. Every field is required to appear on the import file. However, not every field requires a value. In other words, the field column must appear in the file, but the value for the field in a row can be empty.

Tip: If you do not have a sample template and to ensure you have the latest format, execute the export action to save a file with the correct formatting.

Notes:

The following items provide information with respect to importing data: 

  • The header and line records can be combined into a single composite entity, which means it can be included in a single file. However, only XML files can be used with composite entities.
  • If a stubbing cutoff date exists, and the schedule details lines have a billing start date that is earlier than or the same as the stubbing cutoff date, the line is stubbed.
  • Each entity record is processed independently of all other entity records. As a result, when an import error occurs, only the line that has the error is rolled back. All other lines that are successfully imported are not affected.

    • For composite entities, the header and line are considered a single entity. If an import error occurs with the line, the header is not imported.

  • When price adjustment data is imported, the price adjustment line number is automatically generated.
  • When importing data, the ScheduleNumber is required. Also, the ScheduleLineNum is required for a billing schedule line, but optional for composite. For more information about the file format for the data, review the sample import file.

Billing Schedule Header

Review the following table for the required content for importing data to the SBS ARCB Billing Schedule List page.

Select Copy to copy the sample to the clipboard.

Copy

BillingScheduleHeader.txt sample

"CONT077","10000","","03/01/19","11/30/22"," Quarterly","15","No","12345","0","0","","","PS","","1M(8D)","10000","Adatum Corporation","192 Market Square","","Atlanta","","Adatum Corporation123","123","1232","Atlanta","0.00","31772","GA","31772","US","Adatum Corporation","192 Market Square","","Atlanta","Robert Townes","31772","GA","No","No","","","","","GA","31772","US","Robert Townes","","US","","","","Robert Townes","","US","No","No","","SBS","DEFAULT"

The following table shows the columns for the CSV formatted file: 

  • Action: Import/Export > CSV > Import or Export > Billing Schedule (Headers)
Field Name Data Type Required Description
BssiArcbBillingScheduleNumber String Required Billing schedule number
Sell-to Customer No. String Required Customer number
BssiEndUser String    
BssiArcbScheduleStartDate Date Required Billing schedule start date
BssiArcbScheduleEndDate Date Required Billing schedule end date
BssiArcbBillingFrequency String Required

Options:

  • Monthly
  • Quarterly
  • Semi-Annual
  • Annual
  • One Time
  • Weekly
  • Daily
  • Miscellaneous

When this value is empty, the value is from the specified billing schedule group.

BssiArcbInterval Integer   When this value is empty, the value is from the specified billing schedule group.
BssiArcbAutoRenewed Boolean   Yes/No
BssiArcbDescription String    
BssiArcbNoticeGivenDays Integer    
BssiRenewInAdvance Integer  
Currency Code String    
Location Code String    
Salesperson Code String    
Responsibility Center String    
Payment Terms Code String    
Bill-to Customer No. String    
Bill-To Name String    
Bill-to Address String    
Bill-to Address2 String    
Bill-to City String    
Ship-to Code String    
Ship-to Name String    
Ship-to Address String    
Ship-to Address2 String    
Ship-to City String    
BssiArcbDetailInvAmt Integer    
Bill-To Postal Code String    
Bill-To Country String    
Ship-to Postal Code String    
Ship-to Country String    
Sell-to Customer Name String    
Sell-to Address String    
Sell-to Address 2 String    
Sell-to City String    
Sell-to Contact String    
Sell-to Postal Code String    
Sell-to County String    
BssiArcbAlignToMonth Boolean   Yes/No
BssiArcbProRatePartialPeriod Boolean   Yes/No
Shipment Method Code String    
String String    
Shipping Agent Service Code String    
Shipping Agent Code String    
Ship-to County String    
Ship-to Post Code String    
Ship-to Country/Region String    
Ship-to Contact String    
Sell-to Contact No. String  
Sell-to Country/Region String    
Sell-to Customer Name 2 String    
Your Reference String    
External Document No. String    
Bill-to Contact String    
Bill-to Contact No. String    
Bill-to Country/Region String    
BssiInvoiceSeparately Boolean   Yes/No
Tax Liable Boolean   Yes/No
Tax Area Code String    
No.Series String    
BssiArcbBillingSchGroup String   Group
BssiEstimateQty Real   Estimated usage quantity

Billing Schedule Lines

Review the following table for the required content for importing data to the SBS ARCB Billing Schedule List page.

Select Copy to copy the sample to the clipboard.

Copy

BillingScheduleLines.txt sample

"ARC0027","10000","Item","1900-S","PARIS Guest Chair, black","Standard","","PCS","192.00","1","192.00"," Monthly","01/01/21","12/31/21","1","FURNITURE","No","CHICAGO, IL","No","Reading"," Flat","","0.00","1","","No","0.00","0","Sales Invoice","20000","Trey Research","153 Thomas Drive","","Chicago","Helen Ray","","","IL","61236"

The following table shows the columns for the CSV formatted file: 

  • Action: Import/Export > CSV > Import or Export > Billing Schedule (Lines)
Column Name Data Type Required Description
BssiArcbBillingScheduleNumber String Required  
Line No. Integer Required  
Type String Required  
Item No. String Required  
Description String    
BssiArcbBillingType Option    
Location Code String    
Unit Of Measure String Required  
Unit Price Number Required  
Quantity Number Required  
Amount Number    
BssiArcbBillingFrequency String Required

Options:

  • Monthly
  • Quarterly
  • Semi-Annual
  • Annual
  • One Time
  • Weekly
  • Daily
  • Miscellaneous
BillingStartDate Date Required  
BillingEndDate Date    
BssiArcbInterval Integer    
Tax Group Code String    
Tax Liable Boolean    
Tax Area Code String    
BssiArcbAutoRenewed Boolean   Yes/No
Usage Option Option    
Pricing Method String    
Usage Identifier String    
Initial Reading Decimal    
Renewal Lines Integer    
BssiStubbedDate      
BssiRevenueSplit Boolean    
BssiParentAmount Decimal    
BssiEstimateQty Real    
BssiTransactionType String    
BssiBillToCustomerForLine String Required

If this value is empty, an error occurs when an invoice is created.

Instead of leaving this value empty, use the sell-to customer details.

BssiBillToCustomerNameForLine String Required

If this value is empty, an error occurs when an invoice is created.

Instead of leaving this value empty, use the sell-to customer details.

BssiBillToAddressForLine String Required

If this value is empty, an error occurs when an invoice is created.

Instead of leaving this value empty, use the sell-to customer details.

BssiBillToAddress2ForLine String Required

If this value is empty, an error occurs when an invoice is created.

Instead of leaving this value empty, use the sell-to customer details.

BssiBillToCityForLine String Required

If this value is empty, an error occurs when an invoice is created.

Instead of leaving this value empty, use the sell-to customer details.

BssiBillToContactForLine String Required

If this value is empty, an error occurs when an invoice is created.

Instead of leaving this value empty, use the sell-to customer details.

BssiBillToContactNoForLine String Required

If this value is empty, an error occurs when an invoice is created.

Instead of leaving this value empty, use the sell-to customer details.

BssiBillToCountryForLine String Required

If this value is empty, an error occurs when an invoice is created.

Instead of leaving this value empty, use the sell-to customer details.

BssiBillToCountyForLine String Required

If this value is empty, an error occurs when an invoice is created.

Instead of leaving this value empty, use the sell-to customer details.

BssiBillToPostalForLine String Required

If this value is empty, an error occurs when an invoice is created.

Instead of leaving this value empty, use the sell-to customer details.

Note icon. Note: To import child items in a revenue split (automatically insert) from a configuration package, the following changes must be made to the configuration package:

  • It is not necessary to select the BssiRevenueSplit field in the configuration package. This field is automatically selected at the time the details are entered.
  • Do not select the Number of Period field. To import the number of periods, move the field Number of Period before the Item No field.

Billing Schedule Line Min-Max Free Details

Review the following table for the required content for importing data to the SBS ARCB Billing Schedule List page.

Select Copy to copy the sample to the clipboard.

Copy

Billing Schedule Line Min/Max Free Details sample

"CONT077","10000","0.00","1","By Amount","1,200.00","0.00","1"

The following table shows the columns for the CSV formatted file: 

  • Action: Import/Export > CSV > Import or Export > Billing Schedule Line Min-Max Free Details
Column Name Data Type Required Description
BssiArcbBillingScheduleNumber String   Billing Schedule No.
Line No. Integer   Line No.
FreeQuantity Integer    
FreeResetNumberofPeriods Integer    
MinMaxType String   By Amount/By Quantity
MinimumValue Integer    
MaximumValue Integer    
MinMaxResetNumberofPeriods Integer    

Billing Schedule Price Adjustment

Review the following table for the required content for importing data to the SBS ARCB Billing Schedule List page.

Select Copy to copy the sample to the clipboard.

Copy

PriceAdjustmentDetails.txt sample

"CONT079","10000","10000","No","05/01/20","12/31/2020","None","0.00","10.00","","Prior CPI","Yes"

The following table shows the columns for the CSV formatted file: 

  • Action: Import/Export > CSV > Import or Export > Billing Schedule Price Adjustment
Column Name Data Type Required Description
BssiArcbBillingScheduleNumber String Required Billing Schedule No.
BssiArcbBillingScheduleLineNo Integer Required  
ItemNumber String Required  
Frequency Integer Required

Billing frequency:

  • 1-Monthly
  • 2-Quarterly
  • 3-Semi-Annual
  • 4-Annual
  • 5-Markdown
EscStartDate Date Required  
EscEndDate Date    
Percentage Number    
Amount Number    
CPI schedule String    

Billing Schedule Usage Items

Review the following table for the required content for importing data to the SBS ARCB Billing Schedule List page.

Select Copy to copy the sample to the clipboard.

Copy

UsageItem.txt sample

"CONT080","1900-S","Reading","200","identifier_123","01/01/2020","comment 1"
"CONT080","1900-S","Reading","300","identifier_123","02/01/2020","comment 2"
"CONT080","1900-S","Reading","400","identifier_123","03/01/2020","comment 3"
"CONT080","1900-S","Reading","500","identifier_123","04/01/2020","comment 4"

Select Copy to copy the sample to the clipboard.

Copy

UsageItem.txt sample

"CONT080","1900-S","Consumption","20","","01/01/2020","comment 1"
"CONT080","1900-S","Consumption","30","","01/15/2020","comment 2"
"CONT080","1900-S","Consumption","10","","02/10/2020","comment 3"
"CONT080","1900-S","Consumption","50","","03/05/2020","comment 4"

The following table shows the columns for the CSV formatted file: 

  • Action: Import/Export > CSV > Import or Export > Billing Schedule Usage Items
Column Name Data Type Required Description
BssiArcbBillingScheduleNumber String Required Billing Schedule No.
ItemNo String Required  
Usage Option Boolean   Consumption or Reading
Current Reading Number    
Usage Identifer String   Unique for each usage item with the same item no.
Billing Start Date Date Required The date the usage occurred.
Comments String    

Billing Schedule Line Deferral Details

Review the following table for the required content for importing data to the SBS ARCB Billing Schedule List page.

Select Copy to copy the sample to the clipboard.

Copy

BillingScheduleLineDeferralTransactionDetails.txt sample

"CONT0014","10000"," Billing Schedule","Yes","01/01/20","1.00","433.60","","No","Equal Amounts","","10700","40200","10800","50100","10900","40300","Straight Line","TEMP1","No","No","No","01/01/20","12/31/20","Yes"

The following table shows the columns for the CSV formatted file: 

  • Action: Import/Export > CSV > Import or Export > Billing Schedule Line Deferral Details
Column Name Data Type Required Description
Document No. String    
Document Line no String    
Transaction Type String    
BssiAredDeferral      
Document Date Date    
Qty      
BssiAredDefAmount      
BssiAredEvenTemplateNo String    
BssiAredEventPerUnit      
BssiAredEventAllocationType String    
BssiAredExpirationAccount String    
BssiAredRevDefAct String    
BssiAredRevRecogAct String    
BssiAredConDefAct String    
BssiAredConRecogAct String    
BssiAredDisDefAct String    
BssiAredDisRecogAct String    
BssiAredScheduleType      
BssiAredTemplateNo String    
BssiAredConsolidatePrPeriod      
BssiAredEqualPerPeriod      
BssiAredOverrideStartdate Date    
BssiAredStartDate Date    
BssiAredEndDate Date    
BssiAredSchFromTemplate      

Billing Schedule Line MERA (Headers)

Review the following table for the required content for importing data to the SBS ARCB Billing Schedule Listpage.

Select Copy to copy the sample to the clipboard.

Copy

Billing Schedule Line MERA Header sample

"CONT0016"," Single","1","10800"

The following table shows the columns for the CSV formatted file: 

  • Action: Import/Export > CSV > Import or Export > Billing Schedule Line MERA (Headers)
Column Name Data Type Required Description
DocumentNo String    
BssiMeraMEAType String    
BssiMeraMEANumber String    
DeferredContractRevenueAccount String    

Billing Schedule Line MERA Details

Review the following table for the required content for importing data to the SBS ARCB Billing Schedule List page.

Select Copy to copy the sample to the clipboard.

Copy

Billing Schedule Line MERA Details sample

"CONT0016","10000","1"," Amount","100.00","10800"

The following table shows the columns for the CSV formatted file: 

  • Action: Import/Export > CSV > Import or Export > Billing Schedule Line MERA Details
Column Name Data Type Required Description
DocumentNo String    
LineNum Integer    
BssiMeraMEANumber String    
BssiMeraFairValueOrigin String    
BssiMeraFairValueAmount Real    
DeferredContractRevenueAccount String    

Price Index Schedule Header Import/Export

Review the following table for the required content for importing data to the SBS ARCB Billing Schedule List page.

Select Copy to copy the sample to the clipboard.

Copy

Schedule Price Index Header sample

"1","CPI Schedule ","","SBS1"

The following table shows the columns for the CSV formatted file: 

  • Action: Import/Export > CSV > Import or Export > Schedule Price Index Header
Column Name Data Type Required Description
BssiArcbCPIScheduleNo String    
BssiArcbCPIScheduleDesc String    
BssiArcbCPILastRunDate Date    
BssiArcbUserApplied String    

Price Index Schedule Line Import/Export

Review the following table for the required content for importing data to the SBS ARCB Billing Schedule List page.

Select Copy to copy the sample to the clipboard.

Copy

Schedule CPI Line sample

"1","10000","01/01/19","5.00"
"1","20000","01/01/20","5.50"
"1","30000","01/01/21","6.50"

The following table shows the columns for the CSV formatted file: 

  • Action: Import/Export > CSV > Import or Export > Schedule Price Index Line
Column Name Data Type Required Description
BssiArcbCPIScheduleId Integer Required  
Line No. Integer    
BssiArcbCPIDate Date    
BssiArcbCPIValue Decimal