Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Search Engine

Here you can search through the pages of this Namespace, their attachments and the files uploaded to the system.
Note: the results will only display the items you have permissions to read.



Filter by Category


This search, performed through 2.14 MB (338 documents, 3448 words), completed in 0.0 seconds and yielded 4 results.

Purchasing PurchaseOrderDetail (table) — 34.8%

[...] number per purchased product. DueDate datetime not null Date the product is expected to be received. OrderQty smallint not null Quantity ordered. ProductID int not null Product identification number. Foreign key to Product.ProductID. UnitPrice money not null Vendor's selling price of a single product. LineTotal Per product subtotal. Computed as OrderQty * UnitPrice. ReceivedQty decimal(8, 2) not null Quantity actually received from the vendor. RejectedQty decimal(8, 2) not null Quantity rejected during inspection. StockedQty [...]

Sales SalesOrderDetail (table) — 30.4%

[...] sold. CarrierTrackingNumber nvarchar(25) null Shipment tracking number supplied by the shipper. OrderQty smallint not null Quantity ordered per product. ProductID int not null Product sold to customer. Foreign key to Product.ProductID. SpecialOfferID int not null Promotional code. Foreign key to SpecialOffer.SpecialOfferID. UnitPrice money not null Selling price of a single product. UnitPriceDiscount money not null ((0.0)) Discount amount. LineTotal Per product subtotal. Computed as UnitPrice * (1 - UnitPriceDiscount) * OrderQty. [...]

Production WorkOrder (table) — 30.4%

[...] records. ProductID int not null Product identification number. Foreign key to Product.ProductID. OrderQty int not null Product quantity to build. StockedQty Quantity built and put in inventory. ScrappedQty smallint not null Quantity that failed inspection. StartDate datetime not null Work order start date. EndDate datetime null Work order end date. DueDate datetime not null Work order due date. ScrapReasonID smallint null Reason for inspection failure. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. [...]

WikiMarkup — 4.3%

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

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.