The PriceDiscAmount extended data type should be extended to the maximum required number of decimals for both amounts and unit amounts.įor example, if amounts need to be maintained with three decimals, but unit amounts need to be maintained with four decimals, the data type should be extended to four decimals. The PriceDiscAmount extended data type is used for storing and presenting amounts and unit amounts. There are five extended data types that are used for storing both unit amount data and other types of data. If you require a more than four number of decimals, you should also extend the PriceRoundOff extended data type. If you require the ability enter, maintain, and view unit amounts with a maximum of six decimals, you must extend the number of decimals of the UnitAmountCur, UnitAmountMST, and CostPriceNonMonetary extended data types. Unit amountsīy default, unit amounts including prices, line discount amounts, and line charge amounts can be maintained with a maximum of two decimals. The ProductQuantityHourValue extended data type should be extended to the maximum required number of decimals for both hours and quantities.įor example, if quantities need to be maintained with four decimals, but hours still need to be maintained with two decimals, then the data type should be extended to four decimals. The ProductQuantityHourValue extended data type is used for storing and presenting both hours and quantities. The AmountQty extended data type should be extended to the maximum required number of decimals for both amounts and quantities.įor example, if amounts need to be maintained with three decimals, but quantities still need to be maintained with two decimals, then the data type should be extended to three decimals. The AmountQty extended data type is used for storing and presenting both amounts and quantities. These data types must be extended separately. There are two extended data types that are used for storing both quantity data and other types of data. You can extend the PriceQty extended data type to change the number of decimals to a value other than the default two for price and charge quantities. You can extend the PriceUnit extended data type to change the number of decimals to a value other than the default two for price units.
Price unit, Price quantity, and Charge quantity data can be extended independently from product quantities. If you require more than four decimals, extend the number of decimals for the BOMProductQuantity extended data type. If you require the ability to enter, maintain, and view product quantities with a maximum of six decimals, you must extend the number of decimals of the ProductQuantity, CostQuantity, and CAMMagnitude extended data types.īill of materials, formulas, and production orders allow maintaining quantities with four decimals by default. Quantity data that is related to the procuring, consuming, producing, storing, and selling of products can be maintained with a maximum of two decimals by default. If you require the ability to enter, maintain, and view this data with a maximum of six decimals, you must extend the number of decimals for the InventWidth, InventHeight, and InventDepth extended data types respectively. These physical dimensions can be maintained with a maximum of two decimals by default. If you require the ability to enter, maintain, and view weight data with a maximum of six decimals, you must extend the number of decimals for the WeightBase extended data type. Weight data can be maintained with a maximum of two decimals by default. Due to database constraints, each of the data types described in this article can have a maximum precision of six decimals.
0 kommentar(er)
