SV
SVOrderDetail
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AcctID | int | Account | Account | |
Description:No description available | ||||
Amount | decimal | - | ||
Description:No description available | ||||
BaseEstimatedQty | decimal | - | ||
Description:No description available | ||||
BillingCategory | char(1) | Billing Category | - | |
Description:No description available | ||||
BranchID | int | Branch | - | |
Description:No description available | ||||
CostCodeID | int | Cost Code | PMCostCode | |
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 | ||||
CuryAmount | decimal | Amount | - | |
Description:No description available | ||||
CuryDiscAmt | decimal | Discount Amount | - | |
Description:No description available | ||||
CuryExtCost | decimal | Estimated Ext. Cost | - | |
Description:No description available | ||||
CuryExtPrice | decimal | Estimated Ext. Price | - | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryTaxAmt | decimal | Tax Amount | - | |
Description:No description available | ||||
CuryUnitCost | decimal | Estimated Unit Cost | - | |
Description:No description available | ||||
CuryUnitPrice | decimal | Unit Price | - | |
Description:No description available | ||||
CustomerID | int | Customer | ||
Description:The identifier of the customer of the original work order. The field is included in the FK.Customer foreign key. The field is a part of the identifier of the reason code AR.Customer.Customer.bAccountID. | ||||
CustomerLocationID | int | Location | Location | |
Description:No description available | ||||
DiscAmt | decimal | - | ||
Description:No description available | ||||
DiscPct | decimal | Discount, % | - | |
Description:No description available | ||||
DiscountID | nvarchar(10) | Discount Code | ARDiscount | |
Description:No description available | ||||
DiscountSequenceID | nvarchar(10) | Discount Sequence | - | |
Description:No description available | ||||
DiscountsAppliedToLine | varbinary | - | ||
Description:No description available | ||||
DocumentDiscountRate | decimal | - | ||
Description:No description available | ||||
EstimatedDuration | int | Estimated Duration | - | |
Description:No description available | ||||
EstimatedQty | decimal | Estimated Quantity | - | |
Description:No description available | ||||
ExtCost | decimal | - | ||
Description:No description available | ||||
ExtPrice | decimal | - | ||
Description:No description available | ||||
FreezeManualDiscNonexistent in DB | bool? | - | ||
Description:No description available | ||||
GroupDiscountRate | decimal | - | ||
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsFree | bit | Free Item | - | |
Description:No description available | ||||
IsUseMarkup | bit | Use Markup | - | |
Description:No description available | ||||
ItemType | char(1) | Item Type | - | |
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 | ||||
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
ManualDisc | bit | Manual Discount | - | |
Description:No description available | ||||
ManualMarkup | bit | Manual Markup | - | |
Description:No description available | ||||
ManualPrice | bit | Manual Price | - | |
Description:No description available | ||||
MarkupPct | decimal | Markup, % | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrderNbr | nvarchar(15) | Order Nbr. | SVOrder | |
Description:No description available | ||||
PriceRule | char(1) | Price Rule | - | |
Description:No description available | ||||
ProjectID | int | PMProject | ||
Description:No description available | ||||
ProjectTaskID | int | Project Task | PMTask | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SkipDiscNonexistent in DB | bool? | - | ||
Description:No description available | ||||
SkipLineDiscounts | bit | Ignore Automatic Line Discounts | - | |
Description:Indicates (if selected) that the automatic line discounts are not applied to this line. | ||||
SortOrder | int | Sort Order | - | |
Description:No description available | ||||
StkItemNonexistent in DB | bool? | - | ||
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
TaxAmt | decimal | Tax Amount | - | |
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TranDesc | nvarchar(256) | Description | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UnitCost | decimal | - | ||
Description:No description available | ||||
UnitPrice | decimal | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||