Latest revision as of 03:02, 4 February 2007

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
wmRuleContext
wmRuleContextLine
wmRuleMaster
wmScaleDefinition
wmStockMoveInt
wmTaskMaster
wmTestHistory
wmUomConv
wmUserPrefs
wmUserTask
wmWave
wms_autohd_tbl
wms_bin_tbl
wms_bincnt_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

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

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

wmCountDetail

Column	Data Type	Nullable	Key Description
company warehouse countKey containerHeader containerDetail bin item pack lot originalQty countedQty countedCost variance varianceCost countedBy countedOn updateCounter	varchar(2) varchar(4) int varchar(10) int varchar(10) varchar(10) varchar(10) varchar(10) decimal(18,4) decimal(18,4) decimal(18,4) decimal(18,4) decimal(18,4) varchar(10) datetime int	NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL	Company Key Warehouse Key Count Key Container Header Key Container Detail Key Bin Key Item Key Pack Key Lot Key Original Quantity Value Counted Quantity Value Counted Cost Value Variance Value Variance Cost Value User Key Counted On Date/Time Value Update Counter Key

wmCountMaster

Column	Data Type	Nullable	Key Description
company warehouse countKey countStatus createdBy createdOn completedBy completedOn countedCost netVarianceCost numCounts numErrors	varchar(2) varchar(4) int varchar(10) varchar(10) datetime varchar(10) datetime decimal(18,4) decimal(18,4) int int	NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NULL NULL NULL NULL NULL NULL	Company Key Warehouse Key Count Key Count Status Key User Key Counted On Date/Time Value User Key Completed On Date/Time Value Counted Cost Value Net Variance Cost Number of Counts Value Number of Errors Value

wmCountZones

Column	Data Type	Nullable	Key Description
company warehouse countZone bin	varchar(2) varchar(4) varchar(10) varchar(10)	NOTNULL NOTNULL NOTNULL NOTNULL	Company Key Warehouse Key Count Zone Key Bin Key

wmCountedBins

Column	Data Type	Nullable	Key Description
company warehouse countKey bin errors countedBy countedOn updateCounter	varchar(2) varchar(4) int varchar(10) int varchar(10) datetime int	NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL	Company Key Warehouse Key Count Key Bin Key Errors Key User Key Counted On Date/Time Value Update Counter Key

wmCustomer

Column	Data Type	Nullable	Key Description
company warehouse customerKey showCustPartNumber	varchar(2) varchar(4) varchar(10) int	NOTNULL NOTNULL NOTNULL NOTNULL	Company Key Warehouse Key Customer Key Show Customer Part Number Key

wmDemand

Column	Data Type	Nullable	Key Description
company warehouse orderKey orderType demandLine status item pack lot demandQty pickedQty uom createTime activeUser lockCounter minShelfLife	varchar(2) varchar(4) varchar(10) int int varchar(50) varchar(20) varchar(8) varchar(20) decimal(18,4) decimal(18,4) varchar(2) datetime varchar(10) int int	NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NULL NULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL	Company Key Warehouse Key Order Key Order Type Key Demand Line Key Status Key Item Key Pack Key Lot Key Demand Quantity Value Picked Quantity Value UOM Value Created Date/Time Value User Key Lock Counter Key Minimum Shelf Life Key

wmExtraInfoUserFlds

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

Column	Data Type	Nullable	Key Description
company warehouse item pack context instruction	varchar(2) varchar(4) varchar(20) varchar(8) int varchar(255)	NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL	Company Key Warehouse Key Item Key Pack Key Context Key Instruction Text Value

wmLabelCrossRef

Column	Data Type	Nullable	Key Description
company branch deliverFrom labelKey	varchar(2) varchar(4) varchar(10) int	NOTNULL NOTNULL NOTNULL NOTNULL	Company key Branch Key Deliver From Key Label Key

wmLabelElements

Column	Data Type	Nullable	Key Description
labelKey elementKey dataType elementDescription position width uom decimalPosition mapsTo required lastModifiedBy lastModifiedOn	int int int varchar(10) int int varchar(2) int varchar(20) int varchar(10) datetime	NOTNULL NOTNULL NOTNULL NULL NOTNULL NOTNULL NULL NOTNULL NULL NOTNULL NOTNULL NULL	Label Key Element Key Data Type Value Element Description Value Position Value Width Value UOM Value Decimal Position Key Maps To Key Required Key User Key Last Modified Date/Time Value

wmPickAllocation

Column	Data Type	Nullable	Key Description
pickAllocKey companyKey warehouseKey orderType orderKey orderLineKey containerKey itemKey packKey allocLotKey allocQuantity allocUOM status lastChangedBy lastChangeDate createdBy creationDate lockCounter	int varchar(10) varchar(10) smallint varchar(30) int varchar(10) varchar(20) varchar(10) varchar(30) float varchar(2) smallint varchar(30) datetime varchar(30) datetime int	NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL	Pick Allocation Key Company Key Warehouse Key Order Type Key Order Key Order Line Key Container Key Item Key Pack Key Allocation Lot Key Allocation Quantity Value Allocation UOM Value Status Key User Key Changed on Date/Time Value User Key Created On Date Value Lock Counter Value

wmPOReturnInt

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

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

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

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

wmRuleContext

Column	Data Type	Nullable	Key Description
ruleContextKey companyKey warehouseKey contextName contextType binKey lastChangedBy lastChangeDate createdBy creationDate lockCounter	int varchar(10) varchar(10) varchar(60) smallint varchar(10) varchar(30) datetime varchar(30) datetime int	NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL	Rule Context key Company Key Warehouse Key Context Name Value Context Type Value Bin Key User Key Changed on Date/Time Value User Key Created on Date/Time Value Lock Counter

wmRuleContextLine

Column	Data Type	Nullable	Key Description
ruleContextLineKey ruleContextKey rulePriority ruleMasterKey sortOrder lastChangedBy lastChangeDate createdBy creationDate lockCounter	int int smallint int smallint varchar(30) datetime varchar(30) datetime int	NOTNULL NOTNULL NOTNULL NOTNULL NULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL	Rule Context Line Key Rule Context Key Rule Priority Value Rule Master Key Sort Order Value User Key Changed on Date User Key Created on Date Lock Counter Value

wmRuleMaster

Column	Data Type	Nullable	Key Description
ruleMasterKey ruleName ruleTable ruleColumn ruleIdentifier lastChangedBy lastChangeDate createdBy creationDate lockCounter	int varchar(60) varchar(30) varchar(30) varchar(30) varchar(30) datetime varchar(30) datetime int	NOTNULL NOTNULL NULL NULL NULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL	Rule Master Key Rule Name Value Rule Table Value Rule Column Value Rule ID Value User Key Changed on Date Value User Key Created on Date Value Lock Counter Value

wmScaleDefinition

Column	Data Type	Nullable	Key Description
company warehouse scaleKey scaleDescription scaleAddress	varchar(2) varchar(4) varchar(60) varchar(128) varchar(128)	NOTNULL NOTNULL NOTNULL NULL NOTNULL	Company Key Warehouse Key Scale Key Scale Description Value Scale Address Value

wmStockMoveInt

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

wmTaskMaster

Column	Data Type	Nullable	Key Description
taskMasterKey taskType taskName refLabel1 refLabel2 refLabel3 lastChangedBy lastChangeDate createdBy creationDate lockCounter	int varchar(20) varchar(30) varchar(30) varchar(30) varchar(30) varchar(30) datetime varchar(30) datetime int	NOTNULL NOTNULL NOTNULL NULL NULL NULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL	Task Master Key Task Type Value Task Name Value Reference Label 1 Reference Label 2 Reference Label 3 User Key Changed On Date/Time Value User Key Created On Date/Time Value Lock Counter Value

wmTestHistory

Column	Data Type	Nullable	Key Description
testKey effectiveDate sequence item pack lot sampleID status result measured measuredUOM comments transactionTime tranactionUser	varchar(10) datetime int varchar(20) varchar(10) varchar(30) varchar(20) varchar(20) varchar(60) decimal(18,4) varchar(2) varchar(255) datetime varchar(10)	NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL NULL NULL NULL NOTNULL NULL	Test Key Effective Date/Time Value Sequence Value Item Key Pack Key Lot Key Sample ID Value Status Value Result Value Measured value Unit Of Measure Value Comment Value Transaction Date/Time Value User Key

wmUomConv

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

wmUserPrefs

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

wmUserTask

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

wmWave

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

wms_autohd_tbl

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

wms_bin_tbl

Column	Data Type	Nullable	Key Description
gl_cmp_key in_whs_key in_locn_key wms_bin_key wms_bin_depth wms_bin_height wms_bin_width wms_bin_type wms_bin_row wms_bin_col wms_bin_cychd wms_bin_hold 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 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_bincnt_tbl

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

wms_bindtlst_tbl

Column	Data Type	Nullable	Key Description
gl_cmp_key in_whs_key wms_bin_key wms_zone_key wms_conthdr_key wms_bin_depth wms_bin_height wms_bin_width wms_bin_vol wms_binst_rem wms_binst_pc in_item_key im_pack_key in_lot_key wms_contdtl_puldt wms_contdtl_alloc wms_contst_key wms_conthdr_lstmv wms_contdtl_qty wms_bin_type wms_contdtl_key wms_count_key wms_count_qty wms_count_var 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

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

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

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

wms_contcase_tbl

Column	Data Type	Nullable	Key Description
gl_cmp_key in_whs_key wms_conthdr_key wms_contdtl_key wms_contcase_key wms_contcase_ctwgt in_sublot_key wms_contcase_prddt created_on changed_on created_by changed_by lock_count wms_contcase_stat wms_contcase_acwgt 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

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

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

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

wms_contty_tbl

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

wms_contxf_tbl

Column	Data Type	Nullable	Key Description
gl_cmp_key in_whs_key wms_contty_key in_item_key im_pack_key wms_desc so_prod_key wms_active_qty wms_hold_qty 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

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

wms_ctwght_tbl

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

wms_custpull_tbl

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

wms_cycnt_tbl

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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_shipins_tbl Table no longer

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

wms_track_tbl

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

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

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_utcount_tbl

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

wms_vndpull_tbl

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

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

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

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 3: / Line 3: @@
 The Whistle application uses a number of database tables to store and organize warehouse information.  Whistle updates most tables automatically.  Other tables, such as the ‘user’ tables, are updated manually through the use of data maintenance frames (see chapter on Data Maintenance Frames).  This is a comprehensive listing of all Whistle – specific database tables and their corresponding parameters.
