SO
SOSiteStatusSelected
PX.Objects.SO47 of 47 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
InventoryID | int | Inventory ID | - | |
Description:No description available | ||||
SiteCD | nvarchar(MAX) | - | ||
Description:No description available | ||||
SubItemCD | nvarchar(MAX) | - | ||
Description:No description available | ||||
AlternateDescr | nvarchar(60) | Alternate Description | - | |
Description:No description available | ||||
AlternateID | nvarchar(225) | Alternate ID | - | |
Description:No description available | ||||
AlternateType | varchar(4) | Alternate Type | - | |
Description:No description available | ||||
BarCode | nvarchar(255) | Barcode | - | |
Description:No description available | ||||
BarCodeDescr | nvarchar(60) | - | ||
Description:No description available | ||||
BarCodeType | varchar(4) | - | ||
Description:No description available | ||||
BaseUnit | nvarchar(6) | Base Unit | - | |
Description:No description available | ||||
BaseUnitPrice | decimal | - | ||
Description:No description available | ||||
CombinedSearchString | nvarchar(MAX) | - | ||
Description:No description available | ||||
CuryIDNonexistent in DB | nvarchar(5) | Currency | - | |
Description:No description available | ||||
CuryInfoIDNonexistent in DB | bigint | - | ||
Description:No description available | ||||
CuryUnitPriceNonexistent in DB | decimal | Last Unit Price | - | |
Description:No description available | ||||
Descr | nvarchar(256) | Description | - | |
Description:No description available | ||||
DropShipCuryUnitPriceNonexistent in DB | decimal | Unit Price of Last Drop Ship | - | |
Description:No description available | ||||
DropShipLastBaseQty | decimal | - | ||
Description:No description available | ||||
DropShipLastDate | datetime2 | Date of Last Drop Ship | - | |
Description:No description available | ||||
DropShipLastQty | decimal | Qty. of Last Drop Ship | - | |
Description:No description available | ||||
DropShipLastUnitPrice | decimal | - | ||
Description:No description available | ||||
InventoryAlternateDescr | varchar(4) | - | ||
Description:No description available | ||||
InventoryAlternateID | nvarchar(225) | - | ||
Description:No description available | ||||
InventoryAlternateType | varchar(4) | - | ||
Description:No description available | ||||
InventoryCD | nvarchar(MAX) | Inventory ID | - | |
Description:No description available | ||||
ItemClassCD | nvarchar(30) | - | ||
Description:No description available | ||||
ItemClassDescription | nvarchar(256) | Item Class Description | - | |
Description:No description available | ||||
ItemClassID | int | Item Class ID | INItemClass | |
Description:No description available | ||||
ItemStatus | char(2) | - | ||
Description:No description available | ||||
LastSalesDate | datetime2 | Last Sales Date | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
PreferredVendorDescription | nvarchar(250) | Preferred Vendor Name | - | |
Description:No description available | ||||
PreferredVendorID | int | Preferred Vendor ID | - | |
Description:No description available | ||||
PriceClassDescription | nvarchar(256) | Price Class Description | - | |
Description:No description available | ||||
PriceClassID | nvarchar(10) | Price Class ID | INPriceClass | |
Description:No description available | ||||
QtyAvail | decimal | Qty. Available | - | |
Description:No description available | ||||
QtyAvailSale | decimal | Qty. Available | - | |
Description:No description available | ||||
QtyLast | decimal | - | ||
Description:No description available | ||||
QtyLastSale | decimal | Qty. Last Sales | - | |
Description:No description available | ||||
QtyOnHand | decimal | Qty. On Hand | - | |
Description:No description available | ||||
QtyOnHandSale | decimal | Qty. On Hand | - | |
Description:No description available | ||||
QtySelectedNonexistent in DB | decimal | Qty. Selected | - | |
Description:No description available | ||||
Rank | int | - | ||
Description:No description available | ||||
SalesUnit | nvarchar(6) | Sales Unit | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | - | |
Description:No description available | ||||
SubItemID | int | Subitem | - | |
Description:No description available | ||||