Skip to main content
SO

SOShipLine

PX.Objects.SO
Field NameTypeDisplay NameForeign Key
LineNbr
intLine Nbr.-
Description:No description available
ShipmentNbr API
nvarchar(15)Shipment Nbr.-
Description:No description available
ShipmentType
char(1)SOShipment
Description:No description available
AlternateID
nvarchar(50)-
Description:No description available
BaseFullOpenQty
decimal(25, 6)-
Description:The back-ordered quantity of the related sales order line in the base unit of the item.
BaseFullOrderQty
decimal(25, 6)-
Description:No description available
BaseOriginalShippedQty
decimal(25, 6)-
Description:No description available
BaseOrigOrderQtyObsolete
decimal(25, 6)-
Description:No description available
BasePackedQty
decimal(25, 6)-
Description:No description available
BasePickedQty
decimal(25, 6)-
Description:No description available
BaseShippedQty
decimal(25, 6)Base Shipped Qty.-
Description:No description available
BlanketLineNbr
int-
Description:No description available
BlanketNbrDefault Navigation
nvarchar(15)Blanket SO Ref. Nbr.SOBlanketOrderLink
Description:No description available
BlanketSplitLineNbr
int-
Description:No description available
BlanketType
char(2)-
Description:No description available
CompleteQtyMin
decimal(9, 6)Undership Threshold (%)-
Description:No description available
Confirmed
bit-
Description:No description available
CostCenterID
intINLocationStatusByCostCenter
Description:No description available
CostCodeIDDefault Navigation
intCost CodePMCostCode
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime API
datetime-
Description:No description available
CustomerID API
intCustomer
Description:No description available
DiscountIDDefault Navigation
nvarchar(10)Discount CodeARDiscount
Description:No description available
DiscountSequenceID
nvarchar(10)Discount SequenceDiscountSequence
Description:No description available
DiscPct
decimal(19, 6)-
Description:No description available
ExpireDate
datetime2Expiration Date-
Description:No description available
ExtCost
decimal(19, 4)-
Description:No description available
ExtVolume
decimal(25, 6)-
Description:No description available
ExtWeight
decimal(25, 6)-
Description:No description available
FullOpenQty
decimal(25, 6)Open Order Qty.-
Description:The back-ordered quantity of the related sales order line in the units of the sales order line.
FullOrderQty
decimal(25, 6)Ordered Qty.-
Description:No description available
InventoryIDDefault Navigation
intInventory IDInventoryItem
Description:No description available
InvoiceGroupNbr
int-
Description:Number of the group of shipment lines referencing the same sales order line which are going to be invoiced together in the single invoice line.
InvtMult
smallintInventory Multiplier-
Description:No description available
IsFree
bitFree Item-
Description:No description available
IsIntercompany
bit-
Description:No description available
IsSpecialOrder
bit-
Description:No description available
IsStockItem
bitIs stock-
Description:No description available
IsUnassigned
bit-
Description:No description available
KeepManualFreightNonexistent in DB
bit-
Description:No description available
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime API
datetime-
Description:No description available
LineAmtNonexistent in DB
decimal-
Description:No description available
LineType
char(2)-
Description:No description available
LocationID API Default Navigation
intLocationINLocation
Description:No description available
LotSerialNbrDefault Navigation
nvarchar(100)Lot/Serial Nbr.INLotSerialStatus
Description:No description available
ManualDisc
bitManual Cash Discount-
Description:No description available
ManualPrice
bit-
Description:No description available
NoteID API
uniqueidentifier-
Description:No description available
OpenOrderQtyNonexistent in DBObsolete
decimalOpen Qty.-
Description:No description available
Operation API Default Navigation
char(1)SOOrderTypeOperation
Description:No description available
OrderUOM
nvarchar(6)-
Description:No description available
OriginalShippedQtyNonexistent in DB
decimalOriginal Qty.-
Description:No description available
OrigLineNbr
intOrder Line Nbr.SOLine
Description:No description available
OrigOrderNbrDefault Navigation
nvarchar(15)Order Nbr.SOOrder
Description:No description available
OrigOrderQtyObsolete
decimal(25, 6)-
Description:No description available
OrigOrderType
char(2)Order TypeSOOrderType
Description:No description available
OrigPlanTypeDefault Navigation
char(2)INPlanType
Description:No description available
OrigSplitLineNbr
intSplit Line Nbr.SOLineSplit
Description:No description available
PackedQty
decimal(25, 6)Packed Qty.-
Description:No description available
PickedQty
decimal(25, 6)Picked Qty.-
Description:No description available
PlanType
char(2)INPlanType
Description:No description available
ProjectID
intPMProject
Description:No description available
ReasonCodeDefault Navigation
nvarchar(20)Reason CodeReasonCode
Description:No description available
Released
bit-
Description:No description available
RequireINUpdate
bit-
Description:No description available
ShipComplete
char(1)Shipping Rule-
Description:No description available
ShipDate
datetime2-
Description:No description available
ShippedQty API
decimal(25, 6)Shipped Qty.-
Description:No description available
SiteIDDefault Navigation
intWarehouseINSite
Description:No description available
SOLineSign
smallint-
Description:No description available
SortOrder
int-
Description:No description available
SubItemIDDefault Navigation
intSubitemINSubItem
Description:No description available
TaskID
intPMTask
Description:No description available
TranDesc
nvarchar(256)Description-
Description:No description available
TranTypeNonexistent in DB
nchar(3)-
Description:No description available
tstamp
timestamp-
Description:No description available
UnassignedQty
decimal(25, 6)Unassigned Qty.-
Description:No description available
UnitCost
decimal(19, 6)-
Description:No description available
UnitPrice
decimal(19, 6)-
Description:No description available
UnitVolume
decimal(19, 6)-
Description:No description available
UnitWeigth
decimal(19, 6)Unit Weight-
Description:No description available
UOMDefault Navigation
nvarchar(6)UOMINUnit
Description:No description available