API CreateCustomer: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
 
(Není zobrazeno 8 mezilehlých verzí od stejného uživatele.)
Řádka 16: Řádka 16:
 
!Relation
 
!Relation
 
|-
 
|-
−
|ShortName
+
|@ShortName
 
|nvarchar(30)
 
|nvarchar(30)
 
|
 
|
Řádka 22: Řádka 22:
 
|
 
|
 
|-
 
|-
−
|CompanyName
+
|@CompanyName
 
|nvarchar(250)
 
|nvarchar(250)
 
|
 
|
Řádka 28: Řádka 28:
 
|
 
|
 
|-
 
|-
−
|CompanyRegistrationNumber
+
|@CompanyRegistrationNumber
 
|nvarchar(20)
 
|nvarchar(20)
 
|
 
|
Řádka 34: Řádka 34:
 
|
 
|
 
|-
 
|-
−
|VATNumber
+
|@VATNumber
 
|nvarchar(20)
 
|nvarchar(20)
 
|
 
|
Řádka 40: Řádka 40:
 
|
 
|
 
|-
 
|-
−
|VATNumber2
+
|@VATNumber2
 
|nvarchar(15)
 
|nvarchar(15)
 
|
 
|
Řádka 46: Řádka 46:
 
|
 
|
 
|-
 
|-
−
|VATPayer
+
|@VATPayer
 
|int
 
|int
 
|
 
|
Řádka 52: Řádka 52:
 
|
 
|
 
|-
 
|-
−
|TransportID
+
|@TransportID
 
|int
 
|int
 
|
 
|
Řádka 58: Řádka 58:
 
|API_GetTransports.ID
 
|API_GetTransports.ID
 
|-
 
|-
−
|Username
+
|@Username
 
|nvarchar(255)
 
|nvarchar(255)
 
|
 
|
Řádka 64: Řádka 64:
 
|
 
|
 
|-
 
|-
−
|Password
+
|@Password
 
|nvarchar(25)
 
|nvarchar(25)
 
|
 
|
Řádka 70: Řádka 70:
 
|
 
|
 
|-
 
|-
−
|OrderConfirmationPassword
+
|@OrderConfirmationPassword
 
|nvarchar(25)
 
|nvarchar(25)
 
|
 
|
Řádka 76: Řádka 76:
 
|
 
|
 
|-
 
|-
−
|Street
+
|@Street
 
|nvarchar(100)
 
|nvarchar(100)
 
|
 
|
Řádka 82: Řádka 82:
 
|
 
|
 
|-
 
|-
−
|City
+
|@City
 
|nvarchar(80)
 
|nvarchar(80)
 
|
 
|
Řádka 88: Řádka 88:
 
|
 
|
 
|-
 
|-
−
|ZIPCode
+
|@ZIPCode
 
|nvarchar(15)
 
|nvarchar(15)
 
|
 
|
Řádka 94: Řádka 94:
 
|
 
|
 
|-
 
|-
−
|State
+
|@State
 
|int
 
|int
 
|
 
|
Řádka 100: Řádka 100:
 
|API_GetCountry.ID
 
|API_GetCountry.ID
 
|-
 
|-
−
|BranchID
+
|@BranchID
 
|int
 
|int
 
|
 
|
Řádka 106: Řádka 106:
 
|API_GetBranches.ID
 
|API_GetBranches.ID
 
|-
 
|-
−
|WorkshopID
+
|@WorkshopID
 
|int
 
|int
 
|
 
|
Řádka 112: Řádka 112:
 
|API_GetWorkshops.ID
 
|API_GetWorkshops.ID
 
|-
 
|-
−
|StockID
+
|@StockID
 
|int
 
|int
 
|
 
|
Řádka 118: Řádka 118:
 
|API_GetStocks.ID
 
|API_GetStocks.ID
 
|-
 
|-
−
|CurrencyID
+
|@CurrencyID
 
|int
 
|int
 
|
 
|
Řádka 124: Řádka 124:
 
|API_GetCurrency.ID
 
|API_GetCurrency.ID
 
|-
 
|-
−
|SendOrderConfirmationEmail
+
|@SendOrderConfirmationEmail
 
|int
 
|int
 
|
 
|
Řádka 130: Řádka 130:
 
|
 
|
 
|-
 
|-
−
|OrderConfirmationEmail
+
|@OrderConfirmationEmail
 
|nvarchar(100)
 
|nvarchar(100)
 
|
 
|
Řádka 136: Řádka 136:
 
|
 
|
 
|-
 
|-
−
|Email
+
|@Email
 
|nvarchar(100)
 
|nvarchar(100)
 
|
 
|
Řádka 142: Řádka 142:
 
|
 
|
 
|-
 
|-
−
|EshopEmails
+
|@EshopEmails
 
|nvarchar(400)
 
|nvarchar(400)
 
