Skip to main content

VQ354108 - Q35 Item Balances F4101/F4102/F41021/F4108

Cantara Business View Object which joins standard JDE tables F4101, F4102, F41021 and F4108

Fields

Name

Alias

Type

Table

IdentifierShortItem

ITM

SHORTITEM

F4101

IdentifierShortItem1

ITM

SHORTITEM

F4102

IdentifierShortItem2

ITM

SHORTITEM

F41021

CostCenter

MCU

BUSINESSUNIT

F4102

CostCenter1

MCU

BUSINESSUNIT

F41021

CostCenter2

MCU

BUSINESSUNIT

F4108

IdentifierShortItem3

ITM

SHORTITEM

F4108

Lot

LOTN

STRING

F41021

Lot1

LOTN

STRING

F4108

Location

LOCN

LOCATION

F41021

Identifier2ndItem

LITM

STRING

F4101

Identifier3rdItem

AITM

STRING

F4101

DescriptionLine1

DSC1

STRING

F4101

DescriptionLine2

DSC2

STRING

F4101

SearchText

SRTX

STRING

F4101

SalesReportingCode1

SRP1

UDC

F4101

SalesReportingCode2

SRP2

UDC

F4101

SalesReportingCode3

SRP3

UDC

F4101

SalesReportingCode4

SRP4

UDC

F4101

SalesReportingCode5

SRP5

UDC

F4101

PurchasingReportCode1

PRP1

UDC

F4101

PurchasingReportCode2

PRP2

UDC

F4101

PurchasingReportCode3

PRP3

UDC

F4101

PurchasingReportCode4

PRP4

UDC

F4101

PurchasingReportCode5

PRP5

UDC

F4101

CommodityCode

CDCD

STRING

F4101

Buyer

BUYR

ADDRESSNUMBER

F4101

Carrier

CARS

ADDRESSNUMBER

F4101

UnitOfMeasurePrimary

UOM1

UDC

F4101

UnitOfMeasureSecondary

UOM2

UDC

F4101

CycleCountCategory

CYCL

UDC

F4101

GlCategory

GLPT

UDC

F4101

StockingType

STKT

UDC

F4101

LineType

LNTY

STRING

F4101

ContractItem

CONT

CHARACTER

F4101

DualUnitOfMeasureItem

DUAL

CHARACTER

F4101

LotNumberPreAsignment

LNPA

CHARACTER

F4101

Buyer1

BUYR

ADDRESSNUMBER

F4102

GlCategory1

GLPT

UDC

F4102

AddressNumberPlanner

ANPL

ADDRESSNUMBER

F4102

CountryOfOrigin

ORIG

UDC

F4102

ItemFlashMessage

IFLA

UDC

F4102

Carrier1

CARS

ADDRESSNUMBER

F4102

StockingType1

STKT

UDC

F4102

LineType1

LNTY

STRING

F4102

LeadtimeLevel

LTLV

INTEGER

F4102

LeadtimeMfg

LTMF

INTEGER

F4102

AcctingCostQty

ACQ

FLOAT

F4102

IssueTypeCode

ITC

UDC

F4102

PrimaryBinPS

PBIN

CHARACTER

F41021

GlCategory2

GLPT

UDC

F41021

LotStatusCode

LOTS

UDC

F41021

DateLastReceipt1

LRCJ

DATE

F41021

QtyOnHandPrimaryUn

PQOH

FLOAT

F41021

QtyBackorderedInPri

PBCK

FLOAT

F41021

QtyOnPurchaseOrderPr

PREQ

FLOAT

F41021

QuantityOnWoReceipt

QWBO

FLOAT

F41021

Qty1OtherPrimaryUn

OT1P

FLOAT

F41021

Qty2OtherPrimaryUn

OT2P

FLOAT

F41021

QtyOtherPurchasing1

OT1A

FLOAT

F41021

QuantitySoftCommitted

PCOM

FLOAT

F41021

QtyHardCommitted

HCOM

FLOAT

F41021

QtyOnFutureCommit

FCOM

FLOAT

F41021

WorkOrderSoftCommit

FUN1

FLOAT

F41021

QuantityOnWorkorder

QOWO

FLOAT

F41021

QtyInTranPrimaryUn

QTTR

FLOAT

F41021

QtyInInspPrimaryUn

QTIN

FLOAT

F41021

QuantityOnLoanToMa

QONL

FLOAT

F41021

QuantityInboundWareh

QTRI

FLOAT

F41021

QuantityOutboundWare

QTRO

FLOAT

F41021

DateNextInventoryCnt

NCDJ

DATE

F41021

QtyOnHandInSeconda

SQOH

FLOAT

F41021

CriticalHoldFlag

CHDF

CHARACTER

F41021

PrimaryLastVendorNo

VEND

