API GetPrivacyConsents: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „df“) |
|||
| (Nejsou zobrazeny 3 mezilehlé verze od stejného uživatele.) | |||
| Řádka 1: | Řádka 1: | ||
| − | + | ==== Description ==== | |
| + | Method gives You overview of existing privacy consents in system. | ||
| + | |||
| + | ==== Exact name ==== | ||
| + | <code>API_GetPrivacyConsents</code> | ||
| + | |||
| + | ==== Type ==== | ||
| + | Standard view. | ||
| + | |||
| + | ==== Specification ==== | ||
| + | {| class="wikitable" | ||
| + | !Column | ||
| + | !Data type | ||
| + | !Description | ||
| + | !Relation | ||
| + | |- | ||
| + | |ID | ||
| + | |int | ||
| + | |Internal system id | ||
| + | | | ||
| + | |- | ||
| + | |CustomersID | ||
| + | |int | ||
| + | |ID of customer from customer list (see relation) | ||
| + | |API_GetCustomers.ID | ||
| + | |- | ||
| + | |BranchID | ||
| + | |int | ||
| + | |ID of branche from branch list (see relation) | ||
| + | |API_GetBranches.ID | ||
| + | |- | ||
| + | |CompanyName | ||
| + | |nvarchar(250) | ||
| + | |Company name of customer from customer list (see relation) | ||
| + | |API_GetCustomers.CompanyName | ||
| + | |- | ||
| + | |ConsentTypeID | ||
| + | |int | ||
| + | |Consent type ID | ||
| + | | | ||
| + | |- | ||
| + | |ConsentType | ||
| + | |nvarchar(100) | ||
| + | |Consent type | ||
| + | | | ||
| + | |- | ||
| + | |Timestamp | ||
| + | |datetime | ||
| + | |Timestamp | ||
| + | | | ||
| + | |- | ||
| + | |IP | ||
| + | |nvarchar(50) | ||
| + | |IP address | ||
| + | | | ||
| + | |- | ||
| + | |Headers | ||
| + | |text | ||
| + | |Headers | ||
| + | | | ||
| + | |- | ||
| + | |State | ||
| + | |int | ||
| + | |State | ||
| + | | | ||
| + | |} | ||
| + | |||
| + | ==== Example ==== | ||
| + | <syntaxhighlight lang="sql"> | ||
| + | SELECT TOP 1000 * FROM [API_GetPrivacyConsents] | ||
| + | </syntaxhighlight> | ||
| + | |||
| + | ==== Notices ==== | ||
| + | None. | ||
Aktuální verze z 31. 5. 2018, 13:12
Description
Method gives You overview of existing privacy consents in system.
Exact name
API_GetPrivacyConsents
Type
Standard view.
Specification
| Column | Data type | Description | Relation |
|---|---|---|---|
| ID | int | Internal system id | |
| CustomersID | int | ID of customer from customer list (see relation) | API_GetCustomers.ID |
| BranchID | int | ID of branche from branch list (see relation) | API_GetBranches.ID |
| CompanyName | nvarchar(250) | Company name of customer from customer list (see relation) | API_GetCustomers.CompanyName |
| ConsentTypeID | int | Consent type ID | |
| ConsentType | nvarchar(100) | Consent type | |
| Timestamp | datetime | Timestamp | |
| IP | nvarchar(50) | IP address | |
| Headers | text | Headers | |
| State | int | State |
Example
SELECT TOP 1000 * FROM [API_GetPrivacyConsents]
Notices
None.
