Skip to main content
Skip table of contents

VQ3548J1 - Q35 Equipment Work Orders Join F4801 F4801T F1307


Cantara Business View Object which joins standard JDE tables F4801, F4801T and F1307.


Fields

Name

Alias

Type

Table

DocumentOrderInvoiceE

DOCOINTEGERF4801

DocumentOrderInvoiceE1

DOCOINTEGERF4801T

OrderType

DCTOUDCF4801

RelatedPoSoNumber

RORNSTRINGF4801

RelatedOrderType

RCTOUDCF4801

CompanyKeyRelated

RKCOSTRINGF4801

OrderSuffix

SFXOSTRINGF4801

LineNumber

LNIDFLOATF4801

ParentWoNumber

PARSSTRINGF4801

TypeWo

TYPSUDCF4801

PriorityWo

PRTSUDCF4801

Description001

DL01STRINGF4801

StatusCommentWo

STCMSTRINGF4801

Company

COSTRINGF4801

CostCenter

MCUSTRINGF4801

CostCenterAlt

MMCUSTRINGF4801

Location

LOCNSTRINGF4801

StatusCodeWo

SRSTUDCF4801

Subsidiary

SUBSTRINGF4801

AddressNumber

AN8INTEGERF4801

AddNoOriginator

ANOINTEGERF4801

AddressNumberManager

ANSAINTEGERF4801

Supervisor

ANPAINTEGERF4801

AddNoAssignedTo

ANPINTEGERF4801

ServiceAddressNumber

SAIDINTEGERF4801

AddressNumberInspector

ANTINTEGERF4801

NextAddressNumber

NAN8INTEGERF4801

DateTransactionJulian

TRDJDATEF4801

DateStart

STRTDATEF4801

DateRequestedJulian

DRQJDATEF4801

DateWoPlanCompleted

DPLDATEF4801

DateCompletion

STRXDATEF4801

DateAssignedTo

DAPDATEF4801

DateAssignToInspector

DATDATEF4801

DateScheduledTickler

TDTDATEF4801

BeginningHhMmSs

PBTMINTEGERF4801

CategoriesWorkOrder001

WR01UDCF4801

CategoriesWorkOrder002

WR02UDCF4801

CategoriesWorkOrder003

WR03UDCF4801

CategoriesWorkOrder004

WR04UDCF4801

CategoriesWorkOrder005

WR05UDCF4801

CategoriesWorkOrder006

WR06UDCF4801

CategoriesWorkOrder007

WR07UDCF4801

CategoriesWorkOrder008

WR08UDCF4801

CategoriesWorkOrder009

WR09UDCF4801

CategoriesWorkOrder010

WR10UDCF4801

AmountOriginalDollars

AMTOFLOATF4801

HoursOriginal

HRSOFLOATF4801

EstimatedDowntimeHours

ESDNFLOATF4801

AmountActual

AMTAFLOATF4801

HoursActual

HRSAFLOATF4801

ActualDowntimeHours

ACDNFLOATF4801

IdentifierShortItem

ITMINTEGERF4801

TypeBill

TBMUDCF4801

TypeRouting

TRTUDCF4801

AssetItemNumber

NUMBINTEGERF4801

ParentNumber

AAIDINTEGERF4801

UnitsTransactionQty

UORGFLOATF4801

MessageNo

SHNOSTRINGF4801

WoFlashMessage

SPRTUDCF4801

PercentComplete

PCFLOATF4801

Reference1

VR01STRINGF4801

ApprovalType

APRTUDCF4801

SubledgerInactiveCode

SBLIUDCF4801

UserId

USERSTRINGF4801

ProgramId

PIDSTRINGF4801

WorkStationId

JOBNSTRINGF4801

DateUpdated

UPMJDATEF4801

TimeOfDay

TDAYINTEGERF4801

PegToWorkOrder

PTWOINTEGERF4801

Reference2Vendor

VR02STRINGF4801

UnitOfMeasureAsInput

UOMUDCF4801

Lot

LOTNSTRINGF4801

AmtChngToOriginalD

AMTCFLOATF4801

UserReservedCode

URCDSTRINGF4801

UserReservedAmount

URATFLOATF4801

UserReservedDate

URDTDATEF4801

UserReservedNumber

URABINTEGERF4801

UserReservedReference

URRFSTRINGF4801

CrewSize

SETCFLOATF4801

UnitNumber

APIDSTRINGF4801
JavaScript errors detected

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

If this problem persists, please contact our support.