Skip to main content
Skip table of contents

VQ3548J4 - Q35 Work Order Parts Join View F4801 F4801T F3111 Selective Columns

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

Fields

NameAliasTypeTable

DocumentOrderInvoiceE

DOCO

INTEGER

F4801

DocumentOrderInvoiceE1

DOCO

INTEGER

F4801T

DocumentOrderInvoiceE2

DOCO

INTEGER

F3111

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

UniqueKeyIDInternal

UKID

INTEGER

F3111

SequenceNoOperations

OPSQ

FLOAT

F3111

TypeBill1

TBM

UDC

F3111

IssueTypeCode

ITC

UDC

F3111

ComponentItemNoShort

CPIT

INTEGER

F3111

ComponentItemNo2nd

CPIL

STRING

F3111

BranchComponent

CMCU

BUSINESSUNIT

F3111

DescriptionLine1

DSC1

STRING

F3111

DescriptionLine2

DSC2

STRING

F3111

CompanyKeyRelated1

RKCO

COMPANY

F3111

RelatedPoSoNumber1

RORN

STRING

F3111

RelatedOrderType1

RCTO

UDC

F3111

RelatedPoSoLineNo

RLLN

FLOAT

F3111

LineType

LNTY

STRING

F3111

AddressNumber1

AN8

ADDRESSNUMBER

F3111

PrimaryLastVendorNo

VEND

ADDRESSNUMBER

F3111

CostCenter1

MCU

BUSINESSUNIT

F3111

PurchasingCostCenter

OMCU

BUSINESSUNIT

F3111

ObjectAccount

OBJ

STRING

F3111

Subsidiary1

SUB

STRING

F3111

CoproductsByproducts

COBY

UDC

F3111

ComponentNumber

CPNT

FLOAT

F3111

Location1

LOCN

LOCATION

F3111

Lot

LOTN

STRING

F3111

UnitsTransactionQty

UORG

FLOAT

F3111

QuantityTransaction

TRQT

FLOAT

F3111

UnitOfMeasure

UM

UDC

F3111

MaterialStatusCodeWo

MTST

UDC

F3111

DateRequestedJulian1

DRQJ

DATE

F3111

UnitsQuantityCanceled

SOCN

FLOAT

F3111

UnitsQuanBackorHeld

SOBK

FLOAT

F3111

EstimatedAmount

EA

FLOAT

F3111

MessageNo1

SHNO

STRING

F3111

UserReservedCode1

URCD

STRING

F3111

UserReservedDate1

URDT

DATE

F3111

UserReservedAmount1

URAT

FLOAT

F3111

UserReservedReference1

URRF

STRING

F3111

UserReservedNumber1

URAB

INTEGER

F3111

UserId1

USER

STRING

F3111

JavaScript errors detected

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

If this problem persists, please contact our support.