GT:Appendix C Whistle Database Tables - Revision history

Cce: Add description to tables, remove no longer used schema.

2010-02-04T18:46:29Z

Add description to tables, remove no longer used schema.

2007-02-04T03:02:59Z

2007-02-04T03:01:53Z

2007-02-04T02:55:50Z

2007-02-04T02:54:14Z

‎wms_pmint_tbl

2007-02-04T02:53:04Z

‎wms_piint_tbl

2007-02-04T02:51:34Z

‎wms_contcase_tbl

2007-02-04T02:49:50Z

‎wms_load_tbl

2007-02-04T02:47:56Z

‎wms_load_tbl

2007-02-04T02:39:04Z

‎wms_contcase_tbl

@@ Line 224: / Line 224: @@
 |-
-===wmASNHistory===
+===wmAutoReceiveWhs===
+|
 *company

@@ Line 46: / Line 46: @@
 *wms_bindtlst_tbl
 *wms_case_tbl
 *wms_contadj_tbl
 *wms_contcase_tbl
@@ Line 213: / Line 214: @@
 *Created On Date/Time Value
 *Created By Value
 |}
@@ Line 2,190: / Line 2,214: @@
 *User Key
 *Lock Counter Value
 |}

@@ 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 following is a list of all Whistle database tables.  Each table is described in detail in later in this appendix.
+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"
@@ Line 14: / Line 14: @@
+|
 *wmASNHistory
 *wmCountDetail
 *wmCountMaster

@@ Line 3,604: / Line 3,604: @@
 *wms_contdtl_key
 *in_lot_key
 *wms_pmint_control
+|
 *varchar(255)
@@ Line 3,623: / Line 3,624: @@
 *varchar(25)
 *varchar(50)
+|
 *NULL
@@ Line 3,640: / Line 3,642: @@
 *NOTNULL
 *NULL
 *NULL
+|
@@ Line 3,659: / Line 3,662: @@
 *In Lot Key
 *PM Control Key
 |}

@@ Line 3,500: / Line 3,500: @@
 *wms_contdtl_key
 *pm_matl_key
 *originTrack
+|
 *varchar(255)
@@ Line 3,524: / Line 3,525: @@
 *int
 *int
 *varchar(10)
+|
 *NULL
@@ Line 3,548: / Line 3,550: @@
 *NOTNULL
 *NOTNULL
 *NULL
+|
 *Message Value
@@ Line 3,572: / Line 3,575: @@
 *Container Detail Key
 *PM Material Key
 *Original Tracking Key
 |}

@@ Line 2,343: / Line 2,343: @@
 *Lot Key
 *Case Allocated Value
-*Number of Pieces in Case
+*Per box Piece Count
 *Line Number
 |}

@@ Line 3,275: / Line 3,275: @@
 *Load Key
 *Thermometer ID Number
-*Temp of Trailer at Start
+*Temp of Trailer at Start Of Loading Process
-*Temp to Set Trailer at Start of Loading
+*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

@@ Line 3,210: / Line 3,210: @@
 *prePaidFreight
 *status
 *loadKey
+|
 *varchar(2)
@@ Line 3,225: / Line 3,232: @@
 *varchar(10)
 *varchar(10)
+|
 *NOTNULL
@@ Line 3,238: / Line 3,252: @@
 *NULL
 *NULL
 *NULL
+|
@@ Line 3,253: / Line 3,274: @@
 *Status Value
 *Load Key
 |}

@@ Line 2,342: / Line 2,342: @@
 *Container Actual Weight Value
 *Lot Key
-*Allocation
+*Case Allocated Value
-*Number of pieces
+*Number of Pieces in Case
-*Line number
+*Line Number
 |}