Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Description

This method can be used to create new companies in SEKO360. 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

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 SEKO360.

nvarchar(4000)





SpecialInstructions

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

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


  • No labels