Skip to main content

VQ3548J3 - Q35 Work Orders Join View F4801 F4801T All Columns

Cantara Business View Object for Work Orders which joins all 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

AmountEstimatedLabor

AMLC

FLOAT

F4801

AmountEstimatedMaterial

AMMC

FLOAT

F4801

AmountEstimatedOther

AMOT

FLOAT

F4801

AmountActualLabor

LBAM

FLOAT

F4801

AmountActualMaterial

MTAM

FLOAT

F4801

PegToWorkOrder

PTWO

INTEGER

F4801

AisleLocation

AISL

STRING

F4801

BinLocation

BIN

STRING

F4801

DateStatusChanged

DCG

DATE

F4801

NextAddressNumber

NAN8

ADDRESSNUMBER

F4801

DateAssignedTo

DAP

DATE

F4801

DateAssignToInspector

DAT

DATE

F4801

PaperPrintedDate

PPDT

DATE

F4801

AmountOriginalDollars

AMTO

FLOAT

F4801

CrewSize

SETC

FLOAT

F4801

RateDistribuOrBill

BRT

FLOAT

F4801

PayDeductBenefitType

PAYT

STRING

F4801

AmtChngToOriginalD

AMTC

FLOAT

F4801

HrsChngToOriginalHo

HRSC

FLOAT

F4801

Identifier3rdItem

AITM

STRING

F4801

Identifier2ndItem

LITM

STRING

F4801

UnitsTransactionQty

UORG

FLOAT

F4801

UnitsQuanBackorHeld

SOBK

FLOAT

F4801

UnitsQuantityCanceled

SOCN

FLOAT

F4801

UnitsQuantityShipped

SOQS

FLOAT

F4801

QuantityShippedToDate

QTYT

FLOAT

F4801

UnitOfMeasureAsInput

UOM

UDC

F4801

WoPickListPrinted

SHTY

UDC

F4801

PostingEdit

PEC

UDC

F4801

VarianceFlag

PPFG

UDC

F4801

BillOfMaterialN

BM

CHARACTER

F4801

RouteSheetN

RTG

CHARACTER

F4801

WoOrderFreezeCode

UNCD

UDC

F4801

IndentedCode

INDC

CHARACTER

F4801

SequenceCode

RESC

FLOAT

F4801

AmtMilesOrHoursUnit

MOH

FLOAT

F4801

DateScheduledTickler

TDT

DATE

F4801

AmtProjectedOverUnder

POU

FLOAT

F4801

PercentComplete

PC

FLOAT

F4801

LeadtimeLevel

LTLV

INTEGER

F4801

LeadtimeCum

LTCM

INTEGER

F4801

UnacctDirectLaborHrs

CTS1

FLOAT

F4801

Lot

LOTN

STRING

F4801

LotPotency

LOTP

FLOAT

F4801

LotGrade

LOTG

UDC

F4801

CriticalRatioPriority1

RAT1

FLOAT

F4801

CriticalRatioPriority2

RAT2

FLOAT

F4801

DocumentType

DCT

UDC

F4801

BillRevisionLevel

BREV

STRING

F4801

RoutingRevisionLevel

RREV

STRING

F4801

DrawingChange

DRWC

CHARACTER

F4801

RoutingChangeEco

RTCH

CHARACTER

F4801

NewPartNumberRequired

PNRQ

CHARACTER

F4801

Reason

REAS

UDC

F4801

PhaseIn

PHSE

UDC

F4801

ExistingDisposition

XDSP

UDC

F4801

BillOfMaterialsChange

BOMC

CHARACTER

F4801

ProgramId

PID

STRING

F4801

WorkStationId

JOBN

STRING

F4801

ParentNumber

AAID

INTEGER

F4801

NextStatusWO

NTST

UDC

F4801

CriticalityWorkOrder

XRTO

INTEGER

F4801

MeterPosition

MPOS

INTEGER

F4801

ApprovalType

APRT

UDC

F4801

LineIdentifier

LINE

BUSINESSUNIT

F4801T

MonthWeekDayHour

MWDH

UDC

F4801T

ScheduleSpread

SCSP

INTEGER

F4801T

ShiftCode

SHFT

UDC

F4801T

Serializedcomponents

SRCN

UDC

F4801T

LedgType

LEDG

UDC

F4801T

UnacctDirectLaborAmt

CTS4

FLOAT

F4801T

UnacctScrapAmt

CTS7

FLOAT

F4801T

UnacctScrapUnits

CTS8

FLOAT

F4801T

AccountId

AID

ACCOUNTID

F4801T

AlertSensitiveTask

ALSE

CHARACTER

F4801T

BubbleSequence

BSEQ

INTEGER

F4801T

ChargeCosttoProjectAccount

CHPR

CHARACTER

F4801T

CurrencyCodeFrom

CRCD

STRING

F4801T

CurrencyCodeSource

CRCE

STRING

F4801T

CurrencyCodeOrigin

CRCF

STRING

F4801T

DateOther5J

D5J

DATE

F4801T

DateOther6J

D6J

DATE

F4801T

DrawingNumber

DRAW

STRING

F4801T

DualUnitOfMeasureItem

DUAL

CHARACTER

F4801T

ProductionCostsExist

MPCE

UDC

F4801T

ChangesToPartsAndRoutingsAllow

MPRC

UDC

