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