-The following is a list of all Whistle database tables.  Each table is described in detail in later in this appendix.
+The following is a list of all Whistle database tables.  Each table is described in detail later in this appendix.
 {| border="1" cellpadding="2" valign="top" halign="left"
@@ Line 13: / Line 13: @@
 {| border="1" cellpadding="2" valign="top" halign="left"|
 |
+*wmASNHistory
+*wmAutoReceiveWhs
 *wmCountDetail
 *wmCountMaster
@@ Line 19: / Line 21: @@
 *wmCustomer
 *wmDemand
+*wmExtraInfoUserFlds
 *wmItemInstruct
 *wmLabelCrossRef
 *wmLabelElements
 *wmPickAllocation
+*wmPOReturnInt
 *wmPrintJobs
+*wmReceiptReturn
+*wmReclassHist
 *wmRuleContext
 *wmRuleContextLine
 *wmRuleMaster
 *wmScaleDefinition
+*wmStockMoveInt
 *wmTaskMaster
 *wmTestHistory
@@ Line 39: / Line 46: @@
 *wms_bindtlst_tbl
 *wms_case_tbl
+*wms_comments_tbl
 *wms_contadj_tbl
 *wms_contcase_tbl
@@ Line 68: / Line 76: @@
 *wms_pultol_tbl
 *wms_recper_tbl
+*wms_rma_tbl
 *wms_screen_tbl
 *wms_sectmpl_tbl
@@ Line 130: / Line 139: @@
 ==Whistle Tables and Definitions==
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wmASNHistory===
+|
+*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
+|}
 {| border="1" cellpadding="2" valign="top" halign="left"
@@ Line 137: / Line 223: @@
 !Key Description
 |-
-===wmCountDetail===
+===wmAutoReceiveWhs===
+|
+*company
+*warehouse
+|
+*varchar(2)
+*varchar(4)
 |
-*company
+*NULL
-*warehouse
+*NULL
+|
+*Company Key
+*Warehouse Key
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wmCountDetail===
+|
+*company
+*warehouse
 *countKey
 *containerHeader
@@ Line 459: / Line 569: @@
 !Key Description
 |-
-===wmItemInstruct===
+===wmExtraInfoUserFlds===
 |
 *company
-*warehouse
+*branch
-*item
+*warehouse
-*pack
+*orderkey
-*context
+*bolkey
-*instruction
+*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
 |
-*varchar(2)
+*NOTNULL
-*varchar(4)
+*NOTNULL
-*varchar(20)
+*NOTNULL
-*varchar(8)
+*NOTNULL
-*int
+*NOTNULL
-*varchar(255)
+*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
+|-
+===wmItemInstruct===
+|
+*company
+*warehouse
+*item
+*pack
+*context
+*instruction
+|
+*varchar(2)
+*varchar(4)
+*varchar(20)
+*varchar(8)
+*int
+*varchar(255)
 |
 *NOTNULL
@@ Line 671: / Line 947: @@
 !Key Description
 |-
-===wmPrintJobs===
+===wmPOReturnInt===
+|
+*returnLineId
+*company
+*branch
+*warehouse
+*po
+*poDtl
+*receipt
+*contHdr
+*contDtl
+*item
+*pack
+*lot
+*location
+*returnedQty
+*returnedUom
+*returnedTime
+*userKey
+*poReturnControl
 |
-*company
+*int
-*warehouse
+*varchar(3)
-*track
+*varchar(5)
-*numLabels
+*varchar(5)
-*printDoc
+*varchar(10)
-*printer
+*int
-*prePrint
+*varchar(10)
-*printSequence1
+*varchar(20)
-*printSequence2
+*int
-*printSequence3
+*varchar(30)
-|
+*varchar(10)
-*varchar(2)
+*varchar(25)
-*varchar(4)
-*varchar(10)
-*int
-*varchar(255)
-*varchar(255)
-*int
-*varchar(10)
-*varchar(10)
 *varchar(10)
+*decimal
+*varchar(6)
+*datetime
+*varchar(8)
+*varchar(60)
 |
-*NOTNULL
 *NOTNULL
 *NOTNULL
 *NOTNULL
-*NULL
-*NULL
 *NOTNULL
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
-|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Return Line Key
 *Company Key
-*Warehouse Key
+*Branch Key
-*Tracking Key
+*Warehouse Key
-*Number of labels Value
+*Purchase Order Key
-*Print Document Value
+*Purchase Order Detail Key
-*Printer Value
+*Receipt Key
-*Pre print Value
+*Container Header Key
-*Print Sequence 1 Value
+*Container Detail Key
-*Print Sequence 2 Value
+*Item Key
-*Print Sequence 3 Value
+*Pack Key
+*Lot Key
+*Location Key
+*Quantity Returned
+*Quantity Returned Unit of Measure
+*Returned Date/Time Value
+*User Key
+*Control Number
 |}
@@ Line 724: / Line 1,032: @@
 !Key Description
 |-
-===wmRuleContext===
+===wmPrintJobs===
 |
-*ruleContextKey
+*company
-*companyKey
+*warehouse
-*warehouseKey
+*track
-*contextName
+*numLabels
-*contextType
+*printDoc
-*binKey
+*printer
-*lastChangedBy
+*prePrint
-*lastChangeDate
+*printSequence1
-*createdBy
+*printSequence2
-*creationDate
+*printSequence3
-*lockCounter
 |
-*int
+*varchar(2)
-*varchar(10)
+*varchar(4)
 *varchar(10)
-*varchar(60)
+*int
-*smallint
+*varchar(255)
-*varchar(10)
+*varchar(255)
-*varchar(30)
+*int
-*datetime
+*varchar(10)
-*varchar(30)
+*varchar(10)
-*datetime
+*varchar(10)
-*int
 |
+*NOTNULL
 *NOTNULL
 *NOTNULL
 *NOTNULL
+*NULL
+*NULL
 *NOTNULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
-*NOTNULL
+|
-*NOTNULL
+*Company Key
-*NOTNULL
+*Warehouse Key
-*NOTNULL
+*Tracking Key
-|
+*Number of labels Value
-*Rule Context key
+*Print Document Value
-*Company Key
+*Printer Value
-*Warehouse Key
+*Pre print Value
-*Context Name Value
+*Print Sequence 1 Value
-*Context Type Value
+*Print Sequence 2 Value
-*Bin Key
+*Print Sequence 3 Value
-*User Key
-*Changed on Date/Time Value
-*User Key
-*Created on Date/Time Value
-*Lock Counter
 |}
@@ Line 781: / Line 1,086: @@
 !Key Description
 |-
+===wmReceiptReturn===
-===wmRuleContextLine===
+|
+*company
+*branch
+*warehouse
+*purchaseOrder
+*receiptCntrl
+*rma
+*item
+*pack
+*qty
+*track
+*reason
+*comment
+*userKey
+*createdate
 |
-*ruleContextLineKey
+*varchar(2)
-*ruleContextKey
+*varchar(4)
-*rulePriority
+*varchar(4)
-*ruleMasterKey
+*varchar(10)
-*sortOrder
+*varchar(20)
-*lastChangedBy
+*varchar(20)
-*lastChangeDate
+*varchar(20)
-*createdBy
+*varchar(6)
-*creationDate
+*decimal
-*lockCounter
+*varchar(10)
-|
+*varchar(10)
-*int
+*varchar(255)
-*int
+*varchar(8)
-*smallint
+*datetime
-*int
-*smallint
-*varchar(30)
-*datetime
-*varchar(30)
-*datetime
-*int
 |
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
 *NULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
-|
+*NULL
-*Rule Context Line Key
+*NULL
-*Rule Context Key
+*NULL
-*Rule Priority Value
+*NULL
-*Rule Master Key
+|
-*Sort Order Value
+*Company Key
-*User Key
+*Branch Key
-*Changed on Date
+*Warehouse Key
-*User Key
+*Purchase Order Key
-*Created on Date
+*Control Number
-*Lock Counter Value
+*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"
@@ Line 836: / Line 1,155: @@
 !Key Description
 |-
+===wmReclassHist===
-===wmRuleMaster===
+|
+*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)
 |
-*ruleMasterKey
+*NOTNULL
-*ruleName
+*NOTNULL
-*ruleTable
+*NOTNULL
-*ruleColumn
+*NULL
-*ruleIdentifier
+*NULL
-*lastChangedBy
+*NULL
-*lastChangeDate
+*NULL
-*createdBy
+*NULL
-*creationDate
+*NULL
-*lockCounter
+*NULL
-|
+*NULL
-*int
+*NULL
-*varchar(60)
+*NULL
-*varchar(30)
+*NULL
-*varchar(30)
+*NULL
-*varchar(30)
+*NULL
-*varchar(30)
+*NULL
-*datetime
+*NULL
-*varchar(30)
+*NULL
-*datetime
+*NULL
-*int
+*NOTNULL
-|
+*NOTNULL
-*NOTNULL
+|
-*NOTNULL
+*Company Key
-*NULL
+*Warehouse Key
-*NULL
+*Container Header Key
-*NULL
+*Container Detail Key
-*NOTNULL
+*Original Item Key
-*NOTNULL
+*Original Pack Key
-*NOTNULL
+*Original Product Key
-*NOTNULL
+*Original Quantity Value
-*NOTNULL
+*Original Unit of Measure
-|
+*Original Container Type
-*Rule Master Key
+*Original Lot Key
-*Rule Name Value
+*New Item Key
-*Rule Table Value
+*New Pack Key
-*Rule Column Value
+*New Product Key
-*Rule ID Value
+*New Quantity Value
-*User Key
+*New Unit of Measure
-*Changed on Date Value
+*New Container Type
-*User Key
+*New Lot Key
-*Created on Date Value
+*Created On Date/Time Value
-*Lock Counter Value
+*User Key
+*Debit ATF Control Number
+*Credit ATF Control Number
 |}
@@ Line 891: / Line 1,257: @@
 |-
-===wmScaleDefinition===
+===wmRuleContext===
+|
+*ruleContextKey
+*companyKey
+*warehouseKey
+*contextName
+*contextType
+*binKey
+*lastChangedBy
+*lastChangeDate
+*createdBy
+*creationDate
+*lockCounter
 |
-*company
+*int
-*warehouse
+*varchar(10)
-*scaleKey
+*varchar(10)
-*scaleDescription
-*scaleAddress
-|
-*varchar(2)
-*varchar(4)
 *varchar(60)
-*varchar(128)
+*smallint
-*varchar(128)
+*varchar(10)
+*varchar(30)
+*datetime
+*varchar(30)
+*datetime
+*int
 |
 *NOTNULL
 *NOTNULL
 *NOTNULL
-*NULL
 *NOTNULL
-|
+*NOTNULL
-*Company Key
+*NOTNULL
-*Warehouse Key
+*NOTNULL
-*Scale Key
+*NOTNULL
-*Scale Description Value
+*NOTNULL
-*Scale Address Value
+*NOTNULL
+*NOTNULL
+|
+*Rule Context key
+*Company Key
+*Warehouse Key
+*Context Name Value
+*Context Type Value
+*Bin Key
+*User Key
+*Changed on Date/Time Value
+*User Key
+*Created on Date/Time Value
+*Lock Counter
 |}
 {| border="1" cellpadding="2" valign="top" halign="left"
 !Column
@@ Line 925: / Line 1,315: @@
 |-
-===wmTaskMaster===
+===wmRuleContextLine===
 |
-*taskMasterKey
+*ruleContextLineKey
-*taskType
+*ruleContextKey
-*taskName
+*rulePriority
-*refLabel1
+*ruleMasterKey
-*refLabel2
+*sortOrder
-*refLabel3
 *lastChangedBy
 *lastChangeDate
@@ Line 938: / Line 1,327: @@
 *creationDate
 *lockCounter
+|
+*int
+*int
+*smallint
+*int
+*smallint
+*varchar(30)
+*datetime
+*varchar(30)
+*datetime
+*int
 |
-*int
+*NOTNULL
-*varchar(20)
-*varchar(30)
-*varchar(30)
-*varchar(30)
-*varchar(30)
-*varchar(30)
-*datetime
-*varchar(30)
-*datetime
-*int
-|
 *NOTNULL
 *NOTNULL
 *NOTNULL
 *NULL
-*NULL
-*NULL
 *NOTNULL
 *NOTNULL
 *NOTNULL
 *NOTNULL
 *NOTNULL
 |
-*Task Master Key
+*Rule Context Line Key
-*Task Type Value
+*Rule Context Key
-*Task Name Value
+*Rule Priority Value
-*Reference Label 1
+*Rule Master Key
-*Reference Label 2
+*Sort Order Value
-*Reference Label 3
+*User Key
-*User Key
+*Changed on Date
-*Changed On Date/Time Value
+*User Key
-*User Key
+*Created on Date
-*Created On Date/Time Value
+*Lock Counter Value
-*Lock Counter Value
 |}
 {| border="1" cellpadding="2" valign="top" halign="left"
@@ Line 983: / Line 1,370: @@
 |-
-===wmTestHistory===
+===wmRuleMaster===
 |
-*testKey
+*ruleMasterKey
-*effectiveDate
+*ruleName
-*sequence
+*ruleTable
-*item
+*ruleColumn
-*pack
+*ruleIdentifier
-*lot
+*lastChangedBy
-*sampleID
+*lastChangeDate
-*status
+*createdBy
-*result
+*creationDate
-*measured
+*lockCounter
-*measuredUOM
+|
-*comments
+*int
-*transactionTime
+*varchar(60)
-*tranactionUser
+*varchar(30)
-|
+*varchar(30)
-*varchar(10)
+*varchar(30)
-*datetime
+*varchar(30)
-*int
+*datetime
-*varchar(20)
+*varchar(30)
-*varchar(10)
+*datetime
-*varchar(30)
+*int
-*varchar(20)
-*varchar(20)
-*varchar(60)
-*decimal(18,4)
-*varchar(2)
-*varchar(255)
-*datetime
-*varchar(10)
 |
+*NOTNULL
 *NOTNULL
+*NULL
+*NULL
+*NULL
 *NOTNULL
 *NOTNULL
@@ Line 1,021: / Line 1,404: @@
 *NOTNULL
 *NOTNULL
-*NOTNULL
-*NOTNULL
-*NOTNULL
-*NULL
-*NULL
-*NULL
-*NOTNULL
-*NULL
 |
-*Test Key
+*Rule Master Key
-*Effective Date/Time Value
+*Rule Name Value
-*Sequence Value
+*Rule Table Value
-*Item Key
+*Rule Column Value
-*Pack Key
+*Rule ID Value
-*Lot Key
+*User Key
-*Sample ID Value
+*Changed on Date Value
-*Status Value
+*User Key
-*Result Value
+*Created on Date Value
-*Measured value
+*Lock Counter Value
-*Unit Of Measure Value
-*Comment Value
-*Transaction Date/Time Value
-*User Key
 |}
