IN
INItemSite
PX.Objects.IN.S69 of 69 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 | ||||
BasePrice | decimal(19, 6) | 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 | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
DfltPurchaseUnit | nvarchar(6) | Purchase Unit | INUnit | |
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 | ||||
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(19, 6) | Last Price | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LastStdCost | decimal(19, 6) | Last Cost | - | |
Description:No description available | ||||
LaunchDate | datetime | Launch Date | - | |
Description:No description available | ||||
LaunchDateOverride | bit | Override | - | |
Description:No description available | ||||
MarkupPct | decimal(19, 6) | Markup % | - | |
Description:No description available | ||||
MarkupPctOverride | bit | Markup % Override | - | |
Description:No description available | ||||
MaxQty | decimal(16, 9) | Max Qty. | - | |
Description:No description available | ||||
MaxQtyOverride | bit | Override | - | |
Description:No description available | ||||
MaxShelfLife | int | Max. Shelf Life (Days) | - | |
Description:No description available | ||||
MaxShelfLifeOverride | bit | Override | - | |
Description:No description available | ||||
MinQty | decimal(16, 9) | Reorder Point | - | |
Description:No description available | ||||
MinQtyOverride | bit | Override | - | |
Description:No description available | ||||
MovementClassID | nvarchar(10) | Movement Class | INMovementClass | |
Description:No description available | ||||
MovementClassIsFixed | bit | Fixed Movement Class | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
PendingBasePrice | decimal(19, 6) | Pending Price | - | |
Description:No description available | ||||
PendingBasePriceDate | datetime2 | Pending Price Date | - | |
Description:No description available | ||||
PendingStdCost | decimal(19, 6) | Pending Cost | - | |
Description:No description available | ||||
PendingStdCostDate | datetime2 | Pending Cost Date | - | |
Description:No description available | ||||
PlanningMethod | char(1) | Planning Method | - | |
Description:No description available | ||||
POCreate | bit | - | ||
Description:No description available | ||||
PreferredVendorID | int | Preferred Vendor | Vendor | |
Description:No description available | ||||
PreferredVendorLocationID | int | Preferred Location | Location | |
Description:No description available | ||||
PreferredVendorOverride | bit | Preferred Vendor Override | - | |
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 | ||||
ProductWorkgroupID | int | Product Workgroup | EPCompanyTree | |
Description:No description available | ||||
RecPrice | decimal(19, 6) | MSRP | - | |
Description:No description available | ||||
RecPriceOverride | bit | Price Override | - | |
Description:No description available | ||||
ReplenishmentMethod | char(1) | Replenishment Method | - | |
Description:No description available | ||||
ReplenishmentPolicyID | nvarchar(10) | Seasonality | INReplenishmentPolicy | |
Description:No description available | ||||
ReplenishmentPolicyOverride | bit | Replenishment Policy Override | - | |
Description:No description available | ||||
ReplenishmentSource | char(1) | Replenishment Source | - | |
Description:No description available | ||||
ReplenishmentSourceSiteID | int | Replenishment Warehouse | INSite | |
Description:No description available | ||||
SafetyStock | decimal(16, 9) | Safety Stock | - | |
Description:No description available | ||||
SafetyStockOverride | bit | Override | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SiteStatus | char(2) | Status | - | |
Description:No description available | ||||
StdCost | decimal(19, 6) | Current Cost | - | |
Description:No description available | ||||
StdCostDate | datetime2 | Effective Date | - | |
Description:No description available | ||||
StdCostOverride | bit | Std. Cost Override | - | |
Description:No description available | ||||
TerminationDate | datetime | Termination Date | - | |
Description:No description available | ||||
TerminationDateOverride | bit | Override | - | |
Description:No description available | ||||
TransferERQ | decimal(16, 9) | Transfer ERQ | - | |
Description:No description available | ||||
TransferERQOverride | bit | Override | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
ValMethod | char(1) | - | ||
Description:No description available | ||||