VQ353112 - Q35 Join View F3112 F4801
Cantara Business View Object which joins standard JDE tables F4801 and F3112
Fields
| Name | Alias | Type | Table |
|---|---|---|---|
| DocumentOrderInvoiceE | DOCO | INTEGER | F3112 |
| DocumentOrderInvoiceE1 | DOCO | INTEGER | F4801 |
| OrderType | DCTO | UDC | F3112 |
| OrderType1 | DCTO | UDC | F4801 |
| CostCenter | MCU | BUSINESSUNIT | F3112 |
| SequenceNoOperations | OPSQ | FLOAT | F3112 |
| TypeOperationCode | OPSC | UDC | F3112 |
| OperationStatusCodeWo | OPST | UDC | F3112 |
| DateStart | STRT | DATE | F3112 |
| DateRequestedJulian | DRQJ | DATE | F3112 |
| UnitOfMeasureAsInput | UOM | UDC | F3112 |
| UnitsQuantityMovedT | QMTO | INTEGER | F3112 |
| UnitsTransactionQty | UORG | INTEGER | F3112 |
| UnitsQuantityCanceled | SOCN | INTEGER | F3112 |
| UnitsQuantityShipped | SOQS | INTEGER | F3112 |
| CostCenterAlt | MMCU | BUSINESSUNIT | 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 | ADDRESSNUMBER | F4801 |
| Description001 | DL01 | STRING | F4801 |
| ItemNumberShortKit | KIT | SHORTITEM | F3112 |
| QueueHours | QUED | FLOAT | F3112 |
| DescriptionLine1 | DSC1 | STRING | F3112 |
| StatusCodeWo | SRST | UDC | F4801 |
| TypeWo | TYPS | UDC | F4801 |
| CostCenterAlt1 | MMCU | BUSINESSUNIT | F4801 |
| CostCenter1 | MCU | BUSINESSUNIT | F4801 |
| TypeRouting | TRT | UDC | F3112 |
| OrderSuffix | SFXO | STRING | F3112 |
| ItemNumber2ndKit | KITL | STRING | F3112 |
| ItemNumber3rdKit | KITA | STRING | F3112 |
| LineIdentifier | LINE | BUSINESSUNIT | 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 | ADDRESSNUMBER | 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 | BUSINESSUNIT | F3112 |
| ObjectAccount | OBJ | STRING | F3112 |
| Subsidiary | SUB | STRING | F3112 |
| PrimaryLastVendorNo | VEND | ADDRESSNUMBER | F3112 |
| CompanyKeyRelated | RKCO | COMPANY | 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 | 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 |
| AssetItemNumber | NUMB | ASSETNUMBER | F3112 |
| UnacctScrapAmt | CTS7 | FLOAT | F3112 |
| UnacctScrapUnits | CTS8 | INTEGER | 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 | ADDRESSNUMBER | F3112 |
| Supervisor | ANPA | ADDRESSNUMBER | F3112 |
| AddNoAssignedTo | ANP | ADDRESSNUMBER | F3112 |
| MaintenanceScheduleFlag | WSCHF | UDC | F3112 |
| ResourcesAssigned | TRAF | UDC | F3112 |