View source | Discuss this page | Page history | Printable version   

CloudERP IDL Products

Introduction

Products can be stock items that you sell, or buy and can also be:

Input file definition

Field name Type Nullable Description Accepted values Comment
Organization String(40) No Indicates the organization to be used when processing documents. [Organization search key]
SearchKey String(40) No A search key allows for a fast method of finding a particular record. (unique) [Product search key] Duplicates in this field or existing records with the same value will throw an exception.
Name String(60) No The name of the product.
Description String(255) Yes More information about the product.
UPCEAN String(30) Yes Use this field to enter the bar code for the product in any of the bar code symbologies
ProductCategory String(32) No Identifies the category which this product belongs to. Product categories are used for pricing. [Product category name] If it does not exists any product category with this name, a new product category will be created with this name.
UOM String(32 No Defines a unique non monetary unit of measure. [EDI code] If it does not exists any UOM with this EDI code, a new UOM will be created with this EDI code.
ProductType String(60) No The type of product also determines accounting consequences. {'Item', 'Expense type', 'Resource', 'Service', 'Online'}
Production Boolean No A product that is used for production plans. {'TRUE', 'FALSE'}
BillOfMaterial Boolean No Indicates if this product consists of a bill of materials. {'TRUE', 'FALSE'}
Discontinued Boolean No Indicates a product that has been discontinued. {'TRUE', 'FALSE'}
CostType String(32) Yes Different types of cost {'Average', 'Standard'}
AttributeSet String(60) Yes 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. [AttributeSet name]
AttributeValue String(60) Yes The values of the actual Product Attributes [Attribute value name] The Attribute value meaning depends on the Product Attribute Set defined:
  • For Product Attribute Sets checked as Serial Number, the Attribute Value is the serial number value.
  • For Product Attribute Sets checked as Lot, the Attribute Value is the lot value.
  • For Product Attribute Sets with only one Attribute, the Attribute Value is the value of that attribute.

There is not defined a behaviour for Product Attribute Sets with more than one Attribute.

Stocked Boolean No Indicates if this product is stocked by this Organization. {'TRUE', 'FALSE'}
Purchase Boolean No Indicates if this product is purchased by this organization. {'TRUE', 'FALSE'}
Sale Boolean No Indicates if this product is sold by this organization. {'TRUE', 'FALSE'}
TaxCategory String(32) No The Tax Category provides a method of grouping similar taxes. For example, Sales Tax or Value Added Tax. [Tax category name] If it does not exists any Tax Category with this name, a new Tax Category will be created with this name.
StandardCost Number Yes The value of the standard cost
PriceSales Number Yes Sales price
PricePurchase Number Yes Purchase price

Default Value definition

Field name Type Accepted values Description Examples
Organization String(40) [search_key] column from [AD_Org] table
Currency String(3) [iso_code] column from [c_currency] table Currency used for Price List of the Business Partner EUR, USD, GBP, ...
Category String(60) [name] column from [m_product_category] table Default product category Fruits, Clothes, Standard, ...
UOM String(2) [X12DE355] column from [c_uom] table Default Unit of Measure Code indicates the EDI X12 Code Data Element 355 (Unit or Basis for Measurement) Unit, Bag, Kg, ...
StandardPrecision String(10) [stdprecision] column from [c_uom] table Defines the number of decimal places that amounts will be rounded to for accounting transactions and documents. 0, 1, 2, ...
CostingPrecision String(10) [costingprecision] column from [c_uom] table Defines the number of decimal places that amounts will be rounded to when performing costing calculations. 1, 2, 3, ...
ProductType String(30) [producttype] column from [m_product] table Default product type Item, Online, Resource, Service, Expense type
Stocked Boolean [stocked] column from [m_product] table Indicates if this product is stocked TRUE / True / true / FALSE / False / false
Purchase Boolean [purchase] column from [m_product] table Indicates if this product is purchased TRUE / True / true / FALSE / False / false
Sale Boolean [sale] column from [m_product] table Indicates if this product is sold TRUE / True / true / FALSE / False / false
TaxCategory String(60) [name] column from [c_taxcategory] table Default tax category for the product VAT 16%, VAT 7%, Exempt...
PriceListSchema String(60) [name] column from [m_discountschema] table Default Price List Schema name
PriceListSale String(60) [name] column from [m_pricelist] table Default Sale Price List name
PriceListVersionSale String(60) [name] column from [m_pricelist_version] table Default Sale Price List Version name General Sales 2009, Mafalda Sales 2008, Standard Sales...
PriceListPurchase String(60) [name] column from [m_pricelist] table Default Purchase Price List name
PriceListVersionPurchase String(60) [name] column from [m_pricelist_version] table Default Purchase Price List Version name Purchase 2006, Mafalda Purchase 2009, Standard Purchases...
Production Boolean [production ] column from [m_product] table Indicates if this product is in production TRUE / True / true / FALSE / False / false


Discontinued Boolean [discontinued] column from [m_product] table Indicates a product that has been discontinued. TRUE / True / true / FALSE / False / false
BillOfMaterials Boolean [Bill of material ] column from [m_product] table Indicates if this product consists of a bill of materials. TRUE / True / true / FALSE / False / false
CostType String(32) [cost type] column from [m_product] table Different types of cost AV (Average) / ST (Standard)
AttributeSet String(60) [name] column from [m_attributeset] table Define Product Attribute Sets to add additional attributes Color, Size, Serial Number ....
AttributeSetValue String(60) [name] column from [m_attributevalue] table Defines individual value of a product attribute Green, Large, ..
AttributeSetValueType String(60) Use Attribute Set Value As reference list. Permits to define different types of Attribute Set Values, depending on their usage. In English: "Specification", "Overwrite Specification", "Default".

Retrieved from "http://wiki.openbravo.com/wiki/CloudERP_IDL_Products"

This page has been accessed 829 times. This page was last modified on 18 June 2014, at 08:55. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.