Table: dbo.Vendor_Distribution
This table contains the default distributions used when a payment is created for a vendor.
Columns
Name | Type | Constraints | Description
vendor_distribution_KEY | int (4) | NOT NULL | Primary key.
vendor_KEY | int (4) | NOT NULL | Foreign key to the parent vendor.
gl_account_KEY | int (4) |  | Foreign key to the general ledger account if one is provided, otherwise null. If null, the consumers of this data will have to determine a proper response ie. use the undistributed account, bark at the user, display a blank GL account, etc.
description | nvarchar (240) | NOT NULL | Description of the distribution, left blank if the account description is to be used.
amount | decimal (9, 2) | NOT NULL | Distribution amount.
sequence_number | int (4) | NOT NULL | Sequence number that determines the order within the vendor distributions.
vendor_1099_box_setup_KEY | int (4) |  | A nullable foreign key to the record that has our W2/1099 Box Setup info for this distribution.

Primary key
Name | Columns | Description
PK_Vendor_Distribution | vendor_distribution_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Vendor_Distribution__GL_Account__gl_account_KEY | gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Vendor_Distribution__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |
FK_Vendor_Distribution__Vendor_1099_Box_Setup__vendor_1099_box_setup_KEY | vendor_1099_box_setup_KEY | Vendor_1099_Box_Setup (vendor_1099_box_setup_KEY) |