VQ3548J7 - Q35 Work Order Routing Join View F4801 F4801T F3112 All Columns

DocumentOrderInvoiceE

DOCO

INTEGER

F4801

DocumentOrderInvoiceE1

DOCO

INTEGER

F4801T

DocumentOrderInvoiceE2

DOCO

INTEGER

F3112

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

CostCenter1

MCU

BUSINESSUNIT

F3112

SequenceNoOperations

OPSQ

FLOAT

F3112

TypeOperationCode

OPSC

UDC

F3112

TypeRouting1

TRT

UDC

F3112

DescriptionLine1

DSC1

STRING

F3112

RunMachineStandard

RUNM

FLOAT

F3112

CrewSize1

SETC

FLOAT

F3112

RunLaborStandard

RUNL

FLOAT

F3112

SetupLaborHrsStdr

SETL

FLOAT

F3112

OperationStatusCodeWo

OPST

UDC

F3112

AddNoAssignedTo1

ANP

ADDRESSNUMBER

F3112

CostCenterAlt1

MMCU

BUSINESSUNIT

F3112

AddressNumber1

AN8

ADDRESSNUMBER

F3112

DateRequestedJulian1

DRQJ

DATE

F3112

DateStart1

STRT

DATE

F3112

DateCompletion1

STRX

DATE

F3112

UserReservedCode1

URCD

STRING

F3112

UserReservedDate1

URDT

DATE

F3112

UserReservedAmount1

URAT

FLOAT

F3112

UserReservedReference1

URRF

STRING

F3112

UserReservedNumber1

URAB

INTEGER

F3112

TimeScheduledStartHHMMSS1

SEST

INTEGER

F3112

TimeScheduledEndHHMMSS1

SEET

INTEGER

F3112

TimeCompleted1

TMCO

INTEGER

F3112

DateActualStartJ

D2J

DATE

F3112

TimeStartHHMMSS

STTI

INTEGER

F3112

ResourcesAssigned1

TRAF

UDC

F3112

TimeBasisCode

TIMB

UDC

F3112

LaborOrMachine

LAMC

UDC

F3112

MoveHours

MOVD

FLOAT

F3112

QueueHours

QUED

FLOAT

F3112

RunMachineActual

MACA

FLOAT

F3112

RunLaborActual

LABA

FLOAT

F3112

SetupLaborHoursActual

SETA

FLOAT

F3112

MachineRate

MACR

FLOAT

F3112

LaborRate

LABP

FLOAT

F3112

SetupLaborRate

SETR

FLOAT

F3112

AddressNumberManager1

ANSA

ADDRESSNUMBER

F3112

Supervisor1

ANPA

ADDRESSNUMBER

F3112

PayPointCode

BFPF

UDC

F3112

PayPointStatus

PPRF

UDC

F3112

ItemNumberShortKit

KIT

SHORTITEM

F3112

ItemNumber2ndKit

KITL

STRING

F3112

ItemNumber3rdKit

KITA

STRING

F3112

OrderType1

DCTO

UDC

F3112

OrderSuffix1

SFXO

STRING

F3112

LineIdentifier1

LINE

BUSINESSUNIT

F3112

AutoLoadDescription

ALD

UDC

F3112

InspectionCode

INPE

STRING

F3112

JobCategory1

JBCD

UDC

F3112

CriticalRatio

CRTR

FLOAT

F3112

SlackTimeRatio

SLTR

FLOAT

F3112

DateTransactionJulian1

TRDJ

DATE

F3112

ShiftCodeRequested

RSFT

CHARACTER

F3112

ShiftCodeStart

SSFT

CHARACTER

F3112

ShiftCodeCompleted

CSFT

CHARACTER

F3112

LeadtimeOverlap

LTPC

FLOAT

F3112

PercentOfOverlap

POVR

FLOAT

F3112

PercentOperationalPl

OPYP

FLOAT

F3112

PercentCumulativePla

CPYP

FLOAT

F3112

NextOperation

NXOP

FLOAT

F3112

OperationShrinkage

OPSR

FLOAT

F3112

UnitsTransactionQty1

UORG

FLOAT

F3112

UnitsQuantityCanceled1

SOCN

FLOAT

F3112

UnitsQuantityShipped1

SOQS

FLOAT

F3112

UnitsQuantityMovedT

QMTO

FLOAT

F3112

RatePiecework

PWRT

FLOAT

F3112

UnitOfMeasureAsInput1

UOM

UDC

F3112

UnacctSetupLaborHrs

CTS2

FLOAT

F3112

UnacctMachineHours

CTS3

FLOAT

F3112

UnacctDirectLaborAmt1

CTS4

FLOAT

F3112

UnacctDirectSetupAmt

CTS5

FLOAT

F3112

UnacctDirectMachAmt

CTS6

FLOAT

F3112

UnitNumber1

APID

STRING

F3112

MessageNo1

SHNO

STRING

F3112

PurchasingCostCenter

OMCU

BUSINESSUNIT

F3112

ObjectAccount1

OBJ

STRING

F3112

Subsidiary1

SUB

STRING

F3112

PrimaryLastVendorNo1

VEND

ADDRESSNUMBER

F3112

CompanyKeyRelated1

RKCO

COMPANY

F3112

RelatedPoSoNumber1

RORN

STRING

F3112

RelatedOrderType1

RCTO

UDC

F3112

RelatedPoSoLineNo

RLLN

FLOAT

F3112

DocumentType2

DCT

UDC

F3112

Location1

LOCN

LOCATION

F3112

Resourceunitsconsumed

RUC

FLOAT

F3112

UMCapacityUOM

CAPU

UDC

F3112

WorkcenterBranch

WMCU

BUSINESSUNIT

F3112

RunMachineCurrent

CMHR

FLOAT

F3112

RunLaborCurrent

CLHR

FLOAT

F3112

SetupLaborCurrent

CSHR

FLOAT

F3112

CostType

COST

UDC

F3112

ActivityCode

ACTB

STRING

F3112

AssetItemNumber1

NUMB

ASSETNUMBER

F3112

UnacctScrapAmt1

CTS7

FLOAT

F3112

UnacctScrapUnits1

CTS8

FLOAT

F3112

UnacctDirectLaborHrs1

CTS9

FLOAT

F3112

ConstraintsFlag

APSC

UDC

F3112

CompentencyType

CMPE

UDC

F3112

CompentencyCode

CMPC

STRING

F3112

CompetencyLevelFrom

CPLVLFR

FLOAT

F3112

CompetencyLevelTo

CPLVLTO

FLOAT

F3112

RuleMatchFlag

CMRQ

CHARACTER

F3112

MaintenanceScheduleFlag1

WSCHF

UDC

F3112

UserId1

USER

STRING

F3112

ProgramId1

PID

STRING

F3112

WorkStationId1

JOBN

STRING

F3112

DateUpdated1

UPMJ

DATE

F3112

TimeOfDay1

TDAY

INTEGER

F3112