Latest revision |
Your text |
Line 2: |
Line 2: |
| | | |
| {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
− | |- valign="top" | + | |- |
| | '''Table | | | '''Table |
| | Purchasing.ProductVendor | | | Purchasing.ProductVendor |
− | |- valign="top" | + | |- |
− | | '''Description
| |
− | | Cross-reference table mapping vendors with the products they supply.
| |
| |} | | |} |
| | | |
− | === Columns ===
| + | |
| {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
| |- style="background:silver" | | |- style="background:silver" |
Line 17: |
Line 15: |
| | '''Nullable | | | '''Nullable |
| | '''Default | | | '''Default |
− | | '''Description | + | | '''PK |
− | | + | | '''Index |
− | |- valign="top" | + | |
| + | |- |
| | ProductID | | | ProductID |
| | int | | | int |
| | not null | | | not null |
| | | | | |
− | | Primary key. Foreign key to Product.ProductID. | + | | PK_ProductVendor_ProductID_VendorID |
− | |- valign="top" | + | | |
| + | |- |
| | VendorID | | | VendorID |
| | int | | | int |
| | not null | | | not null |
| | | | | |
− | | Primary key. Foreign key to Vendor.VendorID. | + | | PK_ProductVendor_ProductID_VendorID |
− | |- valign="top" | + | | IX_ProductVendor_VendorID |
| + | |- |
| | AverageLeadTime | | | AverageLeadTime |
| | int | | | int |
| | not null | | | not null |
| | | | | |
− | | The average span of time (in days) between placing an order with the vendor and receiving the purchased product. | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | StandardPrice | | | StandardPrice |
| | money | | | money |
| | not null | | | not null |
| | | | | |
− | | The vendor's usual selling price. | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | LastReceiptCost | | | LastReceiptCost |
| | money | | | money |
| | null | | | null |
| | | | | |
− | | The selling price when last purchased. | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | LastReceiptDate | | | LastReceiptDate |
| | datetime | | | datetime |
| | null | | | null |
| | | | | |
− | | Date the product was last received by the vendor.
| |
− | |- valign="top"
| |
− | | MinOrderQty
| |
− | | int
| |
− | | not null
| |
| | | | | |
− | | The maximum quantity that should be ordered.
| |
− | |- valign="top"
| |
− | | MaxOrderQty
| |
− | | int
| |
− | | not null
| |
| | | | | |
− | | The minimum quantity that should be ordered.
| + | |- |
− | |- valign="top" | + | | MinOrderQty |
− | | OnOrderQty | |
| | int | | | int |
− | | null
| |
− | |
| |
− | | The quantity currently on order.
| |
− | |- valign="top"
| |
− | | UnitMeasureCode
| |
− | | nchar(3)
| |
| | not null | | | not null |
| | | | | |
− | | The product's unit of measure.
| |
− | |- valign="top"
| |
− | | ModifiedDate
| |
− | | datetime
| |
− | | not null
| |
− | | (getdate())
| |
− | | Date and time the record was last updated.
| |
− | |}
| |
− |
| |
− | === Primary Key ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Primary Key
| |
− | | '''Columns
| |
− | |- valign="top"
| |
− | | PK_ProductVendor_ProductID_VendorID
| |
− | | ProductID, VendorID
| |
− | |}
| |
− |
| |
− | === Indexes ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Index
| |
− | | '''Type
| |
− | | '''Columns
| |
− |
| |
− | |- valign="top"
| |
− | | IX_ProductVendor_UnitMeasureCode
| |
| | | | | |
− | | UnitMeasureCode
| |
− | |- valign="top"
| |
− | | IX_ProductVendor_VendorID
| |
| | | | | |
− | | VendorID
| |
− | |}
| |
− |
| |
− | === Check Constraints ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Check Constraint
| |
− | | '''Expression
| |
− | | '''Description
| |
− |
| |
− | |- valign="top"
| |
− | | CK_ProductVendor_AverageLeadTime
| |
− | | ([AverageLeadTime]>=(1))
| |
− | | Check constraint [AverageLeadTime] >= (1)
| |
− | |- valign="top"
| |
− | | CK_ProductVendor_LastReceiptCost
| |
− | | ([LastReceiptCost]>(0.00))
| |
− | | Check constraint [LastReceiptCost] > (0.00)
| |
− | |- valign="top"
| |
− | | CK_ProductVendor_MaxOrderQty
| |
− | | ([MaxOrderQty]>=(1))
| |
− | | Check constraint [MaxOrderQty] >= (1)
| |
− | |- valign="top"
| |
− | | CK_ProductVendor_MinOrderQty
| |
− | | ([MinOrderQty]>=(1))
| |
− | | Check constraint [MinOrderQty] >= (1)
| |
− | |- valign="top"
| |
− | | CK_ProductVendor_OnOrderQty
| |
− | | ([OnOrderQty]>=(0))
| |
− | | Check constraint [OnOrderQty] >= (0)
| |
− | |- valign="top"
| |
− | | CK_ProductVendor_StandardPrice
| |
− | | ([StandardPrice]>(0.00))
| |
− | | Check constraint [StandardPrice] > (0.00)
| |
− | |}
| |
− |
| |
− | === Foreign Keys ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Relation
| |
− | | '''Column
| |
− | | '''Referenced Column
| |
− |
| |
− | |- valign="top"
| |
− | | [[Production.Product_(table)|Production.Product]]
| |
− | | ProductID
| |
− | | ProductID
| |
− | |- valign="top"
| |
− | | [[Production.UnitMeasure_(table)|Production.UnitMeasure]]
| |
− | | UnitMeasureCode
| |
− | | UnitMeasureCode
| |
− | |- valign="top"
| |
− | | [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
| |
− | | VendorID
| |
− | | VendorID
| |
− | |}
| |
− |
| |
− | === References ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Dependency Type
| |
− | | '''Object Type
| |
− | | '''Referenced Object
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Schema
| |
− | | [[Purchasing_(schema)|Purchasing]]
| |
− |
| |
− | |}
| |
− |
| |
− |
| |
− | == automatically generated ==
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| |- | | |- |
− | | '''Table | + | | MaxOrderQty |
− | | Purchasing.ProductVendor
| |
− | |- valign="top"
| |
− | | '''Description
| |
− | | Cross-reference table mapping vendors with the products they supply.
| |
− | |-
| |
− | |}
| |
− | | |
− | | |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Column
| |
− | | '''Data Type
| |
− | | '''Nullable
| |
− | | '''Default
| |
− | | '''Description / PK / Index
| |
− |
| |
− | |- valign="top"
| |
− | | ProductID
| |
| | int | | | int |
| | not null | | | not null |
| | | | | |
− | | Primary key. Foreign key to Product.ProductID.<br />PK_ProductVendor_ProductID_VendorID
| |
− | |- valign="top"
| |
− | | VendorID
| |
− | | int
| |
− | | not null
| |
| | | | | |
− | | Primary key. Foreign key to Vendor.VendorID.<br />PK_ProductVendor_ProductID_VendorIDIX_ProductVendor_VendorID | + | | |
− | |- valign="top" | + | |- |
− | | AverageLeadTime | + | | OnOrderQty |
| | int | | | int |
− | | not null
| |
− | |
| |
− | | The average span of time (in days) between placing an order with the vendor and receiving the purchased product.<br />
| |
− | |- valign="top"
| |
− | | StandardPrice
| |
− | | money
| |
− | | not null
| |
− | |
| |
− | | The vendor's usual selling price.<br />
| |
− | |- valign="top"
| |
− | | LastReceiptCost
| |
− | | money
| |
− | | null
| |
− | |
| |
− | | The selling price when last purchased.<br />
| |
− | |- valign="top"
| |
− | | LastReceiptDate
| |
− | | datetime
| |
| | null | | | null |
| | | | | |
− | | Date the product was last received by the vendor.<br />
| |
− | |- valign="top"
| |
− | | MinOrderQty
| |
− | | int
| |
− | | not null
| |
| | | | | |
− | | The maximum quantity that should be ordered.<br />
| |
− | |- valign="top"
| |
− | | MaxOrderQty
| |
− | | int
| |
− | | not null
| |
| | | | | |
− | | The minimum quantity that should be ordered.<br />
| + | |- |
− | |- valign="top" | |
− | | OnOrderQty
| |
− | | int
| |
− | | null
| |
− | |
| |
− | | The quantity currently on order.<br />
| |
− | |- valign="top"
| |
| | UnitMeasureCode | | | UnitMeasureCode |
| | nchar(3) | | | nchar(3) |
| | not null | | | not null |
| | | | | |
− | | The product's unit of measure.<br />IX_ProductVendor_UnitMeasureCode | + | | |
− | |- valign="top" | + | | IX_ProductVendor_UnitMeasureCode |
| + | |- |
| | ModifiedDate | | | ModifiedDate |
| | datetime | | | datetime |
| | not null | | | not null |
− | | (GETDATE()) | + | | (getdate()) |
− | | Date and time the record was last updated.<br /> | + | | |
| + | | |
| |} | | |} |
| | | |
Line 292: |
Line 117: |
| | VendorID | | | VendorID |
| | VendorID | | | VendorID |
− | |}
| |
− |
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Dependency Type
| |
− | | '''Object Type
| |
− | | '''Referenced Object
| |
− |
| |
− | |-
| |
− | | Schema
| |
− | | Schema
| |
− | | [[Purchasing_(schema)|Purchasing]]
| |
− |
| |
| |} | | |} |