ManPageW Product

From ADempiere
Jump to: navigation, search

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



Window: Product

Description : Maintain Products

Help : The Product Window defines all products used by an organization. These products include those sold to customers, used in the manufacture of products sold to customers and products purchased by an organization.



Tab: Product

Description : Define Product

Help : The Product Tab defines each product and identifies it for use in price lists and orders. The Location is the default location when receiving the stored product.

Table Name  : M_Product

ManPageW Product Product.png

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Search Key Search key for the record in the format required - must be unique A search key allows you a fast method of finding a particular record.

If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

Value

NVARCHAR2(510)

String

Version No Version Number VersionNo

NVARCHAR2(20)

String

Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name

NVARCHAR2(510)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Comment/Help Comment or Hint The Help field contains a hint, comment or help about the use of this item. Help

NVARCHAR2(2000)

Text

Document Note Additional information for a Document The Document Note is used for recording any additional information regarding this product. DocumentNote

NVARCHAR2(2000)

Text

UPC/EAN Bar Code (Universal Product Code or its superset European Article Number) Use this field to enter the bar code for the product in any of the bar code symbologies (Codabar, Code 25, Code 39, Code 93, Code 128, UPC (A), UPC (E), EAN-13, EAN-8, ITF, ITF-14, ISBN, ISSN, JAN-13, JAN-8, POSTNET and FIM, MSI/Plessey, and Pharmacode) UPC

VARCHAR2

String

SKU Stock Keeping Unit The SKU indicates a user defined stock keeping unit. It may be used for an additional bar code symbols or your own schema. SKU

VARCHAR2

String

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Summary Level This is a summary entity A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values. IsSummary

CHAR(1)

YesNo

Product Category Category of a Product Identifies the category which this product belongs to. Product categories are used for pricing and selection. M_Product_Category_ID

NUMBER(10)

TableDir

Classification Classification for grouping The Classification can be used to optionally group products. Classification

CHAR(1)

String

Tax Category Tax Category The Tax Category provides a method of grouping similar taxes. For example, Sales Tax or Value Added Tax. C_TaxCategory_ID

NUMBER(10)

TableDir

Revenue Recognition Method for recording revenue The Revenue Recognition indicates how revenue will be recognized for this product C_RevenueRecognition_ID

NUMBER(10)

TableDir

UOM Unit of Measure The UOM defines a unique non monetary Unit of Measure C_UOM_ID

NUMBER(10)

TableDir

Company Agent Purchase or Company Agent Purchase agent for the document. Any Sales Rep must be a valid internal user. SalesRep_ID

NUMBER(10)

Table

Product Type Type of product The type of product also determines accounting consequences. ProductType

CHAR(1)

List

Mail Template Text templates for mailings The Mail Template indicates the mail template for return messages. Mail text can include variables. The priority of parsing is User/Contact, Business Partner and then the underlying business object (like Request, Dunning, Workflow object).

So, @Name@ would resolve into the User name (if user is defined defined), then Business Partner name (if business partner is defined) and then the Name of the business object if it has a Name.
For Multi-Lingual systems, the template is translated based on the Business Partner's language selection.

R_MailText_ID

NUMBER(10)

TableDir

Weight Weight of a product The Weight indicates the weight of the product in the Weight UOM of the Client Weight

NUMBER

Amount

Volume Volume of a product The Volume indicates the volume of the product in the Volume UOM of the Client Volume

NUMBER

Amount

Freight Category Category of the Freight Freight Categories are used to calculate the Freight for the Shipper selected M_FreightCategory_ID

NUMBER(10)

TableDir

Drop Shipment Drop Shipments are sent from the Vendor directly to the Customer Drop Shipments do not cause any Inventory reservations or movements as the Shipment is from the Vendor's inventory. The Shipment of the Vendor to the Customer must be confirmed. IsDropShip

CHAR(1)

YesNo

