VQ354312 - Q35 PO Receipt F43121/F4108
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 |