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. |
Available formats
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 |