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 |