Skip to main content
IN

InventoryItemCurySettings

PX.Objects.IN
Field NameTypeDisplay NameForeign Key
CuryIDDefault Navigation
nvarchar(10)CurrencyCurrency
Description:No description available
InventoryID
intInventory IDInventoryItem
Description:No description available
BasePrice
decimal(19, 6)Default Price-
Description:The price used as the default price, if there are no other prices defined for this item in any price list in the Accounts Receivable module.
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetimeCreated On-
Description:No description available
DfltPutawayLocationIDDefault Navigation
intDefault Putaway ToINLocation
Description:No description available
DfltReceiptLocationIDDefault Navigation
intDefault Receipt ToINLocation
Description:The Location of warehouse used by default to receive items of this kind. Applicable only for Stock Items (see InventoryItem.StkItem) when the Warehouse Locations feature is enabled. Corresponds to the INLocation.LocationID field.
DfltShipLocationIDDefault Navigation
intDefault Issue FromINLocation
Description:The Location of warehouse used by default to issue items of this kind. Applicable only for Stock Items (see InventoryItem.StkItem) when the Warehouse Locations feature is enabled. Corresponds to the INLocation.LocationID field.
DfltSiteIDDefault Navigation
intDefault WarehouseINSite
Description:The default Warehouse used to store the items of this kind. Applicable only for Stock Items (see InventoryItem.StkItem) and when the Warehouses feature is enabled. Corresponds to the INSite.SiteID field. Defaults to the Default Warehouse specified for the Class of the item.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetimeLast Modified On-
Description:No description available
LastStdCost
decimal(19, 6)Last Cost-
Description:The standard cost assigned to the item before the current standard cost was set.
PendingStdCost
decimal(19, 6)Pending Cost-
Description:The standard cost to be assigned to the item when the costs are updated.
PendingStdCostDate
datetime2Pending Cost Date-
Description:The date when the Pending Cost becomes effective.
PreferredVendorIDDefault Navigation
intPreferred VendorVendor
Description:Preferred (default) Vendor for purchases of this item. Corresponds to the BAccount.BAccountID field.
PreferredVendorLocationIDDefault Navigation
intPreferred LocationLocation
Description:The Location of the Preferred (default) Vendor. Corresponds to the Location.LocationID field.
RecPrice
decimal(19, 6)MSRP-
Description:The manufacturer's suggested retail price of the item.
StdCost
decimal(19, 6)Current Cost-
Description:The current standard cost of the item.
StdCostDate
datetime2Effective Date-
Description:The date when the Current Cost became effective.
tstamp
timestamp-
Description:No description available