API GetPrivacyConsents: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
(Založena nová stránka s textem „df“)
 
Řádka 1: Řádka 1:
−
df
+
==== 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
 +
|-
 +
|PRIVACYConsentID
 +
|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
 +
|
 +
|-
 +
|ConsentTypeID
 +
|int
 +
|
 +
|
 +
|-
 +
|ConsentType
 +
|nvarchar(100)
 +
|
 +
|
 +
|-
 +
|Timestamp
 +
|datetime
 +
|Timestamp
 +
|
 +
|-
 +
|IP
 +
|nvarchar(50)
 +
|
 +
|
 +
|-
 +
|Headers
 +
|text
 +
|
 +
|
 +
|-
 +
|State
 +
|int
 +
|
 +
|
 +
|}
 +
 
 +
==== Example ====
 +
<syntaxhighlight lang="sql">
 +
SELECT TOP 1000 * FROM [API_GetPrivacyConsents]
 +
</syntaxhighlight>
 +
 
 +
==== Notices ====
 +
None.

Verze z 31. 5. 2018, 14:05

Description

Method gives You overview of existing privacy consents in system.

Exact name

API_GetPrivacyConsents

Type

Standard view.

Specification

Column Data type Description Relation
PRIVACYConsentID 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
ConsentTypeID int
ConsentType nvarchar(100)
Timestamp datetime Timestamp
IP nvarchar(50)
Headers text
State int

Example

SELECT TOP 1000 * FROM [API_GetPrivacyConsents]

Notices

None.

Citováno z „https://podpora.nextis.cz/index.php?title=API_GetPrivacyConsents&oldid=1222“