vendor_item_link

vend_id

string40

Y

N

Identify vendor; referenced cust record must have vendor = Yes

item_id

string40

Y

N

Item available from this vendor; referenced item record must have purchased = Yes

pref

int32

N

N

Vendor with lowest number is preferred; starts at 1

price

tfloat

N

Y

Unit price if independent of quantity; assumes standard unit of measure (i.e., item.uom_id)

Note: This field is currently not used.

lead_time

int32

N

Y

Lead time in days; used to check po_line.reqd_by

Note: This field is currently not used.

notes

nvarchar(max)

N

Y

Notes about ability of vendor to supply item

Note: This field is currently not used.

spare1

string80

N

Y

Use defined by language term 5217

Note: This field is currently not used.

spare2

string80

N

Y

Use defined by language term 5218

Note: This field is currently not used.

spare3

string80

N

Y

Use defined by language term 5219

Note: This field is currently not used.

spare4

string80

N

Y

Use defined by language term 5220

Note: This field is currently not used.

last_edit_comment

string254

N

Y

Reserved for internal use to indicate why this record was changed

last_edit_by

string40

N

N

Who last changed this record

last_edit_at

tdatetime

N

N

When this record was last changed

row_id

ID 1

N

N

Unique row identifier, for audit trail.