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

From coolearthwiki
Jump to: navigation, search
(wms_ctwght_tbl)
(wms_custpull_tbl)
Line 2,288: Line 2,288:
  
 
===wms_custpull_tbl===
 
===wms_custpull_tbl===
*gl_cmp_key           varchar(3)     NOTNULL  Company Key
+
|
*in_whs_key          varchar(4)     NOTNULL  Warehouse Key
+
*gl_cmp_key        
*ap_cust_key          varchar(10)   NOTNULL Customer Key
+
*in_whs_key       
*wms_custpull_puldt  int           NULL    Customer Pull Date Value
+
*ap_cust_key       
 +
*wms_custpull_puldt
 +
|                                 
 +
*varchar(3)  
 +
*varchar(4)  
 +
*varchar(10)
 +
*int       
 +
|
 +
*NOTNULL
 +
*NOTNULL
 +
*NOTNULL
 +
*NULL                 
 +
|
 +
*Company Key            
 +
*Warehouse Key            
 +
*Customer Key           
 +
*Customer Pull Date Value  
 +
|}
  
 
{| border="1" cellpadding="2" valign="top" halign="left"
 
{| border="1" cellpadding="2" valign="top" halign="left"
Line 2,299: Line 2,316:
 
!Key Description
 
!Key Description
 
|-
 
|-
 +
 
===wms_cycnt_tbl===
 
===wms_cycnt_tbl===
 
*gl_cmp_key          varchar(3)    NULL    Company Key
 
*gl_cmp_key          varchar(3)    NULL    Company Key

Revision as of 19:00, 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

Column Data Type Nullable Key Description
  • 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


wmRuleMaster

Column Data Type Nullable Key Description
  • 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

wmScaleDefinition

Column Data Type Nullable Key Description
  • 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

wmTaskMaster

Column Data Type Nullable Key Description
  • 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

wmTestHistory

Column Data Type Nullable Key Description
  • 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

wmUomConv

Column Data Type Nullable Key Description
  • 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

wmUserPrefs

Column Data Type Nullable Key Description
  • 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

wmUserTask

Column Data Type Nullable Key Description
  • 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

wmWave

Column Data Type Nullable Key Description
  • 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

wms_autohd_tbl

Column Data Type Nullable Key Description
  • 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

wms_bin_tbl

Column Data Type Nullable Key Description
  • 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

wms_bincnt_tbl

Column Data Type Nullable Key Description
  • 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

wms_bindtlst_tbl

Column Data Type Nullable Key Description
  • 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

wms_case_tbl

Column Data Type Nullable Key Description
  • 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

wms_contadj_tbl

Column Data Type Nullable Key Description
  • 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

wms_contcase_tbl

Column Data Type Nullable Key Description
  • 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

wms_contdtl_tbl

Column Data Type Nullable Key Description
  • 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

wms_context_tbl

Column Data Type Nullable Key Description
  • 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

wms_conthdr_tbl

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

wms_contst_tbl

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

wms_contty_tbl

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

wms_contxf_tbl

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

wms_counter_tbl

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

wms_ctwght_tbl

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

wms_custpull_tbl

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

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