Field
|
Name
|
M
|
Type
|
Description
|
Status
|
Status Id
|
X
|
nvarchar(20)
|
|
DESCRIPTION
|
Description
|
|
nvarchar(255)
|
|
Deleted
|
Entry deleted / blocked
|
|
int(4)
|
|
Release
|
Release
|
|
int(4)
|
Valid values: yes=1
No=0
do not change=2
|
Block
|
Locked
|
|
int(4)
|
Valid values: Yes=1
No=0
do not change=2
|
BITMAPNAME
|
Picture
|
|
nvarchar(50)
|
|
COLORID
|
Color
|
|
int(4)
|
|
CanSaleOrder
|
Sales order
|
|
int(4)
|
Valid values: Yes=1
No=0
|
CanDeliver
|
Delivery note
|
|
int(4)
|
Valid values: Yes=1
No=0
|
CanSaleInvoice
|
Sales Invoice
|
|
int(4)
|
Valid values: Yes=1
No=0
|
CanPurchaseOrder
|
PO Order can be created
|
|
int(4)
|
Valid values: Yes=1
No=0
|
CanGRPO
|
Purchase delivery note
|
|
int(4)
|
Define, if a Goods Receipt PO can be created
Valid values: Yes=1
No=0
|
CanPurchaseInvoice
|
Purchase Invoice
|
|
int(4)
|
Describe, if a PO Invoice can be created
Valid values: Yes=1
No=0
|
CanModify
|
Change allow
|
|
int(4)
|
If this option is deactivated, the stored routing cannot be changed.
But the fields in the item version are still changeable.
Valid values: Yes=1
No=0
|
CanCreateWo
|
Work order can be created
|
|
int(4)
|
A work order can only be created for this item version if this option is active.
Note: If the status is blocked the work order is created but blocked if it is a sub-item.
The work order is also be blocked if it is created in an automatic process (via integration hub).
The blocking can be avoided by using Production types eg. for a sample production.
Valid values: Yes=1
No=0
|
CanReservationWo
|
Reservation for Wo
|
|
int(4)
|
Valid values: Yes=1
No=0
|
CanIssueWo
|
Issue for wo can be created
|
|
int(4)
|
Defines whether the item version is to be considered in material planning.
If a work order has already been created, this option affects the same option in the work order position.
See Update Status. Yes / No / None change are selectable.
Valid values: Yes=1
No=0
None Chagen=2
|
STARTDISPOSITION
|
Material planning
|
|
int(4)
|
Related to work order setting "Disposition"
Defines whether the item version is to be considered in material planning.
If a work order has already been created, this option affects the same option in the work order position.
See Update Status. Yes / No / None change are selectable
None change means: The status don't change the setting in the work order
Valid values: Yes=1
No=0
do not change=2
|
STARTTIMEREQUEST
|
Login to workorder
|
|
int(4)
|
Defines whether order time receipts may be created for this item version. This option affects the same option in the work order position. See Update Status.
Valid values: Yes=1
No=0
do not change=2
|
STARTBOOKING
|
Work order material posting
|
|
int(4)
|
Defines whether material postings may be created for this item version. This option affects the same option in the work order position.
Valid values: Yes=1
No=0
do not change=2
|
STARTCAPACITYPLANUNG
|
Capacity planining
|
|
int(4)
|
Defines whether the item version is to be considered in capacity planning (APS). This option affects the same option in the work order position
Valid values: Yes=1
No=0
do not change=2
|
Confirmed
|
Work order approved
|
|
int(4)
|
Defines whether for this item version the work order position may be approved. This option affects the same option in the work order position
Valid values: Yes=1
No=0
do not change=2
|
CanModifyWo
|
Work order change allowed
|
|
int(4)
|
Defines whether for this item version, changes may be executed in the work order. This option affects the same option in the work order position.
Valid values: Yes=1
No=0
do not change=2
|
ChangeOpenWorkorders
|
Status update
|
|
int(4)
|
|
UDF1
|
Userfield 1
|
|
nvarchar(50)
|
|
UDF2
|
Userfield 2
|
|
nvarchar(50)
|
|
UDF3
|
Userfield 3
|
|
nvarchar(50)
|
|
UDF4
|
Userfield 4
|
|
nvarchar(50)
|
|