ADDRESSNUMBER

F4102

SerialNumberRequired

SRNR

UDC

F4102

SerialNumberRequired1

SRNR

UDC

F4101

ReorderPointInput

ROPI

FLOAT

F4102

ReorderQuantityInput

ROQI

FLOAT

F4102

ReorderQuantityMaximum

RQMX

FLOAT

F4102

ReorderQuantityMinimum

RQMN

FLOAT

F4102

OrderMultiples

WOMO

INTEGER

F4102

LotStatusCode1

LOTS

UDC

F4102

SafetyStockDaysSupply

SAFE

FLOAT

F4102

ShippingCommodityClass

SHCM

UDC

F4102

CycleCountCategory1

CYCL

UDC

F4102

TypeWarranty

WARR

STRING

F4102

PrintMessage1

INMG

UDC

F4102

PlanningCode

MPST

UDC

F4102

MfgLeadtimeQty

MLQ

FLOAT

F4102

FixedVariableLeadtime

MRPP

UDC

F4102

TimeBasisCode

TIMB

UDC

F4102

SafetyLeadtime

SFLT

INTEGER

F4102

QtyOrderMultiples

MULT

FLOAT

F4102

SalesReportingCode6

SRP6

UDC

F4101

SalesReportingCode10

SRP0

UDC

F4101

SalesReportingCode9

SRP9

UDC

F4101

SalesReportingCode8

SRP8

UDC

F4101

SalesReportingCode7

SRP7

UDC

F4101

PurchReportingCode10

PRP0

UDC

F4101

PurchReportingCode9

PRP9

UDC

F4101

PurchReportingCode8

PRP8

UDC

F4101

PurchReportingCode7

PRP7

UDC

F4101

PurchReportingCode6

PRP6

UDC

F4101

PurchReportingCode101

PRP0

UDC

F4102

PurchReportingCode91

PRP9

UDC

F4102

PurchReportingCode81

PRP8

UDC

F4102

PurchReportingCode71

PRP7

UDC

F4102

PurchReportingCode61

PRP6

UDC

F4102

PurchasingReportCode51

PRP5

UDC

F4102

PurchasingReportCode41

PRP4

UDC

F4102

PurchasingReportCode31

PRP3

UDC

F4102

PurchasingReportCode21

PRP2

UDC

F4102

PurchasingReportCode11

PRP1

UDC

F4102

SalesReportingCode101

SRP0

UDC

F4102

SalesReportingCode91

SRP9

UDC

F4102

SalesReportingCode81

SRP8

UDC

F4102

SalesReportingCode71

SRP7

UDC

F4102

SalesReportingCode61

SRP6

UDC

F4102

SalesReportingCode51

SRP5

UDC

F4102

SalesReportingCode41

SRP4

UDC

F4102

SalesReportingCode31

SRP3

UDC

F4102

SalesReportingCode21

SRP2

UDC

F4102

SalesReportingCode11

SRP1

UDC

F4102

QtyInOperation1

QTO1

FLOAT

F41021

QtyInOperation2

QTO2

FLOAT

F41021

DateUpdated

UPMJ

DATE

F4101

DateUpdated1

UPMJ

DATE

F4102

DateUpdated2

UPMJ

DATE

F41021

DescriptionLot

LDSC

STRING

F4108

LotStatusCode2

LOTS

UDC

F4108

PrimaryLastVendorNo1

VEND

ADDRESSNUMBER

F4108

CompanyKeyOrderNo

KCOO

COMPANY

F4108

DocumentOrderInvoiceE

DOCO

INTEGER

F4108

OrderType

DCTO

UDC

F4108

VendorLotNumber

RLOT

STRING

F4108

LotPotency

LOTP

FLOAT

F4108

LotGrade

LOTG

UDC

F4108

Date_-_Lot_Expiration

MMEJ

DATE

F4108

SerialNumberLot

SERN

STRING

F4108

MemoLotField1

LOT1

STRING

F4108

MemoLotField2

LOT2

STRING

F4108

MemoLotField3

LOT3

STRING

F4108

LotEffectivityDate

DLEJ

DATE

F4108

BasedOnDate

BODJ

DATE

F4108

OnHandDate

OHDJ

DATE

F4108

BestBeforeDate

BBDJ

DATE

F4108

SellByDate

SBDJ

DATE

F4108

DocumentOrderInvoi

DOC1

INTEGER

F4108

LotEffectiveDefaultDays

LEDD

INTEGER

F4102

LotExpirationDateCalculationMethod

LECM

UDC

F4102

ShelfLifeDays

SLD

INTEGER

F4102

LayerCodeSource

SRCE

UDC

F4102

UnitsPerContainer

UPC

INTEGER

F4102

JavaScript errors detected

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

If this problem persists, please contact our support.