Difference between revisions of "GT:Appendix C Whistle Database Tables"
From coolearthwiki
(Add description to tables, remove no longer used schema.) |
|||
| (17 intermediate revisions by 2 users not shown) | |||
| 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 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 | + | 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" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
| Line 14: | Line 14: | ||
| | | | ||
*wmASNHistory | *wmASNHistory | ||
| + | *wmAutoReceiveWhs | ||
*wmCountDetail | *wmCountDetail | ||
*wmCountMaster | *wmCountMaster | ||
| Line 29: | Line 30: | ||
*wmReceiptReturn | *wmReceiptReturn | ||
*wmReclassHist | *wmReclassHist | ||
| − | |||
| − | |||
| − | |||
*wmScaleDefinition | *wmScaleDefinition | ||
*wmStockMoveInt | *wmStockMoveInt | ||
| − | |||
*wmTestHistory | *wmTestHistory | ||
*wmUomConv | *wmUomConv | ||
*wmUserPrefs | *wmUserPrefs | ||
| − | |||
*wmWave | *wmWave | ||
*wms_autohd_tbl | *wms_autohd_tbl | ||
*wms_bin_tbl | *wms_bin_tbl | ||
| − | |||
*wms_bindtlst_tbl | *wms_bindtlst_tbl | ||
*wms_case_tbl | *wms_case_tbl | ||
| + | *wms_comments_tbl | ||
*wms_contadj_tbl | *wms_contadj_tbl | ||
*wms_contcase_tbl | *wms_contcase_tbl | ||
| Line 144: | Line 140: | ||
|- | |- | ||
===wmASNHistory=== | ===wmASNHistory=== | ||
| + | History of EDI ASN transmitted from Whistle. | ||
| | | | ||
*company | *company | ||
| Line 212: | Line 209: | ||
*Created On Date/Time Value | *Created On Date/Time Value | ||
*Created By Value | *Created By Value | ||
| + | |||
| + | |} | ||
| + | |||
| + | {| border="1" cellpadding="2" valign="top" halign="left" | ||
| + | !Column | ||
| + | !Data Type | ||
| + | !Nullable | ||
| + | !Key Description | ||
| + | |- | ||
| + | |||
| + | ===wmAutoReceiveWhs=== | ||
| + | List of warehouses that can auto receive warehouse transfer push transactions. | ||
| + | | | ||
| + | *company | ||
| + | *warehouse | ||
| + | | | ||
| + | *varchar(2) | ||
| + | *varchar(4) | ||
| + | | | ||
| + | *NULL | ||
| + | *NULL | ||
| + | | | ||
| + | *Company Key | ||
| + | *Warehouse Key | ||
|} | |} | ||
| Line 223: | Line 244: | ||
===wmCountDetail=== | ===wmCountDetail=== | ||
| + | Cycle count detail information. Child of wmCountMaser | ||
| | | | ||
*company | *company | ||
| Line 304: | Line 326: | ||
|- | |- | ||
===wmCountMaster=== | ===wmCountMaster=== | ||
| + | Cycle count header information. Parent of wmCountDetail | ||
| | | | ||
*company | *company | ||
| Line 365: | Line 388: | ||
|- | |- | ||
===wmCountZones=== | ===wmCountZones=== | ||
| + | Contains collection of bins in a count zone. | ||
| | | | ||
*company | *company | ||
| Line 394: | Line 418: | ||
|- | |- | ||
===wmCountedBins=== | ===wmCountedBins=== | ||
| + | Details of what bins have been counted for a particular cycle count. | ||
| | | | ||
*company | *company | ||
| Line 439: | Line 464: | ||
|- | |- | ||
===wmCustomer=== | ===wmCustomer=== | ||
| + | Configuration details for a customer. | ||
| | | | ||
*company | *company | ||
| Line 468: | Line 494: | ||
|- | |- | ||
===wmDemand=== | ===wmDemand=== | ||
| + | Demand records for staging. Contains picking progress information for production orders, sales orders and warehouse transfers. | ||
| | | | ||
*company | *company | ||
| Line 545: | Line 572: | ||
|- | |- | ||
===wmExtraInfoUserFlds=== | ===wmExtraInfoUserFlds=== | ||
| + | Collect users data for purchase order receipts and sales order shippments. | ||
| | | | ||
*company | *company | ||
| Line 711: | Line 739: | ||
===wmItemInstruct=== | ===wmItemInstruct=== | ||
| + | Picking instructions for user. | ||
| | | | ||
*company | *company | ||
| Line 748: | Line 777: | ||
|- | |- | ||
===wmLabelCrossRef=== | ===wmLabelCrossRef=== | ||
| + | Attaches Vendor deliver-Froms to a label for vendor label decoding. | ||
| | | | ||
*company | *company | ||
| Line 777: | Line 807: | ||
|- | |- | ||
===wmLabelElements=== | ===wmLabelElements=== | ||
| + | Defines elements on a vendor label. | ||
| | | | ||
*labelKey | *labelKey | ||
| Line 829: | Line 860: | ||
*User Key | *User Key | ||
*Last Modified Date/Time Value | *Last Modified Date/Time Value | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| Line 923: | Line 869: | ||
|- | |- | ||
===wmPOReturnInt=== | ===wmPOReturnInt=== | ||
| + | Transaction history of PO returns. | ||
| | | | ||
*returnLineId | *returnLineId | ||
| Line 1,009: | Line 956: | ||
===wmPrintJobs=== | ===wmPrintJobs=== | ||
| + | Holds sequence registers for preprinted labels. | ||
| | | | ||
*company | *company | ||
| Line 1,062: | Line 1,010: | ||
|- | |- | ||
===wmReceiptReturn=== | ===wmReceiptReturn=== | ||
| + | Collects details of Purchase order returns. | ||
| | | | ||
*company | *company | ||
| Line 1,131: | Line 1,080: | ||
|- | |- | ||
===wmReclassHist=== | ===wmReclassHist=== | ||
| + | Transactional history for Item Reclass transactions. | ||
| | | | ||
*company | *company | ||
| Line 1,223: | Line 1,173: | ||
*Debit ATF Control Number | *Debit ATF Control Number | ||
*Credit ATF Control Number | *Credit ATF Control Number | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| Line 1,400: | Line 1,183: | ||
===wmScaleDefinition=== | ===wmScaleDefinition=== | ||
| + | Load cell setup. | ||
| | | | ||
*company | *company | ||
| Line 1,434: | Line 1,218: | ||
===wmStockMoveInt=== | ===wmStockMoveInt=== | ||
| + | Transaction history of ERP stock move interfaces | ||
| | | | ||
*company | *company | ||
| Line 1,501: | Line 1,286: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
!Column | !Column | ||
| Line 1,567: | Line 1,294: | ||
===wmTestHistory=== | ===wmTestHistory=== | ||
| + | History of QC test data collection. | ||
| | | | ||
*testKey | *testKey | ||
| Line 1,637: | Line 1,365: | ||
===wmUomConv=== | ===wmUomConv=== | ||
| + | Warehouse level UOM conversions. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 1,679: | Line 1,408: | ||
===wmUserPrefs=== | ===wmUserPrefs=== | ||
| + | Warehouse and User level software settings. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 1,723: | Line 1,453: | ||
*Changed On Date/Time Value | *Changed On Date/Time Value | ||
*Lock Counter Value | *Lock Counter Value | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| Line 1,831: | Line 1,463: | ||
===wmWave=== | ===wmWave=== | ||
| + | Wave picking header. | ||
| | | | ||
*company | *company | ||
| Line 1,865: | Line 1,498: | ||
===wms_autohd_tbl=== | ===wms_autohd_tbl=== | ||
| + | Definition by item of timed and indefinite holds for receipts and production. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 1,903: | Line 1,537: | ||
===wms_bin_tbl=== | ===wms_bin_tbl=== | ||
| + | Definition of bin locations in a warehouse. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 1,915: | Line 1,550: | ||
*wms_bin_col | *wms_bin_col | ||
*wms_bin_cychd | *wms_bin_cychd | ||
| − | *wms_bin_hold | + | *wms_bin_hold |
| + | *can_mix_items | ||
| + | *not_on_picklist | ||
| + | *dont_trackvol | ||
| | | | ||
*varchar(3) | *varchar(3) | ||
| Line 1,928: | Line 1,566: | ||
*int | *int | ||
*int | *int | ||
| − | *int | + | *int |
| + | *int | ||
| + | *int | ||
| + | *int | ||
| | | | ||
*NOTNULL | *NOTNULL | ||
| Line 1,942: | Line 1,583: | ||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| | | | ||
*Company Key | *Company Key | ||
*Warehouse Key | *Warehouse Key | ||
| − | *Location Key | + | *ERP Location Key |
*Bin Key | *Bin Key | ||
*Bin Depth Value | *Bin Depth Value | ||
| Line 1,955: | Line 1,599: | ||
*Bin Cycle Lock Value | *Bin Cycle Lock Value | ||
*Bin On Hold Value | *Bin On Hold Value | ||
| + | *Bin will accept a mix of items | ||
| + | *Don't show bin contents in picklist | ||
| + | *Don't calculate bin volume | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
| Line 2,019: | Line 1,613: | ||
===wms_bindtlst_tbl=== | ===wms_bindtlst_tbl=== | ||
| + | Contains location of containers in the warehouse and the space remaining in bins. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 2,044: | Line 1,639: | ||
*wms_count_qty | *wms_count_qty | ||
*wms_count_var | *wms_count_var | ||
| − | *lastCount | + | *lastCount |
| + | *not_on_picklist | ||
| + | *dont_trackvol | ||
| | | | ||
*varchar(3) | *varchar(3) | ||
| Line 2,061: | Line 1,658: | ||
*varchar(25) | *varchar(25) | ||
*datetime | *datetime | ||
| − | *varchar( | + | *varchar(20) |
*varchar(10) | *varchar(10) | ||
*datetime | *datetime | ||
| Line 2,070: | Line 1,667: | ||
*float | *float | ||
*float | *float | ||
| − | *datetime | + | *datetime |
| + | *int | ||
| + | *int | ||
| | | | ||
*NOTNULL | *NOTNULL | ||
| Line 2,096: | Line 1,695: | ||
*NULL | *NULL | ||
*NULL | *NULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
| | | | ||
| Line 2,123: | Line 1,724: | ||
*Cycle Count Variance Value | *Cycle Count Variance Value | ||
*Counted On Date/Time Value | *Counted On Date/Time Value | ||
| + | *Don't show bin contents in picklist | ||
| + | *Dont' calculate bin volume | ||
|} | |} | ||
| Line 2,133: | Line 1,736: | ||
===wms_case_tbl=== | ===wms_case_tbl=== | ||
| + | Case number register by warehouse. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 2,169: | Line 1,773: | ||
*User Key | *User Key | ||
*Lock Counter Value | *Lock Counter Value | ||
| + | |} | ||
| + | |||
| + | {| border="1" cellpadding="2" valign="top" halign="left" | ||
| + | !Column | ||
| + | !Data Type | ||
| + | !Nullable | ||
| + | !Key Description | ||
| + | |- | ||
| + | |||
| + | ===wms_comments_tbl=== | ||
| + | List of valid comments by warehouse. | ||
| + | | | ||
| + | *company | ||
| + | *warehouse | ||
| + | *comments | ||
| + | | | ||
| + | *varchar(2) | ||
| + | *varchar(4) | ||
| + | *varchar(60) | ||
| + | | | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | | | ||
| + | *Company Key | ||
| + | *Warehouse Key | ||
| + | *Comment Text | ||
| + | |||
|} | |} | ||
| Line 2,179: | Line 1,811: | ||
===wms_contadj_tbl=== | ===wms_contadj_tbl=== | ||
| + | Transaction history of misc adjustments made to inventory. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 2,245: | Line 1,878: | ||
===wms_contcase_tbl=== | ===wms_contcase_tbl=== | ||
| + | Case/sublot level inventory master. Child of wms_contdtl_tbl. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 2,260: | Line 1,894: | ||
*lock_count | *lock_count | ||
*wms_contcase_stat | *wms_contcase_stat | ||
| − | *wms_contcase_acwgt | + | *wms_contcase_acwgt |
| + | *lot | ||
| + | *allocation | ||
| + | *pieces | ||
| + | *lineKey | ||
| | | | ||
*varchar(2) | *varchar(2) | ||
| Line 2,276: | Line 1,914: | ||
*int | *int | ||
*int | *int | ||
| − | *float | + | *float |
| + | *varchar(25) | ||
| + | *varchar(25) | ||
| + | *int | ||
| + | *int | ||
| | | | ||
*NOTNULL | *NOTNULL | ||
| Line 2,293: | Line 1,935: | ||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| | | | ||
*Company Key | *Company Key | ||
| Line 2,309: | Line 1,955: | ||
*Container Status Value | *Container Status Value | ||
*Container Actual Weight Value | *Container Actual Weight Value | ||
| + | *Lot Key | ||
| + | *Case Allocated Value | ||
| + | *Per box Piece Count | ||
| + | *Line Number | ||
|} | |} | ||
| Line 2,319: | Line 1,969: | ||
===wms_contdtl_tbl=== | ===wms_contdtl_tbl=== | ||
| + | Item/Pack/Lot level inventory master. Child of wms_conthdr_tbl, parent of wms_contcase_tbl table. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 2,367: | Line 2,018: | ||
*varchar(6) | *varchar(6) | ||
*varchar(25) | *varchar(25) | ||
| − | *varchar( | + | *varchar(20) |
*float | *float | ||
*int | *int | ||
| Line 2,523: | Line 2,174: | ||
===wms_conthdr_tbl=== | ===wms_conthdr_tbl=== | ||
| + | Inventory master for container (pallet) level inventory. Parent of wms_contdtl_tbl. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 2,593: | Line 2,245: | ||
===wms_contst_tbl=== | ===wms_contst_tbl=== | ||
| + | Valid inventory statuses | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 2,635: | Line 2,288: | ||
===wms_contty_tbl=== | ===wms_contty_tbl=== | ||
| + | Definition of container types. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 2,689: | Line 2,343: | ||
===wms_contxf_tbl=== | ===wms_contxf_tbl=== | ||
| + | Maps Item/Packs to a container type. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 2,747: | Line 2,402: | ||
===wms_counter_tbl=== | ===wms_counter_tbl=== | ||
| + | Generic counter table. | ||
| | | | ||
*wms_counter_type | *wms_counter_type | ||
| Line 2,769: | Line 2,425: | ||
===wms_ctwght_tbl=== | ===wms_ctwght_tbl=== | ||
| + | Defines the setup for catchweight or serial tracked inventory. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 2,855: | Line 2,512: | ||
===wms_custpull_tbl=== | ===wms_custpull_tbl=== | ||
| + | Days of shelf life required for a customer when shipping. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 2,875: | Line 2,533: | ||
*Customer Key | *Customer Key | ||
*Customer Pull Date Value | *Customer Pull Date Value | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| Line 2,965: | Line 2,577: | ||
===wms_except_tbl=== | ===wms_except_tbl=== | ||
| + | Logs users exceptions, like not following pick or putaway recommendations. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,023: | Line 2,636: | ||
===wms_group_tbl=== | ===wms_group_tbl=== | ||
| + | Defines groupings of containers. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,049: | Line 2,663: | ||
===wms_kit_tbl=== | ===wms_kit_tbl=== | ||
| + | Formulations for kit building. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,115: | Line 2,730: | ||
===wms_lhold_tbl=== | ===wms_lhold_tbl=== | ||
| + | Transactional history for lot holds. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,161: | Line 2,777: | ||
===wms_load_tbl=== | ===wms_load_tbl=== | ||
| + | Contains extended information about a shipment load. Also used for BOL generation. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,174: | Line 2,791: | ||
*prePaidFreight | *prePaidFreight | ||
*status | *status | ||
| − | *loadKey | + | *loadKey |
| + | *temp_recorder | ||
| + | *trl_temp_start | ||
| + | *set_trl_at | ||
| + | *set_trl_for_hrs | ||
| + | *trl_temp_for_trip | ||
| + | *pallets_in | ||
| + | *po_num | ||
| | | | ||
*varchar(2) | *varchar(2) | ||
| Line 3,189: | Line 2,813: | ||
*varchar(10) | *varchar(10) | ||
*varchar(10) | *varchar(10) | ||
| + | *varchar(25) | ||
| + | *varchar(5) | ||
| + | *varchar(5) | ||
| + | *varchar(5) | ||
| + | *varchar(5) | ||
| + | *varchar(5) | ||
| + | *varchar(25) | ||
| | | | ||
*NOTNULL | *NOTNULL | ||
| Line 3,202: | Line 2,833: | ||
*NULL | *NULL | ||
*NULL | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
*NULL | *NULL | ||
| | | | ||
| Line 3,217: | Line 2,855: | ||
*Status Value | *Status Value | ||
*Load Key | *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,227: | Line 2,872: | ||
===wms_loadnm_tbl=== | ===wms_loadnm_tbl=== | ||
| + | Register for load numbers. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,257: | Line 2,903: | ||
===wms_lothist_tbl=== | ===wms_lothist_tbl=== | ||
| + | Transaction history for system. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,319: | Line 2,966: | ||
===wms_outint_tbl=== | ===wms_outint_tbl=== | ||
| + | Transaction history for shipments. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,413: | Line 3,061: | ||
===wms_piint_tbl=== | ===wms_piint_tbl=== | ||
| + | Transaction history for production issues. | ||
| | | | ||
*wms_piint_error | *wms_piint_error | ||
| Line 3,436: | Line 3,085: | ||
*wms_contdtl_key | *wms_contdtl_key | ||
*pm_matl_key | *pm_matl_key | ||
| − | *originTrack | + | *originTrack |
| + | *wms_line_key | ||
| | | | ||
*varchar(255) | *varchar(255) | ||
| Line 3,460: | Line 3,110: | ||
*int | *int | ||
*int | *int | ||
| − | *varchar(10) | + | *varchar(10) |
| + | *varchar(3) | ||
| | | | ||
*NULL | *NULL | ||
| Line 3,484: | Line 3,135: | ||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
| − | *NULL | + | *NULL |
| + | *NOTNULL | ||
| | | | ||
*Message Value | *Message Value | ||
| Line 3,508: | Line 3,160: | ||
*Container Detail Key | *Container Detail Key | ||
*PM Material Key | *PM Material Key | ||
| − | *Original Tracking Key | + | *Original Tracking Key |
| + | *Line Key | ||
|} | |} | ||
| Line 3,519: | Line 3,172: | ||
===wms_pmint_tbl=== | ===wms_pmint_tbl=== | ||
| + | Transaction history for production reports. | ||
| | | | ||
*wms_pmint_error | *wms_pmint_error | ||
| Line 3,536: | Line 3,190: | ||
*wms_contdtl_key | *wms_contdtl_key | ||
*in_lot_key | *in_lot_key | ||
| − | *wms_pmint_control | + | *wms_pmint_control |
| + | *pieces | ||
| | | | ||
*varchar(255) | *varchar(255) | ||
| Line 3,555: | Line 3,210: | ||
*varchar(25) | *varchar(25) | ||
*varchar(50) | *varchar(50) | ||
| + | *int | ||
| | | | ||
*NULL | *NULL | ||
| Line 3,572: | Line 3,228: | ||
*NOTNULL | *NOTNULL | ||
*NULL | *NULL | ||
| + | *NULL | ||
*NULL | *NULL | ||
| | | | ||
| Line 3,591: | Line 3,248: | ||
*In Lot Key | *In Lot Key | ||
*PM Control Key | *PM Control Key | ||
| + | *Per Box Piece Count | ||
|} | |} | ||
| Line 3,601: | Line 3,259: | ||
===wms_pmintdtl_tbl=== | ===wms_pmintdtl_tbl=== | ||
| + | Transaction history for production reports of catchweight / serial tracked inventory. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,659: | Line 3,318: | ||
===wms_point_tbl=== | ===wms_point_tbl=== | ||
| + | Transactional history of purchase order receipts. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,749: | Line 3,409: | ||
===wms_print_tbl=== | ===wms_print_tbl=== | ||
| + | Printer definition. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,787: | Line 3,448: | ||
===wms_pultol_tbl=== | ===wms_pultol_tbl=== | ||
| + | Number of days to consider inventory as the same age. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,821: | Line 3,483: | ||
===wms_recper_tbl=== | ===wms_recper_tbl=== | ||
| + | Date of last ERP reconciliation. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,846: | Line 3,509: | ||
|- | |- | ||
===wms_rma_tbl=== | ===wms_rma_tbl=== | ||
| + | Whistle RMA information. | ||
| | | | ||
| − | *gl_cmp_key | + | *gl_cmp_key |
| − | *so_brnch_key | + | *so_brnch_key |
| − | *so_rthdr_key | + | *so_rthdr_key |
| − | *so_hdr_key | + | *so_hdr_key |
| − | *so_resn_code | + | *so_resn_code |
| − | *sa_user_key | + | *sa_user_key |
| − | *wms_rma_crtdt | + | *wms_rma_crtdt |
| | | | ||
*varchar(2) | *varchar(2) | ||
| Line 3,873: | Line 3,537: | ||
*Company Key | *Company Key | ||
*Branch Key | *Branch Key | ||
| − | *Sales | + | *Sales Order Return Header Key |
| − | *Sales | + | *Sales Order Header Key |
*Sales Order Reason Code | *Sales Order Reason Code | ||
*User Key | *User Key | ||
| Line 3,888: | Line 3,552: | ||
===wms_screen_tbl=== | ===wms_screen_tbl=== | ||
| + | Valid screens for a warehouse. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,914: | Line 3,579: | ||
===wms_sectmpl_tbl=== | ===wms_sectmpl_tbl=== | ||
| + | Security template definition. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,948: | Line 3,614: | ||
===wms_secure_tbl=== | ===wms_secure_tbl=== | ||
| + | Users security rights. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,974: | Line 3,641: | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
| Line 4,016: | Line 3,650: | ||
===wms_track_tbl=== | ===wms_track_tbl=== | ||
| + | Register for container tracking numbers. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 4,042: | Line 3,677: | ||
===wms_user_tbl=== | ===wms_user_tbl=== | ||
| + | Extended user information, default printer and language. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 4,076: | Line 3,712: | ||
===wms_usercols_tbl=== | ===wms_usercols_tbl=== | ||
| + | Metadata for user columns in wms_contdtl_tbl table. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 4,158: | Line 3,795: | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
| Line 4,220: | Line 3,804: | ||
===wms_vndpull_tbl=== | ===wms_vndpull_tbl=== | ||
| + | Minimum number of days of shelf life to allow for receipt of an item. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 4,250: | Line 3,835: | ||
===wms_wtint_tbl=== | ===wms_wtint_tbl=== | ||
| + | Transaction history for warehouse transfer receipts. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 4,344: | Line 3,930: | ||
===wms_zone_tbl=== | ===wms_zone_tbl=== | ||
| + | Maps bins to picking and putaway zones. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 4,374: | Line 3,961: | ||
===wms_zonexf_tbl=== | ===wms_zonexf_tbl=== | ||
| + | Attaches an item to one or more preferred zones. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
Latest revision as of 13:46, 4 February 2010
Contents
- 1 Whistle Database Tables
- 1.1 Whistle Tables and Definitions
- 1.1.1 wmASNHistory
- 1.1.2 wmAutoReceiveWhs
- 1.1.3 wmCountDetail
- 1.1.4 wmCountMaster
- 1.1.5 wmCountZones
- 1.1.6 wmCountedBins
- 1.1.7 wmCustomer
- 1.1.8 wmDemand
- 1.1.9 wmExtraInfoUserFlds
- 1.1.10 wmItemInstruct
- 1.1.11 wmLabelCrossRef
- 1.1.12 wmLabelElements
- 1.1.13 wmPOReturnInt
- 1.1.14 wmPrintJobs
- 1.1.15 wmReceiptReturn
- 1.1.16 wmReclassHist
- 1.1.17 wmScaleDefinition
- 1.1.18 wmStockMoveInt
- 1.1.19 wmTestHistory
- 1.1.20 wmUomConv
- 1.1.21 wmUserPrefs
- 1.1.22 wmWave
- 1.1.23 wms_autohd_tbl
- 1.1.24 wms_bin_tbl
- 1.1.25 wms_bindtlst_tbl
- 1.1.26 wms_case_tbl
- 1.1.27 wms_comments_tbl
- 1.1.28 wms_contadj_tbl
- 1.1.29 wms_contcase_tbl
- 1.1.30 wms_contdtl_tbl
- 1.1.31 wms_context_tbl
- 1.1.32 wms_conthdr_tbl
- 1.1.33 wms_contst_tbl
- 1.1.34 wms_contty_tbl
- 1.1.35 wms_contxf_tbl
- 1.1.36 wms_counter_tbl
- 1.1.37 wms_ctwght_tbl
- 1.1.38 wms_custpull_tbl
- 1.1.39 wms_erpint_tbl
- 1.1.40 wms_except_tbl
- 1.1.41 wms_group_tbl
- 1.1.42 wms_kit_tbl
- 1.1.43 wms_lhold_tbl
- 1.1.44 wms_load_tbl
- 1.1.45 wms_loadnm_tbl
- 1.1.46 wms_lothist_tbl
- 1.1.47 wms_outint_tbl
- 1.1.48 wms_piint_tbl
- 1.1.49 wms_pmint_tbl
- 1.1.50 wms_pmintdtl_tbl
- 1.1.51 wms_point_tbl
- 1.1.52 wms_print_tbl
- 1.1.53 wms_pultol_tbl
- 1.1.54 wms_recper_tbl
- 1.1.55 wms_rma_tbl
- 1.1.56 wms_screen_tbl
- 1.1.57 wms_sectmpl_tbl
- 1.1.58 wms_secure_tbl
- 1.1.59 wms_track_tbl
- 1.1.60 wms_user_tbl
- 1.1.61 wms_usercols_tbl
- 1.1.62 wms_vndpull_tbl
- 1.1.63 wms_wtint_tbl
- 1.1.64 wms_zone_tbl
- 1.1.65 wms_zonexf_tbl
- 1.1 Whistle Tables and Definitions
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 | ||
|---|---|---|---|---|
|
|
|
Whistle Tables and Definitions
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
