Revision as of 22:53, 18 September 2006 (view source) 64.122.111.148 (talk) (→‎wms_contst_tbl) ← Older edit		Revision as of 22:54, 18 September 2006 (view source) 64.122.111.148 (talk) (→‎wms_contty_tbl) Newer edit →
Line 2,064:		Line 2,064:
	===wms_contty_tbl===		===wms_contty_tbl===
−	*gl_cmp_key          varchar(3)     NOTNULL  Company Key	+	|
−	*in_whs_key          varchar(4)     NOTNULL  Warehouse Key	+	*gl_cmp_key
−	*wms_contty_key      varchar(10)   NOTNULL Container Type Value	+	*in_whs_key
−	*wms_contty_height    float          NULL    Container Height Value	+	*wms_contty_key
−	*wms_contty_depth    float          NULL    Container Depth Value	+	*wms_contty_height
−	*wms_contty_width    float          NULL    Container Width Value	+	*wms_contty_depth
−	*wms_contty_lay      int            NULL    Number Of Layers Value	+	*wms_contty_width
−	*wms_contty_case      int            NULL    Number Of Cases Value	+	*wms_contty_lay
−	*wms_contty_uom      varchar(6)    NULL    Unit Of Measure Value	+	*wms_contty_case
−	*wms_contty_dftrtype  varchar(50)    NULL    Type Of Transaction Value	+	*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
		+	|}
	{| border="1" cellpadding="2" valign="top" halign="left"		{| border="1" cellpadding="2" valign="top" halign="left"
Line 2,081:		Line 2,116:
	!Key Description		!Key Description
	|-		|-
		+
	===wms_contxf_tbl===		===wms_contxf_tbl===
	*gl_cmp_key          varchar(3)    NOTNULL  Company Key		*gl_cmp_key          varchar(3)    NOTNULL  Company Key

---

Revision as of 22:54, 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

• 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