IN
INItemSite
No summary is documented for this DAC in the release source.
View API Entity: ItemWarehouse
/entity/Default/25.200.001/ItemWarehouse| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ABCCodeID | char(1) | ABC Code | INABCCode | |
Description:No description available | ||||
ABCCodeIsFixed | bit | Fixed ABC Code | - | |
Description:No description available | ||||
ABCCodeOverride | bit | ABC Code Override | - | |
Description:No description available | ||||
AMBOMID | nvarchar(15) | Default BOM ID | AMBomItem | |
Description:Default BOM ID | ||||
AMConfigurationID | nvarchar(15) | Configuration ID | AMConfiguration | |
Description:Item configuration ID. If null, this item will fallback to StockItem configuration ID | ||||
AMGroupWindow | int | Days of Supply | - | |
Description:Days of Supply | ||||
AMGroupWindowOverride | bit | Override | - | |
Description:Override Days of Supply | ||||
AMLotSize | decimal | Lot Size | - | |
Description:Lot Size | ||||
AMLotSizeOverride | bit | Override | - | |
Description:Override of Lot Size | ||||
AMMFGLeadTime | int | Manufacturing Lead Time | - | |
Description:Manufacturing Lead Time | ||||
AMMFGLeadTimeOverride | bit | Override | - | |
Description:Override of Manufacturing Lead Time | ||||
AMMaxOrdQty | decimal | Max Order Qty | - | |
Description:Max Order Qty | ||||
AMMaxOrdQtyOverride | bit | Override | - | |
Description:Override of Max Order Qty | ||||
AMMinOrdQty | decimal | Min Order Qty | - | |
Description:Min Order Qty | ||||
AMMinOrdQtyOverride | bit | Override | - | |
Description:Override Min Order Qty | ||||
AMMinQtyNonexistent in DB | decimal? | Reorder Point | - | |
Description:Reorder Point | ||||
AMMinQtyOverrideNonexistent in DB | bool? | Override | - | |
Description:Override of Reorder Point | ||||
AMPlanningBOMID | nvarchar(15) | Planning BOM ID | AMBomItem | |
Description:Planning BOM ID | ||||
AMReplenishmentSourceNonexistent in DB | string | Source | - | |
Description:Source | ||||
AMReplenishmentSourceOverride | bit | Override | - | |
Description:Override of Source | ||||
AMSafetyStockNonexistent in DB | decimal? | Safety Stock | - | |
Description:Safety Stock | ||||
AMSafetyStockOverrideNonexistent in DB | bool? | Override | - | |
Description:Override of Safety Stock | ||||
AMScrapLocationID | int | Scrap Location | INLocation | |
Description:Scrap Location | ||||
AMScrapOverride | bit | Scrap Override | - | |
Description:Scrap Override | ||||
AMScrapSiteID | int | Scrap Warehouse | - | |
Description:Scrap Warehouse | ||||
AMSourceSiteID | int | Source Warehouse | - | |
Description:Source Warehouse | ||||
AMSourceSiteIDOverride | bit | Override | - | |
Description:Override of Source Warehouse | ||||
AMTransferLeadTime | int | Transfer Lead Time | - | |
Description:Transfer Lead Time | ||||
AMTransferLeadTimeOverride | bit | Override | - | |
Description:Override of Transfer Lead Time | ||||
Active | bit | Active | - | |
Description:No description available | ||||
AutoFitModel | bit | Auto Fit Model | - | |
Description:No description available | ||||
AvgCostNonexistent in DB | decimal? | Average Cost | - | |
Description:No description available | ||||
BasePrice | decimal | Current Price | - | |
Description:No description available | ||||
BasePriceDate | datetime | Effective Date | - | |
Description:No description available | ||||
BasePriceOverride | bit | Price Override | - | |
Description:No description available | ||||
Commissionable | bit | Subject to Commission | - | |
Description:No description available | ||||
CountryOfOrigin | nvarchar(100) | Country Of Origin | Country | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime API | datetime | - | ||
Description:No description available | ||||
DemandPerDayAverage | decimal | Daily Demand Forecast | - | |
Description:No description available | ||||
DemandPerDayMAD | decimal | Daily Forecast Error(MAD) | - | |
Description:No description available | ||||
DemandPerDayMSE | decimal | Daily Demand Forecast Error(MSE) | - | |
Description:No description available | ||||
DemandPerDaySTDEVNonexistent in DB | decimal? | Daily Demand Forecast Error(STDEV) | - | |
Description:No description available | ||||
DfltPurchaseUnit | nvarchar(6) | Purchase Unit | INUnit | |
Description:No description available | ||||
DfltPutawayLocationID | int | Default Putaway To | INLocation | |
Description:The location of the warehouse to be used by default to put away the selected stock item. | ||||
DfltReceiptLocationID API | int | Default Receipt To | INLocation | |
Description:No description available | ||||
DfltSalesUnit | nvarchar(6) | Sales Unit | INUnit | |
Description:No description available | ||||
DfltShipLocationID API | int | Default Issue From | INLocation | |
Description:No description available | ||||
ESSmoothingConstantL | decimal | Level Smoothing Constant | - | |
Description:No description available | ||||
ESSmoothingConstantLOverride | bit | Override | - | |
Description:No description available | ||||
ESSmoothingConstantS | decimal | Seasonality Smoothing Constant | - | |
Description:No description available | ||||
ESSmoothingConstantSOverride | bit | Override | - | |
Description:No description available | ||||
ESSmoothingConstantT | decimal | Trend Smoothing Constant | - | |
Description:No description available | ||||
ESSmoothingConstantTOverride | bit | Override | - | |
Description:No description available | ||||
ForecastModelType | char(3) | Demand Forecast Model Used | - | |
Description:No description available | ||||
ForecastPeriodType | char(2) | Forecast Period Type Used | - | |
Description:No description available | ||||
InventoryID API | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InvtAcctID API | int | Inventory Account | Account | |
Description:No description available | ||||
InvtSubID API | int | Inventory Sub. | Sub | |
Description:No description available | ||||
IsDefaultNonexistent in DB | bool? | Default | - | |
Description:No description available | ||||
LastBasePrice | decimal | Last Price | - | |
Description:No description available | ||||
LastCost | decimal | Last Cost | - | |
Description:No description available | ||||
LastCostDateNonexistent in DB | DateTime? | - | ||
Description:No description available | ||||
LastFCApplicationDate | datetime | Last Forecast Results Application Date | - | |
Description:No description available | ||||
LastForecastDate | datetime | Last Forecast Date | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime API | datetime | - | ||
Description:No description available | ||||
LastStdCost | decimal | Last Cost | - | |
Description:No description available | ||||
LaunchDate | datetime | Launch Date | - | |
Description:No description available | ||||
LaunchDateOverride | bit | Override | - | |
Description:No description available | ||||
LeadTimeAverage | decimal | Lead Time Average | - | |
Description:No description available | ||||
LeadTimeMSE | decimal | Lead Time Deviation | - | |
Description:No description available | ||||
LeadTimeSTDEVNonexistent in DB | decimal? | Lead Time STDEV | - | |
Description:No description available | ||||
MarkupPct | decimal | Markup % | - | |
Description:No description available | ||||
MarkupPctOverride | bit | Override Markup % | - | |
Description:No description available | ||||
MaxCost | decimal | Max. Cost | - | |
Description:No description available | ||||
MaxQty API | decimal | Max Qty. | - | |
Description:No description available | ||||
MaxQtyOverride API | bit | Override | - | |
Description:No description available | ||||
MaxQtySuggested | decimal | Max Qty Suggested | - | |
Description:No description available | ||||
MaxShelfLife | int | Max. Shelf Life (Days) | - | |
Description:No description available | ||||
MaxShelfLifeOverride | bit | Override | - | |
Description:No description available | ||||
MinCost | decimal | Min. Cost | - | |
Description:No description available | ||||
MinQty API | decimal | Reorder Point | - | |
Description:No description available | ||||
MinQtyOverride API | bit | Override | - | |
Description:No description available | ||||
MinQtySuggested | decimal | Reorder Point Suggested | - | |
Description:No description available | ||||
MovementClassID | nvarchar(1) | Movement Class | INMovementClass | |
Description:No description available | ||||
MovementClassIsFixed | bit | Fixed Movement Class | - | |
Description:No description available | ||||
MovementClassOverride | bit | Movement Class Override | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OverrideInvtAcctSub API | bit | Override Inventory Account/Sub. | - | |
Description:No description available | ||||
POCreateNonexistent in DB | bool? | Mark fo PO | - | |
Description:No description available | ||||
POSourceNonexistent in DB | string | - | ||
Description:No description available | ||||
PendingBasePrice | decimal | Pending Price | - | |
Description:No description available | ||||
PendingBasePriceDate | datetime | Pending Price Date | - | |
Description:No description available | ||||
PendingMovementClassID | nvarchar(1) | INMovementClass | ||
Description:No description available | ||||
PendingMovementClassPeriodID | string | - | ||
Description:No description available | ||||
PendingMovementClassUpdateDate | datetime | - | ||
Description:No description available | ||||
PendingStdCost | decimal | Pending Cost | - | |
Description:No description available | ||||
PendingStdCostDate | datetime | Pending Cost Date | - | |
Description:No description available | ||||
PendingStdCostReset | bit | - | ||
Description:No description available | ||||
PlanningMethod | char(1) | Planning Method | - | |
Description:Planning method | ||||
PreferredVendorID API | int | Preferred Vendor | Vendor | |
Description:No description available | ||||
PreferredVendorLocationID API | int | Preferred Location | Location | |
Description:No description available | ||||
PreferredVendorOverride API | bit | Override Preferred Vendor | - | |
Description:No description available | ||||
PriceManagerID | int | Price Manager | EPEmployee | |
Description:No description available | ||||
PriceWorkgroupID | int | Price Workgroup | EPCompanyTree | |
Description:No description available | ||||
ProductManagerID API | int | Product Manager | EPEmployee | |
Description:No description available | ||||
ProductManagerOverride API | bit | Override Product Manager | - | |
Description:No description available | ||||
ProductWorkgroupID API | int | Product Workgroup | EPCompanyTree | |
Description:No description available | ||||
RecPrice API | decimal | MSRP | - | |
Description:No description available | ||||
RecPriceOverride API | bit | Override Price | - | |
Description:No description available | ||||
ReplenishmentClassID API | nvarchar(10) | Replenishment Class | INReplenishmentClass | |
Description:No description available | ||||
ReplenishmentMethod API | char(1) | Replenishment Method | - | |
Description:No description available | ||||
ReplenishmentPolicyID API | nvarchar(10) | Seasonality | INReplenishmentPolicy | |
Description:No description available | ||||
ReplenishmentPolicyOverride API | bit | Override Replenishment Settings | - | |
Description:No description available | ||||
ReplenishmentSource API | char(1) | Replenishment Source | - | |
Description:Replenishment source | ||||
ReplenishmentSourceSiteID API | int | Replenishment Warehouse | INSite | |
Description:No description available | ||||
SafetyStock API | decimal | Safety Stock | - | |
Description:No description available | ||||
SafetyStockOverride API | bit | Override | - | |
Description:No description available | ||||
SafetyStockSuggested | decimal | Safety Stock Suggested | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
ServiceLevel | decimal | Service Level | - | |
Description:No description available | ||||
ServiceLevelOverride API | bit | Override | - | |
Description:No description available | ||||
decimal? | Service Level (%) | - | ||
Description:No description available | ||||
SiteID API | int | Warehouse | INSite | |
Description:No description available | ||||
SiteStatus API | char(2) | Status | - | |
Description:No description available | ||||
StdCost | decimal | Current Cost | - | |
Description:No description available | ||||
StdCostDate | datetime | Effective Date | - | |
Description:No description available | ||||
StdCostOverride API | bit | Override Std. Cost | - | |
Description:No description available | ||||
SubItemOverride | bit | Override | - | |
Description:No description available | ||||
TerminationDate | datetime | Termination Date | - | |
Description:No description available | ||||
TerminationDateOverride | bit | Override | - | |
Description:No description available | ||||
TranUnitCostNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
TransferERQ | decimal | Transfer ERQ | - | |
Description:No description available | ||||
TransferERQOverride | bit | Override | - | |
Description:No description available | ||||
ValMethod | char(1) | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||