Differences
This shows you the differences between two versions of the page.
|
bps2:dbtables [2010/07/22 13:20] pkoch |
bps2:dbtables [2010/08/29 23:05] (current) pkoch |
||
|---|---|---|---|
| Line 5: | Line 5: | ||
| * Constraints not strictly required for correct database operation are omitted in the physical database, for example NOT NULL's. Such constraints are enforced by the application code.\\ | * Constraints not strictly required for correct database operation are omitted in the physical database, for example NOT NULL's. Such constraints are enforced by the application code.\\ | ||
| * The BPS datastores are not designed for safe write by any non-BPS application or tool. While reading the BPS datastores is safe, writing is only allowed through the BPS applications and scripts. **Any other write access voids the warranty and support conditions.** | * The BPS datastores are not designed for safe write by any non-BPS application or tool. While reading the BPS datastores is safe, writing is only allowed through the BPS applications and scripts. **Any other write access voids the warranty and support conditions.** | ||
| - | * Tables starting with ''t_pr_'' are interface tables for the GEKO and TAKO robots do not belong to the core. They are documented in the [[de:bps2:gekotakospec|interface description]]. | + | * Tables starting with ''t_geko_'' and ''t_tako_'' are interface tables for the GEKO and TAKO robots do not belong to the BPS core. They are documented in the [[de:bps2:gekotakospec|interface description]]. |
| + | * Tables starting with ''ct_'' are custom tables and do not belong to the BPS core. Ask your system integrator for documentation of such tables. | ||
| ===== Reference ===== | ===== Reference ===== | ||
| Line 89: | Line 90: | ||
| | c_article | number(15) not null | Article key, references [[#t_articles]]. | | | c_article | number(15) not null | Article key, references [[#t_articles]]. | | ||
| | c_prio | number | Priority: Lower number are higher priorities. The topmost picture is shown in certain picking applications. | | | c_prio | number | Priority: Lower number are higher priorities. The topmost picture is shown in certain picking applications. | | ||
| + | | c_type | varchar(10) | Data file type. Any types can be read and written by Qt, for example JPG, PNG, TIF, GIF, BMP. The used type can be limited in the validator c_type.formats, by default pictures are stored as PNG if the picture has alpha transparency, or JPG otherwise. | | ||
| + | | c_size | number not null | Size of the data file contents in bytes. | | ||
| | c_data | blob | Data file contents. | | | c_data | blob | Data file contents. | | ||
| Line 147: | Line 150: | ||
| | c_selldays | number | Number of selling days after production/labeling. | | | c_selldays | number | Number of selling days after production/labeling. | | ||
| | c_expiredays | number | Expires this number days after production/labeling. | | | c_expiredays | number | Expires this number days after production/labeling. | | ||
| + | | c_overdelivery | number | Number of remaining units in robot stocks, which can be overdelivered in case to empty down the stock. When more units are left at end of an order trip, no overdelivery happens at all and the units are kept for the next order trip. | | ||
| | c_intakecode | varchar(1) not null | Intake registration code:\\ ''c'' = count only\\ ''w'' = count and weigh. | | | c_intakecode | varchar(1) not null | Intake registration code:\\ ''c'' = count only\\ ''w'' = count and weigh. | | ||
| | c_delivcode | varchar(1) not null | Delivery registration code:\\ ''c'' = count only\\ ''w'' = count and weigh. | | | c_delivcode | varchar(1) not null | Delivery registration code:\\ ''c'' = count only\\ ''w'' = count and weigh. | | ||
| | c_pickremarks | varchar(4000) | Remarks shown when picking. | | | c_pickremarks | varchar(4000) | Remarks shown when picking. | | ||
| + | | c_hdlspeed | number not null | Allowed handling speed.\\ -2 = very slow\\ -1 = slow\\ 0 = medium\\ 1 = fast\\ 2 = very fast | | ||
| | c_fps_lus | number | Free pickable stock expressed in logistic units.\\ (Shadow column, read-only!). | | | c_fps_lus | number | Free pickable stock expressed in logistic units.\\ (Shadow column, read-only!). | | ||
| | c_fps_tus | number | Free pickable stock expressed in traded units.\\ (Shadow column, read-only!). | | | c_fps_tus | number | Free pickable stock expressed in traded units.\\ (Shadow column, read-only!). | | ||
| Line 360: | Line 365: | ||
| | c_orderitem | number(15) not null | References [[#t_orderitems]]. | | | c_orderitem | number(15) not null | References [[#t_orderitems]]. | | ||
| | c_actor | number(15) not null | References [[#t_actors]]. | | | c_actor | number(15) not null | References [[#t_actors]]. | | ||
| + | |||
| + | ==== t_orderitemrobots ==== | ||
| + | |||
| + | Order item robot status record. | ||
| + | |||
| + | ^ Column ^ Type ^ Description ^ | ||
| + | | c_key | number(15) not null | Primary key. | | ||
| + | | c_ordertriprobot | number(15) not null | References [[#t_ordertriprobots]]. | | ||
| + | | c_orderitem | number(15) not null | References [[#t_orderitems]]. | | ||
| + | | c_mergeclass | number(15) not null | References [[#t_mergeclasses]]. | | ||
| + | | c_planned | number not null | Planned delivery quantitiy in OU's. | | ||
| + | |||
| ==== t_orderitems ==== | ==== t_orderitems ==== | ||
| Line 443: | Line 460: | ||
| + | |||
| + | ==== t_ordertriprobots ==== | ||
| + | |||
| + | Order trip robot status record. | ||
| + | |||
| + | ^ Column ^ Type ^ Description ^ | ||
| + | | c_key | number(15) not null | Primary key. | | ||
| + | | c_ordertrip | number(15) not null | References [[#t_ordertrips]]. | | ||
| + | | c_pickzone | number(15) not null | References [[#t_pickzones]]. | | ||
| + | | c_status | varchar(1) not null | ''u'' = unsent\\ ''s'' = sent\\ ''a'' = active\\ ''f'' = finished | | ||
| + | |||
| ==== t_ordertrips ==== | ==== t_ordertrips ==== | ||
| The trips for order delivery to buyers. | The trips for order delivery to buyers. | ||
| - | + | ||
| - | ^ Column ^ Type ^ Description ^ | + | ^ Column ^ Type ^ Description ^ |
| - | | c_key | number(15) not null | Primary key. | | + | | c_key | number(15) not null | Primary key. | |
| | c_status | varchar(1) not null | ''n'' = new, being created\\ ''r'' = ready for working\\ ''a'' = actively picking\\ ''c'' = completed \\ ''h''= History, archived | | | c_status | varchar(1) not null | ''n'' = new, being created\\ ''r'' = ready for working\\ ''a'' = actively picking\\ ''c'' = completed \\ ''h''= History, archived | | ||
| - | | c_date | timestamp not null | Date of trip departure. | | + | | c_date | timestamp not null | Date of trip departure. | |
| - | | c_trip | number(15) not null | References [[#t_trips]]. | | + | | c_trip | number(15) not nul | References [[#t_trips]]. | |
| - | | c_remarks | varchar(4000) | Open trip remarks. | | + | | c_remarks | varchar(4000) | Open trip remarks. | |
| Line 477: | Line 505: | ||
| Package records (bins, barrels, boxes, pallets etc.). | Package records (bins, barrels, boxes, pallets etc.). | ||
| + | The factors packages per layer, and layers per container refer to the regular container of the package, which is a palette in most applicationa. | ||
| + | |||
| ^ Column ^ Type ^ Description ^ | ^ Column ^ Type ^ Description ^ | ||
| | c_key | number(15) not null | Primary key. | | | c_key | number(15) not null | Primary key. | | ||
| Line 486: | Line 516: | ||
| | c_height | number not null | Total height in meters. | | | c_height | number not null | Total height in meters. | | ||
| | c_socket | number not null | Socket height in meters. When stacking, the socket of the upper bin sinks into the lower bin, so the total stack height is n * height - (n-1) * socket. | | | c_socket | number not null | Socket height in meters. When stacking, the socket of the upper bin sinks into the lower bin, so the total stack height is n * height - (n-1) * socket. | | ||
| + | | c_pkg_lyr_in | number not null | Packages per layer inbound e.g. when receiving from suppliers or manufacturers. | | ||
| + | | c_lyr_ctr_in | number not null | Layers per container inbound e.g. when receiving from suppliers or manufacturers. | | ||
| + | | c_pkg_lyr_out | number not null | Packages per layer outbound e.g. when delivering to customers or branches. | | ||
| + | | c_lyr_ctr_out | number not null | Layers per container inbound e.g. when receiving to customers or branches. | | ||
| | c_press | number not null | Allowed pressing force.\\ -2 = very low\\ -1 = low\\ 0 = medium\\ 1 = high\\ 2 = very high | | | c_press | number not null | Allowed pressing force.\\ -2 = very low\\ -1 = low\\ 0 = medium\\ 1 = high\\ 2 = very high | | ||
| Line 529: | Line 563: | ||
| | c_status | varchar(1) not null | ''a'' = active\\ ''l'' = locked\\ ''d'' = marked for deletion. | | | c_status | varchar(1) not null | ''a'' = active\\ ''l'' = locked\\ ''d'' = marked for deletion. | | ||
| | c_partnerclass | number(15) | References [[#t_partnerclasses]]. | | | c_partnerclass | number(15) | References [[#t_partnerclasses]]. | | ||
| + | | c_salechannel | number(15) | References [[#t_salechannels]]. | | ||
| | c_closeprio | number | Closure priority. Lower number are higher priorities. Partners with same priority are sorted by c_client, c_ident, c_key ascending. A null value is interpreted as lowest possible priority. | | | c_closeprio | number | Closure priority. Lower number are higher priorities. Partners with same priority are sorted by c_client, c_ident, c_key ascending. A null value is interpreted as lowest possible priority. | | ||
| | c_barcodetype | varchar(10) | See [[bps2:scanning|Barcode scanning]]. | | | c_barcodetype | varchar(10) | See [[bps2:scanning|Barcode scanning]]. | | ||
| Line 568: | Line 603: | ||
| - | ==== t_partnertrips ==== | ||
| - | |||
| - | Trips assigned to distinct partners. | ||
| - | |||
| - | ^ Column ^ Type ^ Description ^ | ||
| - | | c_partner | number(15) not null | References [[#t_partners]]. | | ||
| - | | c_trip | number(15) not null | References [[#t_trips]]. | | ||
| Line 688: | Line 716: | ||
| | c_user | number(15) | The user ID for private settings, or NULL for public settings. References [[#t_users]]. | | | c_user | number(15) | The user ID for private settings, or NULL for public settings. References [[#t_users]]. | | ||
| | c_application | varchar(35) not null | Name of the application this settings are for. | | | c_application | varchar(35) not null | Name of the application this settings are for. | | ||
| + | |||
| + | ==== t_robotlocks ==== | ||
| + | |||
| + | Locks held on order items. | ||
| + | |||
| + | ^ Column ^ Type ^ Description ^ | ||
| + | | c_pickzone | number(15) not null | References [[#t_pickzones]]. | | ||
| + | | c_actor | number(15) not null | References [[#t_actors]]. | | ||
| + | |||
| + | |||
| + | ==== t_salechannels ==== | ||
| + | |||
| + | Sale/distribution channels to be assigned to partners. | ||
| + | |||
| + | ^ Column ^ Type ^ Description ^ | ||
| + | | c_key | number(15) not null | Primary key. | | ||
| + | | c_parent | number(15) | Parent item. Root items are null. | | ||
| + | | c_name | varchar(35) not null | Name of the class element. May not contain any slash. | | ||
| ==== t_saleclasses ==== | ==== t_saleclasses ==== | ||
| - | Sale classes (for example in Migros: BoSS). | + | Sale classes to be assigned to articles (for example in Migros: BoSS). |
| ^ Column ^ Type ^ Description ^ | ^ Column ^ Type ^ Description ^ | ||
| Line 816: | Line 862: | ||
| 's+' = stocktaking plus correction\\ | 's+' = stocktaking plus correction\\ | ||
| 's-' = stocktaking minus correction\\ | 's-' = stocktaking minus correction\\ | ||
| - | 'a+' = automatic sync plus correction\\ | + | 'a' = automatic sync |
| - | 'a-' = automatic sync minus correction | + | |
| Line 844: | Line 889: | ||
| | c_name | varchar(35) not null | Name of the class element. May not contain any slash. | | | c_name | varchar(35) not null | Name of the class element. May not contain any slash. | | ||
| + | |||
| + | ==== t_trippartners ==== | ||
| + | |||
| + | Partners settings per trip. | ||
| + | |||
| + | ^ Column ^ Type ^ Description ^ | ||
| + | | c_key | number(15) not null | Primary key. | | ||
| + | | c_trip | number(15) not null | References [[#t_trips]]. | | ||
| + | | c_partner | number(15) not null | References [[#t_partners]]. | | ||
| + | | c_prio | number | Picking priority. Lower number are higher priorities. Partners with same priority are ordered by c_partner ascending. A null value is interpreted as lowest possible priority. | | ||
| + | | c_htime | number not null | Handover time in hours.minutes. At this time the order picking should be finished. | | ||
| + | | c_restmode | varchar(1) not null | How to handle non full LU's for the partner by robots:\\ ''n'' = no further picking.\\ ''m'' = manually continue picking to fill up the LU. | | ||
| ==== t_trips ==== | ==== t_trips ==== | ||
| Line 860: | Line 917: | ||
| | c_bgcolor | varchar(35) not null | Background color name. | | | c_bgcolor | varchar(35) not null | Background color name. | | ||
| | c_schedule | varchar(350) not null | Schedule times in CRON syntax. | | | c_schedule | varchar(350) not null | Schedule times in CRON syntax. | | ||
| + | | c_ptime | number not null | Preload time in hours.minutes. How much the picking should be finished in advance of the trips schedule time. | | ||
| + | | c_fillgrade | number not null | Percentage of actual filling of a logistic unit, to handle the unit as "full". | | ||
| + | | c_robotmode | varchar(1) not null | Robot working mode.\\ ''o'' = order waves\\ ''l'' = LU waves | | ||
| + | | c_robotupdt | varchar(1) not null | How new created order items are sent to a robot, in case some items of the order trip were already send to the robot before.\\ ''m'' = manual by user action\\ ''i'' = Automatic for items of partner orders where c_origin is empty (internal orders created by BPS itself)\\ ''a'' = All automatic | | ||
| ==== t_usergroups ==== | ==== t_usergroups ==== | ||