Navigation¶

• Main Page
  

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

• Administration
• File Management
  

• Create Account
  

Search the wiki
»

Search in all Namespaces and all Categories
Search Files and Attachments

Filter by Category

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

Purchasing PurchaseOrderDetail (table) — 11.3%

[...] 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 ShoppingCartItem (table) — 9.4%

[...] ShoppingCartItem records. ShoppingCartID nvarchar(50) not null Shopping cart identification number. Quantity int not null ((1)) Product quantity ordered. ProductID int not null Product ordered. Foreign key to Product.ProductID. DateCreated datetime not null (getdate()) Date the time the record was created. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_ShoppingCartItem_ShoppingCartItemID ShoppingCartItemID Indexes Index Type Columns IX_ShoppingCartItem_ShoppingCartID_ProductID [...]

Production WorkOrder (table) — 9.4%

[...] 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 [...]

Purchasing ProductVendor (table) — 5.7%

[...] datetime null Date the product was last received by the vendor. MinOrderQty int not null The maximum quantity that should be ordered. MaxOrderQty int not null The minimum quantity that should be [...]

SH SALES (table) — 5.7%

[...] null promotion identifier, without FK constraint (intentionally) to show outer join optimization QUANTITY_SOLD NUMBER(10, 2) not null product quantity sold with the transaction AMOUNT_SOLD NUMBER(10, 2) not null invoiced amount to the customer Indexes Index Type Columns SALES_CHANNEL_BIX CHANNEL_ID SALES_CUST_BIX CUST_ID SALES_PROD_BIX PROD_ID SALES_PROMO_BIX PROMO_ID SALES_TIME_BIX TIME_ID Check Constraints Check Constraint Expression Description SYS_C005075 "PROD_ID" IS NOT NULL SYS_C005076 "CUST_ID" [...]

SH PROFITS (view) — 3.8%

[...] s.prod_id, s.promo_id, s.time_id, c.unit_cost, c.unit_price, s.amount_sold, s.quantity_sold, c.unit_cost * s.quantity_sold [...]

Sales SalesOrderDetail (table) — 3.8%

[...] 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. rowguid uniqueidentifier not null (newid()) [...]

OE INVENTORIES (table) — 3.8%

[...] WAREHOUSE_ID NUMBER(3, 0) not null Part of concatenated primary key, references warehouses.warehouse_id. QUANTITY_ON_HAND NUMBER(8, 0) not null Primary Key Primary Key Columns INVENTORY_IX WAREHOUSE_ID, PRODUCT_ID Indexes Index Type Columns INV_PRODUCT_IX PRODUCT_ID Check Constraints Check Constraint Expression Description INVENTORY_QOH_NN "QUANTITY_ON_HAND" [...]

Production BillOfMaterials (table) — 3.8%

[...] assembly item. UnitMeasureCode nchar(3) not null Standard code identifying the unit of measure for the quantity. BOMLevel smallint not null Indicates the depth the component is from its parent (AssemblyID). PerAssemblyQty decimal(8, 2) not null ((1.00)) Quantity [...]

dbo ufnGetStock (function) — 3.8%

wikibot Function dbo.ufnGetStock Description Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID. Source CREATE FUNCTION [dbo].[ufnGetStock](@ProductID [int]) RETURNS [int] AS -- Returns the stock level for the product. This function is used internally only BEGIN DECLARE @ret int; SELECT @ret = SUM(p.[Quantity]) [...]

Production ProductInventory (table) — 3.8%

[...] inventory location. Bin tinyint not null Storage container on a shelf in an inventory location. Quantity smallint not null ((0)) Quantity [...]

Production TransactionHistory (table) — 3.8%

[...] transaction. TransactionType nchar(1) not null W = WorkOrder, S = SalesOrder, P = PurchaseOrder Quantity int not null Product quantity. [...]

Production TransactionHistoryArchive (table) — 3.8%

