Cantara Business View Object which joins standard JDE tables F4801, F4801T and F1307.
Fields
|
Name |
Alias |
Type |
Table |
|---|---|---|---|
|
DocumentOrderInvoiceE |
DOCO |
INTEGER |
F4801 |
|
DocumentOrderInvoiceE1 |
DOCO |
INTEGER |
F4801T |
|
OrderType |
DCTO |
UDC |
F4801 |
|
RelatedPoSoNumber |
RORN |
STRING |
F4801 |
|
RelatedOrderType |
RCTO |
UDC |
F4801 |
|
CompanyKeyRelated |
RKCO |
STRING |
F4801 |
|
OrderSuffix |
SFXO |
STRING |
F4801 |
|
LineNumber |
LNID |
FLOAT |
F4801 |
|
ParentWoNumber |
PARS |
STRING |
F4801 |
|
TypeWo |
TYPS |
UDC |
F4801 |
|
PriorityWo |
PRTS |
UDC |
F4801 |
|
Description001 |
DL01 |
STRING |
F4801 |
|
StatusCommentWo |
STCM |
STRING |
F4801 |
|
Company |
CO |
STRING |
F4801 |
|
CostCenter |
MCU |
STRING |
F4801 |
|
CostCenterAlt |
MMCU |
STRING |
F4801 |
|
Location |
LOCN |
STRING |
F4801 |
|
StatusCodeWo |
SRST |
UDC |
F4801 |
|
Subsidiary |
SUB |
STRING |
F4801 |
|
AddressNumber |
AN8 |
INTEGER |
F4801 |
|
AddNoOriginator |
ANO |
INTEGER |
F4801 |
|
AddressNumberManager |
ANSA |
INTEGER |
F4801 |
|
Supervisor |
ANPA |
INTEGER |
F4801 |
|
AddNoAssignedTo |
ANP |
INTEGER |
F4801 |
|
ServiceAddressNumber |
SAID |
INTEGER |
F4801 |
|
AddressNumberInspector |
ANT |
INTEGER |
F4801 |
|
NextAddressNumber |
NAN8 |
INTEGER |
F4801 |
|
DateTransactionJulian |
TRDJ |
DATE |
F4801 |
|
DateStart |
STRT |
DATE |
F4801 |
|
DateRequestedJulian |
DRQJ |
DATE |
F4801 |
|
DateWoPlanCompleted |
DPL |
DATE |
F4801 |
|
DateCompletion |
STRX |
DATE |
F4801 |
|
DateAssignedTo |
DAP |
DATE |
F4801 |
|
DateAssignToInspector |
DAT |
DATE |
F4801 |
|
DateScheduledTickler |
TDT |
DATE |
F4801 |
|
BeginningHhMmSs |
PBTM |
INTEGER |
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 |
|
AmountOriginalDollars |
AMTO |
FLOAT |
F4801 |
|
HoursOriginal |
HRSO |
FLOAT |
F4801 |
|
EstimatedDowntimeHours |
ESDN |
FLOAT |
F4801 |
|
AmountActual |
AMTA |
FLOAT |
F4801 |
|
HoursActual |
HRSA |
FLOAT |
F4801 |
|
ActualDowntimeHours |
ACDN |
FLOAT |
F4801 |
|
IdentifierShortItem |
ITM |
INTEGER |
F4801 |
|
TypeBill |
TBM |
UDC |
F4801 |
|
TypeRouting |
TRT |
UDC |
F4801 |
|
AssetItemNumber |
NUMB |
INTEGER |
F4801 |
|
ParentNumber |
AAID |
INTEGER |
F4801 |
|
UnitsTransactionQty |
UORG |
FLOAT |
F4801 |
|
MessageNo |
SHNO |
STRING |
F4801 |
|
WoFlashMessage |
SPRT |
UDC |
F4801 |
|
PercentComplete |
PC |
FLOAT |
F4801 |
|
Reference1 |
VR01 |
STRING |
F4801 |
|
ApprovalType |
APRT |
UDC |
F4801 |
|
SubledgerInactiveCode |
SBLI |
UDC |
F4801 |
|
UserId |
USER |
STRING |
F4801 |
|
ProgramId |
PID |
STRING |
F4801 |
|
WorkStationId |
JOBN |
STRING |
F4801 |
|
DateUpdated |
UPMJ |
DATE |
F4801 |
|
TimeOfDay |
TDAY |
INTEGER |
F4801 |
|
PegToWorkOrder |
PTWO |
INTEGER |
F4801 |
|
Reference2Vendor |
VR02 |
STRING |
F4801 |
|
UnitOfMeasureAsInput |
UOM |
UDC |
F4801 |
|
Lot |
LOTN |
STRING |
F4801 |
|
AmtChngToOriginalD |
AMTC |
FLOAT |
F4801 |
|
UserReservedCode |
URCD |
STRING |
F4801 |
|
UserReservedAmount |
URAT |
FLOAT |
F4801 |
|
UserReservedDate |
URDT |
DATE |
F4801 |
|
UserReservedNumber |
URAB |
INTEGER |
F4801 |
|
UserReservedReference |
URRF |
STRING |
F4801 |
|
CrewSize |
SETC |
FLOAT |
F4801 |
|
UnitNumber |
APID |
STRING |
F4801 |