SO
SOLine4
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BaseOpenQty | decimal | Base Open Qty. | - | |
Description:No description available | ||||
BaseOrderQty | decimal | - | ||
Description:No description available | ||||
BaseShippedQty | decimal | - | ||
Description:No description available | ||||
BaseUnbilledQty | decimal | - | ||
Description:No description available | ||||
BlanketLineNbr | int | - | ||
Description:The blanket line number of the blanket sales order from which the child order has been generated. The field is included in the following foreign keys: - FK.BlanketLine. The field is a part of the identifier of the blanket sales order line BlanketSOLine.BlanketSOLine.lineNbr - FK.BlanketSplit. The field is a part of the identifier of the blanket sales order split line BlanketSOLineSplit.BlanketSOLineSplit.lineNbr | ||||
BlanketNbr | nvarchar(15) | - | ||
Description:The reference number of the blanket sales order from which the child order has been generated. The field is included in the following foreign keys: - FK.BlanketOrder. The field is a part of the identifier of the blanket sales order BlanketSOOrder.BlanketSOOrder.orderNbr - FK.BlanketLine. The field is a part of the identifier of the blanket sales order line BlanketSOLine.BlanketSOLine.orderNbr - FK.BlanketSplit. The field is a part of the identifier of the blanket sales order split line BlanketSOLineSplit.BlanketSOLineSplit.orderNbr - FK.BlanketOrderLink. The field is a part of the identifier of the blanket sales order link SOBlanketOrderLink.SOBlanketOrderLink.blanketNbr | ||||
BlanketSplitLineNbr | int | - | ||
Description:The blanket split line number of the blanket sales order from which the child order has been generated. The field is included in the FK.BlanketSplit foreign key. The field is a part of the identifier of the blanket sales order split line BlanketSOLineSplit.BlanketSOLineSplit.lineNbr. | ||||
BlanketType | char(2) | - | ||
Description:The order type of the blanket sales order from which the child order has been generated. The field is included in the following foreign keys: - FK.BlanketOrder. The field is a part of the identifier of the blanket sales order BlanketSOOrder.BlanketSOOrder.orderType - FK.BlanketLine. The field is a part of the identifier of the blanket sales order line BlanketSOLine.BlanketSOLine.orderType - FK.BlanketSplit. The field is a part of the identifier of the blanket sales order split line BlanketSOLineSplit.BlanketSOLineSplit.orderType - FK.BlanketOrderLink. The field is a part of the identifier of the blanket sales order link SOBlanketOrderLink.SOBlanketOrderLink.blanketType | ||||
BranchID | int | - | ||
Description:No description available | ||||
CompleteQtyMax | decimal | - | ||
Description:No description available | ||||
CompleteQtyMin | decimal | - | ||
Description:No description available | ||||
Completed | bit | - | ||
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryOpenAmt | decimal | Open Amount | - | |
Description:No description available | ||||
CuryUnbilledAmt | decimal | - | ||
Description:No description available | ||||
CuryUnitPrice | decimal | - | ||
Description:No description available | ||||
DiscPct | decimal | - | ||
Description:No description available | ||||
DocumentDiscountRate | decimal | - | ||
Description:No description available | ||||
GroupDiscountRate | decimal | - | ||
Description:No description available | ||||
InventoryID | int | - | ||
Description:No description available | ||||
LineAmt | decimal | - | ||
Description:No description available | ||||
LineNbr | int | - | ||
Description:No description available | ||||
LineSign | smallint | - | ||
Description:No description available | ||||
OpenAmt | decimal | - | ||
Description:No description available | ||||
OpenLine | bit | - | ||
Description:No description available | ||||
OpenQty | decimal | - | ||
Description:No description available | ||||
Operation | char(1) | Operation | - | |
Description:No description available | ||||
OrderNbr | nvarchar(15) | SOOrder | ||
Description:No description available | ||||
OrderQty | decimal | - | ||
Description:No description available | ||||
OrderType | char(2) | SOOrder | ||
Description:No description available | ||||
POCreate | bit | - | ||
Description:No description available | ||||
POSource | nvarchar | - | ||
Description:No description available | ||||
ProjectID | int | - | ||
Description:No description available | ||||
SalesAcctID | int | - | ||
Description:No description available | ||||
ShipComplete | char(1) | - | ||
Description:No description available | ||||
ShipDate | datetime | - | ||
Description:No description available | ||||
ShippedQty | decimal | - | ||
Description:No description available | ||||
SiteID | int | SOOrderSite | ||
Description:The identifier of the warehouse from which the specified quantity of the Inventory Item should be delivered. The field is included in the following foreign keys: - FK.Site. The field is identifier of the Warehouse INSite.INSite.siteID - FK.SiteStatus. The field is a part of the identifier of the Warehouse inventory item status INSiteStatus.INSiteStatus.siteID - FK.LocationStatus. The field is a part of the identifier of the Location inventory item status INLocationStatus.INLocationStatus.siteID - FK.LotSerialStatus. The field is a part of the identifier of the Location inventory item status by Lot Serial numbers INLotSerialStatus.INLotSerialStatus.siteID This field is available only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form. | ||||
SortOrder | int | - | ||
Description:No description available | ||||
TaskID | int | - | ||
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UnbilledAmt | decimal | - | ||
Description:No description available | ||||
UnbilledQty | decimal | - | ||
Description:No description available | ||||
UnitPrice | decimal | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||