Order

Type Length PK FK Mode Mandatory Remarks
        Table Field Read Write Delete Create Update  
code STRING 80 X     X X X   x The order code is a unique identifier of an order. The order code is automatically generated by Infor Production Scheduling at the time of creation or assigned by an external system.
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        
description STRING 80       X X        
due time DATE         X X   X   The due time of an order (represented as a date and time) can be specified manually or read-in through an interface. The planning aim is to have a scheduled time that is not later than the due time.
earliest start DATE         X X       The earliest start time of an order is the first point in time at which the outflow of end product batches for the order can start.
end item STRING 80   end item code X X   X    
external code STRING 80       X X X      
external version STRING 80       X X        
extra shelf life NUM         X X        
extra shelf life max NUM         X X       The extra shelf life of an order increases the best before date. The extra shelf life is bounded by the maximum extra shelf life.
last modified DATE         X X        
model name STRING 80 X end item model name   X        
quantity REAL         X X   X   The quantity is the due quantity of an order.
registered quantity REAL         X X       The registered inflow quantity can be used to track the (inflow) progress of an order. Registered quantity can only be specified if start inflow is registered.
remarks STRING 80       X X        
scheduled quantity REAL           X       The part of the order quantity that is scheduled.
scheduled time DATE           X       The scheduled time of an order (represented as date and time) is the point in time at which the last part of the outflow from the end product batches flows to that order. The scheduled time is calculated from the batches in the schedule and cannot be modified.
start inflow DATE         X X       The start time of an order is the point in time at which inflow begins from the end product batches.
status STRING 80   status code X X        
uom extra shelf life NUM           X        
uom extra shelf life max NUM           X       The unit is indicated with a code: 3 for days 4 for weeks 5 for months 6 for years
version STRING 80   process step version X X       alternative step
week of delivery NUM         X X        
year of delivery NUM         X X