Open topic with navigation

VENDOR1099DISTRIBUTION (4.0SP20)

All vendor 1099 distributions.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

VENDOR1099SETTINGID

uniqueidentifier

false

Foreign key to the vendor 1099 setting table

BOXNUMBER1099ID

uniqueidentifier

false

1099 box number

STATEID

uniqueidentifier

true

Submitted state.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.
Fields
Field Field Type Null Notes Description

PERCENT

decimal(20, 3)

false

0

Percent

SEQUENCE

int

false

0

Sequence to show distributions.

DATEADDED

datetime

false

getdate()

Indicates the date this record was added.

DATECHANGED

datetime

false

getdate()

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.
Indexes
Index Name Field(s) Unique Primary Clustered

IX_VENDOR1099DISTRIBUTION_DATEADDED

DATEADDED

False

False

True

IX_VENDOR1099DISTRIBUTION_DATECHANGED

DATECHANGED

False

False

False

PK_VENDOR1099DISTRIBUTION

ID

True

True

False

UC_VENDOR1099DISTRIBUTION_BOXNUMBER1099ID_STATEID

VENDOR1099SETTINGID

BOXNUMBER1099ID

STATEID

True

False

False
Triggers
Trigger Name Description

TR_VENDOR1099DISTRIBUTION_VALIDSTATE

TR_VENDOR1099DISTRIBUTION_AUDIT_UPDATE

TR_VENDOR1099DISTRIBUTION_AUDIT_DELETE