Skip to main content
Skip table of contents

VQ3548J2 - Q35 Work Orders Join View F4801 F4801T Selective Columns

Cantara Business View Object for Work Orders which joins selective columns of standard JDE tables F4801 and F4801T.

Fields

NameAliasTypeTable

DocumentOrderInvoiceE

DOCO

INTEGER

F4801

DocumentOrderInvoiceE1

DOCO

INTEGER

F4801T

OrderType

DCTO

UDC

F4801

OrderSuffix

SFXO

STRING

F4801

RelatedOrderType

RCTO

UDC

F4801

RelatedPoSoNumber

RORN

STRING

F4801

LineNumber

LNID

FLOAT

F4801

TypeWo

TYPS

UDC

F4801

ParentWoNumber

PARS

STRING

F4801

PriorityWo

PRTS

UDC

F4801

Description001

DL01

STRING

F4801

CostCenter

MCU

BUSINESSUNIT

F4801

CostCenterAlt

MMCU

BUSINESSUNIT

F4801

Location

LOCN

LOCATION

F4801

StatusCodeWo

SRST

UDC

F4801

Subsidiary

SUB

STRING

F4801

AddressNumber

AN8

ADDRESSNUMBER

F4801

AddNoOriginator

ANO

ADDRESSNUMBER

F4801

AddressNumberManager

ANSA

ADDRESSNUMBER

F4801

Supervisor

ANPA

ADDRESSNUMBER

F4801

AddNoAssignedTo

ANP

ADDRESSNUMBER

F4801

AddressNumberInspector

ANT

ADDRESSNUMBER

F4801

CategoriesWorkOrder001

WR01

UDC

F4801

CategoriesWorkOrder002

WR02

UDC

F4801

CategoriesWorkOrder003

WR03

UDC

F4801

CategoriesWorkOrder004

WR04

UDC

F4801

CategoriesWorkOrder005

WR05

UDC

F4801

CategoriesWorkOrder006

WR06

UDC

F4801

CategoriesWorkOrder007

WR07

UDC

F4801

CategoriesWorkOrder008

WR08

UDC

F4801

CategoriesWorkOrder009

WR09

UDC

F4801

CategoriesWorkOrder010

WR10

UDC

F4801

Reference1

VR01

STRING

F4801

Reference2Vendor

VR02

STRING

F4801

HoursOriginal

HRSO

FLOAT

F4801

AmountActual

AMTA

FLOAT

F4801

HoursActual

HRSA

FLOAT

F4801

AssetItemNumber

NUMB

ASSETNUMBER

F4801

UnitNumber

APID

STRING

F4801

TypeBill

TBM

UDC

F4801

TypeRouting

TRT

UDC

F4801

WoFlashMessage

SPRT

UDC

F4801

UserReservedCode

URCD

STRING

F4801

UserReservedDate

URDT

DATE

F4801

UserReservedAmount

URAT

FLOAT

F4801

UserReservedNumber

URAB

INTEGER

F4801

UserReservedReference

URRF

STRING

F4801

UserId

USER

STRING

F4801

DateUpdated

UPMJ

DATE

F4801

TimeOfDay

TDAY

INTEGER

F4801

EstimatedDowntimeHours

ESDN

FLOAT

F4801

ActualDowntimeHours

ACDN

FLOAT

F4801

DateActualToStart

ATST

DATE

F4801T

DateStart

STRT

DATE

F4801

DateTransactionJulian

TRDJ

DATE

F4801

DateRequestedJulian

DRQJ

DATE

F4801

DateCompletion

STRX

DATE

F4801

DateWoPlanCompleted

DPL

DATE

F4801

ECOworkbenchselections

WR11

UDC

F4801T

CategoriesWorkOrder12

WR12

UDC

F4801T

CategoriesWorkOrder13

WR13

UDC

F4801T

CategoriesWorkOrder14

WR14

UDC

F4801T

CategoriesWorkOrder15

WR15

UDC

F4801T

CategoriesWorkOrder16

WR16

UDC

F4801T

CategoriesWorkOrder17

WR17

UDC

F4801T

CategoriesWorkOrder18

WR18

UDC

F4801T

CategoriesWorkOrder19

WR19

UDC

F4801T

CategoriesWorkOrder20

WR20

UDC

F4801T

ISSUE

ISSUE

STRING

F4801T

ProductModel

PRODM

UDC

F4801T

ProductFamily

PRODF

UDC

F4801T

ContactName2

WHO2

STRING

F4801T

TimeScheduledStartHHMMSS

SEST

INTEGER

F4801T

TimeScheduledEndHHMMSS

SEET

INTEGER

F4801T

Company

CO

COMPANY

F4801

StatusCommentWo

STCM

STRING

F4801

CompanyKeyRelated

RKCO

COMPANY

F4801

ServiceAddressNumber

SAID

INTEGER

F4801

BeginningHhMmSs

PBTM

INTEGER

F4801

IdentifierShortItem

ITM

SHORTITEM

F4801

MessageNo

SHNO

STRING

F4801

SubledgerInactiveCode

SBLI

UDC

F4801

PhoneAreaCode1

AR1

STRING

F4801T

PhoneNumberOne

PHN1

STRING

F4801T

TimeCompleted

TMCO

INTEGER

F4801T

SerialTagNumber

ASID

STRING

F4801T

WorkCenterLeadCraft

MCULT

STRING

F4801T

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.