Import Master Security

The following tables and samples provide information on the file formats for importing master security data in an XML formatted file. The data import updates the entity values that are assigned to records for the MEM Master Security page.

Before importing data, review the following table for additional information about data imports.

Import type Bank Account Entity Customer Entity Fixed Asset Item Entity Location Entity Vendor Entity Project Entity Resource Entity Service Item Entity
Page refresh required to see import results? (Y/N) Y Y Y Y Y Y Y Y Y
Existing data is not deleted upon import? (Y/N) Y Y Y Y Y Y Y Y Y
Duplicate data is ignored, and no errors occur? (Y/N). Y Y Y Y Y Y Y Y Y

XML elements must be in exact same order as the samples? (Y/N)

If not, an XML schema validation occurs.

Y Y Y Y Y Y Y Y Y
If XML schema validation contains errors, the entire import fails? (Y/N) Y Y Y Y Y Y Y Y Y
If XML data validation contains errors, the entire import fails? (Y/N) Y Y Y Y Y Y Y Y Y

Bank Account Entity

Review the following table for the required content for importing entity values that are assigned to a bank account.

Field Description
BssiEntityBankAccount Bank account number or name.
BssiEntityId Entity for the bank account.

Customer Entity

Review the following table for the required content for importing entity values that are assigned to a customer record.

Field Description
BssiCustomer Customer number.
BssiEntityId Entity for the customer record.

Fixed Asset

Review the following table for the required content for importing entity values that are assigned to a fixed asset record.

Field Description
BssiFixedAsset Fixed asset number.
BssiEntityId Entity for the item record.

Item Entity

Review the following table for the required content for importing entity values that are assigned to an item record.

Field Description
BssiItem Item number.
BssiEntityId Entity for the item record.

Location Entity

Review the following table for the required content for importing entity values that are assigned to a location.

Field Description
BssiLocation Location identifier.
BssiEntityId Entity for the location record.

Vendor Entity

Review the following table for the required content for importing entity values that are assigned to a vendor record.

Field Description
BssiVendor Vendor number.
BssiEntityId Entity for the vendor record

Project Entity

Review the following table for the required content for importing entity values that are assigned to a Project record.

Field Description
BssiJob Project number.
BssiEntityId Entity for the item record.

Resource Entity

Review the following table for the required content for importing entity values that are assigned to a resource record.

Field Description
BssiResource Resource.
BssiEntityId Entity for the item record.

Service Item Entity

Review the following table for the required content for importing entity values that are assigned to a service item record.

This entity is available for users with a Multi-Entity Management Premium license.

Field Description
BssiServiceItem Service Item number.
BssiEntityId Entity for the item record.

Payment Method Entity

Review the following table for the required content for importing entity values that are assigned to a payment method codes.

Field Description
BssiPaymentMethod Payment method code.
BssiEntityId Entity for the payment method.