|
 
|
Řádka 148: Řádka 148:
 
|
 
|
 
|-
 
|-
−
|IsBuyer
+
|@IsBuyer
 
|int
 
|int
 
|
 
|
Řádka 154: Řádka 154:
 
|
 
|
 
|-
 
|-
−
|IsSupplier
+
|@IsSupplier
 
|int
 
|int
 
|
 
|
Řádka 160: Řádka 160:
 
|
 
|
 
|-
 
|-
−
|Region
+
|@Region
 
|nvarchar(30)
 
|nvarchar(30)
 
|
 
|
Řádka 166: Řádka 166:
 
|
 
|
 
|-
 
|-
−
|Country
+
|@Country
 
|nvarchar(50)
 
|nvarchar(50)
 
|
 
|
Řádka 172: Řádka 172:
 
|
 
|
 
|-
 
|-
−
|IsCompetition
+
|@IsCompetition
 
|int
 
|int
 
|
 
|
Řádka 178: Řádka 178:
 
|
 
|
 
|-
 
|-
−
|FileMarkText
+
|@FileMarkText
 
|nvarchar(200)
 
|nvarchar(200)
 
|
 
|
Řádka 184: Řádka 184:
 
|
 
|
 
|-
 
|-
−
|IsWSInvoicesExportAllowed
+
|@IsWSInvoicesExportAllowed
 
|bit
 
|bit
 
|
 
|
Řádka 190: Řádka 190:
 
|
 
|
 
|-
 
|-
−
|IsWSDeliveryNotesExportAllowed
+
|@IsWSDeliveryNotesExportAllowed
 
|bit
 
|bit
 
|
 
|
Řádka 196: Řádka 196:
 
|
 
|
 
|-
 
|-
−
|IsWSImportOrdersAllowed
+
|@IsWSImportOrdersAllowed
 
|bit
 
|bit
 
|
 
|
Řádka 202: Řádka 202:
 
|
 
|
 
|-
 
|-
−
|StoreBackOrder
+
|@StoreBackOrder
 
|int
 
|int
 
|
 
|
Řádka 208: Řádka 208:
 
|
 
|
 
|-
 
|-
−
|IsSupplierIndividualOrders
+
|@IsSupplierIndividualOrders
 
|int
 
|int
 
|
 
|
Řádka 214: Řádka 214:
 
|
 
|
 
|-
 
|-
−
|IsSupplierShortcut
+
|@IsSupplierShortcut
 
|nvarchar(10)
 
|nvarchar(10)
 
|
 
|
Řádka 220: Řádka 220:
 
|
 
|
 
|-
 
|-
−
|Note
+
|@Note
 
|nvarchar(500)
 
|nvarchar(500)
 
|
 
|
Řádka 226: Řádka 226:
 
|
 
|
 
|-
 
|-
−
|Note2
+
|@Note2
 
|nvarchar(500)
 
|nvarchar(500)
 
|
 
|
Řádka 232: Řádka 232:
 
|
 
|
 
|-
 
|-
−
|GlobalPricing
+
|@GlobalPricing
 
|int
 
|int
 
|
 
|
Řádka 238: Řádka 238:
 
|
 
|
 
|-
 
|-
−
|OrderGroup
+
|@OrderGroup
 
|nvarchar(10)
 
|nvarchar(10)
 
|
 
|
Řádka 244: Řádka 244:
 
|
 
|
 
|-
 
|-
−
|GPSLatitude
+
|@GPSLatitude
 
|nvarchar(20)
 
|nvarchar(20)
 
|
 
|
Řádka 250: Řádka 250:
 
|
 
|
 
|-
 
|-
−
|GPSLongitude
+
|@GPSLongitude
 
|nvarchar(20)
 
|nvarchar(20)
 
|
 
|
Řádka 256: Řádka 256:
 
|
 
|
 
|-
 
|-
 +
|@ParentID
 +
|int
 +
|
 
|ParentID
 
|ParentID
 +
|
 +
|-
 +
|@VisibleProductsAmountOnStockLimit
 +
|int
 +
|
 +
|Visible products amount on stock limit
 +
-1 = Default,
 +
 +
0 = Picture,
 +
 +
5 = up to 5 products,
 +
 +
10 = up to 10 products,
 +
 +
1000 = full amount
 +
|
 +
|-
 +
|@AreOrdersVisible
 +
|int
 +
|
 +
|Are visible orders:
 +
-1 = Default,
 +
 +
0 = Off,
 +
 +
1 = On
 +
|
 +
|-
 +
|@DeliveryAddressID
 +
|int
 +
|
 +
|ID of delivery address from customer list (see relation).
 +
-1 = Default
 +
|API_GetCustomers.ID
 +
|-
 +
|@DefaultPaymentType
 +
|int
 +
|
 +
|Default payment type:
 +
