Item Fields Json & Internal Names
itemNumber
No.
itemNumber2
No. 2
description
Description
searchDescription
Search Description
description2
Description 2
assemblyBom
Assembly BOM
baseUnitOfMeasure
Base Unit of Measure
priceUnitConversion
Price Unit Conversion
type
Type
inventoryPostingGroup
Inventory Posting Group
shelfNumber
Shelf No.
itemDiscountGroup
Item Disc. Group
allowInvoiceDiscount
Allow Invoice Disc.
statisticsGroup
Statistics Group
commissionGroup
Commission Group
unitPrice
Unit Price
priceProfitCalculation
Price/Profit Calculation
profitPercentage
Profit %
costingMethod
Costing Method
unitCost
Unit Cost
standardCost
Standard Cost
lastDirectCost
Last Direct Cost
indirectCostPercentage
Indirect Cost %
costIsAdjusted
Cost is Adjusted
allowOnlineAdjustment
Allow Online Adjustment
vendorNumber
Vendor No.
vendorItemNumber
Vendor Item No.
leadTimeCalculation
Lead Time Calculation
reorderPoint
Reorder Point
maximumInventory
Maximum Inventory
reorderQuantity
Reorder Quantity
alternativeItemNumber
Alternative Item No.
unitListPrice
Unit List Price
dutyDuePercentage
Duty Due %
dutyCode
Duty Code
grossWeight
Gross Weight
netWeight
Net Weight
unitsPerParcel
Units per Parcel
unitVolume
Unit Volume
durability
Durability
freightType
Freight Type
tariffNumber
Tariff No.
dutyUnitConversion
Duty Unit Conversion
countryRegionPurchasedCode
Country/Region Purchased Code
budgetQuantity
Budget Quantity
budgetedAmount
Budgeted Amount
budgetProfit
Budget Profit
comment
Comment
blocked
Blocked
costIsPostedToGL
Cost is Posted to G/L
blockReason
Block Reason
lastDateTimeModified
Last DateTime Modified
lastDateModified
Last Date Modified
lastTimeModified
Last Time Modified
dateFilter
Date Filter
globalDimension1Filter
Global Dimension 1 Filter
globalDimension2Filter
Global Dimension 2 Filter
locationFilter
Location Filter
inventory
Inventory
netInvoicedQuantity
Net Invoiced Qty.
netChange
Net Change
purchasesQuantity
Purchases (Qty.)
salesQuantity
Sales (Qty.)
positiveAdjustmentQuantity
Positive Adjmt. (Qty.)
negativeAdjustmentQuantity
Negative Adjmt. (Qty.)
purchasesLocalCurrency
Purchases (LCY)
salesLocalCurrency
Sales (LCY)
positiveAdjustmentLocalCurrency
Positive Adjmt. (LCY)
negativeAdjustmentLocalCurrency
Negative Adjmt. (LCY)
cogsLocalCurrency
COGS (LCY)
quantityOnPurchasingOrder
Qty. on Purch. Order
quantityOnSalesOrder
Qty. on Sales Order
priceIncludesVat
Price Includes VAT
dropShipmentFilter
Drop Shipment Filter
vatBusinessPostingGroupPrice
VAT Bus. Posting Gr. (Price)
generalProductionPostingGroup
Gen. Prod. Posting Group
picture
Picture
transferredQuantity
Transferred (Qty.)
transferredLocalCurrency
Transferred (LCY)
countryRegionOfOriginCode
Country/Region of Origin Code
automaticExtendedTexts
Automatic Ext. Texts
numberSeries
No. Series
taxGroupCode
Tax Group Code
vatProductionPostingGroup
VAT Prod. Posting Group
reserve
Reserve
reservedQuantityOnInventory
Reserved Qty. on Inventory
reservedQuantityOnPurchasingOrders
Reserved Qty. on Purch. Orders
reservedQuantityOnSalesOrders
Reserved Qty. on Sales Orders
globalDimension1Code
Global Dimension 1 Code
globalDimension2Code
Global Dimension 2 Code
reservedQuantityOnOutboundTransfer
Res. Qty. on Outbound Transfer
reservedQuantityOnInboundTransfer
Res. Qty. on Inbound Transfer
reservedQuantityOnSalesReturns
Res. Qty. on Sales Returns
reservedQuantityOnPurchasingReturns
Res. Qty. on Purch. Returns
stockoutWarning
Stockout Warning
preventNegativeInventory
Prevent Negative Inventory
variantMandatoryIfExists
Variant Mandatory if Exists
costOfOpenProductionOrders
Cost of Open Production Orders
applicationWorksheetUserId
Application Wksh. User ID
coupledToDataverse
Coupled to Dataverse
assemblyPolicy
Assembly Policy
reservedQuantityOnAssemblyOrder
Res. Qty. on Assembly Order
reservedQuantityOnAssemblyComponent
Res. Qty. on Asm. Comp.
quantityOnAssemblyOrder
Qty. on Assembly Order
quantityOnAssemblyComponent
Qty. on Asm. Component
quantityOnJobOrder
Qty. on Job Order
reservedQuantityOnJobOrder
Res. Qty. on Job Order
gtin
GTIN
defaultDeferralTemplateCode
Default Deferral Template Code
lowLevelCode
Low-Level Code
lotSize
Lot Size
serialNumbers
Serial Nos.
lastUnitCostCalculatedDate
Last Unit Cost Calc. Date
rolledUpMaterialCost
Rolled-up Material Cost
rolledUpCapacityCost
Rolled-up Capacity Cost
scrapPercentage
Scrap %
inventoryValueZero
Inventory Value Zero
discreteOrderQuantity
Discrete Order Quantity
minimumOrderQuantity
Minimum Order Quantity
maximumOrderQuantity
Maximum Order Quantity
safetyStockQuantity
Safety Stock Quantity
orderMultiple
Order Multiple
safetyLeadTime
Safety Lead Time
flushingMethod
Flushing Method
replenishmentSystem
Replenishment System
scheduledReceiptQuantity
Scheduled Receipt (Qty.)
roundingPrecision
Rounding Precision
binFilter
Bin Filter
variantFilter
Variant Filter
salesUnitOfMeasure
Sales Unit of Measure
purchasingUnitOfMeasure
Purch. Unit of Measure
unitOfMeasureFilter
Unit of Measure Filter
timeBucket
Time Bucket
reservedQuantityOnProductionOrder
Reserved Qty. on Prod. Order
reservedQuantityOnProductionOrderComponent
Res. Qty. on Prod. Order Comp.
reservedQuantityOnRequisitionLine
Res. Qty. on Req. Line
reorderingPolicy
Reordering Policy
includeInventory
Include Inventory
manufacturingPolicy
Manufacturing Policy
reschedulingPeriod
Rescheduling Period
lotAccumulationPeriod
Lot Accumulation Period
dampenerPeriod
Dampener Period
dampenerQuantity
Dampener Quantity
overflowLevel
Overflow Level
planningTransferShipmentQuantity
Planning Transfer Ship. (Qty).
planningWorksheetQuantity
Planning Worksheet (Qty.)
stockkeepingUnitExists
Stockkeeping Unit Exists
manufacturerCode
Manufacturer Code
itemCategoryCode
Item Category Code
createdFromNonstockItem
Created From Nonstock Item
substitutesExist
Substitutes Exist
quantityInTransit
Qty. in Transit
transferOrderReceiptQuantity
Trans. Ord. Receipt (Qty.)
transferOrderShipmentQuantity
Trans. Ord. Shipment (Qty.)
purchasingCode
Purchasing Code
quantityAssignedToShip
Qty. Assigned to ship
quantityPicked
Qty. Picked
excludedFromCostAdjustment
Excluded from Cost Adjustment
serviceItemGroup
Service Item Group
quantityOnServiceOrder
Qty. on Service Order
reservedQuantityOnServiceOrders
Res. Qty. on Service Orders
itemTrackingCode
Item Tracking Code
lotNumbers
Lot Nos.
expirationCalculation
Expiration Calculation
lotNumberFilter
Lot No. Filter
serialNumberFilter
Serial No. Filter
packageNumberFilter
Package No. Filter
quantityOnPurchasingReturn
Qty. on Purch. Return
quantityOnSalesReturn
Qty. on Sales Return
numberOfSubstitutes
No. of Substitutes
warehouseClassCode
Warehouse Class Code
specialEquipmentCode
Special Equipment Code
putAwayTemplateCode
Put-away Template Code
putAwayUnitOfMeasureCode
Put-away Unit of Measure Code
physicalInventoryCountingPeriodCode
Phys Invt Counting Period Code
lastCountingPeriodUpdate
Last Counting Period Update
lastPhysicalInventoryDate
Last Phys. Invt. Date
useCrossDocking
Use Cross-Docking
nextCountingStartDate
Next Counting Start Date
nextCountingEndDate
Next Counting End Date
unitGroupExists
Unit Group Exists
identifierCode
Identifier Code
unitOfMeasureId
Unit of Measure Id
taxGroupId
Tax Group Id
salesBlocked
Sales Blocked
purchasingBlocked
Purchasing Blocked
itemCategoryId
Item Category Id
inventoryPostingGroupId
Inventory Posting Group Id
generalProductionPostingGroupId
Gen. Prod. Posting Group Id
serviceBlocked
Service Blocked
overReceiptCode
Over-Receipt Code
routingNumber
Routing No.
productionBomNumber
Production BOM No.
singleLevelMaterialCost
Single-Level Material Cost
singleLevelCapacityCost
Single-Level Capacity Cost
singleLevelSubcontractedCost
Single-Level Subcontrd. Cost
singleLevelCapacityOverheadCost
Single-Level Cap. Ovhd Cost
singleLevelManufacturingOverheadCost
Single-Level Mfg. Ovhd Cost
overheadRate
Overhead Rate
rolledUpSubcontractedCost
Rolled-up Subcontracted Cost
rolledUpManufacturingOverheadCost
Rolled-up Mfg. Ovhd Cost
rolledUpCapitalOverheadCost
Rolled-up Cap. Overhead Cost
planningIssuesQuantity
Planning Issues (Qty.)
planningReceiptQuantity
Planning Receipt (Qty.)
plannedOrderReceiptQuantity
Planned Order Receipt (Qty.)
fpOrderReceiptQuantity
FP Order Receipt (Qty.)
releaseOrderReceiptQuantity
Rel. Order Receipt (Qty.)
planningReleaseQuantity
Planning Release (Qty.)
plannedOrderReleaseQuantity
Planned Order Release (Qty.)
purchasingRequisitionReceiptQuantity
Purch. Req. Receipt (Qty.)
purchasingRequisitionReleaseQuantity
Purch. Req. Release (Qty.)
orderTrackingPolicy
Order Tracking Policy
productionForecastQuantityBase
Prod. Forecast Quantity (Base)
productionForecastName
Production Forecast Name
componentForecast
Component Forecast
quantityOnProductionOrder
Qty. on Prod. Order
quantityOnComponentLines
Qty. on Component Lines
critical
Critical
commonItemNumber
Common Item No.
Last updated