|
|
Line 2,202: |
Line 2,202: |
| | | |
| ===wms_ctwght_tbl=== | | ===wms_ctwght_tbl=== |
− | *gl_cmp_key varchar(2) NOTNULL Company Key | + | | |
− | *in_whs_key varchar(4) NOTNULL Warehouse Key | + | *gl_cmp_key |
− | *in_item_key varchar(20) NOTNULL Item Key | + | *in_whs_key |
− | *im_pack_key varchar(6) NOTNULL Pack Key | + | *in_item_key |
− | *wms_ctwght_minwgt float NOTNULL Catch Weight Minimum Tolerance | + | *im_pack_key |
− | *wms_ctwght_maxwgt float NOTNULL Catch Weight Maximum Tolerance | + | *wms_ctwght_minwgt |
− | *wms_ctwght_tare float NOTNULL Catch Weight Tare Weight Value | + | *wms_ctwght_maxwgt |
− | *wms_ctwght_scc varchar(40) NULL Catch Weight SCC Value | + | *wms_ctwght_tare |
− | *upc_key varchar(60) NOTNULL UPC Key | + | *wms_ctwght_scc |
− | *ucc128_item varchar(6) NOTNULL UCC 128 Item | + | *upc_key |
− | *created_on datetime NOTNULL Created on Date/Time Value | + | *ucc128_item |
− | *changed_on datetime NOTNULL Changed on Date/Time Value | + | *created_on |
− | *created_by varchar(8) NOTNULL User Key | + | *changed_on |
− | *changed_by varchar(8) NOTNULL User Key | + | *created_by |
− | *lock_count int NOTNULL Lock Count Value | + | *changed_by |
− | *wms_ctwght_netwt float NOTNULL Catch weight Net Weight Value | + | *lock_count |
− | *wms_ctwght_backdt int NULL Catch Weight Back Date | + | *wms_ctwght_netwt |
− | *wms_ctwght_sell int NOTNULL Catch Weight Sell Value | + | *wms_ctwght_backdt |
| + | *wms_ctwght_sell |
| + | | |
| + | *varchar(2) |
| + | *varchar(4) |
| + | *varchar(20) |
| + | *varchar(6) |
| + | *float |
| + | *float |
| + | *float |
| + | *varchar(40) |
| + | *varchar(60) |
| + | *varchar(6) |
| + | *datetime |
| + | *datetime |
| + | *varchar(8) |
| + | *varchar(8) |
| + | *int |
| + | *float |
| + | *int |
| + | *int |
| + | | |
| + | *NOTNULL |
| + | *NOTNULL |
| + | *NOTNULL |
| + | *NOTNULL |
| + | *NOTNULL |
| + | *NOTNULL |
| + | *NOTNULL |
| + | *NULL |
| + | *NOTNULL |
| + | *NOTNULL |
| + | *NOTNULL |
| + | *NOTNULL |
| + | *NOTNULL |
| + | *NOTNULL |
| + | *NOTNULL |
| + | *NOTNULL |
| + | *NULL |
| + | *NOTNULL |
| + | | |
| + | *Company Key |
| + | *Warehouse Key |
| + | *Item Key |
| + | *Pack Key |
| + | *Catch Weight Minimum Tolerance |
| + | *Catch Weight Maximum Tolerance |
| + | *Catch Weight Tare Weight Value |
| + | *Catch Weight SCC Value |
| + | *UPC Key |
| + | *UCC 128 Item |
| + | *Created on Date/Time Value |
| + | *Changed on Date/Time Value |
| + | *User Key |
| + | *User Key |
| + | *Lock Count Value |
| + | *Catch weight Net Weight Value |
| + | *Catch Weight Back Date |
| + | *Catch Weight Sell Value |
| + | |} |
| | | |
| {| border="1" cellpadding="2" valign="top" halign="left" | | {| border="1" cellpadding="2" valign="top" halign="left" |
Line 2,227: |
Line 2,286: |
| !Key Description | | !Key Description |
| |- | | |- |
| + | |
| ===wms_custpull_tbl=== | | ===wms_custpull_tbl=== |
| *gl_cmp_key varchar(3) NOTNULL Company Key | | *gl_cmp_key varchar(3) NOTNULL Company Key |
Revision as of 18:59, 18 September 2006
Whistle Database Tables
The Whistle application uses a number of database tables to store and organize warehouse information. Whistle updates most tables automatically. Other tables, such as the ‘user’ tables, are updated manually through the use of data maintenance frames (see chapter on Data Maintenance Frames). This is a comprehensive listing of all Whistle – specific database tables and their corresponding parameters.
The following is a list of all Whistle database tables. Each table is described in detail in later in this appendix.
Whistle Tables and Definitions
Column
|
Data Type
|
Nullable
|
Key Description
|
wmCountDetail
- company
- warehouse
- countKey
- containerHeader
- containerDetail
- bin
- item
- pack
- lot
- originalQty
- countedQty
- countedCost
- variance
- varianceCost
- countedBy
- countedOn
- updateCounter
|
- varchar(2)
- varchar(4)
- int
- varchar(10)
- int
- varchar(10)
- varchar(10)
- varchar(10)
- varchar(10)
- decimal(18,4)
- decimal(18,4)
- decimal(18,4)
- decimal(18,4)
- decimal(18,4)
- varchar(10)
- datetime
- int
|
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
|
- Company Key
- Warehouse Key
- Count Key
- Container Header Key
- Container Detail Key
- Bin Key
- Item Key
- Pack Key
- Lot Key
- Original Quantity Value
- Counted Quantity Value
- Counted Cost Value
- Variance Value
- Variance Cost Value
- User Key
- Counted On Date/Time Value
- Update Counter Key
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmCountMaster
- company
- warehouse
- countKey
- countStatus
- createdBy
- createdOn
- completedBy
- completedOn
- countedCost
- netVarianceCost
- numCounts
- numErrors
|
- varchar(2)
- varchar(4)
- int
- varchar(10)
- varchar(10)
- datetime
- varchar(10)
- datetime
- decimal(18,4)
- decimal(18,4)
- int
- int
|
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NULL
- NULL
- NULL
- NULL
- NULL
- NULL
|
- Company Key
- Warehouse Key
- Count Key
- Count Status Key
- User Key
- Counted On Date/Time Value
- User Key
- Completed On Date/Time Value
- Counted Cost Value
- Net Variance Cost
- Number of Counts Value
- Number of Errors Value
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmCountZones
- company
- warehouse
- countZone
- bin
|
- varchar(2)
- varchar(4)
- varchar(10)
- varchar(10)
|
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
|
- Company Key
- Warehouse Key
- Count Zone Key
- Bin Key
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmCountedBins
- company
- warehouse
- countKey
- bin
- errors
- countedBy
- countedOn
- updateCounter
|
- varchar(2)
- varchar(4)
- int
- varchar(10)
- int
- varchar(10)
- datetime
- int
|
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
|
- Company Key
- Warehouse Key
- Count Key
- Bin Key
- Errors Key
- User Key
- Counted On Date/Time Value
- Update Counter Key
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmCustomer
- company
- warehouse
- customerKey
- showCustPartNumber
|
- varchar(2)
- varchar(4)
- varchar(10)
- int
|
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
|
- Company Key
- Warehouse Key
- Customer Key
- Show Customer Part Number Key
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmDemand
- company
- warehouse
- orderKey
- orderType
- demandLine
- status
- item
- pack
- lot
- demandQty
- pickedQty
- uom
- createTime
- activeUser
- lockCounter
- minShelfLife
|
- varchar(2)
- varchar(4)
- varchar(10)
- int
- int
- varchar(50)
- varchar(20)
- varchar(8)
- varchar(20)
- decimal(18,4)
- decimal(18,4)
- varchar(2)
- datetime
- varchar(10)
- int
- int
|
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NULL
- NULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
|
- Company Key
- Warehouse Key
- Order Key
- Order Type Key
- Demand Line Key
- Status Key
- Item Key
- Pack Key
- Lot Key
- Demand Quantity Value
- Picked Quantity Value
- UOM Value
- Created Date/Time Value
- User Key
- Lock Counter Key
- Minimum Shelf Life Key
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmItemInstruct
- company
- warehouse
- item
- pack
- context
- instruction
|
- varchar(2)
- varchar(4)
- varchar(20)
- varchar(8)
- int
- varchar(255)
|
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
|
- Company Key
- Warehouse Key
- Item Key
- Pack Key
- Context Key
- Instruction Text Value
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmLabelCrossRef
- company
- branch
- deliverFrom
- labelKey
|
- varchar(2)
- varchar(4)
- varchar(10)
- int
|
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
|
- Company key
- Branch Key
- Deliver From Key
- Label Key
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmLabelElements
- labelKey
- elementKey
- dataType
- elementDescription
- position
- width
- uom
- decimalPosition
- mapsTo
- required
- lastModifiedBy
- lastModifiedOn
|
- int
- int
- int
- varchar(10)
- int
- int
- varchar(2)
- int
- varchar(20)
- int
- varchar(10)
- datetime
|
- NOTNULL
- NOTNULL
- NOTNULL
- NULL
- NOTNULL
- NOTNULL
- NULL
- NOTNULL
- NULL
- NOTNULL
- NOTNULL
- NULL
|
- Label Key
- Element Key
- Data Type Value
- Element Description Value
- Position Value
- Width Value
- UOM Value
- Decimal Position Key
- Maps To Key
- Required Key
- User Key
- Last Modified Date/Time Value
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmPickAllocation
- pickAllocKey
- companyKey
- warehouseKey
- orderType
- orderKey
- orderLineKey
- containerKey
- itemKey
- packKey
- allocLotKey
- allocQuantity
- allocUOM
- status
- lastChangedBy
- lastChangeDate
- createdBy
- creationDate
- lockCounter
|
- int
- varchar(10)
- varchar(10)
- smallint
- varchar(30)
- int
- varchar(10)
- varchar(20)
- varchar(10)
- varchar(30)
- float
- varchar(2)
- smallint
- varchar(30)
- datetime
- varchar(30)
- datetime
- int
|
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
|
- Pick Allocation Key
- Company Key
- Warehouse Key
- Order Type Key
- Order Key
- Order Line Key
- Container Key
- Item Key
- Pack Key
- Allocation Lot Key
- Allocation Quantity Value
- Allocation UOM Value
- Status Key
- User Key
- Changed on Date/Time Value
- User Key
- Created On Date Value
- Lock Counter Value
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmPrintJobs
- company
- warehouse
- track
- numLabels
- printDoc
- printer
- prePrint
- printSequence1
- printSequence2
- printSequence3
|
- varchar(2)
- varchar(4)
- varchar(10)
- int
- varchar(255)
- varchar(255)
- int
- varchar(10)
- varchar(10)
- varchar(10)
|
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NULL
- NULL
- NOTNULL
- NULL
- NULL
- NULL
|
- Company Key
- Warehouse Key
- Tracking Key
- Number of labels Value
- Print Document Value
- Printer Value
- Pre print Value
- Print Sequence 1 Value
- Print Sequence 2 Value
- Print Sequence 3 Value
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmRuleContext
- ruleContextKey
- companyKey
- warehouseKey
- contextName
- contextType
- binKey
- lastChangedBy
- lastChangeDate
- createdBy
- creationDate
- lockCounter
|
- int
- varchar(10)
- varchar(10)
- varchar(60)
- smallint
- varchar(10)
- varchar(30)
- datetime
- varchar(30)
- datetime
- int
|
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
|
- Rule Context key
- Company Key
- Warehouse Key
- Context Name Value
- Context Type Value
- Bin Key
- User Key
- Changed on Date/Time Value
- User Key
- Created on Date/Time Value
- Lock Counter
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmRuleContextLine
- ruleContextLineKey
- ruleContextKey
- rulePriority
- ruleMasterKey
- sortOrder
- lastChangedBy
- lastChangeDate
- createdBy
- creationDate
- lockCounter
|
- int
- int
- smallint
- int
- smallint
- varchar(30)
- datetime
- varchar(30)
- datetime
- int
|
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
|
- Rule Context Line Key
- Rule Context Key
- Rule Priority Value
- Rule Master Key
- Sort Order Value
- User Key
- Changed on Date
- User Key
- Created on Date
- Lock Counter Value
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmRuleMaster
- ruleMasterKey
- ruleName
- ruleTable
- ruleColumn
- ruleIdentifier
- lastChangedBy
- lastChangeDate
- createdBy
- creationDate
- lockCounter
|
- int
- varchar(60)
- varchar(30)
- varchar(30)
- varchar(30)
- varchar(30)
- datetime
- varchar(30)
- datetime
- int
|
- NOTNULL
- NOTNULL
- NULL
- NULL
- NULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
|
- Rule Master Key
- Rule Name Value
- Rule Table Value
- Rule Column Value
- Rule ID Value
- User Key
- Changed on Date Value
- User Key
- Created on Date Value
- Lock Counter Value
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmScaleDefinition
- company
- warehouse
- scaleKey
- scaleDescription
- scaleAddress
|
- varchar(2)
- varchar(4)
- varchar(60)
- varchar(128)
- varchar(128)
|
- NOTNULL
- NOTNULL
- NOTNULL
- NULL
- NOTNULL
|
- Company Key
- Warehouse Key
- Scale Key
- Scale Description Value
- Scale Address Value
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmTaskMaster
- taskMasterKey
- taskType
- taskName
- refLabel1
- refLabel2
- refLabel3
- lastChangedBy
- lastChangeDate
- createdBy
- creationDate
- lockCounter
|
- int
- varchar(20)
- varchar(30)
- varchar(30)
- varchar(30)
- varchar(30)
- varchar(30)
- datetime
- varchar(30)
- datetime
- int
|
- NOTNULL
- NOTNULL
- NOTNULL
- NULL
- NULL
- NULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
|
- Task Master Key
- Task Type Value
- Task Name Value
- Reference Label 1
- Reference Label 2
- Reference Label 3
- User Key
- Changed On Date/Time Value
- User Key
- Created On Date/Time Value
- Lock Counter Value
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmTestHistory
- testKey
- effectiveDate
- sequence
- item
- pack
- lot
- sampleID
- status
- result
- measured
- measuredUOM
- comments
- transactionTime
- tranactionUser
|
- varchar(10)
- datetime
- int
- varchar(20)
- varchar(10)
- varchar(30)
- varchar(20)
- varchar(20)
- varchar(60)
- decimal(18,4)
- varchar(2)
- varchar(255)
- datetime
- varchar(10)
|
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NULL
- NULL
- NULL
- NOTNULL
- NULL
|
- Test Key
- Effective Date/Time Value
- Sequence Value
- Item Key
- Pack Key
- Lot Key
- Sample ID Value
- Status Value
- Result Value
- Measured value
- Unit Of Measure Value
- Comment Value
- Transaction Date/Time Value
- User Key
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmUomConv
- gl_cmp_key
- in_whs_key
- in_item_key
- im_pack_key
- uom_from
- uom_to
- factor
|
- varchar(2)
- varchar(4)
- varchar(20)
- varchar(6)
- varchar(10)
- varchar(10)
- float
|
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
|
- Company Key
- Warehouse Key
- Item Key
- Pack Key
- UOM From Key
- UOM To Key
- Factor Key
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmUserPrefs
- gl_cmp_key
- in_whs_key
- user_key
- pref_name
- pref_value
- created_by
- created_on
- changed_by
- changed_on
- lock_counter
|
- varchar(2)
- varchar(4)
- varchar(8)
- varchar(64)
- varchar(256)
- varchar(8)
- datetime
- varchar(8)
- datetime
- int
|
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
|
- Company Key
- Warehouse Key
- User Key
- Preference Name Value
- Preference Value
- User Key
- Created on Date/Time Value
- User Key
- Changed On Date/Time Value
- Lock Counter Value
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmUserTask
- userTaskKey
- userKey
- companyKey
- warehouseKey
- taskMasterKey
- taskNote
- expectedStart
- expectedFinish
- actualStart
- actualFinish
- priority
- status
- refValue1
- refValue2
- refValue3
- assignedBy
- lastChangedBy
- lastChangeDate
- createdBy
- creationDate
- lockCounter
|
- int
- varchar(8)
- varchar(10)
- varchar(10)
- int
- varchar(255)
- datetime
- datetime
- datetime
- datetime
- smallint
- smallint
- varchar(30)
- varchar(30)
- varchar(30)
- varchar(10)
- varchar(30)
- datetime
- varchar(30)
- datetime
- int
|
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NULL
- NULL
- NULL
- NULL
- NOTNULL
- NOTNULL
- NULL
- NULL
- NULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
|
- User Task Key
- User Key
- Company Key
- Warehouse Key
- Task Master Key
- Task Note Value
- Expected Start Date/Time Value
- Expected End Date/Time Value
- Actual Start Date/Time Value
- Actual End Date/Time Value
- Priority Value
- Status Value
- Reference Value 1
- Reference Value 2
- Reference Value 3
- User Key
- User Key
- Changed on Date/Time Value
- User Key
- Created on Date/Time Value
- Lock Counter Value
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wmWave
- company
- warehouse
- waveKey
- createdOn
- createdBy
|
- varchar(2)
- varchar(4)
- varchar(10)
- datetime
- varchar(10)
|
- NOTNULL
- NOTNULL
- NOTNULL
- NULL
- NOTNULL
|
- Company Key
- Warehouse Key
- Wave Key
- Created on Date/Time Value
- User Key
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_autohd_tbl
- gl_cmp_key
- in_whs_key
- in_item_key
- im_pack_key
- wms_autohd_hrs
- context
|
- varchar(2)
- varchar(4)
- varchar(30)
- varchar(6)
- int
- varchar(10)
|
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NULL
- NOTNULL
|
- Company Key
- Warehouse Key
- Item Key
- Pack Key
- Autohold Length Hours Value
- Context Value
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_bin_tbl
- gl_cmp_key
- in_whs_key
- in_locn_key
- wms_bin_key
- wms_bin_depth
- wms_bin_height
- wms_bin_width
- wms_bin_type
- wms_bin_row
- wms_bin_col
- wms_bin_cychd
- wms_bin_hold
- wms_bin_tbl_key
|
- varchar(3)
- varchar(4)
- varchar(10)
- varchar(15)
- float
- float
- float
- varchar(10)
- int
- int
- int
- int
- int (IDENTITY)
|
- NOTNULL
- NOTNULL
- NULL
- NOTNULL
- NULL
- NULL
- NULL
- NULL
- NULL
- NULL
- NOTNULL
- NOTNULL
- NOTNULL
|
- Company Key
- Warehouse Key
- Location Key
- Bin Key
- Bin Depth Value
- Bin Height Value
- Bin Width Value
- Bin Type Value
- Bin row # (x) Value
- Bin column # (y) Value
- Bin Cycle Lock Value
- Bin On Hold Value
- Bin Table Key
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_bincnt_tbl
- gl_cmp_key
- in_whs_key
- in_cycnt_key
- wms_bin_key
- wms_bincnt_stat
- sa_user_key
- wms_bincnt_crtdt
- in_locn_key
- in_item_key
- im_pack_key
|
- varchar(3)
- varchar(4)
- int
- varchar(15)
- int
- varchar(8)
- datetime
- varchar(10)
- varchar(10)
- varchar(10)
|
- NULL
- NULL
- NULL
- NULL
- NULL
- NULL
- NULL
- NULL
- NULL
- NULL
|
- Company Key
- Warehouse Key
- Cycle count key
- Bin Key
- Bin count status Value
- User Key
- Counted on Date/Time Value
- Location Key
- Item Key
- Pack Key
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_case_tbl
- gl_cmp_key
- in_whs_key
- wms_case_num
- created_on
- changed_on
- created_by
- changed_by
- lock_count
|
- varchar(2)
- varchar(4)
- int
- datetime
- datetime
- varchar(8)
- varchar(8)
- int
|
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
|
- Company Key
- Warehouse Key
- Case Number Value
- Created on Date
- Changed on Date
- User Key
- User Key
- Lock Counter Value
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_contadj_tbl
- gl_cmp_key
- in_whs_key
- wms_conthdr_key
- in_item_key
- im_pack_key
- wms_contadj_qty
- en_resn_key
- sa_user_key
- wms_contadj_date
- wms_contadj_cmt
- wms_contdtl_key
- wms_contcase_key
- wms_contadj_cntrl
|
- varchar(3)
- varchar(4)
- varchar(10)
- varchar(30)
- varchar(6)
- float
- varchar(10)
- varchar(10)
- datetime
- varchar(255)
- int
- varchar(60)
- varchar(60)
|
- NULL
- NULL
- NULL
- NULL
- NULL
- NULL
- NULL
- NULL
- NULL
- NULL
- NOTNULL
- NULL
- NULL
|
- Company Key
- Warehouse Key
- Tracking Key
- Item Key
- Pack Key
- Adjusted Quantity Value
- Reason For Adjustment Value
- User Key
- Transaction Date/Time Value
- Container Adj Comment Value
- Container Detail Key
- Container Case Key
- Container Adj Control Num Value
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_contcase_tbl
- gl_cmp_key
- in_whs_key
- wms_conthdr_key
- wms_contdtl_key
- wms_contcase_key
- wms_contcase_ctwgt
- in_sublot_key
- wms_contcase_prddt
- created_on
- changed_on
- created_by
- changed_by
- lock_count
- wms_contcase_stat
- wms_contcase_acwgt
|
- varchar(2)
- varchar(4)
- varchar(10)
- int
- varchar(60)
- float
- int
- datetime
- datetime
- datetime
- varchar(8)
- varchar(8)
- int
- int
- float
|
- NOTNULL
- NOTNULL
- NULL
- NULL
- NOTNULL
- NULL
- NULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
|
- Company Key
- Warehouse Key
- Tracking Key
- Tracking Detail Key
- Tracking Case Key
- Tracking Catch Weight Value
- Adage SubLot Key
- Case Production Date Value
- Created On Date Value
- Changed On Date Value
- User Key
- User Key
- Lock Count Value
- Container Status Value
- Container Actual Weight Value
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_context_tbl
- gl_cmp_key
- in_whs_key
- wms_conthdr_key
- wms_context_variety
- wms_context_linemtch
- wms_context_idfield
- created_on
- changed_on
- created_by
- changed_by
- lock_count
|
- varchar(2)
- varchar(4)
- varchar(10)
- varchar(10)
- varchar(10)
- varchar(4)
- datetime
- datetime
- varchar(8)
- varchar(8)
- int
|
- NOTNULL
- NOTNULL
- NOTNULL
- NULL
- NULL
- NULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
|
- Company Key
- Warehouse Key
- Tracking Key
- Context Variety Value
- Context Line Match Value
- Context ID Field Value
- Created on Date/Time Value
- Changed on Date/Time Value
- User Key
- User Key
- Lock Count Value
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_conthdr_tbl
- gl_cmp_key
- in_whs_key
- wms_conthdr_key
- wms_contst_key
- in_locn_key
- wms_bin_key
- wms_conthdr_lstmv
- wms_contty_key
- wms_conthdr_lstdt
- sa_user_key
- wms_contst_reldt
- wms_group_key
- wms_conthdr_vol
- wms_conthdr_unique
- lockCounter
|
- varchar(3)
- varchar(4)
- varchar(10)
- varchar(10)
- varchar(10)
- varchar(15)
- datetime
- varchar(10)
- datetime
- varchar(8)
- datetime
- int
- float
- int (IDENTITY)
- int
|
- NOTNULL
- NOTNULL
- NOTNULL
- NULL
- NULL
- NULL
- NULL
- NULL
- NULL
- NULL
- NULL
- NULL
- NULL
- NOTNULL
- NULL
|
- Company Key
- Warehouse Key
- Tracking Key
- Container Status Value
- Location Key
- Bin Key
- Last Moved Date/Time Value
- Container Type
- Container Last Changed Date Value
- User Key
- Release Date/Time
- Group Key
- Container Volume Value
- Container Header Unique Key
- Lock Counter Value
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_contst_tbl
- gl_cmp_key
- 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
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_contty_tbl
- 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
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_contxf_tbl
- 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
- wms_contxf_key
- toleranceOver
- wms_contxf_pseq
|
- varchar(3)
- varchar(4)
- varchar(10)
- varchar(30)
- varchar(6)
- varchar(60)
- varchar(20)
- float
- float
- int (IDENTITY)
- float
- int
|
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NOTNULL
- NULL
- NULL
- NULL
- NULL
- NOTNULL
- 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
- Container Cross Reference Key
- Tolerance Over Value
- Container Cross Reference Seq Key
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_counter_tbl
- wms_counter_type
- wms_counter_idx
|
|
|
- Counter Name Value
- Current Counter Number Value
|
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
- 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
|
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_custpull_tbl
- gl_cmp_key varchar(3) NOTNULL Company Key
- in_whs_key varchar(4) NOTNULL Warehouse Key
- ap_cust_key varchar(10) NOTNULL Customer Key
- wms_custpull_puldt int NULL Customer Pull Date Value
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_cycnt_tbl
- gl_cmp_key varchar(3) NULL Company Key
- in_whs_key varchar(4) NULL Warehouse Key
- wms_conthdr_key varchar(10) NULL Tracking Key
- in_cycnt_key varchar(10) NULL Cycle Count Key
- wms_cycnt_entlv varchar(10) NULL Cycle Count Entity Level Key
- wms_cycnt_ent varchar(20) NULL Cycle Count Entity Key
- wms_cycnt_stat varchar(10) NULL Cycle Count Status Value
- wms_cycnt_ent2 varchar(20) NULL Cycle Count Entity 2 Key
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_erpint_tbl
- gl_cmp_key varchar(3) NOTNULL Company Key
- in_whs_key varchar(4) NOTNULL Warehouse Key
- wms_erpint_type varchar(30) NOTNULL ERP Interface Type Value
- wms_erpint_start datetime NOTNULL ERP Interface Start Value
- wms_erpint_pid int NOTNULL ERP Interface Part ID Value
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_except_tbl
- gl_cmp_key varchar(3) NULL Company Key
- in_whs_key varchar(4) NULL Warehouse Key
- wms_tran_key varchar(10) NULL Transaction Key
- wms_conthdr_key varchar(10) NULL Tracking Key
- wms_except_sbin varchar(15) NULL Bin Key
- wms_except_ubin varchar(15) NULL Bin Key
- wms_except_sqty float NULL System Expected Quantity Value
- wms_except_uqty float NULL User Entered Quantity Value
- wms_except_note varchar(255) NULL Exception Explanation Value
- sa_user_key varchar(8) NULL User Key
- wms_except_crtdt datetime NULL Exception Creation Date/Time
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_group_tbl
- gl_cmp_key varchar(3) NOTNULL Company Key
- in_whs_key varchar(4) NOTNULL Warehouse Key
- wms_group_key int NOTNULL Group Key
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_kit_tbl
- gl_cmp_key varchar(2) NOTNULL Company Key
- in_whs_key varchar(4) NOTNULL Warehouse Key
- wms_kititem_key varchar(20) NOTNULL Kit Item Key
- wms_kitpack_key varchar(6) NOTNULL Kit Pack Key
- in_item_key varchar(20) NOTNULL Item Key
- im_pack_key varchar(6) NOTNULL Pack Key
- wms_kit_qty float NOTNULL Kit Quantity Value
- wms_kit_uom varchar(2) NOTNULL Kit UOM Value
- created_by varchar(8) NOTNULL Created by Date/Time Value
- created_on datetime NOTNULL Created on Date/Time Value
- changed_by varchar(8) NOTNULL User Key
- changed_on datetime NOTNULL Changed on Date/Time Value
- lock_count int NOTNULL Lock Counter Key
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_lhold_tbl
- gl_cmp_key varchar(3) NULL Company Key
- in_whs_key varchar(4) NULL Warehouse Key
- sa_user_key varchar(8) NULL User Key
- wms_lhold_lot varchar(25) NULL Lot Hold Lot Value
- wms_lhold_bgdt datetime NULL Beginning Hold Date/Time Value
- wms_lhold_eddt datetime NULL Ending Hold Date/Time Value
- wms_lhold_cmt varchar(255) NULL Comment Value
- wms_lhold_trdt datetime NULL Date Lot Placed On Hold Value
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_load_tbl
- gl_cmp_key varchar(2) NOTNULL Company Key
- so_brnch_key varchar(4) NOTNULL Branch Key
- so_hdr_key varchar(10) NOTNULL Tracking Key
- wms_load_bol varchar(25) NOTNULL Load BOL Value
- wms_load_trailer varchar(25) NULL Load Trailer Value
- wms_load_seal varchar(45) NULL Load Seal Value
- wms_load_chep int NULL Load Chep Value
- wms_load_shpdt datetime NULL Load Ship Date/Time Value
- in_towhs_key varchar(4) NULL To WHS Key
- carrier varchar(10) NULL Carrier Value
- prePaidFreight float NULL Pre Paid Freight Value
- status varchar(10) NULL Status Value
- loadKey varchar(10) NULL Load Key
Column
|
Data Type
|
Nullable
|
Key Description
|
wms_loadnm_tbl
- gl_cmp_key varchar(2) NOTNULL Company Key
- so_brnch_key varchar(4) NOTNULL Branch Key
- so_hdr_key varchar(10) NOTNULL Tracking Key
- wms_loadnm_key int NULL Load Name Key