Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.