PriceListLines |
Catalog: Dummy
Schema: Demo
This is a read-only view. The Dummy API may not support changing the data or the Invantive SQL driver for Dummy does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Dummy API.
View Columns
The columns of the view PriceListLines are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
plt_code |
string |
|
☑ |
|
plt_id |
int64 |
|
☑ |
|
plt_in_code |
string |
|
☐ |
|
plt_in_id |
int64 |
|
☐ |
|
plt_in_koppel_ind |
string |
|
☐ |
|
plt_in_omschrijving |
string |
|
☐ |
|
plt_koppel_ind |
string |
|
☑ |
|
plt_omschrijving |
string |
|
☑ |
|
prl_aangemaakt_door |
string |
|
☑ |
|
prl_aangemaakt_in |
string |
|
☑ |
|
prl_bedrag_verkoopprijs |
decimal |
|
☐ |
|
prl_bijgewerkt_door |
string |
|
☑ |
|
prl_bijgewerkt_in |
string |
|
☑ |
|
prl_datum_aangemaakt |
datetime |
|
☑ |
|
prl_datum_bijgewerkt |
datetime |
|
☑ |
|
prl_datum_geldig_tot |
datetime |
|
☐ |
|
prl_datum_geldig_vanaf |
datetime |
|
☑ |
|
prl_datum_intrf_bijgewerkt |
datetime |
|
☐ |
|
prl_datum_intrf_geladen |
datetime |
|
☐ |
|
prl_id |
int64 |
|
☑ |
|
prl_job_seq_geladen |
int64 |
|
☐ |
|
prl_kolom_soort |
string |
|
☐ |
|
prl_kolom1 |
string |
|
☐ |
|
prl_kolom10 |
string |
|
☐ |
|
prl_kolom2 |
string |
|
☐ |
|
prl_kolom3 |
string |
|
☐ |
|
prl_kolom4 |
string |
|
☐ |
|
prl_kolom5 |
string |
|
☐ |
|
prl_kolom6 |
string |
|
☐ |
|
prl_kolom7 |
string |
|
☐ |
|
prl_kolom8 |
string |
|
☐ |
|
prl_kolom9 |
string |
|
☐ |
|
prl_nk |
string |
|
☐ |
|
prl_orig_system_group |
string |
|
☐ |
|
prl_orig_system_reference |
string |
|
☐ |
|
prl_partitie |
int64 |
|
☑ |
|
prl_sessie_aangemaakt |
string |
|
☑ |
|
prl_sessie_bijgewerkt |
string |
|
☑ |
|
prl_sorteer_volgorde |
int64 |
|
☑ |
|
prl_toelichting |
string |
|
☐ |
|
prl_transactie_aangemaakt |
int64 |
|
☑ |
|
prl_transactie_bijgewerkt |
int64 |
|
☑ |
|
unt_deelbaar_vlag |
string |
|
☐ |
|
unt_id |
int64 |
|
☐ |
|
unt_ikoon_url_ult |
string |
|
☐ |
|
unt_ikoon_url |
string |
|
☐ |
|
unt_kopieerbaar_vlag |
string |
|
☐ |
|
unt_label |
string |
|
☐ |
|
unt_omschrijving |
string |
|
☐ |
|
unt_serienummer |
string |
|
☐ |
|
unt_verkoopbaar_vlag |
string |
|
☐ |
|
unt_volledige_code |
int64 |
|
☐ |
|
unt_voorraad_vlag |
string |
|
☐ |
|
unt_vpl_verkoopprijs_vlag |
string |
|
☐ |
|
ust_code |
string |
|
☐ |
|
ust_id |
int64 |
|
☐ |
|
ust_ikoon_url |
string |
|
☐ |
|
ust_omschrijving |
string |
|
☐ |
|
ust_vpl_verkoopprijs_vlag |
string |
|
☐ |
|
22-12-2022 20:48 Version 22.1.101-BETA+3681