CloudERP IDL Price Lists
Introduction
Price lists are the different prices products can have. These prices are grouped by price lists.
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] | |
| PriceListName | String(60) | No | A unique identifier for a Price List. | [Price List name] | If it does not exists any price list with this name, a new price list will be created with this name. If it exist the price list will be used (not updated). |
| IsDefault | Boolean | Yes | Indicates if the prices list is the default. | {'TRUE', 'FALSE'} | |
| IsTaxInc | Boolean | Yes | Indicates if the prices include tax. This is also known as the gross price. | {'TRUE', 'FALSE'} | |
| IsSales | Boolean | Yes | Indicates if this price list is used for sales transactions or purchase. | {'TRUE', 'FALSE'} | |
| Currency | String(32) | No* | Indicates the currency to be used when processing this document. | [Currency ISO code] | |
| EnforcePriceLimit | Boolean | Yes | Indicates that prices cannot be below the limit price in Orders. Invoices are not checked. | {'TRUE', 'FALSE'} | |
| PriceListVersionName | String(60) | No | A non-unique identifier for a Price List Version. | [Price List Version name] | If it does not exists any price list version with this name, a new price list version will be created with this name. If it exist, the price list version will be used (not updated). |
| DiscountSchema | String(60) | No* | After calculation of the (standard) price, the trade discount percentage is calculated and applied resulting in the final price. | [Discount Schema name] | |
| ValidFrom | Date | No | The Valid From date indicates the first day of a date range. yyyy-MM-dd format. | yyyy-MM-dd format. | |
| BasePriceListVersion | String(60) | Yes | The Base Price List identifies the Base Pricelist used for calculating prices (the source). | [Price List Version name] | |
| ProductName | String(60) | No | A non-unique identifier for a Product. | [Product search key] | If it does not exists the process will not pass the validation. If a product and the price list version exist the prices will be updated. |
| ListPrice | BigDecimal | Yes | Is the official price stated by the selected pricelist and the currency of the document. | Decimal separator = . | If null, database default value = 0.0 |
| StandardPrice | BigDecimal | Yes | Indicates the standard or normal price for a product on this price list | Decimal separator = . | If null, database default value = 0.0 |
| PriceLimit | BigDecimal | Yes | Indicates the lowest price for a product stated in the Price List Currency. | Decimal separator = . | If null, database default value = 0.0 |
* This fields can be NULL if they have a default value associated.
Default Value definition
| Field name | Type | Accepted values | Examples |
|---|---|---|---|
| Organization | String(40) | [search_key] column from [AD_Org] table | |
| Currency | String(3) | [iso_code] column from [c_currency] table | EUR, USD, GBP, ... |
| IsTaxIncluded | Boolean | TRUE / True / true / FALSE / False / false | True
|
| IsSalesPriceList | Boolean | TRUE / True / true / FALSE / False / false | True |
| EnforcePriceLimit | Boolean | TRUE / True / true / FALSE / False / false | True |
| DiscountSchema | String(60) | [name] column from [m_discountschema] table | Discount Schema 2006 |
| BasePriceListVersion | String(60) | [name] column from [m_pricelist_version] table | Mafalda Sales |
| IsDefault | Boolean | TRUE / True / true / FALSE / False / false | True |