This table contains the default distributions used when a payment is created for a vendor. |
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. |