BEASV_WORKORDER_POS

Column

Description

Table Info

DocEntry

Document Entry (internal number)

BEAS_FTHAUPT.BELNR_ID

DocNum

Document Number (alphanumeric)

BEAS_FTHAUPT.AUFTRAG

DocDate

Date of Document

BEAS_FTHAUPT.BELDAT

LineNumber

Number of work order position

BEAS_FTPOS.BELPOS_ID

Level

Structure Level of this position. Main Level have "0", Sublevel: 1,2 and so on

Sub Levels assigned with fields AssignedToLineNumber to parent Levels

BEAS_FTPOS.STUFE

ItemCode

The ItemCode of Assembly

BEAS_FTPOS.ItemCode

QuantityWhsUnit

Planned quantity in Inventory UoM

BEAS_FTPOS.MENGE

WhsUnit

Inventory UoM

OITM.InvntryUom

QuantityBomUnit

Planned quantity in Production UoM

BEAS_FTPOS.MENGE_VERBRAUCH

BomUnit

Production UoM

BEAS_FTPOS.ME_VERBRAUCH

QuantityScrap

Planned scrap quantity in Production UoM

BEAS_FTPOS.MENGE_VERSCHNITT

WhsCode

Warehouse Code

BEAS_FTPOS.WhsCode

InWork

Return if Position is in work

0 = no, 1 = current running, 2 = minimal one time receipt existing

beas 9.3 PL 2

DrawingNumber

Drawing number from assembly

BEAS_FTPOS.U_ZNR

DIN

Din Number

BEAS_FTPOS.DIN

RawMaterial

Raw Material Number

BEAS_FTPOS.WST_ID

MatchCode

MatchCode Number

BEAS_FTPOS.MATCH

Configuration

Product configuration Number

BEAS_FTPOS.VRI

ShortVariant

ShortVariant (A-Z)

BEAS_FTPOS.SHORTVARIANT

DeliveryDate

Planned delivery Date

BEAS_FTPOS.LIEFERDATUM

CardCode

Customer Card Code

BEAS_FTHAUPT.KND_ID

CardName

Customer Card Name

BEAS_FTHAUPT.KNDNAME

AssignToLineNumber

Parent work order line number Number if this position a sub level

BEAS_FTPOS.ZU_BELPOS_ID

AssignToLineNumber2

Linked to parent Bill of materials number

BEAS_FTPOS.ZU_POS_ID

Approved

Flag Approved 1/0

BEAS_FTPOS.Confirmed

CapacityPlanning

Flag Capacity Planning 1/0

BEAS_FTPOS.StartCapacityPlanung

MaterialPlanning

Flag Material Planning 1/0

BEAS_FTPOS.StartDisposition

LoginToWorkOrder

Flag Login to Work order 1/0

BEAS_FTPOS.StartTimeRequests

MaterialBooking

Flag Material booking  1/0

BEAS_FTPOS.StartBooking

CanModifyWo

Flag Can Modify Wo 1/0

BEAS_FTPOS.ChangeAllow

Lock

Flag Lock (Work order Level) 1/0

BEAS_FTHAUPT.SPERRUNG

Closed

Position closed? 1/0

BEAS_FTPOS.AbgKz

Priority

Priority (Work order Level)

BEAS_FTHAUPT.PRIOR_ID

StartDate

Start Date/Time of this Position

BEAS_FTPOS.ANFZEIT

EndDate

End Date/Time of this Position

BEAS_FTPOS.ENDZEIT

PrintStatus

Position Printed? 1/0

BEAS_FTPOS.DRUCKKZ

WorkTime

Sum current work time in this position

BEAS_ARBZEIT

ReservedTime

Currently reserved resource time

BEAS_RESOURCE

PrjCode

Project Code, linked to OPRJ.PrjCode

BEAS_FTPOS.PROJECT

PrjTask

Project Task

BEAS_FTPOS.PRJUID

BillOfMaterialId

Used Bill of Materials

Linked to BEAS_STL_HEADER.ItemCode

BEAS_FTPOS.StlItemCode

RoutingId

Used Routing

Linked to

BEAS_APL_HEADER.ItemCode

BEAS_FTPOS.RoutingId

CreationDate

Date of Creation

BEAS_FTPOS.ERFTSTAMP

CreationUser

User of Creation

BEAS_FTPOS.ERFUSER

InWork

AutomaticallyScheduled

PositionClosed

LastMaterialReceiptDate

LastWorkReceiptDate

WorkOrderStartDate

Starttime for Workorder

BEAS_FTHAUPT.ANFZEIT

WorkOrderEndDate

Endtime for Workorder

BEAS_FTHAUPT.ENDZEI

Worktime

Sum of all work times

Receipt_count

Count of receipts