Revision as of 16:41, 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

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

Column	Data Type	Nullable	Key Description

wmUserPrefs

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

Column	Data Type	Nullable	Key Description

wmUserTask

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

Column	Data Type	Nullable	Key Description

wmWave

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

Column	Data Type	Nullable	Key Description

wms_autohd_tbl

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

Column	Data Type	Nullable	Key Description

wms_bin_tbl

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

Column	Data Type	Nullable	Key Description

wms_bincnt_tbl

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

Column	Data Type	Nullable	Key Description

wms_bindtlst_tbl

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

Column	Data Type	Nullable	Key Description

wms_case_tbl

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

Column	Data Type	Nullable	Key Description

wms_contadj_tbl

gl_cmp_key varchar(3) NULL Company Key
in_whs_key varchar(4) NULL Warehouse Key
wms_conthdr_key varchar(10) NULL Tracking Key
in_item_key varchar(30) NULL Item Key
im_pack_key varchar(6) NULL Pack Key
wms_contadj_qty float NULL Adjusted Quantity Value
en_resn_key varchar(10) NULL Reason For Adjustment Value
sa_user_key varchar(10) NULL User Key
wms_contadj_date datetime NULL Transaction Date/Time Value
wms_contadj_cmt varchar(255) NULL Container Adj Comment Value
wms_contdtl_key int NOTNULL Container Detail Key
wms_contcase_key varchar(60) NULL Container Case Key
wms_contadj_cntrl varchar(60) NULL Container Adj Control Num Value

Column	Data Type	Nullable	Key Description

wms_contcase_tbl

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

Column	Data Type	Nullable	Key Description

wms_contdtl_tbl

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

Column	Data Type	Nullable	Key Description

wms_context_tbl

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

Column	Data Type	Nullable	Key Description

wms_conthdr_tbl

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

Column	Data Type	Nullable	Key Description

wms_contst_tbl

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

Column	Data Type	Nullable	Key Description

wms_contty_tbl

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

Column	Data Type	Nullable	Key Description

wms_contxf_tbl

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

Column	Data Type	Nullable	Key Description

wms_counter_tbl

wms_counter_type smallint NOTNULL Counter Name Value
wms_counter_idx int NOTNULL Current Counter Number Value

Column	Data Type	Nullable	Key Description

wms_ctwght_tbl

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

Column	Data Type	Nullable	Key Description

wms_custpull_tbl

gl_cmp_key varchar(3) NOTNULL Company Key
in_whs_key varchar(4) NOTNULL Warehouse Key
ap_cust_key varchar(10) NOTNULL Customer Key
wms_custpull_puldt int NULL Customer Pull Date Value

Column	Data Type	Nullable	Key Description

wms_cycnt_tbl

gl_cmp_key varchar(3) NULL Company Key
in_whs_key varchar(4) NULL Warehouse Key
wms_conthdr_key varchar(10) NULL Tracking Key
in_cycnt_key varchar(10) NULL Cycle Count Key
wms_cycnt_entlv varchar(10) NULL Cycle Count Entity Level Key
wms_cycnt_ent varchar(20) NULL Cycle Count Entity Key
wms_cycnt_stat varchar(10) NULL Cycle Count Status Value
wms_cycnt_ent2 varchar(20) NULL Cycle Count Entity 2 Key

Column	Data Type	Nullable	Key Description

wms_erpint_tbl

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

Column	Data Type	Nullable	Key Description

wms_except_tbl

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

Column	Data Type	Nullable	Key Description

wms_group_tbl

gl_cmp_key varchar(3) NOTNULL Company Key
in_whs_key varchar(4) NOTNULL Warehouse Key
wms_group_key int NOTNULL Group Key

Column	Data Type	Nullable	Key Description

wms_kit_tbl

gl_cmp_key varchar(2) NOTNULL Company Key
in_whs_key varchar(4) NOTNULL Warehouse Key
wms_kititem_key varchar(20) NOTNULL Kit Item Key
wms_kitpack_key varchar(6) NOTNULL Kit Pack Key
in_item_key varchar(20) NOTNULL Item Key
im_pack_key varchar(6) NOTNULL Pack Key
wms_kit_qty float NOTNULL Kit Quantity Value
wms_kit_uom varchar(2) NOTNULL Kit UOM Value
created_by varchar(8) NOTNULL Created by Date/Time Value
created_on datetime NOTNULL Created on Date/Time Value
changed_by varchar(8) NOTNULL User Key
changed_on datetime NOTNULL Changed on Date/Time Value
lock_count int NOTNULL Lock Counter Key

