Difference between revisions of "GX:Appendix C Whistle Database Tables"
From coolearthwiki
(16 intermediate revisions by 2 users not shown) | |||
Line 3: | Line 3: | ||
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 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 | + | The following is a list of all Whistle database tables. Each table is described in detail later in this appendix. |
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 14: | Line 14: | ||
| | | | ||
*wmASNHistory | *wmASNHistory | ||
+ | *wmAutoReceiveWhs | ||
*wmCountDetail | *wmCountDetail | ||
*wmCountMaster | *wmCountMaster | ||
Line 45: | Line 46: | ||
*wms_bindtlst_tbl | *wms_bindtlst_tbl | ||
*wms_case_tbl | *wms_case_tbl | ||
+ | *wms_comments_tbl | ||
*wms_contadj_tbl | *wms_contadj_tbl | ||
*wms_contcase_tbl | *wms_contcase_tbl | ||
Line 212: | Line 214: | ||
*Created On Date/Time Value | *Created On Date/Time Value | ||
*Created By Value | *Created By Value | ||
+ | |||
+ | |} | ||
+ | |||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | |||
+ | ===wmAutoReceiveWhs=== | ||
+ | | | ||
+ | *company | ||
+ | *warehouse | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
|} | |} | ||
Line 1,915: | Line 1,940: | ||
*wms_bin_col | *wms_bin_col | ||
*wms_bin_cychd | *wms_bin_cychd | ||
− | *wms_bin_hold | + | *wms_bin_hold |
+ | *can_mix_items | ||
+ | *not_on_picklist | ||
+ | *dont_trackvol | ||
| | | | ||
*varchar(3) | *varchar(3) | ||
Line 1,928: | Line 1,956: | ||
*int | *int | ||
*int | *int | ||
− | *int | + | *int |
+ | *int | ||
+ | *int | ||
+ | *int | ||
| | | | ||
*NOTNULL | *NOTNULL | ||
Line 1,942: | Line 1,973: | ||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
| | | | ||
*Company Key | *Company Key | ||
Line 1,955: | Line 1,989: | ||
*Bin Cycle Lock Value | *Bin Cycle Lock Value | ||
*Bin On Hold Value | *Bin On Hold Value | ||
+ | *Bin will accept a mix of items | ||
+ | *Don't show bin contents in picklist | ||
+ | *Don't calculate bin volume | ||
|} | |} | ||
Line 2,044: | Line 2,081: | ||
*wms_count_qty | *wms_count_qty | ||
*wms_count_var | *wms_count_var | ||
− | *lastCount | + | *lastCount |
+ | *not_on_picklist | ||
+ | *dont_trackvol | ||
| | | | ||
*varchar(3) | *varchar(3) | ||
Line 2,061: | Line 2,100: | ||
*varchar(25) | *varchar(25) | ||
*datetime | *datetime | ||
− | *varchar( | + | *varchar(20) |
*varchar(10) | *varchar(10) | ||
*datetime | *datetime | ||
Line 2,070: | Line 2,109: | ||
*float | *float | ||
*float | *float | ||
− | *datetime | + | *datetime |
+ | *int | ||
+ | *int | ||
| | | | ||
*NOTNULL | *NOTNULL | ||
Line 2,096: | Line 2,137: | ||
*NULL | *NULL | ||
*NULL | *NULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
| | | | ||
Line 2,123: | Line 2,166: | ||
*Cycle Count Variance Value | *Cycle Count Variance Value | ||
*Counted On Date/Time Value | *Counted On Date/Time Value | ||
+ | *Don't show bin contents in picklist | ||
+ | *Dont' calculate bin volume | ||
|} | |} | ||
Line 2,169: | Line 2,214: | ||
*User Key | *User Key | ||
*Lock Counter Value | *Lock Counter Value | ||
+ | |} | ||
+ | |||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | |||
+ | ===wms_comments_tbl=== | ||
+ | | | ||
+ | *company | ||
+ | *warehouse | ||
+ | *comments | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(60) | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Comment Text | ||
+ | |||
|} | |} | ||
Line 2,260: | Line 2,332: | ||
*lock_count | *lock_count | ||
*wms_contcase_stat | *wms_contcase_stat | ||
− | *wms_contcase_acwgt | + | *wms_contcase_acwgt |
+ | *lot | ||
+ | *allocation | ||
+ | *pieces | ||
+ | *lineKey | ||
| | | | ||
*varchar(2) | *varchar(2) | ||
Line 2,276: | Line 2,352: | ||
*int | *int | ||
*int | *int | ||
− | *float | + | *float |
+ | *varchar(25) | ||
+ | *varchar(25) | ||
+ | *int | ||
+ | *int | ||
| | | | ||
*NOTNULL | *NOTNULL | ||
Line 2,293: | Line 2,373: | ||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
| | | | ||
*Company Key | *Company Key | ||
Line 2,309: | Line 2,393: | ||
*Container Status Value | *Container Status Value | ||
*Container Actual Weight Value | *Container Actual Weight Value | ||
+ | *Lot Key | ||
+ | *Case Allocated Value | ||
+ | *Per box Piece Count | ||
+ | *Line Number | ||
|} | |} | ||
Line 2,367: | Line 2,455: | ||
*varchar(6) | *varchar(6) | ||
*varchar(25) | *varchar(25) | ||
− | *varchar( | + | *varchar(20) |
*float | *float | ||
*int | *int | ||
Line 3,174: | Line 3,262: | ||
*prePaidFreight | *prePaidFreight | ||
*status | *status | ||
− | *loadKey | + | *loadKey |
+ | *temp_recorder | ||
+ | *trl_temp_start | ||
+ | *set_trl_at | ||
+ | *set_trl_for_hrs | ||
+ | *trl_temp_for_trip | ||
+ | *pallets_in | ||
+ | *po_num | ||
| | | | ||
*varchar(2) | *varchar(2) | ||
Line 3,189: | Line 3,284: | ||
*varchar(10) | *varchar(10) | ||
*varchar(10) | *varchar(10) | ||
+ | *varchar(25) | ||
+ | *varchar(5) | ||
+ | *varchar(5) | ||
+ | *varchar(5) | ||
+ | *varchar(5) | ||
+ | *varchar(5) | ||
+ | *varchar(25) | ||
| | | | ||
*NOTNULL | *NOTNULL | ||
Line 3,202: | Line 3,304: | ||
*NULL | *NULL | ||
*NULL | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
*NULL | *NULL | ||
| | | | ||
Line 3,217: | Line 3,326: | ||
*Status Value | *Status Value | ||
*Load Key | *Load Key | ||
+ | *Thermometer ID Number | ||
+ | *Temp of Trailer at Start Of Loading Process | ||
+ | *Temp to Set Trailer At | ||
+ | *Number of Hours to Set Temp For | ||
+ | *Temp Trailer Should Maintain For Rest of Trip After set_trl_for_hrs Hours | ||
+ | *Number of Empty Pallets on Truck/Trailer When It Arrives | ||
+ | *PO Number | ||
|} | |} | ||
Line 3,436: | Line 3,552: | ||
*wms_contdtl_key | *wms_contdtl_key | ||
*pm_matl_key | *pm_matl_key | ||
− | *originTrack | + | *originTrack |
+ | *wms_line_key | ||
| | | | ||
*varchar(255) | *varchar(255) | ||
Line 3,460: | Line 3,577: | ||
*int | *int | ||
*int | *int | ||
− | *varchar(10) | + | *varchar(10) |
+ | *varchar(3) | ||
| | | | ||
*NULL | *NULL | ||
Line 3,484: | Line 3,602: | ||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
− | *NULL | + | *NULL |
+ | *NOTNULL | ||
| | | | ||
*Message Value | *Message Value | ||
Line 3,508: | Line 3,627: | ||
*Container Detail Key | *Container Detail Key | ||
*PM Material Key | *PM Material Key | ||
− | *Original Tracking Key | + | *Original Tracking Key |
+ | *Line Key | ||
|} | |} | ||
Line 3,536: | Line 3,656: | ||
*wms_contdtl_key | *wms_contdtl_key | ||
*in_lot_key | *in_lot_key | ||
− | *wms_pmint_control | + | *wms_pmint_control |
+ | *pieces | ||
| | | | ||
*varchar(255) | *varchar(255) | ||
Line 3,555: | Line 3,676: | ||
*varchar(25) | *varchar(25) | ||
*varchar(50) | *varchar(50) | ||
+ | *int | ||
| | | | ||
*NULL | *NULL | ||
Line 3,572: | Line 3,694: | ||
*NOTNULL | *NOTNULL | ||
*NULL | *NULL | ||
+ | *NULL | ||
*NULL | *NULL | ||
| | | | ||
Line 3,591: | Line 3,714: | ||
*In Lot Key | *In Lot Key | ||
*PM Control Key | *PM Control Key | ||
+ | *Per Box Piece Count | ||
|} | |} | ||
Line 3,847: | Line 3,971: | ||
===wms_rma_tbl=== | ===wms_rma_tbl=== | ||
| | | | ||
− | *gl_cmp_key | + | *gl_cmp_key |
− | *so_brnch_key | + | *so_brnch_key |
− | *so_rthdr_key | + | *so_rthdr_key |
− | *so_hdr_key | + | *so_hdr_key |
− | *so_resn_code | + | *so_resn_code |
− | *sa_user_key | + | *sa_user_key |
− | *wms_rma_crtdt | + | *wms_rma_crtdt |
| | | | ||
*varchar(2) | *varchar(2) | ||
Line 3,873: | Line 3,997: | ||
*Company Key | *Company Key | ||
*Branch Key | *Branch Key | ||
− | *Sales | + | *Sales Order Return Header Key |
− | *Sales | + | *Sales Order Header Key |
*Sales Order Reason Code | *Sales Order Reason Code | ||
*User Key | *User Key |
Latest revision as of 23:02, 3 February 2007
Contents
- 1 Whistle Database Tables
- 1.1 Whistle Tables and Definitions
- 1.1.1 wmASNHistory
- 1.1.2 wmAutoReceiveWhs
- 1.1.3 wmCountDetail
- 1.1.4 wmCountMaster
- 1.1.5 wmCountZones
- 1.1.6 wmCountedBins
- 1.1.7 wmCustomer
- 1.1.8 wmDemand
- 1.1.9 wmExtraInfoUserFlds
- 1.1.10 wmItemInstruct
- 1.1.11 wmLabelCrossRef
- 1.1.12 wmLabelElements
- 1.1.13 wmPickAllocation
- 1.1.14 wmPOReturnInt
- 1.1.15 wmPrintJobs
- 1.1.16 wmReceiptReturn
- 1.1.17 wmReclassHist
- 1.1.18 wmRuleContext
- 1.1.19 wmRuleContextLine
- 1.1.20 wmRuleMaster
- 1.1.21 wmScaleDefinition
- 1.1.22 wmStockMoveInt
- 1.1.23 wmTaskMaster
- 1.1.24 wmTestHistory
- 1.1.25 wmUomConv
- 1.1.26 wmUserPrefs
- 1.1.27 wmUserTask
- 1.1.28 wmWave
- 1.1.29 wms_autohd_tbl
- 1.1.30 wms_bin_tbl
- 1.1.31 wms_bincnt_tbl
- 1.1.32 wms_bindtlst_tbl
- 1.1.33 wms_case_tbl
- 1.1.34 wms_comments_tbl
- 1.1.35 wms_contadj_tbl
- 1.1.36 wms_contcase_tbl
- 1.1.37 wms_contdtl_tbl
- 1.1.38 wms_context_tbl
- 1.1.39 wms_conthdr_tbl
- 1.1.40 wms_contst_tbl
- 1.1.41 wms_contty_tbl
- 1.1.42 wms_contxf_tbl
- 1.1.43 wms_counter_tbl
- 1.1.44 wms_ctwght_tbl
- 1.1.45 wms_custpull_tbl
- 1.1.46 wms_cycnt_tbl
- 1.1.47 wms_erpint_tbl
- 1.1.48 wms_except_tbl
- 1.1.49 wms_group_tbl
- 1.1.50 wms_kit_tbl
- 1.1.51 wms_lhold_tbl
- 1.1.52 wms_load_tbl
- 1.1.53 wms_loadnm_tbl
- 1.1.54 wms_lothist_tbl
- 1.1.55 wms_outint_tbl
- 1.1.56 wms_piint_tbl
- 1.1.57 wms_pmint_tbl
- 1.1.58 wms_pmintdtl_tbl
- 1.1.59 wms_point_tbl
- 1.1.60 wms_print_tbl
- 1.1.61 wms_pultol_tbl
- 1.1.62 wms_recper_tbl
- 1.1.63 wms_rma_tbl
- 1.1.64 wms_screen_tbl
- 1.1.65 wms_sectmpl_tbl
- 1.1.66 wms_secure_tbl
- 1.1.67 wms_shipins_tbl Table no longer
- 1.1.68 wms_track_tbl
- 1.1.69 wms_user_tbl
- 1.1.70 wms_usercols_tbl
- 1.1.71 wms_utcount_tbl
- 1.1.72 wms_vndpull_tbl
- 1.1.73 wms_wtint_tbl
- 1.1.74 wms_zone_tbl
- 1.1.75 wms_zonexf_tbl
- 1.1 Whistle Tables and Definitions
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 later in this appendix.
Whistle Tables | Common Keys and DataTypes | Data Types | ||
---|---|---|---|---|
|
|
|
Whistle Tables and Definitions
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|