Generated using SQL Data Dictionary demo version.
Types of customer, supplier, or stock transactions (ie: invoice, credit note, etc.)
| Column | Data Type | Identity | Nullable | Default | |
|---|---|---|---|---|---|
| PK | TransactionTypeID | int | NEXT VALUE FOR [Sequences].[TransactionTypeID] | ||
| Numeric ID used for reference to a transaction type within the database | |||||
| UK | TransactionTypeName | nvarchar(50) | |||
| Full name of the transaction type | |||||
| FK | LastEditedBy | int | |||
| ValidFrom | datetime2 | ||||
| ValidTo | datetime2 | ||||