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
Name | Alias | Type | Table |
---|---|---|---|
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 |