API GetPrivacyConsents: Porovnání verzí
Z Podpora.nextis.cz
| (Nejsou zobrazeny 2 mezilehlé verze od stejného uživatele.) | |||
| Řádka 15: | Řádka 15: | ||
!Relation | !Relation | ||
|- | |- | ||
| − | | | + | |ID |
|int | |int | ||
|Internal system id | |Internal system id | ||
| Řádka 32: | Řádka 32: | ||
|CompanyName | |CompanyName | ||
|nvarchar(250) | |nvarchar(250) | ||
| − | |Company name | + | |Company name of customer from customer list (see relation) |
| − | | | + | |API_GetCustomers.CompanyName |
|- | |- | ||
|ConsentTypeID | |ConsentTypeID | ||
|int | |int | ||
| − | | | + | |Consent type ID |
| | | | ||
|- | |- | ||
|ConsentType | |ConsentType | ||
|nvarchar(100) | |nvarchar(100) | ||
| − | | | + | |Consent type |
| | | | ||
|- | |- | ||
| Řádka 52: | Řádka 52: | ||
|IP | |IP | ||
|nvarchar(50) | |nvarchar(50) | ||
| − | | | + | |IP address |
| | | | ||
|- | |- | ||
|Headers | |Headers | ||
|text | |text | ||
| − | | | + | |Headers |
| | | | ||
|- | |- | ||
|State | |State | ||
|int | |int | ||
| − | | | + | |State |
| | | | ||
|} | |} | ||
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.
