Purchases Fields - Item

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 AccountEdge requires that you include both the last name and the first name.
First Name	20 characters, alphanumeric.
Addr 1 - Line 1 - Line 2 - Line 3 - Line 4	Total Address field (lines 1 through 4) cannot exceed 255 characters, alphanumeric.
Purchase Order #	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.
Vendor Invoice #	20 characters, alphanumeric
Ship Via	20 characters, alphanumeric
Already Printed	1 character. Any non-blank character signifies that the invoice and purchase order is already printed or sent.
*Item Number	30 characters, alphanumeric. Must match an preexisting item in your MYOB AccountEdge company file.
Quantity	10 characters, numeric - allows 3 decimal places and decimal point.
Description	255 characters, alphanumeric
Price	11 characters, numeric, including 3 decimal places
Discount	10 characters, numeric, including 2 decimal places
Total	Dollar amount field 15 characters (including dollar signs and negative signs).
Job	5 characters, alphanumeric. Must match preexisting job number in your MYOB AccountEdge company file.
Comment	255 characters, alphanumeric
Journal Memo	255 characters, alphanumeric
Shipping 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
Import Duty Amount	15 characters, numeric, including 2 decimal places
Freight Amount	15 characters, numeric, including 2 decimal places
Freight Tax Code	3 characters, alphanumeric. Must match a preexisting tax code in the Tax Code List.
Freight Tax Amount	15 characters, numeric, including 2 decimal places
Freight Import Duty Amount	15 characters, numeric, including 2 decimal places
Purchase Status	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	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	11 digits, including 6 decimal places. If blank, current exchange rate substituted.
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
- Discount 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)
- 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)
- % Discount	2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.
Amount Paid	15 characters (including dollar sign, comma and negative sign). If no decimal entered, MYOB AccountEdge appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.
Category	15 characters, alphanumeric

*This is a required field for importing.