Difference between revisions of "GS:Appendix C Whistle Database Tables"
From coolearthwiki
(→wms_lhold_tbl) |
|||
(73 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 13: | Line 13: | ||
{| border="1" cellpadding="2" valign="top" halign="left"| | {| border="1" cellpadding="2" valign="top" halign="left"| | ||
| | | | ||
+ | *wmASNHistory | ||
+ | *wmAutoReceiveWhs | ||
*wmCountDetail | *wmCountDetail | ||
*wmCountMaster | *wmCountMaster | ||
Line 19: | Line 21: | ||
*wmCustomer | *wmCustomer | ||
*wmDemand | *wmDemand | ||
+ | *wmExtraInfoUserFlds | ||
*wmItemInstruct | *wmItemInstruct | ||
*wmLabelCrossRef | *wmLabelCrossRef | ||
*wmLabelElements | *wmLabelElements | ||
*wmPickAllocation | *wmPickAllocation | ||
+ | *wmPOReturnInt | ||
*wmPrintJobs | *wmPrintJobs | ||
+ | *wmReceiptReturn | ||
+ | *wmReclassHist | ||
*wmRuleContext | *wmRuleContext | ||
*wmRuleContextLine | *wmRuleContextLine | ||
*wmRuleMaster | *wmRuleMaster | ||
*wmScaleDefinition | *wmScaleDefinition | ||
+ | *wmStockMoveInt | ||
*wmTaskMaster | *wmTaskMaster | ||
*wmTestHistory | *wmTestHistory | ||
Line 39: | Line 46: | ||
*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 68: | Line 76: | ||
*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 130: | Line 139: | ||
==Whistle Tables and Definitions== | ==Whistle Tables and Definitions== | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wmASNHistory=== | ||
+ | | | ||
+ | *company | ||
+ | *warehouse | ||
+ | *atffilename | ||
+ | *billto | ||
+ | *orderkey | ||
+ | *numberofpallets | ||
+ | *grossweight | ||
+ | *bolnum | ||
+ | *carrier | ||
+ | *shipto | ||
+ | *seal | ||
+ | *trailer | ||
+ | *numchep | ||
+ | *shipdate | ||
+ | *createdate | ||
+ | *createdby | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(512) | ||
+ | *varchar(11) | ||
+ | *varchar(11) | ||
+ | *integer | ||
+ | *float | ||
+ | *varchar(26) | ||
+ | *varchar(11) | ||
+ | *varchar(11) | ||
+ | *varchar(46) | ||
+ | *varchar(26) | ||
+ | *integer | ||
+ | *datetime | ||
+ | *datetime | ||
+ | *varchar(8) | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *ATF File Name | ||
+ | *Bill To Name | ||
+ | *Order Key | ||
+ | *Number Of Pallets | ||
+ | *Gross Weight Value | ||
+ | *Bill of Lading Value | ||
+ | *Carrier Value | ||
+ | *Ship To Name | ||
+ | *Seal Value | ||
+ | *Trailer Value | ||
+ | *CHEP Value | ||
+ | *Ship Date/Time Value | ||
+ | *Created On Date/Time Value | ||
+ | *Created By Value | ||
+ | |||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 137: | Line 223: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
+ | ===wmAutoReceiveWhs=== | ||
+ | | | ||
+ | *company | ||
+ | *warehouse | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | |||
+ | |} | ||
+ | |||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | |||
===wmCountDetail=== | ===wmCountDetail=== | ||
| | | | ||
Line 459: | Line 569: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | ===wmExtraInfoUserFlds=== | ||
+ | | | ||
+ | *company | ||
+ | *branch | ||
+ | *warehouse | ||
+ | *orderkey | ||
+ | *bolkey | ||
+ | *parentWnd | ||
+ | *user1 | ||
+ | *user2 | ||
+ | *user3 | ||
+ | *user4 | ||
+ | *user5 | ||
+ | *user6 | ||
+ | *user7 | ||
+ | *user8 | ||
+ | *user9 | ||
+ | *user10 | ||
+ | *user11 | ||
+ | *user12 | ||
+ | *user13 | ||
+ | *user14 | ||
+ | *user15 | ||
+ | *user16 | ||
+ | *user17 | ||
+ | *user18 | ||
+ | *user19 | ||
+ | *user20 | ||
+ | *user21 | ||
+ | *user22 | ||
+ | *user23 | ||
+ | *user24 | ||
+ | *user25 | ||
+ | *user26 | ||
+ | *user27 | ||
+ | *user28 | ||
+ | *user29 | ||
+ | *user30 | ||
+ | *userkey | ||
+ | *createdate | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(20) | ||
+ | *int | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(50) | ||
+ | *varchar(8) | ||
+ | *datetime | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Branch Key | ||
+ | *Warehouse Key | ||
+ | *Order Key | ||
+ | *Bill of Lading Key | ||
+ | *Parent Window Type Key | ||
+ | *Entry Field 1 | ||
+ | *Entry Field 2 | ||
+ | *Entry Field 3 | ||
+ | *Entry Field 4 | ||
+ | *Entry Field 5 | ||
+ | *Entry Field 6 | ||
+ | *Entry Field 7 | ||
+ | *Entry Field 8 | ||
+ | *Entry Field 9 | ||
+ | *Entry Field 10 | ||
+ | *Entry Field 11 | ||
+ | *Entry Field 12 | ||
+ | *Entry Field 13 | ||
+ | *Entry Field 14 | ||
+ | *Entry Field 15 | ||
+ | *Entry Field 16 | ||
+ | *Entry Field 17 | ||
+ | *Entry Field 18 | ||
+ | *Entry Field 19 | ||
+ | *Entry Field 20 | ||
+ | *Entry Field 21 | ||
+ | *Entry Field 22 | ||
+ | *Entry Field 23 | ||
+ | *Entry Field 24 | ||
+ | *Entry Field 25 | ||
+ | *Entry Field 26 | ||
+ | *Entry Field 27 | ||
+ | *Entry Field 28 | ||
+ | *Entry Field 29 | ||
+ | *Entry Field 30 | ||
+ | *User Key | ||
+ | *Created On Date/Time Value | ||
+ | |} | ||
+ | |||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | |||
===wmItemInstruct=== | ===wmItemInstruct=== | ||
| | | | ||
Line 671: | Line 947: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | ===wmPOReturnInt=== | ||
+ | | | ||
+ | *returnLineId | ||
+ | *company | ||
+ | *branch | ||
+ | *warehouse | ||
+ | *po | ||
+ | *poDtl | ||
+ | *receipt | ||
+ | *contHdr | ||
+ | *contDtl | ||
+ | *item | ||
+ | *pack | ||
+ | *lot | ||
+ | *location | ||
+ | *returnedQty | ||
+ | *returnedUom | ||
+ | *returnedTime | ||
+ | *userKey | ||
+ | *poReturnControl | ||
+ | | | ||
+ | *int | ||
+ | *varchar(3) | ||
+ | *varchar(5) | ||
+ | *varchar(5) | ||
+ | *varchar(10) | ||
+ | *int | ||
+ | *varchar(10) | ||
+ | *varchar(20) | ||
+ | *int | ||
+ | *varchar(30) | ||
+ | *varchar(10) | ||
+ | *varchar(25) | ||
+ | *varchar(10) | ||
+ | *decimal | ||
+ | *varchar(6) | ||
+ | *datetime | ||
+ | *varchar(8) | ||
+ | *varchar(60) | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Return Line Key | ||
+ | *Company Key | ||
+ | *Branch Key | ||
+ | *Warehouse Key | ||
+ | *Purchase Order Key | ||
+ | *Purchase Order Detail Key | ||
+ | *Receipt Key | ||
+ | *Container Header Key | ||
+ | *Container Detail Key | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | *Lot Key | ||
+ | *Location Key | ||
+ | *Quantity Returned | ||
+ | *Quantity Returned Unit of Measure | ||
+ | *Returned Date/Time Value | ||
+ | *User Key | ||
+ | *Control Number | ||
+ | |} | ||
+ | |||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | |||
===wmPrintJobs=== | ===wmPrintJobs=== | ||
| | | | ||
Line 724: | Line 1,086: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | ===wmReceiptReturn=== | ||
+ | | | ||
+ | *company | ||
+ | *branch | ||
+ | *warehouse | ||
+ | *purchaseOrder | ||
+ | *receiptCntrl | ||
+ | *rma | ||
+ | *item | ||
+ | *pack | ||
+ | *qty | ||
+ | *track | ||
+ | *reason | ||
+ | *comment | ||
+ | *userKey | ||
+ | *createdate | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(20) | ||
+ | *varchar(20) | ||
+ | *varchar(20) | ||
+ | *varchar(6) | ||
+ | *decimal | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *varchar(255) | ||
+ | *varchar(8) | ||
+ | *datetime | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Branch Key | ||
+ | *Warehouse Key | ||
+ | *Purchase Order Key | ||
+ | *Control Number | ||
+ | *Return Merchandise Authorization Key | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | *Quantity | ||
+ | *Container Header Key | ||
+ | *Reason Code | ||
+ | *Comment | ||
+ | *User Key | ||
+ | *Created On Date/Time Value | ||
+ | |} | ||
+ | |||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wmReclassHist=== | ||
+ | | | ||
+ | *company | ||
+ | *warehouse | ||
+ | *container | ||
+ | *containerdetail | ||
+ | *olditem | ||
+ | *oldpack | ||
+ | *oldproduct | ||
+ | *oldqty | ||
+ | *olduom | ||
+ | *oldcontainertype | ||
+ | *oldlot | ||
+ | *newitem | ||
+ | *newpack | ||
+ | *newproduct | ||
+ | *newqty | ||
+ | *newuom | ||
+ | *newcontainertype | ||
+ | *newlot | ||
+ | *createdate | ||
+ | *username | ||
+ | *debitAtfControl | ||
+ | *creditAtfControl | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *int | ||
+ | *varchar(20) | ||
+ | *varchar(10) | ||
+ | *varchar(20) | ||
+ | *float | ||
+ | *varchar(5) | ||
+ | *varchar(10) | ||
+ | *varchar(25) | ||
+ | *varchar(20) | ||
+ | *varchar(10) | ||
+ | *varchar(20) | ||
+ | *float | ||
+ | *varchar(5) | ||
+ | *varchar(10) | ||
+ | *varchar(25) | ||
+ | *datetime | ||
+ | *varchar(8) | ||
+ | *varchar(60) | ||
+ | *varchar(60) | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Container Header Key | ||
+ | *Container Detail Key | ||
+ | *Original Item Key | ||
+ | *Original Pack Key | ||
+ | *Original Product Key | ||
+ | *Original Quantity Value | ||
+ | *Original Unit of Measure | ||
+ | *Original Container Type | ||
+ | *Original Lot Key | ||
+ | *New Item Key | ||
+ | *New Pack Key | ||
+ | *New Product Key | ||
+ | *New Quantity Value | ||
+ | *New Unit of Measure | ||
+ | *New Container Type | ||
+ | *New Lot Key | ||
+ | *Created On Date/Time Value | ||
+ | *User Key | ||
+ | *Debit ATF Control Number | ||
+ | *Credit ATF Control Number | ||
+ | |} | ||
+ | |||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | |||
===wmRuleContext=== | ===wmRuleContext=== | ||
| | | | ||
Line 917: | Line 1,450: | ||
*Scale Address Value | *Scale Address Value | ||
|} | |} | ||
− | + | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | |||
+ | ===wmStockMoveInt=== | ||
+ | | | ||
+ | *company | ||
+ | *warehouse | ||
+ | *wms_conthdr_key | ||
+ | *tolocation | ||
+ | *fromlocation | ||
+ | *sa_user_key | ||
+ | *createdate | ||
+ | *item | ||
+ | *pack | ||
+ | *quantity | ||
+ | *uom | ||
+ | *wms_eia_cntrl | ||
+ | *reason | ||
+ | *trans_date | ||
+ | *lot | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *varchar(8) | ||
+ | *datetime | ||
+ | *varchar(20) | ||
+ | *varchar(10) | ||
+ | *float | ||
+ | *varchar(6) | ||
+ | *varchar(60) | ||
+ | *varchar(14) | ||
+ | *datetime | ||
+ | *varchar(25) | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Container Header Key | ||
+ | *Destination Location | ||
+ | *Source Location | ||
+ | *User Key | ||
+ | *Created On Date/Time Value | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | *Quantity | ||
+ | *Unit of Measure | ||
+ | *Control Number | ||
+ | *Reason Code | ||
+ | *Transaction Date/Time Value | ||
+ | *Lot Key | ||
+ | |} | ||
+ | |||
+ | |||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
!Column | !Column | ||
Line 1,332: | Line 1,940: | ||
*wms_bin_col | *wms_bin_col | ||
*wms_bin_cychd | *wms_bin_cychd | ||
− | *wms_bin_hold | + | *wms_bin_hold |
− | * | + | *can_mix_items |
+ | *not_on_picklist | ||
+ | *dont_trackvol | ||
| | | | ||
*varchar(3) | *varchar(3) | ||
Line 1,346: | Line 1,956: | ||
*int | *int | ||
*int | *int | ||
− | *int | + | *int |
− | *int | + | *int |
+ | *int | ||
+ | *int | ||
| | | | ||
*NOTNULL | *NOTNULL | ||
Line 1,361: | Line 1,973: | ||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
+ | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
+ | *NOTNULL | ||
| | | | ||
*Company Key | *Company Key | ||
Line 1,375: | Line 1,989: | ||
*Bin Cycle Lock Value | *Bin Cycle Lock Value | ||
*Bin On Hold Value | *Bin On Hold Value | ||
− | *Bin | + | *Bin will accept a mix of items |
+ | *Don't show bin contents in picklist | ||
+ | *Don't calculate bin volume | ||
|} | |} | ||
Line 1,465: | Line 2,081: | ||
*wms_count_qty | *wms_count_qty | ||
*wms_count_var | *wms_count_var | ||
− | * | + | *lastCount |
− | * | + | *not_on_picklist |
+ | *dont_trackvol | ||
| | | | ||
*varchar(3) | *varchar(3) | ||
Line 1,483: | Line 2,100: | ||
*varchar(25) | *varchar(25) | ||
*datetime | *datetime | ||
− | *varchar( | + | *varchar(20) |
*varchar(10) | *varchar(10) | ||
*datetime | *datetime | ||
Line 1,492: | Line 2,109: | ||
*float | *float | ||
*float | *float | ||
− | *int | + | *datetime |
− | * | + | *int |
+ | *int | ||
| | | | ||
*NOTNULL | *NOTNULL | ||
Line 1,519: | Line 2,137: | ||
*NULL | *NULL | ||
*NULL | *NULL | ||
− | *NOTNULL | + | *NOTNULL |
+ | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
| | | | ||
Line 1,546: | Line 2,165: | ||
*Cycle Count Quantity Value | *Cycle Count Quantity Value | ||
*Cycle Count Variance Value | *Cycle Count Variance Value | ||
− | |||
*Counted On Date/Time Value | *Counted On Date/Time Value | ||
+ | *Don't show bin contents in picklist | ||
+ | *Dont' calculate bin volume | ||
|} | |} | ||
Line 1,594: | Line 2,214: | ||
*User Key | *User Key | ||
*Lock Counter Value | *Lock Counter Value | ||
+ | |} | ||
+ | |||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | |||
+ | ===wms_comments_tbl=== | ||
+ | | | ||
+ | *company | ||
+ | *warehouse | ||
+ | *comments | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(60) | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Comment Text | ||
+ | |||
|} | |} | ||
Line 1,685: | Line 2,332: | ||
*lock_count | *lock_count | ||
*wms_contcase_stat | *wms_contcase_stat | ||
− | *wms_contcase_acwgt | + | *wms_contcase_acwgt |
+ | *lot | ||
+ | *allocation | ||
+ | *pieces | ||
+ | *lineKey | ||
| | | | ||
*varchar(2) | *varchar(2) | ||
Line 1,701: | Line 2,352: | ||
*int | *int | ||
*int | *int | ||
− | *float | + | *float |
+ | *varchar(25) | ||
+ | *varchar(25) | ||
+ | *int | ||
+ | *int | ||
| | | | ||
*NOTNULL | *NOTNULL | ||
Line 1,718: | Line 2,373: | ||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
| | | | ||
*Company Key | *Company Key | ||
Line 1,734: | Line 2,393: | ||
*Container Status Value | *Container Status Value | ||
*Container Actual Weight Value | *Container Actual Weight Value | ||
+ | *Lot Key | ||
+ | *Case Allocated Value | ||
+ | *Per box Piece Count | ||
+ | *Line Number | ||
|} | |} | ||
Line 1,792: | Line 2,455: | ||
*varchar(6) | *varchar(6) | ||
*varchar(25) | *varchar(25) | ||
− | *varchar( | + | *varchar(20) |
*float | *float | ||
*int | *int | ||
Line 1,962: | Line 2,625: | ||
*wms_group_key | *wms_group_key | ||
*wms_conthdr_vol | *wms_conthdr_vol | ||
− | |||
*lockCounter | *lockCounter | ||
| | | | ||
Line 1,978: | Line 2,640: | ||
*int | *int | ||
*float | *float | ||
− | |||
*int | *int | ||
| | | | ||
Line 1,994: | Line 2,655: | ||
*NULL | *NULL | ||
*NULL | *NULL | ||
− | |||
*NULL | *NULL | ||
| | | | ||
Line 2,010: | Line 2,670: | ||
*Group Key | *Group Key | ||
*Container Volume Value | *Container Volume Value | ||
− | |||
*Lock Counter Value | *Lock Counter Value | ||
|} | |} | ||
Line 2,128: | Line 2,787: | ||
*wms_active_qty | *wms_active_qty | ||
*wms_hold_qty | *wms_hold_qty | ||
− | |||
*toleranceOver | *toleranceOver | ||
*wms_contxf_pseq | *wms_contxf_pseq | ||
Line 2,141: | Line 2,799: | ||
*float | *float | ||
*float | *float | ||
− | |||
*float | *float | ||
*int | *int | ||
Line 2,154: | Line 2,811: | ||
*NULL | *NULL | ||
*NULL | *NULL | ||
− | |||
*NOTNULL | *NOTNULL | ||
*NOTNULL | *NOTNULL | ||
Line 2,167: | Line 2,823: | ||
*Container Active Quantity | *Container Active Quantity | ||
*Container Hold Quantity | *Container Hold Quantity | ||
− | |||
*Tolerance Over Value | *Tolerance Over Value | ||
*Container Cross Reference Seq Key | *Container Cross Reference Seq Key | ||
Line 2,594: | Line 3,249: | ||
===wms_load_tbl=== | ===wms_load_tbl=== | ||
− | *gl_cmp_key | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *so_brnch_key |
− | * | + | *so_hdr_key |
− | * | + | *wms_load_bol |
− | * | + | *wms_load_trailer |
− | * | + | *wms_load_seal |
− | * | + | *wms_load_chep |
− | * | + | *wms_load_shpdt |
− | * | + | *in_towhs_key |
− | * | + | *carrier |
− | * | + | *prePaidFreight |
− | * | + | *status |
+ | *loadKey | ||
+ | *temp_recorder | ||
+ | *trl_temp_start | ||
+ | *set_trl_at | ||
+ | *set_trl_for_hrs | ||
+ | *trl_temp_for_trip | ||
+ | *pallets_in | ||
+ | *po_num | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(25) | ||
+ | *varchar(25) | ||
+ | *varchar(45) | ||
+ | *int | ||
+ | *datetime | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *float | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *varchar(25) | ||
+ | *varchar(5) | ||
+ | *varchar(5) | ||
+ | *varchar(5) | ||
+ | *varchar(5) | ||
+ | *varchar(5) | ||
+ | *varchar(25) | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company key | ||
+ | *Branch Key | ||
+ | *Tracking Key | ||
+ | *Load BOL Value | ||
+ | *Load Trailer Value | ||
+ | *Load Seal Value | ||
+ | *Load Chep Value | ||
+ | *Load Ship Date/Time Value | ||
+ | *To WHS Key | ||
+ | *Carrier Value | ||
+ | *Pre Paid Freight Value | ||
+ | *Status Value | ||
+ | *Load Key | ||
+ | *Thermometer ID Number | ||
+ | *Temp of Trailer at Start Of Loading Process | ||
+ | *Temp to Set Trailer At | ||
+ | *Number of Hours to Set Temp For | ||
+ | *Temp Trailer Should Maintain For Rest of Trip After set_trl_for_hrs Hours | ||
+ | *Number of Empty Pallets on Truck/Trailer When It Arrives | ||
+ | *PO Number | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,614: | Line 3,341: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_loadnm_tbl=== | ===wms_loadnm_tbl=== | ||
− | *gl_cmp_key | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *so_brnch_key |
− | * | + | *so_hdr_key |
+ | *wms_loadnm_key | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Branch Key | ||
+ | *Tracking Key | ||
+ | *Load Name Key | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,626: | Line 3,371: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_lothist_tbl=== | ===wms_lothist_tbl=== | ||
− | *gl_cmp_key | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *in_whs_key |
− | * | + | *wms_conthdr_key |
− | * | + | *wms_tran_type |
− | * | + | *wms_tran_key |
− | * | + | *in_lot_key |
− | * | + | *sa_user_key |
− | * | + | *wms_lothist_crtdt |
− | * | + | *wms_lothist_qty |
− | * | + | *wms_lothist_uom |
− | * | + | *wms_contdtl_key |
− | * | + | *comment_key |
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(15) | ||
+ | *varchar(20) | ||
+ | *varchar(25) | ||
+ | *varchar(8) | ||
+ | *datetime | ||
+ | *float | ||
+ | *varchar(2) | ||
+ | *int | ||
+ | *varchar(255) | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Tracking Key | ||
+ | *Transaction Type Key | ||
+ | *Transaction Key | ||
+ | *Lot Key | ||
+ | *User Key | ||
+ | *Date of transaction Value | ||
+ | *Lot History Quantity Value | ||
+ | *Unit Of Measure Value | ||
+ | *Container detail Key | ||
+ | *Comment Value | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,647: | Line 3,433: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_outint_tbl=== | ===wms_outint_tbl=== | ||
− | *gl_cmp_key varchar(3) | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *so_brnch_key |
− | * | + | *so_hdr_key |
− | * | + | *so_prod_key |
− | * | + | *wms_conthdr_key |
− | * | + | *wms_outint_qty |
− | * | + | *wms_outint_uom |
− | * | + | *in_lot_key |
− | * | + | *wms_outint_error |
− | * | + | *sa_user_key |
− | * | + | *wms_outint_crtdt |
− | * | + | *wms_outint_type |
− | * | + | *wms_outdtl_key |
− | * | + | *in_whs_key |
− | * | + | *in_towhs_key |
− | * | + | *wms_contdtl_key |
− | * | + | *wms_whistle_recdt |
− | * | + | *in_item_key |
− | * | + | *im_pack_key |
− | + | *wms_outint_control | |
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(30) | ||
+ | *varchar(10) | ||
+ | *float | ||
+ | *varchar(2) | ||
+ | *varchar(25) | ||
+ | *varchar(255) | ||
+ | *varchar(8) | ||
+ | *datetime | ||
+ | *int | ||
+ | *int | ||
+ | *varchar(4) | ||
+ | *varchar(4) | ||
+ | *smallint | ||
+ | *datetime | ||
+ | *varchar(20) | ||
+ | *varchar(6) | ||
+ | *varchar(60) | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Branch key | ||
+ | *Order Key | ||
+ | *Product Key | ||
+ | *Tracking Key | ||
+ | *Quantity Value | ||
+ | *Unit of Measure Value | ||
+ | *Lot Key | ||
+ | *Status Value | ||
+ | *User Key | ||
+ | *Date/Time Stamp Value | ||
+ | *Type of Transaction Value | ||
+ | *Out-Int Detail Key | ||
+ | *Warehouse Key | ||
+ | *To WHS Key | ||
+ | *Container Detail Key | ||
+ | *Whistle Receive Date/Time | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | *Outint Control Key | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,676: | Line 3,527: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_piint_tbl=== | ===wms_piint_tbl=== | ||
− | *wms_piint_error varchar(255) | + | | |
− | * | + | *wms_piint_error |
− | * | + | *gl_cmp_key |
− | * | + | *sf_plant_key |
− | * | + | *in_whs_key |
− | * | + | *in_locn_key |
− | * | + | *pm_shop_key |
− | * | + | *pm_shop_ordtp |
− | * | + | *sf_opseq_key |
− | * | + | *wms_piint_bqty |
− | * | + | *wms_piint_sqty |
− | * | + | *wms_piint_uom |
− | * | + | *sa_user_key |
− | * | + | *wms_piint_crdt |
− | * | + | *in_item_key |
− | * | + | *im_pack_key |
− | * | + | *wms_conthdr_key |
− | * | + | *in_lot_key |
− | * | + | *wms_contdtl_puldt |
− | * | + | *wms_piint_control |
− | * | + | *tranKey |
− | * | + | *wms_contdtl_key |
− | * | + | *pm_matl_key |
− | * | + | *originTrack |
+ | *wms_line_key | ||
+ | | | ||
+ | *varchar(255) | ||
+ | *varchar(3) | ||
+ | *varchar(10) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *varchar(1) | ||
+ | *int | ||
+ | *float | ||
+ | *float | ||
+ | *varchar(2) | ||
+ | *varchar(8) | ||
+ | *datetime | ||
+ | *varchar(20) | ||
+ | *varchar(6) | ||
+ | *varchar(10) | ||
+ | *varchar(25) | ||
+ | *datetime | ||
+ | *varchar(60) | ||
+ | *int | ||
+ | *int | ||
+ | *int | ||
+ | *varchar(10) | ||
+ | *varchar(3) | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Message Value | ||
+ | *Company Key | ||
+ | *Plant Key | ||
+ | *Warehouse Key | ||
+ | *Location Key | ||
+ | *Production Order Key | ||
+ | *Order Type Value | ||
+ | *Routing sequence | ||
+ | *Batch Quantity Value | ||
+ | *Scrapped Quantity Value | ||
+ | *Unit of Measure | ||
+ | *User Key | ||
+ | *Prod Issue Create Date Value | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | *Tracking Key | ||
+ | *Lot Key | ||
+ | *Container Pull Date/Time | ||
+ | *Production Issue Control Key | ||
+ | *Transaction Key | ||
+ | *Container Detail Key | ||
+ | *PM Material Key | ||
+ | *Original Tracking Key | ||
+ | *Line Key | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,708: | Line 3,637: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_pmint_tbl=== | ===wms_pmint_tbl=== | ||
− | *wms_pmint_error varchar(255) | + | | |
− | * | + | *wms_pmint_error |
− | * | + | *gl_cmp_key |
− | * | + | *sf_plant_key |
− | * | + | *in_whs_key |
− | * | + | *pm_shop_key |
− | * | + | *pm_shop_ordtp |
− | * | + | *wms_pmint_bqty |
− | * | + | *wms_pmint_sqty |
− | * | + | *wms_pmint_uom |
− | * | + | *sa_user_key |
− | * | + | *wms_pmint_crdt |
− | * | + | *in_item_key |
− | * | + | *im_pack_key |
− | * | + | *wms_conthdr_key |
− | * | + | *wms_contdtl_key |
− | * | + | *in_lot_key |
− | * | + | *wms_pmint_control |
+ | *pieces | ||
+ | | | ||
+ | *varchar(255) | ||
+ | *varchar(3) | ||
+ | *varchar(10) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(1) | ||
+ | *float | ||
+ | *float | ||
+ | *varchar(2) | ||
+ | *varchar(8) | ||
+ | *datetime | ||
+ | *varchar(20) | ||
+ | *varchar(6) | ||
+ | *varchar(10) | ||
+ | *int | ||
+ | *varchar(25) | ||
+ | *varchar(50) | ||
+ | *int | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Message Value | ||
+ | *Company Key | ||
+ | *Plant Key | ||
+ | *Warehouse Key | ||
+ | *Order Key | ||
+ | *Shop Order Type Key | ||
+ | *PM Batch Quantity Value | ||
+ | *PM Scrapped Quantity Value | ||
+ | *Unit of Measure Value | ||
+ | *User Key | ||
+ | *PM Transaction Date/Time | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | *Container Header Key | ||
+ | *Container Detail Key | ||
+ | *In Lot Key | ||
+ | *PM Control Key | ||
+ | *Per Box Piece Count | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,734: | Line 3,723: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_pmintdtl_tbl=== | ===wms_pmintdtl_tbl=== | ||
− | *gl_cmp_key varchar(2) | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *sf_plant_key |
− | * | + | *in_whs_key |
− | * | + | *pm_shop_key |
− | * | + | *wms_conthdr_key |
− | * | + | *wms_contdtl_key |
− | * | + | *wms_contcase_key |
− | * | + | *in_sublot_key |
− | * | + | *wms_contcase_ctwgt |
− | * | + | *wms_contcase_acwgt |
+ | *wms_contcase_prddt | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *int | ||
+ | *varchar(60) | ||
+ | *int | ||
+ | *float | ||
+ | *float | ||
+ | *datetime | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Plant Key | ||
+ | *Warehouse Key | ||
+ | *Order Key | ||
+ | *Tracking Key | ||
+ | *Container Detail Key | ||
+ | *Containe Case Key | ||
+ | *Sub Lot Key | ||
+ | *Case Catchweight Value | ||
+ | *Case Actual Weight Value | ||
+ | *Case Production Date/Time | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,753: | Line 3,781: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_point_tbl=== | ===wms_point_tbl=== | ||
− | *gl_cmp_key varchar(3) | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *so_brnch_key |
− | * | + | *in_whs_key |
− | * | + | *wms_conthdr_key |
− | * | + | *wms_contdtl_puldt |
− | * | + | *po_hdr_key |
− | * | + | *in_item_key |
− | * | + | *im_pack_key |
− | * | + | *wms_point_qty |
− | * | + | *wms_point_uom |
− | * | + | *in_lot_key |
− | * | + | *wms_point_bol |
− | * | + | *wms_point_error |
− | * | + | *sa_user_key |
− | * | + | *wms_point_crtdt |
− | * | + | *po_dtl_key |
− | * | + | *in_locn_key |
− | * | + | *wms_contdtl_key |
− | + | *wms_point_control | |
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *datetime | ||
+ | *varchar(10) | ||
+ | *varchar(30) | ||
+ | *varchar(6) | ||
+ | *float | ||
+ | *varchar(6) | ||
+ | *varchar(25) | ||
+ | *varchar(20) | ||
+ | *varchar(255) | ||
+ | *varchar(8) | ||
+ | *datetime | ||
+ | *smallint | ||
+ | *varchar(10) | ||
+ | *int | ||
+ | *varchar(60) | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Branch Key | ||
+ | *Warehouse Key | ||
+ | *Tracking Key | ||
+ | *Pull date | ||
+ | *Order Key | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | *Quantity Received Value | ||
+ | *Unit Of Measure Value | ||
+ | *Lot Key | ||
+ | *Bill of Lading Value | ||
+ | *Message Value | ||
+ | *User Key | ||
+ | *Transaction Date/Time Value | ||
+ | *Production Order Detail Key | ||
+ | *Location Key | ||
+ | *Container Detail Key | ||
+ | *Point Control | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,781: | Line 3,871: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_print_tbl=== | ===wms_print_tbl=== | ||
− | *gl_cmp_key varchar(3) | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *in_whs_key |
− | * | + | *wms_print_key |
− | * | + | *wms_print_desc |
− | * | + | *wms_print_def |
− | + | *pr_rotate_key | |
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(100) | ||
+ | *varchar(100) | ||
+ | *int | ||
+ | *float | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Printer Name Value | ||
+ | *Printer Description Value | ||
+ | *Printer Definition Value | ||
+ | *Print Rotate Value | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,796: | Line 3,909: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_pultol_tbl=== | ===wms_pultol_tbl=== | ||
− | *gl_cmp_key | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *in_whs_key |
− | * | + | *in_item_key |
− | * | + | *im_pack_key |
+ | *wms_pultol_tol | ||
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(30) | ||
+ | *varchar(6) | ||
+ | *int | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | *Pull Date Tolerance Value | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,809: | Line 3,943: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_recper_tbl=== | ===wms_recper_tbl=== | ||
− | *gl_cmp_key | + | | |
− | * | + | *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" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,820: | Line 3,969: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | ===wms_rma_tbl=== | ||
+ | | | ||
+ | *gl_cmp_key | ||
+ | *so_brnch_key | ||
+ | *so_rthdr_key | ||
+ | *so_hdr_key | ||
+ | *so_resn_code | ||
+ | *sa_user_key | ||
+ | *wms_rma_crtdt | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *varchar(11) | ||
+ | *varchar(8) | ||
+ | *datetime | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Branch Key | ||
+ | *Sales Order Return Header Key | ||
+ | *Sales Order Header Key | ||
+ | *Sales Order Reason Code | ||
+ | *User Key | ||
+ | *Created On Date/Time Value | ||
+ | |} | ||
+ | |||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | |||
===wms_screen_tbl=== | ===wms_screen_tbl=== | ||
− | *gl_cmp_key | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *in_whs_key |
+ | *wms_screen_key | ||
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(20) | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Screen Name Value | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,831: | Line 4,036: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_sectmpl_tbl=== | ===wms_sectmpl_tbl=== | ||
− | *gl_cmp_key | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *in_whs_key |
− | * | + | *wms_sectmpl_key |
− | * | + | *wms_screen_key |
+ | *wms_secure_mode | ||
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(20) | ||
+ | *varchar(20) | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Security Template Name Key | ||
+ | *Screen Name Key | ||
+ | *Security Mode Value | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,844: | Line 4,070: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_secure_tbl=== | ===wms_secure_tbl=== | ||
− | *gl_cmp_key | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *in_whs_key |
− | * | + | *sa_user_key |
− | * | + | *wms_screen_key |
+ | *wms_secure_mode | ||
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(8) | ||
+ | *varchar(20) | ||
+ | *int | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *User Key | ||
+ | *Screen Name Key | ||
+ | *Security Mode Value | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,857: | Line 4,104: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_shipins_tbl Table no longer=== | ===wms_shipins_tbl Table no longer=== | ||
− | *gl_cmp_key | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *in_whs_key |
− | * | + | *ar_ship_key |
− | * | + | *so_prod_key |
+ | *in_instr_key | ||
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(20) | ||
+ | *text | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *AR Ship Key | ||
+ | *So Product Key | ||
+ | *IN Instruction Key | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,870: | Line 4,138: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_track_tbl=== | ===wms_track_tbl=== | ||
− | *gl_cmp_key | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *in_whs_key |
+ | *wms_track_key | ||
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *int | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Tracking Number Key | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,881: | Line 4,164: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_user_tbl=== | ===wms_user_tbl=== | ||
− | *gl_cmp_key | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *in_whs_key |
− | * | + | *sa_user_key |
− | * | + | *wms_print_key |
− | * | + | *wms_user_lang |
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(8) | ||
+ | *varchar(100) | ||
+ | *varchar(20) | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *User Key | ||
+ | *Default Printer Value | ||
+ | *User Language Key | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,895: | Line 4,198: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_usercols_tbl=== | ===wms_usercols_tbl=== | ||
− | *gl_cmp_key varchar(2) | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *in_whs_key |
− | * | + | *wms_table_key |
− | * | + | *wms_col_key |
− | * | + | *wms_col_name |
− | * | + | *wms_col_shortname |
− | * | + | *wms_col_type |
− | * | + | *wms_col_default |
− | * | + | *wms_col_min |
− | * | + | *wms_col_max |
− | * | + | *wms_col_req |
− | * | + | *wms_item_type |
− | * | + | *wms_valid_sql |
− | * | + | *wms_ui_type |
− | * | + | *created_on |
− | * | + | *changed_on |
− | * | + | *created_by |
− | * | + | *changed_by |
+ | *lock_count | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(20) | ||
+ | *varchar(20) | ||
+ | *varchar(20) | ||
+ | *varchar(5) | ||
+ | *varchar(10) | ||
+ | *varchar(26) | ||
+ | *varchar(26) | ||
+ | *varchar(26) | ||
+ | *smallint | ||
+ | *varchar(20) | ||
+ | *text | ||
+ | *smallint | ||
+ | *datetime | ||
+ | *datetime | ||
+ | *varchar(8) | ||
+ | *varchar(8) | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Table Key | ||
+ | *New Column Database Key | ||
+ | *Column Common Name | ||
+ | *Short Name Value | ||
+ | *Column Type Value | ||
+ | *Column Default Value | ||
+ | *Column Minimum Tolerance Value | ||
+ | *Column Maximum Tolerance Value | ||
+ | *Column Required Value | ||
+ | *Item Type Key | ||
+ | *SQL Text Value | ||
+ | *UI Parameter Type Key | ||
+ | *Created On Date/Time | ||
+ | *Changed On Date/Time | ||
+ | *User Key | ||
+ | *User Key | ||
+ | *Lock Counter | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,922: | Line 4,288: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_utcount_tbl=== | ===wms_utcount_tbl=== | ||
− | *gl_cmp_key | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *in_whs_key |
− | * | + | *in_cycnt_key |
− | * | + | *in_item_key |
− | * | + | *im_pack_key |
− | * | + | *in_locn_key |
− | * | + | *en_lot_key |
− | * | + | *sa_user_key |
− | * | + | *wms_utcycnt_crdt |
+ | *wms_utcycnt_qty | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *int | ||
+ | *varchar(20) | ||
+ | *varchar(7) | ||
+ | *varchar(10) | ||
+ | *varchar(25) | ||
+ | *varchar(8) | ||
+ | *datetime | ||
+ | *float | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Cycle Count Key | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | *Location Key | ||
+ | *Lot Key | ||
+ | *User Key | ||
+ | *Date/Time Stamp Value | ||
+ | *Reported Quantity Value | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,940: | Line 4,342: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_vndpull_tbl=== | ===wms_vndpull_tbl=== | ||
− | *gl_cmp_key varchar(3) | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *in_whs_key |
− | * | + | *en_vend_key |
+ | *wms_vndpull_puldt | ||
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Vendor Key | ||
+ | *Vendor Pull Date Value | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,952: | Line 4,372: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_wtint_tbl=== | ===wms_wtint_tbl=== | ||
− | *gl_cmp_key varchar(3) | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *so_brnch_key |
− | * | + | *wms_conthdr_key |
− | * | + | *wms_contdtl_puldt |
− | * | + | *wt_hdr_key |
− | * | + | *in_item_key |
− | * | + | *im_pack_key |
− | * | + | *wms_wtint_qty |
− | * | + | *wms_wtint_uom |
− | * | + | *in_lot_key |
− | * | + | *wms_wtint_bol |
− | * | + | *wms_wtint_error |
− | * | + | *sa_user_key |
− | * | + | *wms_wtint_crtdt |
− | * | + | *wms_wtint_frwhs |
− | * | + | *wt_dtl_key |
− | * | + | *in_whs_key |
− | * | + | *in_locn_key |
− | * | + | *wms_contdtl_key |
− | + | *wms_wtint_control | |
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *datetime | ||
+ | *varchar(10) | ||
+ | *varchar(30) | ||
+ | *varchar(6) | ||
+ | *float | ||
+ | *varchar(6) | ||
+ | *varchar(25) | ||
+ | *varchar(20) | ||
+ | *varchar(255) | ||
+ | *varchar(8) | ||
+ | *datetime | ||
+ | *varchar(4) | ||
+ | *smallint | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *int | ||
+ | *varchar(60) | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Branch Key | ||
+ | *Tracking Key | ||
+ | *Item Pull Date | ||
+ | *Warehouse Transfer Header Key | ||
+ | *Item Key | ||
+ | *Packing Key | ||
+ | *WT Quantity Value | ||
+ | *Unit Of Measur Value | ||
+ | *Lot Key | ||
+ | *WT Bill of Lading Value | ||
+ | *WT Error Message Value | ||
+ | *User Key | ||
+ | *WT Creation Date/Time | ||
+ | *WT From Warehouse Key | ||
+ | *WT Detail Key | ||
+ | *Warehouse Key | ||
+ | *In Location Key | ||
+ | *Container Detail Key | ||
+ | *ERP Control Key | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,981: | Line 4,466: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_zone_tbl=== | ===wms_zone_tbl=== | ||
− | *gl_cmp_key | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *in_whs_key |
− | * | + | *wms_zone_key |
+ | *wms_bin_key | ||
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(15) | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Zone Key | ||
+ | *Bin Key | ||
+ | |} | ||
{| border="1" cellpadding="2" valign="top" halign="left" | {| border="1" cellpadding="2" valign="top" halign="left" | ||
Line 2,993: | Line 4,496: | ||
!Key Description | !Key Description | ||
|- | |- | ||
+ | |||
===wms_zonexf_tbl=== | ===wms_zonexf_tbl=== | ||
− | *gl_cmp_key varchar(3) | + | | |
− | * | + | *gl_cmp_key |
− | * | + | *in_whs_key |
− | * | + | *wms_zone_key |
− | * | + | *in_item_key |
− | * | + | *im_pack_key |
− | * | + | *wms_zone_pri |
+ | *actionType | ||
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(30) | ||
+ | *varchar(6) | ||
+ | *int | ||
+ | *smallint | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Zone Key | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | *Zone Priority Value | ||
+ | *Action Type Value | ||
+ | |} |
Latest revision as of 23:02, 3 February 2007
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 wmPickAllocation
- 1.1.14 wmPOReturnInt
- 1.1.15 wmPrintJobs
- 1.1.16 wmReceiptReturn
- 1.1.17 wmReclassHist
- 1.1.18 wmRuleContext
- 1.1.19 wmRuleContextLine
- 1.1.20 wmRuleMaster
- 1.1.21 wmScaleDefinition
- 1.1.22 wmStockMoveInt
- 1.1.23 wmTaskMaster
- 1.1.24 wmTestHistory
- 1.1.25 wmUomConv
- 1.1.26 wmUserPrefs
- 1.1.27 wmUserTask
- 1.1.28 wmWave
- 1.1.29 wms_autohd_tbl
- 1.1.30 wms_bin_tbl
- 1.1.31 wms_bincnt_tbl
- 1.1.32 wms_bindtlst_tbl
- 1.1.33 wms_case_tbl
- 1.1.34 wms_comments_tbl
- 1.1.35 wms_contadj_tbl
- 1.1.36 wms_contcase_tbl
- 1.1.37 wms_contdtl_tbl
- 1.1.38 wms_context_tbl
- 1.1.39 wms_conthdr_tbl
- 1.1.40 wms_contst_tbl
- 1.1.41 wms_contty_tbl
- 1.1.42 wms_contxf_tbl
- 1.1.43 wms_counter_tbl
- 1.1.44 wms_ctwght_tbl
- 1.1.45 wms_custpull_tbl
- 1.1.46 wms_cycnt_tbl
- 1.1.47 wms_erpint_tbl
- 1.1.48 wms_except_tbl
- 1.1.49 wms_group_tbl
- 1.1.50 wms_kit_tbl
- 1.1.51 wms_lhold_tbl
- 1.1.52 wms_load_tbl
- 1.1.53 wms_loadnm_tbl
- 1.1.54 wms_lothist_tbl
- 1.1.55 wms_outint_tbl
- 1.1.56 wms_piint_tbl
- 1.1.57 wms_pmint_tbl
- 1.1.58 wms_pmintdtl_tbl
- 1.1.59 wms_point_tbl
- 1.1.60 wms_print_tbl
- 1.1.61 wms_pultol_tbl
- 1.1.62 wms_recper_tbl
- 1.1.63 wms_rma_tbl
- 1.1.64 wms_screen_tbl
- 1.1.65 wms_sectmpl_tbl
- 1.1.66 wms_secure_tbl
- 1.1.67 wms_shipins_tbl Table no longer
- 1.1.68 wms_track_tbl
- 1.1.69 wms_user_tbl
- 1.1.70 wms_usercols_tbl
- 1.1.71 wms_utcount_tbl
- 1.1.72 wms_vndpull_tbl
- 1.1.73 wms_wtint_tbl
- 1.1.74 wms_zone_tbl
- 1.1.75 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 |
---|---|---|---|
|
|
|
|
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 |
---|---|---|---|
|
|
|
|