Purchasing.SupplierTransactions - WideWorldImporters

WideWorldImporters

- WideWorldImporters

Documentation	WideWorldImporters
Schema	Purchasing
Name	SupplierTransactions
Module	Purchasing

All financial transactions that are supplier-related (invoices, payments)

Columns

		Name	Data type	Attributes	References	Description
	1	SupplierTransactionID	int	Default: NEXT VALUE FOR [Sequences].[TransactionID]		Numeric ID used to refer to a supplier transaction within the database
Numeric ID used to refer to a supplier transaction within the database Default: NEXT VALUE FOR [Sequences].[TransactionID]
	2	SupplierID	int		Purchasing.Suppliers	Supplier for this transaction
Supplier for this transaction References: Purchasing.Suppliers
	3	TransactionTypeID	int		Application.TransactionTypes	Type of transaction
Type of transaction References: Application.TransactionTypes
	4	PurchaseOrderID	int		Purchasing.PurchaseOrders	ID of an purchase order (for transactions associated with a purchase order)
ID of an purchase order (for transactions associated with a purchase order) References: Purchasing.PurchaseOrders
	5	PaymentMethodID	int		Application.PaymentMethods	ID of a payment method (for transactions involving payments)
ID of a payment method (for transactions involving payments) References: Application.PaymentMethods
	6	SupplierInvoiceNumber	nvarchar(20)			Invoice number for an invoice received from the supplier
Invoice number for an invoice received from the supplier
	7	TransactionDate	date			Date for the transaction
Date for the transaction
	8	AmountExcludingTax	decimal(18, 2)			Transaction amount (excluding tax)
Transaction amount (excluding tax)
	9	TaxAmount	decimal(18, 2)			Tax amount calculated
Tax amount calculated
	10	TransactionAmount	decimal(18, 2)			Transaction amount (including tax)
Transaction amount (including tax)
	11	OutstandingBalance	decimal(18, 2)			Amount still outstanding for this transaction
Amount still outstanding for this transaction
	12	FinalizationDate	date			Date that this transaction was finalized (if it has been)
Date that this transaction was finalized (if it has been)
	13	IsFinalized	bit	Computed: case when [FinalizationDate] IS NULL then CONVERT([bit],(0)) else CONVERT([bit],(1)) end		Is this transaction finalized (invoices, credits and payments have been matched)
Is this transaction finalized (invoices, credits and payments have been matched) Computed: case when [FinalizationDate] IS NULL then CONVERT([bit],(0)) else CONVERT([bit],(1)) end
	14	LastEditedBy	int		Application.People
References: Application.People
	15	LastEditedWhen	datetime2(7)	Default: sysdatetime()		When this row was last edited
When this row was last edited Default: sysdatetime()

Relations

Foreign table	Primary table	Join	Title / Name / Description
Purchasing.SupplierTransactions	Application.PaymentMethods	Purchasing.SupplierTransactions.PaymentMethodID = Application.PaymentMethods.PaymentMethodID	FK_Purchasing_SupplierTransactions_PaymentMethodID_Application_PaymentMethods Foreign key constraint referencing PaymentMethods.PaymentMethodID
Purchasing.SupplierTransactions.PaymentMethodID = Application.PaymentMethods.PaymentMethodID Name: FK_Purchasing_SupplierTransactions_PaymentMethodID_Application_PaymentMethods Foreign key constraint referencing PaymentMethods.PaymentMethodID
Purchasing.SupplierTransactions	Application.People	Purchasing.SupplierTransactions.LastEditedBy = Application.People.PersonID	FK_Purchasing_SupplierTransactions_Application_People Foreign key constraint referencing People.PersonID
Purchasing.SupplierTransactions.LastEditedBy = Application.People.PersonID Name: FK_Purchasing_SupplierTransactions_Application_People Foreign key constraint referencing People.PersonID
Purchasing.SupplierTransactions	Purchasing.PurchaseOrders	Purchasing.SupplierTransactions.PurchaseOrderID = Purchasing.PurchaseOrders.PurchaseOrderID	FK_Purchasing_SupplierTransactions_PurchaseOrderID_Purchasing_PurchaseOrders Foreign key constraint referencing PurchaseOrders.PurchaseOrderID
Purchasing.SupplierTransactions.PurchaseOrderID = Purchasing.PurchaseOrders.PurchaseOrderID Name: FK_Purchasing_SupplierTransactions_PurchaseOrderID_Purchasing_PurchaseOrders Foreign key constraint referencing PurchaseOrders.PurchaseOrderID
Purchasing.SupplierTransactions	Purchasing.Suppliers	Purchasing.SupplierTransactions.SupplierID = Purchasing.Suppliers.SupplierID	FK_Purchasing_SupplierTransactions_SupplierID_Purchasing_Suppliers Foreign key constraint referencing Suppliers.SupplierID
Purchasing.SupplierTransactions.SupplierID = Purchasing.Suppliers.SupplierID Name: FK_Purchasing_SupplierTransactions_SupplierID_Purchasing_Suppliers Foreign key constraint referencing Suppliers.SupplierID
Purchasing.SupplierTransactions	Application.TransactionTypes	Purchasing.SupplierTransactions.TransactionTypeID = Application.TransactionTypes.TransactionTypeID	FK_Purchasing_SupplierTransactions_TransactionTypeID_Application_TransactionTypes Foreign key constraint referencing TransactionTypes.TransactionTypeID
Purchasing.SupplierTransactions.TransactionTypeID = Application.TransactionTypes.TransactionTypeID Name: FK_Purchasing_SupplierTransactions_TransactionTypeID_Application_TransactionTypes Foreign key constraint referencing TransactionTypes.TransactionTypeID

Unique keys

	Key name	Columns	Description
	PK_Purchasing_SupplierTransactions	SupplierTransactionID	Primary key (nonclustered) constraint.
Primary key (nonclustered) constraint.

Uses

Name
Purchasing.SupplierTransactions
Application.PaymentMethods
Application.People
Application.TransactionTypes
Purchasing.PurchaseOrders
Purchasing.Suppliers

Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51