[en] Knowledge Center

[en] AssignInMultipleOf

4

[en] Sometimes the products are packed together in a way that makes it preferable to keep them together when selling. When RamBase starts the process of assigning sales to stock or purchase backlog, this field is taken into consideration. If the available quantity is not in this multiple, the rest quantity will be requested for procurement.

[en] AutoCreateProductUnitAtGoodsReception

1

[en] When activated, product units are automatically generated when goods are registered to stock

[en] AutoGenerateSerialNumbersForPurchaseOrders

1

[en] Serial numbers can be added to all newly created purchase order items. The serial number is specified in the company setting ProductionSerialNumberCounter, which will increase afterwards. If the company setting AutoProductionSerialNumberPrefix is specified, the serial number will be prefixed by this value.

[en] BlockedForProduction

1

[en] If a product is blocked for production, no production work orders with that product can be registered.

[en] BlockedForPurchase

1

[en] If a product is blocked for purchase, no purchase quotes or purchase orders with that product can be registered.

[en] BlockedForSale

1

[en] If a product is blocked for sales, no sales quotes, sales order requests, sales order change requests or sales orders with that product can be registered in this location.

[en] BlockedForShipping

1

[en] If a product is blocked for shipping, no shipments can be sent to customers from this location.

[en] ClassificationCode

10100010011002

[en] Product classification identifier

[en] ClassificationGroup

10

[en] Product classification group

[en] ClassificationLevel1

1001

[en] Product classification level 1

[en] ClassificationLevel2

1002

[en] Product classification level 2

[en] ClassificationLevel3

1000

[en] Product classification level 3

[en] ClassificationLevel4

1000

[en] Product classification level 4

[en] ClassificationLevel5

1001

[en] Product classification level 5

[en] CountryOfOrigionCode

[en] DE

[en] Two-character code (ISO 3166) identifying the default country where the product is produced. This value is inherited from the assigned goods reception(s). If not country of origin is specified for the goods reception(s), country of origin is retrieved from the product. If assigned to multiple goods receptions with different origin, the field will be empty.

[en] CreateIfnotExisting

1

[en] Use the value 1, if product should be created if it does not match existing products

[en] CustomerExtId

77597376

[en] External id, used for migrations to refers to customer in a different system.

[en] CustomerId

15112

[en] Products customer identifier

[en] CustomersProductName

[en] X12-GREEN-LASER

[en] Customers/buyers name of the product

[en] CustomField1

[en] York

[en] Custom field for grouping, sorting, categorizing and other purposes. Obsolete field

[en] CustomField2

[en] Cosmetics

[en] Custom field for grouping, sorting, categorizing and other purposes. Obsolete field

[en] CustomField3

[en] Consumer

[en] Custom field for grouping, sorting, categorizing and other purposes. Obsolete field

[en] DaysToExpediteScheduledStartDate

12

[en] Number of days the production will start ahead of the scheduled start date. Set this value if you want a buffer to be sure you are ready in time.

[en] DefaultManufacturersProductManufacturer

[en] INTEL

[en] Manufacturer of the MPN

[en] DefaultManufacturersProductName

[en] BX8071513700KE

[en] Manufacturer's name of the product. Also known as Manufacturer Part Number (MPN).

[en] Description

[en] X12 laser

[en] Description of the product

[en] DetailedDescription

[en] X12 laser with 5000 m long beam green light

[en] Detailed description of the product

[en] DomestisCustomsTariffCode

11.22.33.55

[en] Domestic customs tariff classification identifier

[en] EUCustomsTariffCode

2513.20.00.00

[en] EU customs tariff classification identifier

[en] ExcludeFromSOPProcesses

1

[en] Exclude product from sales- and operation (SOP) processes for location. Typically used for products/materials being purchased, but can also be set for products with product structure.

[en] ExclusivelyForCustomer

102243

[en] If customer is specified, only this customer can place orders for this product. Customer id

[en] ExpectedWastagePercent

5.0

[en] Standard percentage of wastage for product when used in a production work order in this location

[en] ExpectedWastageQuantity

0

[en] Standard quantity of wastage for product when used in a production work order in this location

[en] ExternalReference

776655

[en] External reference of the product. Typically used for storing product identifier for same product in external system

[en] ExtId

678943

[en] External reference. Used in migration. Id in external system

[en] FreightPercent

10.0

[en] Freight percent. Will, if added, be a part of the cost calculation

[en] GlobalTradeItemNumber

3 014260 11553

[en] Global Trade Item Number (GTIN) is a 14 digit identifier for trade items (comprising among others of the former EAN International and Uniform Code Council). Examples of types of GTIN are UPC, EAN, JAN, ISBN

[en] Height

30

[en] Height of the product in centimeters

[en] InternalNote

[en] Don't sell this product without talking to the sales manager

[en] Internal note regarding the product. Should not be exposed to customers.

[en] IsExternallyManufactured

1

[en] True if product structure is manufactured externally, and not internally

[en] IsManufacturedInBatches

1

[en] Products is either manufactured in batch product units, or single product units. When manufactured as single, each production unit of a production work order should result in separate product units. When manufactured in batches, all production units from one production work order should result in one common product unit.

[en] IsNonStock

1

[en] True if this is a non-physical product which are no using assignments from the assignment archive

[en] IsTraceableMaterialOfProductUnit

1

[en] During production of a product structure, each produced unit generates a list of traceable materials included in the finished unit. When this value is true, this product is included in the list of traceable materials.

[en] Length

60

[en] Length of the product in centimeters

[en] LocationShortName

[en] OSL

