VENDOR1099SETTING

All vendor 1099 settings.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
CHECK1099BOX9	bit		Default = 0	Mark 1099 box 9 for direct sales of consumer products
CHECK10992TIN	bit		Default = 0	Mark the 1099 2nd TIN notification box
DATEADDED	datetime		Default = getdate()	Indicates the date this record was added.
DATECHANGED	datetime		Default = getdate()	Indicates the date this record was last changed.
TS	timestamp			Timestamp.
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)	Numeric representation of the timestamp.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ID	uniqueidentifier		VENDOR.ID	Primary Key.
NAMEFIRSTLINEALIASTYPECODEID	uniqueidentifier	yes	ALIAS.ID	Foreign Key to the Alias table
NAMESECONDLINEALIASTYPECODEID	uniqueidentifier	yes	ALIAS.ID	Foreign Key to the Alias table
ADDRESSID	uniqueidentifier	yes	ADDRESS.LOCALID	Foreign Key to the Address table
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_VENDOR1099SETTING_ADDRESSID	ADDRESSID
IX_VENDOR1099SETTING_DATEADDED	DATEADDED			yes
IX_VENDOR1099SETTING_DATECHANGED	DATECHANGED
PK_VENDOR1099SETTING	ID	yes	yes

Triggers

Trigger Name	Description
TR_VENDOR1099SETTING_AUDIT_UPDATE
TR_VENDOR1099SETTING_AUDIT_DELETE

Referenced by

Referenced by	Field
VENDOR1099ADJUSTMENT	VENDOR1099SETTINGID
VENDOR1099DISTRIBUTION	VENDOR1099SETTINGID