Modul 99 - Lager
|
Gelöscht |
et8_deleted |
int |
|
|
Etikett |
et8_label |
int |
|
|
free_Frei01 |
free_Frei01 |
varchar |
100 |
|
free_Frei02 |
free_Frei02 |
varchar |
100 |
|
free_Frei03 |
free_Frei03 |
varchar |
100 |
|
free_stock_amazontyp |
free_stock_amazontyp |
varchar |
255 |
|
free_stock_image_sonstige1 |
free_stock_image_sonstige1 |
varchar |
255 |
|
free_stock_pdf_1 |
free_stock_pdf_1 |
varchar |
255 |
|
free_stock_preisvorschlag_akzeptieren |
free_stock_preisvorschlag_akzeptieren |
varchar |
255 |
|
free_stock_produktcode |
free_stock_produktcode |
varchar |
255 |
|
free_stock_produkttyp |
free_stock_produkttyp |
varchar |
255 |
|
free_stock_shop_hersteller |
free_stock_shop_hersteller |
varchar |
255 |
|
free_stock_shop_kategorie |
free_stock_shop_kategorie |
varchar |
255 |
|
free_stock_shop_lieferant |
free_stock_shop_lieferant |
varchar |
255 |
|
free_stock_versandprofil |
free_stock_versandprofil |
varchar |
255 |
|
Aktiv bei amazon |
stock_amazonactive |
int |
|
|
ASIN - Amazon |
stock_asin |
varchar |
45 |
|
stock_auvitoactive |
stock_auvitoactive |
int |
|
|
Verfügbar |
stock_aviable |
int |
|
|
stock_aviabletime |
stock_aviabletime |
datetime |
|
|
stock_condition |
stock_condition |
varchar |
45 |
|
stock_created |
stock_created |
datetime |
|
|
stock_depth |
stock_depth |
double |
|
|
Beschreibung |
stock_description |
longtext |
4294967295 |
|
Differenzbesteuerung |
stock_dif |
tinyint |
|
|
EAN |
stock_ean |
varchar |
45 |
|
Aktiv bei eBay |
stock_ebayactive |
int |
|
|
EK |
stock_ek |
double |
|
|
stock_ekcalc |
stock_ekcalc |
double |
|
|
Interner Ordner |
stock_folder |
varchar |
20 |
|
Höhe |
stock_height |
double |
|
|
Aktiv bei Hood |
stock_hoodactive |
int |
|
|
Interne ID |
stock_id |
int |
|
|
stock_image1 |
stock_image1 |
varchar |
255 |
|
stock_image10 |
stock_image10 |
varchar |
255 |
|
stock_image11 |
stock_image11 |
varchar |
255 |
|
stock_image12 |
stock_image12 |
varchar |
255 |
|
stock_image2 |
stock_image2 |
varchar |
255 |
|
stock_image3 |
stock_image3 |
varchar |
255 |
|
stock_image4 |
stock_image4 |
varchar |
255 |
|
stock_image5 |
stock_image5 |
varchar |
255 |
|
stock_image6 |
stock_image6 |
varchar |
255 |
|
stock_image7 |
stock_image7 |
varchar |
255 |
|
stock_image8 |
stock_image8 |
varchar |
255 |
|
stock_image9 |
stock_image9 |
varchar |
255 |
|
stock_isbn |
stock_isbn |
varchar |
45 |
|
Variante |
stock_isvariant |
int |
|
|
stock_length |
stock_length |
double |
|
|
stock_manid |
stock_manid |
int |
|
|
Mindestbestand |
stock_minquantity |
int |
|
|
stock_minquantity_status |
stock_minquantity_status |
tinyint |
|
|
SKU |
stock_model |
varchar |
45 |
|
stock_modified |
stock_modified |
datetime |
|
|
stock_mpn |
stock_mpn |
varchar |
120 |
|
stock_mpn_number |
stock_mpn_number |
varchar |
80 |
|
Titel |
stock_name |
varchar |
150 |
|
stock_oldid |
stock_oldid |
int |
|
|
stock_parentid_stk |
stock_parentid_stk |
int |
|
|
stock_place |
stock_place |
varchar |
150 |
|
Bestand |
stock_quantity |
int |
|
|
stock_quantitysoft |
stock_quantitysoft |
int |
|
|
stock_quantityvirtual |
stock_quantityvirtual |
int |
|
|
stock_reserve |
stock_reserve |
int |
|
|
stock_ricardoactive |
stock_ricardoactive |
int |
|
|
Verkauft |
stock_sellcount |
int |
|
|
VK Brutto |
stock_sellprice |
decimal |
|
|
VK Aufgenommen |
stock_sellprice_history |
double |
|
|
VK zuletzt |
stock_sellprice_last |
double |
|
|
Aktiv Shop |
stock_shopactive |
int |
|
|
stock_shopprice |
stock_shopprice |
double |
|
|
Kurzbeschreibung |
stock_shortdescription |
text |
65535 |
|
Staffelpreis 1 Menge |
stock_staff_1_quantity |
int |
|
|
Staffelpreis 1 |
stock_staff_1_vk |
double |
|
|
Staffelpreis 1 Händler |
stock_staff_1_vkb |
double |
|
|
Staffelpreis 2 Menge |
stock_staff_2_quantity |
int |
|
|
Staffelpreis 2 |
stock_staff_2_vk |
double |
|
|
Staffelpreis 2 H‰ndler |
stock_staff_2_vkb |
double |
|
|
Staffelpreis 3 Menge |
stock_staff_3_quantity |
int |
|
|
Staffelpreis 3 |
stock_staff_3_vk |
double |
|
|
Staffelpreis 3 Händler |
stock_staff_3_vkb |
double |
|
|
Stückliste |
stock_stkitems |
int |
|
|
stock_stkpercent |
stock_stkpercent |
double |
|
|
stock_stksellprice |
stock_stksellprice |
double |
|
|
stock_supplierid |
stock_supplierid |
int |
|
|
stock_suppliernr |
stock_suppliernr |
varchar |
45 |
|
stock_supplierorder |
stock_supplierorder |
int |
|
|
Steuer |
stock_tax |
decimal |
|
|
stock_template |
stock_template |
varchar |
150 |
|
stock_upc |
stock_upc |
varchar |
45 |
|
stock_uvp |
stock_uvp |
double |
|
|
stock_vamandantid |
stock_vamandantid |
int |
|
|
stock_vastockinid |
stock_vastockinid |
int |
|
|
VK Händler |
stock_vk_b |
double |
|
|
Verp. Einh. |
stock_vpetype |
varchar |
25 |
|
Verp. Einh. Wert |
stock_vpevalue |
decimal |
|
|
Gewicht |
stock_weight |
decimal |
|
|
stock_width |
stock_width |
double |
|
|
template_id |
template_id |
int |
|