0 = Default - cash,
 +
 +
1 = cash,
 +
 +
2 = transfer
 +
|
 +
|-
 +
|@DueType
 
|int
 
|int
 
|
 
|
−
|ParentID
+
|IF @DefaultPaymentType = 2. Due type:
 +
0 = Default - Global setting,
 +
 
 +
1 = Global setting,
 +
 
 +
2 = Individual setting
 +
|
 +
|-
 +
|@DueDays
 +
|int
 +
|
 +
|If @DefaultPaymentType = 2 and @DueType = 2. Due days:
 +
0 = Default
 +
|
 +
|-
 +
|@CorrectionPaymentType
 +
|int
 +
|
 +
|Correction payment type:
 +
1 = Default - cash,
 +
 
 +
2 = transfer
 +
|
 +
|-
 +
|@CorrectionPaymentRange
 +
|int
 +
|
 +
|If @CorrectionPaymentType = 2. Correction payment range:
 +
0 = Default - Global setting,
 +
 
 +
1 = Individual setting
 +
|
 +
|-
 +
|@CorrectionPaymentRangeDays
 +
|int
 +
|
 +
|If @CorrectionPaymentType = 2 and @CorrectionPaymentRange = 1. Correction payment range days:
 +
0 = Default
 
|
 
|
 
|}
 
|}
 +
 +
==== Return ====
 +
0 : OK
 +
100 : Item could not be created
  
 
==== Example ====
 
==== Example ====
 
<syntaxhighlight lang="sql">
 
<syntaxhighlight lang="sql">
−
EXEC [API_CreateCustomer] @WorkshopID = 1 ,@Name = 'Name'  
+
DECLARE @return_value int
 +
EXEC @return_value = [API_CreateCustomer] @ShortName= 'ShortName' ,@CompanyName= 'CompanyName' ,@CompanyRegistrationNumber= 'CompanyRegistrationNumber' ,@VATNumber= 'VATNumber' ,@VATNumber2= 'VATNumber2' ,@VATPayer= 1 ,@TransportID= 1 ,@Username= 'Username' ,@Password= 'Password' ,@OrderConfirmationPassword= 'OrderConfirmationPassword' ,@Street= 'Street' ,@City= 'City' ,@ZIPCode= 'ZIPCode' ,@State= 15797 ,@BranchID= 1 ,@WorkshopID= 1 ,@StockID= 1 ,@CurrencyID= 144 ,@SendOrderConfirmationEmail= 0 ,@OrderConfirmationEmail= 'OrderConfirmationEmail' ,@Email= 'Email' ,@EshopEmails= 'EshopEmails' ,@IsBuyer= 0 ,@IsSupplier= 0 ,@Region= 'Region' ,@Country= 'Country' ,@IsCompetition= 0 ,@FileMarkText= 'FileMarkText' ,@IsWSInvoicesExportAllowed= 0 ,@IsWSDeliveryNotesExportAllowed= 0 ,@IsWSImportOrdersAllowed= 0 ,@StoreBackOrder= 0 ,@IsSupplierIndividualOrders= 0 ,@IsSupplierShortcut= 'IsSupplierShortcut' ,@Note= 'Note' ,@Note2= 'Note2' ,@GlobalPricing= 0 ,@OrderGroup= 'OrderGroup' ,@GPSLatitude= 'GPSLatitude' ,@GPSLongitude= 'GPSLongitude' ,@ParentID= -1, @VisibleProductsAmountOnStockLimit = 10, @AreOrdersVisible = 1, @DeliveryAddressID = -1, @DefaultPaymentType = 1, @DueType = 1, @DueDays = 0, @CorrectionPaymentType = 1, @CorrectionPaymentRange = 0, @CorrectionPaymentRangeDays = 0
 
</syntaxhighlight>
 
</syntaxhighlight>
  
 
==== Notices ====
 
==== Notices ====
 
None.
 
None.

Aktuální verze z 13. 8. 2020, 10:31

Description

Method allows You to create new customer in system.

Exact name

