Skip to main content
Skip table of contents

VQ3548J5 - Q35 Work Order Parts Join View F4801 F4801T F3111 All Columns

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

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

UniqueKeyIDInternal

UKID

INTEGER

F3111

SequenceNoOperations

OPSQ

FLOAT

F3111

TypeBill1

TBM

UDC

F3111

IssueTypeCode

ITC

UDC

F3111

CoproductsByproducts

COBY

UDC

F3111

ComponentNumber

CPNT

FLOAT

F3111

LineType

LNTY

STRING

F3111

ComponentItemNoShort

CPIT

INTEGER

F3111

ComponentItemNo2nd

CPIL

STRING

F3111

ComponentThirdNumber

CPIA

STRING

F3111

BranchComponent

CMCU

BUSINESSUNIT

F3111

DescriptionLine1

DSC1

STRING

F3111

DescriptionLine2

DSC2

STRING

F3111

Location1

LOCN

LOCATION

F3111

Lot1

LOTN

STRING

F3111

UnitsTransactionQty1

UORG

FLOAT

F3111

QuantityTransaction

TRQT

FLOAT

F3111

UnitsQuantityCanceled1

SOCN

FLOAT

F3111

UnitsQuanBackorHeld1

SOBK

FLOAT

F3111

UnacctDirectLaborHrs1

CTS1

FLOAT

F3111

UnitsQuantityAllocat

QNTA

FLOAT

F3111

UnitOfMeasure

UM

UDC

F3111

CostCenter1

MCU

BUSINESSUNIT

F3111

AddressNumber1

AN8

ADDRESSNUMBER

F3111

PrimaryLastVendorNo1

VEND

ADDRESSNUMBER

F3111

PurchasingCostCenter

OMCU

BUSINESSUNIT

F3111

ObjectAccount1

OBJ

STRING

F3111

Subsidiary1

SUB

STRING

F3111

CompanyKeyRelated1

RKCO

COMPANY

F3111

RelatedPoSoNumber1

RORN

STRING

F3111

RelatedOrderType1

RCTO

UDC

F3111

RelatedPoSoLineNo

RLLN

FLOAT

F3111

DateRequestedJulian1

DRQJ

DATE

F3111

DateTransactionJulian1

TRDJ

DATE

F3111

EstimatedAmount

EA

FLOAT

F3111

MaterialStatusCodeWo

MTST

UDC

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

ProgramId1

PID

STRING

F3111

WorkStationId1

JOBN

STRING

F3111

DateUpdated1

UPMJ

DATE

F3111

TimeOfDay1

TDAY

INTEGER

F3111

OrderType1

DCTO

UDC

F3111

OrderSuffix1

SFXO

STRING

F3111

FixedOrVariableQty

FORQ

UDC

F3111

ComponentType

COTY

UDC

F3111

FromPotency

FRMP

FLOAT

F3111

ThruPotency

THRP

FLOAT

F3111

FromGrade

FRGD

UDC

F3111

ThruGrade

THGD

UDC

F3111

BubbleSequence1

BSEQ

INTEGER

F3111

ResourcePercent

RSCP

FLOAT

F3111

PercentOfScrap

SCRP

FLOAT

F3111

ReworkPercent

REWP

FLOAT

F3111

AsIsPercent

ASIP

FLOAT

F3111

PercentCumulativePla

CPYP

FLOAT

F3111

StepScrapPercent

STPP

FLOAT

F3111

LeadtimeOffsetDays

LOVD

INTEGER

F3111

SerialNumberLot

SERN

STRING

F3111

RouteSheetN1

RTG

CHARACTER

F3111

DocumentType2

DCT

UDC

F3111

MessageNo1

SHNO

STRING

F3111

ComponentRevisionLevel

CMRV

STRING

F3111

DateCompletion1

STRX

DATE

F3111

ParentWoNumber1

PARS

STRING

F3111

CommittedHS

COMM

UDC

F3111

Payonconsumption

POC

UDC

F3111

UnacctDirectLaborAmt1

CTS4

FLOAT

F3111

UnacctScrapAmt1

CTS7

FLOAT

F3111

UnacctScrapUnits1

CTS8

FLOAT

F3111

JeGlDate

GLD

DATE

F3111

cSubstituteFlag

SBFL

CHARACTER

F3111

ActiveIngredientFlag

AING

CHARACTER

F3111

SecondaryIssued_CompletedQuantity

SSTQ

FLOAT

F3111

UnitOfMeasureSecondary1

UOM2

UDC

F3111

ConstraintsFlag

APSC

UDC

F3111

PickSlipNumber

PSN

INTEGER

F3111

LotEffectivityDate

DLEJ

DATE

F3111

CostType

COST

UDC

F3111

CriticalHoldPropagation

CHPP

CHARACTER

F3111

ComponentNumberBOM

CPNB

FLOAT

F3111

BubbleSequenceAlphaNum

BSEQAN

STRING

F3111

JavaScript errors detected

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

If this problem persists, please contact our support.