VQ3548J1 - Q35 Equipment Work Orders Join F4801 F4801T F1307
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 |