Skip to main content

VQ353112 - Q35 Join View F3112 F4801

Cantara Business View Object which joins standard JDE tables F4801 and F3112

Fields

NameAliasTypeTable
DocumentOrderInvoiceEDOCOINTEGERF3112
DocumentOrderInvoiceE1DOCOINTEGERF4801
OrderTypeDCTOUDCF3112
OrderType1DCTOUDCF4801
CostCenterMCUBUSINESSUNITF3112
SequenceNoOperationsOPSQFLOATF3112
TypeOperationCodeOPSCUDCF3112
OperationStatusCodeWoOPSTUDCF3112
DateStartSTRTDATEF3112
DateRequestedJulianDRQJDATEF3112
UnitOfMeasureAsInputUOMUDCF3112
UnitsQuantityMovedTQMTOINTEGERF3112
UnitsTransactionQtyUORGINTEGERF3112
UnitsQuantityCanceledSOCNINTEGERF3112
UnitsQuantityShippedSOQSINTEGERF3112
CostCenterAltMMCUBUSINESSUNITF3112
RunMachineStandardRUNMFLOATF3112
RunLaborStandardRUNLFLOATF3112
SetupLaborHrsStdrSETLFLOATF3112
SetupLaborHoursActualSETAFLOATF3112
RunMachineActualMACAFLOATF3112
RunLaborActualLABAFLOATF3112
RelatedPoSoNumberRORNSTRINGF4801
AddressNumberAN8ADDRESSNUMBERF4801
Description001DL01STRINGF4801
ItemNumberShortKitKITSHORTITEMF3112
QueueHoursQUEDFLOATF3112
DescriptionLine1DSC1STRINGF3112
StatusCodeWoSRSTUDCF4801
TypeWoTYPSUDCF4801
CostCenterAlt1MMCUBUSINESSUNITF4801
CostCenter1MCUBUSINESSUNITF4801
TypeRoutingTRTUDCF3112
OrderSuffixSFXOSTRINGF3112
ItemNumber2ndKitKITLSTRINGF3112
ItemNumber3rdKitKITASTRINGF3112
LineIdentifierLINEBUSINESSUNITF3112
AutoLoadDescriptionALDUDCF3112
InspectionCodeINPESTRINGF3112
TimeBasisCodeTIMBUDCF3112
LaborOrMachineLAMCUDCF3112
PayPointCodeBFPFUDCF3112
PayPointStatusPPRFUDCF3112
JobCategoryJBCDUDCF3112
AddressNumber1AN8ADDRESSNUMBERF3112
CriticalRatioCRTRFLOATF3112
SlackTimeRatioSLTRFLOATF3112
DateTransactionJulianTRDJDATEF3112
DateCompletionSTRXDATEF3112
ShiftCodeRequestedRSFTCHARACTERF3112
ShiftCodeStartSSFTCHARACTERF3112
ShiftCodeCompletedCSFTCHARACTERF3112
LeadtimeOverlapLTPCFLOATF3112
PercentOfOverlapPOVRFLOATF3112
PercentOperationalPlOPYPFLOATF3112
PercentCumulativePlaCPYPFLOATF3112
NextOperationNXOPFLOATF3112
CrewSizeSETCFLOATF3112
MoveHoursMOVDFLOATF3112
OperationShrinkageOPSRFLOATF3112
RatePieceworkPWRTFLOATF3112
UnacctSetupLaborHrsCTS2FLOATF3112
UnacctMachineHoursCTS3FLOATF3112
UnacctDirectLaborAmtCTS4FLOATF3112
UnacctDirectSetupAmtCTS5FLOATF3112
UnacctDirectMachAmtCTS6FLOATF3112
UnitNumberAPIDSTRINGF3112
MessageNoSHNOSTRINGF3112
PurchasingCostCenterOMCUBUSINESSUNITF3112
ObjectAccountOBJSTRINGF3112
SubsidiarySUBSTRINGF3112
PrimaryLastVendorNoVENDADDRESSNUMBERF3112
CompanyKeyRelatedRKCOCOMPANYF3112
RelatedPoSoNumber1RORNSTRINGF3112
RelatedOrderTypeRCTOUDCF3112
RelatedPoSoLineNoRLLNFLOATF3112
DocumentTypeDCTUDCF3112
UserReservedCodeURCDSTRINGF3112
UserReservedDateURDTDATEF3112
UserReservedAmountURATFLOATF3112
UserReservedReferenceURRFSTRINGF3112
UserReservedNumberURABINTEGERF3112
UserIdUSERSTRINGF3112
ProgramIdPIDSTRINGF3112
WorkStationIdJOBNSTRINGF3112
DateUpdatedUPMJDATEF3112
TimeOfDayTDAYINTEGERF3112
LocationLOCNLOCATIONF3112
ResourceunitsconsumedRUCFLOATF3112
UMCapacityUOMCAPUUDCF3112
WorkcenterBranchWMCUBUSINESSUNITF3112
RunMachineCurrentCMHRFLOATF3112
RunLaborCurrentCLHRFLOATF3112
SetupLaborCurrentCSHRFLOATF3112
CostTypeCOSTUDCF3112
ActivityCodeACTBSTRINGF3112
AssetItemNumberNUMBASSETNUMBERF3112
UnacctScrapAmtCTS7FLOATF3112
UnacctScrapUnitsCTS8INTEGERF3112
UnacctDirectLaborHrsCTS9FLOATF3112
LaborRateLABPFLOATF3112
MachineRateMACRFLOATF3112
SetupLaborRateSETRFLOATF3112
ConstraintsFlagAPSCUDCF3112
TimeScheduledStartHHMMSSSESTINTEGERF3112
TimeScheduledEndHHMMSSSEETINTEGERF3112
TimeCompletedTMCOINTEGERF3112
DateActualStartJD2JDATEF3112
TimeStartHHMMSSSTTIINTEGERF3112
CompentencyTypeCMPEUDCF3112
CompentencyCodeCMPCSTRINGF3112
CompetencyLevelFromCPLVLFRFLOATF3112
CompetencyLevelToCPLVLTOFLOATF3112
RuleMatchFlagCMRQCHARACTERF3112
AddressNumberManagerANSAADDRESSNUMBERF3112
SupervisorANPAADDRESSNUMBERF3112
AddNoAssignedToANPADDRESSNUMBERF3112
MaintenanceScheduleFlagWSCHFUDCF3112
ResourcesAssignedTRAFUDCF3112
JavaScript errors detected

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

If this problem persists, please contact our support.