JDE Reference
F4102
masterAlso in JDE WorldItem branch — branch/plant-level item attributes, planning parameters, and sourcing responsibility
Module: 41 · Inventory ManagementColumn prefix: IB
What the badges mean
- Superseded
- Superseded — a newer table has replaced it, but older scripts still read this one.
- Also in JDE World
- Also present in JDE World A9.x on the same table name.
- master
- Data class: what the table holds — master data, transaction documents, control/setup values, history, or a workfile.
- Read/write access
- Access mode: how the paired program reads or writes this table — R (read), W (write), or R/W (both).
No lifecycle badge means the table is current and not documented in JDE World. In field listings, K marks a primary-key field.
Used in the library
Fields
36 fields · 2 key
36 fields.
| Key | Field | Alias | Description | Type | Length | Flags |
|---|---|---|---|---|---|---|
| Primary key | IBITM | ITM | Short item number - the internal numeric item key | Numeric | 8 | |
| Primary key | IBMCU | MCU | Business unit / branch plant (right-justified, space-padded to 12) | String | 12 | |
| IBLITM | LITM | Second item number - the primary user-facing item code | String | 25 | ||
| IBAITM | AITM | Third item number - catalog or cross-reference item code | String | 25 | ||
| IBSTKT | STKT | Stocking type - how the item is stocked/made/purchased | Character | 1 | ||
| IBGLPT | GLPT | G/L class code driving inventory account derivation through AAIs | String | 4 | ||
| IBLNTY | LNTY | Line type controlling inventory/GL/AR interfaces (S, N, F, ...) | String | 2 | ||
| IBPDGR | PDGR | Product group for pricing | String | 3 | ||
| IBBUYR | BUYR | Buyer address book number responsible for the item at this branch | Numeric | 8 | ||
| IBVEND | VEND | Primary (or most recent) supplier address book number | Numeric | 8 | ||
| IBANPL | ANPL | Planner address book number | Numeric | 8 | ||
| IBSRP0 | SRP0 | Sales category code 10 (6-char) | String | 6 | ||
| IBSRP1 | SRP1 | Sales category code 1 - catalog section | String | 3 | ||
| IBSRP2 | SRP2 | Sales category code 2 - sub section | String | 3 | ||
| IBSRP3 | SRP3 | Sales category code 3 | String | 3 | ||
| IBSRP4 | SRP4 | Sales category code 4 | String | 3 | ||
| IBSRP5 | SRP5 | Sales category code 5 | String | 3 | ||
| IBPRP0 | PRP0 | Purchasing category code - item pool (6-char) | String | 6 | ||
| IBPRP1 | PRP1 | Purchasing category code 1 - commodity class | String | 3 | ||
| IBPRP2 | PRP2 | Purchasing category code 2 - commodity sub class | String | 3 | ||
| IBPRP3 | PRP3 | Purchasing category code 3 - supplier rebate code | String | 3 | ||
| IBPRP4 | PRP4 | Purchasing category code 4 - master planning family | String | 3 | ||
| IBPRP5 | PRP5 | Purchasing category code 5 | String | 3 | ||
| IBMPST | MPST | Planning code - how MRP/DRP plans the item | Character | 1 | ||
| IBLTLV | LTLV | Level lead time in days | Numeric | 5 | ||
| IBLTCM | LTCM | Cumulative lead time in days | Numeric | 5 | ||
| IBLTMF | LTMF | Manufacturing lead time in days | Numeric | 5 | ||
| IBSAFE | SAFE | Safety stock quantity | Numeric | 15 | ||
| IBROQI | ROQI | Fixed reorder quantity entered for the branch | Numeric | 15 | ||
| IBROPI | ROPI | Reorder point entered for the branch | Numeric | 15 | ||
| IBABCS | ABCS | ABC ranking by sales | Character | 1 | ||
| IBABCM | ABCM | ABC ranking by margin | Character | 1 | ||
| IBABCI | ABCI | ABC ranking by investment | Character | 1 | ||
| IBBACK | BACK | Whether backorders are allowed for this item at this branch | Character | 1 | ||
| IBSLD | SLD | Shelf life in days | Numeric | 6 | ||
| IBLOTS | LOTS | Default lot status code | Character | 1 |
Field provenance: hand-curated.
Boilerplate SQL
Starting point for reading F4102 on Databricks — Julian dates, implied decimals, and padded strings are already converted. Set your Unity Catalog location and filter values below; they’re substituted into the SQL and the copy button.
Query parameters
4 parameters not filled: <catalog>, <schema_data>, <ITM>, <MCU>
-- ============================================================
-- Table : F4102 Item branch — branch/plant-level item attributes, planning parameters, and sourcing responsibility
-- Purpose: Column-selected read of F4102 — auto-generated from field metadata
-- Grain : One row per IBITM + IBMCU
-- Notes : Auto-generated skeleton. Julian dates (CYYDDD) are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210); padded business-unit/UDC keys are TRIMmed. Audit columns (…USER/…PID/…UPMJ) are omitted — see the quirks guide. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
ib.IBITM AS "Short item number - the internal numeric item key",
TRIM(ib.IBMCU) AS "Business unit / branch plant (right-justified, space-padded to 12)",
ib.IBLITM AS "Second item number - the primary user-facing item code",
ib.IBAITM AS "Third item number - catalog or cross-reference item code",
ib.IBSTKT AS "Stocking type - how the item is stocked/made/purchased",
ib.IBGLPT AS "G/L class code driving inventory account derivation through AAIs",
ib.IBLNTY AS "Line type controlling inventory/GL/AR interfaces (S, N, F, ...)",
ib.IBPDGR AS "Product group for pricing",
ib.IBBUYR AS "Buyer address book number responsible for the item at this branch",
ib.IBVEND AS "Primary (or most recent) supplier address book number",
ib.IBANPL AS "Planner address book number",
ib.IBSRP0 AS "Sales category code 10 (6-char)",
ib.IBSRP1 AS "Sales category code 1 - catalog section",
ib.IBSRP2 AS "Sales category code 2 - sub section",
ib.IBSRP3 AS "Sales category code 3",
ib.IBSRP4 AS "Sales category code 4",
ib.IBSRP5 AS "Sales category code 5",
ib.IBPRP0 AS "Purchasing category code - item pool (6-char)",
ib.IBPRP1 AS "Purchasing category code 1 - commodity class",
ib.IBPRP2 AS "Purchasing category code 2 - commodity sub class",
ib.IBPRP3 AS "Purchasing category code 3 - supplier rebate code",
ib.IBPRP4 AS "Purchasing category code 4 - master planning family",
ib.IBPRP5 AS "Purchasing category code 5",
ib.IBMPST AS "Planning code - how MRP/DRP plans the item",
ib.IBLTLV AS "Level lead time in days",
ib.IBLTCM AS "Cumulative lead time in days",
ib.IBLTMF AS "Manufacturing lead time in days",
ib.IBSAFE AS "Safety stock quantity",
ib.IBROQI AS "Fixed reorder quantity entered for the branch",
ib.IBROPI AS "Reorder point entered for the branch",
ib.IBABCS AS "ABC ranking by sales",
ib.IBABCM AS "ABC ranking by margin",
ib.IBABCI AS "ABC ranking by investment",
ib.IBBACK AS "Whether backorders are allowed for this item at this branch",
ib.IBSLD AS "Shelf life in days",
ib.IBLOTS AS "Default lot status code"
FROM <catalog>.<schema_data>.f4102 ib
WHERE
ib.IBITM = <ITM>
-- AND ib.IBMCU = '<MCU>'
ORDER BY ib.IBITM;Verified September 2026
Relationships
Diagram of 1-hop neighbors — join details below. UDC decode edges point coded fields at their F0005 lookup.
Programs That Use This Table
R read · W write · R/W read + write
Primary programs
Secondary programs
- P3002Bill of Material Revisions — the screen where engineering builds and maintains bills of material: components, quantities per, effectivity dates, and substitutes.Read accessInteractive
- P3003Enter/Change Routing — the screen where manufacturing engineering defines the standard routing for an item: operations, work centers, and labor/machine time standards.Read accessInteractive
- P3111Work Order Parts List — the screen for reviewing and revising the components attached to a specific work order, including substitutions and commitment changes.Read accessInteractive
- P3411MRP/MPS Detail Message Revisions — the screen where planners review and process the action messages MRP generated, releasing them into work orders or purchase orders.Read accessInteractive
- P3413MPS Time Series — the screen that shows an item's time-phased supply and demand picture (the planning time series) produced by the last MRP/MPS run.Read accessInteractive
- P3460Forecast Revisions — the screen where planners review and manually adjust detail forecast quantities and amounts by item, branch, and forecast type.Read accessInteractive
- P4101Item Master — the interactive application that creates and maintains F4101 itemsWrite accessInteractive
- P4105Cost Revisions — maintain item costs by cost method and branch/plant, generating variance journal entries on changeRead accessInteractive
- P4106Base Price Revisions — maintain base sales prices by item, branch, customer, or customer group with effective datesRead accessInteractive
- P4108Lot Master — maintain lot records, statuses, and dates for lot- and serial-controlled inventoryRead accessInteractive
- P4111Item Ledger Inquiry (Cardex) — review the full transaction history behind every inventory quantity movementRead accessInteractive
- P4112Inventory Issues — remove inventory from stock (for example to scrap or expense) with matching journal entriesRead accessInteractive
- P4113Inventory Transfers — move inventory between locations or branch/plants, recording both sides of the movementRead accessInteractive
- P4114Inventory Adjustments — correct on-hand quantity discrepancies (cycle count variances, damage, initial loads)Read accessInteractive
- P4116Item Reclassifications — reclassify inventory from one item number, lot, or location to anotherRead accessInteractive
- P41202Item Availability — inquire on on-hand, committed, and available quantities by item, branch, location, and lotRead accessInteractive
- P4310Purchase Order Entry — create and revise purchase orders, requisitions, and quotes (header and detail lines)Read accessInteractive
- P4312PO Receipts — record receipt of goods against purchase orders, updating on-hand inventory and creating receiver recordsRead accessInteractive
- P48013Enter/Change Order — the screen where manufacturing work orders are created and maintained: item, quantity, dates, status, and branch before shop floor processing begins.Read accessInteractive
- R34650Forecast Generation — the batch job that builds statistical demand forecasts from sales history, testing up to twelve forecasting methods and keeping the best fit per item.Read accessBatch UBE
- R3482MRP/MPS Requirements Planning — the batch job that runs single-facility MRP/MPS, netting forecasts, sales orders, and on-hand supply into time-phased plans and action messages.Read accessBatch UBE
- R3483Master Planning Schedule - Multiple Plant — the batch job that runs multifacility requirements planning, generating transfer-order messages and time series across a network of branch/plants.Read accessBatch UBE
More Inventory Management tables
- F41021Item location — on-hand, committed, and inbound quantities by item, branch, location, and lot
- F4104Item cross-reference: links internal item numbers to external identifiers such as customer or supplier part numbers, substitutes, and replacements, keyed by cross-reference type.
- F4105Item cost table: one row per item, branch, location, lot, and cost method carrying the unit cost used to value inventory and purchasing transactions.
- F4108Lot master: one row per lot or serial number by item and branch, holding lot status, grade, potency, supplier lot linkage, and the full set of lot control dates.
- F4111Item ledger (Cardex) — every inventory movement with quantity, cost, and links back to source documents
- F4100Warehouse location master: one row per storage location within a branch/plant, defining physical attributes plus putaway, pick, and replenishment behavior.