Databases > WideWorldImporters > Tables > Application.TransactionTypes

WideWorldImporters

Application.TransactionTypes

//
Types of customer, supplier, or stock transactions (ie: invoice, credit note, etc.)

SYSTEM VERSIONED

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    TransactionTypeID
    [int] NOT NULL DEFAULT (NEXT VALUE FOR [Sequences].[TransactionTypeID])
  • //
    ${escapify(column.description)}
    TransactionTypeName
    [nvarchar](50) NOT NULL
  • LastEditedBy
    [int] NOT NULL
  • ValidFrom
    [datetime2](8) NOT NULL
  • ValidTo
    [datetime2](8) NOT NULL

Indexes

  • PK_Application_TransactionTypes
    UNIQUE CLUSTERED
    TransactionTypeID
  • UQ_Application_TransactionTypes_TransactionTypeName
    UNIQUE NONCLUSTERED
    TransactionTypeName

Foreign Keys

  • FK_Application_TransactionTypes_Application_People
    Application.People
    LastEditedBy ⥱ PersonID

Sample Data

TransactionTypeID
TransactionTypeName
LastEditedBy
ValidFrom
ValidTo
1
Customer Invoice
1
2
Customer Credit Note
1
3
Customer Payment Received
1
4
Customer Refund
1
5
Supplier Invoice
1
6
Supplier Credit Note
1
7
Supplier Payment Issued
1
8
Supplier Refund
1
9
Stock Transfer
1
10
Stock Issue
1
11
Stock Receipt
1
12
Stock Adjustment at Stocktake
1
13
Customer Contra
9