SV
SVOrderActual
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ActualCost | decimal | Actual Cost in Base Currency | - | |
Description:No description available | ||||
ActualQty | decimal | Actual Quantity | - | |
Description:No description available | ||||
BillableQty | decimal | Billable Quantity | - | |
Description:No description available | ||||
Billed | bit | Billed | - | |
Description:No description available | ||||
BilledAmt | decimal | Billed Amount in Base Currency | - | |
Description:No description available | ||||
BillingCategory | char(1) | Billing Category | - | |
Description:No description available | ||||
BillingStatus | char(1) | Billing Status | - | |
Description:No description available | ||||
BranchID | int | Branch | - | |
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 | ||||
CuryActualCost | decimal | Actual Cost | - | |
Description:No description available | ||||
CuryBilledAmt | decimal | Billed Amount | - | |
Description:No description available | ||||
CuryExtCost | decimal | Ext. Cost | - | |
Description:No description available | ||||
CuryExtPrice | decimal | Ext. Price | - | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryStdCost | decimal | Standard Cost | - | |
Description:No description available | ||||
CuryUnitCost | decimal | Unit Cost | - | |
Description:No description available | ||||
CuryUnitPrice | decimal | Unit Price | - | |
Description:No description available | ||||
CustomerID | int | Customer | 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 | Customer Location | - | |
Description:No description available | ||||
CustomerRefNbr | nvarchar(40) | Customer Order Nbr. | - | |
Description:No description available | ||||
Description | nvarchar(256) | Description | - | |
Description:No description available | ||||
EmployeeID | int | Employee ID | EPEmployee | |
Description:No description available | ||||
EmployeeNameNonexistent in DB | string | Employee Name | - | |
Description:No description available | ||||
ExpenseAcctID | int | Expense Account | Account | |
Description:No description available | ||||
ExpenseSubID | int | Expense Subaccount | Sub | |
Description:No description available | ||||
ExtCost | decimal | Ext. Cost in Base Currency | - | |
Description:No description available | ||||
ExtPrice | decimal | Ext. Price in Base Currency | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InvoiceLineNbr | int | Invoice Line Nbr. | - | |
Description:No description available | ||||
InvoiceNbr | nvarchar(15) | Invoice Nbr. | - | |
Description:No description available | ||||
InvoiceType | char(3) | Invoice Type | - | |
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 | ||||
LocationID | int | Warehouse Location | INLocation | |
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 | ||||
OrigDocType | char(1) | Orig. Doc. Type | - | |
Description:No description available | ||||
OrigNoteID | uniqueidentifier | Orig. Doc. Nbr. | - | |
Description:No description available | ||||
PriceRule | char(1) | Price Rule | - | |
Description:No description available | ||||
ProfitMarginPercentNonexistent in DB | decimal? | Profit Margin (%) | - | |
Description:No description available | ||||
SalesAcctID | int | Sales Account | Account | |
Description:No description available | ||||
SalesSubID | int | Subaccount | Sub | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SortOrder | int | - | ||
Description:No description available | ||||
StdCost | decimal | Standard Cost in Base Currency | - | |
Description:No description available | ||||
StkItemNonexistent in DB | bool? | - | ||
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TicketNbr | nvarchar(15) | Work Ticket Nbr. | SVTicket | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UnitCost | decimal | Unit Cost in Base Currency | - | |
Description:No description available | ||||
UnitPrice | decimal | Unit Price in Base Currency | - | |
Description:No description available | ||||
WorkDate | datetime | Work Date | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||