VQ354807 - Q35 Work Order Status Update 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 |
RecordNumber | NUMR | INTEGER | F1307 |
TypeOfRec | TREC | CHARACTER | F1307 |
DateBeginningEffective | EFTB | DATE | F1307 |
TimeBeginning | BEGT | INTEGER | F1307 |
EquipmentWorkOrderS | EWST | STRING | F1307 |
DocumentOrderInvoiceE2 | DOCO | INTEGER | F1307 |
OrderType | DCTO | UDC | F4801 |
PegToWorkOrder | PTWO | INTEGER | F4801 |
TypeWo | TYPS | UDC | F4801 |
PriorityWo | PRTS | UDC | F4801 |
Description001 | DL01 | STRING | F4801 |
Company | CO | STRING | F4801 |
CostCenter | MCU | STRING | F4801 |
CostCenterAlt | MMCU | STRING | F4801 |
StatusCodeWo | SRST | UDC | F4801 |
AddressNumber | AN8 | INTEGER | F4801 |
AddNoOriginator | ANO | INTEGER | F4801 |
AddressNumberManager | ANSA | INTEGER | F4801 |
Supervisor | ANPA | INTEGER | F4801 |
AddNoAssignedTo | ANP | INTEGER | F4801 |
DateTransactionJulian | TRDJ | DATE | F4801 |
DateStart | STRT | DATE | F4801 |
DateCompletion | STRX | DATE | 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 |
IdentifierShortItem | ITM | INTEGER | F4801 |
Identifier2ndItem | LITM | STRING | F4801 |
Identifier3rdItem | AITM | STRING | F4801 |
AssetItemNumber | NUMB | INTEGER | F4801 |
UnitNumber | APID | STRING | F4801 |
DateUpdated | UPMJ | DATE | F4801 |
ShiftCode | SHFT | UDC | F4801T |
ProjectNumber | PRJM | INTEGER | F4801T |
CategoriesWorkOrder12 | WR12 | UDC | F4801T |
CategoriesWorkOrder13 | WR13 | UDC | F4801T |
CategoriesWorkOrder14 | WR14 | UDC | F4801T |
CategoriesWorkOrder15 | WR15 | UDC | F4801T |
CategoriesWorkOrder16 | WR16 | UDC | F4801T |
ECOworkbenchselections | WR11 | 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 |
CoverageGroup | COVGR | UDC | F4801T |
ProductFamily | PRODF | UDC | F4801T |
DateEndingEffective | EFTE | DATE | F1307 |
TimeEnding | ENDT | INTEGER | F1307 |
StatusHours | STHR | FLOAT | F1307 |
DateUpdated1 | UPMJ | DATE | F1307 |