Display all work orders.
Table: BEAS_FTHAUPT
Column |
Description |
Table Info |
DocEntry |
Document Entry (internal number) |
BEAS_FTHAUPT.BELNR_ID |
DocNum |
Document Number (alphanumeric) |
BEAS_FTHAUPT.AUFTRAG |
DocDate |
Date of creation |
BEAS_FTHAUPT.BELDAT |
DeliveryDate |
Planned delivery date |
BEAS_FTHAUPT.LFGDAT |
CardCode |
Customer CardCode, Link: OCRD.CardCode
If the info is not customer order/related, this is empty. |
BEAS_FTHAUPT.KND_ID |
MailAddress |
Street |
BEAS_FTHAUPT.KNDSTRASSE |
MailZipCode |
ZipCode |
BEAS_FTHAUPT.KNDPLZ |
MailCity |
City |
BEAS_FTHAUPT.KNDORT |
Phone1 |
Phone Number |
BEAS_FTHAUPT.KNDTELEFON1 |
Lock |
Work order locked? 1=yes,0=No |
BEAS_FTHAUPT.SPERRUNG |
Closed |
Work order closed? 1=yes,0=No |
BEAS_FTHAUPT.ABGKZ |
Priority |
Work order Priority. Linked to BEAS_PRJ.PRIOR_ID |
BEAS_FTHAUPT.PRIOR_ID |
StartDate |
Planned start date of work order |
BEAS_FTHAUPT.ANFZEIT |
EndDate |
Planned end date of work order |
BEAS_FTHAUPT.ENDZEIT |
PrintStatus |
Status Print work order: 1=printed, 0=not printed |
BEAS_FTHAUPT.DRUCKKZ |
ItemCode |
ItemCode from first work order position |
BEAS_FTHAUPT.ItemCode |
OrderBitmap |
Bitmap for this work order |
BEAS_FTHAUPT.BITMAPCLOSE |
WorkTime |
Sum of all work times in minutes |
BEAS_ARBZEIT |
Receipt_count |
Count of receipts |
|
ReservedTime |
Sum of reserved work time (current open times) |
BEAS_RESOURCEN |
ScheduleAutomatically |
Automatic Scheduling Active 1/0 |
BEAS_FTHAUPT.TIMECALCULATE |
PrjCode |
Project Code (Linked to OPRJ) |
BEAS_FTHAUPT.PROJECT |
PRJUID |
Project Task Code |
BEAS_FTHAUPT.PRJUID |
BPLid |
Branch |
BEAS_FTHAUPT.BPLid |
WorkOrderStatus |
Status of work order |
BEAS_FTHAUPT.STATUS_ID |
UDF1...UDF4 |
Free fields |
BEAS_FTHAUPT.UDF1...4 |