F4801T

ObjectAccount

OBJ

STRING

F4801T

AmountActualOther

OTAM

FLOAT

F4801T

ProjectNumber

PRJM

INTEGER

F4801T

DirectProjectRelationship

PRRP

CHARACTER

F4801T

ShipThisPhase

SHPP

UDC

F4801T

UnitsSecondaryQtyOr

SQOR

FLOAT

F4801T

ShrinkFactorMethod

SRKF

UDC

F4801T

ShrinkFactor

SRNK

FLOAT

F4801T

SecondaryQuantityCompleted

SSOQ

FLOAT

F4801T

ResourcesAssigned

TRAF

UDC

F4801T

UnitOfMeasureSecondary

UOM2

UDC

F4801T

JobCategory

JBCD

UDC

F4801T

FirmWorkOrder

VFWO

CHARACTER

F4801T

PromotionID

PMTN

STRING

F4801T

MethodofPricing

MTHPR

UDC

F4801T

EntitlementCheck

ENTCK

UDC

F4801T

PaymentInstrumentA

RYIN

UDC

F4801T

ResponseTime

RSTM

FLOAT

F4801T

Country

CTR

UDC

F4801T

GeographicRegion

REGION

UDC

F4801T

TaxArea1

TXA1

STRING

F4801T

TaxExplanationCode1

EXR1

UDC

F4801T

LanguagePreference

LNGP

UDC

F4801T

GLCategoryCovered

GLCCV

UDC

F4801T

GLCategoryNonCovered

GLCNC

UDC

F4801T

PriceAdjustScheduleFour

ASN4

UDC

F4801T

CoverageGroup

COVGR

UDC

F4801T

PriceAdjustScheduleService

ASN2

UDC

F4801T

DaylightSavingsRuleName

DSAVNAME

STRING

F4801T

TimeZoes

TIMEZONES

UDC

F4801T

CausalPart

CSLPRT

SHORTITEM

F4801T

CostCenterCsl

MCUCSL

BUSINESSUNIT

F4801T

VendorLotNumber

RLOT

STRING

F4801T

DefectCode

FAILCD

UDC

F4801T

FailureDate

FAILDT

DATE

F4801T

FailureTime

FAILTM

INTEGER

F4801T

RepairDate

REPDT

DATE

F4801T

RepairTime

REPTM

INTEGER

F4801T

PrimaryLastVendorNo

VEND

ADDRESSNUMBER

F4801T

AssessorNumber

AN8AS

ADDRESSNUMBER

F4801T

SupplierRecoveryManagerNumber

AN8SRM

ADDRESSNUMBER

F4801T

EligibleSupplierRecovery

SRYN

UDC

F4801T

EntitlementCheckSupplier

ENTCKS

STRING

F4801T

CurrentBalanceMeter1

CURBALM1

INTEGER

F4801T

CurrentBalanceMeter2

CURBALM2

INTEGER

F4801T

CurrentBalanceMeter3

CURBALM3

INTEGER

F4801T

CurrencyCodeTo

CRDC

STRING

F4801T

CurrencyMode

CRRM

UDC

F4801T

CurrencyConverRateOv

CRR

FLOAT

F4801T

CompCode-Grp_Sys

VMRS31

UDC

F4801T

CompCode-Assembly

VMRS32

UDC

F4801T

SequenceNumber2

SEQN

FLOAT

F4801T

PlannedMaterial

PLMR

FLOAT

F4801T

PlannedLabor

PLLB

FLOAT

F4801T

PlannedOther

PLOS

FLOAT

F4801T

BudgetedCost

BGTC

FLOAT

F4801T

TotalEstimated

TOEM

FLOAT

F4801T

TotalPlanned

TOPL

FLOAT

F4801T

PlannedSpecialAmount

PLSA

FLOAT

F4801T

PlannedSpecialUnits

PLSU

FLOAT

F4801T

EstimatedSpecialAmount

ESSA

FLOAT

F4801T

EstimatedSpecialUnits

ESSU

FLOAT

F4801T

ActualSpecialAmount

ACSA

FLOAT

F4801T

ActualSpecialUnits

ACSU

FLOAT

F4801T

OriginalAmountCommitted

OACM

FLOAT

F4801T

RemainingAmountCommitted

RACM

FLOAT

F4801T

HeldPartsListFlag

HPLF

CHARACTER

F4801T

CompCode-Part

VMRS33

UDC

F4801T

SecondRequest

SCALL

UDC

F4801T

IssueNumber

ISNO

INTEGER

F4801T

ReimbursementMethod

RMTHD

CHARACTER

F4801T

DocVoucherInvoiceE

DOC

INTEGER

F4801T

DocumentType1

DCT

UDC

F4801T

CompanyKey

KCO

COMPANY

F4801T

ContractChangeNum

COCH

STRING

F4801T

LineNumber1

LNID

FLOAT

F4801T

CreatedByUser

CRTU

STRING

F4801T

ExternalEventFlag

XEVT

CHARACTER

F4801T

MaintenanceScheduleFlag

WSCHF

UDC

F4801T

DFMDailyPlan

DFMDP

CHARACTER

F4801T

ProductionNumber

PMPN

STRING

F4801T

ProductionNumberShort

PNS

INTEGER

F4801T

JavaScript errors detected

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

If this problem persists, please contact our support.