Skip to main content
Skip table of contents

VQ353113 - Q35 Join View F3112/F4801/F31172

Cantara Business View Object

Fields

NameAliasTypeTable

DocumentOrderInvoiceE

DOCO

INTEGER

F3112

DocumentOrderInvoiceE1

DOCO

INTEGER

F4801

OrderType

DCTO

UDC

F3112

OrderType1

DCTO

UDC

F4801

DocumentOrderInvoiceE2

DOCO

INTEGER

F31172

SequenceNoOperations

OPSQ

FLOAT

F3112

SequenceNoOperations1

OPSQ

FLOAT

F31172

CostCenter

MCU

STRING

F3112

CostCenter1

MCU

STRING

F31172

TypeOperationCode

OPSC

UDC

F3112

TypeOperationCode1

OPSC

UDC

F31172

OperationStatusCodeWo

OPST

UDC

F3112

DateStart

STRT

DATE

F3112

DateRequestedJulian

DRQJ

DATE

F3112

UnitOfMeasureAsInput

UOM

UDC

F3112

UnitsQuantityMovedT

QMTO

FLOAT

F3112

UnitsTransactionQty

UORG

FLOAT

F3112

UnitsQuantityCanceled

SOCN

FLOAT

F3112

UnitsQuantityShipped

SOQS

FLOAT

F3112

CostCenterAlt

MMCU

STRING

F3112

RunMachineStandard

RUNM

FLOAT

F3112

RunLaborStandard

RUNL

FLOAT

F3112

SetupLaborHrsStdr

SETL

FLOAT

F3112

SetupLaborHoursActual

SETA

FLOAT

F3112

RunMachineActual

MACA

FLOAT

F3112

RunLaborActual

LABA

FLOAT

F3112

RelatedPoSoNumber

RORN

STRING

F4801

AddressNumber

AN8

INTEGER

F4801

Description001

DL01

STRING

F4801

ItemNumberShortKit

KIT

INTEGER

F3112

QueueHours

QUED

FLOAT

F3112

DescriptionLine1

DSC1

STRING

F3112

StatusCodeWo

SRST

UDC

F4801

TypeWo

TYPS

UDC

F4801

CostCenterAlt1

MMCU

STRING

F4801

CostCenter2

MCU

STRING

F4801

TypeRouting

TRT

UDC

F3112

OrderSuffix

SFXO

STRING

F3112

ItemNumber2ndKit

KITL

STRING

F3112

ItemNumber3rdKit

KITA

STRING

F3112

LineIdentifier

LINE

STRING

F3112

AutoLoadDescription

ALD

UDC

F3112

InspectionCode

INPE

STRING

F3112

TimeBasisCode

TIMB

UDC

F3112

LaborOrMachine

LAMC

UDC

F3112

PayPointCode

BFPF

UDC

F3112

PayPointStatus

PPRF

UDC

F3112

JobCategory

JBCD

UDC

F3112

AddressNumber1

AN8

INTEGER

F3112

CriticalRatio

CRTR

FLOAT

F3112

SlackTimeRatio

SLTR

FLOAT

F3112

DateTransactionJulian

TRDJ

DATE

F3112

DateCompletion

STRX

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

CrewSize

SETC

FLOAT

F3112

MoveHours

MOVD

FLOAT

F3112

OperationShrinkage

OPSR

FLOAT

F3112

RatePiecework

PWRT

FLOAT

F3112

UnacctSetupLaborHrs

CTS2

FLOAT

F3112

UnacctMachineHours

CTS3

FLOAT

F3112

UnacctDirectLaborAmt

CTS4

FLOAT

F3112

UnacctDirectSetupAmt

CTS5

FLOAT

F3112

UnacctDirectMachAmt

CTS6

FLOAT

F3112

UnitNumber

APID

STRING

F3112

MessageNo

SHNO

STRING

F3112

PurchasingCostCenter

OMCU

STRING

F3112

ObjectAccount

OBJ

STRING

F3112

Subsidiary

SUB

STRING

F3112

PrimaryLastVendorNo

VEND

INTEGER

F3112

CompanyKeyRelated

RKCO

STRING

F3112

RelatedPoSoNumber1

RORN

STRING

F3112

RelatedOrderType

RCTO

UDC

F3112

RelatedPoSoLineNo

RLLN

FLOAT

F3112

DocumentType

DCT

UDC

F3112

UserReservedCode

URCD

STRING

F3112

UserReservedDate

URDT

DATE

F3112

UserReservedAmount

URAT

FLOAT

F3112

UserReservedReference

URRF

STRING

F3112

UserReservedNumber

URAB

INTEGER

F3112

UserId

USER

STRING

F3112

ProgramId

PID

STRING

F3112

WorkStationId

JOBN

STRING

F3112

DateUpdated

UPMJ

DATE

F3112

TimeOfDay

TDAY

INTEGER

F3112

Location

LOCN

STRING

F3112

Resourceunitsconsumed

RUC

FLOAT

F3112

UMCapacityUOM

CAPU

UDC

F3112

WorkcenterBranch

WMCU

STRING

F3112

RunMachineCurrent

CMHR

FLOAT

F3112

RunLaborCurrent

CLHR

FLOAT

F3112

SetupLaborCurrent

CSHR

FLOAT

F3112

CostType

COST

UDC

F3112

ActivityCode

ACTB

STRING

F3112

AssetItemNumber

NUMB

INTEGER

F3112

UnacctScrapAmt

CTS7

FLOAT

F3112

UnacctScrapUnits

CTS8

FLOAT

F3112

UnacctDirectLaborHrs

CTS9

FLOAT

F3112

LaborRate

LABP

FLOAT

F3112

MachineRate

MACR

FLOAT

F3112

SetupLaborRate

SETR

FLOAT

F3112

ConstraintsFlag

APSC

UDC

F3112

TimeScheduledStartHHMMSS

SEST

INTEGER

F3112

TimeScheduledEndHHMMSS

SEET

INTEGER

F3112

TimeCompleted

TMCO

INTEGER

F3112

DateActualStartJ

D2J

DATE

F3112

TimeStartHHMMSS

STTI

INTEGER

F3112

CompentencyType

CMPE

UDC

F3112

CompentencyCode

CMPC

STRING

F3112

CompetencyLevelFrom

CPLVLFR

FLOAT

F3112

CompetencyLevelTo

CPLVLTO

FLOAT

F3112

RuleMatchFlag

CMRQ

CHARACTER

F3112

AddressNumberManager

ANSA

INTEGER

F3112

Supervisor

ANPA

INTEGER

F3112

AddNoAssignedTo

ANP

INTEGER

F3112

MaintenanceScheduleFlag

WSCHF

UDC

F3112

ResourcesAssigned

TRAF

UDC

F3112

TimeStartHHMMSS1

STTI

INTEGER

F31172

EstEndingHhMmSs

EPETM

INTEGER

F31172

RelatedOrderType1

RCTO

UDC

F4801

IdentifierShortItem

ITM

INTEGER

F4801

Identifier2ndItem

LITM

STRING

F4801

JavaScript errors detected

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

If this problem persists, please contact our support.