API GetCustomerSettings: Porovnání verzí
Z Podpora.nextis.cz
| (Nejsou zobrazeny 3 mezilehlé verze od stejného uživatele.) | |||
| Řádka 1: | Řádka 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. | ||
| Řádka 12: | Řádka 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, 11: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.