Column	Data Type	Nullable	Key Description

wms_lhold_tbl

gl_cmp_key varchar(3) NULL Company Key
in_whs_key varchar(4) NULL Warehouse Key
sa_user_key varchar(8) NULL User Key
wms_lhold_lot varchar(25) NULL Lot Hold Lot Value
wms_lhold_bgdt datetime NULL Beginning Hold Date/Time Value
wms_lhold_eddt datetime NULL Ending Hold Date/Time Value
wms_lhold_cmt varchar(255) NULL Comment Value
wms_lhold_trdt datetime NULL Date Lot Placed On Hold Value

Column	Data Type	Nullable	Key Description

wms_load_tbl

gl_cmp_key varchar(2) NOTNULL Company Key
so_brnch_key varchar(4) NOTNULL Branch Key
so_hdr_key varchar(10) NOTNULL Tracking Key
wms_load_bol varchar(25) NOTNULL Load BOL Value
wms_load_trailer varchar(25) NULL Load Trailer Value
wms_load_seal varchar(45) NULL Load Seal Value
wms_load_chep int NULL Load Chep Value
wms_load_shpdt datetime NULL Load Ship Date/Time Value
in_towhs_key varchar(4) NULL To WHS Key
carrier varchar(10) NULL Carrier Value
prePaidFreight float NULL Pre Paid Freight Value
status varchar(10) NULL Status Value
loadKey varchar(10) NULL Load Key

Column	Data Type	Nullable	Key Description

wms_loadnm_tbl

gl_cmp_key varchar(2) NOTNULL Company Key
so_brnch_key varchar(4) NOTNULL Branch Key
so_hdr_key varchar(10) NOTNULL Tracking Key
wms_loadnm_key int NULL Load Name Key

Column	Data Type	Nullable	Key Description

wms_lothist_tbl

gl_cmp_key varchar(3) NULL Company Key
in_whs_key varchar(4) NULL Warehouse Key
wms_conthdr_key varchar(10) NULL Tracking Key
wms_tran_type varchar(15) NULL Transaction Type Key
wms_tran_key varchar(20) NULL Transaction Key
in_lot_key varchar(25) NULL Lot Key
sa_user_key varchar(8) NULL User Key
wms_lothist_crtdt datetime NULL Date of transaction Value
wms_lothist_qty float NULL Lot History Quantity Value
wms_lothist_uom varchar(2) NULL Unit Of Measure Value
wms_contdtl_key int NOTNULL Container detail Key
comment_key varchar(255) NULL Comment Value
wms_lothist_key int (IDENTITY) NOTNULL Lot History Key

Column	Data Type	Nullable	Key Description

wms_outint_tbl

gl_cmp_key varchar(3) NOTNULL Company Key
so_brnch_key varchar(4) NOTNULL Branch key
so_hdr_key varchar(10) NOTNULL Order Key
so_prod_key varchar(30) NULL Product Key
wms_conthdr_key varchar(10) NULL Tracking Key
wms_outint_qty float NULL Quantity Value
wms_outint_uom varchar(2) NULL Unit of Measure Value
in_lot_key varchar(25) NULL Lot Key
wms_outint_error varchar(255) NULL Status Value
sa_user_key varchar(8) NULL User Key
wms_outint_crtdt datetime NULL Date/Time Stamp Value
wms_outint_type int NOTNULL Type of Transaction Value
wms_outdtl_key int NULL Out-Int Detail Key
in_whs_key varchar(4) NULL Warehouse Key
in_towhs_key varchar(4) NULL To WHS Key
wms_contdtl_key smallint NULL Container Detail Key
wms_whistle_recdt datetime NULL Whistle Receive Date/Time
in_item_key varchar(20) NULL Item Key
im_pack_key varchar(6) NULL Pack Key
wms_outint_control varchar(60) NULL Outint Control Key
wms_outint_unique int (IDENTITY) NOTNULL Outint Unique Key

Column	Data Type	Nullable	Key Description

wms_piint_tbl

