API GetCustomerSettings: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „d“) |
|||
| (Nejsou zobrazeny 4 mezilehlé verze od stejného uživatele.) | |||
| Řádka 1: | Řádka 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, 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.
