Cantara Business View Object which joins standard JDE tables F4801 and F3112
Fields
|
Name |
Alias |
Type |
Table |
|---|---|---|---|
|
DocumentOrderInvoiceE |
DOCO |
INTEGER |
F3112 |
|
DocumentOrderInvoiceE1 |
DOCO |
INTEGER |
F4801 |
|
OrderType |
DCTO |
UDC |
F3112 |
|
OrderType1 |
DCTO |
UDC |
F4801 |
|
CostCenter |
MCU |
BUSINESSUNIT |
F3112 |
|
SequenceNoOperations |
OPSQ |
FLOAT |
F3112 |
|
TypeOperationCode |
OPSC |
UDC |
F3112 |
|
OperationStatusCodeWo |
OPST |
UDC |
F3112 |
|
DateStart |
STRT |
DATE |
F3112 |
|
DateRequestedJulian |
DRQJ |
DATE |
F3112 |
|
UnitOfMeasureAsInput |
UOM |
UDC |
F3112 |
|
UnitsQuantityMovedT |
QMTO |
INTEGER |
F3112 |
|
UnitsTransactionQty |
UORG |
INTEGER |
F3112 |
|
UnitsQuantityCanceled |
SOCN |
INTEGER |
F3112 |
|
UnitsQuantityShipped |
SOQS |
INTEGER |
F3112 |
|
CostCenterAlt |
MMCU |
BUSINESSUNIT |
F3112 |
|
RunMachineStandard |
RUNM |
FLOAT |
F3112 |
|
RunLaborStandard |
RUNL |
FLOAT |
F3112 |
|
SetupLaborHrsStdr |
SETL |
FLOAT |
F3112 |
|
SetupLaborHoursActual |
SETA |
FLOAT |
F3112 |
|
RunMachineActual |
MACA |
FLOAT |
F3112 |
|
RunLaborActual |
LABA |
FLOAT |
F3112 |
|
RelatedPoSoNumber |
RORN |
STRING |
F4801 |
|
AddressNumber |
AN8 |
ADDRESSNUMBER |
F4801 |
|
Description001 |
DL01 |
STRING |
F4801 |
|
ItemNumberShortKit |
KIT |
SHORTITEM |
F3112 |
|
QueueHours |
QUED |
FLOAT |
F3112 |
|
DescriptionLine1 |
DSC1 |
STRING |
F3112 |
|
StatusCodeWo |
SRST |
UDC |
F4801 |
|
TypeWo |
TYPS |
UDC |
F4801 |
|
CostCenterAlt1 |
MMCU |
BUSINESSUNIT |
F4801 |
|
CostCenter1 |
MCU |
BUSINESSUNIT |
F4801 |
|
TypeRouting |
TRT |
UDC |
F3112 |
|
OrderSuffix |
SFXO |
STRING |
F3112 |
|
ItemNumber2ndKit |
KITL |
STRING |
F3112 |
|
ItemNumber3rdKit |
KITA |
STRING |
F3112 |
|
LineIdentifier |
LINE |
BUSINESSUNIT |
F3112 |
|
AutoLoadDescription |
ALD |
UDC |
F3112 |
|
InspectionCode |
INPE |
STRING |
F3112 |
|
TimeBasisCode |
TIMB |
UDC |
F3112 |
|
LaborOrMachine |
LAMC |
UDC |
F3112 |
|
PayPointCode |
BFPF |
UDC |
F3112 |
|
PayPointStatus |
PPRF |
UDC |
F3112 |
|
JobCategory |
JBCD |
UDC |
F3112 |
|
AddressNumber1 |
AN8 |
ADDRESSNUMBER |
F3112 |
|
CriticalRatio |
CRTR |
FLOAT |
F3112 |
|
SlackTimeRatio |
SLTR |
FLOAT |
F3112 |
|
DateTransactionJulian |
TRDJ |
DATE |
F3112 |
|
DateCompletion |
STRX |
DATE |
F3112 |
|
ShiftCodeRequested |
RSFT |
CHARACTER |
F3112 |
|
ShiftCodeStart |
SSFT |
CHARACTER |
F3112 |
|
ShiftCodeCompleted |
CSFT |
CHARACTER |
F3112 |
|
LeadtimeOverlap |
LTPC |
FLOAT |
F3112 |
|
PercentOfOverlap |
POVR |
FLOAT |
F3112 |
|
PercentOperationalPl |
OPYP |
FLOAT |
F3112 |
|
PercentCumulativePla |
CPYP |
FLOAT |
F3112 |
|
NextOperation |
NXOP |
FLOAT |
F3112 |
|
CrewSize |
SETC |
FLOAT |
F3112 |
|
MoveHours |
MOVD |
FLOAT |
F3112 |
|
OperationShrinkage |
OPSR |
FLOAT |
F3112 |
|
RatePiecework |
PWRT |
FLOAT |
F3112 |
|
UnacctSetupLaborHrs |
CTS2 |
FLOAT |
F3112 |
|
UnacctMachineHours |
CTS3 |
FLOAT |
F3112 |
|
UnacctDirectLaborAmt |
CTS4 |
FLOAT |
F3112 |
|
UnacctDirectSetupAmt |
CTS5 |
FLOAT |
F3112 |
|
UnacctDirectMachAmt |
CTS6 |
FLOAT |
F3112 |
|
UnitNumber |
APID |
STRING |
F3112 |
|
MessageNo |
SHNO |
STRING |
F3112 |
|
PurchasingCostCenter |
OMCU |
BUSINESSUNIT |
F3112 |
|
ObjectAccount |
OBJ |
STRING |
F3112 |
|
Subsidiary |
SUB |
STRING |
F3112 |
|
PrimaryLastVendorNo |
VEND |
ADDRESSNUMBER |
F3112 |
|
CompanyKeyRelated |
RKCO |
COMPANY |
F3112 |
|
RelatedPoSoNumber1 |
RORN |
STRING |
F3112 |
|
RelatedOrderType |
RCTO |
UDC |
F3112 |
|
RelatedPoSoLineNo |
RLLN |
FLOAT |
F3112 |
|
DocumentType |
DCT |
UDC |
F3112 |
|
UserReservedCode |
URCD |
STRING |
F3112 |
|
UserReservedDate |
URDT |
DATE |
F3112 |
|
UserReservedAmount |
URAT |
FLOAT |
F3112 |
|
UserReservedReference |
URRF |
STRING |
F3112 |
|
UserReservedNumber |
URAB |
INTEGER |
F3112 |
|
UserId |
USER |
STRING |
F3112 |
|
ProgramId |
PID |
STRING |
F3112 |
|
WorkStationId |
JOBN |
STRING |
F3112 |
|
DateUpdated |
UPMJ |
DATE |
F3112 |
|
TimeOfDay |
TDAY |
INTEGER |
F3112 |
|
Location |
LOCN |
LOCATION |
F3112 |
|
Resourceunitsconsumed |
RUC |
FLOAT |
F3112 |
|
UMCapacityUOM |
CAPU |
UDC |
F3112 |
|
WorkcenterBranch |
WMCU |
BUSINESSUNIT |
F3112 |
|
RunMachineCurrent |
CMHR |
FLOAT |
F3112 |
|
RunLaborCurrent |
CLHR |
FLOAT |
F3112 |
|
SetupLaborCurrent |
CSHR |
FLOAT |
F3112 |
|
CostType |
COST |
UDC |
F3112 |
|
ActivityCode |
ACTB |
STRING |
F3112 |
|
AssetItemNumber |
NUMB |
ASSETNUMBER |
F3112 |
|
UnacctScrapAmt |
CTS7 |
FLOAT |
F3112 |
|
UnacctScrapUnits |
CTS8 |
INTEGER |
F3112 |
|
UnacctDirectLaborHrs |
CTS9 |
FLOAT |
F3112 |
|
LaborRate |
LABP |
FLOAT |
F3112 |
|
MachineRate |
MACR |
FLOAT |
F3112 |
|
SetupLaborRate |
SETR |
FLOAT |
F3112 |
|
ConstraintsFlag |
APSC |
UDC |
F3112 |
|
TimeScheduledStartHHMMSS |
SEST |
INTEGER |
F3112 |
|
TimeScheduledEndHHMMSS |
SEET |
INTEGER |
F3112 |
|
TimeCompleted |
TMCO |
INTEGER |
F3112 |
|
DateActualStartJ |
D2J |
DATE |
F3112 |
|
TimeStartHHMMSS |
STTI |
INTEGER |
F3112 |
|
CompentencyType |
CMPE |
UDC |
F3112 |
|
CompentencyCode |
CMPC |
STRING |
F3112 |
|
CompetencyLevelFrom |
CPLVLFR |
FLOAT |
F3112 |
|
CompetencyLevelTo |
CPLVLTO |
FLOAT |
F3112 |
|
RuleMatchFlag |
CMRQ |
CHARACTER |
F3112 |
|
AddressNumberManager |
ANSA |
ADDRESSNUMBER |
F3112 |
|
Supervisor |
ANPA |
ADDRESSNUMBER |
F3112 |
|
AddNoAssignedTo |
ANP |
ADDRESSNUMBER |
F3112 |
|
MaintenanceScheduleFlag |
WSCHF |
UDC |
F3112 |
|
ResourcesAssigned |
TRAF |
UDC |
F3112 |