Stocked Organization stocks this product The Stocked check box indicates if this product is stocked by this Organization. IsStocked

CHAR(1)

YesNo

Locator Warehouse Locator The Locator indicates where in a Warehouse a product is located. M_Locator_ID

NUMBER(10)

Locator

Shelf Width Shelf width required The Shelf Width indicates the width dimension required on a shelf for a product ShelfWidth

NUMBER(10)

Integer

Shelf Height Shelf height required The Shelf Height indicates the height dimension required on a shelf for a product ShelfHeight

NUMBER(10)

Integer

Shelf Depth Shelf depth required The Shelf Depth indicates the depth dimension required on a shelf for a product ShelfDepth

NUMBER(10)

Integer

Units Per Pallet Units Per Pallet The Units per Pallet indicates the number of units of this product which fit on a pallet. UnitsPerPallet

NUMBER(10)

Integer

Bill of Materials Bill of Materials The Bill of Materials check box indicates if this product consists of a bill of materials. IsBOM

CHAR(1)

YesNo

Verified The BOM configuration has been verified The Verified check box indicates if the configuration of this product has been verified. This is used for products that consist of a bill of materials IsVerified

CHAR(1)

YesNo

Verify BOM Verify BOM Structure The Verify BOM Structure checks the elements and steps which comprise a Bill of Materials. Processing

CHAR(1)

Button

Print detail records on invoice Print detail BOM elements on the invoice The Print Details on Invoice indicates that the BOM element products will print on the Invoice as opposed to this product. IsInvoicePrintDetails

CHAR(1)

YesNo

Print detail records on pick list Print detail BOM elements on the pick list The Print Details on Pick List indicates that the BOM element products will print on the Pick List as opposed to this product. IsPickListPrintDetails

CHAR(1)

YesNo

Purchased Organization purchases this product The Purchased check box indicates if this product is purchased by this organization. IsPurchased

CHAR(1)

YesNo

Sold Organization sells this product The Sold check box indicates if this product is sold by this organization. IsSold

CHAR(1)

YesNo

Discontinued This product is no longer available The Discontinued check box indicates a product that has been discontinued. Discontinued

CHAR(1)

YesNo

Discontinued by Discontinued By The Discontinued By indicates the individual who discontinued this product DiscontinuedBy

DATE

Date

Expense Type Expense report type S_ExpenseType_ID

NUMBER(10)

TableDir

Resource Resource S_Resource_ID

NUMBER(10)

TableDir

Subscription Type Type of subscription Subscription type and renewal frequency C_SubscriptionType_ID

NUMBER(10)

ID

Exclude Auto Delivery Exclude from automatic Delivery The product is excluded from generating Shipments. This allows manual creation of shipments for high demand items. If selected, you need to create the shipment manually.

But, the item is always included, when the delivery rule of the Order is Force (e.g. for POS). This allows finer granularity of the Delivery Rule Manual.

IsExcludeAutoDelivery

CHAR(1)

YesNo

Image URL URL of image URL of image; The image is not stored in the database, but retrieved at runtime. The image can be a gif, jpeg or png. ImageURL

NVARCHAR2(120)

Unknown (40)

Description URL URL for the description DescriptionURL

NVARCHAR2(120)

Unknown (40)

Guarantee Days Number of days the product is guaranteed or available If the value is 0, there is no limit to the availability or guarantee, otherwise the guarantee date is calculated by adding the days to the delivery date. GuaranteeDays

NUMBER(10)

Integer

Min Guarantee Days Minumum number of guarantee days When selecting batch/products with a guarantee date, the minimum left guarantee days for automatic picking. You can pick any batch/product manually. GuaranteeDaysMin

NUMBER(10)

Integer

Attribute Set Product Attribute Set Define Product Attribute Sets to add additional attributes and values to the product. You need to define a Attribute Set if you want to enable Serial and Lot Number tracking. M_AttributeSet_ID

NUMBER(10)

TableDir

