GX:Appendix C Whistle Database Tables: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
(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,178: | Line 2,223: | ||
|- | |- | ||
=== | ===wms_comments_tbl=== | ||
| | |||
*company | |||
*warehouse | |||
*comments | |||
| | | | ||
*gl_cmp_key | *varchar(2) | ||
*in_whs_key | *varchar(4) | ||
*varchar(60) | |||
| | |||
*NULL | |||
*NULL | |||
*NULL | |||
| | |||
*Company Key | |||
*Warehouse Key | |||
*Comment Text | |||
|} | |||
{| border="1" cellpadding="2" valign="top" halign="left" | |||
!Column | |||
!Data Type | |||
!Nullable | |||
!Key Description | |||
|- | |||
===wms_contadj_tbl=== | |||
| | |||
*gl_cmp_key | |||
*in_whs_key | |||
*wms_conthdr_key | *wms_conthdr_key | ||
*in_item_key | *in_item_key | ||
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 03:02, 4 February 2007
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
wmASNHistory
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmAutoReceiveWhs
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
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 |
---|---|---|---|
|
|
|
|
wmExtraInfoUserFlds
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 |
---|---|---|---|
|
|
|
|
wmPOReturnInt
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmPrintJobs
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmReceiptReturn
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wmReclassHist
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 |
---|---|---|---|
|
|
|
|
wmStockMoveInt
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_comments_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
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_load_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_loadnm_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_lothist_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_outint_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_piint_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_pmint_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_pmintdtl_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_point_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_print_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_pultol_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_recper_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_rma_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_screen_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_sectmpl_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_secure_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_shipins_tbl Table no longer
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_track_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_user_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_usercols_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_utcount_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_vndpull_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_wtint_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_zone_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|
wms_zonexf_tbl
Column | Data Type | Nullable | Key Description |
---|---|---|---|
|
|
|
|