Load Companies



Description

This method can be used to create new companies in SupplyStream. This includes new suppliers and ship to companies. The Company Type field is used to specify the type of company you are creating.
If this service is being used only to create Company→ Company Type→ Ship To, this service may not be required if the 'on the fly' Ship To Company creation is used in Load Sales Orders instead.

Available formats



API

FTP

Manual

XML

x

x



JSON

x





CSV



x

x

Entity Relationships

This diagram shows the high level relationship between the entities detailed in the Field Level Details section of this page.

Field level details

Companies













Field

Description

Data Type

Value Limits

Requirement

Use on standard documents

Field returned in service ID/table/field (multi services split by ";")

CompanyType

Create suppliers that can be used in conjunction with 'Load Product Masters' or 'Load Product Master Updates'. Create Ship To addresses that can be used in conjunction with 'Load Sales Orders'

nvarchar(100)

Supplier, Ship To

Mandatory





CompanyCode

Unique identifier for the new company record. Upload will not fail if CompanyCode already exists.

nvarchar(100)



Mandatory





BranchCode

Placeholder

nvarchar(50)









CompanyDescription

The name of the company delivering to

nvarchar(200)



Mandatory

Dispatch Note, Commercial Inv



CompanyCategory

Placeholder

nvarchar(100)

Asia, EU, RoW







Notes

Shows on 'Notes' tab in client view for the associated company code on SupplyStream.

nvarchar(4000)









SpecialInstructions

Shows on the 'Instructions' tab in client view for the associated company code on SupplyStream.

nvarchar(4000)









CompanyNumber

Placeholder

nvarchar(100)









BusinessNumber

Placeholder

nvarchar(100)









VATNumber

Placeholder

nvarchar(100)









CurrencyCode

Placeholder

nchar(3)









SubsidiaryCode

Placeholder

nvarchar(100)









InvoiceFormat

Placeholder

nvarchar(100)









Airport

Placeholder

nvarchar(100)









BillToCode

Placeholder

nvarchar(100)









BillToName

Placeholder

nvarchar(200)











Address













Field

Description

Data Type

Value Limits

Requirement

Use on standard documents

Field returned in service ID/table/field (multi services split by ";")

AddressType

Type of address. Select 'Delivery' when to be used in conjunction with 'Load Sales Orders' for delivery address. Adding a new address to an existing CompanyCode through this service will make the new address of the specified address type, the default address (used in Load Sales ordersèDeliveryAddressLookup).

nvarchar(100)

Delivery, Bank, Primary, Supplier, Billing, Forwarding Agent

Mandatory





AddressLocationType

Location type: Business or Residential.

nvarchar(100)

Business, Residential







AddressLine1

Part of address

nvarchar(100)

 

Mandatory

Dispatch Note, Commercial Inv



AddressLine2

Part of address

nvarchar(100)

 



Dispatch Note, Commercial Inv



AddressLine3

Part of address

nvarchar(100)

 



Dispatch Note, Commercial Inv



AddressLine4

Part of address

nvarchar(100)

 



Dispatch Note, Commercial Inv



City

Part of address

nvarchar(50)

 

Mandatory

Dispatch Note, Commercial Inv



County

Part of address

nvarchar(50)

 



Dispatch Note, Commercial Inv



PostCodeZIP

Part of address

nvarchar(20)



Mandatory

Dispatch Note, Commercial Inv



CountryCode

Part of address. (ISO-2).

nvarchar(2)

 

Mandatory

Dispatch Note, Commercial Inv