View source for GS:Appendix C Whistle Database Tables

=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.

{| border="1" cellpadding="2" valign="top" halign="left"
!Whistle Tables
!Common Keys and DataTypes
!Data Types
|-
|
{| border="1" cellpadding="2" valign="top" halign="left"|
|
*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
|valign="top" halign="left"|
*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
|}
|valign="top" halign="left"|
*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)
|valign="top" halign="left"|
*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==


{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-
===wmCountDetail===
|
*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
|}

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-
===wmCountMaster===
|
*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           
|}

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-
===wmCountZones===
|
*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
|}

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-
===wmCountedBins===
|
*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        
|}

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-
===wmCustomer===
|
*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
|}

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-
===wmDemand===
|
*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  
|}

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-
===wmItemInstruct===
|
*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 
|}

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-
===wmLabelCrossRef===
|
*company           
*branch            
*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"
!Column
!Data Type
!Nullable
!Key Description
|-
===wmLabelElements===
|
*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
|}

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-
===wmPickAllocation===
|
*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         
|}

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-
===wmPrintJobs===
|
*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  
|}

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-
===wmRuleContext===
|
*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              
|}

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-

===wmRuleContextLine===
|
*ruleContextLineKey   
*ruleContextKey       
*rulePriority         
*ruleMasterKey        
*sortOrder            
*lastChangedBy        
*lastChangeDate       
*createdBy            
*creationDate         
*lockCounter          
|             
*int                      
*int         
*smallint    
*int         
*smallint    
*varchar(30) 
*datetime    
*varchar(30) 
*datetime    
*int   
|
*NOTNULL       
*NOTNULL 
*NOTNULL 
*NOTNULL 
*NULL    
*NOTNULL 
*NOTNULL 
*NOTNULL 
*NOTNULL 
*NOTNULL 
|
*Rule Context Line Key 
*Rule Context Key      
*Rule Priority Value   
*Rule Master Key       
*Sort Order Value      
*User Key              
*Changed on Date       
*User Key              
*Created on Date       
*Lock Counter Value    
|}


{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-

===wmRuleMaster===
|
*ruleMasterKey        
*ruleName             
*ruleTable            
*ruleColumn           
*ruleIdentifier       
*lastChangedBy        
*lastChangeDate       
*createdBy            
*creationDate         
*lockCounter          
|    
*int        
*varchar(60)
*varchar(30)
*varchar(30)
*varchar(30)
*varchar(30)
*datetime   
*varchar(30)
*datetime   
*int
|
*NOTNULL        
*NOTNULL
*NULL   
*NULL   
*NULL   
*NOTNULL
*NOTNULL
*NOTNULL
*NOTNULL
*NOTNULL
|
*Rule Master Key       
*Rule Name Value       
*Rule Table Value      
*Rule Column Value     
*Rule ID Value         
*User Key              
*Changed on Date Value 
*User Key              
*Created on Date Value 
*Lock Counter Value    
|}

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-

===wmScaleDefinition===
|
*company             
*warehouse           
*scaleKey            
*scaleDescription    
*scaleAddress        
|                                  
*varchar(2)  
*varchar(4)  
*varchar(60) 
*varchar(128)
*varchar(128)
|
*NOTNULL
*NOTNULL
*NOTNULL
*NULL   
*NOTNULL
|
*Company Key             
*Warehouse Key           
*Scale Key               
*Scale Description Value 
*Scale Address Value  
|}
   
{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-

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

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-

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

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-

===wmUomConv===
|
*gl_cmp_key          
*in_whs_key          
*in_item_key         
*im_pack_key         
*uom_from            
*uom_to              
*factor              
|
*varchar(2)  
*varchar(4)  
*varchar(20) 
*varchar(6)  
*varchar(10) 
*varchar(10) 
*float    
|
*NOTNULL    
*NOTNULL 
*NOTNULL 
*NOTNULL 
*NOTNULL 
*NOTNULL 
*NOTNULL             
|
*Company Key  
*Warehouse Key
*Item Key     
*Pack Key     
*UOM From Key 
*UOM To Key   
*Factor Key   
|}

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-

===wmUserPrefs===
|
*gl_cmp_key           
*in_whs_key           
*user_key             
*pref_name            
*pref_value           
*created_by           
*created_on           
*changed_by           
*changed_on           
*lock_counter         
|
*varchar(2)  
*varchar(4)                  
*varchar(8)                  
*varchar(64)                 
*varchar(256)                
*varchar(8)                  
*datetime                    
*varchar(8)                  
*datetime                    
*int                         
|               
*NOTNULL                 
*NOTNULL                
*NOTNULL                
*NOTNULL                
*NULL                   
*NOTNULL                
*NOTNULL                
*NOTNULL                
*NOTNULL                
*NOTNULL                
|
*Company Key                  
*Warehouse Key                
*User Key                     
*Preference Name Value        
*Preference Value             
*User Key                     
*Created on Date/Time Value   
*User Key                     
*Changed On Date/Time Value   
*Lock Counter Value           
|}

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-

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

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-

