Cantara Business View Object which joins standard JDE tables F43121 and F4108
Fields
|
Name |
Alias |
Type |
Table |
|---|---|---|---|
|
MatchType |
MATC |
CHARACTER |
F43121 |
|
CompanyKeyOrderNo |
KCOO |
COMPANY |
F43121 |
|
DocumentOrderInvoiceE |
DOCO |
INTEGER |
F43121 |
|
OrderType |
DCTO |
UDC |
F43121 |
|
OrderSuffix |
SFXO |
STRING |
F43121 |
|
LineNumber |
LNID |
FLOAT |
F43121 |
|
NoOfLinesOnOrder |
NLIN |
INTEGER |
F43121 |
|
DocVoucherInvoiceE |
DOC |
INTEGER |
F43121 |
|
AddressNumber |
AN8 |
ADDRESSNUMBER |
F43121 |
|
AssociatedLine |
ALIN |
INTEGER |
F43121 |
|
WrittenBy |
RTBY |
STRING |
F43121 |
|
ContractNumberDistributi |
DMCT |
STRING |
F43121 |
|
ContractSupplementDistri |
DMCS |
INTEGER |
F43121 |
|
ContractBalancesUpdatedY |
BALU |
CHARACTER |
F43121 |
|
IdentifierShortItem |
ITM |
SHORTITEM |
F43121 |
|
Identifier2ndItem |
LITM |
STRING |
F43121 |
|
Identifier3rdItem |
AITM |
STRING |
F43121 |
|
CostCenterItem |
IMCU |
BUSINESSUNIT |
F43121 |
|
Location |
LOCN |
LOCATION |
F43121 |
|
Lot |
LOTN |
STRING |
F43121 |
|
LotGrade |
LOTG |
UDC |
F43121 |
|
LotPotency |
LOTP |
FLOAT |
F43121 |
|
VendorRemark1 |
VRMK |
STRING |
F43121 |
|
ContainerID |
CNID |
STRING |
F43121 |
|
StatusCodeNext |
NXTR |
UDC |
F43121 |
|
StatusCodeLast |
LTTR |
UDC |
F43121 |
|
DateTransactionJulian |
TRDJ |
DATE |
F43121 |
|
DateReceived |
RCDJ |
DATE |
F43121 |
|
DateRequestedJulian |
DRQJ |
DATE |
F43121 |
|
ScheduledPickDate |
PDDJ |
DATE |
F43121 |
|
DateOriginalPromisde |
OPDJ |
DATE |
F43121 |
|
ReasonCode |
RCD |
UDC |
F43121 |
|
VendorInvoiceNumber |
VINV |
STRING |
F43121 |
|
PaymentTermsCode01 |
PTC |
STRING |
F43121 |
|
PayStatusCode |
PST |
UDC |
F43121 |
|
LandedCostCode |
LAND |
CHARACTER |
F43121 |
|
PurchasingReportCode5 |
PRP5 |
UDC |
F43121 |
|
LevelCost |
LVLA |
UDC |
F43121 |
|
InvoiceLoggingCode |
ILOG |
CHARACTER |
F43121 |
|
InvoiceLoggingDist |
DLOG |
CHARACTER |
F43121 |
|
RoutingProcessYN |
RTGC |
CHARACTER |
F43121 |
|
ReceiptCode |
RCPF |
CHARACTER |
F43121 |
|
CodeAutomaticVoucher |
AVCH |
UDC |
F43121 |
|
LineType |
LNTY |
STRING |
F43121 |
|
GlClass |
GLC |
STRING |
F43121 |
|
CostCenter |
MCU |
BUSINESSUNIT |
F43121 |
|
Company |
CO |
COMPANY |
F43121 |
|
AccountId |
AID |
ACCOUNTID |
F43121 |
|
AcctNoInputMode |
ANI |
STRING |
F43121 |
|
PurchasingCostCenter |
OMCU |
BUSINESSUNIT |
F43121 |
|
ObjectAccount |
OBJ |
STRING |
F43121 |
|
Subsidiary |
SUB |
STRING |
F43121 |
|
SerialTagNumber |
ASID |
STRING |
F43121 |
|
Subledger |
SBL |
STRING |
F43121 |
|
SubledgerType |
SBLT |
UDC |
F43121 |
|
CompanyKey |
KCO |
COMPANY |
F43121 |
|
DocumentType |
DCT |
UDC |
F43121 |
|
DocumentPayItem |
SFX |
STRING |
F43121 |
|
DtForGLAndVouch1 |
DGL |
DATE |
F43121 |
|
JournalEntryLineNo |
JELN |
FLOAT |
F43121 |
|
RecNotVoucherAcct |
VANI |
STRING |
F43121 |
|
TaxableYN1 |
TX |
UDC |
F43121 |
|
TaxExplanationCode1 |
EXR1 |
UDC |
F43121 |
|
TaxArea1 |
TXA1 |
STRING |
F43121 |
|
UnitOfMeasureAsInput |
UOM |
UDC |
F43121 |
|
UnitsTransactionQty |
UORG |
FLOAT |
F43121 |
|
QuantityPaidToDate |
UPTD |
FLOAT |
F43121 |
|
UnitsOpenQuantity |
UOPN |
FLOAT |
F43121 |
|
UnitsLineItemQtyRe |
UREC |
FLOAT |
F43121 |
|
UnitsClosed |
UCLO |
FLOAT |
F43121 |
|
QuantityStocked |
QTYS |
FLOAT |
F43121 |
|
QuantityReturned |
QTYR |
FLOAT |
F43121 |
|
QuantityReworked |
QTYW |
FLOAT |
F43121 |
|
QuantityScrapped |
QTYC |
FLOAT |
F43121 |
|
QuantityRejected |
QTYJ |
FLOAT |
F43121 |
|
QuantityAdjusted |
QTYA |
FLOAT |
F43121 |
|
UnitOfMeasurePurchas |
UOM3 |
UDC |
F43121 |
|
PurchasingUnitPrice |
PRRC |
FLOAT |
F43121 |
|
AmountExtendedCost |
ECST |
FLOAT |
F43121 |
|
AmountPaidToDate |
APTD |
FLOAT |
F43121 |
|
AmountOpen1 |
AOPN |
FLOAT |
F43121 |
|
AmountReceived |
AREC |
FLOAT |
F43121 |
|
AmountClosed |
ACLO |
FLOAT |
F43121 |
|
AverageCostDifference |
AVCO |
FLOAT |
F43121 |
|
CostVariance |
VARC |
FLOAT |
F43121 |
|
CurrencyCodeFrom |
CRCD |
STRING |
F43121 |
|
CurrencyConverRateOv |
CRR |
FLOAT |
F43121 |
|
ForeignPurchasingCost |
FRRC |
FLOAT |
F43121 |
|
AmountForeignExtCost |
FEC |
FLOAT |
F43121 |
|
AmountForeignOpen |
FAP |
FLOAT |
F43121 |
|
AmountForeignPaidTd |
FAPT |
FLOAT |
F43121 |
|
AmountReceivedForeign |
FREC |
FLOAT |
F43121 |
|
ForeignAmountClosed |
FCLO |
FLOAT |
F43121 |
|
UserReservedCode |
URCD |
STRING |
F43121 |
|
UserReservedDate |
URDT |
DATE |
F43121 |
|
UserReservedAmount |
URAT |
FLOAT |
F43121 |
|
UserReservedNumber |
URAB |
INTEGER |
F43121 |
|
UserReservedReference |
URRF |
STRING |
F43121 |
|
TransactionOriginator |
TORG |
STRING |
F43121 |
|
UserId |
USER |
STRING |
F43121 |
|
ProgramId |
PID |
STRING |
F43121 |
|
WorkStationId |
JOBN |
STRING |
F43121 |
|
TerminalIdentification |
TERM |
STRING |
F43121 |
|
DateUpdated |
UPMJ |
DATE |
F43121 |
|
TimeOfDay |
TDAY |
INTEGER |
F43121 |
|
CurrencyCodeBase |
BCRC |
STRING |
F43121 |
|
AmtTax2 |
STAM |
FLOAT |
F43121 |
|
ForeignTaxAmount |
CTAM |
FLOAT |
F43121 |
|
MultipleAccounts |
MACT |
UDC |
F43121 |
|
SSCCNumberTareLevel |
PLT |
STRING |
F43121 |
|
SSCCNumberPackLevel |
PAK |
STRING |
F43121 |
|
SCCNumber |
SCCN |
STRING |
F43121 |
|
SCCQuantity |
SCCQ |
FLOAT |
F43121 |
|
SCCUnitofMeasure |
SCUM |
UDC |
F43121 |
|
UPCNumber |
UPCN |
STRING |
F43121 |
|
UPCQuantity |
UPQT |
FLOAT |
F43121 |
|
UPCUnitofMeasure |
UPUM |
UDC |
F43121 |
|
ShipmentNumber |
SHPN |
INTEGER |
F43121 |
|
Reference1 |
VR01 |
STRING |
F43121 |
|
Reference2Vendor |
VR02 |
STRING |
F43121 |
|
FutureUseFuf3 |
FUF3 |
STRING |
F43121 |
|
FutureUseFuf4 |
FUF4 |
STRING |
F43121 |
|
FutureUseFuf5 |
FUF5 |
STRING |
F43121 |
|
FutureUseFuf6 |
FUF6 |
STRING |
F43121 |
|
MeRevisionLevel |
MERL |
STRING |
F43121 |
|
LineNumberKitMaster |
KTLN |
FLOAT |
F43121 |
|
ComponentNumber |
CPNT |
FLOAT |
F43121 |
|
OutsideReverence1 |
VR04 |
STRING |
F43121 |
|
OutsideReverence2 |
VR05 |
STRING |
F43121 |
|
UniqueKeyIDInternal |
UKID |
INTEGER |
F43121 |
|
UnitOfMeasureSecondary |
UOM2 |
UDC |
F43121 |
|
DualUnitOfMeasureItem |
DUAL |
CHARACTER |
F43121 |
|
UnitsSecondaryQtyOr |
SQOR |
FLOAT |
F43121 |
|
CrossDockFlag |
XDCK |
CHARACTER |
F43121 |
|
PortOfEntryExit |
POE |
UDC |
F43121 |
|
ReferenceUCISNo |
VR03 |
STRING |
F43121 |
|
LoadNumber |
LDNM |
INTEGER |
F43121 |
|
szContainerSerial |
CTSN |
STRING |
F43121 |
|
PriceOverrideCode |
PROV |
CHARACTER |
F43121 |
|
PriceAdjustmentScheduleN |
ASN |
UDC |
F43121 |
|
PricingControl01 |
PRFLG1 |
UDC |
F43121 |
|
PricingControl02 |
PRFLG2 |
UDC |
F43121 |
|
ManualOverrideAdjustmentFlag |
MOADJ |
CHARACTER |
F43121 |
|
PurchaseOrderStatus09 |
PS09 |
CHARACTER |
F43121 |
|
QuantityToPay |
QTYPY |
FLOAT |
F43121 |
|
VesselID |
WVID |
INTEGER |
F43121 |
|
Contract_ID |
CNTRTID |
INTEGER |
F43121 |
|
ContractDetailID |
CNTRTDID |
INTEGER |
F43121 |
|
ReviewedFlag |
REVFLG |
CHARACTER |
F43121 |
|
ApprovedFlag |
APPFLG |
CHARACTER |
F43121 |
|
ReviewedBy |
REVAN8 |
INTEGER |
F43121 |
|
ApprovedBy |
APPAN8 |
INTEGER |
F43121 |
|
OperationID |
WOPID |
INTEGER |
F43121 |
|
VesselClass |
WVTY |
CHARACTER |
F43121 |
|
JobCategory |
JBCD |
UDC |
F43121 |
|
UnitsQuantityService |
SRQTY |
FLOAT |
F43121 |
|
UnitOfMeasureService |
SRUOM |
UDC |
F43121 |
|
NonBillableRetainageUsed |
NBRU |
CHARACTER |
F43121 |
|
ExpenseAtVoucher |
NEWR |
CHARACTER |
F43121 |
|
PurchasingSecondaryUnitCost |
SRRC |
FLOAT |
F43121 |
|
ForeignPurchasingSecondaryCost |
FSRRC |
FLOAT |
F43121 |
|
ProductionNumber |
PMPN |
STRING |
F43121 |
|
ProductionNumberShort |
PNS |
INTEGER |
F43121 |
|
Lot1 |
LOTN |
STRING |
F4108 |
|
CostCenter1 |
MCU |
BUSINESSUNIT |
F4108 |
|
IdentifierShortItem1 |
ITM |
SHORTITEM |
F4108 |
|
DescriptionLot |
LDSC |
STRING |
F4108 |
|
LotStatusCode |
LOTS |
UDC |
F4108 |
|
Identifier2ndItem1 |
LITM |
STRING |
F4108 |
|
Identifier3rdItem1 |
AITM |
STRING |
F4108 |
|
PrimaryLastVendorNo |
VEND |
ADDRESSNUMBER |
F4108 |
|
CompanyKeyOrderNo1 |
KCOO |
COMPANY |
F4108 |
|
DocumentOrderInvoiceE1 |
DOCO |
INTEGER |
F4108 |
|
OrderType1 |
DCTO |
UDC |
F4108 |
|
VendorLotNumber |
RLOT |
STRING |
F4108 |
|
LotPotency1 |
LOTP |
FLOAT |
F4108 |
|
LotGrade1 |
LOTG |
UDC |
F4108 |
|
Date_-_Lot_Expiration |
MMEJ |
DATE |
F4108 |
|
SerialNumberLot |
SERN |
STRING |
F4108 |
|
DateUserDefinedDat001 |
UA01 |
DATE |
F4108 |
|
DateUserDefinedDat002 |
UA02 |
DATE |
F4108 |
|
DateUserDefinedDat003 |
UA03 |
DATE |
F4108 |
|
DateUserDefinedDat004 |
UA04 |
DATE |
F4108 |
|
DateUserDefinedDat005 |
UA05 |
DATE |
F4108 |
|
DateUserDefinedDat006 |
UA06 |
DATE |
F4108 |
|
UserDefinedQuantity001 |
UB01 |
FLOAT |
F4108 |
|
UserDefinedQuantity002 |
UB02 |
FLOAT |
F4108 |
|
UserDefinedQuantity003 |
UB03 |
FLOAT |
F4108 |
|
UserDefinedQuantity004 |
UB04 |
FLOAT |
F4108 |
|
UserDefinedQuantity005 |
UB05 |
FLOAT |
F4108 |
|
UserDefinedQuantity006 |
UB06 |
FLOAT |
F4108 |
|
UserId1 |
USER |
STRING |
F4108 |
|
ProgramId1 |
PID |
STRING |
F4108 |
|
DateUpdated1 |
UPMJ |
DATE |
F4108 |
|
TimeOfDay1 |
TDAY |
INTEGER |
F4108 |
|
WorkStationId1 |
JOBN |
STRING |
F4108 |
|
LotMasterCategoryCode1 |
LRP1 |
UDC |
F4108 |
|
LotCategoryCode2 |
LRP2 |
UDC |
F4108 |
|
LotCategoryCode3 |
LRP3 |
UDC |
F4108 |
|
LotCategoryCode4 |
LRP4 |
UDC |
F4108 |
|
LotCategoryCode5 |
LRP5 |
UDC |
F4108 |
|
LotCategoryCode6 |
LRP6 |
UDC |
F4108 |
|
LotCategoryCode7 |
LRP7 |
UDC |
F4108 |
|
LotCategoryCode8 |
LRP8 |
UDC |
F4108 |
|
LotCategoryCode9 |
LRP9 |
UDC |
F4108 |
|
LotCategoryCode10 |
LRP0 |
UDC |
F4108 |
|
MemoLotField1 |
LOT1 |
STRING |
F4108 |
|
MemoLotField2 |
LOT2 |
STRING |
F4108 |
|
MemoLotField3 |
LOT3 |
STRING |
F4108 |
|
BestBeforeDate |
BBDJ |
DATE |
F4108 |
|
BasedOnDate |
BODJ |
DATE |
F4108 |
|
LotEffectivityDate |
DLEJ |
DATE |
F4108 |
|
OnHandDate |
OHDJ |
DATE |
F4108 |
|
SellByDate |
SBDJ |
DATE |
F4108 |
|
UserLotDate1 |
U1DJ |
DATE |
F4108 |
|
UserLotDate2 |
U2DJ |
DATE |
F4108 |
|
UserLotDate3 |
U3DJ |
DATE |
F4108 |
|
UserLotDate4 |
U4DJ |
DATE |
F4108 |
|
UserLotDate5 |
U5DJ |
DATE |
F4108 |
|
CriticalHoldFlag |
CHDF |
CHARACTER |
F4108 |
|
WorkFlowPendingFlag |
WPDF |
CHARACTER |
F4108 |
|
DocumentOrderInvoi |
DOC1 |
INTEGER |
F4108 |
|
LotReusable |
LOTR |
CHARACTER |
F4108 |
|
LotStatusCodeExpanded |
LOTC |
STRING |
F4108 |
|
CountryOfOrigin |
ORIG |
UDC |
F4108 |