IN
INItemSiteSummary
PX.Objects.IN113 of 113 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
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 | ||||
Active | bit | Active | - | |
Description:No description available | ||||
AutoFitModel | bit | Auto Fit Model | - | |
Description:No description available | ||||
AvgCost | decimal | Average Cost | - | |
Description:No description available | ||||
BasePrice | decimal | Current Price | - | |
Description:No description available | ||||
BasePriceDate | datetime2 | 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 | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | 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:No description available | ||||
DfltReceiptLocationID | int | Default Receipt To | INLocation | |
Description:No description available | ||||
DfltSalesUnit | nvarchar(6) | Sales Unit | INUnit | |
Description:No description available | ||||
DfltShipLocationID | 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 | ||||
InvtAcctID | int | Inventory Account | Account | |
Description:No description available | ||||
InvtSubID | int | Inventory Sub. | Sub | |
Description:No description available | ||||
IsDefaultNonexistent in DB | bit | 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 | datetime2 | Last Forecast Results Application Date | - | |
Description:No description available | ||||
LastForecastDate | datetime2 | Last Forecast Date | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LastStdCost | decimal | Last Cost | - | |
Description:No description available | ||||
LaunchDate | datetime2 | 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 | decimal | Max Qty. | - | |
Description:No description available | ||||
MaxQtyOverride | 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 | decimal | Reorder Point | - | |
Description:No description available | ||||
MinQtyOverride | 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 | bit | Override Inventory Account/Sub. | - | |
Description:No description available | ||||
PendingBasePrice | decimal | Pending Price | - | |
Description:No description available | ||||
PendingBasePriceDate | datetime2 | Pending Price Date | - | |
Description:No description available | ||||
PendingMovementClassID | varchar(1) | INMovementClass | ||
Description:No description available | ||||
PendingMovementClassPeriodID | char(6) | - | ||
Description:No description available | ||||
PendingMovementClassUpdateDate | datetime2 | - | ||
Description:No description available | ||||
PendingStdCost | decimal | Pending Cost | - | |
Description:No description available | ||||
PendingStdCostDate | datetime2 | Pending Cost Date | - | |
Description:No description available | ||||
PendingStdCostReset | bit | - | ||
Description:No description available | ||||
PlanningMethod | char(1) | Planning Method | - | |
Description:No description available | ||||
POCreate | bit | Mark fo PO | - | |
Description:No description available | ||||
POSource | nvarchar(MAX) | - | ||
Description:No description available | ||||
PreferredVendorID | int | Preferred Vendor | Vendor | |
Description:No description available | ||||
PreferredVendorLocationID | int | Preferred Location | Location | |
Description:No description available | ||||
PreferredVendorOverride | bit | Override Preferred Vendor | - | |
Description:No description available | ||||
PriceManagerID | int | Price Manager | Contact | |
Description:No description available | ||||
PriceWorkgroupID | int | Price Workgroup | EPCompanyTree | |
Description:No description available | ||||
ProductManagerID | int | Product Manager | Contact | |
Description:No description available | ||||
ProductManagerOverride | bit | Override Product Manager | - | |
Description:No description available | ||||
ProductWorkgroupID | int | Product Workgroup | EPCompanyTree | |
Description:No description available | ||||
RecPrice | decimal | MSRP | - | |
Description:No description available | ||||
RecPriceOverride | bit | Override Price | - | |
Description:No description available | ||||
ReplenishmentClassID | nvarchar(10) | Replenishment Class | INReplenishmentClass | |
Description:No description available | ||||
ReplenishmentMethod | char(1) | Replenishment Method | - | |
Description:No description available | ||||
ReplenishmentPolicyID | nvarchar(10) | Seasonality | INReplenishmentPolicy | |
Description:No description available | ||||
ReplenishmentPolicyOverride | bit | Override Replenishment Settings | - | |
Description:No description available | ||||
ReplenishmentSource | char(1) | Replenishment Source | - | |
Description:No description available | ||||
ReplenishmentSourceSiteID | int | Replenishment Warehouse | INSite | |
Description:No description available | ||||
SafetyStock | decimal | Safety Stock | - | |
Description:No description available | ||||
SafetyStockOverride | bit | Override | - | |
Description:No description available | ||||
SafetyStockSuggested | decimal | Safety Stock Suggested | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
ServiceLevel | decimal | Service Level | - | |
Description:No description available | ||||
ServiceLevelOverride | bit | Override | - | |
Description:No description available | ||||
ServiceLevelPctNonexistent in DB | decimal | Service Level (%) | - | |
Description:No description available | ||||
SiteStatus | char(2) | Status | - | |
Description:No description available | ||||
StdCost | decimal | Current Cost | - | |
Description:No description available | ||||
StdCostDate | datetime2 | Effective Date | - | |
Description:No description available | ||||
StdCostOverride | bit | Override Std. Cost | - | |
Description:No description available | ||||
SubItemOverride | bit | Override | - | |
Description:No description available | ||||
TerminationDate | datetime2 | Termination Date | - | |
Description:No description available | ||||
TerminationDateOverride | bit | Override | - | |
Description:No description available | ||||
TransferERQ | decimal | Transfer ERQ | - | |
Description:No description available | ||||
TransferERQOverride | bit | Override | - | |
Description:No description available | ||||
TranUnitCost | decimal | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
ValMethod | char(1) | - | ||
Description:No description available | ||||