Sales Fields - Professional

Field	Description and Character Limits
*Co./Last Name	Must match a preexisting card in your MYOB software company file. If a company name (no first name), 50 characters, alphanumeric. If a last name, 30 characters, alphanumeric. Note: To match a preexisting card when the designation chosen for the card is Individual, MYOB BusinessBasics requires that you include both the last name and the first name.
First Name	20 characters, alphanumeric.
Invoice #	8 characters, alphanumeric
Date	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
Already Printed	1 character. Any non-blank character signifies that the invoice is already printed or sent.
Detail Date	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
Description	255 characters, alphanumeric
*Account #	Must be valid, preexisting MYOB software account number. 5 characters, numeric. May (optionally) have a non-numeric separator between the first digit and the last 4 digits (for example, 1-1234).
*Amount	15 characters (including dollar sign, comma and negative sign). If no decimal entered, MYOB BusinessBasics appends .00. If more than 2 decimals, MYOB BusinessBasics rounds to the nearest cent.
Job	5 characters, alphanumeric. Must match preexisting job number in your MYOB software company file.
Comment	255 characters, alphanumeric
Journal Memo	255 characters, alphanumeric
Promised Date	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
Tax Code	3 characters, alphanumeric must match a preexisting tax code in the Tax Code List.
Tax Amount	15 characters, numeric, including 2 decimal places
Sale Status	1 alphanumeric character. Q indicates a quote. Any other character or blank indicates the sale is an invoice.
Terms - Payment is Due	1 character, numeric. Use one of these codes to indicate when payment is due: 0 - COD 1 - Prepaid 2 - In a Given # of Days 3 - On a Day of the Month 4 - # of days after EOM 5 - Day of Month after EOM
- Balance Due Days	3 characters, numeric If you choose code 0, 1, 2 or 4 to indicate when payment is due, use a number of days from 0-999. If you chose code 3 or 5 to indicate when payment is due, use a date from 1-31. (EOM=31)
Amount Paid	15 characters (including dollar sign, comma and negative sign). If no decimal entered, MYOB BusinessBasics appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.
Payment Method	20 characters, alphanumeric.
Payment Notes	255 characters, alphanumeric. Available only if a Payment Method is entered.
Name on Card	50 characters, alphanumeric. Available only if a credit card or debit card method of payment is entered.
Card Number	25 characters, alphanumeric. Available only if a credit card or debit card method of payment is entered.
Expiration Date	10 characters, alphanumeric. Available only if a credit card or debit card method of payment is entered.
Authorization Number	255 characters, alphanumeric. Available only if a credit card or debit card method of payment is entered.
Check No	8 characters, alphanumeric. Available only if a check method of payment is entered.
Check No	8 characters, alphanumeric. Only available for check method of payment.

*This is a required field for importing.