@@ Line 1,053: / Line 1,424: @@
 |-
-===wmUomConv===
+===wmScaleDefinition===
-|
-*gl_cmp_key
-*in_whs_key
-*in_item_key
-*im_pack_key
-*uom_from
-*uom_to
-*factor
 |
+*company
+*warehouse
+*scaleKey
+*scaleDescription
+*scaleAddress
+|
 *varchar(2)
 *varchar(4)
-*varchar(20)
+*varchar(60)
-*varchar(6)
+*varchar(128)
-*varchar(10)
+*varchar(128)
-*varchar(10)
-*float
 |
 *NOTNULL
 *NOTNULL
 *NOTNULL
-*NOTNULL
+*NULL
 *NOTNULL
-*NOTNULL
-*NOTNULL
 |
 *Company Key
 *Warehouse Key
-*Item Key
+*Scale Key
-*Pack Key
+*Scale Description Value
-*UOM From Key
+*Scale Address Value
-*UOM To Key
-*Factor Key
 |}
@@ Line 1,095: / Line 1,458: @@
 |-
-===wmUserPrefs===
+===wmStockMoveInt===
 |
-*gl_cmp_key
+*company
-*in_whs_key
+*warehouse
-*user_key
+*wms_conthdr_key
-*pref_name
+*tolocation
-*pref_value
+*fromlocation
-*created_by
+*sa_user_key
-*created_on
+*createdate
-*changed_by
+*item
-*changed_on
+*pack
-*lock_counter
+*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)
 |
-*varchar(2)
+*NULL
-*varchar(4)
+*NULL
-*varchar(8)
+*NULL
-*varchar(64)
+*NULL
-*varchar(256)
+*NULL
-*varchar(8)
+*NULL
-*datetime
+*NULL
-*varchar(8)
+*NULL
-*datetime
+*NULL
-*int
+*NULL
-|
+*NULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
-*NULL
+|
-*NOTNULL
+*Company Key
-*NOTNULL
+*Warehouse Key
-*NOTNULL
+*Container Header Key
-*NOTNULL
+*Destination Location
-*NOTNULL
+*Source Location
-|
+*User Key
-*Company Key
+*Created On Date/Time Value
-*Warehouse Key
+*Item Key
-*User Key
+*Pack Key
-*Preference Name Value
+*Quantity
-*Preference Value
+*Unit of Measure
-*User Key
+*Control Number
-*Created on Date/Time Value
+*Reason Code
-*User Key
+*Transaction Date/Time Value
-*Changed On Date/Time Value
+*Lot Key
-*Lock Counter Value
 |}
 {| border="1" cellpadding="2" valign="top" halign="left"
 !Column
@@ Line 1,149: / Line 1,533: @@
 |-
-===wmUserTask===
+===wmTaskMaster===
 |
-*userTaskKey
+*taskMasterKey
-*userKey
+*taskType
-*companyKey
+*taskName
-*warehouseKey
+*refLabel1
-*taskMasterKey
+*refLabel2
-*taskNote
+*refLabel3
-*expectedStart
+*lastChangedBy
-*expectedFinish
+*lastChangeDate
-*actualStart
+*createdBy
-*actualFinish
+*creationDate
-*priority
+*lockCounter
-*status
+|
-*refValue1
+*int
-*refValue2
+*varchar(20)
-*refValue3
+*varchar(30)
-*assignedBy
+*varchar(30)
-*lastChangedBy
+*varchar(30)
-*lastChangeDate
+*varchar(30)
-*createdBy
+*varchar(30)
-*creationDate
+*datetime
-*lockCounter
+*varchar(30)
-|
+*datetime
 *int
-*varchar(8)
-*varchar(10)
-*varchar(10)
-*int
-*varchar(255)
-*datetime
-*datetime
-*datetime
-*datetime
-*smallint
-*smallint
-*varchar(30)
-*varchar(30)
-*varchar(30)
-*varchar(10)
-*varchar(30)
-*datetime
-*varchar(30)
-*datetime
-*int
 |
 *NOTNULL
-*NOTNULL
-*NOTNULL
-*NOTNULL
-*NOTNULL
-*NOTNULL
-*NULL
-*NULL
-*NULL
-*NULL
 *NOTNULL
 *NOTNULL
@@ Line 1,214: / Line 1,569: @@
 *NOTNULL
 *NOTNULL
 *NOTNULL
-*NOTNULL
 |
-*User Task Key
+*Task Master Key
-*User Key
+*Task Type Value
-*Company Key
+*Task Name Value
-*Warehouse Key
+*Reference Label 1
-*Task Master Key
+*Reference Label 2
-*Task Note Value
+*Reference Label 3
-*Expected Start Date/Time Value
+*User Key
-*Expected End Date/Time Value
+*Changed On Date/Time Value
-*Actual Start Date/Time Value
+*User Key
-*Actual End Date/Time Value
+*Created On Date/Time Value
-*Priority Value
+*Lock Counter Value
-*Status Value
-*Reference Value 1
-*Reference Value 2
-*Reference Value 3
-*User Key
-*User Key
-*Changed on Date/Time Value
-*User Key
-*Created on Date/Time Value
-*Lock Counter Value
 |}
@@ Line 1,247: / Line 1,591: @@
 |-
-===wmWave===
+===wmTestHistory===
 |
-*company
+*testKey
-*warehouse
+*effectiveDate
-*waveKey
+*sequence
-*createdOn
+*item
-*createdBy
+*pack
-|
+*lot
-*varchar(2)
+*sampleID
-*varchar(4)
+*status
-*varchar(10)
+*result
-*datetime
+*measured
-*varchar(10)
+*measuredUOM
+*comments
+*transactionTime
+*tranactionUser
 |
-*NOTNULL
+*varchar(10)
-*NOTNULL
+*datetime
-*NOTNULL
+*int
-*NULL
+*varchar(20)
-*NOTNULL
+*varchar(10)
+*varchar(30)
+*varchar(20)
+*varchar(20)
+*varchar(60)
+*decimal(18,4)
+*varchar(2)
+*varchar(255)
+*datetime
+*varchar(10)
 |
-*Company Key
+*NOTNULL
-*Warehouse Key
+*NOTNULL
-*Wave Key
+*NOTNULL
-*Created on Date/Time Value
+*NOTNULL
-*User Key
+*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
 |}
@@ Line 1,281: / Line 1,661: @@
 |-
-===wms_autohd_tbl===
+===wmUomConv===
 |
 *gl_cmp_key
@@ Line 1,287: / Line 1,667: @@
 *in_item_key
 *im_pack_key
-*wms_autohd_hrs
+*uom_from
-*context
+*uom_to
+*factor
 |
 *varchar(2)
 *varchar(4)
-*varchar(30)
+*varchar(20)
 *varchar(6)
-*int
+*varchar(10)
 *varchar(10)
+*float
 |
+*NOTNULL
 *NOTNULL
 *NOTNULL
 *NOTNULL
 *NOTNULL
-*NULL
 *NOTNULL
+*NOTNULL
 |
 *Company Key
 *Warehouse Key
 *Item Key
 *Pack Key
-*Autohold Length Hours Value
+*UOM From Key
-*Context Value
+*UOM To Key
+*Factor Key
 |}
@@ Line 1,319: / Line 1,703: @@
 |-
-===wms_bin_tbl===
+===wmUserPrefs===
 |
 *gl_cmp_key
 *in_whs_key
-*in_locn_key
+*user_key
-*wms_bin_key
+*pref_name
-*wms_bin_depth
+*pref_value
-*wms_bin_height
+*created_by
-*wms_bin_width
+*created_on
-*wms_bin_type
+*changed_by
-*wms_bin_row
+*changed_on
-*wms_bin_col
+*lock_counter
-*wms_bin_cychd
-*wms_bin_hold
-|
-*varchar(3)
-*varchar(4)
-*varchar(10)
-*varchar(15)
-*float
-*float
-*float
-*varchar(10)
-*int
-*int
-*int
-*int
 |
-*NOTNULL
+*varchar(2)
-*NOTNULL
+*varchar(4)
-*NULL
+*varchar(8)
-*NOTNULL
+*varchar(64)
-*NULL
+*varchar(256)
-*NULL
+*varchar(8)
-*NULL
+*datetime
-*NULL
+*varchar(8)
-*NULL
+*datetime
-*NULL
+*int
-*NOTNULL
+|
 *NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
 |
 *Company Key
 *Warehouse Key
-*Location Key
+*User Key
-*Bin Key
+*Preference Name Value
-*Bin Depth Value
+*Preference Value
-*Bin Height Value
+*User Key
-*Bin Width Value
+*Created on Date/Time Value
-*Bin Type Value
+*User Key
-*Bin row # (x) Value
+*Changed On Date/Time Value
-*Bin column # (y) Value
+*Lock Counter Value
-*Bin Cycle Lock Value
-*Bin On Hold Value
 |}
@@ Line 1,381: / Line 1,757: @@
 |-
-===wms_bincnt_tbl===
+===wmUserTask===
 |
-*gl_cmp_key
+*userTaskKey
-*in_whs_key
+*userKey
-*in_cycnt_key
+*companyKey
-*wms_bin_key
+*warehouseKey
-*wms_bincnt_stat
+*taskMasterKey
-*sa_user_key
+*taskNote
-*wms_bincnt_crtdt
+*expectedStart
-*in_locn_key
+*expectedFinish
-*in_item_key
+*actualStart
-*im_pack_key
+*actualFinish
-|
+*priority
-*varchar(3)
+*status
-*varchar(4)
+*refValue1
-*int
+*refValue2
-*varchar(15)
+*refValue3
-*int
+*assignedBy
-*varchar(8)
+*lastChangedBy
-*datetime
+*lastChangeDate
-*varchar(10)
+*createdBy
-*varchar(10)
+*creationDate
-*varchar(10)
+*lockCounter
 |
