In this article
Import MERA Setup
The following tables provide information on the file formats for importing data entities. All data entities in Subscription Billing start with SB.
Tip: To save time and work more efficiently, use the sample import files (SB_ImportTemplates-YYYYMMDD.zip) that are provided with Subscription Billing installation download file. If a sample file does not exist, you can export the data entities.
When importing data entities from a Microsoft Excel file, set Skip staging to No. When data is imported with the staging, all Subscription Billing validations are performed on the data being imported. If any errors occur during import, you can review the staging data to check for data import issues.
Item Standalone Sales Price
Target entity: BssiMeraItemFairValueEntity
Sample template: SB_MERA_item_SSP.xlsx
| Column Name | Data Type | Required | Description |
| REVENUESPLIT | Enum | Yes/No | |
| ITEMCODE | Enum | Required |
0 = Table 1 = Group ID 2 = All 3 = Category |
| ITEMRELATION | String | Required | |
| PERCENT | Real | ||
| SSPORIGIN | Enum |
0 = Base Sales Price 1 = Invoice Price 2 = Percent Of Item 50 = Amount 51 = None 52 = Percent of Parent Standard Price 53 = Percent of Parent Invoice Price 54 = Allocate Residual Amount |
|
| STANDALONESELLINGPRICE | Real | ||
| PARENTITEM | String | ||
| LINENUM | Real |
Parameters
Target entity: BssiMeraParametersEntity
Sample template: SB_MERA_parameters.xlsx
| Column Name | Data Type | Required | Description |
| DEFERRALROUNDINGACCOUNT | String | ||
| SSPORIGIN | Enum |
0 = Base Sales Price 1 = Invoice Price 2 = Percent Of Item 50 = Amount 51 = None 52 = Percent of Parent Standard Price 53 = Percent of Parent Invoice Price 54 = Allocate Residual Amount |
MEA Template
Target entity: BssiMeraMEATemplatesEntity
Sample template: SB_MERA_MEA_template.xlsx
(MEA = Multiple Element Allocation)
| Column Name | Data Type | Required | Description |
| MEANUMBER | String | ||
| DEFERREDCONTRACTREVENUEACCOUNT | String | ||
| DESCRIPTION | String |
Revenue Split Template Header
Target entity: BssiMeraRevenueSplitHeaderEntity
Sample template: SB_MERA_revenue_split_template_header.xlsx
For more information, see Revenue Split.
| Column Name | Data Type | Required | Description |
| ParentItem | String | Required | |
| AllocationMethod | Enum |
0 = Variable Amount 1 = Percentage 2 = Equal Amount 3 = Zero Amount 4 = Zero Parent Amount |
Revenue Split Template Lines
Target entity: BssiMeraRevenueSplitLineEntity
Sample template: SB_MERA_revenue_split_template_line.xlsx
For more information, see Revenue Split.
| Column Name | Data Type | Required | Description |
| PARENTITEM | String | Required | |
| COMPONENTITEM | String | Required | |
| LINENUM | Real | ||
| PERCENTAGE | Real |
