Item Sales and Purchases Fields

Field	Sales or Purchases	Description and Character Limits
*Co./Last Name	Both	Must match a preexisting card in your MYOB software data file. If a company name (no first name), 50 characters, alphanumeric. If a last name, 30 characters, alphanumeric. (If the card is an individual, MYOB software matches the last name followed by a comma and a space, followed by the first name.)
First Name	Both	20 characters, alphanumeric.
Addr 1 - Line 1 - Line 2 - Line 3 - Line 4	Both	Total Address field (lines 1 through 4) cannot exceed 255 characters, alphanumeric.
Sales Status	Sale	1 alphanumeric character. O indicates an order. Q indicates a quote. Any other character or blank indicates the sale is an invoice.
Purchase Status	Purchase	1 alphanumeric character. O indicates an order. Q indicates a quote. Any other character or blank indicates the purchase is a bill.
Invoice #	Sales	8 characters, alphanumeric
Purchase Order #	Purchases	8 characters, alphanumeric
Date	Both	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
Customer PO	Sales	20 characters, alphanumeric
Vendor Invoice #	Purchases	20 characters, alphanumeric
Ship Via	Both	20 characters, alphanumeric
Already Printed	Both	1 character. Any non-blank character signifies that the invoice and purchase order is already printed or sent.
*Item Number	Both	30 characters, alphanumeric. Must match an preexisting item in your MYOB Accounting Plus data file.
Quantity	Both	10 characters, numeric - allows 3 decimal places and decimal point.
Description	Both	255 characters, alphanumeric
Price	Both	11 characters, numeric, including 3 decimal places
Discount	Both	10 characters, numeric, including 2 decimal places
Total	Both	Dollar amount field 15 characters (including dollar signs and negative signs).
Job	Both	5 characters, alphanumeric. Must match preexisting job number in your MYOB Accounting Plus data file.
Comment	Both	255 characters, alphanumeric
Journal Memo	Both	255 characters, alphanumeric
Slsmn Last Name	Sales	31 characters, alphanumeric. Must match the name of an employee card in the MYOB Accounting Plus data file.
Slsmn First Name	Sales	20 characters, alphanumeric.
Shipping Date	Both	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
Tax Code	Both	3 characters, alphanumeric. Must match a preexisting tax code in the Tax Code List.
Referral Source	Sales	20 characters, alphanumeric.
Tax Amount	Both	15 characters, numeric, including 2 decimal places
Freight Tax	Both	Any non-blank character indicates freight is taxed.
Freight Tax Code	Both	3 characters, alphanumeric must match a preexisting tax code in the Tax Code List.
Freight Tax Amount	Both	15 characters, numeric, including 2 decimal places
Sale Status	Sales	1 character. O indicates the sale is an order, Q indicates the sale is a quote. Any other character or no character indicates the sale is an invoice.
Purchase Status	Purchases	1 character. O indicates the purchase is an order, Q indicates the purchase is a quote. Any other character or no character indicates the purchase is a bill.
Currency Code	Both	3 characters, alpha. One code per sale/purchase. Must match a preexisting currency code in the Currency List. Must match customer/vendor currency code.
Exchange Rate	Both	11 digits, including 6 decimal places. If blank, current exchange rate substituted.
Terms – Payment is Due	Both	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
- Discount Days	Both	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)
- Balance Due Days	Both	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)
% Discount	Both	2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.
- % Monthly Charge	Sales	2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.
Amount Paid	Both	15 characters (including dollar sign, comma and negative sign). If no decimal entered, MYOB Accounting Plus appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.
Payment Date	Both	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
Payment Method	Sales	20 characters, alphanumeric.
Payment Notes	Sales	255 characters, alphanumeric.
Name on Card	Sales	50 characters, alphanumeric. Only available for credit card and debit card methods of payment.
Card Number	Sales	25 characters, alphanumeric. Only available for credit card and debit card methods of payment.
Expiration Date	Sales	10 characters, alphanumeric. Only available for credit card and debit card methods of payment.
Authorization	Sales	255 characters, alphanumeric. Only available for credit card and debit card methods of payment.

*This is a required field for importing.