-*NULL
+*int
-*NULL
+*varchar(8)
-*NULL
+*varchar(10)
-*NULL
+*varchar(10)
-*NULL
+*int
-*NULL
+*varchar(255)
-*NULL
+*datetime
-*NULL
+*datetime
-*NULL
+*datetime
-*NULL
+*datetime
+*smallint
+*smallint
+*varchar(30)
+*varchar(30)
+*varchar(30)
+*varchar(10)
+*varchar(30)
+*datetime
+*varchar(30)
+*datetime
+*int
 |
-*Company Key
+*NOTNULL
-*Warehouse Key
+*NOTNULL
-*Cycle count key
+*NOTNULL
-*Bin Key
+*NOTNULL
-*Bin count status Value
+*NOTNULL
-*User Key
+*NOTNULL
-*Counted on Date/Time Value
+*NULL
-*Location Key
+*NULL
-*Item Key
+*NULL
-*Pack Key
+*NULL
-|}
+*NOTNULL
+*NOTNULL
-{| border="1" cellpadding="2" valign="top" halign="left"
+*NULL
-!Column
+*NULL
-!Data Type
+*NULL
-!Nullable
+*NOTNULL
-!Key Description
+*NOTNULL
-|-
+*NOTNULL
+*NOTNULL
-===wms_bindtlst_tbl===
+*NOTNULL
+*NOTNULL
 |
-*gl_cmp_key
+*User Task Key
-*in_whs_key
+*User Key
-*wms_bin_key
+*Company Key
-*wms_zone_key
+*Warehouse Key
-*wms_conthdr_key
+*Task Master Key
-*wms_bin_depth
+*Task Note Value
-*wms_bin_height
+*Expected Start Date/Time Value
-*wms_bin_width
+*Expected End Date/Time Value
-*wms_bin_vol
+*Actual Start Date/Time Value
-*wms_binst_rem
+*Actual End Date/Time Value
-*wms_binst_pc
+*Priority Value
-*in_item_key
+*Status Value
-*im_pack_key
+*Reference Value 1
-*in_lot_key
+*Reference Value 2
-*wms_contdtl_puldt
+*Reference Value 3
-*wms_contdtl_alloc
+*User Key
-*wms_contst_key
+*User Key
-*wms_conthdr_lstmv
+*Changed on Date/Time Value
-*wms_contdtl_qty
+*User Key
-*wms_bin_type
+*Created on Date/Time Value
-*wms_contdtl_key
+*Lock Counter Value
-*wms_count_key
+|}
-*wms_count_qty
-*wms_count_var
+{| border="1" cellpadding="2" valign="top" halign="left"
-*lastCount
+!Column
-|
+!Data Type
-*varchar(3)
+!Nullable
-*varchar(4)
+!Key Description
-*varchar(13)
+|-
-*varchar(10)
-*varchar(10)
+===wmWave===
-*float
-*float
-*float
-*float
-*float
-*int
-*varchar(30)
-*varchar(6)
-*varchar(25)
-*datetime
-*varchar(10)
-*varchar(10)
-*datetime
-*float
-*varchar(10)
-*int
-*int
-*float
-*float
-*datetime
 |
+*company
+*warehouse
+*waveKey
+*createdOn
+*createdBy
+|
+*varchar(2)
+*varchar(4)
+*varchar(10)
+*datetime
+*varchar(10)
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
 *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
 |
 *Company Key
 *Warehouse Key
-*Bin Key
+*Wave Key
-*Zone Key
+*Created on Date/Time Value
-*Tracking Key
+*User 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
 |}
@@ Line 1,549: / Line 1,889: @@
 |-
-===wms_case_tbl===
+===wms_autohd_tbl===
+|
+*gl_cmp_key
+*in_whs_key
+*in_item_key
+*im_pack_key
+*wms_autohd_hrs
+*context
 |
-*gl_cmp_key
+*varchar(2)
-*in_whs_key
+*varchar(4)
-*wms_case_num
+*varchar(30)
-*created_on
+*varchar(6)
-*changed_on
+*int
-*created_by
+*varchar(10)
-*changed_by
-*lock_count
-|
-*varchar(2)
-*varchar(4)
-*int
-*datetime
-*datetime
-*varchar(8)
-*varchar(8)
-*int
 |
 *NOTNULL
 *NOTNULL
 *NOTNULL
 *NOTNULL
-*NOTNULL
+*NULL
 *NOTNULL
-*NOTNULL
-*NOTNULL
 |
 *Company Key
 *Warehouse Key
-*Case Number Value
+*Item Key
-*Created on Date
+*Pack Key
-*Changed on Date
+*Autohold Length Hours Value
-*User Key
+*Context Value
-*User Key
-*Lock Counter Value
 |}
@@ Line 1,595: / Line 1,927: @@
 |-
-===wms_contadj_tbl===
+===wms_bin_tbl===
 |
 *gl_cmp_key
 *in_whs_key
-*wms_conthdr_key
+*in_locn_key
-*in_item_key
+*wms_bin_key
-*im_pack_key
+*wms_bin_depth
-*wms_contadj_qty
+*wms_bin_height
-*en_resn_key
+*wms_bin_width
-*sa_user_key
+*wms_bin_type
-*wms_contadj_date
+*wms_bin_row
-*wms_contadj_cmt
+*wms_bin_col
-*wms_contdtl_key
+*wms_bin_cychd
-*wms_contcase_key
+*wms_bin_hold
-*wms_contadj_cntrl
+*can_mix_items
-|
+*not_on_picklist
-*varchar(3)
+*dont_trackvol
-*varchar(4)
+|
-*varchar(10)
+*varchar(3)
-*varchar(30)
+*varchar(4)
-*varchar(6)
+*varchar(10)
-*float
+*varchar(15)
-*varchar(10)
+*float
-*varchar(10)
+*float
-*datetime
+*float
-*varchar(255)
+*varchar(10)
+*int
+*int
+*int
+*int
+*int
+*int
 *int
-*varchar(60)
-*varchar(60)
 |
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
 *NULL
-*NULL
+*NOTNULL
 *NULL
 *NULL
 *NULL
 *NULL
 *NULL
 *NULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
 *NOTNULL
-*NULL
-*NULL
 |
 *Company Key
 *Warehouse Key
-*Tracking Key
+*Location Key
-*Item Key
+*Bin Key
-*Pack Key
+*Bin Depth Value
-*Adjusted Quantity Value
+*Bin Height Value
-*Reason For Adjustment Value
+*Bin Width Value
-*User Key
+*Bin Type Value
-*Transaction Date/Time Value
+*Bin row # (x) Value
-*Container Adj Comment Value
+*Bin column # (y) Value
-*Container Detail Key
+*Bin Cycle Lock Value
-*Container Case Key
+*Bin On Hold Value
-*Container Adj Control Num Value
+*Bin will accept a mix of items
+*Don't show bin contents in picklist
+*Don't calculate bin volume
 |}
@@ Line 1,661: / Line 2,001: @@
 |-
-===wms_contcase_tbl===
+===wms_bincnt_tbl===
 |
 *gl_cmp_key
 *in_whs_key
-*wms_conthdr_key
+*in_cycnt_key
-*wms_contdtl_key
+*wms_bin_key
-*wms_contcase_key
+*wms_bincnt_stat
-*wms_contcase_ctwgt
+*sa_user_key
-*in_sublot_key
+*wms_bincnt_crtdt
-*wms_contcase_prddt
+*in_locn_key
-*created_on
+*in_item_key
-*changed_on
+*im_pack_key
-*created_by
+|
-*changed_by
+*varchar(3)
-*lock_count
-*wms_contcase_stat
-*wms_contcase_acwgt
-|
-*varchar(2)
 *varchar(4)
-*varchar(10)
 *int
-*varchar(60)
+*varchar(15)
-*float
 *int
+*varchar(8)
 *datetime
-*datetime
+*varchar(10)
-*datetime
+*varchar(10)
-*varchar(8)
+*varchar(10)
-*varchar(8)
-*int
-*int
-*float
 |
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
 *NULL
 *NULL
-*NOTNULL
+*NULL
 *NULL
 *NULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
-*NOTNULL
-*NOTNULL
-*NOTNULL
-*NOTNULL
-*NOTNULL
 |
 *Company Key
 *Warehouse Key
-*Tracking Key
+*Cycle count key
-*Tracking Detail Key
+*Bin Key
-*Tracking Case Key
+*Bin count status Value
-*Tracking Catch Weight Value
+*User Key
-*Adage SubLot Key
+*Counted on Date/Time Value
-*Case Production Date Value
+*Location Key
-*Created On Date Value
+*Item Key
-*Changed On Date Value
+*Pack Key
-*User Key
-*User Key
-*Lock Count Value
-*Container Status Value
-*Container Actual Weight Value
 |}
@@ Line 1,735: / Line 2,055: @@
 |-
-===wms_contdtl_tbl===
+===wms_bindtlst_tbl===
 |
 *gl_cmp_key
 *in_whs_key
-*wms_conthdr_key
+*wms_bin_key
-*in_item_key
+*wms_zone_key
-*im_pack_key
+*wms_conthdr_key
-*so_prod_key
+*wms_bin_depth
-*in_desc
+*wms_bin_height
-*wms_contdtl_prddt
+*wms_bin_width
-*wms_contdtl_puldt
+*wms_bin_vol
-*wms_contst_key
+*wms_binst_rem
-*wms_contdtl_qty
+*wms_binst_pc
-*wms_contdtl_uom
+*in_item_key
-*in_lot_key
+*im_pack_key
-*wms_contdtl_alloc
+*in_lot_key
-*wms_contdtl_vol
+*wms_contdtl_puldt
-*wms_contdtl_key
+*wms_contdtl_alloc
-*wms_contdtl_ctwgt
+*wms_contst_key
-*wms_user_paramVC1
+*wms_conthdr_lstmv
-*wms_user_paramVC2
+*wms_contdtl_qty
-*wms_user_paramVC3
+*wms_bin_type
-*wms_user_paramVC4
+*wms_contdtl_key
-*wms_user_paramVC5
+*wms_count_key
-*wms_user_paramVC6
+*wms_count_qty
-*wms_user_paramVC7
+*wms_count_var
-*wms_user_paramVC8
+*lastCount
-*wms_user_paramVC9
+*not_on_picklist
-*wms_user_paramVC10
+*dont_trackvol
-*wms_user_paramF1
+|
-*wms_user_paramF2
+*varchar(3)
-*wms_user_paramF3
+*varchar(4)
-*wms_user_paramF4
+*varchar(13)
-*wms_user_paramF5
+*varchar(10)
-*wms_contdtl_crtdt
+*varchar(10)
-|
+*float
-*varchar(3)
+*float
-*varchar(4)
+*float
-*varchar(10)
+*float
-*varchar(30)
+*float
-*varchar(6)
+*int
-*varchar(20)
+*varchar(30)
-*varchar(60)
+*varchar(6)
-*datetime
+*varchar(25)
 *datetime
-*varchar(10)
+*varchar(20)
-*float
+*varchar(10)
-*varchar(6)
+*datetime
-*varchar(25)
+*float
 *varchar(10)
-*float
+*int
 *int
 *float
-*varchar(255)
+*float
-*varchar(255)
+*datetime
-*varchar(255)
+*int
-*varchar(255)
+*int
-*varchar(255)
-*varchar(255)
-*varchar(255)
-*varchar(255)
-*varchar(255)
-*varchar(255)
-*float
-*float
-*float
-*float
-*float
-*datetime
 |
 *NOTNULL
 *NOTNULL
 *NOTNULL
 *NULL
-*NULL
+*NOTNULL
 *NULL
 *NULL
 *NULL
