Skip to main content
Skip table of contents

VQ354101 - Q35 Item Balances F4101/F4102/F41021


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

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

Location

LOCN

LOCATION

F41021

Lot

LOTN

STRING

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

LayerCodeSource

SRCE

UDC

F4102

JavaScript errors detected

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

If this problem persists, please contact our support.