wms_piint_error varchar(255) NULL Message Value===
gl_cmp_key varchar(3) NULL Company Key
sf_plant_key varchar(10) NULL Plant Key
in_whs_key varchar(4) NULL Warehouse Key
in_locn_key varchar(10) NULL Location Key
pm_shop_key varchar(10) NULL Production Order Key
pm_shop_ordtp varchar(1) NULL Order Type Value
sf_opseq_key int NULL Routing sequence
wms_piint_bqty float NULL Batch Quantity Value
wms_piint_sqty float NULL Scrapped Quantity Value
wms_piint_uom varchar(2) NULL Unit of Measure
sa_user_key varchar(8) NULL User Key
wms_piint_crdt datetime NULL Prod Issue Create Date Value
in_item_key varchar(20) NULL Item Key
im_pack_key varchar(6) NULL Pack Key
wms_conthdr_key varchar(10) NULL Tracking Key
in_lot_key varchar(25) NULL Lot Key
wms_contdtl_puldt datetime NULL Container Pull Date/Time
wms_piint_unique int (IDENTITY) NOTNULL Production Issue Unique Key
wms_piint_control varchar(60) NULL Production Issue Control Key
tranKey int NOTNULL Transaction Key
wms_contdtl_key int NOTNULL Container Detail Key
pm_matl_key int NOTNULL PM Material Key
originTrack varchar(10) NULL Original Tracking Key

Column	Data Type	Nullable	Key Description

wms_pmint_tbl

wms_pmint_error varchar(255) NULL Message Value===
gl_cmp_key varchar(3) NULL Company Key
sf_plant_key varchar(10) NULL Plant Key
in_whs_key varchar(4) NULL Warehouse Key
pm_shop_key varchar(10) NULL Order Key
pm_shop_ordtp varchar(1) NULL Shop Order Type Key
wms_pmint_bqty float NULL PM Batch Quantity Value
wms_pmint_sqty float NULL PM Scrapped Quantity Value
wms_pmint_uom varchar(2) NULL Unit of Measure Value
sa_user_key varchar(8) NULL User Key
wms_pmint_crdt datetime NULL PM Transaction Date/Time
in_item_key varchar(20) NULL Item Key
im_pack_key varchar(6) NULL Pack Key
wms_conthdr_key varchar(10) NOTNULL Container Header Key
wms_contdtl_key int NOTNULL Container Detail Key
in_lot_key varchar(25) NULL In Lot Key
wms_pmint_unique int (IDENTITY) NOTNULL PM Unique Key
wms_pmint_control varchar(50) NULL PM Control Key

Column	Data Type	Nullable	Key Description

wms_pmintdtl_tbl

gl_cmp_key varchar(2) NULL Company Key
sf_plant_key varchar(4) NULL Plant Key
in_whs_key varchar(4) NULL Warehouse Key
pm_shop_key varchar(10) NULL Order Key
wms_conthdr_key varchar(10) NULL Tracking Key
wms_contdtl_key int NULL Container Detail Key
wms_contcase_key varchar(60) NULL Containe Case Key
in_sublot_key int NULL Sub Lot Key
wms_contcase_ctwgt float NULL Case Catchweight Value
wms_contcase_acwgt float NULL Case Actual Weight Value
wms_contcase_prddt datetime NULL Case Production Date/Time

Column	Data Type	Nullable	Key Description

wms_point_tbl

gl_cmp_key varchar(3) NULL Company Key
so_brnch_key varchar(4) NULL Branch Key
in_whs_key varchar(4) NULL Warehouse Key
wms_conthdr_key varchar(10) NULL Tracking Key
wms_contdtl_puldt datetime NULL Pull date
po_hdr_key varchar(10) NULL Order Key
in_item_key varchar(30) NULL Item Key
im_pack_key varchar(6) NULL Pack Key
wms_point_qty float NULL Quantity Received Value
wms_point_uom varchar(6) NULL Unit Of Measure Value
in_lot_key varchar(25) NULL Lot Key
wms_point_bol varchar(20) NULL Bill of Lading Value
wms_point_error varchar(255) NULL Message Value
sa_user_key varchar(8) NULL User Key
wms_point_crtdt datetime NULL Transaction Date/Time Value
po_dtl_key smallint NULL Production Order Detail Key
in_locn_key varchar(10) NULL Location Key
wms_contdtl_key int NOTNULL Container Detail Key
wms_point_control varchar(60) NULL Point Control
wms_point_tbl_key int (IDENTITY) NOTNULL Point Table Key

Column	Data Type	Nullable	Key Description

wms_print_tbl

