API GetCustomerSettings: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Založena nová stránka s textem „d“ |
Bez shrnutí editace |
||
| (Nejsou zobrazeny 4 mezilehlé verze od stejného uživatele.) | |||
| Řádek 1: | Řádek 1: | ||
====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, 10: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.