Latest revision as of 14:46, 4 February 2010

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 later in this appendix.

Whistle Tables

Common Keys and DataTypes

Data Types

wmASNHistory
wmAutoReceiveWhs
wmCountDetail
wmCountMaster
wmCountZones
wmCountedBins
wmCustomer
wmDemand
wmExtraInfoUserFlds
wmItemInstruct
wmLabelCrossRef
wmLabelElements
wmPickAllocation
wmPOReturnInt
wmPrintJobs
wmReceiptReturn
wmReclassHist
wmScaleDefinition
wmStockMoveInt
wmTestHistory
wmUomConv
wmUserPrefs
wmWave
wms_autohd_tbl
wms_bin_tbl
wms_bindtlst_tbl
wms_case_tbl
wms_comments_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_rma_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

wmASNHistory

History of EDI ASN transmitted from Whistle.

Column	Data Type	Nullable	Key Description
company warehouse atffilename billto orderkey numberofpallets grossweight bolnum carrier shipto seal trailer numchep shipdate createdate createdby	varchar(2) varchar(4) varchar(512) varchar(11) varchar(11) integer float varchar(26) varchar(11) varchar(11) varchar(46) varchar(26) integer datetime datetime varchar(8)	NOTNULL NOTNULL NOTNULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL	Company Key Warehouse Key ATF File Name Bill To Name Order Key Number Of Pallets Gross Weight Value Bill of Lading Value Carrier Value Ship To Name Seal Value Trailer Value CHEP Value Ship Date/Time Value Created On Date/Time Value Created By Value

wmAutoReceiveWhs

List of warehouses that can auto receive warehouse transfer push transactions.

Column	Data Type	Nullable	Key Description
company warehouse	varchar(2) varchar(4)	NULL NULL	Company Key Warehouse Key

wmCountDetail

Cycle count detail information. Child of wmCountMaser

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

Cycle count header information. Parent of wmCountDetail

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

Contains collection of bins in a count zone.

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

Details of what bins have been counted for a particular cycle count.

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

Configuration details for a customer.

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

Demand records for staging. Contains picking progress information for production orders, sales orders and warehouse transfers.

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

wmExtraInfoUserFlds

Collect users data for purchase order receipts and sales order shippments.

Column	Data Type	Nullable	Key Description
company branch warehouse orderkey bolkey parentWnd user1 user2 user3 user4 user5 user6 user7 user8 user9 user10 user11 user12 user13 user14 user15 user16 user17 user18 user19 user20 user21 user22 user23 user24 user25 user26 user27 user28 user29 user30 userkey createdate	varchar(2) varchar(4) varchar(4) varchar(10) varchar(20) int varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(8) datetime	NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL	Company Key Branch Key Warehouse Key Order Key Bill of Lading Key Parent Window Type Key Entry Field 1 Entry Field 2 Entry Field 3 Entry Field 4 Entry Field 5 Entry Field 6 Entry Field 7 Entry Field 8 Entry Field 9 Entry Field 10 Entry Field 11 Entry Field 12 Entry Field 13 Entry Field 14 Entry Field 15 Entry Field 16 Entry Field 17 Entry Field 18 Entry Field 19 Entry Field 20 Entry Field 21 Entry Field 22 Entry Field 23 Entry Field 24 Entry Field 25 Entry Field 26 Entry Field 27 Entry Field 28 Entry Field 29 Entry Field 30 User Key Created On Date/Time Value

wmItemInstruct

Picking instructions for user.

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

Attaches Vendor deliver-Froms to a label for vendor label decoding.

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

Defines elements on a vendor label.

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

wmPOReturnInt

Transaction history of PO returns.

Column	Data Type	Nullable	Key Description
returnLineId company branch warehouse po poDtl receipt contHdr contDtl item pack lot location returnedQty returnedUom returnedTime userKey poReturnControl	int varchar(3) varchar(5) varchar(5) varchar(10) int varchar(10) varchar(20) int varchar(30) varchar(10) varchar(25) varchar(10) decimal varchar(6) datetime varchar(8) varchar(60)	NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL	Return Line Key Company Key Branch Key Warehouse Key Purchase Order Key Purchase Order Detail Key Receipt Key Container Header Key Container Detail Key Item Key Pack Key Lot Key Location Key Quantity Returned Quantity Returned Unit of Measure Returned Date/Time Value User Key Control Number

wmPrintJobs

Holds sequence registers for preprinted labels.

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

wmReceiptReturn

Collects details of Purchase order returns.

Column	Data Type	Nullable	Key Description
company branch warehouse purchaseOrder receiptCntrl rma item pack qty track reason comment userKey createdate	varchar(2) varchar(4) varchar(4) varchar(10) varchar(20) varchar(20) varchar(20) varchar(6) decimal varchar(10) varchar(10) varchar(255) varchar(8) datetime	NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL	Company Key Branch Key Warehouse Key Purchase Order Key Control Number Return Merchandise Authorization Key Item Key Pack Key Quantity Container Header Key Reason Code Comment User Key Created On Date/Time Value

wmReclassHist

Transactional history for Item Reclass transactions.

Column	Data Type	Nullable	Key Description
company warehouse container containerdetail olditem oldpack oldproduct oldqty olduom oldcontainertype oldlot newitem newpack newproduct newqty newuom newcontainertype newlot createdate username debitAtfControl creditAtfControl	varchar(2) varchar(4) varchar(10) int varchar(20) varchar(10) varchar(20) float varchar(5) varchar(10) varchar(25) varchar(20) varchar(10) varchar(20) float varchar(5) varchar(10) varchar(25) datetime varchar(8) varchar(60) varchar(60)	NOTNULL NOTNULL NOTNULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NOTNULL NOTNULL	Company Key Warehouse Key Container Header Key Container Detail Key Original Item Key Original Pack Key Original Product Key Original Quantity Value Original Unit of Measure Original Container Type Original Lot Key New Item Key New Pack Key New Product Key New Quantity Value New Unit of Measure New Container Type New Lot Key Created On Date/Time Value User Key Debit ATF Control Number Credit ATF Control Number

wmScaleDefinition

Load cell setup.

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

wmStockMoveInt

Transaction history of ERP stock move interfaces

Column	Data Type	Nullable	Key Description
company warehouse wms_conthdr_key tolocation fromlocation sa_user_key createdate item pack quantity uom wms_eia_cntrl reason trans_date lot	varchar(2) varchar(4) varchar(10) varchar(10) varchar(10) varchar(8) datetime varchar(20) varchar(10) float varchar(6) varchar(60) varchar(14) datetime varchar(25)	NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL	Company Key Warehouse Key Container Header Key Destination Location Source Location User Key Created On Date/Time Value Item Key Pack Key Quantity Unit of Measure Control Number Reason Code Transaction Date/Time Value Lot Key

wmTestHistory

History of QC test data collection.

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

Warehouse level UOM conversions.

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

Warehouse and User level software settings.

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

wmWave

Wave picking header.

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

Definition by item of timed and indefinite holds for receipts and production.

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

Definition of bin locations in a warehouse.

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 can_mix_items not_on_picklist dont_trackvol	varchar(3) varchar(4) varchar(10) varchar(15) float float float varchar(10) int int int int int int int	NOTNULL NOTNULL NULL NOTNULL NULL NULL NULL NULL NULL NULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL	Company Key Warehouse Key ERP 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 will accept a mix of items Don't show bin contents in picklist Don't calculate bin volume

wms_bindtlst_tbl

Contains location of containers in the warehouse and the space remaining in bins.

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 lastCount not_on_picklist dont_trackvol	varchar(3) varchar(4) varchar(13) varchar(10) varchar(10) float float float float float int varchar(30) varchar(6) varchar(25) datetime varchar(20) varchar(10) datetime float varchar(10) int int float float datetime int int	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 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 Counted On Date/Time Value Don't show bin contents in picklist Dont' calculate bin volume

wms_case_tbl

Case number register by warehouse.

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_comments_tbl

List of valid comments by warehouse.

Column	Data Type	Nullable	Key Description
company warehouse comments	varchar(2) varchar(4) varchar(60)	NULL NULL NULL	Company Key Warehouse Key Comment Text

wms_contadj_tbl

Transaction history of misc adjustments made to inventory.

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

Case/sublot level inventory master. Child of wms_contdtl_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 lot allocation pieces lineKey	varchar(2) varchar(4) varchar(10) int varchar(60) float int datetime datetime datetime varchar(8) varchar(8) int int float varchar(25) varchar(25) int int	NOTNULL NOTNULL NULL NULL NOTNULL NULL NULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NULL NULL NULL NULL	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 Lot Key Case Allocated Value Per box Piece Count Line Number

wms_contdtl_tbl

Item/Pack/Lot level inventory master. Child of wms_conthdr_tbl, parent of wms_contcase_tbl table.

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(20) 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

Inventory master for container (pallet) level inventory. Parent of wms_contdtl_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 lockCounter	varchar(3) varchar(4) varchar(10) varchar(10) varchar(10) varchar(15) datetime varchar(10) datetime varchar(8) datetime int float int	NOTNULL NOTNULL NOTNULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 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 Lock Counter Value

wms_contst_tbl

Valid inventory statuses

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

Definition of container types.

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

Maps Item/Packs to a container type.

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

wms_counter_tbl

Generic counter table.

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

wms_ctwght_tbl

Defines the setup for catchweight or serial tracked inventory.

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

wms_custpull_tbl

Days of shelf life required for a customer when shipping.

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

wms_erpint_tbl

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

wms_except_tbl

Logs users exceptions, like not following pick or putaway recommendations.

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

wms_group_tbl

Defines groupings of containers.

Column	Data Type	Nullable	Key Description
gl_cmp_key in_whs_key wms_group_key	varchar(3) varchar(4) int	NOTNULL NOTNULL NOTNULL	Company Key Warehouse Key Group Key

wms_kit_tbl

Formulations for kit building.

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

wms_lhold_tbl

Transactional history for lot holds.

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

wms_load_tbl

Contains extended information about a shipment load. Also used for BOL generation.

Column	Data Type	Nullable	Key Description
gl_cmp_key so_brnch_key so_hdr_key wms_load_bol wms_load_trailer wms_load_seal wms_load_chep wms_load_shpdt in_towhs_key carrier prePaidFreight status loadKey temp_recorder trl_temp_start set_trl_at set_trl_for_hrs trl_temp_for_trip pallets_in po_num	varchar(2) varchar(4) varchar(10) varchar(25) varchar(25) varchar(45) int datetime varchar(4) varchar(10) float varchar(10) varchar(10) varchar(25) varchar(5) varchar(5) varchar(5) varchar(5) varchar(5) varchar(25)	NOTNULL NOTNULL NOTNULL NOTNULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL	Company key Branch Key Tracking Key Load BOL Value Load Trailer Value Load Seal Value Load Chep Value Load Ship Date/Time Value To WHS Key Carrier Value Pre Paid Freight Value Status Value Load Key Thermometer ID Number Temp of Trailer at Start Of Loading Process Temp to Set Trailer At Number of Hours to Set Temp For Temp Trailer Should Maintain For Rest of Trip After set_trl_for_hrs Hours Number of Empty Pallets on Truck/Trailer When It Arrives PO Number

wms_loadnm_tbl

Register for load numbers.

Column	Data Type	Nullable	Key Description
gl_cmp_key so_brnch_key so_hdr_key wms_loadnm_key	varchar(2) varchar(4) varchar(10) int	NOTNULL NOTNULL NOTNULL NULL	Company Key Branch Key Tracking Key Load Name Key

wms_lothist_tbl

Transaction history for system.

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

wms_outint_tbl

Transaction history for shipments.

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

wms_piint_tbl

Transaction history for production issues.

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

wms_pmint_tbl

Transaction history for production reports.

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

