Field titles (header row) | Mandatory or optional title | Description of data in this field | Rules for the data | Mandatory or optional field |
---|
Co./Last Name | Mandatory | Last name or company name. Note: This will be imported into the last name and company name fields in MYOB Essentials. | Up to 50 characters in length. | Mandatory |
First Name | Mandatory | First name of the contact. | Up to 20 characters in length. | Optional |
Card Status | Mandatory | The status determines whether the contact is active. | This field should have a value of: N | Mandatory |
Addr 1 - Line 1 | Mandatory | Line 1 of the street address. | Up to 255 characters in length. | Optional |
- Line 2 | Mandatory | Line 2 of the street address. | Up to 253 characters in length. | Optional |
- City | Mandatory | City for the street address. | Up to 255 characters in length. | Optional |
- State | Mandatory | State for the street address. | Up to 255 characters in length. | Optional |
- Postcode | Mandatory | Postcode for the street address. | Up to 10 characters in length. | Optional |
- Country | Mandatory | Country for the street address. | Up to 255 characters in length. | Optional |
- Phone # 1 | Mandatory | Phone number for the street address. | Up to 21 characters in length. | Optional |
- Phone # 2 | Mandatory | Mobile number. | Up to 21 characters in length. | Optional |
- Fax # | Mandatory | Fax number. | Up to 21 characters in length. | Optional |
- Email | Mandatory | Email address. | Up to 255 characters in length. | Optional |
- WWW | Mandatory | Website. | Up to 255 characters in length. | Optional |
Addr 2 - Line 1 | Mandatory | Line 1 of the billing address. | Up to 255 characters in length. | Optional |
- Line 2 | Mandatory | Line 2 of the billing address | Up to 253 characters in length | Optional |
- City | Mandatory | City for the billing address | Up to 255 characters in length | Optional |
- State | Mandatory | State for the billing address | Up to 255 characters in length | Optional |
- Postcode | Mandatory | Postcode for the billing address | Up to 10 characters in length | Optional |
- Country | Mandatory | Country for the billing address | Up to 255 characters in length | Optional |
- Phone # 1 | Mandatory | Phone number for the billing address | Up to 21 characters in length | Optional |
- Phone # 2 | Mandatory | Mobile number | Up to 21 characters in length | Optional |
- Fax # | Mandatory | Fax number | Up to 21 characters in length | Optional |
- Email | Mandatory | Email address | Up to 255 characters in length | Optional |
- WWW | Mandatory | Website | Up to 255 characters in length | Optional |
Notes | Mandatory | Any notes about the contact | Up to 255 characters in length | Optional |
Tax ID No. (Australia) | Mandatory | The contact’s ABN number | A valid ABN number | Mandatory. If you do not have this information for the contact, you must at least enter a space. |
GST ID No. (New Zealand) | Mandatory | The contact’s GST number | A valid GST number | Mandatory. If you do not have this information for the contact, you must at least enter a space. |