CloudERP IDL Products
Introduction
Products can be stock items that you sell, or buy and can also be:
- Items required for business use, for example a printer.
- Expenses such as taxi fares or hotel bills.
- Resources such as machinery or staff.
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:
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". |