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 and Definitions
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
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
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_conthdr_tbl
- 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
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_contst_tbl
- gl_cmp_key varchar(3) NOTNULL Company Key
- in_whs_key varchar(4) NOTNULL Warehouse Key
- wms_contst_key varchar(10) NOTNULL Container Status Value
- wms_contst_desc varchar(60) NULL Container Description Value
- wms_contst_type varchar(10) NULL Container Type Value
- wms_contst_reldt varchar(8) NULL Container Release Date Value
- wms_contst_relby varchar(8) NULL Container Release By Date Value
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_contty_tbl
- gl_cmp_key varchar(3) NOTNULL Company Key
- in_whs_key varchar(4) NOTNULL Warehouse Key
- wms_contty_key varchar(10) NOTNULL Container Type Value
- wms_contty_height float NULL Container Height Value
- wms_contty_depth float NULL Container Depth Value
- wms_contty_width float NULL Container Width Value
- wms_contty_lay int NULL Number Of Layers Value
- wms_contty_case int NULL Number Of Cases Value
- wms_contty_uom varchar(6) NULL Unit Of Measure Value
- wms_contty_dftrtype varchar(50) NULL Type Of Transaction Value