VQ3548J6 - Q35 Work Order Routing Join View F4801 F4801T F3112 Selective Columns
Cantara Business View Object for Work Order Routing which joins selective columns of standard JDE tables F4801 and F4801T and F3112.
Fields
| Name | Alias | Type | Table |
|---|---|---|---|
DocumentOrderInvoiceE | DOCO | INTEGER | F4801 |
DocumentOrderInvoiceE1 | DOCO | INTEGER | F4801T |
DocumentOrderInvoiceE2 | DOCO | INTEGER | F3112 |
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 |
ResourcesAssigned | TRAF | UDC | F3112 |
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 |
CostCenter1 | MCU | BUSINESSUNIT | F3112 |
SequenceNoOperations | OPSQ | FLOAT | F3112 |
TypeOperationCode | OPSC | UDC | F3112 |
TypeRouting1 | TRT | UDC | F3112 |
DescriptionLine1 | DSC1 | STRING | F3112 |
RunMachineStandard | RUNM | FLOAT | F3112 |
CrewSize | SETC | FLOAT | F3112 |
RunLaborStandard | RUNL | FLOAT | F3112 |
SetupLaborHrsStdr | SETL | FLOAT | F3112 |
OperationStatusCodeWo | OPST | UDC | F3112 |
AddNoAssignedTo1 | ANP | ADDRESSNUMBER | F3112 |
CostCenterAlt1 | MMCU | BUSINESSUNIT | F3112 |
AddressNumber1 | AN8 | ADDRESSNUMBER | F3112 |
DateRequestedJulian1 | DRQJ | DATE | F3112 |
DateStart1 | STRT | DATE | F3112 |
DateCompletion1 | STRX | DATE | F3112 |
UserReservedCode1 | URCD | STRING | F3112 |
UserReservedDate1 | URDT | DATE | F3112 |
UserReservedAmount1 | URAT | FLOAT | F3112 |
UserReservedReference1 | URRF | STRING | F3112 |
UserReservedNumber1 | URAB | INTEGER | F3112 |
TimeScheduledStartHHMMSS1 | SEST | INTEGER | F3112 |
TimeScheduledEndHHMMSS1 | SEET | INTEGER | F3112 |
TimeCompleted1 | TMCO | INTEGER | F3112 |
DateActualStartJ | D2J | DATE | F3112 |
TimeStartHHMMSS | STTI | INTEGER | F3112 |
WorkCenterLeadCraft | MCULT | STRING | F4801T |