Import (F2) Wizard (Inventory)
The Import Wizard allows you to either create new inventory items or update existing items using data from a file created outside the software (typically, a spreadsheet, delimited file, etc.). Using the Wizard is similar throughout the application; however, the fields and requirements are different.
This feature is available from the Item Maintenance form (Inventory > Database > Item).
Choose Import (F2) to display the context menu and then choose "Add Inventory" to add new items, or "Update Inventory" to make changes to existing items.
A few fields are required; however, most are optional. When applicable, default settings are used for any item fields that are not provided. A variety of Windows-based file formats may be used for importing items. For example, you can create an import file using Microsoft® Office® Excel® or some form of delimited text file. When using delimited files, it's best to use a delimiter character that is not found in the data (do not use a character that might be found in item descriptions or other fields, for example).
|
Microsoft® Access Database Engine 2010 Your computer must have the proper OLEDB drivers to open Excel and certain other Microsoft Office® files. Should you receive an error attempting to open Office files, download the appropriate Microsoft OLEDB Drivers for your system. |
After you load the source file in the Wizard, you use the Grid Mapping section to specify the matching information in your file to the columns in the database. The Database column names appear in the Grid Mappinglist. The Preview Data section shows you the information that displays in your file with matching F#s for each column entry. You enter the matching F# (F1, F2, etc.) in the Grid Mapping's From column to specify the matching data column in the Preview Data list. Then you can use this criteria to specify which data to use for each item you are importing into your inventory database:
-
You can either use the data in the file (by entering the F# in the From column),
-
You can supply a default value (by adding a specific entry in the Default column), or
-
You can leave the leave both blank to use the Item Maintenance form's defaults.
Minimally, you need to map or assign a default value to at least the required fields. Additionally, even though neither field is required, it is usually best to supply the "prevailing market cost" and/or "suggested retail" in your data... particularly when one or both settings are used to calculate price levels.
If the data in your source file has headers in it, select the Exclude first row (Headers) check box to prevent the import of these names.
If both the From and Default values are left blank, the application applies the Item Maintenance form defaults (if any) when adding the item to your company's inventory. Remember to select check boxes beside any branches you want to add the item to.
It's strongly suggested that you carefully review any newly added items after running the wizard to ensure that they operate as expected. There is no undo if you process and add items (there are sometimes opportunities to cancel during processing, however). Once added, any items you don't want would need to be manually deleted one-at-a-time.
Step Through vs. Update & Continue
When processing, you have the option of either "stepping through" or "update & continue."
-
Stepping Through processes each row in the "Preview Data" table one-at-a-time.
-
Update & Continue processes all rows one after the next except when it encounters an error.
Application or system administrators can change the severity level on some task list items. The Wizard also has it's own task list that identifies certain issues prior to processing.
When you use the "Step Through" option for processing, the Wizard will add new items until the listing is completed or whenever any Item Maintenance task list encounters an error or warning. When a task list displays, the application pauses processing to wait for your response (where you choose "Accept Warnings" or fix the issue). After you resolve all the errors, processing will continue immediately. To stop processing, you can use the Cancel (F9) function while processing is paused due to a task list error. If stopped, all wizard mapping and file selection will need to be repeated; this information is cleared once you cancel processing.
When using the "Update & Continue" option for processing, the Wizard will continue to add new items until the listing is completed. If the application encounters an Item Maintenance task list error, processing will pause; however, task list warnings are automatically accepted and do not display. If a task list error displays, the application will continue processing the import after you resolve the error. When you use the Update and Continue option, the application only stops processing when you select Cancel (F9) function while processing is paused due to a task list error.
In either case, any time processing is stopped (by using the Cancel (F9) function), it will be necessary to repeat all wizard mapping and file selection if you want to again attempt to process the same file. When you cancel processing, the wizard information is cleared.
If an item already exists or was previously added using the wizard, the following message displays. Select OK to continue processing with the next sequential item.
Handling Errors
When you attempt to process, errors are reported in the data grid columns by an error icon. Hover over the icons to view details regarding the error reason. When any errors occur, an "Export Grid Errors" button is now provided. If used, this saves a copy of just the error data in a comma-delimited (CSV) file in the same directory where the original file originated from. If there aren't many errors, you can manually correct errors directly from the data grid; otherwise, we suggest saving the error data then removing the error data rows by selecting the rows and choosing either Delete from the data grid's context menu or pressing the "Delete" key on your keyboard. In cases where all the data has errors, it may be a better idea to choose "Cancel" and fix the data directly in the source file.
The "Export Grid Errors" button is provided for both the "add" and "update" features.
Rules for Adding Inventory
Requirements and conditions for adding new items are different than those allowed when modifying (update). Please refer to the Item Maintenance Help topics for further information about settings. The following table lists all of the fields that can currently be imported to create new items (required fields are highlighted in red):
|
Required |
Field |
Description (for additional details about function, please see the Item Maintenance (database) help topics). |
|---|---|---|
|
N |
AlternateSKU0 |
The primary alternate SKU for the item. Cannot match with any another existing alternate SKU or item. A maximum of 16-characters is allowed. |
|
N |
Barcode0 |
The primary numeric barcode (UPC) to be used with this item. A maximum size of 16-characters is allowed. |
|
Y |
BaseUnitofMeasure |
The item's BASE unit of measure description. Units of Measure must be defined from the Code Definitions area before use. |
|
N |
Class |
The merchandising class code assigned to the product (if any). Found on the Common, Codes tab of the Item Maintenance form. |
|
N |
Department |
The merchandising department code assigned to the product (if any). Found on the Common, Codes tab of the Item Maintenance form. |
|
N |
Description |
The item's description. |
|
N |
FineLineCode |
The merchandising fine line code assigned to the product (if any). Found on the Common, Codes tab of the Item Maintenance form. |
|
Y |
Group |
The group number assigned to this item. Must be an integer between 1 and 255. Group Codes must be defined prior to use. |
|
Y |
ItemNumber |
The code (SKU) to be used for identifying the item. Cannot match with any other existing item or alternate SKU. |
|
N |
Keyword0 |
The 1st of 5 possible keywords that may be assigned to this item. Keywords are listed on the Common and Select tabs in Item Maintenance. |
|
N |
Keyword1 |
The 2nd of 5 possible keywords that may be assigned to this item. |
|
N |
Keyword2 |
The 3rd of 5 possible keywords that may be assigned to this item. |
|
N |
Keyword3 |
The 4th of 5 possible keywords that may be assigned to this item. |
|
N |
Keyword4 |
The 5th of 5 possible keywords that may be assigned to this item. |
|
N |
MiscUMQtyConversion |
The numeric Unit of Measure "From" value. This decimal value is used when converting quantities or pricing represented using the Miscellaneous (Misc) unit of measure to the equivalent value in terms of the BASE measure (and the reverse).
To convert a value (price or qty) from BASE to the Miscellaneous measure, the following calculation is used:
Value * (MiscUMQtyConversion / MiscUMQtyConversionTo)
To convert a value from MISC to the BASE measure, the following calculation is used:
Value * (MiscUMQtyConversionTo / MiscUMQtyConversion)
In Item Maintenance, this field represents the left-hand side conversion value for the Miscellaneous measure (listed under the "Quantity Conversions" section found near the bottom of the Measures tab). If a value is not supplied for this field, it will be assumed that the item's Miscellaneous and BASE measure are the same and both the "To" and "From" values will be set to one (1). |
|
N |
MiscUMQtyConversionTo |
The numeric Unit of Measure "To" value. This decimal value is used when converting quantities or pricing represented using the Miscellaneous (Misc) unit of measure to the equivalent value in terms of the BASE measure (and the reverse).
To convert a value (price or qty) from BASE to the Miscellaneous measure, the following calculation is used:
Value * (MiscUMQtyConversion / MiscUMQtyConversionTo)
To convert a value from MISC to the BASE measure, the following calculation is used:
Value * (MiscUMQtyConversionTo / MiscUMQtyConversion)
In Item Maintenance, this field represents the right-hand side conversion value for the Miscellaneous measure (listed under the "Quantity Conversions" section found near the bottom of the Measures tab). If a value is not supplied for this field, it will be assumed that the item's Miscellaneous and BASE measure are the same and both the "To" and "From" values will be set to one (1). |
|
N |
MiscUnitofMeasure |
The item's Miscellaneous (Misc) unit of measure description (code). Units of Measure must be defined from the Code Definitions area before use. If a value is not supplied, the Miscellaneous measure will be assumed to match the item's BASE measure. |
|
N |
PrevailingMarketCost |
This decimal value sets the Market Cost for the item. For new items, this is also used as the default for the last receipt and weighted average cost. The value used may include up to 4 decimal places. If no cost is supplied, the cost for the item will be set to a zero value. Additionally, assigning a zero cost can cause the item's price levels to be zero if the default levels are calculated using any of the 3 item costs (last receipt, market, and average cost). |
|
N |
PriceUMQtyConversion |
The numeric Unit of Measure "From" value. This decimal value is used when converting quantities or pricing represented using the Pricing unit of measure to the equivalent value in terms of the BASE measure (and the reverse).
To convert a value (price or qty) from BASE to the Pricing measure, the following calculation is used:
Value * (PriceUMQtyConversion / PriceUMQtyConversionTo)
To convert a value from Pricing to the BASE measure, the following calculation is used:
Value * (PriceUMQtyConversionTo / PriceUMQtyConversion)
In Item Maintenance, this field represents the left-hand side conversion value for the Pricing measure (listed under the "Quantity Conversions" section found near the bottom of the Measures tab). If a value is not supplied for this field, it will be assumed that the item's Pricing and BASE measure are the same and both the "To" and "From" values will be set to one (1). |
|
N |
PriceUMQtyConversionTo |
The numeric Unit of Measure "To" value. This decimal value is used when converting quantities or pricing represented using the Pricing unit of measure to the equivalent value in terms of the BASE measure (and the reverse).
To convert a value (price or qty) from BASE to the Pricing measure, the following calculation is used:
Value * (PriceUMQtyConversion / PriceUMQtyConversionTo)
To convert a value from Pricing to the BASE measure, the following calculation is used:
Value * (PriceUMQtyConversionTo / PriceUMQtyConversion)
In Item Maintenance, this field represents the right-hand side conversion value for the Pricing measure (listed under the "Quantity Conversions" section found near the bottom of the Measures tab). If a value is not supplied for this field, it will be assumed that the item's Pricing and BASE measure are the same and both the "To" and "From" values will be set to one (1). |
|
N |
PricingUnitofMeasure |
The item's Pricing unit of measure description (code). Units of Measure must be defined from the Code Definitions area before use. If a value is not supplied, the Pricing measure will be assumed to match the item's BASE measure. |
|
N |
PrimaryVendorCode |
The primary vendor code assigned to this item. The code supplied must match with an existing vendor. |
|
N |
ReceiveUMQtyConversion |
The numeric Unit of Measure "From" value. This decimal value is used when converting quantities or pricing represented using the Receiving unit of measure to the equivalent value in terms of the BASE measure (and the reverse).
To convert a value (price or qty) from BASE to the Receiving measure, the following calculation is used:
Value * (ReceiveUMQtyConversion / ReceiveUMQtyConversionTo)
To convert a value from Receiving to the BASE measure, the following calculation is used:
Value * (ReceiveUMQtyConversionTo / ReceiveUMQtyConversion)
In Item Maintenance, this field represents the left-hand side conversion value for the Receiving measure (listed under the "Quantity Conversions" section found near the bottom of the Measures tab). If a value is not supplied for this field, it will be assumed that the item's Receiving and BASE measure are the same and both the "To" and "From" values will be set to one (1). |
|
N |
ReceiveUMQtyConversionTo |
The numeric Unit of Measure "To" value. This decimal value is used when converting quantities or pricing represented using the Receiving unit of measure to the equivalent value in terms of the BASE measure (and the reverse).
To convert a value (price or qty) from BASE to the Receiving measure, the following calculation is used:
Value * (ReceiveUMQtyConversion / ReceiveUMQtyConversionTo)
To convert a value from Receiving to the BASE measure, the following calculation is used:
Value * (ReceiveUMQtyConversionTo / ReceiveUMQtyConversion)
In Item Maintenance, this field represents the right-hand side conversion value for the Receiving measure (listed under the "Quantity Conversions" section found near the bottom of the Measures tab). If a value is not supplied for this field, it will be assumed that the item's Receiving and BASE measure are the same and both the "To" and "From" values will be set to one (1). |
|
N |
ReceivingUnitofMeasure |
The item's Receiving unit of measure description (code). Units of Measure must be defined from the Code Definitions area before use. If a value is not supplied, the Receiving measure will be assumed to match the item's BASE measure. |
|
N |
ReportSequence |
An item's "Report Sequence" is used to control the order that the item appears when presented in selection listings and in some cases on reports. This is particularly useful when item numbers indicate dimensions such as with lumber/timber products. Report sequence is ordered as text, not numerically, so the value 1 and 1000 would appear before the number "2" when sorted. If you want to use numbers, it's best to pad the digits using zeros (making a sequence 0000001 instead of just 1, for example). Items without a report sequence default to use the item SKU. |
|
Y |
Section |
The section number assigned to this item. Must be an integer between 1 and 255. Section Codes must be defined prior to use. |
|
N |
SellingUnitofMeasure |
The item's Selling unit of measure description (code). Units of Measure must be defined from the Code Definitions area before use. If a value is not supplied, the Selling measure will be assumed to match the item's BASE measure. |
|
N |
SellUMQtyConversion |
The numeric Unit of Measure "From" value. This decimal value is used when converting quantities or pricing represented using the Selling unit of measure to the equivalent value in terms of the BASE measure (and the reverse).
To convert a value (price or qty) from BASE to the Selling measure, the following calculation is used:
Value * (SellUMQtyConversion / SellUMQtyConversionTo)
To convert a value from Selling to the BASE measure, the following calculation is used:
Value * (SellUMQtyConversionTo / SellUMQtyConversion)
In Item Maintenance, this field represents the left-hand side conversion value for the Selling measure (listed under the "Quantity Conversions" section found near the bottom of the Measures tab). If a value is not supplied for this field, it will be assumed that the item's Selling and BASE measure are the same and both the "To" and "From" values will be set to one (1). |
|
N |
SellUMQtyConversionTo |
The numeric Unit of Measure "To" value. This decimal value is used when converting quantities or pricing represented using the Selling unit of measure to the equivalent value in terms of the BASE measure (and the reverse).
To convert a value (price or qty) from BASE to the Selling measure, the following calculation is used:
Value * (SellUMQtyConversion / SellUMQtyConversionTo)
To convert a value from Selling to the BASE measure, the following calculation is used:
Value * (SellUMQtyConversionTo / SellUMQtyConversion)
In Item Maintenance, this field represents the right-hand side conversion value for the Selling measure (listed under the "Quantity Conversions" section found near the bottom of the Measures tab). If a value is not supplied for this field, it will be assumed that the item's Selling and BASE measure are the same and both the "To" and "From" values will be set to one (1). |
|
N |
SuggestedRetail |
This decimal value, if supplied, is used to set the suggested retail (or "list") price for the item being added. Price levels may or may not be based on the suggested list. The default price levels you have defined determine how levels are initially set when new items are added. These defaults are used by the wizard. If no suggested retail (or list) value is supplied, the item will be added with no retail/list price. This can cause the item's price levels to calculate zero prices if they are based on the suggested list. |
|
N |
DaysSupply |
Days Supply. Days supply is an integer (whole number) representing the anticipated number of days that an item should be stocked for when ordering. For example, if this number is 30, a purchase build will consider the quantity necessary to maintain a supply for a 30-day period of time. Days supply is often used to recalculate the maximum quantity when the item's adjustment type is set to "system automated adjustment." This is only true if no Usage Interval is set. Days Supply is also used for calculating the POQDue and COQDue figures which are used for determining order quantities when processing automated purchase order builds. |
|
N |
Disabled |
Disabled Flag. This is a Boolean, or true/false, value field. Disabled items are items that are no longer used. Disabled items don't appear in selection listings and manual entry is prevented. 0 = False (No. This item is not disabled.) 1 = True (Yes. This item IS disabled and is no longer available for selection.) |
|
N |
Discontinued |
Discontinued Flag. This is a Boolean, or true/false, value field that indicates whether an item is discontinued or not. 0 = False (No. This item is not discontinued.) 1 = True (Yes. This item IS discontinued and is no longer available.) Discontinued items are not included on purchase order builds and in some cases produce warnings during use. |
|
N |
DiscountCode |
Discount Code (ie. Net). This integer enumeration determines the discountable status of the item. By the term "discount," we are specifically referring to optional "statement" discounts and line-item discounts. Statement discounts are calculated at time of invoicing and may be applied if the customer pays their receivable bill by the designated discount date. This setting does not affect changes to pricing applied automatically from Point of Sale or as part of the items regular price structure. Choices are as follows: 0 = Discountable (The Item is eligible for Statement Discounts) 1 = Net (No Statement Discounts will be Calculated for this Item.) |
|
N |
ECommerce |
This is a Boolean, or True/False, value field. It is used to indicate which products should be made available for ecommerce use (on-line inquiry, etc.). |
|
N |
ExpectedGrossMargin |
Expected Gross Margin ("Expected %" in Item Maintenance, Branch, Pricing tab). This is the desired gross margin for this item. It is provided for reference but is not used for any calculations, etc. |
|
N |
LeadTime |
Lead Time. This is the number of days between when the item is ordered and when it is received. This might be determined by the vendor, the particulars of the item, or your company's purchasing procedures. For example, a company might purchase widgets from vendor XYZ, but only places orders once every 2 weeks... in this case, the lead time would be 14 (days). Lead time is used during a purchase order build to determine (a) whether an item should be included in the build and (b) to determine what quantity to order. The requirement (or order) quantity is adjusted (reduced) by the quantity of the item expected to be received from Purchase Orders due within the lead time period. This can help avoid duplication when an item already has already been ordered on another Purchase Order and another build is processed. |
|
N |
LFBFDepthDenominator |
Dimensional Depth Denominator. For Lumber/Timber and Sheet Goods products, it's possible to specifydimensions (this is optional). This is an integer field and will always be a whole number (1 or higher). This thedenominator used for specifying depth as a fraction. The denominator is the last or bottom number in the fraction.For example, 8 is the denominator in the fraction 7/8. In cases where a decimal depth or whole number is specified, the denominator is set to one. The measurement system used will vary by region. Dimensions are usedfor calculating initial volume conversion values (board footage, cubic metres, etc.) and in some cases are usedwith Tally items. |
|
N |
LFBFDepthNumerator |
Dimensional Depth Numerator. For Lumber/Timber and Sheet Goods products, it's possible to specify dimensions (this is optional). Depth may be entered as a fraction, decimal, or whole number. In the case of a fraction, the numerator is the first or top number. For example, 3 is the numerator in the fraction 3/4. In the case of decimal or whole number depths, the numerator holds the value and the denominator is set to 1. The measurement system used will vary by region. Dimensions are used for calculating initial volume conversion values (board footage, cubic metres, etc.) and in some cases are used with Tally items. |
|
N |
LFBFLength |
Dimensional Length. Dimensions may be specified for Lumber/Timber and Sheet Goods type items (optionally). Length can be specified as either a whole number or decimal. The measurement system used will vary by region. Dimensions are used for calculating initial volume conversion values (board footage, cubic metres, etc.) and in some cases are used with Tally items. |
|
N |
LFBFWidth |
Dimensional Width. Width can be optionally specified for Lumber/Timber and Sheet Goods item types. If used, the width must be either a decimal or whole number value. The measurement system used will vary by region. Dimensions are used for calculating initial volume conversion values (board footage, cubic metres, etc.) and in some cases are used with Tally items. |
|
N |
LocationCode0 |
Location Code #0 ("Primary" location in Item Maintenance). One of three (3) location codes provided for this item. |
|
N |
LocationCode1 |
Location Code #1 ("Alternate" location in Item Maintenance). One of three (3) location codes provided for this item. |
|
N |
LocationCode2 |
Location Code #2 ("Alternate" location in Item Maintenance). One of three (3) location codes provided for this item. |
|
N |
MaximumQuantity |
Maximum Quantity. If set to a non-zero value, maximum is used for determining the re-order quantity for an item during an automated (PO) build. Maximum should be considered the desired "shelf" quantity to be maintained for a product. Maximum is used for purchase order build calculations and with some reports. Items with a zero minimum and maximum quantity are not included on purchase order builds. Maximum quantity is reflected in the BASE unit of measurement. The Adjustments option from the Purchasing menu can be used to recalculate the maximum based upon any automatic settings. |
|
N |
MinimumGrossMargin |
Minimum Gross Margin Percentage ("Minimum %" in Item Maintenance, Branch, Pricing tab). This percentage represents the lowest gross margin at which your company would consider selling this product. This is used for reference, exception alerts, and some reports. |
|
N |
MinimumQuantity |
Minimum Quantity. If used, this quantity is considered the re-order point for the item. Minimum is the lowest on-hand quantity that should be maintained for the item before re-ordering. Minimum is used for purchase order build calculations and with some reports. Items with a zero minimum and maximum quantity are not included on purchase order builds. Minimum quantity is reflected in the BASE unit of measurement. |
|
N |
PrcPrice0 |
Level 0 Amount. This is either the percentage (discount, markup, or margin) or set price assigned to this level. This is used in conjunction with the PrcType fields to determine the level price. |
|
N |
PrcPrice1 |
Level 1 Amount. This is either the percentage (discount, markup, or margin) or set price assigned to this level. This is used in conjunction with the PrcType fields to determine the level price. |
|
N |
PrcPrice2 |
Level 2 Amount. This is either the percentage (discount, markup, or margin) or set price assigned to this level. This is used in conjunction with the PrcType fields to determine the level price. |
|
N |
PrcPrice3 |
Level 3 Amount. This is either the percentage (discount, markup, or margin) or set price assigned to this level. This is used in conjunction with the PrcType fields to determine the level price. |
|
N |
PrcPrice4 |
Level 4 Amount. This is either the percentage (discount, markup, or margin) or set price assigned to this level. This is used in conjunction with the PrcType fields to determine the level price. |
|
N |
PrcPrice5 |
Level 5 Amount. This is either the percentage (discount, markup, or margin) or set price assigned to this level. This is used in conjunction with the PrcType fields to determine the level price. |
|
N |
PrcPrice6 |
Level 6 Amount. This is either the percentage (discount, markup, or margin) or set price assigned to this level. This is used in conjunction with the PrcType fields to determine the level price. |
|
N |
PrcType0 |
Price Type Level 0. This is an integer enumeration representing the type of pricing used for this level. The enumeration is as follows: 0 = D (Discount % off Suggested List) 1 = M (Markup % over Market Cost) 2 = L (Markup % over Last Receipt Cost) 3 = W (Markup % over Weighted Average Cost) 4 = P (Fixed Price) 5 = C (Margin % using Market Cost) 6 = R (Margin % using Last Receipt Cost) 7 = A (Margin % using Weighted Average Cost) 8 = S (Discount % off Store Retail Level) 9 = X (Markup % Higher of Market or Average) |
|
N |
PrcType1 |
Price Type Level 1. This is an integer enumeration representing the type of pricing used for this level. See PrcType0 for an explanation of the enumeration. |
|
N |
PrcType2 |
Price Type Level 2. This is an integer enumeration representing the type of pricing used for this level. See PrcType0 for an explanation of the enumeration. |
|
N |
PrcType3 |
Price Type Level 3. This is an integer enumeration representing the type of pricing used for this level. See PrcType0 for an explanation of the enumeration. |
|
N |
PrcType4 |
Price Type Level 4. This is an integer enumeration representing the type of pricing used for this level. See PrcType0 for an explanation of the enumeration. |
|
N |
PrcType5 |
Price Type Level 5. This is an integer enumeration representing the type of pricing used for this level. See PrcType0 for an explanation of the enumeration. |
|
N |
PrcType6 |
Price Type Level 6. This is an integer enumeration representing the type of pricing used for this level. See PrcType0 for an explanation of the enumeration. |
|
N |
Weight |
Weight (aka. Load Factor). This is used for calculating weight for deliveries and purchasing, etc. For weight to be used effectively and accurately, ALL weights must be specified using the same measure for ALL products with a weight specified (such as pound (lb.) or Kilogram (Kg), for example). The total weight is calculated taking the weight value times the quantity in BASE measurement terms. |
|
N |
YardFlag |
Yard Flag ("Yard Code" in Item Maintenance, Branch, Codes tab). This code indicates the location of a product in the yard. Items assigned a yard flag (code) will be included on pick ticket style documents. Other documents sometimes print the yard flag if assigned as well. |
Rules for Updating Inventory
The fields available for modifying existing items are different than those permitted for adding. Field names correspond with the names in the Import Wizard's grid, and are not necessarily the same as column names used by the Inventory data tables. Most inventory data is maintained in two separate tables dbo.InventoryCommon (shared item data) and dbo.InventoryStore (branch-specific data). Please note: Suggested List and Prevailing Market Cost were removed from the listing (below) as they cannot be updated using this option. Please see the table below for additional details:
|
Common or Branch |
Field |
Description (for additional details about function, please see the Item Maintenance (database) help topics). |
|---|---|---|
|
C |
AlternateSKU0 |
The primary alternate SKU for the item. Cannot match with any another existing alternate SKU or item. A maximum of 16-characters is allowed. |
|
C |
AlternateSKU1 |
An additional alternate SKU for the item. Must be unique. A maximum of 16-characters is allowed. |
|
C |
AlternateSKU2 |
An additional alternate SKU for the item. Must be unique. A maximum of 16-characters is allowed. |
|
C |
AlternateSKU3 |
An additional alternate SKU for the item. Must be unique. A maximum of 16-characters is allowed. |
|
C |
AlternateSKU4 |
An additional alternate SKU for the item. Must be unique. A maximum of 16-characters is allowed. |
|
C |
AlternateSKUum0 |
The UM (Unit of Measure) associated with AlternateSKU0. Must be a valid Unit of Measure for the item. Unit of measure codes may be up to 4-characters in length. |
|
C |
AlternateSKUum1 |
The UM (Unit of Measure) associated with AlternateSKU1. Must be a valid Unit of Measure for the item. Unit of measure codes may be up to 4-characters in length. |
|
C |
AlternateSKUum2 |
The UM (Unit of Measure) associated with AlternateSKU2. Must be a valid Unit of Measure for the item. Unit of measure codes may be up to 4-characters in length. |
|
C |
AlternateSKUum3 |
The UM (Unit of Measure) associated with AlternateSKU3. Must be a valid Unit of Measure for the item. Unit of measure codes may be up to 4-characters in length. |
|
C |
AlternateSKUum4 |
The UM (Unit of Measure) associated with AlternateSKU4. Must be a valid Unit of Measure for the item. Unit of measure codes may be up to 4-characters in length. |
|
C |
Barcode0 |
The primary numeric barcode (UPC) to be used with this item. A maximum size of 16-characters is allowed. Must be unique to this item. |
|
C |
Barcode1 |
A additional numeric barcode (UPC) to be used with this item. A maximum size of 16-characters is allowed. Must be unique to this item. |
|
C |
Barcode2 |
A additional numeric barcode (UPC) to be used with this item. A maximum size of 16-characters is allowed. Must be unique to this item. |
|
C |
Barcode3 |
A additional numeric barcode (UPC) to be used with this item. A maximum size of 16-characters is allowed. Must be unique to this item. |
|
C |
Barcode4 |
An additional numeric barcode (UPC) to be used with this item. A maximum size of 16-characters is allowed. Must be unique to this item. |
|
C |
BarcodeUM0 |
The UM (Unit of Measure) associated with Barcode0. Must be a valid Unit of Measure for the item. Unit of measure codes may be up to 4-characters in length. |
|
C |
BarcodeUM1 |
The UM (Unit of Measure) associated with Barcode1. Must be a valid Unit of Measure for the item. Unit of measure codes may be up to 4-characters in length. |
|
C |
BarcodeUM2 |
The UM (Unit of Measure) associated with Barcode2. Must be a valid Unit of Measure for the item. Unit of measure codes may be up to 4-characters in length. |
|
C |
BarcodeUM3 |
The UM (Unit of Measure) associated with Barcode3. Must be a valid Unit of Measure for the item. Unit of measure codes may be up to 4-characters in length. |
|
C |
BarcodeUM4 |
The UM (Unit of Measure) associated with Barcode4. Must be a valid Unit of Measure for the item. Unit of measure codes may be up to 4-characters in length. |
|
B |
BuyerId |
Notification Buyer ID. This is the user ID of the purchaser. User IDs may be up to 6-characters in length. The ID must exist. |
|
C |
Class |
The merchandising class code assigned to the product (if any). Maximum of 6-characters. Found on the Common, Codes tab of the Item Maintenance form. |
|
C |
CostPercentage |
Cost Percentage. This decimal value indicates the cost percentage for the item (if any). Up to 4-decimal places are allowed. |
|
C |
Department |
The merchandising department code assigned to the product (if any). Maximum of 6-characters. Found on the Common, Codes tab of the Item Maintenance form. |
|
C |
Description |
The item's description. Maximum of 1,088 characters. |
|
C |
FineLineCode |
The merchandising fine line code assigned to the product (if any). Maximum of 6-characters. Found on the Common, Codes tab of the Item Maintenance form. |
|
C |
Group |
The group number assigned to this item. Must be an integer between 1 and 255. Group Codes must be defined prior to use. |
|
C/B |
ItemNumber |
The code (SKU) to be used for identifying the item. Must match with an existing item. A maximum size of 16-characters. |
|
C |
Keyword0 |
The 1st of 5 possible keywords that may be assigned to this item. Keywords allow a maximum size of 16-characters, are listed on the Common and Select tabs in Item Maintenance. |
|
C |
Keyword1 |
The 2nd of 5 possible keywords that may be assigned to this item. Keywords allow a maximum size of 16-characters, are listed on the Common and Select tabs in Item Maintenance. |
|
C |
Keyword2 |
The 3rd of 5 possible keywords that may be assigned to this item. Keywords allow a maximum size of 16-characters, are listed on the Common and Select tabs in Item Maintenance. |
|
C |
Keyword3 |
The 4th of 5 possible keywords that may be assigned to this item. Keywords allow a maximum size of 16-characters, are listed on the Common and Select tabs in Item Maintenance. |
|
C |
Keyword4 |
The 5th of 5 possible keywords that may be assigned to this item. Keywords allow a maximum size of 16-characters, are listed on the Common and Select tabs in Item Maintenance. |
|
C/B |
PrimaryVendorCode |
The primary vendor code assigned to this item. The code supplied, up to 10-characters in length, must match with an existing vendor that is not a "pay-to" type. |
|
C |
ReportSequence |
An item's "Report Sequence" is used to control the order that the item appears when presented in selection listings and in some cases on reports. This is particularly useful when item numbers indicate dimensions such as with lumber/timber products. Report sequence is ordered as text, not numerically, so the value 1 and 1000 would appear before the number "2" when sorted. If you want to use numbers, it's best to pad the digits using zeros (making a sequence 0000001 instead of just 1, for example). Items without a report sequence default to use the item SKU.
The report sequence can be up to 16-characters in length. |
|
C |
Section |
The section number assigned to this item. Must be an integer between 1 and 255. Section Codes must be defined prior to use. |
|
B |
DaysSupply |
Days Supply. Days supply is an integer (whole number) representing the anticipated number of days that an item should be stocked for when ordering. For example, if this number is 30, a purchase build will consider the quantity necessary to maintain a supply for a 30-day period of time. Days supply is often used to recalculate the maximum quantity when the item's adjustment type is set to "system automated adjustment." This is only true if no Usage Interval is set. Days Supply is also used for calculating the POQDue and COQDue figures which are used for determining order quantities when processing automated purchase order builds. |
|
C |
DescriptionRequired |
Description Required (MiscDescription). This is a Boolean, or true/false, value field that indicates whether an item requires description entry. 0 = False (No. This item does not require description entry) 1 = True (Yes. This item requires description entry.) |
|
B |
Disabled |
Disabled Flag. This is a Boolean, or true/false, value field. Disabled items are items that are no longer used. Disabled items don't appear in selection listings and manual entry is prevented. 0 = False (No. This item is not disabled.) 1 = True (Yes. This item IS disabled and is no longer available for selection.) |
|
B |
Discontinued |
Discontinued Flag. This is a Boolean, or true/false, value field that indicates whether an item is discontinued or not. 0 = False (No. This item is not discontinued.) 1 = True (Yes. This item IS discontinued and is no longer available.) Discontinued items are not included on purchase order builds and in some cases produce warnings during use. |
|
C |
DiscountCode |
Discount Code ("Net," for example). This integer enumeration determines the discountable status of the item. By the term "discount," we are specifically referring to optional "statement" discounts and line-item discounts. Statement discounts are calculated at time of invoicing and may be applied if the customer pays their receivable bill by the designated discount date. This setting does not affect changes to pricing applied automatically from Point of Sale or as part of the items regular price structure. Choices are as follows: 0 = Discountable (The Item is eligible for Statement Discounts) 1 = Net (No Statement Discounts will be Calculated for this Item.) |
|
C |
ECommerce |
This is a Boolean, or True/False, value field. It is used to indicate which products should be made available for ecommerce use (on-line inquiry, etc.). |
|
C |
Estimating |
Estimating Flag. This is a Boolean (true/false) value that's indicated by an integer value of either 0 (false) or 1 (true). 0 = N (No or False) 1 = Y (Yes or True) |
|
B |
ExpectedGrossMargin |
Expected Gross Margin ("Expected %" in Item Maintenance, Branch, Pricing tab). This decimal value indicates the desired gross margin for this item. It is provided for reference but is not used for any calculations, etc. |
|
B |
LeadAdjust |
Lead Adjust (Lead Type). This integer value indicates the type of lead time adjustment. Valid integer values are defined below: 0 = Manual 1 = Automatic |
|
B |
LeadTime |
Lead Time. This integer value is the number of days between when the item is ordered and when it is received. This might be determined by the vendor, the particulars of the item, or your company's purchasing procedures. For example, a company might purchase widgets from vendor XYZ, but only places orders once every two weeks... in this case, the lead time would be 14 (days). Lead time is used during a purchase order build to determine (a) whether an item should be included in the build and (b) to determine what quantity to order. The requirement (or order) quantity is adjusted (reduced) by the quantity of the item expected to be received from Purchase Orders due within the lead time period. This can help avoid duplication when an item already has already been ordered on another Purchase Order and another build is processed. |
|
B |
LocationCode0 |
Location Code #0 ("Primary" location in Item Maintenance). One of three location codes provided for this item. Location codes can be a maximum of 8-characters in length. |
|
B |
LocationCode1 |
Location Code #1 ("Alternate" location in Item Maintenance). One of three location codes provided for this item. Location codes can be a maximum of 8-characters in length. |
|
B |
LocationCode2 |
Location Code #2 ("Alternate" location in Item Maintenance). One of three location codes provided for this item. Location codes can be a maximum of 8-characters in length. |
|
B |
MaximumQuantity |
Maximum Quantity. If this integer value is set to a non-zero value, maximum is used for determining the re-order quantity for an item during an automated (PO) build. Maximum should be considered the desired "shelf" quantity to be maintained for a product. Maximum is used for purchase order build calculations and with some reports. Items with a zero minimum and maximum quantity are not included on purchase order builds. Maximum quantity is reflected in the BASE unit of measurement. The Adjustments option from the Purchasing menu can be used to recalculate the maximum based upon any automatic settings. |
|
B |
MaxQtyAdjType |
Maximum Quantity Adjustment Type. This integer enumeration determines if the item's maximum quantity should be automatically adjusted. The enumeration is defined below: 0 = Manual 1 = Automatic |
|
B |
MinimumGrossMargin |
Minimum Gross Margin Percentage ("Minimum %" in Item Maintenance, Branch, Pricing tab). This decimal value indicates the percentage for the lowest gross margin at which your company would consider selling this product. This is used for reference, exception alerts, and some reports. |
|
B |
MinimumQuantity |
Minimum Quantity. If used, this integer quantity is considered the re-order point for the item. Minimum is the lowest on-hand quantity that should be maintained for the item before re-ordering. Minimum is used for purchase order build calculations and with some reports. Items with a zero minimum and maximum quantity are not included on purchase order builds. Minimum quantity is reflected in the BASE unit of measurement. |
|
B |
MinQtyAdjType |
Minimum Quantity Adjustment Type. This is an integer enumeration that determines if and how the item's minimum quantity is to be adjusted. The enumeration is defined below: 0 = Manual 1 = Percentage of Maximum 2 = Automatic |
|
B |
MinQtyPercentofMax |
Minimum Quantity Percentage of Maximum Quantity. This requires a decimal value (up to 4-decimal places). This would only be used in cases where the item's MinQtyAdjType was set to "Percentage of Maximum" (1). |
|
B |
PhysCtUM |
Physical Count Unit of Measure Default. This is an integer value that indicates which of the item's five (5) units of measure should be used as the default for quantity entry as physical inventory counts. Choices include the following: 0 = Stock (Base) 1 = Selling 2 = Pricing 3 = Receiving 4 = Miscellaneous |
|
B |
POSQtyUM |
Point of Sale Quantity Unit of Measure Default. This is an integer value that indicates which of the item's five (5) units of measure should be used as the default for quantity entry during Point of Sale transactions. Choices include the following: 0 = Stock (Base) 1 = Selling 2 = Pricing 3 = Receiving 4 = Miscellaneous |
|
B |
POSPriceUM |
Point of Sale Pricing Unit of Measure Default. This is an integer value that indicates which of the item's five (5) units of measure should be used as the default for pricing displayed during Point of Sale transactions. Choices include the following: 0 = Stock (Base) 1 = Selling 2 = Pricing 3 = Receiving 4 = Miscellaneous |
|
B |
POSPriceUpdateUM |
Price Updates Unit of Measure Default. This is an integer value that indicates which of the item's five (5) units of measure should be used as the default for pricing when creating price updates via the Inventory area. Choices include the following: 0 = Stock (Base) 1 = Selling 2 = Pricing 3 = Receiving 4 = Miscellaneous |
|
B |
PORecptQtyUM |
Purchasing Receipt Quantity Unit of Measure Default. This is an integer value that indicates which of the item's five (5) units of measure should be used as the default for quantity entry for Purchase Orders and Receipts. Choices include the following: 0 = Stock (Base) 1 = Selling 2 = Pricing 3 = Receiving 4 = Miscellaneous |
|
B |
PORecptCostUM |
Purchasing Receipt Cost Unit of Measure Default. This is an integer value that indicates which of the item's five (5) units of measure should be used as the default for costs displayed for Purchase Orders and Receipts. Choices include the following: 0 = Stock (Base) 1 = Selling 2 = Pricing 3 = Receiving 4 = Miscellaneous |
|
B |
PrcPrice0 |
Level 0 Amount. This decimal value is either the percentage (discount, markup, or margin) or set price assigned to this level. This is used in conjunction with the PrcType fields to determine the level price. |
|
B |
PrcPrice1 |
Level 1 Amount. This decimal value is either the percentage (discount, markup, or margin) or set price assigned to this level. This is used in conjunction with the PrcType fields to determine the level price. |
|
B |
PrcPrice2 |
Level 2 Amount. This decimal value is either the percentage (discount, markup, or margin) or set price assigned to this level. This is used in conjunction with the PrcType fields to determine the level price. |
|
B |
PrcPrice3 |
Level 3 Amount. This decimal value is either the percentage (discount, markup, or margin) or set price assigned to this level. This is used in conjunction with the PrcType fields to determine the level price. |
|
B |
PrcPrice4 |
Level 4 Amount. This decimal value is either the percentage (discount, markup, or margin) or set price assigned to this level. This is used in conjunction with the PrcType fields to determine the level price. |
|
B |
PrcPrice5 |
Level 5 Amount. This decimal value is either the percentage (discount, markup, or margin) or set price assigned to this level. This is used in conjunction with the PrcType fields to determine the level price. |
|
B |
PrcPrice6 |
Level 6 Amount. This decimal value is either the percentage (discount, markup, or margin) or set price assigned to this level. This is used in conjunction with the PrcType fields to determine the level price. |
|
B |
PrcType0 |
Price Type Level 0. This is an integer enumeration representing the type of pricing used for this level. The enumeration is as follows: 0 = D (Discount % off Suggested List) 1 = M (Markup % over Market Cost) 2 = L (Markup % over Last Receipt Cost) 3 = W (Markup % over Weighted Average Cost) 4 = P (Fixed Price) 5 = C (Margin % using Market Cost) 6 = R (Margin % using Last Receipt Cost) 7 = A (Margin % using Weighted Average Cost) 8 = S (Discount % off Store Retail Level) 9 = X (Markup % Higher of Market or Average) |
|
B |
PrcType1 |
Price Type Level 1. This is an integer enumeration representing the type of pricing used for this level. See PrcType0 for an explanation of the enumeration. |
|
B |
PrcType2 |
Price Type Level 2. This is an integer enumeration representing the type of pricing used for this level. See PrcType0 for an explanation of the enumeration. |
|
B |
PrcType3 |
Price Type Level 3. This is an integer enumeration representing the type of pricing used for this level. See PrcType0 for an explanation of the enumeration. |
|
B |
PrcType4 |
Price Type Level 4. This is an integer enumeration representing the type of pricing used for this level. See PrcType0 for an explanation of the enumeration. |
|
B |
PrcType5 |
Price Type Level 5. This is an integer enumeration representing the type of pricing used for this level. See PrcType0 for an explanation of the enumeration. |
|
B |
PrcType6 |
Price Type Level 6. This is an integer enumeration representing the type of pricing used for this level. See PrcType0 for an explanation of the enumeration. |
|
B |
PriceMatrix |
Price Matrix Code. This code, up to 4-characters in length, indicates the price matrix code for the item (if any). Matrix codes must be defined before use. |
|
C |
PriceRounding |
Price Rounding Code. This is an integer enumeration representing the code for rounding pricing. 0 = No rounding 1 = Round to .01 2 = Round to .09 3 = Round to $1 4 = Round to $5 5 = Ace Rounding 6 = Price Range 7 = Cent Range 8 = Round to .001 |
|
C |
ProductId |
Product ID (code). This code, up to 16-characters in length, indicates the product ID for the item (if any). The code must already exist. These codes are defined from the Code Definitions maintenance form or can originate with Do it Best Corp.'s product codes (which must be loaded prior to use). |
|
B |
QtyBreak0 |
Quantity Break Minimum. The first (1st) of four (4) possible quantity breaks you can define for volume pricing. This integer value is the minimum quantity in base terms required to receive a volume discount at this level. |
|
B |
QtyBreak1 |
Quantity Break Minimum. The second (2nd) of four (4) possible quantity breaks you can define for volume pricing. This integer value is the minimum quantity in base terms required to receive a volume discount at this level. |
|
B |
QtyBreak2 |
Quantity Break Minimum. The third (3rd) of four (4) possible quantity breaks you can define for volume pricing. This integer value is the minimum quantity in base terms required to receive a volume discount at this level. |
|
B |
QtyBreak3 |
Quantity Break Minimum. The last of four (4) possible quantity breaks you can define for volume pricing. This integer value is the minimum quantity in base terms required to receive a volume discount at this level. |
|
B |
QtyPrice0 |
Amount for the Break Price (aka. Volume Discount). This decimal value is the amount to be applied as the first (1st) of four (4) possible quantity breaks. The "amount" may represent either a set price or percentage as determined by the QtyType0 value. The QtyBreak0 value determines the minimum quantity purchase required for receiving the break price. Up to 4-decimal places are permitted. |
|
B |
QtyPrice1 |
Amount for the Break Price (aka. Volume Discount). This decimal value is the amount to be applied as the second (2nd) of four (4) possible quantity breaks. The "amount" may represent either a set price or percentage as determined by the QtyType1 value. The QtyBreak1 value determines the minimum quantity purchase required for receiving the break price. Up to 4-decimal places are permitted. |
|
B |
QtyPrice2 |
Amount for the Break Price (aka. Volume Discount). This decimal value is the amount to be applied as the third (3rd) of four (4) possible quantity breaks. The "amount" may represent either a set price or percentage as determined by the QtyType2 value. The QtyBreak2 value determines the minimum quantity purchase required for receiving the break price. Up to 4-decimal places are permitted. |
|
B |
QtyPrice3 |
Amount for the Break Price (aka. Volume Discount). This decimal value is the amount to be applied as the last of four (4) possible quantity breaks. The "amount" may represent either a set price or percentage as determined by the QtyType3 value. The QtyBreak3 value determines the minimum quantity purchase required for receiving the break price. Up to 4-decimal places are permitted. |
|
C |
QtyRounding |
Quantity Rounding. This is a Boolean (true/false) value that's indicated by an integer value of either 0 (false) or 1 (true). 0 = N (No or False) 1 = Y (Yes or True) |
|
B |
QtyType0 |
Price Type for Break Price (aka. Volume Discount). This integer enumeration indicates how the QtyPrice0 value is used for calculation or setting of the break price the customer receives for the first of the four (4) possible quantity breaks (if they meet the QtyBreak0 minimum quantity). The enumeration is defined below: 0 = D (Discount % off Suggested List) 1 = M (Markup % over Market Cost) 2 = L (Markup % over Last Receipt Cost) 3 = W (Markup % over Weighted Average Cost) 4 = % (Additional % off Customer Price) 5 = $ (Dollar Amount off Suggested List) 6 = C (Margin % using Market Cost) 7 = R (Margin % using Last Receipt Cost) 8 = A (Margin % using Weighted Average Cost) 9 = S (Discount % off Store Retail Level) |
|
B |
QtyType1 |
Price Type for Break Price or Volume Discount. This integer enumeration indicates how the QtyPrice1 value is used for calculation or setting of the break price the customer receives for the second (2nd) of the four (4) possible quantity breaks (if they meet the QtyBreak1 minimum quantity). The enumeration is defined below (0 is the default): 0 = D (Discount % off Suggested List) 1 = M (Markup % over Market Cost) 2 = L (Markup % over Last Receipt Cost) 3 = W (Markup % over Weighted Average Cost) 4 = % (Additional % off Customer Price) 5 = $ (Dollar Amount off Suggested List) 6 = C (Margin % using Market Cost) 7 = R (Margin % using Last Receipt Cost) 8 = A (Margin % using Weighted Average Cost) 9 = S (Discount % off Store Retail Level) |
|
B |
QtyType2 |
Price Type for Break Price or Volume Discount. This integer enumeration indicates how the QtyPrice2 value is used for calculation or setting of the break price the customer receives for the third (3rd) of the four (4) possible quantity breaks (if they meet the QtyBreak2 minimum quantity). The enumeration is defined below (0 is the default): 0 = D (Discount % off Suggested List) 1 = M (Markup % over Market Cost) 2 = L (Markup % over Last Receipt Cost) 3 = W (Markup % over Weighted Average Cost) 4 = % (Additional % off Customer Price) 5 = $ (Dollar Amount off Suggested List) 6 = C (Margin % using Market Cost) 7 = R (Margin % using Last Receipt Cost) 8 = A (Margin % using Weighted Average Cost) 9 = S (Discount % off Store Retail Level) |
|
B |
QtyType3 |
Price Type for Break Price or Volume Discount. This integer enumeration indicates how the QtyPrice3 value is used for calculation or setting of the break price the customer receives for the last of the four (4) possible quantity breaks (if they meet the QtyBreak3 minimum quantity). The enumeration is defined below (0 is the default): 0 = D (Discount % off Suggested List) 1 = M (Markup % over Market Cost) 2 = L (Markup % over Last Receipt Cost) 3 = W (Markup % over Weighted Average Cost) 4 = % (Additional % off Customer Price) 5 = $ (Dollar Amount off Suggested List) 6 = C (Margin % using Market Cost) 7 = R (Margin % using Last Receipt Cost) 8 = A (Margin % using Weighted Average Cost) 9 = S (Discount % off Store Retail Level) |
|
C |
Rebate |
Rebate Code. This code, up to 6-characters in length, indicates the product rebate code for the item. Any code indicated must already exist. These codes are defined from the Code Definitions maintenance form. |
|
B |
SeasonalCode |
Seasonal Code. This code, up to 4-characters in length, indicates the seasonal code for the item (if any) and is used for purchasing. Seasonal codes must be defined prior to use. |
|
B |
Stocked |
Stocked (vs. Non-stocked). This is a Boolean (true/false) value that's indicated by an integer value of either 0 (false) or 1 (true). 0 = N (No or False) 1 = Y (Yes or True) |
|
B |
SubstituteSKU |
Substitute SKU (Item). This item SKU, up to 16-characters in length, must exist in the current branch and cannot be a "tally" type item. |
|
B |
Returnable |
Returnable. This is a Boolean (true/false) value that's indicated by an integer value of either 0 (false) or 1 (true). 0 = N (No or False) 1 = Y (Yes or True) |
|
C |
TagIDRequired |
Tag ID Required. This is a Boolean (true/false) value that's indicated by an integer value of either 0 (false) or 1 (true). 0 = N (No or False) 1 = Y (Yes or True) |
|
C |
Taxable |
Taxable Code (Flag). This is an integer enumeration representing the taxable status of the item. Some options only apply to software users in Canada or the United Kingdom (UK) only. 0 = Yes 1 = No 2 = Always 3 = VAT (UK Only) 4 = GST (Canada Only) 5 = PST (Canada Only) |
|
C |
TaxSurcharge |
Tax Surcharge. This is a Boolean (true/false) value that's indicated by an integer value of either 0 (false) or 1 (true). 0 = N (No or False) 1 = Y (Yes or True) |
|
C |
TrackQtyOnHand |
Track Quantity On-hand (aka. Maintain Receipts). This is a Boolean (true/false) value that's indicated by an integer value of either 0 (false) or 1 (true). 0 = N (No or False) 1 = Y (Yes or True) |
|
B |
UsageInt |
Usage Interval. This integer value is used for purchasing. |
|
C |
Weight |
Weight (aka. Load Factor). This decimal value (up to 4-decimal places) is used for calculating weight for deliveries and purchasing, etc. For weight to be used effectively and accurately, ALL weights must be specified using the same measure for ALL products with a weight specified (such as pound (lb.) or Kilogram (Kg), for example). The total weight is calculated taking the weight value times the quantity in BASE measurement terms. |
|
B |
WMSItem |
WMS (Warehouse Management) item flag. This is a Boolean (true/false) value that's indicated by an integer value of either 0 (false) or 1 (true). This is only used by the WMS app, a separately priced feature and is not shown in Item Maintenance unless enabled. 0 = N (No or False) 1 = Y (Yes or True) |
|
C |
YardFlag |
Yard Flag ("Yard Code" in Item Maintenance, Branch, Codes tab). This 2-character code indicates the location of a product in the yard. Items assigned a yard flag (code) will be included on pick ticket style documents. Other documents sometimes print the yard flag if assigned as well. |