Difference between revisions of "36:Appendix C Whistle Database Tables"

From coolearthwiki
Jump to: navigation, search
(→‎Whistle Tables and Definitions)
(→‎Whistle Tables and Definitions)
Line 383: Line 383:
 
|-
 
|-
 
===wmDemand===
 
===wmDemand===
−
*company              varchar(2)     NOTNULL  Company Key
+
|
−
*warehouse            varchar(4)     NOTNULL  Warehouse Key
+
*company               
−
*orderKey            varchar(10)   NOTNULL  Order Key
+
*warehouse           
−
*orderType            int           NOTNULL  Order Type Key
+
*orderKey           
−
*demandLine           int            NOTNULL  Demand Line Key
+
*orderType           
−
*status              varchar(50)   NOTNULL  Status Key
+
*demandLine         
−
*item                varchar(20)   NOTNULL  Item Key
+
*status             
−
*pack                varchar(8)     NULL    Pack Key
+
*item               
−
*lot                  varchar(20)   NULL    Lot Key
+
*pack               
−
*demandQty            decimal(18,4) NOTNULL  Demand Quantity Value
+
*lot                 
−
*pickedQty            decimal(18,4) NOTNULL  Picked Quantity Value
+
*demandQty           
−
*uom                  varchar(2)     NOTNULL UOM Value
+
*pickedQty           
−
*createTime          datetime      NOTNULL  Created Date/Time Value
+
*uom                 
−
*activeUser          varchar(10)    NOTNULL  User Key
+
*createTime         
−
*lockCounter          int            NOTNULL  Lock Counter Key
+
*activeUser         
−
*minShelfLife        int            NOTNULL  Minimum Shelf Life Key
+
*lockCounter         
 +
*minShelfLife       
 +
|
 +
*varchar(2)  
 +
*varchar(4)  
 +
*varchar(10)  
 +
*int          
 +
*int            
 +
*varchar(50)  
 +
*varchar(20)  
 +
*varchar(8)  
 +
*varchar(20)  
 +
*decimal(18,4)  
 +
*decimal(18,4)  
 +
*varchar(2)  
 +
*datetime     
 +
*varchar(10) 
 +
*int         
 +
*int         
 +
|
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NULL 
 +
*NULL 
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
|
 +
*Company Key           
 +
*Warehouse Key         
 +
*Order Key             
 +
*Order Type Key         
 +
*Demand Line Key       
 +
*Status Key             
 +
*Item Key               
 +
*Pack Key               
 +
*Lot Key               
 +
*Demand Quantity Value 
 +
*Picked Quantity Value 
 +
*UOM Value              
 +
*Created Date/Time Value  
 +
*User Key              
 +
*Lock Counter Key      
 +
*Minimum Shelf Life Key
 +