[...] transaction. TransactionType nchar(1) not null W = Work Order, S = Sales Order, P = Purchase Order Quantity int not null Product quantity. [...]

OE TORONTO_INVENTORY (view) — 1.9%

[...] CREATE OR REPLACE VIEW OE.TORONTO_INVENTORY AS SELECT p.product_id , p.product_name , i.quantity_on_hand FROM inventories i , warehouses [...]

OE SYDNEY_INVENTORY (view) — 1.9%

[...] Source CREATE OR REPLACE VIEW OE.SYDNEY_INVENTORY AS SELECT p.product_id , p.product_name , i.quantity_on_hand FROM inventories i , warehouses [...]

OE ORDER_ITEMS (table) — 1.9%

[...] NUMBER(6, 0) not null References product_information.product_id. UNIT_PRICE NUMBER(8, 2) null QUANTITY NUMBER(8, 0) null Primary Key Primary [...]

WikiMarkup — 1.9%

[...] DueDate Bonus CommissionPct SalesLastYear SalesQuota SalesYTD TaxType CostLastYear CostYTD Quantity DiscountPct MaxQty MinQty AdminSnippets [...]

SH SALES_TRANSACTIONS_EXT (table) — 1.9%

[...] CUST_ID NUMBER null TIME_ID DATE(7) null CHANNEL_ID NUMBER null PROMO_ID NUMBER null QUANTITY_SOLD NUMBER null AMOUNT_SOLD NUMBER(10, [...]

OE XDBPO_PART_TYPE (type) — 1.9%

[...] TYPE "XDBPO_PART_TYPE" AS OBJECT ("SYS_XDBPD$" "XDB"."XDB$RAW_LIST_T","PARTNO" VARCHAR2(14 CHAR),"Quantity" NUMBER(12,2),"UNITPRICE" NUMBER(8,4))FINAL [...]

OE ORDER_ITEM_TYP (type) — 1.9%

[...] OBJECT ( order_id NUMBER(12) , line_item_id NUMBER(3) , unit_price NUMBER(8,2) , quantity NUMBER(8) , product_ref REF product_information_typ [...]

OE INVENTORY_TYP (type) — 1.9%

[...] AS OBJECT ( product_id NUMBER(6) , warehouse warehouse_typ , quantity_on_hand NUMBER(8) ) ;

OE OC_CORPORATE_CUSTOMERS (view) — 1.9%

[...] CAST(MULTISET(SELECT l.order_id,l.line_item_id, l.unit_price,l.quantity, make_ref(oc_product_information, [...]

Production Product (table) — 1.9%

[...] salable. Color nvarchar(15) null Product color. SafetyStockLevel smallint not null Minimum inventory quantity. ReorderPoint smallint not null Inventory [...]

OE BOMBAY_INVENTORY (view) — 1.9%

[...] Source CREATE OR REPLACE VIEW OE.BOMBAY_INVENTORY AS SELECT p.product_id , p.product_name , i.quantity_on_hand FROM inventories i , warehouses [...]

OE OC_ORDERS (view) — 1.9%

[...] o.order_status,o.order_total,o.sales_rep_id, CAST(MULTISET(SELECT l.order_id,l.line_item_id,l.unit_price,l.quantity, make_ref(oc_product_information,l.product_id) [...]

OE OC_PRODUCT_INFORMATION (view) — 1.9%

[...] p.list_price, p.min_price, p.catalog_url, CAST(MULTISET(SELECT i.product_id,i.warehouse,i.quantity_on_hand FROM oc_inventories [...]

OE OC_CUSTOMERS (view) — 1.9%

[...] CAST(MULTISET(SELECT l.order_id,l.line_item_id, l.unit_price,l.quantity, MAKE_REF(oc_product_information, [...]

OE OC_INVENTORIES (view) — 1.9%

[...] SELECT i.product_id, warehouse_typ(w.warehouse_id, w.warehouse_name, w.location_id), i.quantity_on_hand FROM inventories i, warehouses [...]