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 |