wms_pmintdtl_tbl

Transaction history for production reports of catchweight / serial tracked inventory.

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

wms_point_tbl

Transactional history of purchase order receipts.

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

wms_print_tbl

Printer definition.

Column	Data Type	Nullable	Key Description
gl_cmp_key in_whs_key wms_print_key wms_print_desc wms_print_def pr_rotate_key	varchar(3) varchar(4) varchar(100) varchar(100) int float	NOTNULL NOTNULL NOTNULL NULL NULL NOTNULL	Company Key Warehouse Key Printer Name Value Printer Description Value Printer Definition Value Print Rotate Value

wms_pultol_tbl

Number of days to consider inventory as the same age.

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

wms_recper_tbl

Date of last ERP reconciliation.

Column	Data Type	Nullable	Key Description
gl_cmp_key in_whs_key wms_recbgn_key	varchar(3) varchar(4) datetime	NOTNULL NOTNULL NULL	Company Key Warehouse Key Last ERP Reconciliation Date

wms_rma_tbl

Whistle RMA information.

Column	Data Type	Nullable	Key Description
gl_cmp_key so_brnch_key so_rthdr_key so_hdr_key so_resn_code sa_user_key wms_rma_crtdt	varchar(2) varchar(4) varchar(10) varchar(10) varchar(11) varchar(8) datetime	NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NULL NULL	Company Key Branch Key Sales Order Return Header Key Sales Order Header Key Sales Order Reason Code User Key Created On Date/Time Value

wms_screen_tbl

Valid screens for a warehouse.

Column	Data Type	Nullable	Key Description
gl_cmp_key in_whs_key wms_screen_key	varchar(3) varchar(4) varchar(20)	NOTNULL NOTNULL NOTNULL	Company Key Warehouse Key Screen Name Value

wms_sectmpl_tbl

Security template definition.

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

wms_secure_tbl

Users security rights.

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

wms_track_tbl

Register for container tracking numbers.

Column	Data Type	Nullable	Key Description
gl_cmp_key in_whs_key wms_track_key	varchar(3) varchar(4) int	NULL NULL NOTNULL	Company Key Warehouse Key Tracking Number Key

wms_user_tbl

Extended user information, default printer and language.

Column	Data Type	Nullable	Key Description
gl_cmp_key in_whs_key sa_user_key wms_print_key wms_user_lang	varchar(3) varchar(4) varchar(8) varchar(100) varchar(20)	NULL NULL NULL NULL NULL	Company Key Warehouse Key User Key Default Printer Value User Language Key

wms_usercols_tbl

Metadata for user columns in wms_contdtl_tbl table.

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

wms_vndpull_tbl

Minimum number of days of shelf life to allow for receipt of an item.

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

wms_wtint_tbl

Transaction history for warehouse transfer receipts.

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

wms_zone_tbl

Maps bins to picking and putaway zones.

Column	Data Type	Nullable	Key Description
gl_cmp_key in_whs_key wms_zone_key wms_bin_key	varchar(3) varchar(4) varchar(10) varchar(15)	NOTNULL NOTNULL NOTNULL NOTNULL	Company Key Warehouse Key Zone Key Bin Key

wms_zonexf_tbl

Attaches an item to one or more preferred zones.

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