|}
  
 
{| border="1" cellpadding="2" valign="top" halign="left"
 
{| border="1" cellpadding="2" valign="top" halign="left"
Line 407: Line 460:
 
|-
 
|-
 
===wmItemInstruct===
 
===wmItemInstruct===
−
*company             varchar(2)     NOTNULL  Company Key
+
|
−
*warehouse            varchar(4)     NOTNULL  Warehouse Key
+
*company      
−
*item                varchar(20)   NOTNULL Item Key
+
*warehouse   
−
*pack                varchar(8)     NOTNULL  Pack Key
+
*item         
−
*context              int           NOTNULL  Context Key
+
*pack         
−
*instruction          varchar(255)   NOTNULL Instruction Text Value
+
*context     
 +
*instruction 
 +
|
 +
*varchar(2)  
 +
*varchar(4)  
 +
*varchar(20)   
 +
*varchar(8)  
 +
*int        
 +
*varchar(255)  
 +
|
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
|
 +
*Company Key           
 +
*Warehouse Key         
 +
*Item Key             
 +
*Pack Key             
 +
*Context Key           
 +
*Instruction Text Value  
 +
|}
  
 
{| border="1" cellpadding="2" valign="top" halign="left"
 
{| border="1" cellpadding="2" valign="top" halign="left"
Line 421: Line 497:
 
|-
 
|-
 
===wmLabelCrossRef===
 
===wmLabelCrossRef===
−
*company             varchar(2)     NOTNULL  Company key
+
|
−
*branch              varchar(4)     NOTNULL  Branch Key
+
*company          
−
*deliverFrom          varchar(10)   NOTNULL Deliver From Key
+
*branch           
−
*labelKey            int            NOTNULL  Label Key
+
*deliverFrom     
 +
*labelKey         
 +
|
 +
*varchar(2)  
 +
*varchar(4)  
 +
*varchar(10)
 +
*int 
 +
|
 +
*NOTNULL    
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
|
 +
*Company key     
 +
*Branch Key     
 +
*Deliver From Key
 +
*Label Key      
 +
|}
  
 
{| border="1" cellpadding="2" valign="top" halign="left"
 
{| border="1" cellpadding="2" valign="top" halign="left"
Line 433: Line 526:
 
|-
 
|-
 
===wmLabelElements===
 
===wmLabelElements===
−
*labelKey            int            NOTNULL  Label Key
+
|
−
*elementKey          int            NOTNULL  Element Key
+
*labelKey             
−
*dataType            int            NOTNULL  Data Type Value
+
*elementKey           
−
*elementDescription  varchar(10)    NULL     Element Description Value
+
*dataType             
−
*position            int            NOTNULL  Position Value
+
*elementDescription   
−
*width                int            NOTNULL  Width Value
+
*position           
−
*uom                  varchar(2)    NULL    UOM Value
+
*width               
−
*decimalPosition      int            NOTNULL  Decimal Position Key
+
*uom                 
−
*mapsTo              varchar(20)    NULL    Maps To Key
+
*decimalPosition     
−
*required            int            NOTNULL  Required Key
+
*mapsTo             
−
*lastModifiedBy      varchar(10)    NOTNULL  User Key
+
*required           
−
*lastModifiedOn      datetime      NULL    Last Modified Date/Time Value
+
*lastModifiedBy     
 +
*lastModifiedOn     
 +
|
 +
*int       
 +
*int       
 +
*int       
 +
*varchar(10)  
 +
*int       
 +
*int       
 +
*varchar(2) 
 +
*int       
 +
*varchar(20)
 +
*int       
 +
*varchar(10)
 +
*datetime    
 +
|
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NULL  
 +
*NOTNULL
 +
*NOTNULL
 +
*NULL 
 +
*NOTNULL
 +
*NULL 
 +
*NOTNULL
 +
*NOTNULL
 +
*NULL 
 +
|
 +
*Label Key                   
 +
*Element Key                 
 +
*Data Type Value             
 +
*Element Description Value  
 +
*Position Value              
 +
*Width Value                
 +
*UOM Value                  
 +
*Decimal Position Key        
 +
*Maps To Key                
 +
*Required Key                
 +
*User Key                    
 +
*Last Modified Date/Time Value
 +
|}
  
 
{| border="1" cellpadding="2" valign="top" halign="left"
 
{| border="1" cellpadding="2" valign="top" halign="left"
Line 453: Line 587:
 
|-
 
|-
 
===wmPickAllocation===
 
===wmPickAllocation===
−
*pickAllocKey        int           NOTNULL  Pick Allocation Key===
+
|
−
*companyKey           varchar(10)   NOTNULL  Company Key
+
*pickAllocKey      
−
*warehouseKey        varchar(10)   NOTNULL  Warehouse Key
+
*companyKey         
−
*orderType            smallint       NOTNULL  Order Type Key
+
*warehouseKey       
−
*orderKey            varchar(30)   NOTNULL  Order Key
+
*orderType         
−
*orderLineKey        int           NOTNULL  Order Line Key
+
*orderKey           
−
*containerKey        varchar(10)   NOTNULL  Container Key
+
*orderLineKey       
−
*itemKey              varchar(20)   NOTNULL  Item Key
+
*containerKey       
−
*packKey              varchar(10)   NOTNULL  Pack Key
+
*itemKey           
−
*allocLotKey          varchar(30)   NOTNULL  Allocation Lot Key
+
*packKey           
−
*allocQuantity        float         NOTNULL  Allocation Quantity Value
+
*allocLotKey          
−
*allocUOM            varchar(2)     NOTNULL  Allocation UOM Value
+
*allocQuantity     
−
*status              smallint       NOTNULL  Status Key
+
*allocUOM            
−
*lastChangedBy        varchar(30)   NOTNULL  User Key
+
*status             
−
*lastChangeDate      datetime      NOTNULL  Changed on Date/Time Value
+
*lastChangedBy     
−
*createdBy            varchar(30)    NOTNULL  User Key
+
*lastChangeDate     
−
*creationDate        datetime      NOTNULL  Created On Date Value
+
*createdBy            
−
*lockCounter          int            NOTNULL  Lock Counter Value
+
*creationDate       
 +
*lockCounter       
 +
|
 +
*int       
 +
*varchar(10)
 +
*varchar(10)
 +
*smallint  
 +
*varchar(30)
 +
*int      
 +
*varchar(10)
 +
*varchar(20)
 +
*varchar(10)
 +
*varchar(30)
 +
*float    
 +
*varchar(2)  
 +
*smallint  
 +
*varchar(30)
 +
*datetime  
 +
*varchar(30)
 +
*datetime 
 +
*int        
 +
|
 +
*NOTNULL  
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
|
 +
*Pick Allocation Key
 +
*Company Key               
 +
*Warehouse Key             
 +
*Order Type Key           
 +
*Order Key                 
 +
*Order Line Key           
 +
*Container Key             
 +
*Item Key                 
 +
*Pack Key                 
 +
*Allocation Lot Key       
 +
*Allocation Quantity Value  
 +
*Allocation UOM Value     
 +
*Status Key               
 +
*User Key                 
 +
*Changed on Date/Time Value  
 +
*User Key                  
 +
*Created On Date Value    
 +
*Lock Counter Value        
 +
|}
  
 
{| border="1" cellpadding="2" valign="top" halign="left"
 
{| border="1" cellpadding="2" valign="top" halign="left"
Line 479: Line 672:
 
|-
 
|-
 
===wmPrintJobs===
 
===wmPrintJobs===
−
*company             varchar(2)     NOTNULL  Company Key
+
|
−
*warehouse            varchar(4)     NOTNULL  Warehouse Key
+
*company            
−
*track                varchar(10)   NOTNULL Tracking Key
+
*warehouse         
−
*numLabels            int           NOTNULL  Number of labels Value
+
*track             
−
*printDoc            varchar(255)   NULL    Print Document Value
+
*numLabels         
−
*printer              varchar(255)  NULL     Printer Value
+
*printDoc           
−
*prePrint             int           NOTNULL Pre print Value
+
*printer           
−
*printSequence1      varchar(10)    NULL    Print Sequence 1 Value
+
*prePrint           
−
*printSequence2      varchar(10)    NULL    Print Sequence 2 Value
+
*printSequence1     
−
*printSequence3      varchar(10)    NULL    Print Sequence 3 Value
+
*printSequence2     
 +
*printSequence3     
 +
|
 +
*varchar(2)  
 +
*varchar(4)  
 +
*varchar(10)   
 +
*int        
 +
*varchar(255)  
 +
*varchar(255)  
 +
*int         
 +
*varchar(10) 
 +
*varchar(10) 
 +
*varchar(10)
 +
|
 +
*NOTNULL 
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NULL    
 +
*NULL  
 +
*NOTNULL
 +
*NULL 
 +
*NULL 
 +
*NULL 
 +
|
 +
*Company Key              
 +
*Warehouse Key         
 +
*Tracking Key            
 +
*Number of labels Value  
 +
*Print Document Value   
 +
*Printer Value         
 +
*Pre print Value        
 +
*Print Sequence 1 Value
 +
*Print Sequence 2 Value
 +
*Print Sequence 3 Value
 +
|}
  
 
{| border="1" cellpadding="2" valign="top" halign="left"
 
{| border="1" cellpadding="2" valign="top" halign="left"
Line 497: Line 725:
 
|-
 
|-
 
===wmRuleContext===
 
===wmRuleContext===
−
*ruleContextKey      int            NOTNULL  Rule Context key===
+
|
−
*companyKey          varchar(10)   NOTNULL  Company Key
+
*ruleContextKey       
−
*warehouseKey        varchar(10)   NOTNULL  Warehouse Key
+
*companyKey           
−
*contextName          varchar(60)   NOTNULL  Context Name Value
+
*warehouseKey       
−
*contextType          smallint       NOTNULL  Context Type Value
+
*contextName         
−
*binKey              varchar(10)    NOTNULL  Bin Key
+
*contextType         
−
*lastChangedBy        varchar(30)    NOTNULL User Key
+
*binKey             
−
*lastChangeDate      datetime      NOTNULL  Changed on Date/Time Value
+
*lastChangedBy       
−
*createdBy            varchar(30)    NOTNULL  User Key
+
*lastChangeDate     
−
*creationDate        datetime      NOTNULL  Created on Date/Time Value
+
*createdBy           
−
*lockCounter          int            NOTNULL  Lock Counter
+
*creationDate       
 +
*lockCounter         
 +
|
 +
*int       
 +
*varchar(10)  
 +
*varchar(10)  
 +
*varchar(60)  
 +
*smallint  
 +
*varchar(10)  
 +
*varchar(30)
 +
*datetime    
 +
*varchar(30)  
 +
*datetime    
 +
*int                 
 +
|
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
|
 +
*Rule Context key===     
 +
*Company Key             
 +
*Warehouse Key           
 +
*Context Name Value       
 +
*Context Type Value       
 +
*Bin Key                 
 +
*User Key                
 +
*Changed on Date/Time Value
 +
*User Key                
 +
*Created on Date/Time Value
 +
*Lock Counter            
 +
|}
  
 
{| border="1" cellpadding="2" valign="top" halign="left"
 
{| border="1" cellpadding="2" valign="top" halign="left"

Revision as of 16:32, 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
  • wmCountDetail
  • wmCountMaster
  • wmCountZones
  • wmCountedBins
  • wmCustomer
  • wmDemand
  • wmItemInstruct
  • wmLabelCrossRef
  • wmLabelElements
  • wmPickAllocation
  • wmPrintJobs
  • wmRuleContext
  • wmRuleContextLine
  • wmRuleMaster
  • wmScaleDefinition
  • wmTaskMaster
  • wmTestHistory
  • wmUomConv
  • wmUserPrefs
  • wmUserTask
  • wmWave
  • wms_autohd_tbl
  • wms_bin_tbl
  • wms_bincnt_tbl
  • wms_bindtlst_tbl
  • wms_case_tbl
  • wms_contadj_tbl
  • wms_contcase_tbl
  • wms_contdtl_tbl
  • wms_context_tbl
  • wms_conthdr_tbl
  • wms_contst_tbl
  • wms_contty_tbl
  • wms_contxf_tbl
  • wms_counter_tbl
  • wms_ctwght_tbl
  • wms_custpull_tbl
  • wms_cycnt_tbl
  • wms_erpint_tbl
  • wms_except_tbl
  • wms_group_tbl
  • wms_kit_tbl
  • wms_lhold_tbl
  • wms_load_tbl
  • wms_loadnm_tbl
  • wms_lothist_tbl
  • wms_outint_tbl
  • wms_piint_tbl
  • wms_pmint_tbl
  • wms_pmintdtl_tbl
  • wms_point_tbl
  • wms_print_tbl
  • wms_pultol_tbl
  • wms_recper_tbl
  • wms_screen_tbl
  • wms_sectmpl_tbl
  • wms_secure_tbl
  • wms_shipins_tbl
  • wms_track_tbl
  • wms_user_tbl
  • wms_usercols_tbl
  • wms_utcount_tbl
  • wms_vndpull_tbl
  • wms_wtint_tbl
  • wms_zone_tbl
  • Bin Key varchar(15)
  • Branch Key varchar(4)
  • Company Key varchar(2)
  • Container Detail Key int
  • Container Header Key varchar(10)
  • Count Key int
  • Item Key varchar(30)
  • Location Key varchar(10)
  • Lot Key varchar(25)
  • Order Key varchar(10)
  • Pack Key varchar(10)
  • Tracking Key varchar(10)
  • User Key varchar(30)
  • Warehouse Key varchar(4)
  • Zone Key varchar(10)
  • datetime
  • decimal(18,4)
  • float
  • int
  • int (IDENTITY)
  • smallint
  • text
  • varchar(1)
  • varchar(10)
  • varchar(100)
  • varchar(128)
  • varchar(13)
  • varchar(15)
  • varchar(2)
  • varchar(20)
  • varchar(25)
  • varchar(255)
  • varchar(256)
  • varchar(45)
  • varchar(5)
  • varchar(30)
  • varchar(4)
  • varchar(40)
  • varchar(50)
  • varchar(6)
  • varchar(60)
  • varchar(64)
  • varchar(7)
  • varchar(8)

Whistle Tables and Definitions

wmCountDetail

Column Data Type Nullable Key Description
  • company
  • warehouse
  • countKey
  • containerHeader
  • containerDetail
  • bin
  • item
  • pack
  • lot
  • originalQty
  • countedQty
  • countedCost
  • variance
  • varianceCost
  • countedBy
  • countedOn
  • updateCounter
  • varchar(2)
  • varchar(4)
  • int
  • varchar(10)
  • int
  • varchar(10)
  • varchar(10)
  • varchar(10)
  • varchar(10)
  • decimal(18,4)
  • decimal(18,4)
  • decimal(18,4)
  • decimal(18,4)
  • decimal(18,4)
  • varchar(10)
  • datetime
  • int
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • Company Key
  • Warehouse Key
  • Count Key
  • Container Header Key
  • Container Detail Key
  • Bin Key
  • Item Key
  • Pack Key
  • Lot Key
  • Original Quantity Value
  • Counted Quantity Value
  • Counted Cost Value
  • Variance Value
  • Variance Cost Value
  • User Key
  • Counted On Date/Time Value
  • Update Counter Key

wmCountMaster

Column Data Type Nullable Key Description
  • company
  • warehouse
  • countKey
  • countStatus
  • createdBy
  • createdOn
  • completedBy
  • completedOn
  • countedCost
  • netVarianceCost
  • numCounts
  • numErrors
  • varchar(2)
  • varchar(4)
  • int
  • varchar(10)
  • varchar(10)
  • datetime
  • varchar(10)
  • datetime
  • decimal(18,4)
  • decimal(18,4)
  • int
  • int
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NULL
  • NULL
  • NULL
  • NULL
  • NULL
  • NULL
  • Company Key
  • Warehouse Key
  • Count Key
  • Count Status Key
  • User Key
  • Counted On Date/Time Value
  • User Key
  • Completed On Date/Time Value
  • Counted Cost Value
  • Net Variance Cost
  • Number of Counts Value
  • Number of Errors Value

wmCountZones

Column Data Type Nullable Key Description
  • company
  • warehouse
  • countZone
  • bin
  • varchar(2)
  • varchar(4)
  • varchar(10)
  • varchar(10)
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • Company Key
  • Warehouse Key
  • Count Zone Key
  • Bin Key

wmCountedBins

Column Data Type Nullable Key Description
  • company
  • warehouse
  • countKey
  • bin
  • errors
  • countedBy
  • countedOn
  • updateCounter
  • varchar(2)
  • varchar(4)
  • int
  • varchar(10)
  • int
  • varchar(10)
  • datetime
  • int
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • Company Key
  • Warehouse Key
  • Count Key
  • Bin Key
  • Errors Key
  • User Key
  • Counted On Date/Time Value
  • Update Counter Key

wmCustomer

Column Data Type Nullable Key Description
  • company
  • warehouse
  • customerKey
  • showCustPartNumber
  • varchar(2)
  • varchar(4)
  • varchar(10)
  • int
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • Company Key
  • Warehouse Key
  • Customer Key
  • Show Customer Part Number Key

wmDemand

Column Data Type Nullable Key Description
  • company
  • warehouse
  • orderKey
  • orderType
  • demandLine
  • status
  • item
  • pack
  • lot
  • demandQty
  • pickedQty
  • uom
  • createTime
  • activeUser
  • lockCounter
  • minShelfLife
  • varchar(2)
  • varchar(4)
  • varchar(10)
  • int
  • int
  • varchar(50)
  • varchar(20)
  • varchar(8)
  • varchar(20)
  • decimal(18,4)
  • decimal(18,4)
  • varchar(2)
  • datetime
  • varchar(10)
  • int
  • int
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NULL
  • NULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • Company Key
  • Warehouse Key
  • Order Key
  • Order Type Key
  • Demand Line Key
  • Status Key
  • Item Key
  • Pack Key
  • Lot Key
  • Demand Quantity Value
  • Picked Quantity Value
  • UOM Value
  • Created Date/Time Value
  • User Key
  • Lock Counter Key
  • Minimum Shelf Life Key

wmItemInstruct

Column Data Type Nullable Key Description
  • company
  • warehouse
  • item
  • pack
  • context
  • instruction
  • varchar(2)
  • varchar(4)
  • varchar(20)
  • varchar(8)
  • int
  • varchar(255)
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • Company Key
  • Warehouse Key
  • Item Key
  • Pack Key
  • Context Key
  • Instruction Text Value

wmLabelCrossRef

Column Data Type Nullable Key Description
  • company
  • branch
  • deliverFrom
  • labelKey
  • varchar(2)
  • varchar(4)
  • varchar(10)
  • int
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • Company key
  • Branch Key
  • Deliver From Key
  • Label Key

wmLabelElements

Column Data Type Nullable Key Description
  • labelKey
  • elementKey
  • dataType
  • elementDescription
  • position
  • width
  • uom
  • decimalPosition
  • mapsTo
  • required
  • lastModifiedBy
  • lastModifiedOn
  • int
  • int
  • int
  • varchar(10)
  • int
  • int
  • varchar(2)
  • int
  • varchar(20)
  • int
  • varchar(10)
  • datetime
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NULL
  • NOTNULL
  • NOTNULL
  • NULL
  • NOTNULL
  • NULL
  • NOTNULL
  • NOTNULL
  • NULL
  • Label Key
  • Element Key
  • Data Type Value
  • Element Description Value
  • Position Value
  • Width Value
  • UOM Value
  • Decimal Position Key
  • Maps To Key
  • Required Key
  • User Key
  • Last Modified Date/Time Value

wmPickAllocation

Column Data Type Nullable Key Description
  • pickAllocKey
  • companyKey
  • warehouseKey
  • orderType
  • orderKey
  • orderLineKey
  • containerKey
  • itemKey
  • packKey
  • allocLotKey
  • allocQuantity
  • allocUOM
  • status
  • lastChangedBy
  • lastChangeDate
  • createdBy
  • creationDate
  • lockCounter
  • int
  • varchar(10)
  • varchar(10)
  • smallint
  • varchar(30)
  • int
  • varchar(10)
  • varchar(20)
  • varchar(10)
  • varchar(30)
  • float
  • varchar(2)
  • smallint
  • varchar(30)
  • datetime
  • varchar(30)
  • datetime
  • int
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • Pick Allocation Key
  • Company Key
  • Warehouse Key
  • Order Type Key
  • Order Key
  • Order Line Key
  • Container Key
  • Item Key
  • Pack Key
  • Allocation Lot Key
  • Allocation Quantity Value
  • Allocation UOM Value
  • Status Key
  • User Key
  • Changed on Date/Time Value
  • User Key
  • Created On Date Value
  • Lock Counter Value

wmPrintJobs

Column Data Type Nullable Key Description
  • company
  • warehouse
  • track
  • numLabels
  • printDoc
  • printer
  • prePrint
  • printSequence1
  • printSequence2
  • printSequence3
  • varchar(2)
  • varchar(4)
  • varchar(10)
  • int
  • varchar(255)
  • varchar(255)
  • int
  • varchar(10)
  • varchar(10)
  • varchar(10)
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NULL
  • NULL
  • NOTNULL
  • NULL
  • NULL
  • NULL
  • Company Key
  • Warehouse Key
  • Tracking Key
  • Number of labels Value
  • Print Document Value
  • Printer Value
  • Pre print Value
  • Print Sequence 1 Value
  • Print Sequence 2 Value
  • Print Sequence 3 Value

wmRuleContext

Column Data Type Nullable Key Description
  • ruleContextKey
  • companyKey
  • warehouseKey
  • contextName
  • contextType
  • binKey
  • lastChangedBy
  • lastChangeDate
  • createdBy
  • creationDate
  • lockCounter
  • int
  • varchar(10)
  • varchar(10)
  • varchar(60)
  • smallint
  • varchar(10)
  • varchar(30)
  • datetime
  • varchar(30)
  • datetime
  • int
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • NOTNULL
  • Rule Context key===
  • Company Key
  • Warehouse Key
  • Context Name Value
  • Context Type Value
  • Bin Key
  • User Key
  • Changed on Date/Time Value
  • User Key
  • Created on Date/Time Value
  • Lock Counter

wmRuleContextLine

  • ruleContextLineKey int NOTNULL Rule Context Line Key
  • ruleContextKey int NOTNULL Rule Context Key
  • rulePriority smallint NOTNULL Rule Priority Value
  • ruleMasterKey int NOTNULL Rule Master Key
  • sortOrder smallint NULL Sort Order Value
  • lastChangedBy varchar(30) NOTNULL User Key
  • lastChangeDate datetime NOTNULL Changed on Date
  • createdBy varchar(30) NOTNULL User Key
  • creationDate datetime NOTNULL Created on Date
  • lockCounter int NOTNULL Lock Counter Value
Column Data Type Nullable Key Description

wmRuleMaster

  • ruleMasterKey int NOTNULL Rule Master Key
  • ruleName varchar(60) NOTNULL Rule Name Value
  • ruleTable varchar(30) NULL Rule Table Value
  • ruleColumn varchar(30) NULL Rule Column Value
  • ruleIdentifier varchar(30) NULL Rule ID Value
  • lastChangedBy varchar(30) NOTNULL User Key
  • lastChangeDate datetime NOTNULL Changed on Date Value
  • createdBy varchar(30) NOTNULL User Key
  • creationDate datetime NOTNULL Created on Date Value
  • lockCounter int NOTNULL Lock Counter Value
Column Data Type Nullable Key Description

wmScaleDefinition

  • company varchar(2) NOTNULL Company Key
  • warehouse varchar(4) NOTNULL Warehouse Key
  • scaleKey varchar(60) NOTNULL Scale Key
  • scaleDescription varchar(128) NULL Scale Description Value
  • scaleAddress varchar(128) NOTNULL Scale Address Value
Column Data Type Nullable Key Description

wmTaskMaster

  • taskMasterKey int NOTNULL Task Master Key
  • taskType varchar(20) NOTNULL Task Type Value
  • taskName varchar(30) NOTNULL Task Name Value
  • refLabel1 varchar(30) NULL Reference Label 1
  • refLabel2 varchar(30) NULL Reference Label 2
  • refLabel3 varchar(30) NULL Reference Label 3
  • lastChangedBy varchar(30) NOTNULL User Key
  • lastChangeDate datetime NOTNULL Changed On Date/Time Value
  • createdBy varchar(30) NOTNULL User Key
  • creationDate datetime NOTNULL Created On Date/Time Value
  • lockCounter int NOTNULL Lock Counter Value
Column Data Type Nullable Key Description

wmTestHistory

  • testKey varchar(10) NOTNULL Test Key
  • effectiveDate datetime NOTNULL Effective Date/Time Value
  • sequence int NOTNULL Sequence Value
  • item varchar(20) NOTNULL Item Key
  • pack varchar(10) NOTNULL Pack Key
  • lot varchar(30) NOTNULL Lot Key
  • sampleID varchar(20) NOTNULL Sample ID Value
  • status varchar(20) NOTNULL Status Value
  • result varchar(60) NOTNULL Result Value
  • measured decimal(18,4) NULL Measured value
  • measuredUOM varchar(2) NULL Unit Of Measure Value
  • comments varchar(255) NULL Comment Value
  • transactionTime datetime NOTNULL Transaction Date/Time Value
  • tranactionUser varchar(10) NULL User Key
Column Data Type Nullable Key Description

wmUomConv

  • gl_cmp_key varchar(2) NOTNULL Company Key
  • in_whs_key varchar(4) NOTNULL Warehouse Key
  • in_item_key varchar(20) NOTNULL Item Key
  • im_pack_key varchar(6) NOTNULL Pack Key
  • uom_from varchar(10) NOTNULL UOM From Key
  • uom_to varchar(10) NOTNULL UOM To Key
  • factor float NOTNULL Factor Key
Column Data Type Nullable Key Description

wmUserPrefs

  • gl_cmp_key varchar(2) NOTNULL Company Key
  • in_whs_key varchar(4) NOTNULL Warehouse Key
  • user_key varchar(8) NOTNULL User Key
  • pref_name varchar(64) NOTNULL Preference Name Value
  • pref_value varchar(256) NULL Preference Value
  • created_by varchar(8) NOTNULL User Key
  • created_on datetime NOTNULL Created on Date/Time Value
  • changed_by varchar(8) NOTNULL User Key
  • changed_on datetime NOTNULL Changed On Date/Time Value
  • lock_counter int NOTNULL Lock Counter Value
Column Data Type Nullable Key Description

wmUserTask

  • userTaskKey int NOTNULL User Task Key
  • userKey varchar(8) NOTNULL User Key===
  • companyKey varchar(10) NOTNULL Company Key
  • warehouseKey varchar(10) NOTNULL Warehouse Key
  • taskMasterKey int NOTNULL Task Master Key
  • taskNote varchar(255) NOTNULL Task Note Value
  • expectedStart datetime NULL Expected Start Date/Time Value
  • expectedFinish datetime NULL Expected End Date/Time Value
  • actualStart datetime NULL Actual Start Date/Time Value
  • actualFinish datetime NULL Actual End Date/Time Value
  • priority smallint NOTNULL Priority Value
  • status smallint NOTNULL Status Value
  • refValue1 varchar(30) NULL Reference Value 1
  • refValue2 varchar(30) NULL Reference Value 2
  • refValue3 varchar(30) NULL Reference Value 3
  • assignedBy varchar(10) NOTNULL User Key
  • lastChangedBy varchar(30) NOTNULL User Key
  • lastChangeDate datetime NOTNULL Changed on Date/Time Value
  • createdBy varchar(30) NOTNULL User Key
  • creationDate datetime NOTNULL Created on Date/Time Value
  • lockCounter int NOTNULL Lock Counter Value
Column Data Type Nullable Key Description

wmWave

  • company varchar(2) NOTNULL Company Key
  • warehouse varchar(4) NOTNULL Warehouse Key
  • waveKey varchar(10) NOTNULL Wave Key
  • createdOn datetime NULL Created on Date/Time Value
  • createdBy varchar(10) NOTNULL User Key
Column Data Type Nullable Key Description

wms_autohd_tbl

  • gl_cmp_key varchar(2) NOTNULL Company Key
  • in_whs_key varchar(4) NOTNULL Warehouse Key
  • in_item_key varchar(30) NOTNULL Item Key
  • im_pack_key varchar(6) NOTNULL Pack Key
  • wms_autohd_hrs int NULL Autohold Length Hours Value
  • context varchar(10) NOTNULL Context Value
Column Data Type Nullable Key Description

wms_bin_tbl

  • gl_cmp_key varchar(3) NOTNULL Company Key
  • in_whs_key varchar(4) NOTNULL Warehouse Key
  • in_locn_key varchar(10) NULL Location Key
  • wms_bin_key varchar(15) NOTNULL Bin Key
  • wms_bin_depth float NULL Bin Depth Value
  • wms_bin_height float NULL Bin Height Value
  • wms_bin_width float NULL Bin Width Value
  • wms_bin_type varchar(10) NULL Bin Type Value
  • wms_bin_row int NULL Bin row # (x) Value
  • wms_bin_col int NULL Bin column # (y) Value
  • wms_bin_cychd int NOTNULL Bin Cycle Lock Value
  • wms_bin_hold int NOTNULL Bin On Hold Value
  • wms_bin_tbl_key int (IDENTITY) NOTNULL Bin Table Key
Column Data Type Nullable Key Description

wms_bincnt_tbl

  • gl_cmp_key varchar(3) NULL Company Key
  • in_whs_key varchar(4) NULL Warehouse Key
  • in_cycnt_key int NULL Cycle count key
  • wms_bin_key varchar(15) NULL Bin Key
  • wms_bincnt_stat int NULL Bin count status Value
  • sa_user_key varchar(8) NULL User Key
  • wms_bincnt_crtdt datetime NULL Counted on Date/Time Value
  • in_locn_key varchar(10) NULL Location Key
  • in_item_key varchar(10) NULL Item Key
  • im_pack_key varchar(10) NULL Pack Key
Column Data Type Nullable Key Description

wms_bindtlst_tbl

  • gl_cmp_key varchar(3) NOTNULL Company Key
  • in_whs_key varchar(4) NOTNULL Warehouse Key
  • wms_bin_key varchar(13) NOTNULL Bin Key
  • wms_zone_key varchar(10) NULL Zone Key
  • wms_conthdr_key varchar(10) NOTNULL Tracking Key
  • wms_bin_depth float NULL Bin Depth Value
  • wms_bin_height float NULL Bin Height Value
  • wms_bin_width float NULL Bin Width Value
  • wms_bin_vol float NULL Bin Volume Value
  • wms_binst_rem float NULL Volume Remaining Value
  • wms_binst_pc int NULL Number Of Pallets Value
  • in_item_key varchar(30) NOTNULL Item Key
  • im_pack_key varchar(6) NOTNULL Pack Key
  • in_lot_key varchar(25) NOTNULL Lot Key
  • wms_contdtl_puldt datetime NOTNULL Pull Date/Time Value
  • wms_contdtl_alloc varchar(10) NULL Pallet Allocation Value
  • wms_contst_key varchar(10) NULL Tracking Key
  • wms_conthdr_lstmv datetime NULL Last Moved Date/Time Value
  • wms_contdtl_qty float NULL Detail Quantity
  • wms_bin_type varchar(10) NULL Bin Type
  • wms_contdtl_key int NOTNULL Container Detail Key
  • wms_count_key int NULL Count Key
  • wms_count_qty float NULL Cycle Count Quantity Value
  • wms_count_var float NULL Cycle Count Variance Value
  • wms_bindtlst_tbl_key int (IDENTITY) NOTNULL Bin Detail List Table Key
  • lastCount datetime NOTNULL Counted On Date/Time Value
Column Data Type Nullable Key Description

wms_case_tbl

  • gl_cmp_key varchar(2) NOTNULL Company Key
  • in_whs_key varchar(4) NOTNULL Warehouse Key
  • wms_case_num int NOTNULL Case Number Value
  • created_on datetime NOTNULL Created on Date
  • changed_on datetime NOTNULL Changed on Date
  • created_by varchar(8) NOTNULL User Key
  • changed_by varchar(8) NOTNULL User Key
  • lock_count int NOTNULL Lock Counter Value
Column Data Type Nullable Key Description

wms_contadj_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
  • in_item_key varchar(30) NULL Item Key
  • im_pack_key varchar(6) NULL Pack Key
  • wms_contadj_qty float NULL Adjusted Quantity Value
  • en_resn_key varchar(10) NULL Reason For Adjustment Value
  • sa_user_key varchar(10) NULL User Key
  • wms_contadj_date datetime NULL Transaction Date/Time Value
  • wms_contadj_cmt varchar(255) NULL Container Adj Comment Value
  • wms_contdtl_key int NOTNULL Container Detail Key
  • wms_contcase_key varchar(60) NULL Container Case Key
  • wms_contadj_cntrl varchar(60) NULL Container Adj Control Num Value
Column Data Type Nullable Key Description

wms_contcase_tbl

  • gl_cmp_key varchar(2) NOTNULL Company Key
  • in_whs_key varchar(4) NOTNULL Warehouse Key
  • wms_conthdr_key varchar(10) NULL Tracking Key
  • wms_contdtl_key int NULL Tracking Detail Key
  • wms_contcase_key varchar(60) NOTNULL Tracking Case Key
  • wms_contcase_ctwgt float NULL Tracking Catch Weight Value
  • in_sublot_key int NULL Adage SubLot Key
  • wms_contcase_prddt datetime NOTNULL Case Production Date Value
  • created_on datetime NOTNULL Created On Date Value
  • changed_on datetime NOTNULL Changed On Date Value
  • created_by varchar(8) NOTNULL User Key
  • changed_by varchar(8) NOTNULL User Key
  • lock_count int NOTNULL Lock Count Value
  • wms_contcase_stat int NOTNULL Container Status Value
  • wms_contcase_acwgt float NOTNULL Container Actual Weight Value
Column Data Type Nullable Key Description

wms_contdtl_tbl

  • gl_cmp_key varchar(3) NOTNULL Company Key
  • in_whs_key varchar(4) NOTNULL Warehouse Key
  • wms_conthdr_key varchar(10) NOTNULL Tracking Key
  • in_item_key varchar(30) NULL Item Key
  • im_pack_key varchar(6) NULL Pack Key
  • so_prod_key varchar(20) NULL Product # (UPC code)
  • in_desc varchar(60) NULL Item Description Value
  • wms_contdtl_prddt datetime NULL Production Date/Time Value
  • wms_contdtl_puldt datetime NOTNULL Pull Date Value
  • wms_contst_key varchar(10) NULL Container Status Key
  • wms_contdtl_qty float NULL Item Quantity Value
  • wms_contdtl_uom varchar(6) NULL Unit Of Measure Value
  • in_lot_key varchar(25) NOTNULL Lot Key
  • wms_contdtl_alloc varchar(10) NULL Pallet Allocated Value
  • wms_contdtl_vol float NULL Item Volume Value
  • wms_contdtl_key int NOTNULL Container Detail Key
  • wms_contdtl_ctwgt float NULL Container Detail Catch Weight
  • wms_user_paramVC1 varchar(255) NULL User defined Parameter #1
  • wms_user_paramVC2 varchar(255) NULL User defined Parameter #2
  • wms_user_paramVC3 varchar(255) NULL User defined Parameter #3
  • wms_user_paramVC4 varchar(255) NULL User defined Parameter #4
  • wms_user_paramVC5 varchar(255) NULL User defined Parameter #5
  • wms_user_paramVC6 varchar(255) NULL User defined Parameter #6
  • wms_user_paramVC7 varchar(255) NULL User defined Parameter #7
  • wms_user_paramVC8 varchar(255) NULL User defined Parameter #8
  • wms_user_paramVC9 varchar(255) NULL User defined Parameter #9
  • wms_user_paramVC10 varchar(255) NULL User defined Parameter #10
  • wms_user_paramF1 float NULL User defined Parameter F1
  • wms_user_paramF2 float NULL User defined Parameter F2
  • wms_user_paramF3 float NULL User defined Parameter F3
  • wms_user_paramF4 float NULL User defined Parameter F4
  • wms_user_paramF5 float NULL User defined Parameter F5
  • wms_contdtl_crtdt datetime NULL Creation Date/Time Value
Column Data Type Nullable Key Description

wms_context_tbl

  • gl_cmp_key varchar(2) NOTNULL Company Key
  • in_whs_key varchar(4) NOTNULL Warehouse Key
  • wms_conthdr_key varchar(10) NOTNULL Tracking Key
  • wms_context_variety varchar(10) NULL Context Variety Value
  • wms_context_linemtch varchar(10) NULL Context Line Match Value
  • wms_context_idfield varchar(4) NULL Context ID Field Value
  • created_on datetime NOTNULL Created on Date/Time Value
  • changed_on datetime NOTNULL Changed on Date/Time Value
  • created_by varchar(8) NOTNULL User Key
  • changed_by varchar(8) NOTNULL User Key
  • lock_count int NOTNULL Lock Count Value
Column Data Type Nullable Key Description

wms_conthdr_tbl

  • gl_cmp_key varchar(3) NOTNULL Company Key
  • in_whs_key varchar(4) NOTNULL Warehouse Key
  • wms_conthdr_key varchar(10) NOTNULL Tracking Key
  • wms_contst_key varchar(10) NULL Container Status Value
  • in_locn_key varchar(10) NULL Location Key
  • wms_bin_key varchar(15) NULL Bin Key
  • wms_conthdr_lstmv datetime NULL Last Moved Date/Time Value
  • wms_contty_key varchar(10) NULL Container Type
  • wms_conthdr_lstdt datetime NULL Container Last Changed Date Value
  • sa_user_key varchar(8) NULL User Key
  • wms_contst_reldt datetime NULL Release Date/Time
  • wms_group_key int NULL Group Key
  • wms_conthdr_vol float NULL Container Volume Value
  • wms_conthdr_unique int (IDENTITY) NOTNULL Container Header Unique Key
  • lockCounter int NULL Lock Counter Value
Column Data Type Nullable Key Description

wms_contst_tbl

  • gl_cmp_key varchar(3) NOTNULL Company Key
  • in_whs_key varchar(4) NOTNULL Warehouse Key
  • wms_contst_key varchar(10) NOTNULL Container Status Value
  • wms_contst_desc varchar(60) NULL Container Description Value
  • wms_contst_type varchar(10) NULL Container Type Value
  • wms_contst_reldt varchar(8) NULL Container Release Date Value
  • wms_contst_relby varchar(8) NULL Container Release By Date Value
Column Data Type Nullable Key Description

wms_contty_tbl

  • gl_cmp_key varchar(3) NOTNULL Company Key
  • in_whs_key varchar(4) NOTNULL Warehouse Key
  • wms_contty_key varchar(10) NOTNULL Container Type Value
  • wms_contty_height float NULL Container Height Value
  • wms_contty_depth float NULL Container Depth Value
  • wms_contty_width float NULL Container Width Value
  • wms_contty_lay int NULL Number Of Layers Value
  • wms_contty_case int NULL Number Of Cases Value
  • wms_contty_uom varchar(6) NULL Unit Of Measure Value
  • wms_contty_dftrtype varchar(50) NULL Type Of Transaction Value
Column Data Type Nullable Key Description

wms_contxf_tbl

  • gl_cmp_key varchar(3) NOTNULL Company Key
  • in_whs_key varchar(4) NOTNULL Warehouse Key
  • wms_contty_key varchar(10) NOTNULL Container Type Value
  • in_item_key varchar(30) NOTNULL Item Key
  • im_pack_key varchar(6) NOTNULL Pack Key
  • wms_desc varchar(60) NULL Item Description Value
  • so_prod_key varchar(20) NULL Adage Sales Order Production K
  • wms_active_qty float NULL Container Active Quantity
  • wms_hold_qty float NULL Container Hold Quantity
  • wms_contxf_key int (IDENTITY) NOTNULL Container Cross Reference Key
  • toleranceOver float NOTNULL Tolerance Over Value
  • wms_contxf_pseq int NOTNULL Container Cross Reference Seq Key
Column Data Type Nullable Key Description

wms_counter_tbl

  • wms_counter_type smallint NOTNULL Counter Name Value
  • wms_counter_idx int NOTNULL Current Counter Number Value
Column Data Type Nullable Key Description

wms_ctwght_tbl

  • gl_cmp_key varchar(2) NOTNULL Company Key
  • in_whs_key varchar(4) NOTNULL Warehouse Key
  • in_item_key varchar(20) NOTNULL Item Key
  • im_pack_key varchar(6) NOTNULL Pack Key
  • wms_ctwght_minwgt float NOTNULL Catch Weight Minimum Tolerance
  • wms_ctwght_maxwgt float NOTNULL Catch Weight Maximum Tolerance
  • wms_ctwght_tare float NOTNULL Catch Weight Tare Weight Value
  • wms_ctwght_scc varchar(40) NULL Catch Weight SCC Value
  • upc_key varchar(60) NOTNULL UPC Key
  • ucc128_item varchar(6) NOTNULL UCC 128 Item
  • created_on datetime NOTNULL Created on Date/Time Value
  • changed_on datetime NOTNULL Changed on Date/Time Value
  • created_by varchar(8) NOTNULL User Key
  • changed_by varchar(8) NOTNULL User Key
  • lock_count int NOTNULL Lock Count Value
  • wms_ctwght_netwt float NOTNULL Catch weight Net Weight Value
  • wms_ctwght_backdt int NULL Catch Weight Back Date
  • wms_ctwght_sell int NOTNULL Catch Weight Sell Value
Column Data Type Nullable Key Description

wms_custpull_tbl

  • gl_cmp_key varchar(3) NOTNULL Company Key
  • in_whs_key varchar(4) NOTNULL Warehouse Key
  • ap_cust_key varchar(10) NOTNULL Customer Key
  • wms_custpull_puldt int NULL Customer Pull Date Value
Column Data Type Nullable Key Description

wms_cycnt_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
  • in_cycnt_key varchar(10) NULL Cycle Count Key
  • wms_cycnt_entlv varchar(10) NULL Cycle Count Entity Level Key
  • wms_cycnt_ent varchar(20) NULL Cycle Count Entity Key
  • wms_cycnt_stat varchar(10) NULL Cycle Count Status Value
  • wms_cycnt_ent2 varchar(20) NULL Cycle Count Entity 2 Key
Column Data Type Nullable Key Description

wms_erpint_tbl

  • gl_cmp_key varchar(3) NOTNULL Company Key
  • in_whs_key varchar(4) NOTNULL Warehouse Key
  • wms_erpint_type varchar(30) NOTNULL ERP Interface Type Value
  • wms_erpint_start datetime NOTNULL ERP Interface Start Value
  • wms_erpint_pid int NOTNULL ERP Interface Part ID Value
Column Data Type Nullable Key Description

wms_except_tbl

  • gl_cmp_key varchar(3) NULL Company Key
  • in_whs_key varchar(4) NULL Warehouse Key
  • wms_tran_key varchar(10) NULL Transaction Key
  • wms_conthdr_key varchar(10) NULL Tracking Key
  • wms_except_sbin varchar(15) NULL Bin Key
  • wms_except_ubin varchar(15) NULL Bin Key
  • wms_except_sqty float NULL System Expected Quantity Value
  • wms_except_uqty float NULL User Entered Quantity Value
  • wms_except_note varchar(255) NULL Exception Explanation Value
  • sa_user_key varchar(8) NULL User Key
  • wms_except_crtdt datetime NULL Exception Creation Date/Time
Column Data Type Nullable Key Description

wms_group_tbl

  • gl_cmp_key varchar(3) NOTNULL Company Key
  • in_whs_key varchar(4) NOTNULL Warehouse Key
  • wms_group_key int NOTNULL Group Key
Column Data Type Nullable Key Description

wms_kit_tbl

  • gl_cmp_key varchar(2) NOTNULL Company Key
  • in_whs_key varchar(4) NOTNULL Warehouse Key
  • wms_kititem_key varchar(20) NOTNULL Kit Item Key
  • wms_kitpack_key varchar(6) NOTNULL Kit Pack Key
  • in_item_key varchar(20) NOTNULL Item Key
  • im_pack_key varchar(6) NOTNULL Pack Key
  • wms_kit_qty float NOTNULL Kit Quantity Value
  • wms_kit_uom varchar(2) NOTNULL Kit UOM Value
  • created_by varchar(8) NOTNULL Created by Date/Time Value
  • created_on datetime NOTNULL Created on Date/Time Value
  • changed_by varchar(8) NOTNULL User Key
  • changed_on datetime NOTNULL Changed on Date/Time Value
  • lock_count int NOTNULL Lock Counter Key
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
Retrieved from "http://demo.coolearth.com/index.php?title=36:Appendix_C_Whistle_Database_Tables&oldid=623"