Difference between revisions of "Production.TransactionHistoryArchive (table)"

From dbscript Online Help
Jump to: navigation, search
 
(2 intermediate revisions by the same user not shown)
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
 
| Production.TransactionHistoryArchive
 
| Production.TransactionHistoryArchive
Line 8: Line 8:
 
| '''Description
 
| '''Description
 
| Transactions for previous years.
 
| Transactions for previous years.
|-
 
 
|}
 
|}
  
 
+
=== 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 18: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
| '''Description / PK / Index
+
| '''Description
+
 
 
|- valign="top"
 
|- valign="top"
 
| TransactionID
 
| TransactionID
Line 25: Line 24:
 
| not null
 
| not null
 
|  
 
|  
| Primary key for TransactionHistoryArchive records.<br />PK_TransactionHistoryArchive_TransactionID
+
| Primary key for TransactionHistoryArchive records.
 
|- valign="top"
 
|- valign="top"
 
| ProductID
 
| ProductID
Line 31: Line 30:
 
| not null
 
| not null
 
|  
 
|  
| Product identification number. Foreign key to Product.ProductID.<br />IX_TransactionHistoryArchive_ProductID
+
| Product identification number. Foreign key to Product.ProductID.
 
|- valign="top"
 
|- valign="top"
 
| ReferenceOrderID
 
| ReferenceOrderID
Line 37: Line 36:
 
| not null
 
| not null
 
|  
 
|  
| Purchase order, sales order, or work order identification number.<br />IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
+
| Purchase order, sales order, or work order identification number.
 
|- valign="top"
 
|- valign="top"
 
| ReferenceOrderLineID
 
| ReferenceOrderLineID
Line 43: Line 42:
 
| not null
 
| not null
 
| ((0))
 
| ((0))
| Line number associated with the purchase order, sales order, or work order.<br />IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
+
| Line number associated with the purchase order, sales order, or work order.
 
|- valign="top"
 
|- valign="top"
 
| TransactionDate
 
| TransactionDate
Line 49: Line 48:
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
| Date and time of the transaction.<br />
+
| Date and time of the transaction.
 
|- valign="top"
 
|- valign="top"
 
| TransactionType
 
| TransactionType
Line 55: Line 54:
 
| not null
 
| not null
 
|  
 
|  
| W = Work Order, S = Sales Order, P = Purchase Order<br />
+
| W = Work Order, S = Sales Order, P = Purchase Order
 
|- valign="top"
 
|- valign="top"
 
| Quantity
 
| Quantity
Line 61: Line 60:
 
| not null
 
| not null
 
|  
 
|  
| Product quantity.<br />
+
| Product quantity.
 
|- valign="top"
 
|- valign="top"
 
| ActualCost
 
| ActualCost
Line 67: Line 66:
 
| not null
 
| not null
 
|  
 
|  
| Product cost.<br />
+
| Product cost.
 
|- valign="top"
 
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
Line 73: Line 72:
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
| Date and time the record was last updated.<br />
+
| 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_TransactionHistoryArchive_TransactionID
 +
| TransactionID
 +
|}
 +
 
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 
 +
|- valign="top"
 +
| IX_TransactionHistoryArchive_ProductID
 +
|
 +
| ProductID
 +
|- valign="top"
 +
| IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
 +
|
 +
| ReferenceOrderID, ReferenceOrderLineID
 +
|}
 +
 
 +
=== Check Constraints ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Check Constraint
 +
| '''Expression
 +
| '''Description
 +
 
 +
|- valign="top"
 +
| CK_TransactionHistoryArchive_TransactionType
 +
| (upper([TransactionType])='P' OR upper([TransactionType])='S' OR upper([TransactionType])='W')
 +
| Check constraint [TransactionType]='p' OR [TransactionType]='s' OR [TransactionType]='w' OR [TransactionType]='P' OR [TransactionType]='S' OR [TransactionType]='W'
 
|}
 
|}
  
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
  
 +
|}
  
  

Latest revision as of 23:17, 23 June 2010

wikibot[edit]

Table Production.TransactionHistoryArchive
Description Transactions for previous years.

Columns[edit]

Column Data Type Nullable Default Description
TransactionID int not null Primary key for TransactionHistoryArchive records.
ProductID int not null Product identification number. Foreign key to Product.ProductID.
ReferenceOrderID int not null Purchase order, sales order, or work order identification number.
ReferenceOrderLineID int not null ((0)) Line number associated with the purchase order, sales order, or work order.
TransactionDate datetime not null (getdate()) Date and time of the transaction.
TransactionType nchar(1) not null W = Work Order, S = Sales Order, P = Purchase Order
Quantity int not null Product quantity.
ActualCost money not null Product cost.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key[edit]

Primary Key Columns
PK_TransactionHistoryArchive_TransactionID TransactionID

Indexes[edit]

Index Type Columns
IX_TransactionHistoryArchive_ProductID ProductID
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID ReferenceOrderID, ReferenceOrderLineID

Check Constraints[edit]

Check Constraint Expression Description
CK_TransactionHistoryArchive_TransactionType (upper([TransactionType])='P' OR upper([TransactionType])='S' OR upper([TransactionType])='W') Check constraint [TransactionType]='p' OR [TransactionType]='s' OR [TransactionType]='w' OR [TransactionType]='P' OR [TransactionType]='S' OR [TransactionType]='W'

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Production


automatically generated[edit]

Table Production.TransactionHistoryArchive
Description Transactions for previous years.


Column Data Type Nullable Default Description / PK / Index
TransactionID int not null Primary key for TransactionHistoryArchive records.
PK_TransactionHistoryArchive_TransactionID
ProductID int not null Product identification number. Foreign key to Product.ProductID.
IX_TransactionHistoryArchive_ProductID
ReferenceOrderID int not null Purchase order, sales order, or work order identification number.
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
ReferenceOrderLineID int not null (0) Line number associated with the purchase order, sales order, or work order.
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
TransactionDate datetime not null (GETDATE()) Date and time of the transaction.
TransactionType nchar(1) not null W = Work Order, S = Sales Order, P = Purchase Order
Quantity int not null Product quantity.
ActualCost money not null Product cost.
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Dependency Type Object Type Referenced Object
Schema Schema Production