API_CreateCustomer

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
@ShortName nvarchar(30) Short name
@CompanyName nvarchar(250) Company name
@CompanyRegistrationNumber nvarchar(20) Company registration number
@VATNumber nvarchar(20) VAT number
@VATNumber2 nvarchar(15) VAT number 2
@VATPayer int VATPayer
@TransportID int ID of transport from transport list (see relation) API_GetTransports.ID
@Username nvarchar(255) Username
@Password nvarchar(25) Password
@OrderConfirmationPassword nvarchar(25) Order confirmation password
@Street nvarchar(100) Street
@City nvarchar(80) City
@ZIPCode nvarchar(15) ZIP code
@State int ID of country from country list (see relation) API_GetCountry.ID
@BranchID int ID of branche from branch list (see relation) API_GetBranches.ID
@WorkshopID int ID of workshop from workshop list (see relation) API_GetWorkshops.ID
@StockID int ID of stock from stock list (see relation) API_GetStocks.ID
@CurrencyID int ID of currency from currency list (see relation) API_GetCurrency.ID
@SendOrderConfirmationEmail int Send order confirmation email
@OrderConfirmationEmail nvarchar(100) Order confirmation email
@Email nvarchar(100) Email
@EshopEmails nvarchar(400) Eshop emails
@IsBuyer int Is buyer
@IsSupplier int Is supplier
@Region nvarchar(30) Region
@Country nvarchar(50) Country
@IsCompetition int Is competition
@FileMarkText nvarchar(200) File mark text
@IsWSInvoicesExportAllowed bit Is WS invoices export allowed
@IsWSDeliveryNotesExportAllowed bit Is WS delivery notes export Allowed
@IsWSImportOrdersAllowed bit Is WS import orders Allowed
@StoreBackOrder int Store backorder
@IsSupplierIndividualOrders int Is supplier individual orders
@IsSupplierShortcut nvarchar(10) Is supplier shortcut
@Note nvarchar(500) Note
@Note2 nvarchar(500) Note 2
@GlobalPricing int Global pricing
@OrderGroup nvarchar(10) Order group
@GPSLatitude nvarchar(20) GPS latitude
@GPSLongitude nvarchar(20) GPS longitude
@ParentID int ParentID
@VisibleProductsAmountOnStockLimit int Visible products amount on stock limit

-1 = Default,

0 = Picture,

5 = up to 5 products,

10 = up to 10 products,

1000 = full amount

@AreOrdersVisible int Are visible orders:

-1 = Default,

0 = Off,

1 = On

@DeliveryAddressID int ID of delivery address from customer list (see relation).

-1 = Default

API_GetCustomers.ID
@DefaultPaymentType int Default payment type:

0 = Default - cash,

1 = cash,

2 = transfer

@DueType int IF @DefaultPaymentType = 2. Due type:

0 = Default - Global setting,

1 = Global setting,

2 = Individual setting

@DueDays int If @DefaultPaymentType = 2 and @DueType = 2. Due days:

0 = Default

@CorrectionPaymentType int Correction payment type:

1 = Default - cash,

2 = transfer

@CorrectionPaymentRange int If @CorrectionPaymentType = 2. Correction payment range:

0 = Default - Global setting,

1 = Individual setting

@CorrectionPaymentRangeDays int If @CorrectionPaymentType = 2 and @CorrectionPaymentRange = 1. Correction payment range days:

0 = Default

Return

0 : OK
100 : Item could not be created

Example

 DECLARE @return_value int
 EXEC @return_value = [API_CreateCustomer]  @ShortName= 'ShortName' ,@CompanyName= 'CompanyName' ,@CompanyRegistrationNumber= 'CompanyRegistrationNumber' ,@VATNumber= 'VATNumber' ,@VATNumber2= 'VATNumber2' ,@VATPayer= 1 ,@TransportID= 1 ,@Username= 'Username' ,@Password= 'Password' ,@OrderConfirmationPassword= 'OrderConfirmationPassword' ,@Street= 'Street' ,@City= 'City' ,@ZIPCode= 'ZIPCode' ,@State= 15797 ,@BranchID= 1 ,@WorkshopID= 1 ,@StockID= 1 ,@CurrencyID= 144 ,@SendOrderConfirmationEmail= 0 ,@OrderConfirmationEmail= 'OrderConfirmationEmail' ,@Email= 'Email' ,@EshopEmails= 'EshopEmails' ,@IsBuyer= 0 ,@IsSupplier= 0 ,@Region= 'Region' ,@Country= 'Country' ,@IsCompetition= 0 ,@FileMarkText= 'FileMarkText' ,@IsWSInvoicesExportAllowed= 0 ,@IsWSDeliveryNotesExportAllowed= 0 ,@IsWSImportOrdersAllowed= 0 ,@StoreBackOrder= 0 ,@IsSupplierIndividualOrders= 0 ,@IsSupplierShortcut= 'IsSupplierShortcut' ,@Note= 'Note' ,@Note2= 'Note2' ,@GlobalPricing= 0 ,@OrderGroup= 'OrderGroup' ,@GPSLatitude= 'GPSLatitude' ,@GPSLongitude= 'GPSLongitude' ,@ParentID= -1, @VisibleProductsAmountOnStockLimit = 10, @AreOrdersVisible = 1, @DeliveryAddressID = -1, @DefaultPaymentType = 1, @DueType = 1, @DueDays = 0, @CorrectionPaymentType = 1, @CorrectionPaymentRange = 0, @CorrectionPaymentRangeDays = 0

Notices

None.

Citováno z „https://podpora.nextis.cz/index.php?title=API_CreateCustomer&oldid=2768“