Attribute Set Instance Product Attribute Values The values of the actual Product Attributes. Product Instance attributes are defined in the actual transactions. M_AttributeSetInstance_ID

NUMBER(10)

ProductAttribute

Featured in Web Store If selected, the product is displayed in the inital or any empy search In the display of products in the Web Store, the product is displayed in the inital view or if no search criteria are entered. To be displayed, the product must be in the price list used. IsWebStoreFeatured

CHAR(1)

YesNo

Self-Service This is a Self-Service entry or this entry can be changed via Self-Service Self-Service allows users to enter data or update their data. The flag indicates, that this record was entered or created via Self-Service or that the user can change it via the Self-Service functionality. IsSelfService

CHAR(1)

YesNo

Group1 Group1

NVARCHAR2(255)

String

Group2 Group2

NVARCHAR2(255)

String


Tab: Bill of Materials

Description : Bill of Material product lines

Help : The Bill of Materials tab defines those products that are generated from other products. A Bill of Material (BOM) is one or more Products or BOMs.

Available Quantity: - Stored BOMs have to be created via "Production" - The available quantity of a non-stored BOMs is dynamically calculated - The attribute "Stored" is defined in the "Product" tab

Price: - BOMs must be listed in Pricelists - If the price is 0.00, the price is dynamically calculated

Printing: - Usually, only the BOM information is printed - For invoices, delivery slips and pick lists, you have the option to print the details - In the details, the quantity is listed - and the price, if this is dynamically calculated


Table Name  : M_Product_BOM

ManPageW Product BillofMaterials.png

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

Line No Unique line for this document Indicates the unique line for a document. It will also control the display order of the lines within a document. Line

NUMBER(10)

Integer

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

BOM Type Type of BOM The type of Bills of Materials determines the state BOMType

CHAR(1)

List

BOM Product Bill of Material Component Product The BOM Product identifies an element that is part of this Bill of Materials. M_ProductBOM_ID

NUMBER(10)

Search

BOM Quantity Bill of Materials Quantity The BOM Quantity indicates the quantity of the product in its Unit of Measure (multiplication) BOMQty

NUMBER

Quantity


Tab: Substitute

Description : Define Substitute

Help : The Substitute Tab defines products which may be used as a replacement for the selected product.

Table Name  : M_Substitute

ManPageW Product Substitute.png

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Substitute Entity which can be used in place of this entity The Substitute identifies the entity to be used as a substitute for this entity. Substitute_ID

NUMBER(10)

Search


Tab: Related

Description : Related Product

Help : Related Product - e.g. for promotions

Table Name  : M_RelatedProduct

ManPageW Product Related.png

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

Text

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Related Product Type RelatedProductType

CHAR(1)

List

Related Product Related Product RelatedProduct_ID

NUMBER(10)

Search


Tab: Replenish

Description : Define Product Replenishment

Help : The Replenishment Tab defines the type of replenishment quantities. This is used for automated ordering. If you select a custom replenishment type, you need to create a class implementing org.compiere.util.ReplenishInterface and set that on warehouse level.

Table Name  : M_Replenish

ManPageW Product Replenish.png

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

Warehouse Storage Warehouse and Service Point The Warehouse identifies a unique Warehouse where products are stored or Services are provided. M_Warehouse_ID

NUMBER(10)

TableDir

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Replenish Type Method for re-ordering a product The Replenish Type indicates if this product will be manually re-ordered, ordered when the quantity is below the minimum quantity or ordered when it is below the maximum quantity. If you select a custom replenishment type, you need to create a class implementing org.compiere.util.ReplenishInterface and set that on warehouse level. ReplenishType

CHAR(1)

List

Minimum Level Minimum Inventory level for this product Indicates the minimum quantity of this product to be stocked in inventory. Level_Min

NUMBER

Amount

Maximum Level Maximum Inventory level for this product Indicates the maximum quantity of this product to be stocked in inventory. Level_Max

NUMBER

