Purchasing.SupplierTransactions

Columns

• //

  ${escapify(column.description)}
  SupplierTransactionID
  [int] NOT NULL DEFAULT (NEXT VALUE FOR [Sequences].[TransactionID])
• //

  ${escapify(column.description)}
  SupplierID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  TransactionTypeID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  PurchaseOrderID
  [int] NULL
• //

  ${escapify(column.description)}
  PaymentMethodID
  [int] NULL
• //

  ${escapify(column.description)}
  SupplierInvoiceNumber
  [nvarchar](20) NULL
• //

  ${escapify(column.description)}
  TransactionDate
  [date] NOT NULL
• //

  ${escapify(column.description)}
  AmountExcludingTax
  [decimal](18, 2) NOT NULL
• //

  ${escapify(column.description)}
  TaxAmount
  [decimal](18, 2) NOT NULL
• //

  ${escapify(column.description)}
  TransactionAmount
  [decimal](18, 2) NOT NULL
• //

  ${escapify(column.description)}
  OutstandingBalance
  [decimal](18, 2) NOT NULL
• //

  ${escapify(column.description)}
  FinalizationDate
  [date] NULL
• //

  ${escapify(column.description)}
  IsFinalized
  [bit] NULL
• LastEditedBy
  [int] NOT NULL
• LastEditedWhen
  [datetime2](8) NOT NULL DEFAULT (sysdatetime())

Indexes

• CX_Purchasing_SupplierTransactions
  CLUSTERED
  TransactionDate
• //

  Auto-created to support a foreign key
  FK_Purchasing_SupplierTransactions_SupplierID
  NONCLUSTERED
  SupplierID , TransactionDate
• //

  Auto-created to support a foreign key
  FK_Purchasing_SupplierTransactions_TransactionTypeID
  NONCLUSTERED
  TransactionTypeID , TransactionDate
• //

  Auto-created to support a foreign key
  FK_Purchasing_SupplierTransactions_PurchaseOrderID
  NONCLUSTERED
  PurchaseOrderID , TransactionDate
• //

  Auto-created to support a foreign key
  FK_Purchasing_SupplierTransactions_PaymentMethodID
  NONCLUSTERED
  PaymentMethodID , TransactionDate
• //

  Index used to quickly locate unfinalized transactions
  IX_Purchasing_SupplierTransactions_IsFinalized
  NONCLUSTERED
  IsFinalized , TransactionDate
• PK_Purchasing_SupplierTransactions
  UNIQUE NONCLUSTERED
  SupplierTransactionID

Foreign Keys

• FK_Purchasing_SupplierTransactions_Application_People
  Application.People
  LastEditedBy ⥱ PersonID
• FK_Purchasing_SupplierTransactions_PaymentMethodID_Application_PaymentMethods
  Application.PaymentMethods
  PaymentMethodID ⥱ PaymentMethodID
• FK_Purchasing_SupplierTransactions_PurchaseOrderID_Purchasing_PurchaseOrders
  Purchasing.PurchaseOrders
  PurchaseOrderID ⥱ PurchaseOrderID
• FK_Purchasing_SupplierTransactions_SupplierID_Purchasing_Suppliers
  Purchasing.Suppliers
  SupplierID ⥱ SupplierID
• FK_Purchasing_SupplierTransactions_TransactionTypeID_Application_TransactionTypes
  Application.TransactionTypes
  TransactionTypeID ⥱ TransactionTypeID

Sample Data