API GetCustomerSettings: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
(Založena nová stránka s textem „d“)
 
 
(Nejsou zobrazeny 4 mezilehlé verze od stejného uživatele.)
Řádka 1: Řádka 1:
d
+
====Description====
 +
Method gives You overview of existing customer settings in system.
 +
====Exact name====
 +
<code>API_GetCustomerSettings</code>
 +
====Type====
 +
Standard view.
 +
====Specification====
 +
{| class="wikitable"
 +
!Column
 +
!Data type
 +
!Description
 +
!Relation
 +
|-
 +
|CustomerID
 +
|int
 +
|Internal system id
 +
ID of customer from customer list (see relation)
 +
|API_GetCustomers.ID
 +
|-
 +
|IsChildRegistrationEnabled
 +
|int
 +
|Is child registration enabled
 +
|
 +
|-
 +
|IsBlocked
 +
|int
 +
|Is blocked
 +
|
 +
|-
 +
|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
 +
|
 +
|}
 +
====Example====
 +
<syntaxhighlight lang="sql">
 +
SELECT TOP 1000 * FROM [API_GetCustomerSettings]
 +
</syntaxhighlight>
 +
====Notices<span> </span><span> </span>====
 +
None.

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

Description

Method gives You overview of existing customer settings in system.

Exact name

API_GetCustomerSettings

Type

Standard view.

Specification

Column Data type Description Relation
CustomerID int Internal system id

ID of customer from customer list (see relation)

API_GetCustomers.ID
IsChildRegistrationEnabled int Is child registration enabled
IsBlocked int Is blocked
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

Example

SELECT TOP 1000 * FROM [API_GetCustomerSettings]

Notices

None.