gl_cmp_key varchar(3) NOTNULL Company Key
in_whs_key varchar(4) NOTNULL Warehouse Key
wms_print_key varchar(100) NOTNULL Printer Name Value
wms_print_desc varchar(100) NULL Printer Description Value
wms_print_def int NULL Printer Definition Value
pr_rotate_key float NOTNULL Print Rotate Value
wms_print_tbl_key int (IDENTITY) NOTNULL Print Table Key

Column	Data Type	Nullable	Key Description

wms_pultol_tbl

gl_cmp_key varchar(3) NULL Company Key
in_whs_key varchar(4) NULL Warehouse Key
in_item_key varchar(30) NULL Item Key
im_pack_key varchar(6) NULL Pack Key
wms_pultol_tol int NULL Pull Date Tolerance Value

Column	Data Type	Nullable	Key Description

wms_recper_tbl

gl_cmp_key varchar(3) NOTNULL Company Key
in_whs_key varchar(4) NOTNULL Warehouse Key
wms_recbgn_key datetime NULL Last ERP Reconciliation Date

Column	Data Type	Nullable	Key Description

wms_screen_tbl

gl_cmp_key varchar(3) NOTNULL Company Key
in_whs_key varchar(4) NOTNULL Warehouse Key
wms_screen_key varchar(20) NOTNULL Screen Name Value

Column	Data Type	Nullable	Key Description

wms_sectmpl_tbl

gl_cmp_key varchar(3) NOTNULL Company Key
in_whs_key varchar(4) NOTNULL Warehouse Key
wms_sectmpl_key varchar(20) NOTNULL Security Template Name Key
wms_screen_key varchar(20) NOTNULL Screen Name Key
wms_secure_mode int NULL Security Mode Value

Column	Data Type	Nullable	Key Description

wms_secure_tbl

gl_cmp_key varchar(3) NULL Company Key
in_whs_key varchar(4) NULL Warehouse Key
sa_user_key varchar(8) NULL User Key
wms_screen_key varchar(20) NULL Screen Name Key
wms_secure_mode int NULL Security Mode Value

Column	Data Type	Nullable	Key Description

wms_shipins_tbl Table no longer

gl_cmp_key varchar(3) NOTNULL Company Key
in_whs_key varchar(4) NOTNULL Warehouse Key
ar_ship_key varchar(10) NOTNULL AR Ship Key
so_prod_key varchar(20) NOTNULL So Product Key
in_instr_key text NOTNULL IN Instruction Key

Column	Data Type	Nullable	Key Description

wms_track_tbl

gl_cmp_key varchar(3) NULL Company Key
in_whs_key varchar(4) NULL Warehouse Key
wms_track_key int NOTNULL Tracking Number Key

Column	Data Type	Nullable	Key Description

wms_user_tbl

gl_cmp_key varchar(3) NULL Company Key
in_whs_key varchar(4) NULL Warehouse Key
sa_user_key varchar(8) NULL User Key
wms_print_key varchar(100) NULL Default Printer Value
wms_user_lang varchar(20) NULL User Language Key
wms_user_tbl_key int (IDENTITY) NOTNULL User Table Key

Column	Data Type	Nullable	Key Description

wms_usercols_tbl

gl_cmp_key varchar(2) NOTNULL Company Key
in_whs_key varchar(4) NOTNULL Warehouse Key
wms_table_key varchar(20) NOTNULL Table Key
wms_col_key varchar(20) NOTNULL New Column Database Key
wms_col_name varchar(20) NOTNULL Column Common Name
wms_col_shortname varchar(5) NOTNULL Short Name Value
wms_col_type varchar(10) NOTNULL Column Type Value
wms_col_default varchar(26) NULL Column Default Value
wms_col_min varchar(26) NULL Column Minimum Tolerance Value
wms_col_max varchar(26) NULL Column Maximum Tolerance Value
wms_col_req smallint NULL Column Required Value
wms_item_type varchar(20) NULL Item Type Key
wms_valid_sql text NULL SQL Text Value
wms_ui_type smallint NOTNULL UI Parameter Type Key
created_on datetime NOTNULL Created On Date/Time
changed_on datetime NOTNULL Changed On Date/Time
created_by varchar(8) NOTNULL User Key
changed_by varchar(8) NOTNULL User Key
lock_count int NOTNULL Lock Counter

Column	Data Type	Nullable	Key Description

wms_utcount_tbl

