The OFPR table of the SAP Business One database is used to calculate prices for sales or Purchase items to save. It contains entries for several SAP Business One price lists and price groups.
Each OFPR table entry is associated with an article and a price list and contains information such as unit price, currency, validity period and tax rates. This data is used in other areas of SAP Business One to create sales and purchasing documents such as quotations, orders, delivery notes and invoices.
Here is an overview of some of the most important fields in the OFPR table:
- ListNum: The unique ID number of the price list.
- ListName: The name of the price list.
- Currency: The currency used in the price list.
- ValidFrom: The date on which the price list becomes valid.
- ValidTo: The date on which the price list expires.
- BaseList: The ID number of the base price list on which this price list is based.
