VendorID|int|4|10|0|no AccountNumber|AccountNumber|30|||no Name|Name|100|||no CreditRating|tinyint|1|3|0|no PreferredVendorStatus|Flag|1|||no ActiveFlag|Flag|1|||no PurchasingWebServiceURL|nvarchar|2048|||yes ModifiedDate|datetime|8|||no