API GetCustomerSettings: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Bez shrnutí editace |
Bez shrnutí editace |
||
| (Nejsou zobrazeny 3 mezilehlé verze od stejného uživatele.) | |||
| Řádek 1: | Řádek 1: | ||
====Description==== | ====Description==== | ||
Method gives You overview of existing | Method gives You overview of existing customer settings in system. | ||
====Exact name==== | ====Exact name==== | ||
<code> | <code>API_GetCustomerSettings</code> | ||
====Type==== | ====Type==== | ||
Standard view. | Standard view. | ||
| Řádek 12: | Řádek 12: | ||
!Relation | !Relation | ||
|- | |- | ||
| | |CustomerID | ||
|int | |int | ||
|Internal system id | |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 | |int | ||
| | |If CorrectionPaymentType = 2 and CorrectionPaymentRange = 1. Correction payment range days: | ||
0 = Default | |||
| | | | ||
|} | |} | ||
====Example==== | ====Example==== | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
SELECT TOP 1000 * FROM [ | SELECT TOP 1000 * FROM [API_GetCustomerSettings] | ||
</syntaxhighlight> | </syntaxhighlight> | ||
====Notices<span> </span><span> </span>==== | ====Notices<span> </span><span> </span>==== | ||
None. | 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.