Navigation:  Inventory > Technical References >   Product table

Many fields in the Product table apply mainly to the Sales and Purchasing modules.

 
Adding and deleting Products and maintaining common fields occurs in the Product maintenance task.

 
Sales-related fields are maintained in the Product Sales maintenance task.

 
Purchasing-related fields are maintained in the Product Purchasing maintenance task.

 

Field names below are the typical field names shown on forms.
Some of these are slightly different than the actual field names in the underlying table. In particular, actual field names do not have embedded spaces and field names of logical fields such as IsActive are prefixed by ‘Is’.

 

Fields marked (d) will initially be set to the values for the corresponding Product Group when a new Product is inserted.

 

ProductID

This identifies the Product.

 

ProductSID

The surrogate key assigned by the system for this Product. Usually not shown on forms.

 

Description

This describes the Product.

 

Product GroupID

This specifies the Product Group for this Product.

 

Unit of Stock

This specifies the Unit of Measure for Inventory of the Product.

 

Unit of Sale

This specifies the standard Unit of Measure for Sales of the Product.

 

Unit of Purchase

This specifies the standard Unit of Measure for Purchasing the Product.

 

IsIssueReceiptQuantityDecimal

Checked means an Issue Quantity or a Receipt Quantity must be an integral value (e.g. it may NOT be a decimal value)

Unchecked means an Issue Quantity or a Receipt Quantity may be a decimal value

This field is used within the Inventory module and maintained in Product maintenance where it is captioned Decimal Quantity.

 

IsSalesOrderQuantityDecimal

Checked means a Sales Order Quantity must be an integral value (e.g. it may NOT be a decimal value)

Unchecked means a Sales Order Quantity may be a decimal value

This field is used within the Sales module and maintained in Product Sales maintenance where it is captioned Decimal Quantity.

 

IsPurchaseOrderQuantityDecimal

Checked means a Purchase Order Quantity must be an integral value (e.g. it may NOT be a decimal value)

Unchecked means a Purchase Order Quantity may be a decimal value

This field is used within the Purchasing module and maintained in Product Purchasing maintenance where it is captioned Decimal Quantity.

 

Active

Checked means this Product is Active.
Unchecked means this Product is not Active.
Only Active Products are presented in data entry lookup lists or available for Product List maintenance.

 

Service(d)

Checked means this Product is a Service.
Unchecked means this Product is not a Service.
Services do not have OnHand Quantity or OnHand Available Quantity.

 

SalesTax Taxable(d)

Countries with SalesTax.
Checked means Sales Tax usually applies to this Product.
Unchecked means Sales Tax does not usually apply to this Product.
This field is used within the Sales module and maintained in Product Sales maintenance.

 

Pick Slip

This determines whether or not the Product will be printed on a Picking Slip in the Sales Orders | Reports | Print Picking Slips task.
Checked means it will be printed. Unchecked means it will not be printed.
This field is maintained in Product Sales maintenance.

 

Vat Code(d)

U.S.A. Unused.
Gst/Vat countries. The applicable Vat/Gst code for the Product.

 

Sales Discount Code(d)

The Product Sales Discount Code corresponds to an entry in the Sales Discount rate table. This field is used within the Sales module and maintained in Product Sales maintenance.

 

Sales Commission Code(d)

The Product Sales Commission Code corresponds to an entry in the Sales Commission rate table.
This field is used within the Sales module and maintained in Product Sales maintenance.

 

Standard Cost

Enables directly specifying a standard cost for this Product for use within the Bill of Materials module. This standard cost is not affected by changes to the Average Cost.

 

Average Cost

This is the current all-Warehouse Average (FIFO or LIFO) Cost per unit of this Product.

 

Notes

This Memo field is used for any supplementary information about this Product.

 

OriginDate

The date when this Product record was created.

 

OriginUserID

The UserID of the user who created this Product record.

 

OriginTaskID

The TaskID of the task that created this Product record.