Difference between revisions of "GX:Appendix C Whistle Database Tables"
From coolearthwiki
m |
|||
(127 intermediate revisions by 5 users not shown) | |||
Line 1: | Line 1: | ||
− | + | =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 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 128: | Line 137: | ||
|} | |} | ||
− | + | ==Whistle Tables and Definitions== | |
− | {| | + | {| border="1" cellpadding="2" valign="top" halign="left" |
− | ! | + | !Column |
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
|- | |- | ||
− | *company | + | ===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" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
− | + | ===wmAutoReceiveWhs=== | |
− | company | + | | |
− | warehouse | + | *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=== | |
− | company varchar(2) | + | | |
− | + | *company | |
− | + | *warehouse | |
− | + | *countKey | |
+ | *containerHeader | ||
+ | *containerDetail | ||
+ | *bin | ||
+ | *item | ||
+ | *pack | ||
+ | *lot | ||
+ | *originalQty | ||
+ | *countedQty | ||
+ | *countedCost | ||
+ | *variance | ||
+ | *varianceCost | ||
+ | *countedBy | ||
+ | *countedOn | ||
+ | *updateCounter | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *int | ||
+ | *varchar(10) | ||
+ | *int | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *decimal(18,4) | ||
+ | *decimal(18,4) | ||
+ | *decimal(18,4) | ||
+ | *decimal(18,4) | ||
+ | *decimal(18,4) | ||
+ | *varchar(10) | ||
+ | *datetime | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Count Key | ||
+ | *Container Header Key | ||
+ | *Container Detail Key | ||
+ | *Bin Key | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | *Lot Key | ||
+ | *Original Quantity Value | ||
+ | *Counted Quantity Value | ||
+ | *Counted Cost Value | ||
+ | *Variance Value | ||
+ | *Variance Cost Value | ||
+ | *User Key | ||
+ | *Counted On Date/Time Value | ||
+ | *Update Counter Key | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wmCountMaster=== | ||
+ | | | ||
+ | *company | ||
+ | *warehouse | ||
+ | *countKey | ||
+ | *countStatus | ||
+ | *createdBy | ||
+ | *createdOn | ||
+ | *completedBy | ||
+ | *completedOn | ||
+ | *countedCost | ||
+ | *netVarianceCost | ||
+ | *numCounts | ||
+ | *numErrors | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *int | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *datetime | ||
+ | *varchar(10) | ||
+ | *datetime | ||
+ | *decimal(18,4) | ||
+ | *decimal(18,4) | ||
+ | *int | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Count Key | ||
+ | *Count Status Key | ||
+ | *User Key | ||
+ | *Counted On Date/Time Value | ||
+ | *User Key | ||
+ | *Completed On Date/Time Value | ||
+ | *Counted Cost Value | ||
+ | *Net Variance Cost | ||
+ | *Number of Counts Value | ||
+ | *Number of Errors Value | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wmCountZones=== | ||
+ | | | ||
+ | *company | ||
+ | *warehouse | ||
+ | *countZone | ||
+ | *bin | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Count Zone Key | ||
+ | *Bin Key | ||
+ | |} | ||
− | wmCountedBins | + | {| border="1" cellpadding="2" valign="top" halign="left" |
− | company varchar(2) | + | !Column |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !Key Description | |
− | + | |- | |
− | + | ===wmCountedBins=== | |
− | + | | | |
− | + | *company | |
+ | *warehouse | ||
+ | *countKey | ||
+ | *bin | ||
+ | *errors | ||
+ | *countedBy | ||
+ | *countedOn | ||
+ | *updateCounter | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *int | ||
+ | *varchar(10) | ||
+ | *int | ||
+ | *varchar(10) | ||
+ | *datetime | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Count Key | ||
+ | *Bin Key | ||
+ | *Errors Key | ||
+ | *User Key | ||
+ | *Counted On Date/Time Value | ||
+ | *Update Counter Key | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wmCustomer=== | ||
+ | | | ||
+ | *company | ||
+ | *warehouse | ||
+ | *customerKey | ||
+ | *showCustPartNumber | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Customer Key | ||
+ | *Show Customer Part Number Key | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wmDemand=== | ||
+ | | | ||
+ | *company | ||
+ | *warehouse | ||
+ | *orderKey | ||
+ | *orderType | ||
+ | *demandLine | ||
+ | *status | ||
+ | *item | ||
+ | *pack | ||
+ | *lot | ||
+ | *demandQty | ||
+ | *pickedQty | ||
+ | *uom | ||
+ | *createTime | ||
+ | *activeUser | ||
+ | *lockCounter | ||
+ | *minShelfLife | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *int | ||
+ | *int | ||
+ | *varchar(50) | ||
+ | *varchar(20) | ||
+ | *varchar(8) | ||
+ | *varchar(20) | ||
+ | *decimal(18,4) | ||
+ | *decimal(18,4) | ||
+ | *varchar(2) | ||
+ | *datetime | ||
+ | *varchar(10) | ||
+ | *int | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Order Key | ||
+ | *Order Type Key | ||
+ | *Demand Line Key | ||
+ | *Status Key | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | *Lot Key | ||
+ | *Demand Quantity Value | ||
+ | *Picked Quantity Value | ||
+ | *UOM Value | ||
+ | *Created Date/Time Value | ||
+ | *User Key | ||
+ | *Lock Counter Key | ||
+ | *Minimum Shelf Life Key | ||
+ | |} | ||
− | + | {| border="1" cellpadding="2" valign="top" halign="left" | |
− | company | + | !Column |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !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=== | ||
+ | | | ||
+ | *company | ||
+ | *warehouse | ||
+ | *item | ||
+ | *pack | ||
+ | *context | ||
+ | *instruction | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(20) | ||
+ | *varchar(8) | ||
+ | *int | ||
+ | *varchar(255) | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | *Context Key | ||
+ | *Instruction Text Value | ||
+ | |} | ||
− | + | {| border="1" cellpadding="2" valign="top" halign="left" | |
− | + | !Column | |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !Key Description | |
− | + | |- | |
− | + | ===wmLabelCrossRef=== | |
− | + | | | |
− | + | *company | |
− | + | *branch | |
− | + | *deliverFrom | |
− | + | *labelKey | |
− | + | | | |
− | + | *varchar(2) | |
− | + | *varchar(4) | |
− | + | *varchar(10) | |
− | + | *int | |
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company key | ||
+ | *Branch Key | ||
+ | *Deliver From Key | ||
+ | *Label Key | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wmLabelElements=== | ||
+ | | | ||
+ | *labelKey | ||
+ | *elementKey | ||
+ | *dataType | ||
+ | *elementDescription | ||
+ | *position | ||
+ | *width | ||
+ | *uom | ||
+ | *decimalPosition | ||
+ | *mapsTo | ||
+ | *required | ||
+ | *lastModifiedBy | ||
+ | *lastModifiedOn | ||
+ | | | ||
+ | *int | ||
+ | *int | ||
+ | *int | ||
+ | *varchar(10) | ||
+ | *int | ||
+ | *int | ||
+ | *varchar(2) | ||
+ | *int | ||
+ | *varchar(20) | ||
+ | *int | ||
+ | *varchar(10) | ||
+ | *datetime | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Label Key | ||
+ | *Element Key | ||
+ | *Data Type Value | ||
+ | *Element Description Value | ||
+ | *Position Value | ||
+ | *Width Value | ||
+ | *UOM Value | ||
+ | *Decimal Position Key | ||
+ | *Maps To Key | ||
+ | *Required Key | ||
+ | *User Key | ||
+ | *Last Modified Date/Time Value | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wmPickAllocation=== | ||
+ | | | ||
+ | *pickAllocKey | ||
+ | *companyKey | ||
+ | *warehouseKey | ||
+ | *orderType | ||
+ | *orderKey | ||
+ | *orderLineKey | ||
+ | *containerKey | ||
+ | *itemKey | ||
+ | *packKey | ||
+ | *allocLotKey | ||
+ | *allocQuantity | ||
+ | *allocUOM | ||
+ | *status | ||
+ | *lastChangedBy | ||
+ | *lastChangeDate | ||
+ | *createdBy | ||
+ | *creationDate | ||
+ | *lockCounter | ||
+ | | | ||
+ | *int | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *smallint | ||
+ | *varchar(30) | ||
+ | *int | ||
+ | *varchar(10) | ||
+ | *varchar(20) | ||
+ | *varchar(10) | ||
+ | *varchar(30) | ||
+ | *float | ||
+ | *varchar(2) | ||
+ | *smallint | ||
+ | *varchar(30) | ||
+ | *datetime | ||
+ | *varchar(30) | ||
+ | *datetime | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Pick Allocation Key | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Order Type Key | ||
+ | *Order Key | ||
+ | *Order Line Key | ||
+ | *Container Key | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | *Allocation Lot Key | ||
+ | *Allocation Quantity Value | ||
+ | *Allocation UOM Value | ||
+ | *Status Key | ||
+ | *User Key | ||
+ | *Changed on Date/Time Value | ||
+ | *User Key | ||
+ | *Created On Date Value | ||
+ | *Lock Counter Value | ||
+ | |} | ||
− | + | {| border="1" cellpadding="2" valign="top" halign="left" | |
− | company | + | !Column |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !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=== | ||
+ | | | ||
+ | *company | ||
+ | *warehouse | ||
+ | *track | ||
+ | *numLabels | ||
+ | *printDoc | ||
+ | *printer | ||
+ | *prePrint | ||
+ | *printSequence1 | ||
+ | *printSequence2 | ||
+ | *printSequence3 | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *int | ||
+ | *varchar(255) | ||
+ | *varchar(255) | ||
+ | *int | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Tracking Key | ||
+ | *Number of labels Value | ||
+ | *Print Document Value | ||
+ | *Printer Value | ||
+ | *Pre print Value | ||
+ | *Print Sequence 1 Value | ||
+ | *Print Sequence 2 Value | ||
+ | *Print Sequence 3 Value | ||
+ | |} | ||
− | + | {| border="1" cellpadding="2" valign="top" halign="left" | |
− | company | + | !Column |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !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=== | |
− | + | | | |
− | + | *ruleContextKey | |
− | + | *companyKey | |
− | + | *warehouseKey | |
− | + | *contextName | |
− | + | *contextType | |
− | + | *binKey | |
− | + | *lastChangedBy | |
− | + | *lastChangeDate | |
− | + | *createdBy | |
− | + | *creationDate | |
− | + | *lockCounter | |
+ | | | ||
+ | *int | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *varchar(60) | ||
+ | *smallint | ||
+ | *varchar(10) | ||
+ | *varchar(30) | ||
+ | *datetime | ||
+ | *varchar(30) | ||
+ | *datetime | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Rule Context key | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Context Name Value | ||
+ | *Context Type Value | ||
+ | *Bin Key | ||
+ | *User Key | ||
+ | *Changed on Date/Time Value | ||
+ | *User Key | ||
+ | *Created on Date/Time Value | ||
+ | *Lock Counter | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wmRuleContextLine=== | ||
+ | | | ||
+ | *ruleContextLineKey | ||
+ | *ruleContextKey | ||
+ | *rulePriority | ||
+ | *ruleMasterKey | ||
+ | *sortOrder | ||
+ | *lastChangedBy | ||
+ | *lastChangeDate | ||
+ | *createdBy | ||
+ | *creationDate | ||
+ | *lockCounter | ||
+ | | | ||
+ | *int | ||
+ | *int | ||
+ | *smallint | ||
+ | *int | ||
+ | *smallint | ||
+ | *varchar(30) | ||
+ | *datetime | ||
+ | *varchar(30) | ||
+ | *datetime | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Rule Context Line Key | ||
+ | *Rule Context Key | ||
+ | *Rule Priority Value | ||
+ | *Rule Master Key | ||
+ | *Sort Order Value | ||
+ | *User Key | ||
+ | *Changed on Date | ||
+ | *User Key | ||
+ | *Created on Date | ||
+ | *Lock Counter Value | ||
+ | |} | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wmRuleMaster=== | ||
+ | | | ||
+ | *ruleMasterKey | ||
+ | *ruleName | ||
+ | *ruleTable | ||
+ | *ruleColumn | ||
+ | *ruleIdentifier | ||
+ | *lastChangedBy | ||
+ | *lastChangeDate | ||
+ | *createdBy | ||
+ | *creationDate | ||
+ | *lockCounter | ||
+ | | | ||
+ | *int | ||
+ | *varchar(60) | ||
+ | *varchar(30) | ||
+ | *varchar(30) | ||
+ | *varchar(30) | ||
+ | *varchar(30) | ||
+ | *datetime | ||
+ | *varchar(30) | ||
+ | *datetime | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Rule Master Key | ||
+ | *Rule Name Value | ||
+ | *Rule Table Value | ||
+ | *Rule Column Value | ||
+ | *Rule ID Value | ||
+ | *User Key | ||
+ | *Changed on Date Value | ||
+ | *User Key | ||
+ | *Created on Date Value | ||
+ | *Lock Counter Value | ||
+ | |} | ||
− | + | {| border="1" cellpadding="2" valign="top" halign="left" | |
− | + | !Column | |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !Key Description | |
− | + | |- | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
+ | ===wmScaleDefinition=== | ||
+ | | | ||
+ | *company | ||
+ | *warehouse | ||
+ | *scaleKey | ||
+ | *scaleDescription | ||
+ | *scaleAddress | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(60) | ||
+ | *varchar(128) | ||
+ | *varchar(128) | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Scale Key | ||
+ | *Scale Description Value | ||
+ | *Scale Address Value | ||
+ | |} | ||
+ | {| 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" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wmTaskMaster=== | ||
+ | | | ||
+ | *taskMasterKey | ||
+ | *taskType | ||
+ | *taskName | ||
+ | *refLabel1 | ||
+ | *refLabel2 | ||
+ | *refLabel3 | ||
+ | *lastChangedBy | ||
+ | *lastChangeDate | ||
+ | *createdBy | ||
+ | *creationDate | ||
+ | *lockCounter | ||
+ | | | ||
+ | *int | ||
+ | *varchar(20) | ||
+ | *varchar(30) | ||
+ | *varchar(30) | ||
+ | *varchar(30) | ||
+ | *varchar(30) | ||
+ | *varchar(30) | ||
+ | *datetime | ||
+ | *varchar(30) | ||
+ | *datetime | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Task Master Key | ||
+ | *Task Type Value | ||
+ | *Task Name Value | ||
+ | *Reference Label 1 | ||
+ | *Reference Label 2 | ||
+ | *Reference Label 3 | ||
+ | *User Key | ||
+ | *Changed On Date/Time Value | ||
+ | *User Key | ||
+ | *Created On Date/Time Value | ||
+ | *Lock Counter Value | ||
+ | |} | ||
− | + | {| border="1" cellpadding="2" valign="top" halign="left" | |
− | + | !Column | |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !Key Description | |
− | + | |- | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
+ | ===wmTestHistory=== | ||
+ | | | ||
+ | *testKey | ||
+ | *effectiveDate | ||
+ | *sequence | ||
+ | *item | ||
+ | *pack | ||
+ | *lot | ||
+ | *sampleID | ||
+ | *status | ||
+ | *result | ||
+ | *measured | ||
+ | *measuredUOM | ||
+ | *comments | ||
+ | *transactionTime | ||
+ | *tranactionUser | ||
+ | | | ||
+ | *varchar(10) | ||
+ | *datetime | ||
+ | *int | ||
+ | *varchar(20) | ||
+ | *varchar(10) | ||
+ | *varchar(30) | ||
+ | *varchar(20) | ||
+ | *varchar(20) | ||
+ | *varchar(60) | ||
+ | *decimal(18,4) | ||
+ | *varchar(2) | ||
+ | *varchar(255) | ||
+ | *datetime | ||
+ | *varchar(10) | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Test Key | ||
+ | *Effective Date/Time Value | ||
+ | *Sequence Value | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | *Lot Key | ||
+ | *Sample ID Value | ||
+ | *Status Value | ||
+ | *Result Value | ||
+ | *Measured value | ||
+ | *Unit Of Measure Value | ||
+ | *Comment Value | ||
+ | *Transaction Date/Time Value | ||
+ | *User Key | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
− | + | ===wmUomConv=== | |
− | + | | | |
− | + | *gl_cmp_key | |
− | + | *in_whs_key | |
− | + | *in_item_key | |
− | + | *im_pack_key | |
− | + | *uom_from | |
− | + | *uom_to | |
− | + | *factor | |
− | + | | | |
− | + | *varchar(2) | |
+ | *varchar(4) | ||
+ | *varchar(20) | ||
+ | *varchar(6) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *float | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | *UOM From Key | ||
+ | *UOM To Key | ||
+ | *Factor Key | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wmUserPrefs=== | ||
+ | | | ||
+ | *gl_cmp_key | ||
+ | *in_whs_key | ||
+ | *user_key | ||
+ | *pref_name | ||
+ | *pref_value | ||
+ | *created_by | ||
+ | *created_on | ||
+ | *changed_by | ||
+ | *changed_on | ||
+ | *lock_counter | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(8) | ||
+ | *varchar(64) | ||
+ | *varchar(256) | ||
+ | *varchar(8) | ||
+ | *datetime | ||
+ | *varchar(8) | ||
+ | *datetime | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *User Key | ||
+ | *Preference Name Value | ||
+ | *Preference Value | ||
+ | *User Key | ||
+ | *Created on Date/Time Value | ||
+ | *User Key | ||
+ | *Changed On Date/Time Value | ||
+ | *Lock Counter Value | ||
+ | |} | ||
− | + | {| border="1" cellpadding="2" valign="top" halign="left" | |
− | + | !Column | |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !Key Description | |
− | + | |- | |
+ | ===wmUserTask=== | ||
+ | | | ||
+ | *userTaskKey | ||
+ | *userKey | ||
+ | *companyKey | ||
+ | *warehouseKey | ||
+ | *taskMasterKey | ||
+ | *taskNote | ||
+ | *expectedStart | ||
+ | *expectedFinish | ||
+ | *actualStart | ||
+ | *actualFinish | ||
+ | *priority | ||
+ | *status | ||
+ | *refValue1 | ||
+ | *refValue2 | ||
+ | *refValue3 | ||
+ | *assignedBy | ||
+ | *lastChangedBy | ||
+ | *lastChangeDate | ||
+ | *createdBy | ||
+ | *creationDate | ||
+ | *lockCounter | ||
+ | | | ||
+ | *int | ||
+ | *varchar(8) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *int | ||
+ | *varchar(255) | ||
+ | *datetime | ||
+ | *datetime | ||
+ | *datetime | ||
+ | *datetime | ||
+ | *smallint | ||
+ | *smallint | ||
+ | *varchar(30) | ||
+ | *varchar(30) | ||
+ | *varchar(30) | ||
+ | *varchar(10) | ||
+ | *varchar(30) | ||
+ | *datetime | ||
+ | *varchar(30) | ||
+ | *datetime | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *User Task Key | ||
+ | *User Key | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Task Master Key | ||
+ | *Task Note Value | ||
+ | *Expected Start Date/Time Value | ||
+ | *Expected End Date/Time Value | ||
+ | *Actual Start Date/Time Value | ||
+ | *Actual End Date/Time Value | ||
+ | *Priority Value | ||
+ | *Status Value | ||
+ | *Reference Value 1 | ||
+ | *Reference Value 2 | ||
+ | *Reference Value 3 | ||
+ | *User Key | ||
+ | *User Key | ||
+ | *Changed on Date/Time Value | ||
+ | *User Key | ||
+ | *Created on Date/Time Value | ||
+ | *Lock Counter Value | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
− | + | ===wmWave=== | |
− | + | | | |
− | + | *company | |
− | + | *warehouse | |
− | + | *waveKey | |
− | + | *createdOn | |
− | + | *createdBy | |
− | + | | | |
− | + | *varchar(2) | |
− | + | *varchar(4) | |
− | + | *varchar(10) | |
− | + | *datetime | |
+ | *varchar(10) | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Wave Key | ||
+ | *Created on Date/Time Value | ||
+ | *User Key | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wms_autohd_tbl=== | ||
+ | | | ||
+ | *gl_cmp_key | ||
+ | *in_whs_key | ||
+ | *in_item_key | ||
+ | *im_pack_key | ||
+ | *wms_autohd_hrs | ||
+ | *context | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(30) | ||
+ | *varchar(6) | ||
+ | *int | ||
+ | *varchar(10) | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | *Autohold Length Hours Value | ||
+ | *Context Value | ||
+ | |} | ||
− | + | {| border="1" cellpadding="2" valign="top" halign="left" | |
− | + | !Column | |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !Key Description | |
− | + | |- | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
+ | ===wms_bin_tbl=== | ||
+ | | | ||
+ | *gl_cmp_key | ||
+ | *in_whs_key | ||
+ | *in_locn_key | ||
+ | *wms_bin_key | ||
+ | *wms_bin_depth | ||
+ | *wms_bin_height | ||
+ | *wms_bin_width | ||
+ | *wms_bin_type | ||
+ | *wms_bin_row | ||
+ | *wms_bin_col | ||
+ | *wms_bin_cychd | ||
+ | *wms_bin_hold | ||
+ | *can_mix_items | ||
+ | *not_on_picklist | ||
+ | *dont_trackvol | ||
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(15) | ||
+ | *float | ||
+ | *float | ||
+ | *float | ||
+ | *varchar(10) | ||
+ | *int | ||
+ | *int | ||
+ | *int | ||
+ | *int | ||
+ | *int | ||
+ | *int | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Location Key | ||
+ | *Bin Key | ||
+ | *Bin Depth Value | ||
+ | *Bin Height Value | ||
+ | *Bin Width Value | ||
+ | *Bin Type Value | ||
+ | *Bin row # (x) Value | ||
+ | *Bin column # (y) Value | ||
+ | *Bin Cycle Lock Value | ||
+ | *Bin On Hold Value | ||
+ | *Bin 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" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
− | + | ===wms_bincnt_tbl=== | |
− | gl_cmp_key | + | | |
− | + | *gl_cmp_key | |
− | + | *in_whs_key | |
− | + | *in_cycnt_key | |
− | + | *wms_bin_key | |
− | + | *wms_bincnt_stat | |
− | + | *sa_user_key | |
+ | *wms_bincnt_crtdt | ||
+ | *in_locn_key | ||
+ | *in_item_key | ||
+ | *im_pack_key | ||
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *int | ||
+ | *varchar(15) | ||
+ | *int | ||
+ | *varchar(8) | ||
+ | *datetime | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Cycle count key | ||
+ | *Bin Key | ||
+ | *Bin count status Value | ||
+ | *User Key | ||
+ | *Counted on Date/Time Value | ||
+ | *Location Key | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wms_bindtlst_tbl=== | ||
+ | | | ||
+ | *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 | ||
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(13) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *float | ||
+ | *float | ||
+ | *float | ||
+ | *float | ||
+ | *float | ||
+ | *int | ||
+ | *varchar(30) | ||
+ | *varchar(6) | ||
+ | *varchar(25) | ||
+ | *datetime | ||
+ | *varchar(20) | ||
+ | *varchar(10) | ||
+ | *datetime | ||
+ | *float | ||
+ | *varchar(10) | ||
+ | *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 | ||
+ | *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 | ||
+ | |} | ||
− | + | {| border="1" cellpadding="2" valign="top" halign="left" | |
− | + | !Column | |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !Key Description | |
− | + | |- | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
+ | ===wms_case_tbl=== | ||
+ | | | ||
+ | *gl_cmp_key | ||
+ | *in_whs_key | ||
+ | *wms_case_num | ||
+ | *created_on | ||
+ | *changed_on | ||
+ | *created_by | ||
+ | *changed_by | ||
+ | *lock_count | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *int | ||
+ | *datetime | ||
+ | *datetime | ||
+ | *varchar(8) | ||
+ | *varchar(8) | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Case Number Value | ||
+ | *Created on Date | ||
+ | *Changed on Date | ||
+ | *User Key | ||
+ | *User Key | ||
+ | *Lock Counter Value | ||
+ | |} | ||
+ | {| 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 | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
− | + | ===wms_contadj_tbl=== | |
− | + | | | |
− | + | *gl_cmp_key | |
− | + | *in_whs_key | |
− | + | *wms_conthdr_key | |
− | + | *in_item_key | |
+ | *im_pack_key | ||
+ | *wms_contadj_qty | ||
+ | *en_resn_key | ||
+ | *sa_user_key | ||
+ | *wms_contadj_date | ||
+ | *wms_contadj_cmt | ||
+ | *wms_contdtl_key | ||
+ | *wms_contcase_key | ||
+ | *wms_contadj_cntrl | ||
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(30) | ||
+ | *varchar(6) | ||
+ | *float | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *datetime | ||
+ | *varchar(255) | ||
+ | *int | ||
+ | *varchar(60) | ||
+ | *varchar(60) | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Tracking Key | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | *Adjusted Quantity Value | ||
+ | *Reason For Adjustment Value | ||
+ | *User Key | ||
+ | *Transaction Date/Time Value | ||
+ | *Container Adj Comment Value | ||
+ | *Container Detail Key | ||
+ | *Container Case Key | ||
+ | *Container Adj Control Num Value | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wms_contcase_tbl=== | ||
+ | | | ||
+ | *gl_cmp_key | ||
+ | *in_whs_key | ||
+ | *wms_conthdr_key | ||
+ | *wms_contdtl_key | ||
+ | *wms_contcase_key | ||
+ | *wms_contcase_ctwgt | ||
+ | *in_sublot_key | ||
+ | *wms_contcase_prddt | ||
+ | *created_on | ||
+ | *changed_on | ||
+ | *created_by | ||
+ | *changed_by | ||
+ | *lock_count | ||
+ | *wms_contcase_stat | ||
+ | *wms_contcase_acwgt | ||
+ | *lot | ||
+ | *allocation | ||
+ | *pieces | ||
+ | *lineKey | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *int | ||
+ | *varchar(60) | ||
+ | *float | ||
+ | *int | ||
+ | *datetime | ||
+ | *datetime | ||
+ | *datetime | ||
+ | *varchar(8) | ||
+ | *varchar(8) | ||
+ | *int | ||
+ | *int | ||
+ | *float | ||
+ | *varchar(25) | ||
+ | *varchar(25) | ||
+ | *int | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Tracking Key | ||
+ | *Tracking Detail Key | ||
+ | *Tracking Case Key | ||
+ | *Tracking Catch Weight Value | ||
+ | *Adage SubLot Key | ||
+ | *Case Production Date Value | ||
+ | *Created On Date Value | ||
+ | *Changed On Date Value | ||
+ | *User Key | ||
+ | *User Key | ||
+ | *Lock Count Value | ||
+ | *Container Status Value | ||
+ | *Container Actual Weight Value | ||
+ | *Lot Key | ||
+ | *Case Allocated Value | ||
+ | *Per box Piece Count | ||
+ | *Line Number | ||
+ | |} | ||
− | + | {| border="1" cellpadding="2" valign="top" halign="left" | |
− | + | !Column | |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !Key Description | |
− | + | |- | |
− | + | ||
+ | ===wms_contdtl_tbl=== | ||
+ | | | ||
+ | *gl_cmp_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 | ||
+ | *wms_user_paramVC10 | ||
+ | *wms_user_paramF1 | ||
+ | *wms_user_paramF2 | ||
+ | *wms_user_paramF3 | ||
+ | *wms_user_paramF4 | ||
+ | *wms_user_paramF5 | ||
+ | *wms_contdtl_crtdt | ||
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(30) | ||
+ | *varchar(6) | ||
+ | *varchar(20) | ||
+ | *varchar(60) | ||
+ | *datetime | ||
+ | *datetime | ||
+ | *varchar(10) | ||
+ | *float | ||
+ | *varchar(6) | ||
+ | *varchar(25) | ||
+ | *varchar(20) | ||
+ | *float | ||
+ | *int | ||
+ | *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 | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company 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 | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
− | + | ===wms_context_tbl=== | |
− | gl_cmp_key varchar( | + | | |
− | + | *gl_cmp_key | |
− | + | *in_whs_key | |
− | + | *wms_conthdr_key | |
− | + | *wms_context_variety | |
− | + | *wms_context_linemtch | |
− | + | *wms_context_idfield | |
− | + | *created_on | |
− | + | *changed_on | |
− | + | *created_by | |
− | + | *changed_by | |
− | + | *lock_count | |
− | + | | | |
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *varchar(4) | ||
+ | *datetime | ||
+ | *datetime | ||
+ | *varchar(8) | ||
+ | *varchar(8) | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Tracking Key | ||
+ | *Context Variety Value | ||
+ | *Context Line Match Value | ||
+ | *Context ID Field Value | ||
+ | *Created on Date/Time Value | ||
+ | *Changed on Date/Time Value | ||
+ | *User Key | ||
+ | *User Key | ||
+ | *Lock Count Value | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wms_conthdr_tbl=== | ||
+ | | | ||
+ | *gl_cmp_key | ||
+ | *in_whs_key | ||
+ | *wms_conthdr_key | ||
+ | *wms_contst_key | ||
+ | *in_locn_key | ||
+ | *wms_bin_key | ||
+ | *wms_conthdr_lstmv | ||
+ | *wms_contty_key | ||
+ | *wms_conthdr_lstdt | ||
+ | *sa_user_key | ||
+ | *wms_contst_reldt | ||
+ | *wms_group_key | ||
+ | *wms_conthdr_vol | ||
+ | *lockCounter | ||
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *varchar(15) | ||
+ | *datetime | ||
+ | *varchar(10) | ||
+ | *datetime | ||
+ | *varchar(8) | ||
+ | *datetime | ||
+ | *int | ||
+ | *float | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Tracking Key | ||
+ | *Container Status Value | ||
+ | *Location Key | ||
+ | *Bin Key | ||
+ | *Last Moved Date/Time Value | ||
+ | *Container Type | ||
+ | *Container Last Changed Date Value | ||
+ | *User Key | ||
+ | *Release Date/Time | ||
+ | *Group Key | ||
+ | *Container Volume Value | ||
+ | *Lock Counter Value | ||
+ | |} | ||
− | + | {| border="1" cellpadding="2" valign="top" halign="left" | |
− | + | !Column | |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !Key Description | |
− | + | |- | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
+ | ===wms_contst_tbl=== | ||
+ | | | ||
+ | *gl_cmp_key | ||
+ | *in_whs_key | ||
+ | *wms_contst_key | ||
+ | *wms_contst_desc | ||
+ | *wms_contst_type | ||
+ | *wms_contst_reldt | ||
+ | *wms_contst_relby | ||
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(60) | ||
+ | *varchar(10) | ||
+ | *varchar(8) | ||
+ | *varchar(8) | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Container Status Value | ||
+ | *Container Description Value | ||
+ | *Container Type Value | ||
+ | *Container Release Date Value | ||
+ | *Container Release By Date Value | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
− | + | ===wms_contty_tbl=== | |
− | gl_cmp_key | + | | |
− | in_whs_key | + | *gl_cmp_key |
− | + | *in_whs_key | |
− | + | *wms_contty_key | |
− | + | *wms_contty_height | |
− | + | *wms_contty_depth | |
− | + | *wms_contty_width | |
− | + | *wms_contty_lay | |
− | + | *wms_contty_case | |
− | + | *wms_contty_uom | |
− | + | *wms_contty_dftrtype | |
− | + | | | |
− | + | *varchar(3) | |
− | + | *varchar(4) | |
− | + | *varchar(10) | |
− | + | *float | |
− | + | *float | |
− | + | *float | |
− | + | *int | |
− | + | *int | |
− | + | *varchar(6) | |
− | + | *varchar(50) | |
− | + | | | |
− | + | *NOTNULL | |
− | + | *NOTNULL | |
− | + | *NOTNULL | |
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Container Type Value | ||
+ | *Container Height Value | ||
+ | *Container Depth Value | ||
+ | *Container Width Value | ||
+ | *Number Of Layers Value | ||
+ | *Number Of Cases Value | ||
+ | *Unit Of Measure Value | ||
+ | *Type Of Transaction Value | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wms_contxf_tbl=== | ||
+ | | | ||
+ | *gl_cmp_key | ||
+ | *in_whs_key | ||
+ | *wms_contty_key | ||
+ | *in_item_key | ||
+ | *im_pack_key | ||
+ | *wms_desc | ||
+ | *so_prod_key | ||
+ | *wms_active_qty | ||
+ | *wms_hold_qty | ||
+ | *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 | ||
+ | *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=== | ||
+ | | | ||
+ | *wms_counter_type | ||
+ | *wms_counter_idx | ||
+ | | | ||
+ | *smallint | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Counter Name Value | ||
+ | *Current Counter Number Value | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
− | + | ===wms_ctwght_tbl=== | |
− | gl_cmp_key | + | | |
− | in_whs_key varchar( | + | *gl_cmp_key |
− | + | *in_whs_key | |
− | + | *in_item_key | |
− | + | *im_pack_key | |
− | + | *wms_ctwght_minwgt | |
− | + | *wms_ctwght_maxwgt | |
− | + | *wms_ctwght_tare | |
− | + | *wms_ctwght_scc | |
− | + | *upc_key | |
− | + | *ucc128_item | |
− | + | *created_on | |
− | + | *changed_on | |
+ | *created_by | ||
+ | *changed_by | ||
+ | *lock_count | ||
+ | *wms_ctwght_netwt | ||
+ | *wms_ctwght_backdt | ||
+ | *wms_ctwght_sell | ||
+ | | | ||
+ | *varchar(2) | ||
+ | *varchar(4) | ||
+ | *varchar(20) | ||
+ | *varchar(6) | ||
+ | *float | ||
+ | *float | ||
+ | *float | ||
+ | *varchar(40) | ||
+ | *varchar(60) | ||
+ | *varchar(6) | ||
+ | *datetime | ||
+ | *datetime | ||
+ | *varchar(8) | ||
+ | *varchar(8) | ||
+ | *int | ||
+ | *float | ||
+ | *int | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Item Key | ||
+ | *Pack Key | ||
+ | *Catch Weight Minimum Tolerance | ||
+ | *Catch Weight Maximum Tolerance | ||
+ | *Catch Weight Tare Weight Value | ||
+ | *Catch Weight SCC Value | ||
+ | *UPC Key | ||
+ | *UCC 128 Item | ||
+ | *Created on Date/Time Value | ||
+ | *Changed on Date/Time Value | ||
+ | *User Key | ||
+ | *User Key | ||
+ | *Lock Count Value | ||
+ | *Catch weight Net Weight Value | ||
+ | *Catch Weight Back Date | ||
+ | *Catch Weight Sell Value | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wms_custpull_tbl=== | ||
+ | | | ||
+ | *gl_cmp_key | ||
+ | *in_whs_key | ||
+ | *ap_cust_key | ||
+ | *wms_custpull_puldt | ||
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Customer Key | ||
+ | *Customer Pull Date Value | ||
+ | |} | ||
− | + | {| border="1" cellpadding="2" valign="top" halign="left" | |
− | + | !Column | |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !Key Description | |
− | + | |- | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
+ | ===wms_cycnt_tbl=== | ||
+ | | | ||
+ | *gl_cmp_key | ||
+ | *in_whs_key | ||
+ | *wms_conthdr_key | ||
+ | *in_cycnt_key | ||
+ | *wms_cycnt_entlv | ||
+ | *wms_cycnt_ent | ||
+ | *wms_cycnt_stat | ||
+ | *wms_cycnt_ent2 | ||
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *varchar(20) | ||
+ | *varchar(10) | ||
+ | *varchar(20) | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Tracking Key | ||
+ | *Cycle Count Key | ||
+ | *Cycle Count Entity Level Key | ||
+ | *Cycle Count Entity Key | ||
+ | *Cycle Count Status Value | ||
+ | *Cycle Count Entity 2 Key | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
− | + | ===wms_erpint_tbl=== | |
− | gl_cmp_key | + | | |
− | in_whs_key | + | *gl_cmp_key |
− | + | *in_whs_key | |
− | + | *wms_erpint_type | |
− | + | *wms_erpint_start | |
− | + | *wms_erpint_pid | |
− | + | | | |
− | + | *varchar(3) | |
− | + | *varchar(4) | |
− | + | *varchar(30) | |
− | + | *datetime | |
− | + | *int | |
− | + | | | |
− | + | *NOTNULL | |
− | + | *NOTNULL | |
− | + | *NOTNULL | |
− | + | *NOTNULL | |
− | + | *NOTNULL | |
− | + | | | |
− | + | *Company Key | |
− | + | *Warehouse Key | |
− | + | *ERP Interface Type Value | |
− | + | *ERP Interface Start Value | |
− | + | *ERP Interface Part ID Value | |
− | + | |} | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wms_except_tbl=== | ||
+ | | | ||
+ | *gl_cmp_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(4) | ||
+ | *varchar(10) | ||
+ | *varchar(10) | ||
+ | *varchar(15) | ||
+ | *varchar(15) | ||
+ | *float | ||
+ | *float | ||
+ | *varchar(255) | ||
+ | *varchar(8) | ||
+ | *datetime | ||
+ | | | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *Company 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 | ||
+ | |} | ||
− | + | {| border="1" cellpadding="2" valign="top" halign="left" | |
− | + | !Column | |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !Key Description | |
− | + | |- | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
+ | ===wms_group_tbl=== | ||
+ | | | ||
+ | *gl_cmp_key | ||
+ | *in_whs_key | ||
+ | *wms_group_key | ||
+ | | | ||
+ | *varchar(3) | ||
+ | *varchar(4) | ||
+ | *int | ||
+ | | | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | *NOTNULL | ||
+ | | | ||
+ | *Company Key | ||
+ | *Warehouse Key | ||
+ | *Group Key | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
− | + | ===wms_kit_tbl=== | |
− | gl_cmp_key | + | | |
− | + | *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 | |
− | + | | | |
+ | *varchar(2) | ||
+ | *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 | ||
+ | |} | ||
+ | {| border="1" cellpadding="2" valign="top" halign="left" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wms_lhold_tbl=== | ||
+ | | | ||
+ | *gl_cmp_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 | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | *NULL | ||
+ | | | ||
+ | *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 | ||
+ | |} | ||
− | + | {| border="1" cellpadding="2" valign="top" halign="left" | |
− | + | !Column | |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !Key Description | |
− | + | |- | |
− | + | ||
− | + | ||
+ | ===wms_load_tbl=== | ||
+ | | | ||
+ | *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" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
− | + | ===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" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wms_lothist_tbl=== | ||
+ | | | ||
+ | *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" | |
− | + | !Column | |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !Key Description | |
− | + | |- | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
+ | ===wms_outint_tbl=== | ||
+ | | | ||
+ | *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" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
− | + | ===wms_piint_tbl=== | |
− | + | | | |
− | + | *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" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wms_pmint_tbl=== | ||
+ | | | ||
+ | *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" | |
− | + | !Column | |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !Key Description | |
− | + | |- | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
+ | ===wms_pmintdtl_tbl=== | ||
+ | | | ||
+ | *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" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
− | + | ===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" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wms_print_tbl=== | ||
+ | | | ||
+ | *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" | |
− | + | !Column | |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !Key Description | |
− | + | |- | |
− | + | ||
− | + | ||
− | + | ||
+ | ===wms_pultol_tbl=== | ||
+ | | | ||
+ | *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" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
− | + | ===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" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !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=== | |
− | 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" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wms_sectmpl_tbl=== | ||
+ | | | ||
+ | *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" | |
− | + | !Column | |
− | + | !Data Type | |
− | + | !Nullable | |
+ | !Key Description | ||
+ | |- | ||
+ | ===wms_secure_tbl=== | ||
+ | | | ||
+ | *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" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
− | + | ===wms_shipins_tbl Table no longer=== | |
− | gl_cmp_key | + | | |
− | in_whs_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" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wms_track_tbl=== | ||
+ | | | ||
+ | *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" | |
− | + | !Column | |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !Key Description | |
− | + | |- | |
− | + | ||
− | + | ||
− | + | ||
+ | ===wms_user_tbl=== | ||
+ | | | ||
+ | *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" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
− | + | ===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" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wms_utcount_tbl=== | ||
+ | | | ||
+ | *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" | |
− | + | !Column | |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !Key Description | |
+ | |- | ||
+ | ===wms_vndpull_tbl=== | ||
+ | | | ||
+ | *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" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
− | + | ===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" | ||
+ | !Column | ||
+ | !Data Type | ||
+ | !Nullable | ||
+ | !Key Description | ||
+ | |- | ||
+ | ===wms_zone_tbl=== | ||
+ | | | ||
+ | *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" | |
− | + | !Column | |
− | + | !Data Type | |
− | + | !Nullable | |
− | + | !Key Description | |
− | + | |- | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ===wms_zonexf_tbl=== | |
− | + | | | |
− | gl_cmp_key | + | *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 | |
− | in_whs_key | + | *NOTNULL |
− | + | *NOTNULL | |
− | + | *NOTNULL | |
− | + | *NOTNULL | |
− | in_item_key | + | *NOTNULL |
− | im_pack_key | + | *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 |
---|---|---|---|
|
|
|
|