-*NOTNULL
+*NULL
 *NULL
 *NULL
-*NULL
+*NOTNULL
 *NOTNULL
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
-*NOTNULL
+*NULL
 *NULL
 *NULL
 *NULL
 *NULL
-*NULL
+*NOTNULL
 *NULL
 *NULL
 *NULL
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
 |
 *Company Key
 *Warehouse Key
-*Tracking Key
+*Bin Key
-*Item Key
+*Zone Key
-*Pack Key
+*Tracking Key
-*Product # (UPC code)
+*Bin Depth Value
-*Item Description Value
+*Bin Height Value
-*Production Date/Time Value
+*Bin Width Value
-*Pull Date Value
+*Bin Volume Value
-*Container Status Key
+*Volume Remaining Value
-*Item Quantity Value
+*Number Of Pallets Value
-*Unit Of Measure Value
+*Item Key
-*Lot Key
+*Pack Key
-*Pallet Allocated Value
+*Lot Key
-*Item Volume Value
+*Pull Date/Time Value
-*Container Detail Key
+*Pallet Allocation Value
-*Container Detail Catch Weight
+*Tracking Key
-*User defined Parameter #1
+*Last Moved Date/Time Value
-*User defined Parameter #2
+*Detail Quantity
-*User defined Parameter #3
+*Bin Type
-*User defined Parameter #4
+*Container Detail Key
-*User defined Parameter #5
+*Count Key
-*User defined Parameter #6
+*Cycle Count Quantity Value
-*User defined Parameter #7
+*Cycle Count Variance Value
-*User defined Parameter #8
+*Counted On Date/Time Value
-*User defined Parameter #9
+*Don't show bin contents in picklist
-*User defined Parameter #10
+*Dont' calculate bin volume
-*User defined Parameter F1
-*User defined Parameter F2
-*User defined Parameter F3
-*User defined Parameter F4
-*User defined Parameter F5
-*Creation Date/Time Value
 |}
@@ Line 1,881: / Line 2,177: @@
 |-
-===wms_context_tbl===
+===wms_case_tbl===
 |
 *gl_cmp_key
 *in_whs_key
-*wms_conthdr_key
+*wms_case_num
-*wms_context_variety
+*created_on
-*wms_context_linemtch
+*changed_on
-*wms_context_idfield
+*created_by
-*created_on
+*changed_by
-*changed_on
+*lock_count
-*created_by
-*changed_by
-*lock_count
 |
 *varchar(2)
 *varchar(4)
-*varchar(10)
+*int
-*varchar(10)
-*varchar(10)
-*varchar(4)
 *datetime
 *datetime
 *varchar(8)
 *varchar(8)
 *int
 |
 *NOTNULL
 *NOTNULL
 *NOTNULL
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
 *NOTNULL
 *NOTNULL
-*NOTNULL
-*NOTNULL
-*NOTNULL
 |
 *Company Key
 *Warehouse Key
-*Tracking Key
+*Case Number Value
-*Context Variety Value
+*Created on Date
-*Context Line Match Value
+*Changed on Date
-*Context ID Field Value
+*User Key
-*Created on Date/Time Value
+*User Key
-*Changed on Date/Time Value
+*Lock Counter Value
-*User Key
-*User Key
-*Lock Count Value
 |}
@@ Line 1,939: / Line 2,223: @@
 |-
-===wms_conthdr_tbl===
+===wms_comments_tbl===
+|
+*company
+*warehouse
+*comments
+|
+*varchar(2)
+*varchar(4)
+*varchar(60)
 |
-*gl_cmp_key
+*NULL
-*in_whs_key
+*NULL
-*wms_conthdr_key
+*NULL
-*wms_contst_key
+|
-*in_locn_key
+*Company Key
-*wms_bin_key
+*Warehouse Key
-*wms_conthdr_lstmv
+*Comment Text
-*wms_contty_key
-*wms_conthdr_lstdt
+|}
-*sa_user_key
-*wms_contst_reldt
+{| border="1" cellpadding="2" valign="top" halign="left"
-*wms_group_key
+!Column
-*wms_conthdr_vol
+!Data Type
-*lockCounter
+!Nullable
-|
+!Key Description
-*varchar(3)
+|-
-*varchar(4)
-*varchar(10)
+===wms_contadj_tbl===
-*varchar(10)
-*varchar(10)
-*varchar(15)
-*datetime
-*varchar(10)
-*datetime
-*varchar(8)
-*datetime
-*int
-*float
-*int
 |
-*NOTNULL
+*gl_cmp_key
-*NOTNULL
+*in_whs_key
-*NOTNULL
+*wms_conthdr_key
-*NULL
+*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
@@ Line 1,983: / Line 2,290: @@
 *NULL
 *NULL
+*NOTNULL
 *NULL
 *NULL
 |
 *Company Key
 *Warehouse Key
 *Tracking Key
-*Container Status Value
+*Item Key
-*Location Key
+*Pack Key
-*Bin Key
+*Adjusted Quantity Value
-*Last Moved Date/Time Value
+*Reason For Adjustment Value
-*Container Type
+*User Key
-*Container Last Changed Date Value
+*Transaction Date/Time Value
-*User Key
+*Container Adj Comment Value
-*Release Date/Time
+*Container Detail Key
-*Group Key
+*Container Case Key
-*Container Volume Value
+*Container Adj Control Num Value
-*Lock Counter Value
 |}
@@ Line 2,009: / Line 2,316: @@
 |-
-===wms_contst_tbl===
+===wms_contcase_tbl===
 |
 *gl_cmp_key
 *in_whs_key
-*wms_contst_key
+*wms_conthdr_key
-*wms_contst_desc
+*wms_contdtl_key
-*wms_contst_type
+*wms_contcase_key
-*wms_contst_reldt
+*wms_contcase_ctwgt
-*wms_contst_relby
+*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(3)
+*varchar(2)
 *varchar(4)
 *varchar(10)
+*int
 *varchar(60)
-*varchar(10)
+*float
-*varchar(8)
+*int
-*varchar(8)
+*datetime
+*datetime
+*datetime
+*varchar(8)
+*varchar(8)
+*int
+*int
+*float
+*varchar(25)
+*varchar(25)
+*int
+*int
 |
-*NOTNULL
 *NOTNULL
 *NOTNULL
 *NULL
 *NULL
+*NOTNULL
 *NULL
 *NULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NULL
+*NULL
+*NULL
 |
 *Company Key
 *Warehouse Key
-*Container Status Value
+*Tracking Key
-*Container Description Value
+*Tracking Detail Key
-*Container Type Value
+*Tracking Case Key
-*Container Release Date Value
+*Tracking Catch Weight Value
-*Container Release By Date 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
 |}
@@ Line 2,051: / Line 2,406: @@
 |-
-===wms_contty_tbl===
+===wms_contdtl_tbl===
 |
 *gl_cmp_key
 *in_whs_key
-*wms_contty_key
+*wms_conthdr_key
-*wms_contty_height
+*in_item_key
-*wms_contty_depth
+*im_pack_key
-*wms_contty_width
+*so_prod_key
-*wms_contty_lay
+*in_desc
-*wms_contty_case
+*wms_contdtl_prddt
-*wms_contty_uom
+*wms_contdtl_puldt
-*wms_contty_dftrtype
+*wms_contst_key
-|
+*wms_contdtl_qty
-*varchar(3)
+*wms_contdtl_uom
-*varchar(4)
+*in_lot_key
-*varchar(10)
+*wms_contdtl_alloc
-*float
+*wms_contdtl_vol
-*float
+*wms_contdtl_key
-*float
+*wms_contdtl_ctwgt
-*int
+*wms_user_paramVC1
-*int
+*wms_user_paramVC2
-*varchar(6)
+*wms_user_paramVC3
-*varchar(50)
+*wms_user_paramVC4
-|
+*wms_user_paramVC5
-*NOTNULL
+*wms_user_paramVC6
-*NOTNULL
+*wms_user_paramVC7
-*NOTNULL
+*wms_user_paramVC8
-*NULL
+*wms_user_paramVC9
-*NULL
+*wms_user_paramVC10
-*NULL
+*wms_user_paramF1
-*NULL
+*wms_user_paramF2
-*NULL
+*wms_user_paramF3
-*NULL
+*wms_user_paramF4
-*NULL
+*wms_user_paramF5
-|
+*wms_contdtl_crtdt
-*Company Key
+|
-*Warehouse Key
+*varchar(3)
-*Container Type Value
+*varchar(4)
-*Container Height Value
+*varchar(10)
-*Container Depth Value
+*varchar(30)
-*Container Width Value
+*varchar(6)
-*Number Of Layers Value
+*varchar(20)
-*Number Of Cases Value
+*varchar(60)
-*Unit Of Measure Value
+*datetime
-*Type Of Transaction Value
+*datetime
-|}
+*varchar(10)
+*float
-{| border="1" cellpadding="2" valign="top" halign="left"
+*varchar(6)
-!Column
+*varchar(25)
-!Data Type
+*varchar(20)
-!Nullable
+*float
-!Key Description
+*int
-|-
+*float
+*varchar(255)
-===wms_contxf_tbl===
+*varchar(255)
-|
+*varchar(255)
-*gl_cmp_key
+*varchar(255)
-*in_whs_key
+*varchar(255)
-*wms_contty_key
+*varchar(255)
-*in_item_key
+*varchar(255)
-*im_pack_key
+*varchar(255)
-*wms_desc
+*varchar(255)
-*so_prod_key
+*varchar(255)
-*wms_active_qty
+*float
-*wms_hold_qty
+*float
-*toleranceOver
+*float
-*wms_contxf_pseq
+*float
-|
+*float
-*varchar(3)
+*datetime
-*varchar(4)
-*varchar(10)
-*varchar(30)
-*varchar(6)
-*varchar(60)
-*varchar(20)
-*float
-*float
-*float
-*int
 |
+*NOTNULL
 *NOTNULL
 *NOTNULL
-*NOTNULL
+*NULL
-*NOTNULL
-*NOTNULL
 *NULL
 *NULL
@@ Line 2,141: / Line 2,485: @@
 *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
-*Container Type Value
+*Tracking Key
 *Item Key
 *Pack Key
-*Item Description Value
+*Product # (UPC code)
-*Adage Sales Order Production Key
+*Item Description Value
-*Container Active Quantity
+*Production Date/Time Value
-*Container Hold Quantity
+*Pull Date Value
-*Tolerance Over Value
+*Container Status Key
-*Container Cross Reference Seq 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
 |}
@@ Line 2,163: / Line 2,552: @@
 |-
-===wms_counter_tbl===
+===wms_context_tbl===
 |
-*wms_counter_type
+*gl_cmp_key
-*wms_counter_idx
+*in_whs_key
-|
+*wms_conthdr_key
-*smallint
+*wms_context_variety
-*int
+*wms_context_linemtch
-|
+*wms_context_idfield
-*NOTNULL
-*NOTNULL
-|
-*Counter Name Value
-*Current Counter Number Value
-|}
-{| border="1" cellpadding="2" valign="top" halign="left"
-!Column
-!Data Type
-!Nullable
-!Key Description
-|-
-===wms_ctwght_tbl===
-|
-*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
@@ Line 2,202: / Line 2,565: @@
 *changed_by
 *lock_count
-*wms_ctwght_netwt
+|
-*wms_ctwght_backdt
+*varchar(2)
-*wms_ctwght_sell
+*varchar(4)
-|
+*varchar(10)
-*varchar(2)
+*varchar(10)
-*varchar(4)
+*varchar(10)
-*varchar(20)
+*varchar(4)
-*varchar(6)
+*datetime
-*float
+*datetime
-*float
+*varchar(8)
-*float
+*varchar(8)
-*varchar(40)
+*int
-*varchar(60)
-*varchar(6)
-*datetime
-*datetime
-*varchar(8)
-*varchar(8)
-*int
-*float
-*int
-*int
 |
 *NOTNULL
 *NOTNULL
 *NOTNULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
 *NOTNULL
-*NULL
+*NOTNULL
 *NOTNULL
 *NOTNULL
 *NOTNULL
-*NOTNULL
-*NOTNULL
-*NOTNULL
-*NOTNULL
-*NOTNULL
-*NULL
-*NOTNULL
 |
 *Company Key
 *Warehouse Key
-*Item Key
+*Tracking Key
-*Pack Key
+*Context Variety Value
-*Catch Weight Minimum Tolerance
+*Context Line Match Value
-*Catch Weight Maximum Tolerance
+*Context ID Field Value
-*Catch Weight Tare Weight Value
+*Created on Date/Time Value
-*Catch Weight SCC Value
+*Changed on Date/Time Value
-*UPC Key
+*User Key
-*UCC 128 Item
+*User Key
-*Created on Date/Time Value
+*Lock Count 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
 |}
