Navigation¶

• Main Page
  

• Random Page
• Create a new Page
• All Pages
• Categories
• Navigation Paths
  

• Administration
• File Management
  

• Create Account
  

Filter by Category

Production WorkOrderRouting (table) — 36.4%

[...] Number of manufacturing hours used. PlannedCost money not null Estimated manufacturing cost. ActualCost money null Actual manufacturing cost. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence WorkOrderID, ProductID, OperationSequence Indexes Index Type Columns IX_WorkOrderRouting_ProductID ProductID Check Constraints Check Constraint Expression Description CK_WorkOrderRouting_ActualCost [...]

Purchasing PurchaseOrderDetail (table) — 18.2%

[...] ,[ReferenceOrderLineID] ,[TransactionType] ,[TransactionDate] ,[Quantity] ,[ActualCost]) SELECT inserted.[ProductID] ,inserted.[PurchaseOrderID] ,inserted.[PurchaseOrderDetailID] ,'P' ,GETDATE() ,inserted.[OrderQty] ,inserted.[UnitPrice] FROM inserted INNER JOIN [Purchasing].[PurchaseOrderHeader] ON inserted.[PurchaseOrderID] = [Purchasing].[PurchaseOrderHeader].[PurchaseOrderID]; -- Update SubTotal in PurchaseOrderHeader record. Note that this causes the [...]

WikiMarkup — 9.1%

[...] SellStartDate StandardCost Style Weight A-Za-z Bin Shelf Rating TransactionType OrderQty ScrappedQty ActualCost ActualEndDate ActualResourceHrs ActualStartDate [...]

Sales SalesOrderDetail (table) — 9.1%

[...] ,[ReferenceOrderLineID] ,[TransactionType] ,[TransactionDate] ,[Quantity] ,[ActualCost]) SELECT inserted.[ProductID] [...]

Production TransactionHistoryArchive (table) — 9.1%

[...] null W = Work Order, S = Sales Order, P = Purchase Order Quantity int not null Product quantity. ActualCost money not null Product cost. ModifiedDate [...]

Production WorkOrder (table) — 9.1%

[...] ,[ReferenceOrderID] ,[TransactionType] ,[TransactionDate] ,[Quantity] ,[ActualCost]) SELECT inserted.[ProductID] [...]

Production TransactionHistory (table) — 9.1%

[...] null W = WorkOrder, S = SalesOrder, P = PurchaseOrder Quantity int not null Product quantity. ActualCost money not null Product cost. ModifiedDate [...]