gl_cmp_key varchar(2) NOTNULL Company Key
in_whs_key varchar(4) NOTNULL Warehouse Key
in_cycnt_key int NOTNULL Cycle Count Key
in_item_key varchar(20) NOTNULL Item Key
im_pack_key varchar(7) NOTNULL Pack Key
in_locn_key varchar(10) NOTNULL Location Key
en_lot_key varchar(25) NULL Lot Key
sa_user_key varchar(8) NOTNULL User Key
wms_utcycnt_crdt datetime NOTNULL Date/Time Stamp Value
wms_utcycnt_qty float NOTNULL Reported Quantity Value

Column	Data Type	Nullable	Key Description

wms_vndpull_tbl

gl_cmp_key varchar(3) NOTNULL Company Key
in_whs_key varchar(4) NOTNULL Warehouse Key
en_vend_key varchar(10) NOTNULL Vendor Key
wms_vndpull_puldt int NULL Vendor Pull Date Value

Column	Data Type	Nullable	Key Description

wms_wtint_tbl

gl_cmp_key varchar(3) NULL Company Key
so_brnch_key varchar(4) NULL Branch Key
wms_conthdr_key varchar(10) NULL Tracking Key
wms_contdtl_puldt datetime NULL Item Pull Date
wt_hdr_key varchar(10) NULL Warehouse Transfer Header Key
in_item_key varchar(30) NULL Item Key
im_pack_key varchar(6) NULL Packing Key
wms_wtint_qty float NULL WT Quantity Value
wms_wtint_uom varchar(6) NULL Unit Of Measur Value
in_lot_key varchar(25) NULL Lot Key
wms_wtint_bol varchar(20) NULL WT Bill of Lading Value
wms_wtint_error varchar(255) NULL WT Error Message Value
sa_user_key varchar(8) NULL User Key
wms_wtint_crtdt datetime NULL WT Creation Date/Time
wms_wtint_frwhs varchar(4) NULL WT From Warehouse Key
wt_dtl_key smallint NOTNULL WT Detail Key
in_whs_key varchar(4) NULL Warehouse Key
in_locn_key varchar(10) NULL In Location Key
wms_contdtl_key int NOTNULL Container Detail Key
wms_wtint_control varchar(60) NULL ERP Control Key
wms_wtint_key int (IDENTITY) NOTNULL WT Index Key

Column	Data Type	Nullable	Key Description

wms_zone_tbl

gl_cmp_key varchar(3) NOTNULL Company Key
in_whs_key varchar(4) NOTNULL Warehouse Key
wms_zone_key varchar(10) NOTNULL Zone Key
wms_bin_key varchar(15) NOTNULL Bin Key

Column	Data Type	Nullable	Key Description

wms_zonexf_tbl

gl_cmp_key varchar(3) NOTNULL Company Key
in_whs_key varchar(4) NOTNULL Warehouse Key
wms_zone_key varchar(10) NOTNULL Zone Key
in_item_key varchar(30) NOTNULL Item Key
im_pack_key varchar(6) NOTNULL Pack Key
wms_zone_pri int NOTNULL Zone Priority Value
actionType smallint NOTNULL Action Type Value

Column	Data Type	Nullable	Key Description

@@ Line 984: / Line 984: @@
 ===wmTestHistory===
-*testKey              varchar(10)    NOTNULL  Test Key
+|
-*effectiveDate        datetime       NOTNULL  Effective Date/Time Value
+*testKey
-*sequence             int            NOTNULL  Sequence Value
+*effectiveDate
-*item                 varchar(20)    NOTNULL  Item Key
+*sequence
-*pack                 varchar(10)    NOTNULL  Pack Key
+*item
-*lot                  varchar(30)    NOTNULL  Lot Key
+*pack
-*sampleID             varchar(20)    NOTNULL  Sample ID Value
+*lot
-*status               varchar(20)    NOTNULL  Status Value
+*sampleID
-*result               varchar(60)    NOTNULL  Result Value
+*status
-*measured             decimal(18,4)  NULL     Measured value
+*result
-*measuredUOM          varchar(2)     NULL     Unit Of Measure Value
+*measured
-*comments             varchar(255)   NULL     Comment Value
+*measuredUOM
-*transactionTime      datetime       NOTNULL  Transaction Date/Time Value
+*comments
-*tranactionUser       varchar(10)    NULL     User Key
+*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"
@@ Line 1,005: / Line 1,052: @@
 !Key Description
 |-
 ===wmUomConv===
 *gl_cmp_key           varchar(2)     NOTNULL  Company Key

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