@@ Line 2,271: / Line 2,610: @@
 |-
-===wms_custpull_tbl===
+===wms_conthdr_tbl===
-|
-*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
-|}
-{| border="1" cellpadding="2" valign="top" halign="left"
-!Column
-!Data Type
-!Nullable
-!Key Description
-|-
-===wms_cycnt_tbl===
 |
 *gl_cmp_key
 *in_whs_key
 *wms_conthdr_key
-*in_cycnt_key
+*wms_contst_key
-*wms_cycnt_entlv
+*in_locn_key
-*wms_cycnt_ent
+*wms_bin_key
-*wms_cycnt_stat
+*wms_conthdr_lstmv
-*wms_cycnt_ent2
+*wms_contty_key
-|
+*wms_conthdr_lstdt
-*varchar(3)
+*sa_user_key
-*varchar(4)
+*wms_contst_reldt
-*varchar(10)
+*wms_group_key
-*varchar(10)
+*wms_conthdr_vol
-*varchar(10)
+*lockCounter
-*varchar(20)
+|
-*varchar(10)
+*varchar(3)
-*varchar(20)
+*varchar(4)
+*varchar(10)
+*varchar(10)
+*varchar(10)
+*varchar(15)
+*datetime
+*varchar(10)
+*datetime
+*varchar(8)
+*datetime
+*int
+*float
+*int
 |
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
 *NULL
 *NULL
 *NULL
 *NULL
 *NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
 |
 *Company Key
 *Warehouse Key
 *Tracking Key
-*Cycle Count Key
+*Container Status Value
-*Cycle Count Entity Level Key
+*Location Key
-*Cycle Count Entity Key
+*Bin Key
-*Cycle Count Status Value
+*Last Moved Date/Time Value
-*Cycle Count Entity 2 Key
+*Container Type
+*Container Last Changed Date Value
+*User Key
+*Release Date/Time
+*Group Key
+*Container Volume Value
+*Lock Counter Value
 |}
@@ Line 2,347: / Line 2,680: @@
 |-
-===wms_erpint_tbl===
+===wms_contst_tbl===
 |
 *gl_cmp_key
 *in_whs_key
-*wms_erpint_type
+*wms_contst_key
-*wms_erpint_start
+*wms_contst_desc
-*wms_erpint_pid
+*wms_contst_type
+*wms_contst_reldt
+*wms_contst_relby
 |
 *varchar(3)
 *varchar(4)
-*varchar(30)
+*varchar(10)
-*datetime
+*varchar(60)
-*int
+*varchar(10)
+*varchar(8)
+*varchar(8)
 |
 *NOTNULL
 *NOTNULL
 *NOTNULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
+*NULL
+*NULL
 |
 *Company Key
 *Warehouse Key
-*ERP Interface Type Value
+*Container Status Value
-*ERP Interface Start Value
+*Container Description Value
-*ERP Interface Part ID Value
+*Container Type Value
+*Container Release Date Value
+*Container Release By Date Value
 |}
@@ Line 2,381: / Line 2,722: @@
 |-
-===wms_except_tbl===
+===wms_contty_tbl===
 |
 *gl_cmp_key
 *in_whs_key
-*wms_tran_key
+*wms_contty_key
-*wms_conthdr_key
+*wms_contty_height
-*wms_except_sbin
+*wms_contty_depth
-*wms_except_ubin
+*wms_contty_width
-*wms_except_sqty
+*wms_contty_lay
-*wms_except_uqty
+*wms_contty_case
-*wms_except_note
+*wms_contty_uom
-*sa_user_key
+*wms_contty_dftrtype
-*wms_except_crtdt
 |
 *varchar(3)
 *varchar(4)
 *varchar(10)
-*varchar(10)
+*float
-*varchar(15)
+*float
-*varchar(15)
+*float
-*float
+*int
-*float
+*int
-*varchar(255)
+*varchar(6)
-*varchar(8)
+*varchar(50)
-*datetime
 |
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
 *NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
 |
 *Company Key
 *Warehouse Key
-*Transaction Key
+*Container Type Value
-*Tracking Key
+*Container Height Value
-*Bin Key
+*Container Depth Value
-*Bin Key
+*Container Width Value
-*System Expected Quantity Value
+*Number Of Layers Value
-*User Entered Quantity Value
+*Number Of Cases Value
-*Exception Explanation Value
+*Unit Of Measure Value
-*User Key
+*Type Of Transaction Value
-*Exception Creation Date/Time
 |}
@@ Line 2,439: / Line 2,776: @@
 |-
-===wms_group_tbl===
+===wms_contxf_tbl===
 |
 *gl_cmp_key
 *in_whs_key
-*wms_group_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)
-*int
+*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
-*Group 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
 |}
@@ Line 2,465: / Line 2,834: @@
 |-
-===wms_kit_tbl===
+===wms_counter_tbl===
+|
+*wms_counter_type
+*wms_counter_idx
+|
+*smallint
+*int
 |
-*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
+*Counter Name Value
-*Warehouse Key
+*Current Counter Number Value
-*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
@@ Line 2,531: / Line 2,856: @@
 |-
-===wms_lhold_tbl===
+===wms_ctwght_tbl===
 |
 *gl_cmp_key
 *in_whs_key
-*sa_user_key
+*in_item_key
-*wms_lhold_lot
+*im_pack_key
-*wms_lhold_bgdt
+*wms_ctwght_minwgt
-*wms_lhold_eddt
+*wms_ctwght_maxwgt
-*wms_lhold_cmt
+*wms_ctwght_tare
-*wms_lhold_trdt
+*wms_ctwght_scc
-|
+*upc_key
-*varchar(3)
+*ucc128_item
-*varchar(4)
+*created_on
-*varchar(8)
+*changed_on
-*varchar(25)
+*created_by
-*datetime
+*changed_by
-*datetime
+*lock_count
-*varchar(255)
+*wms_ctwght_netwt
-*datetime
+*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
 |
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
 *NULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NOTNULL
 |
 *Company Key
 *Warehouse Key
-*User Key
+*Item Key
-*Lot Hold Lot Value
+*Pack Key
-*Beginning Hold Date/Time Value
+*Catch Weight Minimum Tolerance
-*Ending Hold Date/Time Value
+*Catch Weight Maximum Tolerance
-*Comment Value
+*Catch Weight Tare Weight Value
-*Date Lot Placed On Hold 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
 |}
@@ Line 2,577: / Line 2,942: @@
 |-
-===wms_load_tbl===
+===wms_custpull_tbl===
 |
 *gl_cmp_key
-*so_brnch_key
+*in_whs_key
-*so_hdr_key
+*ap_cust_key
-*wms_load_bol
+*wms_custpull_puldt
-*wms_load_trailer
+|
-*wms_load_seal
+*varchar(3)
-*wms_load_chep
+*varchar(4)
-*wms_load_shpdt
+*varchar(10)
-*in_towhs_key
+*int
-*carrier
-*prePaidFreight
-*status
-*loadKey
-|
-*varchar(2)
-*varchar(4)
-*varchar(10)
-*varchar(25)
-*varchar(25)
-*varchar(45)
-*int
-*datetime
-*varchar(4)
-*varchar(10)
-*float
-*varchar(10)
-*varchar(10)
 |
 *NOTNULL
 *NOTNULL
 *NOTNULL
-*NOTNULL
+*NULL
-*NULL
+|
-*NULL
+*Company Key
-*NULL
+*Warehouse Key
-*NULL
+*Customer Key
-*NULL
+*Customer Pull Date Value
-*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
 |}
@@ Line 2,643: / Line 2,972: @@
 |-
-===wms_loadnm_tbl===
+===wms_cycnt_tbl===
 |
 *gl_cmp_key
-*so_brnch_key
+*in_whs_key
-*so_hdr_key
+*wms_conthdr_key
-*wms_loadnm_key
+*in_cycnt_key
-|
+*wms_cycnt_entlv
-*varchar(2)
+*wms_cycnt_ent
-*varchar(4)
+*wms_cycnt_stat
-*varchar(10)
+*wms_cycnt_ent2
-*int
+|
+*varchar(3)
+*varchar(4)
+*varchar(10)
+*varchar(10)
+*varchar(10)
+*varchar(20)
+*varchar(10)
+*varchar(20)
 |
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
 *NULL
+*NULL
+*NULL
+*NULL
+*NULL
 |
 *Company Key
-*Branch Key
+*Warehouse Key
 *Tracking Key
-*Load Name Key
+*Cycle Count Key
+*Cycle Count Entity Level Key
+*Cycle Count Entity Key
+*Cycle Count Status Value
+*Cycle Count Entity 2 Key
 |}
@@ Line 2,673: / Line 3,018: @@
 |-
-===wms_lothist_tbl===
+===wms_erpint_tbl===
 |
 *gl_cmp_key
 *in_whs_key
-*wms_conthdr_key
+*wms_erpint_type
-*wms_tran_type
+*wms_erpint_start
-*wms_tran_key
+*wms_erpint_pid
-*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(30)
-*varchar(15)
+*datetime
-*varchar(20)
+*int
-*varchar(25)
-*varchar(8)
-*datetime
-*float
-*varchar(2)
-*int
-*varchar(255)
 |
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
 *NOTNULL
-*NULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
 |
 *Company Key
 *Warehouse Key
-*Tracking Key
+*ERP Interface Type Value
-*Transaction Type Key
+*ERP Interface Start Value
-*Transaction Key
+*ERP Interface Part ID Value
-*Lot Key
-*User Key
-*Date of transaction Value
-*Lot History Quantity Value
-*Unit Of Measure Value
-*Container detail Key
-*Comment Value
 |}
@@ Line 2,735: / Line 3,052: @@
 |-
-===wms_outint_tbl===
+===wms_except_tbl===
 |
 *gl_cmp_key
-*so_brnch_key
+*in_whs_key
-*so_hdr_key
+*wms_tran_key
-*so_prod_key
+*wms_conthdr_key
-*wms_conthdr_key
+*wms_except_sbin
-*wms_outint_qty
+*wms_except_ubin
-*wms_outint_uom
+*wms_except_sqty
-*in_lot_key
+*wms_except_uqty
-*wms_outint_error
+*wms_except_note
 *sa_user_key
-*wms_outint_crtdt
+*wms_except_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)
-*varchar(10)
+*varchar(15)
-*float
+*varchar(15)
-*varchar(2)
+*float
-*varchar(25)
+*float
 *varchar(255)
 *varchar(8)
 *datetime
-*int
-*int
-*varchar(4)
-*varchar(4)
-*smallint
-*datetime
-*varchar(20)
-*varchar(6)
-*varchar(60)
 |
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
 *NULL
 *NULL
 *NULL
 *NULL
 *NULL
 *NULL
 *NULL
 *NULL
