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 |