[Cuon-user_de] cuon stock

[Jürgen H. <jh...@cy...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,
Here are the new fields in our stock data tables, please inform me if
you need some more columns:

Tabelle stocks

 id              | integer                     | not null
 user_id         | character(25)               |
 status          | character(25)               |
 insert_time     | timestamp without time zone |
 update_time     | timestamp without time zone |
 update_user_id  | character varying(25)       |
 client          | integer                     | Vorgabewert 1
 sep_info_1      | integer                     | Vorgabewert 0
 sep_info_2      | integer                     | Vorgabewert 0
 sep_info_3      | integer                     | Vorgabewert 0
 versions_number | integer                     | Vorgabewert 0
 versions_uuid   | character varying(36)       | Vorgabewert
'0'::character varying
 name            | character varying(35)       |
 designation     | character varying(125)      |
 address         | character varying(255)      |
 phone           | character varying(50)       |
 uuid            | character varying(36)       | Vorgabewert
'0'::character varying

- ----NEU----




Tabelle stock_goods

id               | integer                     | not null
 user_id          | character(25)               |
 status           | character(25)               |
 insert_time      | timestamp without time zone |
 update_time      | timestamp without time zone |
 update_user_id   | character varying(25)       |
 client           | integer                     | Vorgabewert 1
 sep_info_1       | integer                     | Vorgabewert 0
 sep_info_2       | integer                     | Vorgabewert 0
 sep_info_3       | integer                     | Vorgabewert 0
 versions_number  | integer                     | Vorgabewert 0
 versions_uuid    | character varying(36)       | Vorgabewert
'0'::character varying
 stock_id         | integer                     |
 article_id       | integer                     |
 to_embed         | double precision            |
 roll_out         | double precision            |
 designation      | character varying(50)       |
 date_of_change   | timestamp without time zone |
 reference_number | character varying(30)       |
 actual_stock     | double precision            |
 uuid             | character varying(36)       | Vorgabewert
'0'::character varying

- ----NEU----

delivery_id with search button and info field to display address
stock_place_id
stock_place_info (varchar 250), for additional info like geo-ip, row,
column, folder
single_price ( for calculation and stocktaking[Inventur])
process_status




- ----NEU----
stock_place, for storage location, row, folder

id
designation
place (varchar 100), also allowed for geo-infomation,
allow_minus_values bool
special_flag ( for example to set this to a reserved stock_place )



best regards
Jürgen


- -- 
Cyrus-Computer GmbH Linux Server Support Jürgen Hamel
Cuon - Warenwirtschaft mit Linux  http://www.cuon.org
Twitter: cuonOne    Google+:
https://plus.google.com/u/0/104728678336561754401/
Linux Counter #79564
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.22 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iEYEARECAAYFAlNWjHoACgkQabQFsT6uaQDBuwCeN/uFIfZ6E65/Jj/yY22rqIeI
E3YAnjBzUSD3zR9wCXiRtFE0UZYI9VKB
=2zaL
-----END PGP SIGNATURE-----