How to import vendors to VendTable in Dynamics AX

Here are the steps:

1. Import vendor records with a PartyID (I used vendor id)

2. Import records into the DirPartyTable

Type = Organisation
Language=EN-GB (for example)
PartyID=VendTable.AccountNum

3. Import records into the Address table (export dirpartytable to get recid)

AddrRecId=DirPartyTable.RecID
AddrTableId=2303 
STREET=address (i.e added char(10)s in excel for carriage returns - I know
there are other ways)

4. Import records into PartyAddressRelationship (export address to get recid)

Status=active
PartyID = vendtable.partyid

5. Import records into PartyAddressRelationshipMapping (export
partyaddressrelationship to get recid)

addressrecid=address.recid
partyaddressrelationshiprecid=partyaddressrelationship.