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 |