-*NOTNULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
 |
 *Company Key
-*Branch key
+*Warehouse Key
-*Order Key
+*Transaction Key
-*Product Key
+*Tracking Key
-*Tracking Key
+*Bin Key
-*Quantity Value
+*Bin Key
-*Unit of Measure Value
+*System Expected Quantity Value
-*Lot Key
+*User Entered Quantity Value
-*Status Value
+*Exception Explanation Value
 *User Key
-*Date/Time Stamp Value
+*Exception Creation Date/Time
-*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
 |}
@@ Line 2,829: / Line 3,110: @@
 |-
-===wms_piint_tbl===
+===wms_group_tbl===
+|
+*gl_cmp_key
+*in_whs_key
+*wms_group_key
 |
-*wms_piint_error
+*varchar(3)
-*gl_cmp_key
+*varchar(4)
-*sf_plant_key
+*int
-*in_whs_key
+|
-*in_locn_key
+*NOTNULL
-*pm_shop_key
+*NOTNULL
-*pm_shop_ordtp
+*NOTNULL
-*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
 |
-*varchar(255)
+*Company Key
-*varchar(3)
+*Warehouse Key
-*varchar(10)
+*Group Key
-*varchar(4)
+|}
-*varchar(10)
-*varchar(10)
+{| border="1" cellpadding="2" valign="top" halign="left"
-*varchar(1)
+!Column
-*int
+!Data Type
-*float
+!Nullable
-*float
+!Key Description
-*varchar(2)
+|-
-*varchar(8)
-*datetime
+===wms_kit_tbl===
-*varchar(20)
-*varchar(6)
-*varchar(10)
-*varchar(25)
-*datetime
-*varchar(60)
-*int
-*int
-*int
-*varchar(10)
 |
-*NULL
+*gl_cmp_key
-*NULL
+*in_whs_key
-*NULL
+*wms_kititem_key
-*NULL
+*wms_kitpack_key
-*NULL
+*in_item_key
-*NULL
+*im_pack_key
-*NULL
+*wms_kit_qty
-*NULL
+*wms_kit_uom
-*NULL
+*created_by
-*NULL
+*created_on
-*NULL
+*changed_by
-*NULL
+*changed_on
-*NULL
+*lock_count
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NOTNULL
-*NOTNULL
-*NOTNULL
-*NULL
 |
-*Message Value
+*varchar(2)
-*Company Key
+*varchar(4)
-*Plant Key
+*varchar(20)
-*Warehouse Key
+*varchar(6)
-*Location Key
+*varchar(20)
-*Production Order Key
+*varchar(6)
-*Order Type Value
+*float
-*Routing sequence
+*varchar(2)
-*Batch Quantity Value
+*varchar(8)
-*Scrapped Quantity Value
+*datetime
-*Unit of Measure
+*varchar(8)
-*User Key
+*datetime
-*Prod Issue Create Date Value
+*int
-*Item Key
+|
-*Pack Key
+*NOTNULL
-*Tracking Key
+*NOTNULL
-*Lot Key
+*NOTNULL
-*Container Pull Date/Time
+*NOTNULL
-*Production Issue Control Key
+*NOTNULL
-*Transaction Key
+*NOTNULL
-*Container Detail Key
+*NOTNULL
-*PM Material Key
+*NOTNULL
-*Original Tracking Key
+*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
 |}
@@ Line 2,935: / Line 3,202: @@
 |-
-===wms_pmint_tbl===
+===wms_lhold_tbl===
 |
-*wms_pmint_error
+*gl_cmp_key
-*gl_cmp_key
+*in_whs_key
-*sf_plant_key
+*sa_user_key
-*in_whs_key
+*wms_lhold_lot
-*pm_shop_key
+*wms_lhold_bgdt
-*pm_shop_ordtp
+*wms_lhold_eddt
-*wms_pmint_bqty
+*wms_lhold_cmt
-*wms_pmint_sqty
+*wms_lhold_trdt
-*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
 |
-*varchar(255)
 *varchar(3)
-*varchar(10)
 *varchar(4)
-*varchar(10)
-*varchar(1)
-*float
-*float
-*varchar(2)
 *varchar(8)
+*varchar(25)
+*datetime
 *datetime
-*varchar(20)
+*varchar(255)
-*varchar(6)
+*datetime
-*varchar(10)
-*int
-*varchar(25)
-*varchar(50)
 |
 *NULL
 *NULL
 *NULL
 *NULL
 *NULL
 *NULL
 *NULL
 *NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NOTNULL
-*NOTNULL
-*NULL
-*NULL
 |
-*Message Value
+*Company Key
-*Company Key
+*Warehouse Key
-*Plant Key
+*User Key
-*Warehouse Key
+*Lot Hold Lot Value
-*Order Key
+*Beginning Hold Date/Time Value
-*Shop Order Type Key
+*Ending Hold Date/Time Value
-*PM Batch Quantity Value
+*Comment Value
-*PM Scrapped Quantity Value
+*Date Lot Placed On Hold 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
 |}
@@ Line 3,017: / Line 3,248: @@
 |-
-===wms_pmintdtl_tbl===
+===wms_load_tbl===
+|
+*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
 |
-*gl_cmp_key
+*varchar(2)
-*sf_plant_key
+*varchar(4)
-*in_whs_key
+*varchar(10)
-*pm_shop_key
+*varchar(25)
-*wms_conthdr_key
+*varchar(25)
-*wms_contdtl_key
+*varchar(45)
-*wms_contcase_key
+*int
-*in_sublot_key
+*datetime
-*wms_contcase_ctwgt
+*varchar(4)
-*wms_contcase_acwgt
+*varchar(10)
-*wms_contcase_prddt
+*float
-|
+*varchar(10)
-*varchar(2)
+*varchar(10)
-*varchar(4)
+*varchar(25)
-*varchar(4)
+*varchar(5)
-*varchar(10)
+*varchar(5)
-*varchar(10)
+*varchar(5)
-*int
+*varchar(5)
-*varchar(60)
+*varchar(5)
-*int
+*varchar(25)
-*float
-*float
-*datetime
 |
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
 *NULL
 *NULL
 *NULL
 *NULL
 *NULL
 *NULL
 *NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
 |
-*Company Key
+*Company key
-*Plant Key
+*Branch Key
-*Warehouse Key
+*Tracking Key
-*Order Key
+*Load BOL Value
-*Tracking Key
+*Load Trailer Value
-*Container Detail Key
+*Load Seal Value
-*Containe Case Key
+*Load Chep Value
-*Sub Lot Key
+*Load Ship Date/Time Value
-*Case Catchweight Value
+*To WHS Key
-*Case Actual Weight Value
+*Carrier Value
-*Case Production Date/Time
+*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
 |}
@@ Line 3,075: / Line 3,342: @@
 |-
-===wms_point_tbl===
+===wms_loadnm_tbl===
+|
+*gl_cmp_key
+*so_brnch_key
+*so_hdr_key
+*wms_loadnm_key
 |
-*gl_cmp_key
+*varchar(2)
-*so_brnch_key
+*varchar(4)
-*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)
+*int
-*varchar(6)
-*float
-*varchar(6)
-*varchar(25)
-*varchar(20)
-*varchar(255)
-*varchar(8)
-*datetime
-*smallint
-*varchar(10)
-*int
-*varchar(60)
 |
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
 *NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NULL
-*NOTNULL
-*NULL
 |
 *Company Key
 *Branch Key
-*Warehouse Key
+*Tracking Key
-*Tracking Key
+*Load Name 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
 |}
@@ Line 3,165: / Line 3,372: @@
 |-
-===wms_print_tbl===
+===wms_lothist_tbl===
 |
 *gl_cmp_key
 *in_whs_key
-*wms_print_key
+*wms_conthdr_key
-*wms_print_desc
+*wms_tran_type
-*wms_print_def
+*wms_tran_key
-*pr_rotate_key
+*in_lot_key
-|
+*sa_user_key
-*varchar(3)
+*wms_lothist_crtdt
+*wms_lothist_qty
+*wms_lothist_uom
+*wms_contdtl_key
+*comment_key
+|
+*varchar(3)
 *varchar(4)
-*varchar(100)
+*varchar(10)
-*varchar(100)
+*varchar(15)
+*varchar(20)
+*varchar(25)
+*varchar(8)
+*datetime
+*float
+*varchar(2)
 *int
-*float
+*varchar(255)
 |
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
 *NULL
 *NULL
-*NOTNULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NULL
+*NOTNULL
+*NULL
 |
 *Company Key
 *Warehouse Key
-*Printer Name Value
+*Tracking Key
-*Printer Description Value
+*Transaction Type Key
-*Printer Definition Value
+*Transaction Key
-*Print Rotate Value
+*Lot Key
+*User Key
+*Date of transaction Value
+*Lot History Quantity Value
+*Unit Of Measure Value
+*Container detail Key
+*Comment Value
 |}
@@ Line 3,203: / Line 3,434: @@
 |-
-===wms_pultol_tbl===
+===wms_outint_tbl===
 |
 *gl_cmp_key
-*in_whs_key
+*so_brnch_key
-*in_item_key
+*so_hdr_key
-*im_pack_key
+*so_prod_key
-*wms_pultol_tol
+*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(30)
+*varchar(10)
-*varchar(6)
+*varchar(30)
-*int
+*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)
 |
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
-*NULL
+*NOTNULL
 *NULL
 *NULL
-|
+*NULL
-*Company Key
+*NULL
-*Warehouse Key
+*NULL
-*Item Key
+*NULL
-*Pack Key
+*NULL
-*Pull Date Tolerance Value
+*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
 |}
@@ Line 3,237: / Line 3,528: @@
 |-
-===wms_recper_tbl===
+===wms_piint_tbl===
 |
-*gl_cmp_key
+*wms_piint_error
-*in_whs_key
+*gl_cmp_key
-*wms_recbgn_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(3)
+*varchar(255)
-*varchar(4)
+*varchar(3)
-*datetime
+*varchar(10)
-|
+*varchar(4)
-*NOTNULL
+*varchar(10)
-*NOTNULL
+*varchar(10)
-*NULL
+*varchar(1)
-|
+*int
-*Company Key
+*float
-*Warehouse Key
+*float
-*Last ERP Reconciliation Date
+*varchar(2)
-|}
+*varchar(8)
+*datetime
-{| border="1" cellpadding="2" valign="top" halign="left"
-!Column
-!Data Type
-!Nullable
-!Key Description
-|-
-===wms_screen_tbl===
-|
-*gl_cmp_key
-*in_whs_key
-*wms_screen_key
-|
-*varchar(3)
-*varchar(4)
 *varchar(20)
+*varchar(6)
+*varchar(10)
+*varchar(25)
+*datetime
+*varchar(60)
+*int
+*int
+*int
+*varchar(10)
+*varchar(3)
 |
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
-*NOTNULL
+*NULL
-|
+*NULL
-*Company Key
+*NULL
-*Warehouse Key
+*NULL
-*Screen Name Value
+*NULL
-|}
+*NULL
+*NULL
-{| border="1" cellpadding="2" valign="top" halign="left"
+*NULL
-!Column
+*NULL
-!Data Type
+*NULL
-!Nullable
+*NULL
-!Key Description
+*NULL
-|-
+*NULL
+*NULL
-===wms_sectmpl_tbl===
+*NULL
-|
+*NULL
-*gl_cmp_key
+*NULL
-*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
+*NOTNULL
 |
+*Message Value
 *Company Key
-*Warehouse Key
+*Plant Key
-*Security Template Name Key
+*Warehouse Key
-*Screen Name Key
+*Location Key
-*Security Mode Value
+*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
 |}
@@ Line 3,323: / Line 3,638: @@
 |-