Amount

Source Warehouse Optional Warehouse to replenish from If defined, the warehouse selected is used to replenish the product(s) M_WarehouseSource_ID

NUMBER(10)

Table


Tab: Purchasing

Description : Purchasing

Help : The Purchasing Tab define the pricing and rules ( pack quantity, UPC, minimum order quantity) for each product.

Table Name  : M_Product_PO

ManPageW Product Purchasing.png

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

Business Partner Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson C_BPartner_ID

NUMBER(10)

Search

Quality Rating Method for rating vendors The Quality Rating indicates how a vendor is rated (higher number = higher quality) QualityRating

NUMBER

Integer

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Current vendor Use this Vendor for pricing and stock replenishment The Current Vendor indicates if prices are used and Product is reordered from this vendor IsCurrentVendor

CHAR(1)

YesNo

UPC/EAN Bar Code (Universal Product Code or its superset European Article Number) Use this field to enter the bar code for the product in any of the bar code symbologies (Codabar, Code 25, Code 39, Code 93, Code 128, UPC (A), UPC (E), EAN-13, EAN-8, ITF, ITF-14, ISBN, ISSN, JAN-13, JAN-8, POSTNET and FIM, MSI/Plessey, and Pharmacode) UPC

NVARCHAR2(20)

String

Currency The Currency for this record Indicates the Currency to be used when processing or reporting on this record C_Currency_ID

NUMBER(10)

TableDir

List Price List Price The List Price is the official List Price in the document currency. PriceList

NUMBER

CostsPrices

Price effective Effective Date of Price The Price Effective indicates the date this price is for. This allows you to enter future prices for products which will become effective when appropriate. PriceEffective

DATE

Date

PO Price Price based on a purchase order The PO Price indicates the price for a product per the purchase order. PricePO

NUMBER

CostsPrices

Royalty Amount (Included) Amount for copyright, etc. RoyaltyAmt

NUMBER

Amount

Last PO Price Price of the last purchase order for the product The Last PO Price indicates the last price paid (per the purchase order) for this product. PriceLastPO

NUMBER

CostsPrices

Last Invoice Price Price of the last invoice for the product The Last Invoice Price indicates the last price paid (per the invoice) for this product. PriceLastInv

NUMBER

CostsPrices

UOM Unit of Measure The UOM defines a unique non monetary Unit of Measure C_UOM_ID

NUMBER(10)

TableDir

Minimum Order Qty Minimum order quantity in UOM The Minimum Order Quantity indicates the smallest quantity of this product which can be ordered. Order_Min

NUMBER

Quantity

Order Pack Qty Package order size in UOM (e.g. order set of 5 units) The Order Pack Quantity indicates the number of units in each pack of this product. Order_Pack

NUMBER

Quantity

Promised Delivery Time Promised days between order and delivery The Promised Delivery Time indicates the number of days between the order date and the date that delivery was promised. DeliveryTime_Promised

NUMBER(10)

Integer

Actual Delivery Time Actual days between order and delivery The Actual Delivery Time indicates the number of days elapsed between placing an order and the delivery of the order DeliveryTime_Actual

NUMBER(10)

Integer

Cost per Order Fixed Cost Per Order The Cost Per Order indicates the fixed charge levied when an order for this product is placed. CostPerOrder

NUMBER

CostsPrices

Partner Product Key Product Key of the Business Partner The Business Partner Product Key identifies the number used by the Business Partner for this product. It can be printed on orders and invoices when you include the Product Key in the print format. VendorProductNo

NVARCHAR2(30)

String

Partner Category Product Category of the Business Partner The Business Partner Category identifies the category used by the Business Partner for this product. VendorCategory

NVARCHAR2(30)

String

Manufacturer Manufacturer of the Product The manufacturer of the Product (used if different from the Business Partner / Vendor) Manufacturer

NVARCHAR2(30)

String

