Cantara Business View Object for Work Order Parts which joins selective columns of standard JDE tables F4801 and F4801T and F3111.
Fields
|
Name |
Alias |
Type |
Table |
|---|---|---|---|
|
DocumentOrderInvoiceE |
DOCO |
INTEGER |
F4801 |
|
DocumentOrderInvoiceE1 |
DOCO |
INTEGER |
F4801T |
|
DocumentOrderInvoiceE2 |
DOCO |
INTEGER |
F3111 |
|
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 |
|
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 |
|
WorkCenterLeadCraft |
MCULT |
STRING |
F4801T |
|
UniqueKeyIDInternal |
UKID |
INTEGER |
F3111 |
|
SequenceNoOperations |
OPSQ |
FLOAT |
F3111 |
|
TypeBill1 |
TBM |
UDC |
F3111 |
|
IssueTypeCode |
ITC |
UDC |
F3111 |
|
ComponentItemNoShort |
CPIT |
INTEGER |
F3111 |
|
ComponentItemNo2nd |
CPIL |
STRING |
F3111 |
|
BranchComponent |
CMCU |
BUSINESSUNIT |
F3111 |
|
DescriptionLine1 |
DSC1 |
STRING |
F3111 |
|
DescriptionLine2 |
DSC2 |
STRING |
F3111 |
|
CompanyKeyRelated1 |
RKCO |
COMPANY |
F3111 |
|
RelatedPoSoNumber1 |
RORN |
STRING |
F3111 |
|
RelatedOrderType1 |
RCTO |
UDC |
F3111 |
|
RelatedPoSoLineNo |
RLLN |
FLOAT |
F3111 |
|
LineType |
LNTY |
STRING |
F3111 |
|
AddressNumber1 |
AN8 |
ADDRESSNUMBER |
F3111 |
|
PrimaryLastVendorNo |
VEND |
ADDRESSNUMBER |
F3111 |
|
CostCenter1 |
MCU |
BUSINESSUNIT |
F3111 |
|
PurchasingCostCenter |
OMCU |
BUSINESSUNIT |
F3111 |
|
ObjectAccount |
OBJ |
STRING |
F3111 |
|
Subsidiary1 |
SUB |
STRING |
F3111 |
|
CoproductsByproducts |
COBY |
UDC |
F3111 |
|
ComponentNumber |
CPNT |
FLOAT |
F3111 |
|
Location1 |
LOCN |
LOCATION |
F3111 |
|
Lot |
LOTN |
STRING |
F3111 |
|
UnitsTransactionQty |
UORG |
FLOAT |
F3111 |
|
QuantityTransaction |
TRQT |
FLOAT |
F3111 |
|
UnitOfMeasure |
UM |
UDC |
F3111 |
|
MaterialStatusCodeWo |
MTST |
UDC |
F3111 |
|
DateRequestedJulian1 |
DRQJ |
DATE |
F3111 |
|
UnitsQuantityCanceled |
SOCN |
FLOAT |
F3111 |
|
UnitsQuanBackorHeld |
SOBK |
FLOAT |
F3111 |
|
EstimatedAmount |
EA |
FLOAT |
F3111 |
|
MessageNo1 |
SHNO |
STRING |
F3111 |
|
UserReservedCode1 |
URCD |
STRING |
F3111 |
|
UserReservedDate1 |
URDT |
DATE |
F3111 |
|
UserReservedAmount1 |
URAT |
FLOAT |
F3111 |
|
UserReservedReference1 |
URRF |
STRING |
F3111 |
|
UserReservedNumber1 |
URAB |
INTEGER |
F3111 |
|
UserId1 |
USER |
STRING |
F3111 |