===wmWave===
|
*company            
*warehouse          
*waveKey            
*createdOn          
*createdBy          
|                    
*varchar(2)                                    
*varchar(4)  
*varchar(10) 
*datetime    
*varchar(10) 
|
*NOTNULL 
*NOTNULL 
*NOTNULL 
*NULL    
*NOTNULL  
|
*Company Key                 
*Warehouse Key               
*Wave Key                    
*Created on Date/Time Value  
*User Key                    
|}

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-

===wms_autohd_tbl===
|
*gl_cmp_key          
*in_whs_key          
*in_item_key         
*im_pack_key         
*wms_autohd_hrs      
*context             
|
*varchar(2) 
*varchar(4) 
*varchar(30)
*varchar(6) 
*int        
*varchar(10)
|
*NOTNULL 
*NOTNULL 
*NOTNULL 
*NOTNULL 
*NULL    
*NOTNULL 
|
*Company Key                  
*Warehouse Key                
*Item Key                     
*Pack Key                     
*Autohold Length Hours Value  
*Context Value                
|}

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-

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

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-

===wms_bincnt_tbl===
|
*gl_cmp_key         
*in_whs_key         
*in_cycnt_key       
*wms_bin_key        
*wms_bincnt_stat    
*sa_user_key        
*wms_bincnt_crtdt   
*in_locn_key        
*in_item_key        
*im_pack_key        
|                           
*varchar(3)                            
*varchar(4) 
*int        
*varchar(15)
*int        
*varchar(8) 
*datetime   
*varchar(10)
*varchar(10)
*varchar(10)
|
*NULL 
*NULL 
*NULL 
*NULL 
*NULL 
*NULL 
*NULL 
*NULL 
*NULL 
*NULL
|
*Company Key                 
*Warehouse Key              
*Cycle count key            
*Bin Key                    
*Bin count status Value     
*User Key                   
*Counted on Date/Time Value 
*Location Key               
*Item Key                   
*Pack Key                   
|}

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-

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

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-

===wms_case_tbl===
|
*gl_cmp_key         
*in_whs_key         
*wms_case_num       
*created_on         
*changed_on         
*created_by         
*changed_by         
*lock_count         
|                                  
*varchar(2)                                    
*varchar(4)  
*int         
*datetime    
*datetime    
*varchar(8)  
*varchar(8)  
*int                       
|
*NOTNULL
*NOTNULL
*NOTNULL
*NOTNULL
*NOTNULL
*NOTNULL
*NOTNULL
*NOTNULL
|
*Company Key         
*Warehouse Key       
*Case Number Value   
*Created on Date     
*Changed on Date     
*User Key            
*User Key            
*Lock Counter Value  
|}

{| 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     
*in_item_key         
*im_pack_key         
*wms_contadj_qty     
*en_resn_key         
*sa_user_key         
*wms_contadj_date    
*wms_contadj_cmt     
*wms_contdtl_key     
*wms_contcase_key    
*wms_contadj_cntrl   
|                           
*varchar(3)                              
*varchar(4)   
*varchar(10)  
*varchar(30)  
*varchar(6)   
*float        
*varchar(10)  
*varchar(10)  
*datetime     
*varchar(255) 
*int          
*varchar(60)  
*varchar(60)
|
*NULL     
*NULL   
*NULL   
*NULL   
*NULL   
*NULL   
*NULL   
*NULL   
*NULL   
*NULL   
*NOTNULL
*NULL   
*NULL   
|
*Company Key                       
*Warehouse Key                     
*Tracking Key                      
*Item Key                          
*Pack Key                          
*Adjusted Quantity Value           
*Reason For Adjustment Value       
*User Key                          
*Transaction Date/Time Value       
*Container Adj Comment Value       
*Container Detail Key              
*Container Case Key                
*Container Adj Control Num Value   
|}

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-

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

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-

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

{| border="1" cellpadding="2" valign="top" halign="left"
!Column
!Data Type
!Nullable
!Key Description
|-

===wms_context_tbl===
|
*gl_cmp_key           
*in_whs_key           
*wms_conthdr_key      
*wms_context_variety  
*wms_context_linemtch 
*wms_context_idfield  
*created_on           
*changed_on           
*created_by           
*changed_by           
*lock_count           
|                                  
*varchar(2)                                    
*varchar(4)  
*varchar(10) 
*varchar(10) 
*varchar(10) 
*varchar(4)  
*datetime    
*datetime    
*varchar(8)  
*varchar(8)  
*int     
|
*NOTNULL     
*NOTNULL 
*NOTNULL 
*NULL    
*NULL    
*NULL    
*NOTNULL 
*NOTNULL 
*NOTNULL 
*NOTNULL 
*NOTNULL       
|
*Company Key                 
*Warehouse Key               
*Tracking Key                
*Context Variety Value       
*Context Line Match Value    
*Context ID Field Value      
*Created on Date/Time Value  
*Changed on Date/Time Value  
*User Key                    
*User Key                    
*Lock Count Value            
|}

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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

{| border="1" cellpadding="2" valign="top" halign="left"
!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