Difference between revisions of "GT:Appendix C Whistle Database Tables"
From coolearthwiki
(Add description to tables, remove no longer used schema.) |
|||
| Line 30: | 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 | ||
| Line 146: | Line 140: | ||
|- | |- | ||
===wmASNHistory=== | ===wmASNHistory=== | ||
| + | History of EDI ASN transmitted from Whistle. | ||
| | | | ||
*company | *company | ||
| Line 225: | Line 220: | ||
===wmAutoReceiveWhs=== | ===wmAutoReceiveWhs=== | ||
| + | List of warehouses that can auto receive warehouse transfer push transactions. | ||
| | | | ||
*company | *company | ||
| Line 248: | Line 244: | ||
===wmCountDetail=== | ===wmCountDetail=== | ||
| + | Cycle count detail information. Child of wmCountMaser | ||
| | | | ||
*company | *company | ||
| Line 329: | Line 326: | ||
|- | |- | ||
===wmCountMaster=== | ===wmCountMaster=== | ||
| + | Cycle count header information. Parent of wmCountDetail | ||
| | | | ||
*company | *company | ||
| Line 390: | Line 388: | ||
|- | |- | ||
===wmCountZones=== | ===wmCountZones=== | ||
| + | Contains collection of bins in a count zone. | ||
| | | | ||
*company | *company | ||
| Line 419: | Line 418: | ||
|- | |- | ||
===wmCountedBins=== | ===wmCountedBins=== | ||
| + | Details of what bins have been counted for a particular cycle count. | ||
| | | | ||
*company | *company | ||
| Line 464: | Line 464: | ||
|- | |- | ||
===wmCustomer=== | ===wmCustomer=== | ||
| + | Configuration details for a customer. | ||
| | | | ||
*company | *company | ||
| Line 493: | Line 494: | ||
|- | |- | ||
===wmDemand=== | ===wmDemand=== | ||
| + | Demand records for staging. Contains picking progress information for production orders, sales orders and warehouse transfers. | ||
| | | | ||
*company | *company | ||
| Line 570: | Line 572: | ||
|- | |- | ||
===wmExtraInfoUserFlds=== | ===wmExtraInfoUserFlds=== | ||
| + | Collect users data for purchase order receipts and sales order shippments. | ||
| | | | ||
*company | *company | ||
| Line 736: | Line 739: | ||
===wmItemInstruct=== | ===wmItemInstruct=== | ||
| + | Picking instructions for user. | ||
| | | | ||
*company | *company | ||
| Line 773: | Line 777: | ||
|- | |- | ||
===wmLabelCrossRef=== | ===wmLabelCrossRef=== | ||
| + | Attaches Vendor deliver-Froms to a label for vendor label decoding. | ||
| | | | ||
*company | *company | ||
| Line 802: | Line 807: | ||
|- | |- | ||
===wmLabelElements=== | ===wmLabelElements=== | ||
| + | Defines elements on a vendor label. | ||
| | | | ||
*labelKey | *labelKey | ||
| Line 862: | Line 868: | ||
!Key Description | !Key Description | ||
|- | |- | ||
| − | === | + | ===wmPOReturnInt=== |
| + | Transaction history of PO returns. | ||
| | | | ||
| − | * | + | *returnLineId |
| − | * | + | *company |
| − | * | + | *branch |
| − | * | + | *warehouse |
| − | * | + | *po |
| − | * | + | *poDtl |
| − | * | + | *receipt |
| − | * | + | *contHdr |
| − | * | + | *contDtl |
| − | * | + | *item |
| − | * | + | *pack |
| − | * | + | *lot |
| − | * | + | *location |
| − | * | + | *returnedQty |
| − | * | + | *returnedUom |
| − | * | + | *returnedTime |
| − | * | + | *userKey |
| − | * | + | *poReturnControl |
| | | | ||
| − | *int | + | *int |
| + | *varchar(3) | ||
| + | *varchar(5) | ||
| + | *varchar(5) | ||
*varchar(10) | *varchar(10) | ||
| + | *int | ||
*varchar(10) | *varchar(10) | ||
| − | * | + | *varchar(20) |
| + | *int | ||
*varchar(30) | *varchar(30) | ||
| − | |||
*varchar(10) | *varchar(10) | ||
| − | *varchar( | + | *varchar(25) |
*varchar(10) | *varchar(10) | ||
| − | * | + | *decimal |
| − | + | *varchar(6) | |
| − | *varchar( | + | *datetime |
| − | * | + | *varchar(8) |
| − | *varchar( | + | *varchar(60) |
| − | + | | | |
| − | *varchar( | + | *NOTNULL |
| − | |||
| − | |||
| − | | | ||
| − | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
| Line 920: | Line 927: | ||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
| − | | | + | | |
| − | * | + | *Return Line Key |
| − | *Company Key | + | *Company Key |
| − | *Warehouse Key | + | *Branch Key |
| − | *Order | + | *Warehouse Key |
| − | *Order Key | + | *Purchase Order Key |
| − | * | + | *Purchase Order Detail Key |
| − | *Container Key | + | *Receipt Key |
| − | *Item Key | + | *Container Header Key |
| − | *Pack Key | + | *Container Detail Key |
| − | * | + | *Item Key |
| − | * | + | *Pack Key |
| − | * | + | *Lot Key |
| − | * | + | *Location Key |
| − | + | *Quantity Returned | |
| − | * | + | *Quantity Returned Unit of Measure |
| − | *User Key | + | *Returned Date/Time Value |
| − | + | *User Key | |
| − | * | + | *Control Number |
|} | |} | ||
| Line 947: | Line 954: | ||
!Key Description | !Key Description | ||
|- | |- | ||
| − | === | + | |
| + | ===wmPrintJobs=== | ||
| + | Holds sequence registers for preprinted labels. | ||
| | | | ||
| − | + | *company | |
| − | *company | + | *warehouse |
| − | + | *track | |
| − | *warehouse | + | *numLabels |
| − | * | + | *printDoc |
| − | + | *printer | |
| − | + | *prePrint | |
| − | + | *printSequence1 | |
| − | + | *printSequence2 | |
| − | + | *printSequence3 | |
| − | |||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| | | | ||
| − | *int | + | *varchar(2) |
| − | *varchar( | + | *varchar(4) |
| − | *varchar( | + | *varchar(10) |
| − | *varchar( | + | *int |
| + | *varchar(255) | ||
| + | *varchar(255) | ||
| + | *int | ||
| + | *varchar(10) | ||
| + | *varchar(10) | ||
*varchar(10) | *varchar(10) | ||
| − | + | | | |
| − | + | *NOTNULL | |
| − | + | *NOTNULL | |
| − | + | *NOTNULL | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | * | ||
| − | * | ||
| − | * | ||
| − | |||
| − | |||
| − | |||
*NOTNULL | *NOTNULL | ||
| + | *NULL | ||
| + | *NULL | ||
*NOTNULL | *NOTNULL | ||
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | + | | | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | | ||
| − | |||
*Company Key | *Company Key | ||
| − | + | *Warehouse 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 |
| − | * | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| Line 1,032: | Line 1,009: | ||
!Key Description | !Key Description | ||
|- | |- | ||
| − | + | ===wmReceiptReturn=== | |
| − | === | + | Collects details of Purchase order returns. |
| | | | ||
| − | *company | + | *company |
| − | *warehouse | + | *branch |
| − | * | + | *warehouse |
| − | * | + | *purchaseOrder |
| − | * | + | *receiptCntrl |
| − | * | + | *rma |
| − | * | + | *item |
| − | * | + | *pack |
| − | * | + | *qty |
| − | * | + | *track |
| + | *reason | ||
| + | *comment | ||
| + | *userKey | ||
| + | *createdate | ||
| | | | ||
| − | *varchar(2) | + | *varchar(2) |
| − | *varchar(4) | + | *varchar(4) |
| − | *varchar( | + | *varchar(4) |
| − | * | + | *varchar(10) |
| − | *varchar( | + | *varchar(20) |
| − | *varchar( | + | *varchar(20) |
| − | * | + | *varchar(20) |
| − | *varchar( | + | *varchar(6) |
| − | *varchar(10) | + | *decimal |
| + | *varchar(10) | ||
*varchar(10) | *varchar(10) | ||
| + | *varchar(255) | ||
| + | *varchar(8) | ||
| + | *datetime | ||
| | | | ||
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | * | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | | | + | *NULL |
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | | | ||
*Company Key | *Company Key | ||
| − | *Warehouse Key | + | *Branch Key |
| − | * | + | *Warehouse Key |
| − | *Number | + | *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 | ||
|} | |} | ||
| Line 1,086: | Line 1,079: | ||
!Key Description | !Key Description | ||
|- | |- | ||
| − | === | + | ===wmReclassHist=== |
| + | Transactional history for Item Reclass transactions. | ||
| | | | ||
| − | *company | + | *company |
| − | * | + | *warehouse |
| − | * | + | *container |
| − | * | + | *containerdetail |
| − | * | + | *olditem |
| − | * | + | *oldpack |
| − | * | + | *oldproduct |
| − | * | + | *oldqty |
| − | * | + | *olduom |
| − | * | + | *oldcontainertype |
| − | * | + | *oldlot |
| − | * | + | *newitem |
| − | * | + | *newpack |
| + | *newproduct | ||
| + | *newqty | ||
| + | *newuom | ||
| + | *newcontainertype | ||
| + | *newlot | ||
*createdate | *createdate | ||
| − | | | + | *username |
| − | *varchar(2) | + | *debitAtfControl |
| − | *varchar(4) | + | *creditAtfControl |
| − | *varchar( | + | | |
| − | *varchar(10) | + | *varchar(2) |
| + | *varchar(4) | ||
| + | *varchar(10) | ||
| + | *int | ||
| + | *varchar(20) | ||
| + | *varchar(10) | ||
*varchar(20) | *varchar(20) | ||
| − | *varchar(20) | + | *float |
| − | *varchar( | + | *varchar(5) |
| − | *varchar( | + | *varchar(10) |
| − | * | + | *varchar(25) |
| − | *varchar( | + | *varchar(20) |
| − | *varchar(10) | + | *varchar(10) |
| − | *varchar( | + | *varchar(20) |
| − | *varchar(8) | + | *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 | ||
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | * | + | *NOTNULL |
| − | + | *NOTNULL | |
| − | |||
| − | |||
| − | * | ||
| − | |||
| | | | ||
*Company Key | *Company Key | ||
| − | |||
*Warehouse Key | *Warehouse Key | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
*Container Header 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 | *User Key | ||
| − | + | *Debit ATF Control Number | |
| − | + | *Credit ATF Control Number | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | *Debit ATF Control Number | ||
| − | *Credit ATF Control Number | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| Line 1,425: | Line 1,183: | ||
===wmScaleDefinition=== | ===wmScaleDefinition=== | ||
| + | Load cell setup. | ||
| | | | ||
*company | *company | ||
| Line 1,459: | Line 1,218: | ||
===wmStockMoveInt=== | ===wmStockMoveInt=== | ||
| + | Transaction history of ERP stock move interfaces | ||
| | | | ||
*company | *company | ||
| Line 1,526: | Line 1,286: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
!Column | !Column | ||
| Line 1,592: | Line 1,294: | ||
===wmTestHistory=== | ===wmTestHistory=== | ||
| + | History of QC test data collection. | ||
| | | | ||
*testKey | *testKey | ||
| Line 1,662: | Line 1,365: | ||
===wmUomConv=== | ===wmUomConv=== | ||
| + | Warehouse level UOM conversions. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 1,704: | Line 1,408: | ||
===wmUserPrefs=== | ===wmUserPrefs=== | ||
| + | Warehouse and User level software settings. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 1,748: | Line 1,453: | ||
*Changed On Date/Time Value | *Changed On Date/Time Value | ||
*Lock Counter Value | *Lock Counter Value | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| Line 1,856: | Line 1,463: | ||
===wmWave=== | ===wmWave=== | ||
| + | Wave picking header. | ||
| | | | ||
*company | *company | ||
| Line 1,890: | 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,928: | Line 1,537: | ||
===wms_bin_tbl=== | ===wms_bin_tbl=== | ||
| + | Definition of bin locations in a warehouse. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 1,979: | Line 1,589: | ||
*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,994: | Line 1,604: | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
| Line 2,056: | 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,178: | Line 1,736: | ||
===wms_case_tbl=== | ===wms_case_tbl=== | ||
| + | Case number register by warehouse. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 2,224: | Line 1,783: | ||
===wms_comments_tbl=== | ===wms_comments_tbl=== | ||
| + | List of valid comments by warehouse. | ||
| | | | ||
*company | *company | ||
| Line 2,251: | 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,317: | 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,407: | 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,611: | 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,681: | Line 2,245: | ||
===wms_contst_tbl=== | ===wms_contst_tbl=== | ||
| + | Valid inventory statuses | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 2,723: | Line 2,288: | ||
===wms_contty_tbl=== | ===wms_contty_tbl=== | ||
| + | Definition of container types. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 2,777: | Line 2,343: | ||
===wms_contxf_tbl=== | ===wms_contxf_tbl=== | ||
| + | Maps Item/Packs to a container type. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 2,835: | Line 2,402: | ||
===wms_counter_tbl=== | ===wms_counter_tbl=== | ||
| + | Generic counter table. | ||
| | | | ||
*wms_counter_type | *wms_counter_type | ||
| Line 2,857: | 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,943: | 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,963: | Line 2,533: | ||
*Customer Key | *Customer Key | ||
*Customer Pull Date Value | *Customer Pull Date Value | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| Line 3,053: | 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,111: | Line 2,636: | ||
===wms_group_tbl=== | ===wms_group_tbl=== | ||
| + | Defines groupings of containers. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,137: | Line 2,663: | ||
===wms_kit_tbl=== | ===wms_kit_tbl=== | ||
| + | Formulations for kit building. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,203: | Line 2,730: | ||
===wms_lhold_tbl=== | ===wms_lhold_tbl=== | ||
| + | Transactional history for lot holds. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,249: | 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,343: | Line 2,872: | ||
===wms_loadnm_tbl=== | ===wms_loadnm_tbl=== | ||
| + | Register for load numbers. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,373: | Line 2,903: | ||
===wms_lothist_tbl=== | ===wms_lothist_tbl=== | ||
| + | Transaction history for system. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,435: | Line 2,966: | ||
===wms_outint_tbl=== | ===wms_outint_tbl=== | ||
| + | Transaction history for shipments. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,529: | Line 3,061: | ||
===wms_piint_tbl=== | ===wms_piint_tbl=== | ||
| + | Transaction history for production issues. | ||
| | | | ||
*wms_piint_error | *wms_piint_error | ||
| Line 3,639: | Line 3,172: | ||
===wms_pmint_tbl=== | ===wms_pmint_tbl=== | ||
| + | Transaction history for production reports. | ||
| | | | ||
*wms_pmint_error | *wms_pmint_error | ||
| Line 3,725: | 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,783: | Line 3,318: | ||
===wms_point_tbl=== | ===wms_point_tbl=== | ||
| + | Transactional history of purchase order receipts. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,873: | Line 3,409: | ||
===wms_print_tbl=== | ===wms_print_tbl=== | ||
| + | Printer definition. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,911: | 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,945: | Line 3,483: | ||
===wms_recper_tbl=== | ===wms_recper_tbl=== | ||
| + | Date of last ERP reconciliation. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,970: | Line 3,509: | ||
|- | |- | ||
===wms_rma_tbl=== | ===wms_rma_tbl=== | ||
| + | Whistle RMA information. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 4,012: | Line 3,552: | ||
===wms_screen_tbl=== | ===wms_screen_tbl=== | ||
| + | Valid screens for a warehouse. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 4,038: | Line 3,579: | ||
===wms_sectmpl_tbl=== | ===wms_sectmpl_tbl=== | ||
| + | Security template definition. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 4,072: | Line 3,614: | ||
===wms_secure_tbl=== | ===wms_secure_tbl=== | ||
| + | Users security rights. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 4,098: | Line 3,641: | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
| Line 4,140: | Line 3,650: | ||
===wms_track_tbl=== | ===wms_track_tbl=== | ||
| + | Register for container tracking numbers. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 4,166: | Line 3,677: | ||
===wms_user_tbl=== | ===wms_user_tbl=== | ||
| + | Extended user information, default printer and language. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 4,200: | 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,282: | Line 3,795: | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
| Line 4,344: | 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,374: | Line 3,835: | ||
===wms_wtint_tbl=== | ===wms_wtint_tbl=== | ||
| + | Transaction history for warehouse transfer receipts. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 4,468: | Line 3,930: | ||
===wms_zone_tbl=== | ===wms_zone_tbl=== | ||
| + | Maps bins to picking and putaway zones. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 4,498: | 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 18:46, 4 February 2010
Contents
[hide]- 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
wmASNHistory
History of EDI ASN transmitted from Whistle.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmAutoReceiveWhs
List of warehouses that can auto receive warehouse transfer push transactions.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmCountDetail
Cycle count detail information. Child of wmCountMaser
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmCountMaster
Cycle count header information. Parent of wmCountDetail
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmCountZones
Contains collection of bins in a count zone.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmCountedBins
Details of what bins have been counted for a particular cycle count.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmCustomer
Configuration details for a customer.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmDemand
Demand records for staging. Contains picking progress information for production orders, sales orders and warehouse transfers.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmExtraInfoUserFlds
Collect users data for purchase order receipts and sales order shippments.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmItemInstruct
Picking instructions for user.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmLabelCrossRef
Attaches Vendor deliver-Froms to a label for vendor label decoding.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmLabelElements
Defines elements on a vendor label.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmPOReturnInt
Transaction history of PO returns.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmPrintJobs
Holds sequence registers for preprinted labels.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmReceiptReturn
Collects details of Purchase order returns.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmReclassHist
Transactional history for Item Reclass transactions.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmScaleDefinition
Load cell setup.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmStockMoveInt
Transaction history of ERP stock move interfaces
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmTestHistory
History of QC test data collection.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmUomConv
Warehouse level UOM conversions.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmUserPrefs
Warehouse and User level software settings.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wmWave
Wave picking header.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_autohd_tbl
Definition by item of timed and indefinite holds for receipts and production.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_bin_tbl
Definition of bin locations in a warehouse.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_bindtlst_tbl
Contains location of containers in the warehouse and the space remaining in bins.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_case_tbl
Case number register by warehouse.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_comments_tbl
List of valid comments by warehouse.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_contadj_tbl
Transaction history of misc adjustments made to inventory.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_contcase_tbl
Case/sublot level inventory master. Child of wms_contdtl_tbl.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_contdtl_tbl
Item/Pack/Lot level inventory master. Child of wms_conthdr_tbl, parent of wms_contcase_tbl table.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_context_tbl
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_conthdr_tbl
Inventory master for container (pallet) level inventory. Parent of wms_contdtl_tbl.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_contst_tbl
Valid inventory statuses
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_contty_tbl
Definition of container types.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_contxf_tbl
Maps Item/Packs to a container type.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_counter_tbl
Generic counter table.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_ctwght_tbl
Defines the setup for catchweight or serial tracked inventory.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_custpull_tbl
Days of shelf life required for a customer when shipping.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_erpint_tbl
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_except_tbl
Logs users exceptions, like not following pick or putaway recommendations.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_group_tbl
Defines groupings of containers.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_kit_tbl
Formulations for kit building.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_lhold_tbl
Transactional history for lot holds.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_load_tbl
Contains extended information about a shipment load. Also used for BOL generation.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_loadnm_tbl
Register for load numbers.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_lothist_tbl
Transaction history for system.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_outint_tbl
Transaction history for shipments.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_piint_tbl
Transaction history for production issues.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_pmint_tbl
Transaction history for production reports.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_pmintdtl_tbl
Transaction history for production reports of catchweight / serial tracked inventory.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_point_tbl
Transactional history of purchase order receipts.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_print_tbl
Printer definition.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_pultol_tbl
Number of days to consider inventory as the same age.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_recper_tbl
Date of last ERP reconciliation.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_rma_tbl
Whistle RMA information.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_screen_tbl
Valid screens for a warehouse.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_sectmpl_tbl
Security template definition.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_secure_tbl
Users security rights.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_track_tbl
Register for container tracking numbers.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_user_tbl
Extended user information, default printer and language.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_usercols_tbl
Metadata for user columns in wms_contdtl_tbl table.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_vndpull_tbl
Minimum number of days of shelf life to allow for receipt of an item.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_wtint_tbl
Transaction history for warehouse transfer receipts.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_zone_tbl
Maps bins to picking and putaway zones.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
wms_zonexf_tbl
Attaches an item to one or more preferred zones.
| Column | Data Type | Nullable | Key Description |
|---|---|---|---|
|
|
|
|