@@ Line 1: / Line 1: @@
-Whistle Database Tables
+=Whistle Database Tables=
+The Whistle application uses a number of database tables to store and organize warehouse information.  Whistle updates most tables automatically.  Other tables, such as the ‘user’ tables, are updated manually through the use of data maintenance frames (see chapter on Data Maintenance Frames).  This is a comprehensive listing of all Whistle – specific database tables and their corresponding parameters.
-The 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 18 – 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 later in this appendix.
-The following is a list of all Whistle database tables.  Each table is described in detail in later in this appendix.
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Whistle Tables
+!Common Keys and DataTypes
+!Data Types
+|-
+|
+{| border="1" cellpadding="2" valign="top" halign="left"|
+|
+*wmASNHistory
+*wmAutoReceiveWhs
+*wmCountDetail
+*wmCountMaster
+*wmCountZones
+*wmCountedBins
+*wmCustomer
+*wmDemand
+*wmExtraInfoUserFlds
+*wmItemInstruct
+*wmLabelCrossRef
+*wmLabelElements
+*wmPickAllocation
+*wmPOReturnInt
+*wmPrintJobs
+*wmReceiptReturn
+*wmReclassHist
+*wmScaleDefinition
+*wmStockMoveInt
+*wmTestHistory
+*wmUomConv
+*wmUserPrefs
+*wmWave
+*wms_autohd_tbl
+*wms_bin_tbl
+*wms_bindtlst_tbl
+*wms_case_tbl
+*wms_comments_tbl
+*wms_contadj_tbl
+*wms_contcase_tbl
+*wms_contdtl_tbl
+*wms_context_tbl
+*wms_conthdr_tbl
+*wms_contst_tbl
+*wms_contty_tbl
+|valign="top" halign="left"|
+*wms_contxf_tbl
+*wms_counter_tbl
+*wms_ctwght_tbl
+*wms_custpull_tbl
+*wms_cycnt_tbl
+*wms_erpint_tbl
+*wms_except_tbl
+*wms_group_tbl
+*wms_kit_tbl
+*wms_lhold_tbl
+*wms_load_tbl
+*wms_loadnm_tbl
+*wms_lothist_tbl
+*wms_outint_tbl
+*wms_piint_tbl
+*wms_pmint_tbl
+*wms_pmintdtl_tbl
+*wms_point_tbl
+*wms_print_tbl
+*wms_pultol_tbl
+*wms_recper_tbl
+*wms_rma_tbl
+*wms_screen_tbl
+*wms_sectmpl_tbl
+*wms_secure_tbl
+*wms_shipins_tbl
+*wms_track_tbl
+*wms_user_tbl
+*wms_usercols_tbl
+*wms_utcount_tbl
+*wms_vndpull_tbl
+*wms_wtint_tbl
+*wms_zone_tbl
+|}
+|valign="top" halign="left"|
+*Bin Key                       varchar(15)
+*Branch Key                    varchar(4)
+*Company Key                   varchar(2)
+*Container Detail Key          int
+*Container Header Key          varchar(10)
+*Count Key                     int
+*Item Key                      varchar(30)
+*Location Key                  varchar(10)
+*Lot Key                       varchar(25)
+*Order Key                     varchar(10)
+*Pack Key                      varchar(10)
+*Tracking Key                  varchar(10)
+*User Key                      varchar(30)
+*Warehouse Key                 varchar(4)
+*Zone Key                      varchar(10)
+|valign="top" halign="left"|
+*datetime
+*decimal(18,4)
+*float
+*int
+*int (IDENTITY)
+*smallint
+*text
+*varchar(1)
+*varchar(10)
+*varchar(100)
+*varchar(128)
+*varchar(13)
+*varchar(15)
+*varchar(2)
+*varchar(20)
+*varchar(25)
+*varchar(255)
+*varchar(256)
+*varchar(45)
+*varchar(5)
+*varchar(30)
+*varchar(4)
+*varchar(40)
+*varchar(50)
+*varchar(6)
+*varchar(60)
+*varchar(64)
+*varchar(7)
+*varchar(8)
+|}
+==Whistle Tables and Definitions==
-Whistle Tables :
+{| border="1" cellpadding="2" valign="top" halign="left"
-wmCountDetail
+!Column
-wmCountMaster
+!Data Type
-wmCountZones
+!Nullable
-wmCountedBins
+!Key Description
-wmCustomer
+|-
-wmDemand
+===wmASNHistory===
-wmItemInstruct
+History of EDI ASN transmitted from Whistle.
-wmLabelCrossRef
+|
-wmLabelElements
+*company
-wmPickAllocation
+*warehouse
-wmPrintJobs
+*atffilename
-wmRuleContext
+*billto
-wmRuleContextLine
+*orderkey
-wmRuleMaster
+*numberofpallets
-wmScaleDefinition
+*grossweight
-wmTaskMaster
+*bolnum
-wmTestHistory
+*carrier
-wmUomConv
+*shipto
-wmUserPrefs
+*seal
-wmUserTask
+*trailer
-wmWave
+*numchep
-wms_autohd_tbl
+*shipdate
-wms_bin_tbl
+*createdate
-wms_bincnt_tbl
+*createdby
-wms_bindtlst_tbl
+|
-wms_case_tbl
+*varchar(2)
-wms_contadj_tbl
+*varchar(4)
-wms_contcase_tbl
+*varchar(512)
-wms_contdtl_tbl
+*varchar(11)
-wms_context_tbl
+*varchar(11)
-wms_conthdr_tbl
+*integer
-wms_contst_tbl
+*float
-wms_contty_tbl
+*varchar(26)
-wms_contxf_tbl
+*varchar(11)
-wms_counter_tbl
+*varchar(11)
-wms_ctwght_tbl
+*varchar(46)
-wms_custpull_tbl
+*varchar(26)
-wms_cycnt_tbl
+*integer
-wms_erpint_tbl
+*datetime
-wms_except_tbl
+*datetime
-wms_group_tbl
+*varchar(8)
-wms_kit_tbl
+|
-wms_lhold_tbl
+*NOTNULL
-wms_load_tbl
+*NOTNULL
-wms_loadnm_tbl
+*NOTNULL
-wms_lothist_tbl
+*NULL
-wms_outint_tbl
+*NULL
-wms_piint_tbl
+*NULL
-wms_pmint_tbl
+*NULL
-wms_pmintdtl_tbl
+*NULL
-wms_point_tbl
+*NULL
-wms_print_tbl
+*NULL
-wms_pultol_tbl
+*NULL
-wms_recper_tbl
+*NULL
-wms_screen_tbl
+*NULL
-wms_sectmpl_tbl
+*NULL
-wms_secure_tbl
+*NULL
-wms_shipins_tbl
+*NULL
-wms_track_tbl
+|
-wms_user_tbl
+*Company Key
-wms_usercols_tbl
+*Warehouse Key
-wms_utcount_tbl
+*ATF File Name
-wms_vndpull_tbl
+*Bill To Name
-wms_wtint_tbl
+*Order Key
-wms_zone_tbl
+*Number Of Pallets
-wms_zonexf_tbl
+*Gross Weight Value
-Common Keys and DataTypes :
+*Bill of Lading Value
-Bin Key                       varchar(15)
+*Carrier Value
-Branch Key                    varchar(4)
+*Ship To Name
-Company Key                   varchar(2)
+*Seal Value
-Container Detail Key          int
+*Trailer Value
-Container Header Key          varchar(10)
+*CHEP Value
-Count Key                     int
+*Ship Date/Time Value
-Item Key                      varchar(30)
+*Created On Date/Time Value
-Location Key                  varchar(10)
+*Created By Value
-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)
-Data Types :
-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
+{| border="1" cellpadding="2" valign="top" halign="left"
-company              varchar(2)     NOTNULL  Company Key
+!Column
-warehouse            varchar(4)     NOTNULL  Warehouse Key
+!Data Type
-countKey             int            NOTNULL  Count Key
+!Nullable
-containerHeader      varchar(10)    NOTNULL  Container Header Key
+!Key Description
-containerDetail      int            NOTNULL  Container Detail Key
+|-
-bin                  varchar(10)    NOTNULL  Bin Key
-item                 varchar(10)    NOTNULL  Item Key
-pack                 varchar(10)    NOTNULL  Pack Key
-lot                  varchar(10)    NOTNULL  Lot Key
-originalQty          decimal(18,4)  NOTNULL  Original Quantity Value
-countedQty           decimal(18,4)  NOTNULL  Counted Quantity Value
-countedCost          decimal(18,4)  NOTNULL  Counted Cost Value
-variance             decimal(18,4)  NOTNULL  Variance Value
-varianceCost         decimal(18,4)  NOTNULL  Variance Cost Value
-countedBy            varchar(10)    NOTNULL  User Key
-countedOn            datetime       NOTNULL  Counted On Date/Time Value
-updateCounter        int            NOTNULL  Update Counter Key
+===wmAutoReceiveWhs===
+List of warehouses that can auto receive warehouse transfer push transactions.
+|
+*company
+*warehouse
+|
+*varchar(2)
+*varchar(4)
+|
+*NULL
+*NULL
+|
+*Company Key
+*Warehouse Key
+|}
-wmCountMaster
+{| border="1" cellpadding="2" valign="top" halign="left"
-company              varchar(2)     NOTNULL  Company Key
+!Column
-warehouse            varchar(4)     NOTNULL  Warehouse Key
+!Data Type
-countKey             int            NOTNULL  Count Key
+!Nullable
-countStatus          varchar(10)    NOTNULL  Count Status Key
+!Key Description
-createdBy            varchar(10)    NOTNULL  User Key
+|-
-createdOn            datetime       NOTNULL  Counted On Date/Time Value
-completedBy          varchar(10)    NULL     User Key
-completedOn          datetime       NULL     Completed On Date/Time Value
-countedCost          decimal(18,4)  NULL     Counted Cost Value
-netVarianceCost      decimal(18,4)  NULL     Net Variance Cost
-numCounts            int            NULL     Number of Counts Value
-numErrors            int            NULL     Number of Errors Value
+===wmCountDetail===
+Cycle count detail information.  Child of wmCountMaser
+|
+*company
+*warehouse
+*countKey
+*containerHeader
+*containerDetail
+*bin
+*item
+*pack
+*lot
+*originalQty
+*countedQty
+*countedCost
+*variance
+*varianceCost
+*countedBy
+*countedOn
+*updateCounter
+|
+*varchar(2)
+*varchar(4)
+*int
+*varchar(10)
+*int
+*varchar(10)
+*varchar(10)
+*varchar(10)
+*varchar(10)
+*decimal(18,4)
+*decimal(18,4)
+*decimal(18,4)
+*decimal(18,4)
+*decimal(18,4)
+*varchar(10)
+*datetime
+*int
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Count Key
+*Container Header Key
+*Container Detail Key
+*Bin Key
+*Item Key
+*Pack Key
+*Lot Key
+*Original Quantity Value
+*Counted Quantity Value
+*Counted Cost Value
+*Variance Value
+*Variance Cost Value
+*User Key
+*Counted On Date/Time Value
+*Update Counter Key
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wmCountMaster===
+Cycle count header information.  Parent of wmCountDetail
+|
+*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
+{| border="1" cellpadding="2" valign="top" halign="left"
-company              varchar(2)     NOTNULL  Company Key
+!Column
-warehouse            varchar(4)     NOTNULL  Warehouse Key
+!Data Type
-countZone            varchar(10)    NOTNULL  Count Zone Key
+!Nullable
-bin                  varchar(10)    NOTNULL  Bin Key
+!Key Description
+|-
+===wmCountZones===
+Contains collection of bins in a count zone.
+|
+*company
+*warehouse
+*countZone
+*bin
+|
+*varchar(2)
+*varchar(4)
+*varchar(10)
+*varchar(10)
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Count Zone Key
+*Bin Key
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wmCountedBins===
+Details of what bins have been counted for a particular cycle count.
+|
+*company
+*warehouse
+*countKey
+*bin
+*errors
+*countedBy
+*countedOn
+*updateCounter
+|
+*varchar(2)
+*varchar(4)
+*int
+*varchar(10)
+*int
+*varchar(10)
+*datetime
+*int
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Count Key
+*Bin Key
+*Errors Key
+*User Key
+*Counted On Date/Time Value
+*Update Counter Key
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wmCustomer===
+Configuration details for a customer.
+|
+*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
+|}
-wmCountedBins
+{| border="1" cellpadding="2" valign="top" halign="left"
-company              varchar(2)     NOTNULL  Company Key
+!Column
-warehouse            varchar(4)     NOTNULL  Warehouse Key
+!Data Type
-countKey             int            NOTNULL  Count Key
+!Nullable
-bin                  varchar(10)    NOTNULL  Bin Key
+!Key Description
-errors               int            NOTNULL  Errors Key
+|-
-countedBy            varchar(10)    NOTNULL  User Key
+===wmDemand===
-countedOn            datetime       NOTNULL  Counted On Date/Time Value
+Demand records for staging.  Contains picking progress information for production orders, sales orders and warehouse transfers.
-updateCounter        int            NOTNULL  Update Counter Key
+|
+*company
+*warehouse
+*orderKey
+*orderType
+*demandLine
+*status
+*item
+*pack
+*lot
+*demandQty
+*pickedQty
+*uom
+*createTime
+*activeUser
+*lockCounter
+*minShelfLife
+|
+*varchar(2)
+*varchar(4)
+*varchar(10)
+*int
+*int
+*varchar(50)
+*varchar(20)
+*varchar(8)
+*varchar(20)
+*decimal(18,4)
+*decimal(18,4)
+*varchar(2)
+*datetime
+*varchar(10)
+*int
+*int
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Order Key
+*Order Type Key
+*Demand Line Key
+*Status Key
+*Item Key
+*Pack Key
+*Lot Key
+*Demand Quantity Value
+*Picked Quantity Value
+*UOM Value
+*Created Date/Time Value
+*User Key
+*Lock Counter Key
+*Minimum Shelf Life Key
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wmExtraInfoUserFlds===
+Collect users data for purchase order receipts and sales order shippments.
+|
+*company
+*branch
+*warehouse
+*orderkey
+*bolkey
+*parentWnd
+*user1
+*user2
+*user3
+*user4
+*user5
+*user6
+*user7
+*user8
+*user9
+*user10
+*user11
+*user12
+*user13
+*user14
+*user15
+*user16
+*user17
+*user18
+*user19
+*user20
+*user21
+*user22
+*user23
+*user24
+*user25
+*user26
+*user27
+*user28
+*user29
+*user30
+*userkey
+*createdate
+|
+*varchar(2)
+*varchar(4)
+*varchar(4)
+*varchar(10)
+*varchar(20)
+*int
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(50)
+*varchar(8)
+*datetime
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+|
+*Company Key
+*Branch Key
+*Warehouse Key
+*Order Key
+*Bill of Lading Key
+*Parent Window Type Key
+*Entry Field 1
+*Entry Field 2
+*Entry Field 3
+*Entry Field 4
+*Entry Field 5
+*Entry Field 6
+*Entry Field 7
+*Entry Field 8
+*Entry Field 9
+*Entry Field 10
+*Entry Field 11
+*Entry Field 12
+*Entry Field 13
+*Entry Field 14
+*Entry Field 15
+*Entry Field 16
+*Entry Field 17
+*Entry Field 18
+*Entry Field 19
+*Entry Field 20
+*Entry Field 21
+*Entry Field 22
+*Entry Field 23
+*Entry Field 24
+*Entry Field 25
+*Entry Field 26
+*Entry Field 27
+*Entry Field 28
+*Entry Field 29
+*Entry Field 30
+*User Key
+*Created On Date/Time Value
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
-wmCustomer
+===wmItemInstruct===
-company              varchar(2)     NOTNULL  Company Key
+Picking instructions for user.
-warehouse            varchar(4)     NOTNULL  Warehouse Key
+|
-customerKey          varchar(10)    NOTNULL  Customer Key
+*company
-showCustPartNumber   int            NOTNULL  Show Customer Part Number Key
+*warehouse
+*item
+*pack
+*context
+*instruction
+|
+*varchar(2)
+*varchar(4)
+*varchar(20)
+*varchar(8)
+*int
+*varchar(255)
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Item Key
+*Pack Key
+*Context Key
+*Instruction Text Value
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wmLabelCrossRef===
+Attaches Vendor deliver-Froms to a label for vendor label decoding.
+|
+*company
+*branch
+*deliverFrom
+*labelKey
+|
+*varchar(2)
+*varchar(4)
+*varchar(10)
+*int
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Company key
+*Branch Key
+*Deliver From Key
+*Label Key
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wmLabelElements===
+Defines elements on a vendor label.
+|
+*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
+|}
-wmDemand
+{| border="1" cellpadding="2" valign="top" halign="left"
-company              varchar(2)     NOTNULL  Company Key
+!Column
-warehouse            varchar(4)     NOTNULL  Warehouse Key
+!Data Type
-orderKey             varchar(10)    NOTNULL  Order Key
+!Nullable
-orderType            int            NOTNULL  Order Type Key
+!Key Description
-demandLine           int            NOTNULL  Demand Line Key
+|-
-status               varchar(50)    NOTNULL  Status Key
+===wmPOReturnInt===
-item                 varchar(20)    NOTNULL  Item Key
+Transaction history of PO returns.
-pack                 varchar(8)     NULL     Pack Key
+|
-lot                  varchar(20)    NULL     Lot Key
+*returnLineId
-demandQty            decimal(18,4)  NOTNULL  Demand Quantity Value
+*company
-pickedQty            decimal(18,4)  NOTNULL  Picked Quantity Value
+*branch
-uom                  varchar(2)     NOTNULL  UOM Value
+*warehouse
-createTime           datetime       NOTNULL  Created Date/Time Value
+*po
-activeUser           varchar(10)    NOTNULL  User Key
+*poDtl
-lockCounter          int            NOTNULL  Lock Counter Key
+*receipt
-minShelfLife         int            NOTNULL  Minimum Shelf Life Key
+*contHdr
+*contDtl
+*item
+*pack
+*lot
+*location
+*returnedQty
+*returnedUom
+*returnedTime
+*userKey
+*poReturnControl
+|
+*int
+*varchar(3)
+*varchar(5)
+*varchar(5)
+*varchar(10)
+*int
+*varchar(10)
+*varchar(20)
+*int
+*varchar(30)
+*varchar(10)
+*varchar(25)
+*varchar(10)
+*decimal
+*varchar(6)
+*datetime
+*varchar(8)
+*varchar(60)
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Return Line Key
+*Company Key
+*Branch Key
+*Warehouse Key
+*Purchase Order Key
+*Purchase Order Detail Key
+*Receipt Key
+*Container Header Key
+*Container Detail Key
+*Item Key
+*Pack Key
+*Lot Key
+*Location Key
+*Quantity Returned
+*Quantity Returned Unit of Measure
+*Returned Date/Time Value
+*User Key
+*Control Number
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wmPrintJobs===
+Holds sequence registers for preprinted labels.
+|
+*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
+|}
-wmItemInstruct
+{| border="1" cellpadding="2" valign="top" halign="left"
-company              varchar(2)     NOTNULL  Company Key
+!Column
-warehouse            varchar(4)     NOTNULL  Warehouse Key
+!Data Type
-item                 varchar(20)    NOTNULL  Item Key
+!Nullable
-pack                 varchar(8)     NOTNULL  Pack Key
+!Key Description
-context              int            NOTNULL  Context Key
+|-
-instruction          varchar(255)   NOTNULL  Instruction Text Value
+===wmReceiptReturn===
+Collects details of Purchase order returns.
+|
+*company
+*branch
+*warehouse
+*purchaseOrder
+*receiptCntrl
+*rma
+*item
+*pack
+*qty
+*track
+*reason
+*comment
+*userKey
+*createdate
+|
+*varchar(2)
+*varchar(4)
+*varchar(4)
+*varchar(10)
+*varchar(20)
+*varchar(20)
+*varchar(20)
+*varchar(6)
+*decimal
+*varchar(10)
+*varchar(10)
+*varchar(255)
+*varchar(8)
+*datetime
+|
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+|
+*Company Key
+*Branch Key
+*Warehouse Key
+*Purchase Order Key
+*Control Number
+*Return Merchandise Authorization Key
+*Item Key
+*Pack Key
+*Quantity
+*Container Header Key
+*Reason Code
+*Comment
+*User Key
+*Created On Date/Time Value
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wmReclassHist===
+Transactional history for Item Reclass transactions.
+|
+*company
+*warehouse
+*container
+*containerdetail
+*olditem
+*oldpack
+*oldproduct
+*oldqty
+*olduom
+*oldcontainertype
+*oldlot
+*newitem
+*newpack
+*newproduct
+*newqty
+*newuom
+*newcontainertype
+*newlot
+*createdate
+*username
+*debitAtfControl
+*creditAtfControl
+|
+*varchar(2)
+*varchar(4)
+*varchar(10)
+*int
+*varchar(20)
+*varchar(10)
+*varchar(20)
+*float
+*varchar(5)
+*varchar(10)
+*varchar(25)
+*varchar(20)
+*varchar(10)
+*varchar(20)
+*float
+*varchar(5)
+*varchar(10)
+*varchar(25)
+*datetime
+*varchar(8)
+*varchar(60)
+*varchar(60)
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NOTNULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Container Header Key
+*Container Detail Key
+*Original Item Key
+*Original Pack Key
+*Original Product Key
+*Original Quantity Value
+*Original Unit of Measure
+*Original Container Type
+*Original Lot Key
+*New Item Key
+*New Pack Key
+*New Product Key
+*New Quantity Value
+*New Unit of Measure
+*New Container Type
+*New Lot Key
+*Created On Date/Time Value
+*User Key
+*Debit ATF Control Number
+*Credit ATF Control Number
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
-wmLabelCrossRef
+===wmScaleDefinition===
-company              varchar(2)     NOTNULL  Company key
+Load cell setup.
-branch               varchar(4)     NOTNULL  Branch Key
+|
-deliverFrom          varchar(10)    NOTNULL  Deliver From Key
+*company
-labelKey             int            NOTNULL  Label Key
+*warehouse
+*scaleKey
+*scaleDescription
+*scaleAddress
+|
+*varchar(2)
+*varchar(4)
+*varchar(60)
+*varchar(128)
+*varchar(128)
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Scale Key
+*Scale Description Value
+*Scale Address Value
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wmStockMoveInt===
+Transaction history of ERP stock move interfaces
+|
+*company
+*warehouse
+*wms_conthdr_key
+*tolocation
+*fromlocation
+*sa_user_key
+*createdate
+*item
+*pack
+*quantity
+*uom
+*wms_eia_cntrl
+*reason
+*trans_date
+*lot
+|
+*varchar(2)
+*varchar(4)
+*varchar(10)
+*varchar(10)
+*varchar(10)
+*varchar(8)
+*datetime
+*varchar(20)
+*varchar(10)
+*float
+*varchar(6)
+*varchar(60)
+*varchar(14)
+*datetime
+*varchar(25)
+|
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+|
+*Company Key
+*Warehouse Key
+*Container Header Key
+*Destination Location
+*Source Location
+*User Key
+*Created On Date/Time Value
+*Item Key
+*Pack Key
+*Quantity
+*Unit of Measure
+*Control Number
+*Reason Code
+*Transaction Date/Time Value
+*Lot Key
+|}
-wmLabelElements
-labelKey             int            NOTNULL  Label Key
+{| border="1" cellpadding="2" valign="top" halign="left"
-elementKey           int            NOTNULL  Element Key
+!Column
-dataType             int            NOTNULL  Data Type Value
+!Data Type
-elementDescription   varchar(10)    NULL     Element Description Value
+!Nullable
-position             int            NOTNULL  Position Value
+!Key Description
-width                int            NOTNULL  Width Value
+|-
-uom                  varchar(2)     NULL     UOM Value
-decimalPosition      int            NOTNULL  Decimal Position Key
-mapsTo               varchar(20)    NULL     Maps To Key
-required             int            NOTNULL  Required Key
-lastModifiedBy       varchar(10)    NOTNULL  User Key
-lastModifiedOn       datetime       NULL     Last Modified Date/Time Value
+===wmTestHistory===
+History of QC test data collection.
+|
+*testKey
+*effectiveDate
+*sequence
+*item
+*pack
+*lot
+*sampleID
+*status
+*result
+*measured
+*measuredUOM
+*comments
+*transactionTime
+*tranactionUser
+|
+*varchar(10)
+*datetime
+*int
+*varchar(20)
+*varchar(10)
+*varchar(30)
+*varchar(20)
+*varchar(20)
+*varchar(60)
+*decimal(18,4)
+*varchar(2)
+*varchar(255)
+*datetime
+*varchar(10)
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NULL
+*NULL
+*NOTNULL
+*NULL
+|
+*Test Key
+*Effective Date/Time Value
+*Sequence Value
+*Item Key
+*Pack Key
+*Lot Key
+*Sample ID Value
+*Status Value
+*Result Value
+*Measured value
+*Unit Of Measure Value
+*Comment Value
+*Transaction Date/Time Value
+*User Key
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
-wmPickAllocation
+===wmUomConv===
-pickAllocKey         int            NOTNULL  Pick Allocation Key
+Warehouse level UOM conversions.
-companyKey           varchar(10)    NOTNULL  Company Key
+|
-warehouseKey         varchar(10)    NOTNULL  Warehouse Key
+*gl_cmp_key
-orderType            smallint       NOTNULL  Order Type Key
+*in_whs_key
-orderKey             varchar(30)    NOTNULL  Order Key
+*in_item_key
-orderLineKey         int            NOTNULL  Order Line Key
+*im_pack_key
-containerKey         varchar(10)    NOTNULL  Container Key
+*uom_from
-itemKey              varchar(20)    NOTNULL  Item Key
+*uom_to
-packKey              varchar(10)    NOTNULL  Pack Key
+*factor
-allocLotKey          varchar(30)    NOTNULL  Allocation Lot Key
+|
-allocQuantity        float          NOTNULL  Allocation Quantity Value
+*varchar(2)
-allocUOM             varchar(2)     NOTNULL  Allocation UOM Value
+*varchar(4)
-status               smallint       NOTNULL  Status Key
+*varchar(20)
-lastChangedBy        varchar(30)    NOTNULL  User Key
+*varchar(6)
-lastChangeDate       datetime       NOTNULL  Changed on Date/Time Value
+*varchar(10)
-createdBy            varchar(30)    NOTNULL  User Key
+*varchar(10)
-creationDate         datetime       NOTNULL  Created On Date Value
+*float
-lockCounter          int            NOTNULL  Lock Counter Value
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Item Key
+*Pack Key
+*UOM From Key
+*UOM To Key
+*Factor Key
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wmUserPrefs===
+Warehouse and User level software settings.
+|
+*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
+|}
-wmPrintJobs
+{| border="1" cellpadding="2" valign="top" halign="left"
-company              varchar(2)     NOTNULL  Company Key
+!Column
-warehouse            varchar(4)     NOTNULL  Warehouse Key
+!Data Type
-track                varchar(10)    NOTNULL  Tracking Key
+!Nullable
-numLabels            int            NOTNULL  Number of labels Value
+!Key Description
-printDoc             varchar(255)   NULL     Print Document Value
+|-
-printer              varchar(255)   NULL     Printer Value
-prePrint             int            NOTNULL  Pre print Value
-printSequence1       varchar(10)    NULL     Print Sequence 1 Value
-printSequence2       varchar(10)    NULL     Print Sequence 2 Value
-printSequence3       varchar(10)    NULL     Print Sequence 3 Value
+===wmWave===
+Wave picking header.
+|
+*company
+*warehouse
+*waveKey
+*createdOn
+*createdBy
+|
+*varchar(2)
+*varchar(4)
+*varchar(10)
+*datetime
+*varchar(10)
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Wave Key
+*Created on Date/Time Value
+*User Key
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
-wmRuleContext
+===wms_autohd_tbl===
-ruleContextKey       int            NOTNULL  Rule Context key
+Definition by item of timed and indefinite holds for receipts and production.
-companyKey           varchar(10)    NOTNULL  Company Key
+|
-warehouseKey         varchar(10)    NOTNULL  Warehouse Key
+*gl_cmp_key
-contextName          varchar(60)    NOTNULL  Context Name Value
+*in_whs_key
-contextType          smallint       NOTNULL  Context Type Value
+*in_item_key
-binKey               varchar(10)    NOTNULL  Bin Key
+*im_pack_key
-lastChangedBy        varchar(30)    NOTNULL  User Key
+*wms_autohd_hrs
-lastChangeDate       datetime       NOTNULL  Changed on Date/Time Value
+*context
-createdBy            varchar(30)    NOTNULL  User Key
+|
-creationDate         datetime       NOTNULL  Created on Date/Time Value
+*varchar(2)
-lockCounter          int            NOTNULL  Lock Counter
+*varchar(4)
+*varchar(30)
+*varchar(6)
+*int
+*varchar(10)
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Item Key
+*Pack Key
+*Autohold Length Hours Value
+*Context Value
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_bin_tbl===
+Definition of bin locations in a warehouse.
+|
+*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
+*can_mix_items
+*not_on_picklist
+*dont_trackvol
+|
+*varchar(3)
+*varchar(4)
+*varchar(10)
+*varchar(15)
+*float
+*float
+*float
+*varchar(10)
+*int
+*int
+*int
+*int
+*int
+*int
+*int
+|
+*NOTNULL
+*NOTNULL
+*NULL
+*NOTNULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*ERP 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 will accept a mix of items
+*Don't show bin contents in picklist
+*Don't calculate bin volume
+|}
-wmRuleContextLine
-ruleContextLineKey   int            NOTNULL  Rule Context Line Key
-ruleContextKey       int            NOTNULL  Rule Context Key
-rulePriority         smallint       NOTNULL  Rule Priority Value
-ruleMasterKey        int            NOTNULL  Rule Master Key
-sortOrder            smallint       NULL     Sort Order Value
-lastChangedBy        varchar(30)    NOTNULL  User Key
-lastChangeDate       datetime       NOTNULL  Changed on Date
-createdBy            varchar(30)    NOTNULL  User Key
-creationDate         datetime       NOTNULL  Created on Date
-lockCounter          int            NOTNULL  Lock Counter Value
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_bindtlst_tbl===
+Contains location of containers in the warehouse and the space remaining in bins.
+|
+*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
+*lastCount
+*not_on_picklist
+*dont_trackvol
+|
+*varchar(3)
+*varchar(4)
+*varchar(13)
+*varchar(10)
+*varchar(10)
+*float
+*float
+*float
+*float
+*float
+*int
+*varchar(30)
+*varchar(6)
+*varchar(25)
+*datetime
+*varchar(20)
+*varchar(10)
+*datetime
+*float
+*varchar(10)
+*int
+*int
+*float
+*float
+*datetime
+*int
+*int
+|
+*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
+*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
+*Counted On Date/Time Value
+*Don't show bin contents in picklist
+*Dont' calculate bin volume
+|}
-wmRuleMaster
+{| border="1" cellpadding="2" valign="top" halign="left"
-ruleMasterKey        int            NOTNULL  Rule Master Key
+!Column
-ruleName             varchar(60)    NOTNULL  Rule Name Value
+!Data Type
-ruleTable            varchar(30)    NULL     Rule Table Value
+!Nullable
-ruleColumn           varchar(30)    NULL     Rule Column Value
+!Key Description
-ruleIdentifier       varchar(30)    NULL     Rule ID Value
+|-
-lastChangedBy        varchar(30)    NOTNULL  User Key
-lastChangeDate       datetime       NOTNULL  Changed on Date Value
-createdBy            varchar(30)    NOTNULL  User Key
-creationDate         datetime       NOTNULL  Created on Date Value
-lockCounter          int            NOTNULL  Lock Counter Value
+===wms_case_tbl===
+Case number register by warehouse.
+|
+*gl_cmp_key
+*in_whs_key
+*wms_case_num
+*created_on
+*changed_on
+*created_by
+*changed_by
+*lock_count
+|
+*varchar(2)
+*varchar(4)
+*int
+*datetime
+*datetime
+*varchar(8)
+*varchar(8)
+*int
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Case Number Value
+*Created on Date
+*Changed on Date
+*User Key
+*User Key
+*Lock Counter Value
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
-wmScaleDefinition
+===wms_comments_tbl===
-company              varchar(2)     NOTNULL  Company Key
+List of valid comments by warehouse.
-warehouse            varchar(4)     NOTNULL  Warehouse Key
+|
-scaleKey             varchar(60)    NOTNULL  Scale Key
+*company
-scaleDescription     varchar(128)   NULL     Scale Description Value
+*warehouse
-scaleAddress         varchar(128)   NOTNULL  Scale Address Value
+*comments
+|
+*varchar(2)
+*varchar(4)
+*varchar(60)
+|
+*NULL
+*NULL
+*NULL
+|
+*Company Key
+*Warehouse Key
+*Comment Text
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
-wmTaskMaster
+===wms_contadj_tbl===
-taskMasterKey        int            NOTNULL  Task Master Key
+Transaction history of misc adjustments made to inventory.
-taskType             varchar(20)    NOTNULL  Task Type Value
+|
-taskName             varchar(30)    NOTNULL  Task Name Value
+*gl_cmp_key
-refLabel1            varchar(30)    NULL     Reference Label 1
+*in_whs_key
-refLabel2            varchar(30)    NULL     Reference Label 2
+*wms_conthdr_key
-refLabel3            varchar(30)    NULL     Reference Label 3
+*in_item_key
-lastChangedBy        varchar(30)    NOTNULL  User Key
+*im_pack_key
-lastChangeDate       datetime       NOTNULL  Changed On Date/Time Value
+*wms_contadj_qty
-createdBy            varchar(30)    NOTNULL  User Key
+*en_resn_key
-creationDate         datetime       NOTNULL  Created On Date/Time Value
+*sa_user_key
-lockCounter          int            NOTNULL  Lock Counter Value
+*wms_contadj_date
+*wms_contadj_cmt
+*wms_contdtl_key
+*wms_contcase_key
+*wms_contadj_cntrl
+|
+*varchar(3)
+*varchar(4)
+*varchar(10)
+*varchar(30)
+*varchar(6)
+*float
+*varchar(10)
+*varchar(10)
+*datetime
+*varchar(255)
+*int
+*varchar(60)
+*varchar(60)
+|
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NOTNULL
+*NULL
+*NULL
+|
+*Company Key
+*Warehouse Key
+*Tracking Key
+*Item Key
+*Pack Key
+*Adjusted Quantity Value
+*Reason For Adjustment Value
+*User Key
+*Transaction Date/Time Value
+*Container Adj Comment Value
+*Container Detail Key
+*Container Case Key
+*Container Adj Control Num Value
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_contcase_tbl===
+Case/sublot level inventory master.  Child of wms_contdtl_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
+*lot
+*allocation
+*pieces
+*lineKey
+|
+*varchar(2)
+*varchar(4)
+*varchar(10)
+*int
+*varchar(60)
+*float
+*int
+*datetime
+*datetime
+*datetime
+*varchar(8)
+*varchar(8)
+*int
+*int
+*float
+*varchar(25)
+*varchar(25)
+*int
+*int
+|
+*NOTNULL
+*NOTNULL
+*NULL
+*NULL
+*NOTNULL
+*NULL
+*NULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NULL
+*NULL
+*NULL
+|
+*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
+*Lot Key
+*Case Allocated Value
+*Per box Piece Count
+*Line Number
+|}
-wmTestHistory
+{| border="1" cellpadding="2" valign="top" halign="left"
-testKey              varchar(10)    NOTNULL  Test Key
+!Column
-effectiveDate        datetime       NOTNULL  Effective Date/Time Value
+!Data Type
-sequence             int            NOTNULL  Sequence Value
+!Nullable
-item                 varchar(20)    NOTNULL  Item Key
+!Key Description
-pack                 varchar(10)    NOTNULL  Pack Key
+|-
-lot                  varchar(30)    NOTNULL  Lot Key
-sampleID             varchar(20)    NOTNULL  Sample ID Value
-status               varchar(20)    NOTNULL  Status Value
-result               varchar(60)    NOTNULL  Result Value
-measured             decimal(18,4)  NULL     Measured value
-measuredUOM          varchar(2)     NULL     Unit Of Measure Value
-comments             varchar(255)   NULL     Comment Value
-transactionTime      datetime       NOTNULL  Transaction Date/Time Value
-tranactionUser       varchar(10)    NULL     User Key
+===wms_contdtl_tbl===
+Item/Pack/Lot level inventory master.  Child of wms_conthdr_tbl, parent of wms_contcase_tbl table.
+|
+*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(20)
+*float
+*int
+*float
+*varchar(255)
+*varchar(255)
+*varchar(255)
+*varchar(255)
+*varchar(255)
+*varchar(255)
+*varchar(255)
+*varchar(255)
+*varchar(255)
+*varchar(255)
+*float
+*float
+*float
+*float
+*float
+*datetime
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NOTNULL
+*NULL
+*NULL
+*NULL
+*NOTNULL
+*NULL
+*NULL
+*NOTNULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+|
+*Company Key
+*Warehouse Key
+*Tracking Key
+*Item Key
+*Pack Key
+*Product # (UPC code)
+*Item Description Value
+*Production Date/Time Value
+*Pull Date Value
+*Container Status Key
+*Item Quantity Value
+*Unit Of Measure Value
+*Lot Key
+*Pallet Allocated Value
+*Item Volume Value
+*Container Detail Key
+*Container Detail Catch Weight
+*User defined Parameter #1
+*User defined Parameter #2
+*User defined Parameter #3
+*User defined Parameter #4
+*User defined Parameter #5
+*User defined Parameter #6
+*User defined Parameter #7
+*User defined Parameter #8
+*User defined Parameter #9
+*User defined Parameter #10
+*User defined Parameter F1
+*User defined Parameter F2
+*User defined Parameter F3
+*User defined Parameter F4
+*User defined Parameter F5
+*Creation Date/Time Value
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
-wmUomConv
+===wms_context_tbl===
-gl_cmp_key           varchar(2)     NOTNULL  Company Key
+|
-in_whs_key           varchar(4)     NOTNULL  Warehouse Key
+*gl_cmp_key
-in_item_key          varchar(20)    NOTNULL  Item Key
+*in_whs_key
-im_pack_key          varchar(6)     NOTNULL  Pack Key
+*wms_conthdr_key
-uom_from             varchar(10)    NOTNULL  UOM From Key
+*wms_context_variety
-uom_to               varchar(10)    NOTNULL  UOM To Key
+*wms_context_linemtch
-factor               float          NOTNULL  Factor Key
+*wms_context_idfield
+*created_on
+*changed_on
+*created_by
+*changed_by
+*lock_count
+|
+*varchar(2)
+*varchar(4)
+*varchar(10)
+*varchar(10)
+*varchar(10)
+*varchar(4)
+*datetime
+*datetime
+*varchar(8)
+*varchar(8)
+*int
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NULL
+*NULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Tracking Key
+*Context Variety Value
+*Context Line Match Value
+*Context ID Field Value
+*Created on Date/Time Value
+*Changed on Date/Time Value
+*User Key
+*User Key
+*Lock Count Value
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_conthdr_tbl===
+Inventory master for container (pallet) level inventory.  Parent of wms_contdtl_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
+*lockCounter
+|
+*varchar(3)
+*varchar(4)
+*varchar(10)
+*varchar(10)
+*varchar(10)
+*varchar(15)
+*datetime
+*varchar(10)
+*datetime
+*varchar(8)
+*datetime
+*int
+*float
+*int
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*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
+*Lock Counter Value
+|}
-wmUserPrefs
+{| border="1" cellpadding="2" valign="top" halign="left"
-gl_cmp_key           varchar(2)     NOTNULL  Company Key
+!Column
-in_whs_key           varchar(4)     NOTNULL  Warehouse Key
+!Data Type
-user_key             varchar(8)     NOTNULL  User Key
+!Nullable
-pref_name            varchar(64)    NOTNULL  Preference Name Value
+!Key Description
-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
+===wms_contst_tbl===
+Valid inventory statuses
+|
+*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
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
-wmUserTask
+===wms_contty_tbl===
-userTaskKey          int            NOTNULL  User Task Key
+Definition of container types.
-userKey              varchar(8)     NOTNULL  User Key
+|
-companyKey           varchar(10)    NOTNULL  Company Key
+*gl_cmp_key
-warehouseKey         varchar(10)    NOTNULL  Warehouse Key
+*in_whs_key
-taskMasterKey        int            NOTNULL  Task Master Key
+*wms_contty_key
-taskNote             varchar(255)   NOTNULL  Task Note Value
+*wms_contty_height
-expectedStart        datetime       NULL     Expected Start Date/Time Value
+*wms_contty_depth
-expectedFinish       datetime       NULL     Expected End Date/Time Value
+*wms_contty_width
-actualStart          datetime       NULL     Actual Start Date/Time Value
+*wms_contty_lay
-actualFinish         datetime       NULL     Actual End Date/Time Value
+*wms_contty_case
-priority             smallint       NOTNULL  Priority Value
+*wms_contty_uom
-status               smallint       NOTNULL  Status Value
+*wms_contty_dftrtype
-refValue1            varchar(30)    NULL     Reference Value 1
+|
-refValue2            varchar(30)    NULL     Reference Value 2
+*varchar(3)
-refValue3            varchar(30)    NULL     Reference Value 3
+*varchar(4)
-assignedBy           varchar(10)    NOTNULL  User Key
+*varchar(10)
-lastChangedBy        varchar(30)    NOTNULL  User Key
+*float
-lastChangeDate       datetime       NOTNULL  Changed on Date/Time Value
+*float
-createdBy            varchar(30)    NOTNULL  User Key
+*float
-creationDate         datetime       NOTNULL  Created on Date/Time Value
+*int
-lockCounter          int            NOTNULL  Lock Counter Value
+*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"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_contxf_tbl===
+Maps Item/Packs to a container type.
+|
+*gl_cmp_key
+*in_whs_key
+*wms_contty_key
+*in_item_key
+*im_pack_key
+*wms_desc
+*so_prod_key
+*wms_active_qty
+*wms_hold_qty
+*toleranceOver
+*wms_contxf_pseq
+|
+*varchar(3)
+*varchar(4)
+*varchar(10)
+*varchar(30)
+*varchar(6)
+*varchar(60)
+*varchar(20)
+*float
+*float
+*float
+*int
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NOTNULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Container Type Value
+*Item Key
+*Pack Key
+*Item Description Value
+*Adage Sales Order Production Key
+*Container Active Quantity
+*Container Hold Quantity
+*Tolerance Over Value
+*Container Cross Reference Seq Key
+|}
-wmWave
+{| border="1" cellpadding="2" valign="top" halign="left"
-company              varchar(2)     NOTNULL  Company Key
+!Column
-warehouse            varchar(4)     NOTNULL  Warehouse Key
+!Data Type
-waveKey              varchar(10)    NOTNULL  Wave Key
+!Nullable
-createdOn            datetime       NULL     Created on Date/Time Value
+!Key Description
-createdBy            varchar(10)    NOTNULL  User Key
+|-
+===wms_counter_tbl===
+Generic counter table.
+|
+*wms_counter_type
+*wms_counter_idx
+|
+*smallint
+*int
+|
+*NOTNULL
+*NOTNULL
+|
+*Counter Name Value
+*Current Counter Number Value
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
-wms_autohd_tbl
+===wms_ctwght_tbl===
-gl_cmp_key           varchar(2)     NOTNULL  Company Key
+Defines the setup for catchweight or serial tracked inventory.
-in_whs_key           varchar(4)     NOTNULL  Warehouse Key
+|
-in_item_key          varchar(30)    NOTNULL  Item Key
+*gl_cmp_key
-im_pack_key          varchar(6)     NOTNULL  Pack Key
+*in_whs_key
-wms_autohd_hrs       int            NULL     Autohold Length Hours Value
+*in_item_key
-context              varchar(10)    NOTNULL  Context Value
+*im_pack_key
+*wms_ctwght_minwgt
+*wms_ctwght_maxwgt
+*wms_ctwght_tare
+*wms_ctwght_scc
+*upc_key
+*ucc128_item
+*created_on
+*changed_on
+*created_by
+*changed_by
+*lock_count
+*wms_ctwght_netwt
+*wms_ctwght_backdt
+*wms_ctwght_sell
+|
+*varchar(2)
+*varchar(4)
+*varchar(20)
+*varchar(6)
+*float
+*float
+*float
+*varchar(40)
+*varchar(60)
+*varchar(6)
+*datetime
+*datetime
+*varchar(8)
+*varchar(8)
+*int
+*float
+*int
+*int
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Item Key
+*Pack Key
+*Catch Weight Minimum Tolerance
+*Catch Weight Maximum Tolerance
+*Catch Weight Tare Weight Value
+*Catch Weight SCC Value
+*UPC Key
+*UCC 128 Item
+*Created on Date/Time Value
+*Changed on Date/Time Value
+*User Key
+*User Key
+*Lock Count Value
+*Catch weight Net Weight Value
+*Catch Weight Back Date
+*Catch Weight Sell Value
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_custpull_tbl===
+Days of shelf life required for a customer when shipping.
+|
+*gl_cmp_key
+*in_whs_key
+*ap_cust_key
+*wms_custpull_puldt
+|
+*varchar(3)
+*varchar(4)
+*varchar(10)
+*int
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+|
+*Company Key
+*Warehouse Key
+*Customer Key
+*Customer Pull Date Value
+|}
-wms_bin_tbl
+{| border="1" cellpadding="2" valign="top" halign="left"
-gl_cmp_key           varchar(3)     NOTNULL  Company Key
+!Column
-in_whs_key           varchar(4)     NOTNULL  Warehouse Key
+!Data Type
-in_locn_key          varchar(10)    NULL     Location Key
+!Nullable
-wms_bin_key          varchar(15)    NOTNULL  Bin Key
+!Key Description
-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
+===wms_erpint_tbl===
+|
+*gl_cmp_key
+*in_whs_key
+*wms_erpint_type
+*wms_erpint_start
+*wms_erpint_pid
+|
+*varchar(3)
+*varchar(4)
+*varchar(30)
+*datetime
+*int
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*ERP Interface Type Value
+*ERP Interface Start Value
+*ERP Interface Part ID Value
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
-wms_bincnt_tbl
+===wms_except_tbl===
-gl_cmp_key           varchar(3)     NULL     Company Key
+Logs users exceptions, like not following pick or putaway recommendations.
-in_whs_key           varchar(4)     NULL     Warehouse Key
+|
-in_cycnt_key         int            NULL     Cycle count key
+*gl_cmp_key
-wms_bin_key          varchar(15)    NULL     Bin Key
+*in_whs_key
-wms_bincnt_stat      int            NULL     Bin count status Value
+*wms_tran_key
-sa_user_key          varchar(8)     NULL     User Key
+*wms_conthdr_key
-wms_bincnt_crtdt     datetime       NULL     Counted on Date/Time Value
+*wms_except_sbin
-in_locn_key          varchar(10)    NULL     Location Key
+*wms_except_ubin
-in_item_key          varchar(10)    NULL     Item Key
+*wms_except_sqty
-im_pack_key          varchar(10)    NULL     Pack Key
+*wms_except_uqty
+*wms_except_note
+*sa_user_key
+*wms_except_crtdt
+|
+*varchar(3)
+*varchar(4)
+*varchar(10)
+*varchar(10)
+*varchar(15)
+*varchar(15)
+*float
+*float
+*varchar(255)
+*varchar(8)
+*datetime
+|
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+|
+*Company Key
+*Warehouse Key
+*Transaction Key
+*Tracking Key
+*Bin Key
+*Bin Key
+*System Expected Quantity Value
+*User Entered Quantity Value
+*Exception Explanation Value
+*User Key
+*Exception Creation Date/Time
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_group_tbl===
+Defines groupings of containers.
+|
+*gl_cmp_key
+*in_whs_key
+*wms_group_key
+|
+*varchar(3)
+*varchar(4)
+*int
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Group Key
+|}
-wms_bindtlst_tbl
+{| border="1" cellpadding="2" valign="top" halign="left"
-gl_cmp_key           varchar(3)     NOTNULL  Company Key
+!Column
-in_whs_key           varchar(4)     NOTNULL  Warehouse Key
+!Data Type
-wms_bin_key          varchar(13)    NOTNULL  Bin Key
+!Nullable
-wms_zone_key         varchar(10)    NULL     Zone Key
+!Key Description
-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
+===wms_kit_tbl===
+Formulations for kit building.
+|
+*gl_cmp_key
+*in_whs_key
+*wms_kititem_key
+*wms_kitpack_key
+*in_item_key
+*im_pack_key
+*wms_kit_qty
+*wms_kit_uom
+*created_by
+*created_on
+*changed_by
+*changed_on
+*lock_count
+|
+*varchar(2)
+*varchar(4)
+*varchar(20)
+*varchar(6)
+*varchar(20)
+*varchar(6)
+*float
+*varchar(2)
+*varchar(8)
+*datetime
+*varchar(8)
+*datetime
+*int
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Kit Item Key
+*Kit Pack Key
+*Item Key
+*Pack Key
+*Kit Quantity Value
+*Kit UOM Value
+*Created by Date/Time Value
+*Created on Date/Time Value
+*User Key
+*Changed on Date/Time Value
+*Lock Counter Key
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
-wms_case_tbl
+===wms_lhold_tbl===
-gl_cmp_key           varchar(2)     NOTNULL  Company Key
+Transactional history for lot holds.
-in_whs_key           varchar(4)     NOTNULL  Warehouse Key
+|
-wms_case_num         int            NOTNULL  Case Number Value
+*gl_cmp_key
-created_on           datetime       NOTNULL  Created on Date
+*in_whs_key
-changed_on           datetime       NOTNULL  Changed on Date
+*sa_user_key
-created_by           varchar(8)     NOTNULL  User Key
+*wms_lhold_lot
-changed_by           varchar(8)     NOTNULL  User Key
+*wms_lhold_bgdt
-lock_count           int            NOTNULL  Lock Counter Value
+*wms_lhold_eddt
+*wms_lhold_cmt
+*wms_lhold_trdt
+|
+*varchar(3)
+*varchar(4)
+*varchar(8)
+*varchar(25)
+*datetime
+*datetime
+*varchar(255)
+*datetime
+|
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+|
+*Company Key
+*Warehouse Key
+*User Key
+*Lot Hold Lot Value
+*Beginning Hold Date/Time Value
+*Ending Hold Date/Time Value
+*Comment Value
+*Date Lot Placed On Hold Value
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_load_tbl===
+Contains extended information about a shipment load.  Also used for BOL generation.
+|
+*gl_cmp_key
+*so_brnch_key
+*so_hdr_key
+*wms_load_bol
+*wms_load_trailer
+*wms_load_seal
+*wms_load_chep
+*wms_load_shpdt
+*in_towhs_key
+*carrier
+*prePaidFreight
+*status
+*loadKey
+*temp_recorder
+*trl_temp_start
+*set_trl_at
+*set_trl_for_hrs
+*trl_temp_for_trip
+*pallets_in
+*po_num
+|
+*varchar(2)
+*varchar(4)
+*varchar(10)
+*varchar(25)
+*varchar(25)
+*varchar(45)
+*int
+*datetime
+*varchar(4)
+*varchar(10)
+*float
+*varchar(10)
+*varchar(10)
+*varchar(25)
+*varchar(5)
+*varchar(5)
+*varchar(5)
+*varchar(5)
+*varchar(5)
+*varchar(25)
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+|
+*Company key
+*Branch Key
+*Tracking Key
+*Load BOL Value
+*Load Trailer Value
+*Load Seal Value
+*Load Chep Value
+*Load Ship Date/Time Value
+*To WHS Key
+*Carrier Value
+*Pre Paid Freight Value
+*Status Value
+*Load Key
+*Thermometer ID Number
+*Temp of Trailer at Start Of Loading Process
+*Temp to Set Trailer At
+*Number of Hours to Set Temp For
+*Temp Trailer Should Maintain For Rest of Trip After set_trl_for_hrs Hours
+*Number of Empty Pallets on Truck/Trailer When It Arrives
+*PO Number
+|}
-wms_contadj_tbl
+{| border="1" cellpadding="2" valign="top" halign="left"
-gl_cmp_key           varchar(3)     NULL     Company Key
+!Column
-in_whs_key           varchar(4)     NULL     Warehouse Key
+!Data Type
-wms_conthdr_key      varchar(10)    NULL     Tracking Key
+!Nullable
-in_item_key          varchar(30)    NULL     Item Key
+!Key Description
-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
+===wms_loadnm_tbl===
+Register for load numbers.
+|
+*gl_cmp_key
+*so_brnch_key
+*so_hdr_key
+*wms_loadnm_key
+|
+*varchar(2)
+*varchar(4)
+*varchar(10)
+*int
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+|
+*Company Key
+*Branch Key
+*Tracking Key
+*Load Name Key
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
-wms_contcase_tbl
+===wms_lothist_tbl===
-gl_cmp_key           varchar(2)     NOTNULL  Company Key
+Transaction history for system.
-in_whs_key           varchar(4)     NOTNULL  Warehouse Key
+|
-wms_conthdr_key      varchar(10)    NULL     Tracking Key
+*gl_cmp_key
-wms_contdtl_key      int            NULL     Tracking Detail Key
+*in_whs_key
-wms_contcase_key     varchar(60)    NOTNULL  Tracking Case Key
+*wms_conthdr_key
-wms_contcase_ctwgt   float          NULL     Tracking Catch Weight Value
+*wms_tran_type
-in_sublot_key        int            NULL     Adage SubLot Key
+*wms_tran_key
-wms_contcase_prddt   datetime       NOTNULL  Case Production Date Value
+*in_lot_key
-created_on           datetime       NOTNULL  Created On Date Value
+*sa_user_key
-changed_on           datetime       NOTNULL  Changed On Date Value
+*wms_lothist_crtdt
-created_by           varchar(8)     NOTNULL  User Key
+*wms_lothist_qty
-changed_by           varchar(8)     NOTNULL  User Key
+*wms_lothist_uom
-lock_count           int            NOTNULL  Lock Count Value
+*wms_contdtl_key
-wms_contcase_stat    int            NOTNULL  Container Status Value
+*comment_key
-wms_contcase_acwgt   float          NOTNULL  Container Actual Weight Value
+|
+*varchar(3)
+*varchar(4)
+*varchar(10)
+*varchar(15)
+*varchar(20)
+*varchar(25)
+*varchar(8)
+*datetime
+*float
+*varchar(2)
+*int
+*varchar(255)
+|
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NOTNULL
+*NULL
+|
+*Company Key
+*Warehouse Key
+*Tracking Key
+*Transaction Type Key
+*Transaction Key
+*Lot Key
+*User Key
+*Date of transaction Value
+*Lot History Quantity Value
+*Unit Of Measure Value
+*Container detail Key
+*Comment Value
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_outint_tbl===
+Transaction history for shipments.
+|
+*gl_cmp_key
+*so_brnch_key
+*so_hdr_key
+*so_prod_key
+*wms_conthdr_key
+*wms_outint_qty
+*wms_outint_uom
+*in_lot_key
+*wms_outint_error
+*sa_user_key
+*wms_outint_crtdt
+*wms_outint_type
+*wms_outdtl_key
+*in_whs_key
+*in_towhs_key
+*wms_contdtl_key
+*wms_whistle_recdt
+*in_item_key
+*im_pack_key
+*wms_outint_control
+|
+*varchar(3)
+*varchar(4)
+*varchar(10)
+*varchar(30)
+*varchar(10)
+*float
+*varchar(2)
+*varchar(25)
+*varchar(255)
+*varchar(8)
+*datetime
+*int
+*int
+*varchar(4)
+*varchar(4)
+*smallint
+*datetime
+*varchar(20)
+*varchar(6)
+*varchar(60)
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NOTNULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+|
+*Company Key
+*Branch key
+*Order Key
+*Product Key
+*Tracking Key
+*Quantity Value
+*Unit of Measure Value
+*Lot Key
+*Status Value
+*User Key
+*Date/Time Stamp Value
+*Type of Transaction Value
+*Out-Int Detail Key
+*Warehouse Key
+*To WHS Key
+*Container Detail Key
+*Whistle Receive Date/Time
+*Item Key
+*Pack Key
+*Outint Control Key
+|}
-wms_contdtl_tbl
+{| border="1" cellpadding="2" valign="top" halign="left"
-gl_cmp_key           varchar(3)     NOTNULL  Company Key
+!Column
-in_whs_key           varchar(4)     NOTNULL  Warehouse Key
+!Data Type
-wms_conthdr_key      varchar(10)    NOTNULL  Tracking Key
+!Nullable
-in_item_key          varchar(30)    NULL     Item Key
+!Key Description
-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
+===wms_piint_tbl===
+Transaction history for production issues.
+|
+*wms_piint_error
+*gl_cmp_key
+*sf_plant_key
+*in_whs_key
+*in_locn_key
+*pm_shop_key
+*pm_shop_ordtp
+*sf_opseq_key
+*wms_piint_bqty
+*wms_piint_sqty
+*wms_piint_uom
+*sa_user_key
+*wms_piint_crdt
+*in_item_key
+*im_pack_key
+*wms_conthdr_key
+*in_lot_key
+*wms_contdtl_puldt
+*wms_piint_control
+*tranKey
+*wms_contdtl_key
+*pm_matl_key
+*originTrack
+*wms_line_key
+|
+*varchar(255)
+*varchar(3)
+*varchar(10)
+*varchar(4)
+*varchar(10)
+*varchar(10)
+*varchar(1)
+*int
+*float
+*float
+*varchar(2)
+*varchar(8)
+*datetime
+*varchar(20)
+*varchar(6)
+*varchar(10)
+*varchar(25)
+*datetime
+*varchar(60)
+*int
+*int
+*int
+*varchar(10)
+*varchar(3)
+|
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NOTNULL
+|
+*Message Value
+*Company Key
+*Plant Key
+*Warehouse Key
+*Location Key
+*Production Order Key
+*Order Type Value
+*Routing sequence
+*Batch Quantity Value
+*Scrapped Quantity Value
+*Unit of Measure
+*User Key
+*Prod Issue Create Date Value
+*Item Key
+*Pack Key
+*Tracking Key
+*Lot Key
+*Container Pull Date/Time
+*Production Issue Control Key
+*Transaction Key
+*Container Detail Key
+*PM Material Key
+*Original Tracking Key
+*Line Key
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
-wms_context_tbl
+===wms_pmint_tbl===
-gl_cmp_key           varchar(2)     NOTNULL  Company Key
+Transaction history for production reports.
-in_whs_key           varchar(4)     NOTNULL  Warehouse Key
+|
-wms_conthdr_key      varchar(10)    NOTNULL  Tracking Key
+*wms_pmint_error
-wms_context_variety  varchar(10)    NULL     Context Variety Value
+*gl_cmp_key
-wms_context_linemtch varchar(10)    NULL     Context Line Match Value
+*sf_plant_key
-wms_context_idfield  varchar(4)     NULL     Context ID Field Value
+*in_whs_key
-created_on           datetime       NOTNULL  Created on Date/Time Value
+*pm_shop_key
-changed_on           datetime       NOTNULL  Changed on Date/Time Value
+*pm_shop_ordtp
-created_by           varchar(8)     NOTNULL  User Key
+*wms_pmint_bqty
-changed_by           varchar(8)     NOTNULL  User Key
+*wms_pmint_sqty
-lock_count           int            NOTNULL  Lock Count Value
+*wms_pmint_uom
+*sa_user_key
+*wms_pmint_crdt
+*in_item_key
+*im_pack_key
+*wms_conthdr_key
+*wms_contdtl_key
+*in_lot_key
+*wms_pmint_control
+*pieces
+|
+*varchar(255)
+*varchar(3)
+*varchar(10)
+*varchar(4)
+*varchar(10)
+*varchar(1)
+*float
+*float
+*varchar(2)
+*varchar(8)
+*datetime
+*varchar(20)
+*varchar(6)
+*varchar(10)
+*int
+*varchar(25)
+*varchar(50)
+*int
+|
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NULL
+*NULL
+|
+*Message Value
+*Company Key
+*Plant Key
+*Warehouse Key
+*Order Key
+*Shop Order Type Key
+*PM Batch Quantity Value
+*PM Scrapped Quantity Value
+*Unit of Measure Value
+*User Key
+*PM Transaction Date/Time
+*Item Key
+*Pack Key
+*Container Header Key
+*Container Detail Key
+*In Lot Key
+*PM Control Key
+*Per Box Piece Count
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_pmintdtl_tbl===
+Transaction history for production reports of catchweight / serial tracked inventory.
+|
+*gl_cmp_key
+*sf_plant_key
+*in_whs_key
+*pm_shop_key
+*wms_conthdr_key
+*wms_contdtl_key
+*wms_contcase_key
+*in_sublot_key
+*wms_contcase_ctwgt
+*wms_contcase_acwgt
+*wms_contcase_prddt
+|
+*varchar(2)
+*varchar(4)
+*varchar(4)
+*varchar(10)
+*varchar(10)
+*int
+*varchar(60)
+*int
+*float
+*float
+*datetime
+|
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+|
+*Company Key
+*Plant Key
+*Warehouse Key
+*Order Key
+*Tracking Key
+*Container Detail Key
+*Containe Case Key
+*Sub Lot Key
+*Case Catchweight Value
+*Case Actual Weight Value
+*Case Production Date/Time
+|}
-wms_conthdr_tbl
+{| border="1" cellpadding="2" valign="top" halign="left"
-gl_cmp_key           varchar(3)     NOTNULL  Company Key
+!Column
-in_whs_key           varchar(4)     NOTNULL  Warehouse Key
+!Data Type
-wms_conthdr_key      varchar(10)    NOTNULL  Tracking Key
+!Nullable
-wms_contst_key       varchar(10)    NULL     Container Status Value
+!Key Description
-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
+===wms_point_tbl===
+Transactional history of purchase order receipts.
+|
+*gl_cmp_key
+*so_brnch_key
+*in_whs_key
+*wms_conthdr_key
+*wms_contdtl_puldt
+*po_hdr_key
+*in_item_key
+*im_pack_key
+*wms_point_qty
+*wms_point_uom
+*in_lot_key
+*wms_point_bol
+*wms_point_error
+*sa_user_key
+*wms_point_crtdt
+*po_dtl_key
+*in_locn_key
+*wms_contdtl_key
+*wms_point_control
+|
+*varchar(3)
+*varchar(4)
+*varchar(4)
+*varchar(10)
+*datetime
+*varchar(10)
+*varchar(30)
+*varchar(6)
+*float
+*varchar(6)
+*varchar(25)
+*varchar(20)
+*varchar(255)
+*varchar(8)
+*datetime
+*smallint
+*varchar(10)
+*int
+*varchar(60)
+|
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NOTNULL
+*NULL
+|
+*Company Key
+*Branch Key
+*Warehouse Key
+*Tracking Key
+*Pull date
+*Order Key
+*Item Key
+*Pack Key
+*Quantity Received Value
+*Unit Of Measure Value
+*Lot Key
+*Bill of Lading Value
+*Message Value
+*User Key
+*Transaction Date/Time Value
+*Production Order Detail Key
+*Location Key
+*Container Detail Key
+*Point Control
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
-wms_contst_tbl
+===wms_print_tbl===
-gl_cmp_key           varchar(3)     NOTNULL  Company Key
+Printer definition.
-in_whs_key           varchar(4)     NOTNULL  Warehouse Key
+|
-wms_contst_key       varchar(10)    NOTNULL  Container Status Value
+*gl_cmp_key
-wms_contst_desc      varchar(60)    NULL     Container Description Value
+*in_whs_key
-wms_contst_type      varchar(10)    NULL     Container Type Value
+*wms_print_key
-wms_contst_reldt     varchar(8)     NULL     Container Release Date Value
+*wms_print_desc
-wms_contst_relby     varchar(8)     NULL     Container Release By Date Value
+*wms_print_def
+*pr_rotate_key
+|
+*varchar(3)
+*varchar(4)
+*varchar(100)
+*varchar(100)
+*int
+*float
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Printer Name Value
+*Printer Description Value
+*Printer Definition Value
+*Print Rotate Value
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_pultol_tbl===
+Number of days to consider inventory as the same age.
+|
+*gl_cmp_key
+*in_whs_key
+*in_item_key
+*im_pack_key
+*wms_pultol_tol
+|
+*varchar(3)
+*varchar(4)
+*varchar(30)
+*varchar(6)
+*int
+|
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+|
+*Company Key
+*Warehouse Key
+*Item Key
+*Pack Key
+*Pull Date Tolerance Value
+|}
-wms_contty_tbl
+{| border="1" cellpadding="2" valign="top" halign="left"
-gl_cmp_key           varchar(3)     NOTNULL  Company Key
+!Column
-in_whs_key           varchar(4)     NOTNULL  Warehouse Key
+!Data Type
-wms_contty_key       varchar(10)    NOTNULL  Container Type Value
+!Nullable
-wms_contty_height    float          NULL     Container Height Value
+!Key Description
-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
+===wms_recper_tbl===
+Date of last ERP reconciliation.
+|
+*gl_cmp_key
+*in_whs_key
+*wms_recbgn_key
+|
+*varchar(3)
+*varchar(4)
+*datetime
+|
+*NOTNULL
+*NOTNULL
+*NULL
+|
+*Company Key
+*Warehouse Key
+*Last ERP Reconciliation Date
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_rma_tbl===
+Whistle RMA information.
+|
+*gl_cmp_key
+*so_brnch_key
+*so_rthdr_key
+*so_hdr_key
+*so_resn_code
+*sa_user_key
+*wms_rma_crtdt
+|
+*varchar(2)
+*varchar(4)
+*varchar(10)
+*varchar(10)
+*varchar(11)
+*varchar(8)
+*datetime
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NULL
+|
+*Company Key
+*Branch Key
+*Sales Order Return Header Key
+*Sales Order Header Key
+*Sales Order Reason Code
+*User Key
+*Created On Date/Time Value
+|}
-wms_contxf_tbl
+{| border="1" cellpadding="2" valign="top" halign="left"
-gl_cmp_key           varchar(3)     NOTNULL  Company Key
+!Column
-in_whs_key           varchar(4)     NOTNULL  Warehouse Key
+!Data Type
-wms_contty_key       varchar(10)    NOTNULL  Container Type Value
+!Nullable
-in_item_key          varchar(30)    NOTNULL  Item Key
+!Key Description
-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
+===wms_screen_tbl===
+Valid screens for a warehouse.
+|
+*gl_cmp_key
+*in_whs_key
+*wms_screen_key
+|
+*varchar(3)
+*varchar(4)
+*varchar(20)
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Screen Name Value
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
-wms_counter_tbl
+===wms_sectmpl_tbl===
-wms_counter_type     smallint       NOTNULL  Counter Name Value
+Security template definition.
-wms_counter_idx      int            NOTNULL  Current Counter Number Value
+|
+*gl_cmp_key
+*in_whs_key
+*wms_sectmpl_key
+*wms_screen_key
+*wms_secure_mode
+|
+*varchar(3)
+*varchar(4)
+*varchar(20)
+*varchar(20)
+*int
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+|
+*Company Key
+*Warehouse Key
+*Security Template Name Key
+*Screen Name Key
+*Security Mode Value
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_secure_tbl===
+Users security rights.
+|
+*gl_cmp_key
+*in_whs_key
+*sa_user_key
+*wms_screen_key
+*wms_secure_mode
+|
+*varchar(3)
+*varchar(4)
+*varchar(8)
+*varchar(20)
+*int
+|
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+|
+*Company Key
+*Warehouse Key
+*User Key
+*Screen Name Key
+*Security Mode Value
+|}
-wms_ctwght_tbl
-gl_cmp_key           varchar(2)     NOTNULL  Company Key
-in_whs_key           varchar(4)     NOTNULL  Warehouse Key
-in_item_key          varchar(20)    NOTNULL  Item Key
-im_pack_key          varchar(6)     NOTNULL  Pack Key
-wms_ctwght_minwgt    float          NOTNULL  Catch Weight Minimum Tolerance
-wms_ctwght_maxwgt    float          NOTNULL  Catch Weight Maximum Tolerance
-wms_ctwght_tare      float          NOTNULL  Catch Weight Tare Weight Value
-wms_ctwght_scc       varchar(40)    NULL     Catch Weight SCC Value
-upc_key              varchar(60)    NOTNULL  UPC Key
-ucc128_item          varchar(6)     NOTNULL  UCC 128 Item
-created_on           datetime       NOTNULL  Created on Date/Time Value
-changed_on           datetime       NOTNULL  Changed on Date/Time Value
-created_by           varchar(8)     NOTNULL  User Key
-changed_by           varchar(8)     NOTNULL  User Key
-lock_count           int            NOTNULL  Lock Count Value
-wms_ctwght_netwt     float          NOTNULL  Catch weight Net Weight Value
-wms_ctwght_backdt    int            NULL     Catch Weight Back Date
-wms_ctwght_sell      int            NOTNULL  Catch Weight Sell Value
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_track_tbl===
+Register for container tracking numbers.
+|
+*gl_cmp_key
+*in_whs_key
+*wms_track_key
+|
+*varchar(3)
+*varchar(4)
+*int
+|
+*NULL
+*NULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Tracking Number Key
+|}
-wms_custpull_tbl
+{| border="1" cellpadding="2" valign="top" halign="left"
-gl_cmp_key           varchar(3)     NOTNULL  Company Key
+!Column
-in_whs_key           varchar(4)     NOTNULL  Warehouse Key
+!Data Type
-ap_cust_key          varchar(10)    NOTNULL  Customer Key
+!Nullable
-wms_custpull_puldt   int            NULL     Customer Pull Date Value
+!Key Description
+|-
+===wms_user_tbl===
+Extended user information, default printer and language.
+|
+*gl_cmp_key
+*in_whs_key
+*sa_user_key
+*wms_print_key
+*wms_user_lang
+|
+*varchar(3)
+*varchar(4)
+*varchar(8)
+*varchar(100)
+*varchar(20)
+|
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+|
+*Company Key
+*Warehouse Key
+*User Key
+*Default Printer Value
+*User Language Key
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
-wms_cycnt_tbl
+===wms_usercols_tbl===
-gl_cmp_key           varchar(3)     NULL     Company Key
+Metadata for user columns in wms_contdtl_tbl table.
-in_whs_key           varchar(4)     NULL     Warehouse Key
+|
-wms_conthdr_key      varchar(10)    NULL     Tracking Key
+*gl_cmp_key
-in_cycnt_key         varchar(10)    NULL     Cycle Count Key
+*in_whs_key
-wms_cycnt_entlv      varchar(10)    NULL     Cycle Count Entity Level Key
+*wms_table_key
-wms_cycnt_ent        varchar(20)    NULL     Cycle Count Entity Key
+*wms_col_key
-wms_cycnt_stat       varchar(10)    NULL     Cycle Count Status Value
+*wms_col_name
-wms_cycnt_ent2       varchar(20)    NULL     Cycle Count Entity 2 Key
+*wms_col_shortname
+*wms_col_type
+*wms_col_default
+*wms_col_min
+*wms_col_max
+*wms_col_req
+*wms_item_type
+*wms_valid_sql
+*wms_ui_type
+*created_on
+*changed_on
+*created_by
+*changed_by
+*lock_count
+|
+*varchar(2)
+*varchar(4)
+*varchar(20)
+*varchar(20)
+*varchar(20)
+*varchar(5)
+*varchar(10)
+*varchar(26)
+*varchar(26)
+*varchar(26)
+*smallint
+*varchar(20)
+*text
+*smallint
+*datetime
+*datetime
+*varchar(8)
+*varchar(8)
+*int
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Table Key
+*New Column Database Key
+*Column Common Name
+*Short Name Value
+*Column Type Value
+*Column Default Value
+*Column Minimum Tolerance Value
+*Column Maximum Tolerance Value
+*Column Required Value
+*Item Type Key
+*SQL Text Value
+*UI Parameter Type Key
+*Created On Date/Time
+*Changed On Date/Time
+*User Key
+*User Key
+*Lock Counter
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
-wms_erpint_tbl
+===wms_vndpull_tbl===
-gl_cmp_key           varchar(3)     NOTNULL  Company Key
+Minimum number of days of shelf life to allow for receipt of an item.
-in_whs_key           varchar(4)     NOTNULL  Warehouse Key
+|
-wms_erpint_type      varchar(30)    NOTNULL  ERP Interface Type Value
+*gl_cmp_key
-wms_erpint_start     datetime       NOTNULL  ERP Interface Start Value
+*in_whs_key
-wms_erpint_pid       int            NOTNULL  ERP Interface Part ID Value
+*en_vend_key
+*wms_vndpull_puldt
+|
+*varchar(3)
+*varchar(4)
+*varchar(10)
+*int
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+|
+*Company Key
+*Warehouse Key
+*Vendor Key
+*Vendor Pull Date Value
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_wtint_tbl===
+Transaction history for warehouse transfer receipts.
+|
+*gl_cmp_key
+*so_brnch_key
+*wms_conthdr_key
+*wms_contdtl_puldt
+*wt_hdr_key
+*in_item_key
+*im_pack_key
+*wms_wtint_qty
+*wms_wtint_uom
+*in_lot_key
+*wms_wtint_bol
+*wms_wtint_error
+*sa_user_key
+*wms_wtint_crtdt
+*wms_wtint_frwhs
+*wt_dtl_key
+*in_whs_key
+*in_locn_key
+*wms_contdtl_key
+*wms_wtint_control
+|
+*varchar(3)
+*varchar(4)
+*varchar(10)
+*datetime
+*varchar(10)
+*varchar(30)
+*varchar(6)
+*float
+*varchar(6)
+*varchar(25)
+*varchar(20)
+*varchar(255)
+*varchar(8)
+*datetime
+*varchar(4)
+*smallint
+*varchar(4)
+*varchar(10)
+*int
+*varchar(60)
+|
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NOTNULL
+*NULL
+*NULL
+*NOTNULL
+*NULL
+|
+*Company Key
+*Branch Key
+*Tracking Key
+*Item Pull Date
+*Warehouse Transfer Header Key
+*Item Key
+*Packing Key
+*WT Quantity Value
+*Unit Of Measur Value
+*Lot Key
+*WT Bill of Lading Value
+*WT Error Message Value
+*User Key
+*WT Creation Date/Time
+*WT From Warehouse Key
+*WT Detail Key
+*Warehouse Key
+*In Location Key
+*Container Detail Key
+*ERP Control Key
+|}
-wms_except_tbl
+{| border="1" cellpadding="2" valign="top" halign="left"
-gl_cmp_key           varchar(3)     NULL     Company Key
+!Column
-in_whs_key           varchar(4)     NULL     Warehouse Key
+!Data Type
-wms_tran_key         varchar(10)    NULL     Transaction Key
+!Nullable
-wms_conthdr_key      varchar(10)    NULL     Tracking Key
+!Key Description
-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
+===wms_zone_tbl===
+Maps bins to picking and putaway zones.
+|
+*gl_cmp_key
+*in_whs_key
+*wms_zone_key
+*wms_bin_key
+|
+*varchar(3)
+*varchar(4)
+*varchar(10)
+*varchar(15)
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Zone Key
+*Bin Key
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
-wms_group_tbl
+===wms_zonexf_tbl===
-gl_cmp_key           varchar(3)     NOTNULL  Company Key
+Attaches an item to one or more preferred zones.
-in_whs_key           varchar(4)     NOTNULL  Warehouse Key
+|
-wms_group_key        int            NOTNULL  Group Key
+*gl_cmp_key
+*in_whs_key
+*wms_zone_key
+*in_item_key
-wms_kit_tbl
+*im_pack_key
-gl_cmp_key           varchar(2)     NOTNULL  Company Key
+*wms_zone_pri
-in_whs_key           varchar(4)     NOTNULL  Warehouse Key
+*actionType
-wms_kititem_key      varchar(20)    NOTNULL  Kit Item Key
+|
-wms_kitpack_key      varchar(6)     NOTNULL  Kit Pack Key
+*varchar(3)
-in_item_key          varchar(20)    NOTNULL  Item Key
+*varchar(4)
-im_pack_key          varchar(6)     NOTNULL  Pack Key
+*varchar(10)
-wms_kit_qty          float          NOTNULL  Kit Quantity Value
+*varchar(30)
-wms_kit_uom          varchar(2)     NOTNULL  Kit UOM Value
+*varchar(6)
-created_by           varchar(8)     NOTNULL  Created by Date/Time Value
+*int
-created_on           datetime       NOTNULL  Created on Date/Time Value
+*smallint
-changed_by           varchar(8)     NOTNULL  User Key
+|
-changed_on           datetime       NOTNULL  Changed on Date/Time Value
+*NOTNULL
-lock_count           int            NOTNULL  Lock Counter Key
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
-wms_lhold_tbl
+*NOTNULL
-gl_cmp_key           varchar(3)     NULL     Company Key
+*NOTNULL
-in_whs_key           varchar(4)     NULL     Warehouse Key
+|
-sa_user_key          varchar(8)     NULL     User Key
+*Company Key
-wms_lhold_lot        varchar(25)    NULL     Lot Hold Lot Value
+*Warehouse Key
-wms_lhold_bgdt       datetime       NULL     Beginning Hold Date/Time Value
+*Zone Key
-wms_lhold_eddt       datetime       NULL     Ending Hold Date/Time Value
+*Item Key
-wms_lhold_cmt        varchar(255)   NULL     Comment Value
+*Pack Key
-wms_lhold_trdt       datetime       NULL     Date Lot Placed On Hold Value
+*Zone Priority Value
+*Action Type Value
+|}
-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
-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
-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
-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
-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
-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
-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
-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
-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
-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
-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
-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
-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
-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
-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
-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
-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
-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
-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
-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
-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
-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
-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

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