Discontinued This product is no longer available The Discontinued check box indicates a product that has been discontinued. Discontinued

CHAR(1)

YesNo

Discontinued by Discontinued By The Discontinued By indicates the individual who discontinued this product DiscontinuedBy

DATE

Date


Tab: Business Partner

Description : Business Partner specific Information of a Product

Help : Note that some information is for reference only! The

Table Name  : C_BPartner_Product

ManPageW Product BusinessPartner.png

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

Business Partner Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson C_BPartner_ID

NUMBER(10)

Search

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Partner Product Key Product Key of the Business Partner The Business Partner Product Key identifies the number used by the Business Partner for this product. It can be printed on orders and invoices when you include the Product Key in the print format. VendorProductNo

NVARCHAR2(30)

String

Partner Category Product Category of the Business Partner The Business Partner Category identifies the category used by the Business Partner for this product. VendorCategory

NVARCHAR2(30)

String

Manufacturer Manufacturer of the Product The manufacturer of the Product (used if different from the Business Partner / Vendor) Manufacturer

NVARCHAR2(30)

String

Quality Rating Method for rating vendors The Quality Rating indicates how a vendor is rated (higher number = higher quality) QualityRating

NUMBER

Number

Min Shelf Life % Minimum Shelf Life in percent based on Product Instance Guarantee Date Miminum Shelf Life of products with Guarantee Date instance. If > 0 you cannot select products with a shelf life ((Guarantee Date-Today) / Guarantee Days) less than the minum shelf life, unless you select "Show All" ShelfLifeMinPct

NUMBER(10)

Integer

Min Shelf Life Days Minimum Shelf Life in days based on Product Instance Guarantee Date Miminum Shelf Life of products with Guarantee Date instance. If > 0 you cannot select products with a shelf life less than the minum shelf life, unless you select "Show All" ShelfLifeMinDays

NUMBER(10)

Integer


Tab: Price

Description : Product Pricing

Help : The Pricing Tab displays the List, Standard and Limit prices for each price list a product is contained in.

Table Name  : M_ProductPrice

ManPageW Product Price.png

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

Price List Version Identifies a unique instance of a Price List Each Price List can have multiple versions. The most common use is to indicate the dates that a Price List is valid for. M_PriceList_Version_ID

NUMBER(10)

TableDir

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

List Price List Price The List Price is the official List Price in the document currency. PriceList

NUMBER

CostsPrices

Standard Price Standard Price The Standard Price indicates the standard or normal price for a product on this price list PriceStd

NUMBER

CostsPrices

Limit Price Lowest price for a product The Price Limit indicates the lowest price for a product stated in the Price List Currency. PriceLimit

NUMBER

CostsPrices


Tab: Download

Description : Maintain Product Downloads

Help : Define downloads for a product. If the product is an asset, the user can download the data.

Table Name  : M_ProductDownload

ManPageW Product Download.png

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name

NVARCHAR2(60)

String

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Download URL URL of the Download files Semicolon separated list of URLs to be downloaded or distributed DownloadURL

NVARCHAR2(120)

Unknown (40)


Tab: Accounting

Description : Define Accounting Parameters

Help : The Accounting Tab defines the defaults to use when generating accounting transactions for orders and invoices which contain this product.

Table Name  : M_Product_Acct

ManPageW Product Accounting.png

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

TableDir

Accounting Schema Rules for accounting An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar C_AcctSchema_ID

NUMBER(10)

TableDir

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Product Asset Account for Product Asset (Inventory) The Product Asset Account indicates the account used for valuing this a product in inventory. P_Asset_Acct

NUMBER(10)

Account

Product Expense Account for Product Expense The Product Expense Account indicates the account used to record expenses associated with this product. P_Expense_Acct

NUMBER(10)

Account

Cost Adjustment Product Cost Adjustment Account Account used for posting product cost adjustments (e.g. landed costs) P_CostAdjustment_Acct

NUMBER(10)

Account

