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 |