When adding a vendor

INSERT INTO Vendor(Name,CompanyName,VendorAddressAddr1,VendorAddressAddr2,VendorAddressAddr3,VendorAddressAddr4,VendorAddressCity,VendorAddressState,VendorAddressPostalCode,VendorAddressCountry,NameOnCheck,Phone,Fax,TermsRefFullName)

VALUES ( 'VNAME','G NAME','RA1','RA2','RA3','RA4','RCITY','RSTATE','RZIPI','RCOUNTRY','G NAME','RPHONE','G FAX','.5% Net 30')

The city, state, zip and country all get written to the city field and the state, country and zip code fields are blank.  What am I doing wrong?

For a start COUNTRY can't be any value, it must be a pre-determined valid value.

See: Address Mixup in Australian, Canadian & USA versions QuickBooks? and How do I create Vendors (Suppliers)?