Inventory Clearing Product Inventory Clearing Account Account used for posting matched product (item) expenses (e.g. AP Invoice, Invoice Match). You would use a different account then Product Expense, if you want to differentate service related costs from item related costs. The balance on the clearing account should be zero and accounts for the timing difference between invoice receipt and matching. P_InventoryClearing_Acct

NUMBER(10)

Account

Product COGS Account for Cost of Goods Sold The Product COGS Account indicates the account used when recording costs associated with this product. P_COGS_Acct

NUMBER(10)

Account

Purchase Price Variance Difference between Standard Cost and Purchase Price (PPV) The Purchase Price Variance is used in Standard Costing. It reflects the difference between the Standard Cost and the Purchase Order Price. P_PurchasePriceVariance_Acct

NUMBER(10)

Account

Invoice Price Variance Difference between Costs and Invoice Price (IPV) The Invoice Price Variance is used reflects the difference between the current Costs and the Invoice Price. P_InvoicePriceVariance_Acct

NUMBER(10)

Account

Trade Discount Received Trade Discount Receivable Account The Trade Discount Receivables Account indicates the account for received trade discounts in vendor invoices P_TradeDiscountRec_Acct

NUMBER(10)

Account

Trade Discount Granted Trade Discount Granted Account The Trade Discount Granted Account indicates the account for granted trade discount in sales invoices P_TradeDiscountGrant_Acct

NUMBER(10)

Account

Product Revenue Account for Product Revenue (Sales Account) The Product Revenue Account indicates the account used for recording sales revenue for this product. P_Revenue_Acct

NUMBER(10)

Account


Tab: Transactions

Description : Transactions for stored Products

Help : The Transaction Tab displays the transactions that have been processed for this product.

Table Name  : M_Transaction

ManPageW Product Transactions.png

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

Search

Attribute Set Instance Product Attribute Set Instance The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. M_AttributeSetInstance_ID

NUMBER(10)

ProductAttribute

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Locator Warehouse Locator The Locator indicates where in a Warehouse a product is located. M_Locator_ID

NUMBER(10)

Locator

Movement Quantity Quantity of a product moved. The Movement Quantity indicates the quantity of a product that has been moved. MovementQty

NUMBER

Quantity

Movement Date Date a product was moved in or out of inventory The Movement Date indicates the date that a product moved in or out of inventory. This is the result of a shipment, receipt or inventory movement. MovementDate

DATE

Date

Movement Type Method of moving the inventory The Movement Type indicates the type of movement (in, out, to production, etc) MovementType

CHAR(2)

List

Receipt Line Line on Receipt document M_InOutLine_ID

NUMBER(10)

Search

Phys.Inventory Line Unique line in an Inventory document The Physical Inventory Line indicates the inventory document line (if applicable) for this transaction M_InventoryLine_ID

NUMBER(10)

Search

Move Line Inventory Move document Line The Movement Line indicates the inventory movement document line (if applicable) for this transaction M_MovementLine_ID

NUMBER(10)

Search

Production Line Document Line representing a production The Production Line indicates the production document line (if applicable) for this transaction M_ProductionLine_ID

NUMBER(10)

Search

Project Issue Project Issues (Material, Labor) Issues to the project initiated by the "Issue to Project" process. You can issue Receipts, Time and Expenses, or Stock. C_ProjectIssue_ID

NUMBER(10)

Search


Tab: Translation

Description :

Help :

Table Name  : M_Product_Trl

ManPageW Product Translation.png

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID

NUMBER(10)

TableDir

Language Language for this entity The Language identifies the language to use for display and formatting AD_Language

VARCHAR2

Table

Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name

NVARCHAR2(510)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Document Note Additional information for a Document The Document Note is used for recording any additional information regarding this product. DocumentNote

NVARCHAR2(2000)

String

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Translated This column is translated The Translated checkbox indicates if this column is translated. IsTranslated

CHAR(1)

YesNo

Contributions