Table: dbo.Vendor_Distribution
This table contains the default distributions used when a payment is created for a vendor.
Columns
NameTypeConstraintsDescription
vendor_distribution_KEYint (4)NOT NULLPrimary key.
vendor_KEYint (4)NOT NULLForeign key to the parent vendor.
gl_account_KEYint (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.
descriptionnvarchar (240)NOT NULLDescription of the distribution, left blank if the account description is to be used.
amountdecimal (9, 2)NOT NULLDistribution amount.
sequence_numberint (4)NOT NULLSequence number that determines the order within the vendor distributions.
vendor_1099_box_setup_KEYint (4)A nullable foreign key to the record that has our W2/1099 Box Setup info for this distribution.
Primary key
NameColumnsDescription
PK_Vendor_Distributionvendor_distribution_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Vendor_Distribution__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)
FK_Vendor_Distribution__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
FK_Vendor_Distribution__Vendor_1099_Box_Setup__vendor_1099_box_setup_KEYvendor_1099_box_setup_KEYVendor_1099_Box_Setup (vendor_1099_box_setup_KEY)

Schema diagram