Load Entities

Load Entities

  • This service allows you to set up Suppliers in the system and link them in the Vendor Portal.

  • Uses csv file and Manual File Upload

Load Entities File Upload.PNG

Column Name

Data Type

NOTES

Column Name

Data Type

NOTES

IntegrationID

nvarchar(100)

 from Seko360

Type

nvarchar(100)

  “Consignee” or “Supplier”

Code

nvarchar(100)

  Consignee/Supplier unique code

Name

nvarchar(200)

 Consignee/Supplier Name

CountryOfOrigin

nvarchar(50)

Country Of Origin of the Supplier

 

Load Entity Address Table

Column Name

Data Type

NOTES

AddressType

nvarchar(100)

 can be set as “Primary”

AddressCategory

nvarchar(100)

“Business” or “Residential”

AddressLine1

nvarchar(100)

 Required

AddressLine2

nvarchar(100)

 

AddressLine3

nvarchar(100)

 

AddressLine4

nvarchar(100)

 

City

nvarchar(50)

 Required

County

nvarchar(50)

 

PostCodeZIP

nvarchar(50)

 Required

Country

nvarchar(50)

 Required