In this article
Import Intercompany Setup
The following tables and samples provide information on the file formats for importing intercompany setup data in an XML formatted file. Before importing data, review the following table for additional information about data imports.
Import type | Intercompany setup | Additional Intercompany |
Page refresh required to see import results? (Y/N) | N | N |
Existing data is not deleted upon import? (Y/N) | Y | Y |
Duplicate data is ignored, and no errors occur? (Y/N). | Y | Y |
XML elements must be in exact same order as the samples? (Y/N) If not, an XML schema validation occurs. |
Y | Y |
If XML schema validation contains errors, the entire import fails? (Y/N) | Y | Y |
If XML data validation contains errors, the entire import fails? (Y/N) | Y | Y |
Intercompany Setup
Review the following table for the required content for importing Due To and Due From accounts for the MEM Intercompany Setup page.
Select Copy to copy the sample to the clipboard.
Note: Use the FireFox web browser when selecting Copy to ensure that the tab spaces in the code are copied correctly. With other web browsers, the tab spaces are copied as non-breaking spaces, which can cause the code to fail.
Intercompany Setup Sample
<?xml version="1.0" encoding="UTF-16" standalone="no"?>
<BssiDueToDueFrom>
<BssiDueToDueFrom>
<BssiOriginEntityId>ADM</BssiOriginEntityId>
<BssiDestinationEntityId>PROD</BssiDestinationEntityId>
<BssiOriginDueToAccCode>ORG_ADM_DT_PROD</BssiOriginDueToAccCode>
<BssiOriginDueFromAccCode>ORG_ADM_DF_PROD</BssiOriginDueFromAccCode>
<BssiDestinationDueToAccCode>DEST_ADM_DT_PROD</BssiDestinationDueToAccCode>
<BssiDestinationDueFromAccCode>DEST_ADM_DF_PROD</BssiDestinationDueFromAccCode>
<BssiOrgDueToDimensionSetID />
<BssiOrgDueFromDimensionSetID />
<BssiDestDueToDimensionSetID />
<BssiDestDueFromDimensionSetID />
<BssiOrgDTShortDim1></BssiOrgDTShortDim1>
<BssiOrgDTShortDim2 />
<BssiOrgDTShortDim3>40</BssiOrgDTShortDim3>
<BssiOrgDTShortDim4 />
<BssiOrgDTShortDim5 />
<BssiOrgDTShortDim6 />
<BssiOrgDTShortDim7 />
<BssiOrgDTShortDim8 />
<BssiOrgDFShortDim1 />
<BssiOrgDFShortDim2 />
<BssiOrgDFShortDim3>20</BssiOrgDFShortDim3>
<BssiOrgDFShortDim4 />
<BssiOrgDFShortDim5 />
<BssiOrgDFShortDim6 />
<BssiOrgDFShortDim7 />
<BssiOrgDFShortDim8 />
<BssiDestDTShortDim1>PROD</BssiDestDTShortDim1>
<BssiDestDTShortDim2 />
<BssiDestDTShortDim3>30</BssiDestDTShortDim3>
<BssiDestDTShortDim4 />
<BssiDestDTShortDim5 />
<BssiDestDTShortDim6 />
<BssiDestDTShortDim7 />
<BssiDestDTShortDim8 />
<BssiDestDFShortDim1 />
<BssiDestDFShortDim2 />
<BssiDestDFShortDim3 />
<BssiDestDFShortDim4 />
<BssiDestDFShortDim5 />
<BssiDestDFShortDim6 />
<BssiDestDFShortDim7 />
<BssiDestDFShortDim8 />
</BssiDueToDueFrom>
</BssiDueToDueFrom>
Field | Description |
BssiOriginEntityId | Originating entity. |
BssiDestinationEntityId | Destination entity. |
BssiOriginDueToAccCode | Originating Due To account. |
BssiOriginDueFromAccCode | Originating Due From account. |
BssiDestinationDueToAccCode | Destination Due To account. |
BssiDestinationDueFromAccCode | Destination Due From account. |
BssiOrgDueToDimensionSetID | Dimension value code for originating Due To account. These values are related to the dimension set entries. |
BssiOrgDueFromDimensionSetID | Dimension value code for originating Due From account. These values are related to the dimension set entries. |
BssiDestDueToDimensionSetID | Dimension value code for destination Due To account. These values are related to the dimension set entries. |
BssiDestDueFromDimensionSetID | Dimension value code for destination Due From account. These values are related to the dimension set entries. |
BssiOrgDTShortDim# | Dimension value for originating Due To, where # is 1 to 8. These values are related to the dimension set entries. |
BssiOrgDFShortDim1 | Dimension value for originating Due From account, where # is 1 to 8. These values are related to the dimension set entries. |
BssiDestDTShortDim# | Dimension value for originating Due To account, where # is 1 to 8. These values are related to the dimension set entries. |
Additional Intercompany Setup
Review the following table for the required content for importing Due To and Due From accounts for the MEM Additional Intercompany Setup page.
Select Copy to copy the sample to the clipboard.
Note: Use the FireFox web browser when selecting Copy to ensure that the tab spaces in the code are copied correctly. With other web browsers, the tab spaces are copied as non-breaking spaces, which can cause the code to fail.
Additional Intercompany Setup Sample
<BssiAdditionalIntercompany>
<BssiAdditionalIntercompany>
<BssiAddiDimCode>CUSTOMERGROUP</BssiAddiDimCode>
<BssiSourceDimValue>LARGE</BssiSourceDimValue>
<BssiDestDimValue>MEDIUM</BssiDestDimValue>
<BssiOriginDueToAccCode>20100</BssiOriginDueToAccCode>
<BssiOriginDueFromAccCode>10200</BssiOriginDueFromAccCode>
<BssiDestinationDueToAccCode>10300</BssiDestinationDueToAccCode>
<BssiDestinationDueFromAccCode>10400</BssiDestinationDueFromAccCode>
</BssiAdditionalIntercompany>
<BssiAdditionalIntercompany>
<BssiAddiDimCode>FUND</BssiAddiDimCode>
<BssiSourceDimValue>FUND1</BssiSourceDimValue>
<BssiDestDimValue>FUND 1 III</BssiDestDimValue>
<BssiOriginDueToAccCode>20100</BssiOriginDueToAccCode>
<BssiOriginDueFromAccCode>20200</BssiOriginDueFromAccCode>
<BssiDestinationDueToAccCode>20300</BssiDestinationDueToAccCode>
<BssiDestinationDueFromAccCode>20400</BssiDestinationDueFromAccCode>
</BssiAdditionalIntercompany>
</BssiAdditionalIntercompany>
Field | Description |
BssiAddiDimCode | Dimension value. |
BssiSourceDimValue | Originating dimension. |
BssiDestDimValue | Destination dimension. |
BssiOriginDueToAccCode | Originating Due To account. |
BssiOriginDueFromAccCode | Originating Due From account. |
BssiDestinationDueToAccCode | Destination Due To account. |
BssiDestinationDueFromAccCode | Destination Due From account. |