BEASV_WORKORDER

 

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 9.3 PL 2

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