Product

Type Length PK FK Mode Mandatory Remarks
        Table Field Read Write Delete Create Update  
code STRING 80 X product code X X X X X  
counting date DATE         X X       The counting date of an inventory point is the moment at which the initial inventory is recorded.
custom data 01 STRING 80       X X        
custom data 02 STRING 80       X X        
custom data 03 STRING 80       X X        
custom data 04 STRING 80       X X        
custom data 05 STRING 80       X X        
custom data 06 STRING 80       X X        
custom data 07 STRING 80       X X        
custom data 08 STRING 80       X X        
custom data 09 STRING 80       X X        
custom data 10 STRING 80       X X        
custom data 11 STRING 80       X X        
custom data 12 STRING 80       X X        
custom data 13 STRING 80       X X        
custom data 14 STRING 80       X X        
custom data 15 STRING 80       X X        
custom date+time 01 DATE         X X        
custom date+time 02 DATE         X X        
custom date+time 03 DATE         X X        
custom date+time 04 DATE         X X        
custom date+time 05 DATE         X X        
custom date+time 06 DATE         X X        
custom date+time 07 DATE         X X        
custom date+time 08 DATE         X X        
custom date+time 09 DATE         X X        
custom date+time 10 DATE         X X        
custom value 01 REAL         X X        
custom value 02 REAL         X X        
custom value 03 REAL         X X        
custom value 04 REAL         X X        
custom value 05 REAL         X X        
custom value 06 REAL         X X        
custom value 07 REAL         X X        
custom value 08 REAL         X X        
custom value 09 REAL         X X        
custom value 10 REAL         X X        
default consumption step STRING 80   process step code X X        
default consumption step version STRING 80   process step version X X        
default outflow product STRING 80   product code X X       Obsolete
default production step STRING 80   process step code X X        
default production step version STRING 80   process step version X X        
description STRING 80       X X      
enable inventory constraint NUM         X X        
end item STRING 80   end item code X X        
external code STRING 80       X X X      
initial inventory REAL         X X       The initial inventory is the measured or expected inventory of a decoupled product at the counting point in time. The initial inventory is used when calculating the inventory simulation.
inventory date DATE         X X        
inventory strategy NUM         X X        
last modified DATE         X X        
max inventory REAL         X X       The maximum inventory is the maximum inventory level that is allowed at any time. The maximum inventory is used to produce a warning if an inventory level becomes too high.
max. cover::count NUM         X X       Maximum cover period is the maximum number of periods of demand kept in stock.
max. cover::unit NUM         X X       The unit is indicated with a code: 1 for minutes 2 for hours 3 for days 4 for weeks 5 for months 6 for years
min inventory REAL         X X       The minimum inventory is the minimum inventory level required at any one time. The minimum inventory is used to issue a warning if an inventory level becomes too low.
min. cover::count NUM         X X       Minimum cover period is the minimum number of periods of demand kept in stock.
min. cover::unit NUM         X X       The unit is indicated with a code: 1 for minutes 2 for hours 3 for days 4 for weeks 5 for months 6 for years
model name STRING 80 X product, product group model name   X        
product group STRING 80   product group code X X   X   Cannot be updated.
replenishment interval::count NUM         X X       The replenishment interval is a repetitive interval. At the end of each interval the inventory simulation is compared with the standard inventory to determine the replenishment quantity for that interval.
replenishment interval::unit NUM         X X       The unit is indicated with a code: 1 for minutes 2 for hours 3 for days 4 for weeks 5 for months 6 for years
std inventory REAL         X X       The standard inventory is the inventory level wished for at any time in the working area. The standard inventory is used as the inventory replenishment level. The standard inventory level can be fixed or variable.
std. cover::count NUM         X X       The cover period indicates how many periods (for example days) of demand must be kept in stock.
std. cover::unit NUM         X X       The unit is indicated with a code: 1 for minutes 2 for hours 3 for days 4 for weeks 5 for months 6 for years
unit STRING 80       X X       The unit indicates which physical unit of measurement the batch quantity is expressed in. Units are freely definable for each product. Within a product group, a standard unit can be specified which is automatically filled in for each new product.
volume factor REAL         X X       The volume factor of a product converts the units in which the batch quantity is expressed to Infor Production Scheduling standard unit of volume.
weight factor REAL         X X       The weight factor of a product converts the units in which the batch quantity is expressed to Infor Production Scheduling standard unit of weight.