-===wms_secure_tbl===
+===wms_pmint_tbl===
 |
-*gl_cmp_key
+*wms_pmint_error
-*in_whs_key
+*gl_cmp_key
-*sa_user_key
+*sf_plant_key
-*wms_screen_key
+*in_whs_key
-*wms_secure_mode
+*pm_shop_key
-|
+*pm_shop_ordtp
-*varchar(3)
+*wms_pmint_bqty
-*varchar(4)
+*wms_pmint_sqty
-*varchar(8)
+*wms_pmint_uom
-*varchar(20)
+*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
 |
-*Company Key
+*Message Value
-*Warehouse Key
+*Company Key
-*User Key
+*Plant Key
-*Screen Name Key
+*Warehouse Key
-*Security Mode Value
+*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
 |}
@@ Line 3,357: / Line 3,724: @@
 |-
-===wms_shipins_tbl      Table no longer===
+===wms_pmintdtl_tbl===
-*gl_cmp_key          varchar(3)    NOTNULL  Company Key
+|
-*in_whs_key          varchar(4)    NOTNULL  Warehouse Key
+*gl_cmp_key
-*ar_ship_key         varchar(10)    NOTNULL  AR Ship Key
+*sf_plant_key
-*so_prod_key          varchar(20)    NOTNULL  So Product Key
+*in_whs_key
-*in_instr_key        text          NOTNULL  IN Instruction Key
+*pm_shop_key
+*wms_conthdr_key
-{| border="1" cellpadding="2" valign="top" halign="left"
+*wms_contdtl_key
-!Column
+*wms_contcase_key
-!Data Type
+*in_sublot_key
-!Nullable
+*wms_contcase_ctwgt
-!Key Description
+*wms_contcase_acwgt
-|-
+*wms_contcase_prddt
-===wms_track_tbl===
+|
-*gl_cmp_key          varchar(3)     NULL    Company Key
+*varchar(2)
-*in_whs_key          varchar(4)     NULL    Warehouse Key
+*varchar(4)
-*wms_track_key        int            NOTNULL  Tracking Number Key
+*varchar(4)
+*varchar(10)
-{| border="1" cellpadding="2" valign="top" halign="left"
+*varchar(10)
-!Column
+*int
-!Data Type
+*varchar(60)
-!Nullable
+*int
-!Key Description
+*float
-|-
+*float
-===wms_user_tbl===
+*datetime
-*gl_cmp_key          varchar(3)    NULL    Company Key
+|
-*in_whs_key          varchar(4)     NULL    Warehouse Key
+*NULL
-*sa_user_key          varchar(8)     NULL    User Key
+*NULL
-*wms_print_key        varchar(100)  NULL    Default Printer Value
+*NULL
-*wms_user_lang        varchar(20)    NULL    User Language Key
+*NULL
-*wms_user_tbl_key    int (IDENTITY) NOTNULL  User Table Key
+*NULL
+*NULL
-{| border="1" cellpadding="2" valign="top" halign="left"
+*NULL
-!Column
+*NULL
-!Data Type
+*NULL
-!Nullable
+*NULL
-!Key Description
+*NULL
-|-
+|
-===wms_usercols_tbl===
+*Company Key
-*gl_cmp_key          varchar(2)     NOTNULL  Company Key
+*Plant Key
-*in_whs_key          varchar(4)     NOTNULL  Warehouse Key
+*Warehouse Key
-*wms_table_key        varchar(20)    NOTNULL  Table Key
+*Order Key
-*wms_col_key          varchar(20)    NOTNULL  New Column Database Key
+*Tracking Key
-*wms_col_name        varchar(20)    NOTNULL  Column Common Name
+*Container Detail Key
-*wms_col_shortname    varchar(5)     NOTNULL  Short Name Value
+*Containe Case Key
-*wms_col_type        varchar(10)    NOTNULL  Column Type Value
+*Sub Lot Key
-*wms_col_default      varchar(26)    NULL    Column Default Value
+*Case Catchweight Value
-*wms_col_min          varchar(26)    NULL    Column Minimum Tolerance Value
+*Case Actual Weight Value
-*wms_col_max          varchar(26)    NULL    Column Maximum Tolerance Value
+*Case Production Date/Time
-*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
 {| border="1" cellpadding="2" valign="top" halign="left"
@@ Line 3,422: / Line 3,781: @@
 !Key Description
 |-
-===wms_utcount_tbl===
-*gl_cmp_key          varchar(2)    NOTNULL  Company Key
+===wms_point_tbl===
-*in_whs_key          varchar(4)    NOTNULL  Warehouse Key
+|
-*in_cycnt_key        int            NOTNULL  Cycle Count Key
+*gl_cmp_key
-*in_item_key          varchar(20)    NOTNULL  Item Key
+*so_brnch_key
-*im_pack_key          varchar(7)    NOTNULL  Pack Key
+*in_whs_key
-*in_locn_key          varchar(10)    NOTNULL  Location Key
+*wms_conthdr_key
-*en_lot_key           varchar(25)    NULL    Lot Key
+*wms_contdtl_puldt
-*sa_user_key          varchar(8)    NOTNULL  User Key
+*po_hdr_key
-*wms_utcycnt_crdt    datetime      NOTNULL  Date/Time Stamp Value
+*in_item_key
-*wms_utcycnt_qty      float         NOTNULL  Reported Quantity Value
+*im_pack_key
+*wms_point_qty
-{| border="1" cellpadding="2" valign="top" halign="left"
+*wms_point_uom
-!Column
+*in_lot_key
-!Data Type
+*wms_point_bol
-!Nullable
+*wms_point_error
-!Key Description
+*sa_user_key
-|-
+*wms_point_crtdt
-===wms_vndpull_tbl===
+*po_dtl_key
-*gl_cmp_key          varchar(3)     NOTNULL  Company Key
+*in_locn_key
-*in_whs_key          varchar(4)     NOTNULL  Warehouse Key
+*wms_contdtl_key
-*en_vend_key          varchar(10)   NOTNULL  Vendor Key
+*wms_point_control
-*wms_vndpull_puldt    int            NULL    Vendor Pull Date Value
+|
+*varchar(3)
-{| border="1" cellpadding="2" valign="top" halign="left"
+*varchar(4)
-!Column
+*varchar(4)
-!Data Type
+*varchar(10)
-!Nullable
+*datetime
-!Key Description
+*varchar(10)
-|-
+*varchar(30)
-===wms_wtint_tbl===
+*varchar(6)
-*gl_cmp_key          varchar(3)     NULL    Company Key
+*float
-*so_brnch_key        varchar(4)     NULL    Branch Key
+*varchar(6)
-*wms_conthdr_key      varchar(10)    NULL    Tracking Key
+*varchar(25)
-*wms_contdtl_puldt    datetime       NULL    Item Pull Date
+*varchar(20)
-*wt_hdr_key          varchar(10)   NULL    Warehouse Transfer Header Key
+*varchar(255)
-*in_item_key          varchar(30)   NULL    Item Key
+*varchar(8)
-*im_pack_key          varchar(6)     NULL    Packing Key
+*datetime
-*wms_wtint_qty        float          NULL    WT Quantity Value
+*smallint
-*wms_wtint_uom        varchar(6)     NULL    Unit Of Measur Value
+*varchar(10)
-*in_lot_key          varchar(25)    NULL    Lot Key
+*int
-*wms_wtint_bol        varchar(20)    NULL    WT Bill of Lading Value
+*varchar(60)
-*wms_wtint_error      varchar(255)  NULL    WT Error Message Value
+|
-*sa_user_key          varchar(8)     NULL    User Key
+*NULL
-*wms_wtint_crtdt      datetime      NULL    WT Creation Date/Time
+*NULL
-*wms_wtint_frwhs      varchar(4)     NULL    WT From Warehouse Key
+*NULL
-*wt_dtl_key          smallint      NOTNULL  WT Detail Key
+*NULL
-*in_whs_key          varchar(4)    NULL    Warehouse Key
+*NULL
-*in_locn_key          varchar(10)    NULL    In Location Key
+*NULL
-*wms_contdtl_key      int            NOTNULL  Container Detail Key
+*NULL
-*wms_wtint_control    varchar(60)    NULL    ERP Control Key
+*NULL
-*wms_wtint_key        int (IDENTITY) NOTNULL  WT Index Key
+*NULL
+*NULL
-{| border="1" cellpadding="2" valign="top" halign="left"
+*NULL
-!Column
+*NULL
-!Data Type
+*NULL
-!Nullable
+*NULL
-!Key Description
+*NULL
-|-
+*NULL
-===wms_zone_tbl===
+*NULL
-*gl_cmp_key          varchar(3)    NOTNULL  Company Key
+*NOTNULL
-*in_whs_key          varchar(4)    NOTNULL  Warehouse Key
+*NULL
-*wms_zone_key        varchar(10)    NOTNULL  Zone Key
+|
-*wms_bin_key          varchar(15)    NOTNULL  Bin Key
+*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"
@@ Line 3,493: / Line 3,871: @@
 !Key Description
 |-
+===wms_print_tbl===
+|
+*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
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_pultol_tbl===
+|
+*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
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_recper_tbl===
+|
+*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===
+|
+*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
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_screen_tbl===
+|
+*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_sectmpl_tbl===
+|
+*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===
+|
+*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
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_shipins_tbl      Table no longer===
+|
+*gl_cmp_key
+*in_whs_key
+*ar_ship_key
+*so_prod_key
+*in_instr_key
+|
+*varchar(3)
+*varchar(4)
+*varchar(10)
+*varchar(20)
+*text
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*AR Ship Key
+*So Product Key
+*IN Instruction Key
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_track_tbl===
+|
+*gl_cmp_key
+*in_whs_key
+*wms_track_key
+|
+*varchar(3)
+*varchar(4)
+*int
+|
+*NULL
+*NULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Tracking Number Key
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_user_tbl===
+|
+*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_usercols_tbl===
+|
+*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
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_utcount_tbl===
+|
+*gl_cmp_key
+*in_whs_key
+*in_cycnt_key
+*in_item_key
+*im_pack_key
+*in_locn_key
+*en_lot_key
+*sa_user_key
+*wms_utcycnt_crdt
+*wms_utcycnt_qty
+|
+*varchar(2)
+*varchar(4)
+*int
+*varchar(20)
+*varchar(7)
+*varchar(10)
+*varchar(25)
+*varchar(8)
+*datetime
+*float
+|
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+*NULL
+*NOTNULL
+*NOTNULL
+*NOTNULL
+|
+*Company Key
+*Warehouse Key
+*Cycle Count Key
+*Item Key
+*Pack Key
+*Location Key
+*Lot Key
+*User Key
+*Date/Time Stamp Value
+*Reported Quantity Value
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_vndpull_tbl===
+|
+*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
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_wtint_tbl===
+|
+*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
+|}
+{| border="1" cellpadding="2" valign="top" halign="left"
+!Column
+!Data Type
+!Nullable
+!Key Description
+|-
+===wms_zone_tbl===
+|
+*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_zonexf_tbl===
-*gl_cmp_key          varchar(3)     NOTNULL  Company Key
+|
-*in_whs_key          varchar(4)     NOTNULL  Warehouse Key
+*gl_cmp_key
-*wms_zone_key        varchar(10)   NOTNULL  Zone Key
+*in_whs_key
-*in_item_key          varchar(30)   NOTNULL  Item Key
+*wms_zone_key
-*im_pack_key          varchar(6)     NOTNULL  Pack Key
+*in_item_key
-*wms_zone_pri        int            NOTNULL  Zone Priority Value
+*im_pack_key
-*actionType          smallint      NOTNULL  Action Type Value
+*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
+|}

GX:Appendix C Whistle Database Tables: Difference between revisions