GX:Appendix C Whistle Database Tables: Difference between revisions
Jump to navigation
Jump to search
Line 2,482: | Line 2,482: | ||
===wms_kit_tbl=== | ===wms_kit_tbl=== | ||
*gl_cmp_key | | | ||
* | *gl_cmp_key | ||
* | *in_whs_key | ||
* | *wms_kititem_key | ||
* | *wms_kitpack_key | ||
* | *in_item_key | ||
* | *im_pack_key | ||
* | *wms_kit_qty | ||
* | *wms_kit_uom | ||
* | *created_by | ||
* | *created_on | ||
* | *changed_by | ||
* | *changed_on | ||
*lock_count | |||
| | |||
*varchar(2) | |||
*varchar(4) | |||
*varchar(20) | |||
*varchar(6) | |||
*varchar(20) | |||
*varchar(6) | |||
*float | |||
*varchar(2) | |||
*varchar(8) | |||
*datetime | |||
*varchar(8) | |||
*datetime | |||
*int | |||
| | |||
*NOTNULL | |||
*NOTNULL | |||
*NOTNULL | |||
*NOTNULL | |||
*NOTNULL | |||
*NOTNULL | |||
*NOTNULL | |||
*NOTNULL | |||
*NOTNULL | |||
*NOTNULL | |||
*NOTNULL | |||
*NOTNULL | |||
*NOTNULL | |||
| | |||
*Company Key | |||
*Warehouse Key | |||
*Kit Item Key | |||
*Kit Pack Key | |||
*Item Key | |||
*Pack Key | |||
*Kit Quantity Value | |||
*Kit UOM Value | |||
*Created by Date/Time Value | |||
*Created on Date/Time Value | |||
*User Key | |||
*Changed on Date/Time Value | |||
*Lock Counter Key | |||
|} | |||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,502: | Line 2,546: | ||
!Key Description | !Key Description | ||
|- | |- | ||
===wms_lhold_tbl=== | ===wms_lhold_tbl=== | ||
*gl_cmp_key varchar(3) NULL Company Key | *gl_cmp_key varchar(3) NULL Company Key |
Revision as of 23:07, 18 September 2006
Whistle Database Tables
The Whistle application uses a number of database tables to store and organize warehouse information. Whistle updates most tables automatically. Other tables, such as the ‘user’ tables, are updated manually through the use of data maintenance frames (see chapter on Data Maintenance Frames). This is a comprehensive listing of all Whistle – specific database tables and their corresponding parameters.
The following is a list of all Whistle database tables. Each table is described in detail in later in this appendix.
Whistle Tables | Common Keys and DataTypes | Data Types | ||
---|---|---|---|---|
|
|
|
Whistle Tables and Definitions
wmCountDetail
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmCountMaster
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmCountZones
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmCountedBins
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmCustomer
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmDemand
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmItemInstruct
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmLabelCrossRef
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmLabelElements
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmPickAllocation
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmPrintJobs
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmRuleContext
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmRuleContextLine
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmRuleMaster
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmScaleDefinition
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmTaskMaster
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmTestHistory
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmUomConv
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmUserPrefs
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmUserTask
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmWave
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_autohd_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_bin_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_bincnt_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_bindtlst_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_case_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_contadj_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_contcase_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_contdtl_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_context_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_conthdr_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_contst_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_contty_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_contxf_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_counter_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_ctwght_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_custpull_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_cycnt_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_erpint_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_except_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_group_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_kit_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_lhold_tbl
- gl_cmp_key varchar(3) NULL Company Key
- in_whs_key varchar(4) NULL Warehouse Key
- sa_user_key varchar(8) NULL User Key
- wms_lhold_lot varchar(25) NULL Lot Hold Lot Value
- wms_lhold_bgdt datetime NULL Beginning Hold Date/Time Value
- wms_lhold_eddt datetime NULL Ending Hold Date/Time Value
- wms_lhold_cmt varchar(255) NULL Comment Value
- wms_lhold_trdt datetime NULL Date Lot Placed On Hold Value
Column | Data Type | Nullable | Key Description |
---|
wms_load_tbl
- gl_cmp_key varchar(2) NOTNULL Company Key
- so_brnch_key varchar(4) NOTNULL Branch Key
- so_hdr_key varchar(10) NOTNULL Tracking Key
- wms_load_bol varchar(25) NOTNULL Load BOL Value
- wms_load_trailer varchar(25) NULL Load Trailer Value
- wms_load_seal varchar(45) NULL Load Seal Value
- wms_load_chep int NULL Load Chep Value
- wms_load_shpdt datetime NULL Load Ship Date/Time Value
- in_towhs_key varchar(4) NULL To WHS Key
- carrier varchar(10) NULL Carrier Value
- prePaidFreight float NULL Pre Paid Freight Value
- status varchar(10) NULL Status Value
- loadKey varchar(10) NULL Load Key
Column | Data Type | Nullable | Key Description |
---|
wms_loadnm_tbl
- gl_cmp_key varchar(2) NOTNULL Company Key
- so_brnch_key varchar(4) NOTNULL Branch Key
- so_hdr_key varchar(10) NOTNULL Tracking Key
- wms_loadnm_key int NULL Load Name Key
Column | Data Type | Nullable | Key Description |
---|
wms_lothist_tbl
- gl_cmp_key varchar(3) NULL Company Key
- in_whs_key varchar(4) NULL Warehouse Key
- wms_conthdr_key varchar(10) NULL Tracking Key
- wms_tran_type varchar(15) NULL Transaction Type Key
- wms_tran_key varchar(20) NULL Transaction Key
- in_lot_key varchar(25) NULL Lot Key
- sa_user_key varchar(8) NULL User Key
- wms_lothist_crtdt datetime NULL Date of transaction Value
- wms_lothist_qty float NULL Lot History Quantity Value
- wms_lothist_uom varchar(2) NULL Unit Of Measure Value
- wms_contdtl_key int NOTNULL Container detail Key
- comment_key varchar(255) NULL Comment Value
- wms_lothist_key int (IDENTITY) NOTNULL Lot History Key
Column | Data Type | Nullable | Key Description |
---|
wms_outint_tbl
- gl_cmp_key varchar(3) NOTNULL Company Key
- so_brnch_key varchar(4) NOTNULL Branch key
- so_hdr_key varchar(10) NOTNULL Order Key
- so_prod_key varchar(30) NULL Product Key
- wms_conthdr_key varchar(10) NULL Tracking Key
- wms_outint_qty float NULL Quantity Value
- wms_outint_uom varchar(2) NULL Unit of Measure Value
- in_lot_key varchar(25) NULL Lot Key
- wms_outint_error varchar(255) NULL Status Value
- sa_user_key varchar(8) NULL User Key
- wms_outint_crtdt datetime NULL Date/Time Stamp Value
- wms_outint_type int NOTNULL Type of Transaction Value
- wms_outdtl_key int NULL Out-Int Detail Key
- in_whs_key varchar(4) NULL Warehouse Key
- in_towhs_key varchar(4) NULL To WHS Key
- wms_contdtl_key smallint NULL Container Detail Key
- wms_whistle_recdt datetime NULL Whistle Receive Date/Time
- in_item_key varchar(20) NULL Item Key
- im_pack_key varchar(6) NULL Pack Key
- wms_outint_control varchar(60) NULL Outint Control Key
- wms_outint_unique int (IDENTITY) NOTNULL Outint Unique Key
Column | Data Type | Nullable | Key Description |
---|
wms_piint_tbl
- wms_piint_error varchar(255) NULL Message Value===
- gl_cmp_key varchar(3) NULL Company Key
- sf_plant_key varchar(10) NULL Plant Key
- in_whs_key varchar(4) NULL Warehouse Key
- in_locn_key varchar(10) NULL Location Key
- pm_shop_key varchar(10) NULL Production Order Key
- pm_shop_ordtp varchar(1) NULL Order Type Value
- sf_opseq_key int NULL Routing sequence
- wms_piint_bqty float NULL Batch Quantity Value
- wms_piint_sqty float NULL Scrapped Quantity Value
- wms_piint_uom varchar(2) NULL Unit of Measure
- sa_user_key varchar(8) NULL User Key
- wms_piint_crdt datetime NULL Prod Issue Create Date Value
- in_item_key varchar(20) NULL Item Key
- im_pack_key varchar(6) NULL Pack Key
- wms_conthdr_key varchar(10) NULL Tracking Key
- in_lot_key varchar(25) NULL Lot Key
- wms_contdtl_puldt datetime NULL Container Pull Date/Time
- wms_piint_unique int (IDENTITY) NOTNULL Production Issue Unique Key
- wms_piint_control varchar(60) NULL Production Issue Control Key
- tranKey int NOTNULL Transaction Key
- wms_contdtl_key int NOTNULL Container Detail Key
- pm_matl_key int NOTNULL PM Material Key
- originTrack varchar(10) NULL Original Tracking Key
Column | Data Type | Nullable | Key Description |
---|
wms_pmint_tbl
- wms_pmint_error varchar(255) NULL Message Value===
- gl_cmp_key varchar(3) NULL Company Key
- sf_plant_key varchar(10) NULL Plant Key
- in_whs_key varchar(4) NULL Warehouse Key
- pm_shop_key varchar(10) NULL Order Key
- pm_shop_ordtp varchar(1) NULL Shop Order Type Key
- wms_pmint_bqty float NULL PM Batch Quantity Value
- wms_pmint_sqty float NULL PM Scrapped Quantity Value
- wms_pmint_uom varchar(2) NULL Unit of Measure Value
- sa_user_key varchar(8) NULL User Key
- wms_pmint_crdt datetime NULL PM Transaction Date/Time
- in_item_key varchar(20) NULL Item Key
- im_pack_key varchar(6) NULL Pack Key
- wms_conthdr_key varchar(10) NOTNULL Container Header Key
- wms_contdtl_key int NOTNULL Container Detail Key
- in_lot_key varchar(25) NULL In Lot Key
- wms_pmint_unique int (IDENTITY) NOTNULL PM Unique Key
- wms_pmint_control varchar(50) NULL PM Control Key
Column | Data Type | Nullable | Key Description |
---|
wms_pmintdtl_tbl
- gl_cmp_key varchar(2) NULL Company Key
- sf_plant_key varchar(4) NULL Plant Key
- in_whs_key varchar(4) NULL Warehouse Key
- pm_shop_key varchar(10) NULL Order Key
- wms_conthdr_key varchar(10) NULL Tracking Key
- wms_contdtl_key int NULL Container Detail Key
- wms_contcase_key varchar(60) NULL Containe Case Key
- in_sublot_key int NULL Sub Lot Key
- wms_contcase_ctwgt float NULL Case Catchweight Value
- wms_contcase_acwgt float NULL Case Actual Weight Value
- wms_contcase_prddt datetime NULL Case Production Date/Time
Column | Data Type | Nullable | Key Description |
---|
wms_point_tbl
- gl_cmp_key varchar(3) NULL Company Key
- so_brnch_key varchar(4) NULL Branch Key
- in_whs_key varchar(4) NULL Warehouse Key
- wms_conthdr_key varchar(10) NULL Tracking Key
- wms_contdtl_puldt datetime NULL Pull date
- po_hdr_key varchar(10) NULL Order Key
- in_item_key varchar(30) NULL Item Key
- im_pack_key varchar(6) NULL Pack Key
- wms_point_qty float NULL Quantity Received Value
- wms_point_uom varchar(6) NULL Unit Of Measure Value
- in_lot_key varchar(25) NULL Lot Key
- wms_point_bol varchar(20) NULL Bill of Lading Value
- wms_point_error varchar(255) NULL Message Value
- sa_user_key varchar(8) NULL User Key
- wms_point_crtdt datetime NULL Transaction Date/Time Value
- po_dtl_key smallint NULL Production Order Detail Key
- in_locn_key varchar(10) NULL Location Key
- wms_contdtl_key int NOTNULL Container Detail Key
- wms_point_control varchar(60) NULL Point Control
- wms_point_tbl_key int (IDENTITY) NOTNULL Point Table Key
Column | Data Type | Nullable | Key Description |
---|
wms_print_tbl
- gl_cmp_key varchar(3) NOTNULL Company Key
- in_whs_key varchar(4) NOTNULL Warehouse Key
- wms_print_key varchar(100) NOTNULL Printer Name Value
- wms_print_desc varchar(100) NULL Printer Description Value
- wms_print_def int NULL Printer Definition Value
- pr_rotate_key float NOTNULL Print Rotate Value
- wms_print_tbl_key int (IDENTITY) NOTNULL Print Table Key
Column | Data Type | Nullable | Key Description |
---|
wms_pultol_tbl
- gl_cmp_key varchar(3) NULL Company Key
- in_whs_key varchar(4) NULL Warehouse Key
- in_item_key varchar(30) NULL Item Key
- im_pack_key varchar(6) NULL Pack Key
- wms_pultol_tol int NULL Pull Date Tolerance Value
Column | Data Type | Nullable | Key Description |
---|
wms_recper_tbl
- gl_cmp_key varchar(3) NOTNULL Company Key
- in_whs_key varchar(4) NOTNULL Warehouse Key
- wms_recbgn_key datetime NULL Last ERP Reconciliation Date
Column | Data Type | Nullable | Key Description |
---|
wms_screen_tbl
- gl_cmp_key varchar(3) NOTNULL Company Key
- in_whs_key varchar(4) NOTNULL Warehouse Key
- wms_screen_key varchar(20) NOTNULL Screen Name Value
Column | Data Type | Nullable | Key Description |
---|
wms_sectmpl_tbl
- gl_cmp_key varchar(3) NOTNULL Company Key
- in_whs_key varchar(4) NOTNULL Warehouse Key
- wms_sectmpl_key varchar(20) NOTNULL Security Template Name Key
- wms_screen_key varchar(20) NOTNULL Screen Name Key
- wms_secure_mode int NULL Security Mode Value
Column | Data Type | Nullable | Key Description |
---|
wms_secure_tbl
- gl_cmp_key varchar(3) NULL Company Key
- in_whs_key varchar(4) NULL Warehouse Key
- sa_user_key varchar(8) NULL User Key
- wms_screen_key varchar(20) NULL Screen Name Key
- wms_secure_mode int NULL Security Mode Value
Column | Data Type | Nullable | Key Description |
---|
wms_shipins_tbl Table no longer
- gl_cmp_key varchar(3) NOTNULL Company Key
- in_whs_key varchar(4) NOTNULL Warehouse Key
- ar_ship_key varchar(10) NOTNULL AR Ship Key
- so_prod_key varchar(20) NOTNULL So Product Key
- in_instr_key text NOTNULL IN Instruction Key
Column | Data Type | Nullable | Key Description |
---|
wms_track_tbl
- gl_cmp_key varchar(3) NULL Company Key
- in_whs_key varchar(4) NULL Warehouse Key
- wms_track_key int NOTNULL Tracking Number Key
Column | Data Type | Nullable | Key Description |
---|
wms_user_tbl
- gl_cmp_key varchar(3) NULL Company Key
- in_whs_key varchar(4) NULL Warehouse Key
- sa_user_key varchar(8) NULL User Key
- wms_print_key varchar(100) NULL Default Printer Value
- wms_user_lang varchar(20) NULL User Language Key
- wms_user_tbl_key int (IDENTITY) NOTNULL User Table Key
Column | Data Type | Nullable | Key Description |
---|
wms_usercols_tbl
- gl_cmp_key varchar(2) NOTNULL Company Key
- in_whs_key varchar(4) NOTNULL Warehouse Key
- wms_table_key varchar(20) NOTNULL Table Key
- wms_col_key varchar(20) NOTNULL New Column Database Key
- wms_col_name varchar(20) NOTNULL Column Common Name
- wms_col_shortname varchar(5) NOTNULL Short Name Value
- wms_col_type varchar(10) NOTNULL Column Type Value
- wms_col_default varchar(26) NULL Column Default Value
- wms_col_min varchar(26) NULL Column Minimum Tolerance Value
- wms_col_max varchar(26) NULL Column Maximum Tolerance Value
- wms_col_req smallint NULL Column Required Value
- wms_item_type varchar(20) NULL Item Type Key
- wms_valid_sql text NULL SQL Text Value
- wms_ui_type smallint NOTNULL UI Parameter Type Key
- created_on datetime NOTNULL Created On Date/Time
- changed_on datetime NOTNULL Changed On Date/Time
- created_by varchar(8) NOTNULL User Key
- changed_by varchar(8) NOTNULL User Key
- lock_count int NOTNULL Lock Counter
Column | Data Type | Nullable | Key Description |
---|
wms_utcount_tbl
- gl_cmp_key varchar(2) NOTNULL Company Key
- in_whs_key varchar(4) NOTNULL Warehouse Key
- in_cycnt_key int NOTNULL Cycle Count Key
- in_item_key varchar(20) NOTNULL Item Key
- im_pack_key varchar(7) NOTNULL Pack Key
- in_locn_key varchar(10) NOTNULL Location Key
- en_lot_key varchar(25) NULL Lot Key
- sa_user_key varchar(8) NOTNULL User Key
- wms_utcycnt_crdt datetime NOTNULL Date/Time Stamp Value
- wms_utcycnt_qty float NOTNULL Reported Quantity Value
Column | Data Type | Nullable | Key Description |
---|
wms_vndpull_tbl
- gl_cmp_key varchar(3) NOTNULL Company Key
- in_whs_key varchar(4) NOTNULL Warehouse Key
- en_vend_key varchar(10) NOTNULL Vendor Key
- wms_vndpull_puldt int NULL Vendor Pull Date Value
Column | Data Type | Nullable | Key Description |
---|
wms_wtint_tbl
- gl_cmp_key varchar(3) NULL Company Key
- so_brnch_key varchar(4) NULL Branch Key
- wms_conthdr_key varchar(10) NULL Tracking Key
- wms_contdtl_puldt datetime NULL Item Pull Date
- wt_hdr_key varchar(10) NULL Warehouse Transfer Header Key
- in_item_key varchar(30) NULL Item Key
- im_pack_key varchar(6) NULL Packing Key
- wms_wtint_qty float NULL WT Quantity Value
- wms_wtint_uom varchar(6) NULL Unit Of Measur Value
- in_lot_key varchar(25) NULL Lot Key
- wms_wtint_bol varchar(20) NULL WT Bill of Lading Value
- wms_wtint_error varchar(255) NULL WT Error Message Value
- sa_user_key varchar(8) NULL User Key
- wms_wtint_crtdt datetime NULL WT Creation Date/Time
- wms_wtint_frwhs varchar(4) NULL WT From Warehouse Key
- wt_dtl_key smallint NOTNULL WT Detail Key
- in_whs_key varchar(4) NULL Warehouse Key
- in_locn_key varchar(10) NULL In Location Key
- wms_contdtl_key int NOTNULL Container Detail Key
- wms_wtint_control varchar(60) NULL ERP Control Key
- wms_wtint_key int (IDENTITY) NOTNULL WT Index Key
Column | Data Type | Nullable | Key Description |
---|
wms_zone_tbl
- gl_cmp_key varchar(3) NOTNULL Company Key
- in_whs_key varchar(4) NOTNULL Warehouse Key
- wms_zone_key varchar(10) NOTNULL Zone Key
- wms_bin_key varchar(15) NOTNULL Bin Key
Column | Data Type | Nullable | Key Description |
---|
wms_zonexf_tbl
- gl_cmp_key varchar(3) NOTNULL Company Key
- in_whs_key varchar(4) NOTNULL Warehouse Key
- wms_zone_key varchar(10) NOTNULL Zone Key
- in_item_key varchar(30) NOTNULL Item Key
- im_pack_key varchar(6) NOTNULL Pack Key
- wms_zone_pri int NOTNULL Zone Priority Value
- actionType smallint NOTNULL Action Type Value
Column | Data Type | Nullable | Key Description |
---|