[en] Unique abbreviation/short name of the location

[en] MainImageId

[en] FIL/201026.100

[en] Main image of the product

[en] Manufacturer

[en] PHILIPS

[en] Manufacturer of the product

[en] ManufacturingAreaName

[en] Area2

[en] Name of manufacturing area

[en] MeasurementUnit

[en] pcs

[en] Measurement unit used for this product, both in sales and purchase.

[en] MeasuringToolGroup

[en] Thread Micrometer

[en] Measuring tools group

[en] MinimumGrossMargin

7.0

[en] The minimum gross margin, in percent, for the product

[en] MinimumWorkOrderQuantity

2

[en] Minimum ProductionOrder quantity to a production

[en] MoistureSensitivityLevel

[en] 5A

[en] Moisture sensitivity level is an electronic standard for the time period in which a moisture sensitive device can be exposed to ambient room conditions.

[en] Name

[en] X12-5000

[en] Name of the product

[en] NeedsMaterialReplacementToRelease

1

[en] You can add a dummy article in productions which you replace with the actual product before production starts. This function is used in situations where it is undecided which product will be used in the final production.

[en] PackageQuantity

20

[en] Total quantity of the product within a package

[en] PackageType

[en] Box

[en] Type of wrapping used for the package

[en] PalletQuantity

40

[en] Total quantity of the product that can be on a pallet

[en] PlanningCategory

[en] P33

[en] Planning category

[en] PreferredStockLocation

[en] B-12

[en] Preferred stock location in this location for this product

[en] ProduceInMultipleOf

4

[en] Quantity to produce in multiple of. Ex. if set to 2, you can only produce 2, 4, 6 etc

[en] ProductId

[en] #125778

[en] Product Id

[en] PublicProductUri

[en] https://www.vg.no/

[en] Public/external product URI for more information about the product. Will typically be an URL to product details at the manufacturer web site.

[en] PurchaseExpectedLeadTime

50

[en] The expected lead time, in number of days, from ordering from supplier to delivery. Used in different purchase processes, typically when supplier is unknown. Note that this might differ from the standard lead times defined on the different suppliers.

[en] PurchaseGroupName

[en] Laser group

[en] Name of purchase group

[en] PurchasePrice

12.45

[en] The purchase price of the product for this product supplier

[en] PurchasePriceCurrency

[en] EUR

[en] Three character code following the ISO 4217 standard

[en] PurchasePriceEffectiveDate

2025.12.01

[en] The date the purchase price takes effect. The price will be effective from from and including this date.

[en] PurchasePriceExpirationDate

2026.04.30

[en] The date the purchase price expires.

[en] PurchasePriceMinimumQuantity

1

[en] The minimum quantity for this purchase price to be applied

[en] RENTAL

[en] YES

[en] RENTALCUR

[en] SEK

[en] Currency

[en] RENTALPRICE

1300.00

[en] Price

[en] ReorderPoint

200

[en] A minimum amount of quantity which a location holds in stock, such that, when stock falls to this amount, the product must be reordered

[en] ReorderQuantity

10

[en] Preferred quantity to use when reordering to this location. Is also used as order quantity when stock gets below reorder point.

[en] RequireSerialNumberAtGoodsReception

1

[en] If all units of this product should have a serial number in stock, you should require serial number to be required at goods reception. This will ensure that serial number is specified before goods receptions with this product is registered.

[en] RequireSerialNumberBeforeShipping

1

[en] If all units of this product should have a serial number before shipping, you should require serial number to be specified before shipping this product. Shipping includes supplier returns, shipping advices and stock transfers.

[en] Revision

A

[en] Revision number

[en] SalesStandardLeadTime

30

[en] The standard lead time, in number of days, from customer places order to delivery.

[en] SalesType

[en] Defines if an article is of one of the types: Sales, Sales and rental, Rental, Subscription.

[en] SERVICEDELETE

Y

[en] SERVICEID

[en] ART/#224377

[en] Link from service table to KM article.

[en] SERVICEMAIN

Y

[en] "Y" if main service.

[en] Status

4

[en] Status of the product

[en] SupplierExtId

7788497532

[en] External id, used for migrations to refers to suppler in a different system.

[en] SupplierId

23112

[en] Supplier id. Needed if supplier data or purchase data should be updated

[en] SupplierIsPreferred

1

[en] Whether this supplier is preferred or not

[en] SuppliersMinimumOrderQuantity

100

[en] A minimum order quantity (MOQ) is the lowest set amount of stock that a supplier is willing to sell. If you can’t purchase the MOQ of a specific product, then the supplier won’t sell it to you. Also note that if purchase quantity exceeds the MOQ, the purchase quantity should always be in multiple of the MOQ.

[en] SuppliersProductName

22445566

[en] Supplier/sellers internal product name

[en] SupplierStandardLeadTime

30

[en] Standard lead time in days for this product from this supplier

[en] Type

P

[en] Type of product

[en] UDF_CustomFieldName

[en] What ever

[en] User defined fields. You may have several columns, one for each custom field

[en] UseProductIdAsProductName

1

[en] Use the value 1, if product name should be set equal to product id

[en] Volume

72000

[en] Volume of the product in cubic centimeters. Volume is calculated automatically as L* W* H (when the volume field is empty and L,W ,H have values). Volume can also be changed manually

[en] WarrantyPeriod

720

[en] The time period (in months) in which the product may be returned or exchanged. The warranty period starts at the date of shipment to customer.

[en] Weight

10

1.25

[en] The weight of the product in kilograms

[en] Width

40

[en] Width of the product in centimeters