Difference between revisions of "GT:Appendix C Whistle Database Tables"
From coolearthwiki
(Add description to tables, remove no longer used schema.) |
|||
| (20 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 28: | Line 29: | ||
*wmPrintJobs | *wmPrintJobs | ||
*wmReceiptReturn | *wmReceiptReturn | ||
| − | * | + | *wmReclassHist |
| − | |||
| − | |||
*wmScaleDefinition | *wmScaleDefinition | ||
| − | * | + | *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 72: | Line 70: | ||
*wms_pultol_tbl | *wms_pultol_tbl | ||
*wms_recper_tbl | *wms_recper_tbl | ||
| + | *wms_rma_tbl | ||
*wms_screen_tbl | *wms_screen_tbl | ||
*wms_sectmpl_tbl | *wms_sectmpl_tbl | ||
| Line 141: | Line 140: | ||
|- | |- | ||
===wmASNHistory=== | ===wmASNHistory=== | ||
| + | History of EDI ASN transmitted from Whistle. | ||
| | | | ||
*company | *company | ||
| Line 209: | 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 220: | Line 244: | ||
===wmCountDetail=== | ===wmCountDetail=== | ||
| + | Cycle count detail information. Child of wmCountMaser | ||
| | | | ||
*company | *company | ||
| Line 301: | Line 326: | ||
|- | |- | ||
===wmCountMaster=== | ===wmCountMaster=== | ||
| + | Cycle count header information. Parent of wmCountDetail | ||
| | | | ||
*company | *company | ||
| Line 362: | Line 388: | ||
|- | |- | ||
===wmCountZones=== | ===wmCountZones=== | ||
| + | Contains collection of bins in a count zone. | ||
| | | | ||
*company | *company | ||
| Line 391: | Line 418: | ||
|- | |- | ||
===wmCountedBins=== | ===wmCountedBins=== | ||
| + | Details of what bins have been counted for a particular cycle count. | ||
| | | | ||
*company | *company | ||
| Line 436: | Line 464: | ||
|- | |- | ||
===wmCustomer=== | ===wmCustomer=== | ||
| + | Configuration details for a customer. | ||
| | | | ||
*company | *company | ||
| Line 465: | Line 494: | ||
|- | |- | ||
===wmDemand=== | ===wmDemand=== | ||
| + | Demand records for staging. Contains picking progress information for production orders, sales orders and warehouse transfers. | ||
| | | | ||
*company | *company | ||
| Line 542: | Line 572: | ||
|- | |- | ||
===wmExtraInfoUserFlds=== | ===wmExtraInfoUserFlds=== | ||
| + | Collect users data for purchase order receipts and sales order shippments. | ||
| | | | ||
*company | *company | ||
| Line 708: | Line 739: | ||
===wmItemInstruct=== | ===wmItemInstruct=== | ||
| + | Picking instructions for user. | ||
| | | | ||
*company | *company | ||
| Line 745: | Line 777: | ||
|- | |- | ||
===wmLabelCrossRef=== | ===wmLabelCrossRef=== | ||
| + | Attaches Vendor deliver-Froms to a label for vendor label decoding. | ||
| | | | ||
*company | *company | ||
| Line 774: | Line 807: | ||
|- | |- | ||
===wmLabelElements=== | ===wmLabelElements=== | ||
| + | Defines elements on a vendor label. | ||
| | | | ||
*labelKey | *labelKey | ||
| Line 834: | 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( | + | *varchar(3) |
| − | *varchar( | + | *varchar(5) |
| − | + | *varchar(5) | |
| − | *varchar( | + | *varchar(10) |
| − | + | *int | |
| − | *varchar(10) | ||
| − | * | ||
*varchar(10) | *varchar(10) | ||
| + | *varchar(20) | ||
| + | *int | ||
*varchar(30) | *varchar(30) | ||
| − | * | + | *varchar(10) |
| − | *varchar( | + | *varchar(25) |
| − | * | + | *varchar(10) |
| − | *varchar( | + | *decimal |
| − | *datetime | + | *varchar(6) |
| − | *varchar( | + | *datetime |
| − | * | + | *varchar(8) |
| − | + | *varchar(60) | |
| | | | ||
| − | |||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
| Line 892: | Line 926: | ||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
| − | | | + | *NOTNULL |
| − | * | + | | |
| − | *Company Key | + | *Return Line Key |
| − | *Warehouse Key | + | *Company Key |
| − | *Order | + | *Branch Key |
| − | *Order Key | + | *Warehouse Key |
| − | * | + | *Purchase Order Key |
| − | *Container Key | + | *Purchase Order Detail Key |
| − | *Item Key | + | *Receipt Key |
| − | *Pack Key | + | *Container Header Key |
| − | * | + | *Container Detail Key |
| − | * | + | *Item Key |
| − | * | + | *Pack Key |
| − | * | + | *Lot Key |
| − | * | + | *Location Key |
| − | + | *Quantity Returned | |
| − | *User Key | + | *Quantity Returned Unit of Measure |
| − | + | *Returned Date/Time Value | |
| − | * | + | *User Key |
| + | *Control Number | ||
|} | |} | ||
| Line 919: | 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 | |
| − | |||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| | | | ||
| − | + | *varchar(2) | |
| − | + | *varchar(4) | |
| − | *varchar( | + | *varchar(10) |
| − | *varchar( | + | *int |
| − | *varchar(10) | + | *varchar(255) |
| − | *int | + | *varchar(255) |
| − | *varchar( | + | *int |
| − | *varchar( | + | *varchar(10) |
| − | *int | + | *varchar(10) |
| − | *varchar( | ||
| − | *varchar(10) | ||
| − | |||
*varchar(10) | *varchar(10) | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| | | | ||
| + | *NOTNULL | ||
*NOTNULL | *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,004: | 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,058: | 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) | ||
| + | *float | ||
| + | *varchar(5) | ||
| + | *varchar(10) | ||
| + | *varchar(25) | ||
| + | *varchar(20) | ||
| + | *varchar(10) | ||
*varchar(20) | *varchar(20) | ||
| − | *varchar( | + | *float |
| − | *varchar( | + | *varchar(5) |
| − | + | *varchar(10) | |
| − | *varchar( | + | *varchar(25) |
| − | *varchar( | + | *datetime |
| − | *varchar( | + | *varchar(8) |
| − | *varchar( | + | *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 | ||
|} | |} | ||
| Line 1,128: | Line 1,182: | ||
|- | |- | ||
| − | === | + | ===wmScaleDefinition=== |
| + | Load cell setup. | ||
| | | | ||
| − | * | + | *company |
| − | * | + | *warehouse |
| − | * | + | *scaleKey |
| − | + | *scaleDescription | |
| − | + | *scaleAddress | |
| − | * | + | | |
| − | * | + | *varchar(2) |
| − | + | *varchar(4) | |
| − | |||
| − | |||
| − | |||
| − | | | ||
| − | |||
| − | *varchar( | ||
| − | *varchar( | ||
*varchar(60) | *varchar(60) | ||
| − | + | *varchar(128) | |
| − | *varchar( | + | *varchar(128) |
| − | *varchar( | ||
| − | |||
| − | |||
| − | |||
| − | |||
| | | | ||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
| − | * | + | *NULL |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
*NOTNULL | *NOTNULL | ||
| | | | ||
| − | + | *Company Key | |
| − | *Company Key | + | *Warehouse Key |
| − | *Warehouse Key | + | *Scale Key |
| − | + | *Scale Description Value | |
| − | + | *Scale Address Value | |
| − | |||
| − | * | ||
| − | * | ||
| − | * | ||
| − | |||
| − | |||
|} | |} | ||
| Line 1,186: | Line 1,217: | ||
|- | |- | ||
| − | === | + | ===wmStockMoveInt=== |
| + | Transaction history of ERP stock move interfaces | ||
| | | | ||
| − | * | + | *company |
| − | * | + | *warehouse |
| − | * | + | *wms_conthdr_key |
| − | * | + | *tolocation |
| − | * | + | *fromlocation |
| − | * | + | *sa_user_key |
| − | * | + | *createdate |
| − | * | + | *item |
| − | * | + | *pack |
| − | * | + | *quantity |
| − | + | *uom | |
| − | * | + | *wms_eia_cntrl |
| − | * | + | *reason |
| − | * | + | *trans_date |
| − | * | + | *lot |
| − | + | | | |
| − | *varchar( | + | *varchar(2) |
| − | * | + | *varchar(4) |
| − | *varchar( | + | *varchar(10) |
| − | * | + | *varchar(10) |
| − | * | + | *varchar(10) |
| − | + | *varchar(8) | |
| − | * | + | *datetime |
| − | * | + | *varchar(20) |
| − | * | + | *varchar(10) |
| − | * | + | *float |
| − | * | + | *varchar(6) |
| − | * | + | *varchar(60) |
| − | * | + | *varchar(14) |
| − | * | + | *datetime |
| − | * | + | *varchar(25) |
| − | * | ||
| | | | ||
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | *User Key | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | | | ||
| + | *Company Key | ||
| + | *Warehouse Key | ||
| + | *Container Header Key | ||
| + | *Destination Location | ||
| + | *Source Location | ||
| + | *User Key | ||
| + | *Created On Date/Time Value | ||
| + | *Item Key | ||
| + | *Pack Key | ||
| + | *Quantity | ||
| + | *Unit of Measure | ||
| + | *Control Number | ||
| + | *Reason Code | ||
| + | *Transaction Date/Time Value | ||
| + | *Lot Key | ||
|} | |} | ||
| − | + | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
!Column | !Column | ||
| Line 1,241: | Line 1,293: | ||
|- | |- | ||
| − | === | + | ===wmTestHistory=== |
| + | History of QC test data collection. | ||
| | | | ||
| − | * | + | *testKey |
| − | * | + | *effectiveDate |
| − | * | + | *sequence |
| − | * | + | *item |
| − | * | + | *pack |
| − | * | + | *lot |
| − | * | + | *sampleID |
| − | * | + | *status |
| − | * | + | *result |
| − | * | + | *measured |
| − | | | + | *measuredUOM |
| − | *int | + | *comments |
| − | *varchar( | + | *transactionTime |
| − | *varchar(30) | + | *tranactionUser |
| − | *varchar( | + | | |
| − | *varchar( | + | *varchar(10) |
| − | *varchar( | + | *datetime |
| − | * | + | *int |
| − | *varchar( | + | *varchar(20) |
| − | *datetime | + | *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 | ||
| Line 1,275: | Line 1,332: | ||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
| − | | | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NOTNULL |
| − | * | + | *NULL |
| − | * | + | | |
| − | * | + | *Test Key |
| − | * | + | *Effective Date/Time Value |
| − | |} | + | *Sequence Value |
| + | *Item Key | ||
| + | *Pack Key | ||
| + | *Lot Key | ||
| + | *Sample ID Value | ||
| + | *Status Value | ||
| + | *Result Value | ||
| + | *Measured value | ||
| + | *Unit Of Measure Value | ||
| + | *Comment Value | ||
| + | *Transaction Date/Time Value | ||
| + | *User Key | ||
| + | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
| Line 1,295: | Line 1,364: | ||
|- | |- | ||
| − | === | + | ===wmUomConv=== |
| + | Warehouse level UOM conversions. | ||
| + | | | ||
| + | *gl_cmp_key | ||
| + | *in_whs_key | ||
| + | *in_item_key | ||
| + | *im_pack_key | ||
| + | *uom_from | ||
| + | *uom_to | ||
| + | *factor | ||
| | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
*varchar(2) | *varchar(2) | ||
*varchar(4) | *varchar(4) | ||
| − | *varchar( | + | *varchar(20) |
| − | *varchar( | + | *varchar(6) |
| − | *varchar( | + | *varchar(10) |
| + | *varchar(10) | ||
| + | *float | ||
| | | | ||
| − | *NOTNULL | + | *NOTNULL |
| − | *NOTNULL | + | *NOTNULL |
| − | *NOTNULL | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | *NOTNULL | + | *NOTNULL |
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| | | | ||
| − | *Company Key | + | *Company Key |
| − | *Warehouse Key | + | *Warehouse Key |
| − | * | + | *Item Key |
| − | * | + | *Pack Key |
| − | * | + | *UOM From Key |
| + | *UOM To Key | ||
| + | *Factor Key | ||
|} | |} | ||
| − | + | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
!Column | !Column | ||
| Line 1,329: | Line 1,407: | ||
|- | |- | ||
| − | === | + | ===wmUserPrefs=== |
| + | Warehouse and User level software settings. | ||
| | | | ||
| − | * | + | *gl_cmp_key |
| − | * | + | *in_whs_key |
| − | * | + | *user_key |
| − | * | + | *pref_name |
| − | * | + | *pref_value |
| − | * | + | *created_by |
| − | * | + | *created_on |
| − | * | + | *changed_by |
| − | * | + | *changed_on |
| − | * | + | *lock_counter |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| | | | ||
| − | * | + | *varchar(2) |
| − | *NOTNULL | + | *varchar(4) |
| − | *NOTNULL | + | *varchar(8) |
| − | * | + | *varchar(64) |
| − | * | + | *varchar(256) |
| − | *NULL | + | *varchar(8) |
| − | *NOTNULL | + | *datetime |
| − | *NOTNULL | + | *varchar(8) |
| − | *NOTNULL | + | *datetime |
| − | *NOTNULL | + | *int |
| − | *NOTNULL | + | | |
| − | | | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | * | + | *NULL |
| − | + | *NOTNULL | |
| − | + | *NOTNULL | |
| − | *User Key | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | *User Key | + | *NOTNULL |
| − | * | + | | |
| − | *Lock Counter Value | + | *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 | ||
|} | |} | ||
| Line 1,387: | Line 1,462: | ||
|- | |- | ||
| − | === | + | ===wmWave=== |
| + | Wave picking header. | ||
| | | | ||
| − | * | + | *company |
| − | * | + | *warehouse |
| − | * | + | *waveKey |
| − | * | + | *createdOn |
| − | * | + | *createdBy |
| − | + | | | |
| − | * | + | *varchar(2) |
| − | * | + | *varchar(4) |
| − | + | *varchar(10) | |
| − | + | *datetime | |
| − | + | *varchar(10) | |
| − | * | ||
| − | * | ||
| − | * | ||
| | | | ||
| − | * | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | * | + | *NULL |
| − | * | + | *NOTNULL |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| | | | ||
| − | * | + | *Company Key |
| − | + | *Warehouse Key | |
| − | + | *Wave Key | |
| − | + | *Created on Date/Time Value | |
| − | + | *User Key | |
| − | + | |} | |
| − | + | ||
| − | + | {| border="1" cellpadding="2" valign="top" halign="left" | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | * | ||
| − | |||
| − | * | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | * | ||
| − | *User Key | ||
| − | |} | ||
| − | |||
| − | {| border="1" cellpadding="2" valign="top" halign="left" | ||
!Column | !Column | ||
!Data Type | !Data Type | ||
| Line 1,457: | Line 1,497: | ||
|- | |- | ||
| − | === | + | ===wms_autohd_tbl=== |
| + | Definition by item of timed and indefinite holds for receipts and production. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 1,463: | Line 1,504: | ||
*in_item_key | *in_item_key | ||
*im_pack_key | *im_pack_key | ||
| − | * | + | *wms_autohd_hrs |
| − | * | + | *context |
| − | |||
| | | | ||
| − | *varchar(2) | + | *varchar(2) |
| − | *varchar(4) | + | *varchar(4) |
| − | *varchar( | + | *varchar(30) |
| − | *varchar(6) | + | *varchar(6) |
| − | * | + | *int |
| − | *varchar(10) | + | *varchar(10) |
| − | |||
| | | | ||
| − | |||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
| + | *NULL | ||
*NOTNULL | *NOTNULL | ||
| − | |||
| | | | ||
| − | *Company Key | + | *Company Key |
| − | *Warehouse Key | + | *Warehouse Key |
| − | *Item Key | + | *Item Key |
| − | *Pack Key | + | *Pack Key |
| − | * | + | *Autohold Length Hours Value |
| − | * | + | *Context Value |
| − | |||
|} | |} | ||
| Line 1,499: | Line 1,536: | ||
|- | |- | ||
| − | === | + | ===wms_bin_tbl=== |
| + | Definition of bin locations in a warehouse. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
*in_whs_key | *in_whs_key | ||
| − | * | + | *in_locn_key |
| − | * | + | *wms_bin_key |
| − | * | + | *wms_bin_depth |
| − | * | + | *wms_bin_height |
| − | * | + | *wms_bin_width |
| − | * | + | *wms_bin_type |
| − | * | + | *wms_bin_row |
| − | * | + | *wms_bin_col |
| − | + | *wms_bin_cychd | |
| − | * | + | *wms_bin_hold |
| − | * | + | *can_mix_items |
| − | * | + | *not_on_picklist |
| − | *varchar( | + | *dont_trackvol |
| − | *varchar( | + | | |
| − | *varchar( | + | *varchar(3) |
| − | + | *varchar(4) | |
| − | *varchar( | + | *varchar(10) |
| − | * | + | *varchar(15) |
| − | * | + | *float |
| − | + | *float | |
| − | * | + | *float |
| − | * | + | *varchar(10) |
| − | * | + | *int |
| − | * | + | *int |
| − | * | + | *int |
| − | * | + | *int |
| − | * | + | *int |
| − | * | + | *int |
| − | * | + | *int |
| − | |||
| | | | ||
| − | *Company Key | + | *NOTNULL |
| − | *Warehouse Key | + | *NOTNULL |
| − | * | + | *NULL |
| − | * | + | *NOTNULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | | | ||
| + | *Company Key | ||
| + | *Warehouse Key | ||
| + | *ERP Location Key | ||
| + | *Bin Key | ||
| + | *Bin Depth Value | ||
| + | *Bin Height Value | ||
| + | *Bin Width Value | ||
| + | *Bin Type Value | ||
| + | *Bin row # (x) Value | ||
| + | *Bin column # (y) Value | ||
| + | *Bin Cycle Lock Value | ||
| + | *Bin On Hold Value | ||
| + | *Bin will accept a mix of items | ||
| + | *Don't show bin contents in picklist | ||
| + | *Don't calculate bin volume | ||
|} | |} | ||
| + | |||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
| Line 1,553: | Line 1,612: | ||
|- | |- | ||
| − | === | + | ===wms_bindtlst_tbl=== |
| + | Contains location of containers in the warehouse and the space remaining in bins. | ||
| | | | ||
| − | * | + | *gl_cmp_key |
| − | * | + | *in_whs_key |
| − | * | + | *wms_bin_key |
| − | * | + | *wms_zone_key |
| − | * | + | *wms_conthdr_key |
| − | * | + | *wms_bin_depth |
| − | * | + | *wms_bin_height |
| − | * | + | *wms_bin_width |
| − | + | *wms_bin_vol | |
| − | + | *wms_binst_rem | |
| − | * | + | *wms_binst_pc |
| − | + | *in_item_key | |
| − | + | *im_pack_key | |
| − | + | *in_lot_key | |
| − | + | *wms_contdtl_puldt | |
| − | + | *wms_contdtl_alloc | |
| − | * | + | *wms_contst_key |
| − | + | *wms_conthdr_lstmv | |
| − | + | *wms_contdtl_qty | |
| − | + | *wms_bin_type | |
| − | * | + | *wms_contdtl_key |
| − | + | *wms_count_key | |
| − | * | + | *wms_count_qty |
| − | + | *wms_count_var | |
| − | + | *lastCount | |
| − | + | *not_on_picklist | |
| − | * | + | *dont_trackvol |
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | |||
| − | |||
| | | | ||
| − | *NOTNULL | + | *varchar(3) |
| − | *NOTNULL | + | *varchar(4) |
| − | *NOTNULL | + | *varchar(13) |
| − | *NOTNULL | + | *varchar(10) |
| − | * | + | *varchar(10) |
| − | * | + | *float |
| − | *NULL | + | *float |
| − | *NULL | + | *float |
| − | *NULL | + | *float |
| − | *NULL | + | *float |
| − | *NOTNULL | + | *int |
| − | *NOTNULL | + | *varchar(30) |
| − | *NULL | + | *varchar(6) |
| − | *NULL | + | *varchar(25) |
| − | *NULL | + | *datetime |
| − | *NOTNULL | + | *varchar(20) |
| − | * | + | *varchar(10) |
| − | * | + | *datetime |
| − | *NOTNULL | + | *float |
| − | *NOTNULL | + | *varchar(10) |
| − | *NOTNULL | + | *int |
| + | *int | ||
| + | *float | ||
| + | *float | ||
| + | *datetime | ||
| + | *int | ||
| + | *int | ||
| + | | | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NULL | ||
| + | *NOTNULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NOTNULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| | | | ||
| − | |||
| − | |||
*Company Key | *Company Key | ||
*Warehouse Key | *Warehouse Key | ||
| − | * | + | *Bin Key |
| − | * | + | *Zone Key |
| − | * | + | *Tracking Key |
| − | * | + | *Bin Depth Value |
| − | * | + | *Bin Height Value |
| − | * | + | *Bin Width Value |
| − | * | + | *Bin Volume Value |
| − | * | + | *Volume Remaining Value |
| − | * | + | *Number Of Pallets Value |
| − | * | + | *Item Key |
| − | * | + | *Pack Key |
| − | * | + | *Lot Key |
| − | * | + | *Pull Date/Time Value |
| − | * | + | *Pallet Allocation Value |
| − | * | + | *Tracking Key |
| − | * | + | *Last Moved Date/Time Value |
| − | * | + | *Detail Quantity |
| + | *Bin Type | ||
| + | *Container Detail Key | ||
| + | *Count Key | ||
| + | *Cycle Count Quantity Value | ||
| + | *Cycle Count Variance Value | ||
| + | *Counted On Date/Time Value | ||
| + | *Don't show bin contents in picklist | ||
| + | *Dont' calculate bin volume | ||
|} | |} | ||
| Line 1,651: | Line 1,735: | ||
|- | |- | ||
| − | === | + | ===wms_case_tbl=== |
| + | Case number register by warehouse. | ||
| | | | ||
| − | * | + | *gl_cmp_key |
| − | * | + | *in_whs_key |
| − | * | + | *wms_case_num |
| − | * | + | *created_on |
| − | * | + | *changed_on |
| − | | | + | *created_by |
| + | *changed_by | ||
| + | *lock_count | ||
| + | | | ||
*varchar(2) | *varchar(2) | ||
*varchar(4) | *varchar(4) | ||
| − | * | + | *int |
| + | *datetime | ||
*datetime | *datetime | ||
| − | *varchar( | + | *varchar(8) |
| + | *varchar(8) | ||
| + | *int | ||
| | | | ||
| − | *NOTNULL | + | *NOTNULL |
| − | *NOTNULL | + | *NOTNULL |
| − | *NOTNULL | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | *NOTNULL | + | *NOTNULL |
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| | | | ||
| − | *Company Key | + | *Company Key |
| − | *Warehouse Key | + | *Warehouse Key |
| − | * | + | *Case Number Value |
| − | *Created on Date | + | *Created on Date |
| − | *User Key | + | *Changed on Date |
| + | *User Key | ||
| + | *User Key | ||
| + | *Lock Counter Value | ||
|} | |} | ||
| Line 1,685: | Line 1,782: | ||
|- | |- | ||
| − | === | + | ===wms_comments_tbl=== |
| + | List of valid comments by warehouse. | ||
| | | | ||
| − | * | + | *company |
| − | * | + | *warehouse |
| − | * | + | *comments |
| − | |||
| − | |||
| − | |||
| | | | ||
| − | *varchar(2) | + | *varchar(2) |
| − | *varchar(4) | + | *varchar(4) |
| − | *varchar( | + | *varchar(60) |
| − | |||
| − | |||
| − | |||
| | | | ||
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | + | *NULL | |
| − | + | | | |
| − | *NULL | + | *Company Key |
| − | + | *Warehouse Key | |
| − | | | + | *Comment Text |
| − | *Company Key | + | |
| − | *Warehouse Key | ||
| − | * | ||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| Line 1,723: | Line 1,810: | ||
|- | |- | ||
| − | === | + | ===wms_contadj_tbl=== |
| + | Transaction history of misc adjustments made to inventory. | ||
| | | | ||
| − | *gl_cmp_key | + | *gl_cmp_key |
| − | *in_whs_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(3) |
| − | *varchar(10) | + | *varchar(4) |
| − | *varchar( | + | *varchar(10) |
| − | * | + | *varchar(30) |
| − | *float | + | *varchar(6) |
| − | * | + | *float |
| − | *varchar(10) | + | *varchar(10) |
| − | * | + | *varchar(10) |
| − | *int | + | *datetime |
| − | * | + | *varchar(255) |
| − | * | + | *int |
| + | *varchar(60) | ||
| + | *varchar(60) | ||
| | | | ||
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | *NULL | + | *NULL |
| − | * | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NOTNULL | + | *NOTNULL |
| − | * | + | *NULL |
| + | *NULL | ||
| | | | ||
| − | *Company Key | + | *Company Key |
| − | *Warehouse 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 | ||
|} | |} | ||
| Line 1,785: | Line 1,877: | ||
|- | |- | ||
| − | === | + | ===wms_contcase_tbl=== |
| + | Case/sublot level inventory master. Child of wms_contdtl_tbl. | ||
| + | | | ||
| + | *gl_cmp_key | ||
| + | *in_whs_key | ||
| + | *wms_conthdr_key | ||
| + | *wms_contdtl_key | ||
| + | *wms_contcase_key | ||
| + | *wms_contcase_ctwgt | ||
| + | *in_sublot_key | ||
| + | *wms_contcase_prddt | ||
| + | *created_on | ||
| + | *changed_on | ||
| + | *created_by | ||
| + | *changed_by | ||
| + | *lock_count | ||
| + | *wms_contcase_stat | ||
| + | *wms_contcase_acwgt | ||
| + | *lot | ||
| + | *allocation | ||
| + | *pieces | ||
| + | *lineKey | ||
| | | | ||
| − | + | *varchar(2) | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | *varchar( | ||
*varchar(4) | *varchar(4) | ||
| + | *varchar(10) | ||
*int | *int | ||
| − | *varchar( | + | *varchar(60) |
| + | *float | ||
*int | *int | ||
| − | |||
*datetime | *datetime | ||
| − | *varchar( | + | *datetime |
| − | *varchar( | + | *datetime |
| − | *varchar( | + | *varchar(8) |
| + | *varchar(8) | ||
| + | *int | ||
| + | *int | ||
| + | *float | ||
| + | *varchar(25) | ||
| + | *varchar(25) | ||
| + | *int | ||
| + | *int | ||
| | | | ||
| − | *NULL | + | *NOTNULL |
| − | *NULL | + | *NOTNULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | * | + | *NOTNULL |
| − | * | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NOTNULL |
| − | *NULL | + | *NOTNULL |
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
*NULL | *NULL | ||
| | | | ||
| − | *Company Key | + | *Company Key |
| − | *Warehouse Key | + | *Warehouse Key |
| − | * | + | *Tracking Key |
| − | * | + | *Tracking Detail Key |
| − | * | + | *Tracking Case Key |
| − | * | + | *Tracking Catch Weight Value |
| − | * | + | *Adage SubLot Key |
| − | * | + | *Case Production Date Value |
| − | * | + | *Created On Date Value |
| − | * | + | *Changed On Date Value |
| + | *User Key | ||
| + | *User Key | ||
| + | *Lock Count Value | ||
| + | *Container Status Value | ||
| + | *Container Actual Weight Value | ||
| + | *Lot Key | ||
| + | *Case Allocated Value | ||
| + | *Per box Piece Count | ||
| + | *Line Number | ||
|} | |} | ||
| Line 1,839: | Line 1,968: | ||
|- | |- | ||
| − | === | + | ===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 |
| − | *in_whs_key | + | *in_whs_key |
| − | * | + | *wms_conthdr_key |
| − | * | + | *in_item_key |
| − | * | + | *im_pack_key |
| − | * | + | *so_prod_key |
| − | * | + | *in_desc |
| − | * | + | *wms_contdtl_prddt |
| − | * | + | *wms_contdtl_puldt |
| − | * | + | *wms_contst_key |
| − | * | + | *wms_contdtl_qty |
| − | * | + | *wms_contdtl_uom |
| − | * | + | *in_lot_key |
| − | * | + | *wms_contdtl_alloc |
| − | * | + | *wms_contdtl_vol |
| − | * | + | *wms_contdtl_key |
| − | * | + | *wms_contdtl_ctwgt |
| − | * | + | *wms_user_paramVC1 |
| − | * | + | *wms_user_paramVC2 |
| − | * | + | *wms_user_paramVC3 |
| − | * | + | *wms_user_paramVC4 |
| − | * | + | *wms_user_paramVC5 |
| − | * | + | *wms_user_paramVC6 |
| − | * | + | *wms_user_paramVC7 |
| − | * | + | *wms_user_paramVC8 |
| − | | | + | *wms_user_paramVC9 |
| − | *varchar(3) | + | *wms_user_paramVC10 |
| − | *varchar(4) | + | *wms_user_paramF1 |
| − | *varchar( | + | *wms_user_paramF2 |
| − | *varchar( | + | *wms_user_paramF3 |
| − | *varchar(10) | + | *wms_user_paramF4 |
| − | *float | + | *wms_user_paramF5 |
| − | * | + | *wms_contdtl_crtdt |
| − | *float | + | | |
| − | * | + | *varchar(3) |
| − | *float | + | *varchar(4) |
| − | * | + | *varchar(10) |
| − | *varchar( | + | *varchar(30) |
| − | *varchar( | + | *varchar(6) |
| − | *varchar( | + | *varchar(20) |
| − | * | + | *varchar(60) |
| − | *varchar( | + | *datetime |
| − | *varchar( | + | *datetime |
| − | * | + | *varchar(10) |
| − | * | + | *float |
| − | *varchar( | + | *varchar(6) |
| − | * | + | *varchar(25) |
| − | * | + | *varchar(20) |
| − | *float | + | *float |
| − | *float | + | *int |
| − | *datetime | + | *float |
| + | *varchar(255) | ||
| + | *varchar(255) | ||
| + | *varchar(255) | ||
| + | *varchar(255) | ||
| + | *varchar(255) | ||
| + | *varchar(255) | ||
| + | *varchar(255) | ||
| + | *varchar(255) | ||
| + | *varchar(255) | ||
| + | *varchar(255) | ||
| + | *float | ||
| + | *float | ||
| + | *float | ||
| + | *float | ||
| + | *float | ||
| + | *datetime | ||
| | | | ||
| − | *NOTNULL | + | *NOTNULL |
| − | *NOTNULL | + | *NOTNULL |
| − | *NOTNULL | + | *NOTNULL |
| − | *NULL | + | *NULL |
| − | * | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NOTNULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NOTNULL | + | *NULL |
| − | *NOTNULL | + | *NOTNULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | *NULL | + | *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 | ||
| | | | ||
| − | *Company Key | + | *Company Key |
| − | *Warehouse Key | + | *Warehouse Key |
| − | * | + | *Tracking Key |
| − | * | + | *Item Key |
| − | * | + | *Pack Key |
| − | * | + | *Product # (UPC code) |
| − | * | + | *Item Description Value |
| − | * | + | *Production Date/Time Value |
| − | * | + | *Pull Date Value |
| − | * | + | *Container Status Key |
| − | * | + | *Item Quantity Value |
| − | * | + | *Unit Of Measure Value |
| − | * | + | *Lot Key |
| − | * | + | *Pallet Allocated Value |
| − | * | + | *Item Volume Value |
| − | * | + | *Container Detail Key |
| − | * | + | *Container Detail Catch Weight |
| − | * | + | *User defined Parameter #1 |
| − | * | + | *User defined Parameter #2 |
| − | * | + | *User defined Parameter #3 |
| − | * | + | *User defined Parameter #4 |
| − | * | + | *User defined Parameter #5 |
| − | * | + | *User defined Parameter #6 |
| − | * | + | *User defined Parameter #7 |
| − | * | + | *User defined Parameter #8 |
| + | *User defined Parameter #9 | ||
| + | *User defined Parameter #10 | ||
| + | *User defined Parameter F1 | ||
| + | *User defined Parameter F2 | ||
| + | *User defined Parameter F3 | ||
| + | *User defined Parameter F4 | ||
| + | *User defined Parameter F5 | ||
| + | *Creation Date/Time Value | ||
|} | |} | ||
| Line 1,953: | Line 2,115: | ||
|- | |- | ||
| − | === | + | ===wms_context_tbl=== |
| | | | ||
| − | *gl_cmp_key | + | *gl_cmp_key |
| − | *in_whs_key | + | *in_whs_key |
| − | * | + | *wms_conthdr_key |
| − | *created_on | + | *wms_context_variety |
| − | *changed_on | + | *wms_context_linemtch |
| − | *created_by | + | *wms_context_idfield |
| − | *changed_by | + | *created_on |
| − | *lock_count | + | *changed_on |
| + | *created_by | ||
| + | *changed_by | ||
| + | *lock_count | ||
| | | | ||
*varchar(2) | *varchar(2) | ||
*varchar(4) | *varchar(4) | ||
| − | * | + | *varchar(10) |
| + | *varchar(10) | ||
| + | *varchar(10) | ||
| + | *varchar(4) | ||
*datetime | *datetime | ||
*datetime | *datetime | ||
*varchar(8) | *varchar(8) | ||
*varchar(8) | *varchar(8) | ||
| − | *int | + | *int |
| | | | ||
| − | *NOTNULL | + | *NOTNULL |
| − | *NOTNULL | + | *NOTNULL |
| − | *NOTNULL | + | *NOTNULL |
| − | *NOTNULL | + | *NULL |
| − | *NOTNULL | + | *NULL |
| − | *NOTNULL | + | *NULL |
| − | *NOTNULL | + | *NOTNULL |
| − | *NOTNULL | + | *NOTNULL |
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| | | | ||
| − | *Company Key | + | *Company Key |
| − | *Warehouse Key | + | *Warehouse Key |
| − | * | + | *Tracking Key |
| − | *Created on Date | + | *Context Variety Value |
| − | *Changed on Date | + | *Context Line Match Value |
| − | *User Key | + | *Context ID Field Value |
| − | *User Key | + | *Created on Date/Time Value |
| − | *Lock | + | *Changed on Date/Time Value |
| + | *User Key | ||
| + | *User Key | ||
| + | *Lock Count Value | ||
|} | |} | ||
| Line 1,999: | Line 2,173: | ||
|- | |- | ||
| − | === | + | ===wms_conthdr_tbl=== |
| + | Inventory master for container (pallet) level inventory. Parent of wms_contdtl_tbl. | ||
| | | | ||
| − | *gl_cmp_key | + | *gl_cmp_key |
| − | *in_whs_key | + | *in_whs_key |
| − | *wms_conthdr_key | + | *wms_conthdr_key |
| − | * | + | *wms_contst_key |
| − | * | + | *in_locn_key |
| − | * | + | *wms_bin_key |
| − | * | + | *wms_conthdr_lstmv |
| − | * | + | *wms_contty_key |
| − | * | + | *wms_conthdr_lstdt |
| − | * | + | *sa_user_key |
| − | * | + | *wms_contst_reldt |
| − | * | + | *wms_group_key |
| − | * | + | *wms_conthdr_vol |
| − | | | + | *lockCounter |
| − | *varchar(3) | + | | |
| − | *varchar(4) | + | *varchar(3) |
| − | *varchar(10) | + | *varchar(4) |
| − | *varchar( | + | *varchar(10) |
| − | *varchar( | + | *varchar(10) |
| − | + | *varchar(10) | |
| − | *varchar( | + | *varchar(15) |
| − | *varchar(10) | + | *datetime |
| − | *datetime | + | *varchar(10) |
| − | *varchar( | + | *datetime |
| − | *int | + | *varchar(8) |
| − | * | + | *datetime |
| − | * | + | *int |
| + | *float | ||
| + | *int | ||
| | | | ||
| − | * | + | *NOTNULL |
| + | *NOTNULL | ||
| + | *NOTNULL | ||
*NULL | *NULL | ||
*NULL | *NULL | ||
| Line 2,039: | Line 2,218: | ||
*NULL | *NULL | ||
*NULL | *NULL | ||
| − | |||
*NULL | *NULL | ||
*NULL | *NULL | ||
| | | | ||
| − | *Company Key | + | *Company Key |
| − | *Warehouse Key | + | *Warehouse Key |
| − | *Tracking Key | + | *Tracking Key |
| − | * | + | *Container Status Value |
| − | * | + | *Location Key |
| − | * | + | *Bin Key |
| − | * | + | *Last Moved Date/Time Value |
| − | *User Key | + | *Container Type |
| − | * | + | *Container Last Changed Date Value |
| − | * | + | *User Key |
| − | *Container | + | *Release Date/Time |
| − | * | + | *Group Key |
| − | + | *Container Volume Value | |
| + | *Lock Counter Value | ||
|} | |} | ||
| Line 2,065: | Line 2,244: | ||
|- | |- | ||
| − | === | + | ===wms_contst_tbl=== |
| + | Valid inventory statuses | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
*in_whs_key | *in_whs_key | ||
| − | * | + | *wms_contst_key |
| − | * | + | *wms_contst_desc |
| − | * | + | *wms_contst_type |
| − | * | + | *wms_contst_reldt |
| − | + | *wms_contst_relby | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| | | | ||
| − | *varchar( | + | *varchar(3) |
*varchar(4) | *varchar(4) | ||
*varchar(10) | *varchar(10) | ||
| − | |||
*varchar(60) | *varchar(60) | ||
| − | * | + | *varchar(10) |
| − | |||
| − | |||
| − | |||
| − | |||
*varchar(8) | *varchar(8) | ||
| − | *varchar(8) | + | *varchar(8) |
| − | |||
| − | |||
| − | |||
| | | | ||
| + | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
*NULL | *NULL | ||
*NULL | *NULL | ||
| − | |||
*NULL | *NULL | ||
*NULL | *NULL | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| | | | ||
| − | *Company Key | + | *Company Key |
| − | *Warehouse Key | + | *Warehouse Key |
| − | * | + | *Container Status Value |
| − | + | *Container Description Value | |
| − | + | *Container Type Value | |
| − | + | *Container Release Date Value | |
| − | * | + | *Container Release By Date Value |
| − | |||
| − | |||
| − | * | ||
| − | |||
| − | |||
| − | |||
| − | *Container | ||
| − | *Container | ||
|} | |} | ||
| Line 2,139: | Line 2,287: | ||
|- | |- | ||
| − | === | + | ===wms_contty_tbl=== |
| + | Definition of container types. | ||
| | | | ||
| − | *gl_cmp_key | + | *gl_cmp_key |
| − | *in_whs_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 |
| − | * | + | |} |
| − | * | + | |
| − | * | + | {| border="1" cellpadding="2" valign="top" halign="left" |
| − | * | + | !Column |
| − | * | + | !Data Type |
| − | * | + | !Nullable |
| − | * | + | !Key Description |
| − | * | + | |- |
| − | * | + | |
| − | + | ===wms_contxf_tbl=== | |
| − | *varchar( | + | Maps Item/Packs to a container type. |
| − | *varchar( | + | | |
| − | *varchar( | + | *gl_cmp_key |
| − | *varchar( | + | *in_whs_key |
| − | *varchar( | + | *wms_contty_key |
| − | *varchar( | + | *in_item_key |
| − | *varchar( | + | *im_pack_key |
| − | + | *wms_desc | |
| − | *float | + | *so_prod_key |
| − | *float | + | *wms_active_qty |
| − | *float | + | *wms_hold_qty |
| − | * | + | *toleranceOver |
| − | + | *wms_contxf_pseq | |
| − | + | | | |
| + | *varchar(3) | ||
| + | *varchar(4) | ||
| + | *varchar(10) | ||
| + | *varchar(30) | ||
| + | *varchar(6) | ||
| + | *varchar(60) | ||
| + | *varchar(20) | ||
| + | *float | ||
| + | *float | ||
| + | *float | ||
| + | *int | ||
| | | | ||
| − | |||
| − | |||
*NOTNULL | *NOTNULL | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
*NOTNULL | *NOTNULL | ||
| − | |||
| − | |||
| − | |||
*NOTNULL | *NOTNULL | ||
| − | * | + | *NOTNULL |
| − | |||
*NOTNULL | *NOTNULL | ||
*NULL | *NULL | ||
| Line 2,229: | Line 2,378: | ||
*NULL | *NULL | ||
*NULL | *NULL | ||
| − | * | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | * | + | | |
| − | * | + | *Company Key |
| − | * | + | *Warehouse Key |
| − | * | + | *Container Type Value |
| − | * | + | *Item Key |
| − | * | + | *Pack Key |
| − | * | + | *Item Description Value |
| − | * | + | *Adage Sales Order Production Key |
| − | * | + | *Container Active Quantity |
| − | * | + | *Container Hold Quantity |
| − | * | + | *Tolerance Over Value |
| + | *Container Cross Reference Seq Key | ||
| + | |} | ||
| + | |||
| + | {| border="1" cellpadding="2" valign="top" halign="left" | ||
| + | !Column | ||
| + | !Data Type | ||
| + | !Nullable | ||
| + | !Key Description | ||
| + | |- | ||
| + | |||
| + | ===wms_counter_tbl=== | ||
| + | Generic counter table. | ||
| | | | ||
| − | * | + | *wms_counter_type |
| − | * | + | *wms_counter_idx |
| − | + | | | |
| − | * | + | *smallint |
| − | * | + | *int |
| − | + | | | |
| − | * | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | + | | | |
| − | * | + | *Counter Name Value |
| − | + | *Current Counter Number Value | |
| − | * | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| Line 2,285: | Line 2,424: | ||
|- | |- | ||
| − | === | + | ===wms_ctwght_tbl=== |
| + | Defines the setup for catchweight or serial tracked inventory. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
*in_whs_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 | *created_on | ||
*changed_on | *changed_on | ||
| Line 2,298: | Line 2,442: | ||
*changed_by | *changed_by | ||
*lock_count | *lock_count | ||
| − | | | + | *wms_ctwght_netwt |
| − | *varchar(2) | + | *wms_ctwght_backdt |
| − | *varchar(4) | + | *wms_ctwght_sell |
| − | *varchar( | + | | |
| − | *varchar( | + | *varchar(2) |
| − | *varchar( | + | *varchar(4) |
| − | *varchar( | + | *varchar(20) |
| − | *datetime | + | *varchar(6) |
| − | *datetime | + | *float |
| − | *varchar(8) | + | *float |
| − | *varchar(8) | + | *float |
| − | *int | + | *varchar(40) |
| − | + | *varchar(60) | |
| − | * | + | *varchar(6) |
| − | * | + | *datetime |
| − | * | + | *datetime |
| − | + | *varchar(8) | |
| − | + | *varchar(8) | |
| − | + | *int | |
| − | + | *float | |
| − | + | *int | |
| − | + | *int | |
| − | |||
| − | |||
| | | | ||
| − | *Company Key | + | *NOTNULL |
| − | *Warehouse Key | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | *Created on Date/Time Value | + | *NOTNULL |
| − | *Changed on Date/Time Value | + | *NULL |
| − | *User Key | + | *NOTNULL |
| − | *User Key | + | *NOTNULL |
| − | *Lock Count Value | + | *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" | ||
!Column | !Column | ||
| Line 2,343: | Line 2,511: | ||
|- | |- | ||
| − | === | + | ===wms_custpull_tbl=== |
| + | Days of shelf life required for a customer when shipping. | ||
| | | | ||
| − | *gl_cmp_key | + | *gl_cmp_key |
| − | *in_whs_key | + | *in_whs_key |
| − | + | *ap_cust_key | |
| − | + | *wms_custpull_puldt | |
| − | + | | | |
| − | + | *varchar(3) | |
| − | + | *varchar(4) | |
| − | + | *varchar(10) | |
| − | + | *int | |
| − | |||
| − | |||
| − | * | ||
| − | * | ||
| − | |||
| − | | | ||
| − | *varchar(3) | ||
| − | *varchar(4) | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | *varchar(10) | ||
| − | |||
| − | |||
| − | |||
| − | *int | ||
| − | |||
| − | |||
| | | | ||
| − | |||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
| − | * | + | *NOTNULL |
| − | + | *NULL | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | *NULL | ||
| | | | ||
| − | *Company Key | + | *Company Key |
| − | *Warehouse Key | + | *Warehouse Key |
| − | * | + | *Customer Key |
| − | * | + | *Customer Pull Date Value |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| Line 2,413: | Line 2,542: | ||
|- | |- | ||
| − | === | + | ===wms_erpint_tbl=== |
| | | | ||
| − | *gl_cmp_key | + | *gl_cmp_key |
| − | *in_whs_key | + | *in_whs_key |
| − | * | + | *wms_erpint_type |
| − | * | + | *wms_erpint_start |
| − | * | + | *wms_erpint_pid |
| − | |||
| − | |||
| | | | ||
| − | *varchar(3) | + | *varchar(3) |
| − | *varchar(4) | + | *varchar(4) |
| − | *varchar( | + | *varchar(30) |
| − | * | + | *datetime |
| − | + | *int | |
| − | * | ||
| − | |||
| | | | ||
| − | *NOTNULL | + | *NOTNULL |
| − | *NOTNULL | + | *NOTNULL |
| − | *NOTNULL | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | |||
| − | |||
| | | | ||
| − | *Company Key | + | *Company Key |
| − | *Warehouse Key | + | *Warehouse Key |
| − | * | + | *ERP Interface Type Value |
| − | + | *ERP Interface Start Value | |
| − | + | *ERP Interface Part ID Value | |
| − | * | ||
| − | * | ||
|} | |} | ||
| Line 2,455: | Line 2,576: | ||
|- | |- | ||
| − | === | + | ===wms_except_tbl=== |
| + | Logs users exceptions, like not following pick or putaway recommendations. | ||
| | | | ||
| − | *gl_cmp_key | + | *gl_cmp_key |
| − | *in_whs_key | + | *in_whs_key |
| − | * | + | *wms_tran_key |
| − | * | + | *wms_conthdr_key |
| − | * | + | *wms_except_sbin |
| − | * | + | *wms_except_ubin |
| − | * | + | *wms_except_sqty |
| − | * | + | *wms_except_uqty |
| − | * | + | *wms_except_note |
| − | * | + | *sa_user_key |
| + | *wms_except_crtdt | ||
| | | | ||
| − | *varchar(3) | + | *varchar(3) |
| − | *varchar(4) | + | *varchar(4) |
| − | *varchar(10) | + | *varchar(10) |
| − | * | + | *varchar(10) |
| − | * | + | *varchar(15) |
| − | * | + | *varchar(15) |
| − | * | + | *float |
| − | * | + | *float |
| − | *varchar( | + | *varchar(255) |
| − | *varchar( | + | *varchar(8) |
| + | *datetime | ||
| | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
*NULL | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| | | | ||
| − | *Company Key | + | *Company Key |
| − | *Warehouse Key | + | *Warehouse Key |
| − | * | + | *Transaction Key |
| − | * | + | *Tracking Key |
| − | * | + | *Bin Key |
| − | * | + | *Bin Key |
| − | * | + | *System Expected Quantity Value |
| − | * | + | *User Entered Quantity Value |
| − | * | + | *Exception Explanation Value |
| − | * | + | *User Key |
| + | *Exception Creation Date/Time | ||
|} | |} | ||
| Line 2,509: | Line 2,635: | ||
|- | |- | ||
| − | === | + | ===wms_group_tbl=== |
| + | Defines groupings of containers. | ||
| | | | ||
| − | *gl_cmp_key | + | *gl_cmp_key |
| − | *in_whs_key | + | *in_whs_key |
| − | * | + | *wms_group_key |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| | | | ||
| − | *varchar(3) | + | *varchar(3) |
| − | *varchar(4) | + | *varchar(4) |
| − | + | *int | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | *int | ||
| | | | ||
| − | *NOTNULL | + | *NOTNULL |
| − | + | *NOTNULL | |
| − | + | *NOTNULL | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | *NOTNULL | ||
| − | *NOTNULL | ||
| | | | ||
| − | *Company Key | + | *Company Key |
| − | *Warehouse Key | + | *Warehouse Key |
| − | * | + | *Group Key |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| Line 2,567: | Line 2,662: | ||
|- | |- | ||
| − | === | + | ===wms_kit_tbl=== |
| + | Formulations for kit building. | ||
| | | | ||
| − | * | + | *gl_cmp_key |
| − | * | + | *in_whs_key |
| − | + | *wms_kititem_key | |
| − | * | + | *wms_kitpack_key |
| − | * | + | *in_item_key |
| + | *im_pack_key | ||
| + | *wms_kit_qty | ||
| + | *wms_kit_uom | ||
| + | *created_by | ||
| + | *created_on | ||
| + | *changed_by | ||
| + | *changed_on | ||
| + | *lock_count | ||
| | | | ||
| − | *NOTNULL | + | *varchar(2) |
| − | *NOTNULL | + | *varchar(4) |
| − | | | + | *varchar(20) |
| − | * | + | *varchar(6) |
| − | * | + | *varchar(20) |
| + | *varchar(6) | ||
| + | *float | ||
| + | *varchar(2) | ||
| + | *varchar(8) | ||
| + | *datetime | ||
| + | *varchar(8) | ||
| + | *datetime | ||
| + | *int | ||
| + | | | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | | | ||
| + | *Company Key | ||
| + | *Warehouse Key | ||
| + | *Kit Item Key | ||
| + | *Kit Pack Key | ||
| + | *Item Key | ||
| + | *Pack Key | ||
| + | *Kit Quantity Value | ||
| + | *Kit UOM Value | ||
| + | *Created by Date/Time Value | ||
| + | *Created on Date/Time Value | ||
| + | *User Key | ||
| + | *Changed on Date/Time Value | ||
| + | *Lock Counter Key | ||
|} | |} | ||
| Line 2,589: | Line 2,729: | ||
|- | |- | ||
| − | === | + | ===wms_lhold_tbl=== |
| + | Transactional history for lot holds. | ||
| | | | ||
| − | *gl_cmp_key | + | *gl_cmp_key |
| − | *in_whs_key | + | *in_whs_key |
| − | * | + | *sa_user_key |
| − | * | + | *wms_lhold_lot |
| − | * | + | *wms_lhold_bgdt |
| − | * | + | *wms_lhold_eddt |
| − | * | + | *wms_lhold_cmt |
| − | + | *wms_lhold_trdt | |
| − | + | | | |
| − | + | *varchar(3) | |
| − | + | *varchar(4) | |
| − | + | *varchar(8) | |
| − | + | *varchar(25) | |
| − | + | *datetime | |
| − | + | *datetime | |
| − | + | *varchar(255) | |
| − | * | + | *datetime |
| − | + | | | |
| − | | | + | *NULL |
| − | *varchar( | + | *NULL |
| − | *varchar(4) | + | *NULL |
| − | *varchar( | + | *NULL |
| − | *varchar( | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | + | *NULL | |
| − | *varchar( | ||
| − | * | ||
| − | |||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| | | | ||
| − | + | *Company Key | |
| − | + | *Warehouse Key | |
| − | + | *User Key | |
| − | + | *Lot Hold Lot Value | |
| − | + | *Beginning Hold Date/Time Value | |
| − | + | *Ending Hold Date/Time Value | |
| − | + | *Comment Value | |
| − | + | *Date Lot Placed On Hold Value | |
| − | + | |} | |
| − | + | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | *Company Key | ||
| − | *Warehouse Key | ||
| − | * | ||
| − | |||
| − | |||
| − | |||
| − | * | ||
| − | * | ||
| − | |||
| − | |||
| − | |||
| − | * | ||
| − | * | ||
| − | |||
| − | |||
| − | |||
| − | * | ||
| − | |||
| − | |} | ||
| − | |||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
!Column | !Column | ||
| Line 2,675: | Line 2,776: | ||
|- | |- | ||
| − | === | + | ===wms_load_tbl=== |
| + | Contains extended information about a shipment load. Also used for BOL generation. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| − | * | + | *so_brnch_key |
| − | * | + | *so_hdr_key |
| − | * | + | *wms_load_bol |
| − | | | + | *wms_load_trailer |
| − | *varchar( | + | *wms_load_seal |
| − | *varchar(4) | + | *wms_load_chep |
| − | *varchar(10) | + | *wms_load_shpdt |
| − | *int | + | *in_towhs_key |
| + | *carrier | ||
| + | *prePaidFreight | ||
| + | *status | ||
| + | *loadKey | ||
| + | *temp_recorder | ||
| + | *trl_temp_start | ||
| + | *set_trl_at | ||
| + | *set_trl_for_hrs | ||
| + | *trl_temp_for_trip | ||
| + | *pallets_in | ||
| + | *po_num | ||
| + | | | ||
| + | *varchar(2) | ||
| + | *varchar(4) | ||
| + | *varchar(10) | ||
| + | *varchar(25) | ||
| + | *varchar(25) | ||
| + | *varchar(45) | ||
| + | *int | ||
| + | *datetime | ||
| + | *varchar(4) | ||
| + | *varchar(10) | ||
| + | *float | ||
| + | *varchar(10) | ||
| + | *varchar(10) | ||
| + | *varchar(25) | ||
| + | *varchar(5) | ||
| + | *varchar(5) | ||
| + | *varchar(5) | ||
| + | *varchar(5) | ||
| + | *varchar(5) | ||
| + | *varchar(25) | ||
| | | | ||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
| − | *NULL | + | *NOTNULL |
| − | | | + | *NULL |
| − | *Company Key | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | | | ||
| + | *Company key | ||
| + | *Branch Key | ||
| + | *Tracking Key | ||
| + | *Load BOL Value | ||
| + | *Load Trailer Value | ||
| + | *Load Seal Value | ||
| + | *Load Chep Value | ||
| + | *Load Ship Date/Time Value | ||
| + | *To WHS Key | ||
| + | *Carrier Value | ||
| + | *Pre Paid Freight Value | ||
| + | *Status Value | ||
| + | *Load Key | ||
| + | *Thermometer ID Number | ||
| + | *Temp of Trailer at Start Of Loading Process | ||
| + | *Temp to Set Trailer At | ||
| + | *Number of Hours to Set Temp For | ||
| + | *Temp Trailer Should Maintain For Rest of Trip After set_trl_for_hrs Hours | ||
| + | *Number of Empty Pallets on Truck/Trailer When It Arrives | ||
| + | *PO Number | ||
|} | |} | ||
| Line 2,705: | Line 2,871: | ||
|- | |- | ||
| − | === | + | ===wms_loadnm_tbl=== |
| + | Register for load numbers. | ||
| + | | | ||
| + | *gl_cmp_key | ||
| + | *so_brnch_key | ||
| + | *so_hdr_key | ||
| + | *wms_loadnm_key | ||
| | | | ||
| − | + | *varchar(2) | |
| − | + | *varchar(4) | |
| − | + | *varchar(10) | |
| − | + | *int | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | *varchar( | ||
| − | *varchar(4) | ||
| − | *varchar(10) | ||
| − | * | ||
| − | |||
| − | |||
| − | |||
| − | |||
| | | | ||
| − | * | + | *NOTNULL |
| − | + | *NOTNULL | |
| − | + | *NOTNULL | |
| − | * | + | *NULL |
| − | * | ||
| − | |||
| − | |||
| − | *NULL | ||
| | | | ||
| − | *Company Key | + | *Company Key |
| − | * | + | *Branch Key |
| − | *Tracking Key | + | *Tracking Key |
| − | + | *Load Name Key | |
| − | |||
| − | * | ||
| − | |||
| − | |||
|} | |} | ||
| Line 2,751: | Line 2,902: | ||
|- | |- | ||
| − | === | + | ===wms_lothist_tbl=== |
| + | Transaction history for system. | ||
| | | | ||
| − | *gl_cmp_key | + | *gl_cmp_key |
| − | *in_whs_key | + | *in_whs_key |
| − | * | + | *wms_conthdr_key |
| − | * | + | *wms_tran_type |
| − | * | + | *wms_tran_key |
| + | *in_lot_key | ||
| + | *sa_user_key | ||
| + | *wms_lothist_crtdt | ||
| + | *wms_lothist_qty | ||
| + | *wms_lothist_uom | ||
| + | *wms_contdtl_key | ||
| + | *comment_key | ||
| | | | ||
| − | *varchar(3) | + | *varchar(3) |
| − | *varchar(4) | + | *varchar(4) |
| − | *varchar( | + | *varchar(10) |
| − | *datetime | + | *varchar(15) |
| − | *int | + | *varchar(20) |
| + | *varchar(25) | ||
| + | *varchar(8) | ||
| + | *datetime | ||
| + | *float | ||
| + | *varchar(2) | ||
| + | *int | ||
| + | *varchar(255) | ||
| | | | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
*NOTNULL | *NOTNULL | ||
| − | * | + | *NULL |
| − | |||
| − | |||
| − | |||
| | | | ||
| − | *Company Key | + | *Company Key |
| − | *Warehouse Key | + | *Warehouse Key |
| − | * | + | *Tracking Key |
| − | * | + | *Transaction Type Key |
| − | * | + | *Transaction Key |
| + | *Lot Key | ||
| + | *User Key | ||
| + | *Date of transaction Value | ||
| + | *Lot History Quantity Value | ||
| + | *Unit Of Measure Value | ||
| + | *Container detail Key | ||
| + | *Comment Value | ||
|} | |} | ||
| Line 2,785: | Line 2,965: | ||
|- | |- | ||
| − | === | + | ===wms_outint_tbl=== |
| + | Transaction history for shipments. | ||
| | | | ||
| − | *gl_cmp_key | + | *gl_cmp_key |
| − | * | + | *so_brnch_key |
| − | * | + | *so_hdr_key |
| − | * | + | *so_prod_key |
| − | * | + | *wms_conthdr_key |
| − | * | + | *wms_outint_qty |
| − | * | + | *wms_outint_uom |
| − | * | + | *in_lot_key |
| − | * | + | *wms_outint_error |
| − | * | + | *sa_user_key |
| − | * | + | *wms_outint_crtdt |
| + | *wms_outint_type | ||
| + | *wms_outdtl_key | ||
| + | *in_whs_key | ||
| + | *in_towhs_key | ||
| + | *wms_contdtl_key | ||
| + | *wms_whistle_recdt | ||
| + | *in_item_key | ||
| + | *im_pack_key | ||
| + | *wms_outint_control | ||
| | | | ||
| − | *varchar(3) | + | *varchar(3) |
| − | *varchar(4) | + | *varchar(4) |
| − | *varchar(10) | + | *varchar(10) |
| − | *varchar(10) | + | *varchar(30) |
| − | *varchar( | + | *varchar(10) |
| − | *varchar( | + | *float |
| − | * | + | *varchar(2) |
| − | * | + | *varchar(25) |
| − | *varchar( | + | *varchar(255) |
| − | *varchar( | + | *varchar(8) |
| − | *datetime | + | *datetime |
| + | *int | ||
| + | *int | ||
| + | *varchar(4) | ||
| + | *varchar(4) | ||
| + | *smallint | ||
| + | *datetime | ||
| + | *varchar(20) | ||
| + | *varchar(6) | ||
| + | *varchar(60) | ||
| | | | ||
| − | *NULL | + | *NOTNULL |
| − | *NULL | + | *NOTNULL |
| − | *NULL | + | *NOTNULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| + | *NOTNULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| | | | ||
| − | *Company Key | + | *Company Key |
| − | * | + | *Branch key |
| − | * | + | *Order Key |
| − | *Tracking Key | + | *Product Key |
| − | * | + | *Tracking Key |
| − | * | + | *Quantity Value |
| − | * | + | *Unit of Measure Value |
| − | *User | + | *Lot Key |
| − | * | + | *Status Value |
| − | * | + | *User Key |
| − | * | + | *Date/Time Stamp Value |
| + | *Type of Transaction Value | ||
| + | *Out-Int Detail Key | ||
| + | *Warehouse Key | ||
| + | *To WHS Key | ||
| + | *Container Detail Key | ||
| + | *Whistle Receive Date/Time | ||
| + | *Item Key | ||
| + | *Pack Key | ||
| + | *Outint Control Key | ||
|} | |} | ||
| Line 2,843: | Line 3,060: | ||
|- | |- | ||
| − | === | + | ===wms_piint_tbl=== |
| + | Transaction history for production issues. | ||
| | | | ||
| − | *gl_cmp_key | + | *wms_piint_error |
| − | *in_whs_key | + | *gl_cmp_key |
| − | * | + | *sf_plant_key |
| − | + | *in_whs_key | |
| − | * | + | *in_locn_key |
| − | * | + | *pm_shop_key |
| − | * | + | *pm_shop_ordtp |
| − | + | *sf_opseq_key | |
| − | * | + | *wms_piint_bqty |
| − | * | + | *wms_piint_sqty |
| − | * | + | *wms_piint_uom |
| + | *sa_user_key | ||
| + | *wms_piint_crdt | ||
| + | *in_item_key | ||
| + | *im_pack_key | ||
| + | *wms_conthdr_key | ||
| + | *in_lot_key | ||
| + | *wms_contdtl_puldt | ||
| + | *wms_piint_control | ||
| + | *tranKey | ||
| + | *wms_contdtl_key | ||
| + | *pm_matl_key | ||
| + | *originTrack | ||
| + | *wms_line_key | ||
| | | | ||
| − | * | + | *varchar(255) |
| − | * | + | *varchar(3) |
| − | * | + | *varchar(10) |
| − | + | *varchar(4) | |
| − | + | *varchar(10) | |
| − | + | *varchar(10) | |
| − | + | *varchar(1) | |
| − | + | *int | |
| − | + | *float | |
| − | + | *float | |
| − | + | *varchar(2) | |
| − | + | *varchar(8) | |
| − | + | *datetime | |
| + | *varchar(20) | ||
| + | *varchar(6) | ||
| + | *varchar(10) | ||
| + | *varchar(25) | ||
| + | *datetime | ||
| + | *varchar(60) | ||
| + | *int | ||
| + | *int | ||
| + | *int | ||
| + | *varchar(10) | ||
| + | *varchar(3) | ||
| | | | ||
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | * | + | *NULL |
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NULL | ||
| + | *NOTNULL | ||
| | | | ||
| − | * | + | *Message Value |
| − | * | + | *Company Key |
| − | * | + | *Plant Key |
| − | * | + | *Warehouse Key |
| − | * | + | *Location Key |
| − | * | + | *Production Order Key |
| − | * | + | *Order Type Value |
| − | * | + | *Routing sequence |
| − | * | + | *Batch Quantity Value |
| − | * | + | *Scrapped Quantity Value |
| − | * | + | *Unit of Measure |
| − | * | + | *User Key |
| − | + | *Prod Issue Create Date Value | |
| − | + | *Item Key | |
| − | + | *Pack Key | |
| − | + | *Tracking Key | |
| − | + | *Lot Key | |
| − | + | *Container Pull Date/Time | |
| − | + | *Production Issue Control Key | |
| − | + | *Transaction Key | |
| − | + | *Container Detail Key | |
| − | + | *PM Material Key | |
| − | + | *Original Tracking Key | |
| − | + | *Line Key | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
| − | * | ||
|} | |} | ||
| Line 2,935: | Line 3,171: | ||
|- | |- | ||
| − | === | + | ===wms_pmint_tbl=== |
| + | Transaction history for production reports. | ||
| | | | ||
| − | *gl_cmp_key | + | *wms_pmint_error |
| − | * | + | *gl_cmp_key |
| − | *sa_user_key | + | *sf_plant_key |
| − | * | + | *in_whs_key |
| − | * | + | *pm_shop_key |
| − | * | + | *pm_shop_ordtp |
| − | * | + | *wms_pmint_bqty |
| − | * | + | *wms_pmint_sqty |
| + | *wms_pmint_uom | ||
| + | *sa_user_key | ||
| + | *wms_pmint_crdt | ||
| + | *in_item_key | ||
| + | *im_pack_key | ||
| + | *wms_conthdr_key | ||
| + | *wms_contdtl_key | ||
| + | *in_lot_key | ||
| + | *wms_pmint_control | ||
| + | *pieces | ||
| | | | ||
| + | *varchar(255) | ||
*varchar(3) | *varchar(3) | ||
| + | *varchar(10) | ||
*varchar(4) | *varchar(4) | ||
| + | *varchar(10) | ||
| + | *varchar(1) | ||
| + | *float | ||
| + | *float | ||
| + | *varchar(2) | ||
*varchar(8) | *varchar(8) | ||
| + | *datetime | ||
| + | *varchar(20) | ||
| + | *varchar(6) | ||
| + | *varchar(10) | ||
| + | *int | ||
*varchar(25) | *varchar(25) | ||
| − | + | *varchar(50) | |
| − | + | *int | |
| − | *varchar( | ||
| − | * | ||
| | | | ||
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NOTNULL | ||
| + | *NOTNULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| | | | ||
| − | *Company Key | + | *Message Value |
| − | *Warehouse Key | + | *Company Key |
| − | * | + | *Plant Key |
| − | * | + | *Warehouse Key |
| − | * | + | *Order Key |
| − | * | + | *Shop Order Type Key |
| − | * | + | *PM Batch Quantity Value |
| − | * | + | *PM Scrapped Quantity Value |
| + | *Unit of Measure Value | ||
| + | *User Key | ||
| + | *PM Transaction Date/Time | ||
| + | *Item Key | ||
| + | *Pack Key | ||
| + | *Container Header Key | ||
| + | *Container Detail Key | ||
| + | *In Lot Key | ||
| + | *PM Control Key | ||
| + | *Per Box Piece Count | ||
|} | |} | ||
| Line 2,981: | Line 3,258: | ||
|- | |- | ||
| − | === | + | ===wms_pmintdtl_tbl=== |
| + | Transaction history for production reports of catchweight / serial tracked inventory. | ||
| | | | ||
| − | *gl_cmp_key | + | *gl_cmp_key |
| − | * | + | *sf_plant_key |
| − | + | *in_whs_key | |
| − | * | + | *pm_shop_key |
| − | * | + | *wms_conthdr_key |
| − | * | + | *wms_contdtl_key |
| − | * | + | *wms_contcase_key |
| − | * | + | *in_sublot_key |
| − | * | + | *wms_contcase_ctwgt |
| − | * | + | *wms_contcase_acwgt |
| − | * | + | *wms_contcase_prddt |
| − | * | + | | |
| − | + | *varchar(2) | |
| − | | | + | *varchar(4) |
| − | *varchar(2) | + | *varchar(4) |
| − | *varchar(4) | + | *varchar(10) |
| − | *varchar( | + | *varchar(10) |
| − | *varchar( | + | *int |
| − | *varchar( | + | *varchar(60) |
| − | + | *int | |
| − | *int | + | *float |
| − | + | *float | |
| − | *varchar( | + | *datetime |
| − | * | ||
| − | *float | ||
| − | * | ||
| − | * | ||
| | | | ||
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | + | *NULL | |
| − | + | *NULL | |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | + | *NULL |
| − | *NULL | ||
| − | *NULL | ||
| | | | ||
| − | *Company | + | *Company Key |
| − | * | + | *Plant Key |
| − | * | + | *Warehouse Key |
| − | * | + | *Order Key |
| − | * | + | *Tracking Key |
| − | * | + | *Container Detail Key |
| − | * | + | *Containe Case Key |
| − | * | + | *Sub Lot Key |
| − | + | *Case Catchweight Value | |
| − | * | + | *Case Actual Weight Value |
| − | * | + | *Case Production Date/Time |
| − | * | ||
| − | |||
|} | |} | ||
| Line 3,047: | Line 3,317: | ||
|- | |- | ||
| − | === | + | ===wms_point_tbl=== |
| + | Transactional history of purchase order receipts. | ||
| | | | ||
| − | *gl_cmp_key | + | *gl_cmp_key |
| − | *so_brnch_key | + | *so_brnch_key |
| − | * | + | *in_whs_key |
| − | * | + | *wms_conthdr_key |
| − | + | *wms_contdtl_puldt | |
| − | *varchar( | + | *po_hdr_key |
| − | *varchar( | + | *in_item_key |
| + | *im_pack_key | ||
| + | *wms_point_qty | ||
| + | *wms_point_uom | ||
| + | *in_lot_key | ||
| + | *wms_point_bol | ||
| + | *wms_point_error | ||
| + | *sa_user_key | ||
| + | *wms_point_crtdt | ||
| + | *po_dtl_key | ||
| + | *in_locn_key | ||
| + | *wms_contdtl_key | ||
| + | *wms_point_control | ||
| + | | | ||
| + | *varchar(3) | ||
| + | *varchar(4) | ||
| + | *varchar(4) | ||
| + | *varchar(10) | ||
| + | *datetime | ||
| + | *varchar(10) | ||
| + | *varchar(30) | ||
| + | *varchar(6) | ||
| + | *float | ||
| + | *varchar(6) | ||
| + | *varchar(25) | ||
| + | *varchar(20) | ||
| + | *varchar(255) | ||
| + | *varchar(8) | ||
| + | *datetime | ||
| + | *smallint | ||
*varchar(10) | *varchar(10) | ||
| − | *int | + | *int |
| + | *varchar(60) | ||
| | | | ||
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | *NOTNULL | + | *NULL |
| − | *NULL | + | *NULL |
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NULL | ||
| + | *NOTNULL | ||
| + | *NULL | ||
| | | | ||
| − | *Company Key | + | *Company Key |
| − | *Branch Key | + | *Branch Key |
| − | *Tracking Key | + | *Warehouse Key |
| − | * | + | *Tracking Key |
| − | |} | + | *Pull date |
| − | + | *Order Key | |
| − | {| border="1" cellpadding="2" valign="top" halign="left" | + | *Item Key |
| − | !Column | + | *Pack Key |
| − | !Data Type | + | *Quantity Received Value |
| − | !Nullable | + | *Unit Of Measure Value |
| − | !Key Description | + | *Lot Key |
| + | *Bill of Lading Value | ||
| + | *Message Value | ||
| + | *User Key | ||
| + | *Transaction Date/Time Value | ||
| + | *Production Order Detail Key | ||
| + | *Location Key | ||
| + | *Container Detail Key | ||
| + | *Point Control | ||
| + | |} | ||
| + | |||
| + | {| border="1" cellpadding="2" valign="top" halign="left" | ||
| + | !Column | ||
| + | !Data Type | ||
| + | !Nullable | ||
| + | !Key Description | ||
|- | |- | ||
| − | === | + | ===wms_print_tbl=== |
| + | Printer definition. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
*in_whs_key | *in_whs_key | ||
| − | * | + | *wms_print_key |
| − | + | *wms_print_desc | |
| − | * | + | *wms_print_def |
| − | * | + | *pr_rotate_key |
| − | * | + | | |
| − | + | *varchar(3) | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | | | ||
| − | *varchar(3) | ||
*varchar(4) | *varchar(4) | ||
| − | *varchar( | + | *varchar(100) |
| − | *varchar( | + | *varchar(100) |
| − | * | + | *int |
| − | + | *float | |
| − | |||
| − | |||
| − | *float | ||
| − | |||
| − | |||
| − | |||
| | | | ||
| − | * | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | * | + | *NOTNULL |
| − | + | *NULL | |
| − | + | *NULL | |
| − | + | *NOTNULL | |
| − | |||
| − | |||
| − | *NULL | ||
| − | *NULL | ||
| − | *NOTNULL | ||
| − | |||
| | | | ||
| − | *Company Key | + | *Company Key |
| − | *Warehouse Key | + | *Warehouse Key |
| − | + | *Printer Name Value | |
| − | + | *Printer Description Value | |
| − | + | *Printer Definition Value | |
| − | + | *Print Rotate Value | |
| − | * | + | |} |
| − | |||
| − | * | ||
| − | * | ||
| − | |||
| − | * | ||
| − | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
| Line 3,139: | Line 3,447: | ||
|- | |- | ||
| − | === | + | ===wms_pultol_tbl=== |
| + | Number of days to consider inventory as the same age. | ||
| | | | ||
| − | *gl_cmp_key | + | *gl_cmp_key |
| − | + | *in_whs_key | |
| − | + | *in_item_key | |
| − | + | *im_pack_key | |
| − | + | *wms_pultol_tol | |
| − | |||
| − | * | ||
| − | * | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | * | ||
| − | |||
| − | |||
| − | |||
| − | * | ||
| − | |||
| − | |||
| − | |||
| | | | ||
| − | *varchar(3) | + | *varchar(3) |
| − | *varchar(4) | + | *varchar(4) |
| − | + | *varchar(30) | |
| − | *varchar(30) | + | *varchar(6) |
| − | *varchar( | + | *int |
| − | * | + | | |
| − | + | *NULL | |
| − | + | *NULL | |
| − | * | + | *NULL |
| − | * | + | *NULL |
| − | + | *NULL | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | * | ||
| − | * | ||
| − | * | ||
| | | | ||
| − | + | *Company Key | |
| − | + | *Warehouse Key | |
| − | + | *Item Key | |
| − | + | *Pack Key | |
| − | + | *Pull Date Tolerance Value | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | *Company Key | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | *Warehouse Key | ||
| − | |||
| − | |||
| − | |||
| − | *Item Key | ||
| − | *Pack Key | ||
| − | * | ||
|} | |} | ||
| Line 3,233: | Line 3,482: | ||
|- | |- | ||
| − | === | + | ===wms_recper_tbl=== |
| + | Date of last ERP reconciliation. | ||
| + | | | ||
| + | *gl_cmp_key | ||
| + | *in_whs_key | ||
| + | *wms_recbgn_key | ||
| | | | ||
| − | * | + | *varchar(3) |
| − | * | + | *varchar(4) |
| − | * | + | *datetime |
| − | + | | | |
| − | + | *NOTNULL | |
| − | + | *NOTNULL | |
| − | + | *NULL | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | * | ||
| − | * | ||
| − | * | ||
| | | | ||
| − | * | + | *Company Key |
| − | * | + | *Warehouse Key |
| − | * | + | *Last ERP Reconciliation Date |
| − | * | + | |} |
| − | * | + | |
| − | * | + | {| border="1" cellpadding="2" valign="top" halign="left" |
| − | * | + | !Column |
| − | * | + | !Data Type |
| − | * | + | !Nullable |
| − | * | + | !Key Description |
| − | *varchar(2) | + | |- |
| − | *varchar( | + | ===wms_rma_tbl=== |
| − | + | Whistle RMA information. | |
| − | *varchar( | + | | |
| − | *varchar( | + | *gl_cmp_key |
| − | *varchar( | + | *so_brnch_key |
| − | *varchar( | + | *so_rthdr_key |
| − | *datetime | + | *so_hdr_key |
| − | + | *so_resn_code | |
| − | + | *sa_user_key | |
| − | + | *wms_rma_crtdt | |
| − | + | | | |
| − | + | *varchar(2) | |
| + | *varchar(4) | ||
| + | *varchar(10) | ||
| + | *varchar(10) | ||
| + | *varchar(11) | ||
| + | *varchar(8) | ||
| + | *datetime | ||
| | | | ||
| − | + | *NOTNULL | |
| − | + | *NOTNULL | |
| − | + | *NOTNULL | |
| − | + | *NOTNULL | |
| − | + | *NOTNULL | |
| − | + | *NULL | |
| − | + | *NULL | |
| − | + | | | |
| − | + | *Company Key | |
| − | + | *Branch Key | |
| − | + | *Sales Order Return Header Key | |
| − | + | *Sales Order Header Key | |
| − | + | *Sales Order Reason Code | |
| − | + | *User Key | |
| − | + | *Created On Date/Time Value | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | *NOTNULL | ||
| − | *NOTNULL | ||
| − | *NOTNULL | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | *NOTNULL | ||
| − | *NOTNULL | ||
| − | *NULL | ||
| − | *NULL | ||
| − | | | ||
| − | |||
| − | *Company Key | ||
| − | * | ||
| − | * | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | * | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | * | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | *User Key | ||
| − | * | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| Line 3,668: | Line 3,552: | ||
===wms_screen_tbl=== | ===wms_screen_tbl=== | ||
| + | Valid screens for a warehouse. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,694: | Line 3,579: | ||
===wms_sectmpl_tbl=== | ===wms_sectmpl_tbl=== | ||
| + | Security template definition. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,728: | Line 3,614: | ||
===wms_secure_tbl=== | ===wms_secure_tbl=== | ||
| + | Users security rights. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,754: | Line 3,641: | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
| Line 3,796: | Line 3,650: | ||
===wms_track_tbl=== | ===wms_track_tbl=== | ||
| + | Register for container tracking numbers. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,822: | Line 3,677: | ||
===wms_user_tbl=== | ===wms_user_tbl=== | ||
| + | Extended user information, default printer and language. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 3,856: | 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 3,938: | Line 3,795: | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
| Line 4,000: | 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,030: | Line 3,835: | ||
===wms_wtint_tbl=== | ===wms_wtint_tbl=== | ||
| + | Transaction history for warehouse transfer receipts. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 4,124: | Line 3,930: | ||
===wms_zone_tbl=== | ===wms_zone_tbl=== | ||
| + | Maps bins to picking and putaway zones. | ||
| | | | ||
*gl_cmp_key | *gl_cmp_key | ||
| Line 4,154: | 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
- 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 |
|---|---|---|---|
|
|
|
|
