Displays all work order positions.
Link: BEASV_WORKORDER.DocEntry = BEASV_WORKORDER_POS.DocEntry
Table: BEAS_FTPOS
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 |