Importing and exporting

Purchases Fields - Professional

View a list of all types of fields: Field descriptions for importing and exporting

Field	Description and Character Limits
*Co./Last Name	Must match a preexisting card in the MYOB AccountEdge 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 designated as "Individual,' AccountEdge requires both the last and first names.
First Name	20 characters, alphanumeric.
Purchase #	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
Delivery Status	P=To be Printed E=To be Emailed B=To be Printed & Emailed A=Already Printed or Sent If field is left blank, the field will be set to P=To be Printed
Journal Memo	255 characters, alphanumeric
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 #	5 characters, numeric. Must be a valid, preexisting MYOB AccountEdge account number. May have an optional non-numeric separator between the first digit and the last 4 digits (example: 1-1234).
*Amount	15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals. NOTE:  Importing and exporting currency amounts
Job	15 characters, alphanumeric. Must match a preexisting job number in the AccountEdge company file.
Comment	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 (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals. NOTE:  Importing and exporting currency amounts
Import Duty Amount	15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals. NOTE:  Importing and exporting currency amounts
Purchase Status	1 character. Letter "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, alphabetic. One code per sale/purchase. Must match a preexisting currency code in the Currency List and a 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; based on Payment is Due date: If code 0, 1, 2 or 4 indicates when payment is due, use a number of days from 0-999. If code 3 or 5 indicates when payment is due, use a date from 1-31. (EOM=31)
- Balance Due Days	3 characters, numeric; based on Payment is Due date: If code 0, 1, 2 or 4 indicates when payment is due, use a number of days from 0-999. If code 3 or 5 indicates when payment is due, use a date from 1-31. (EOM=31)
% Discount	2 numeric characters to the left of a decimal point and 2 characters to the right of the decimal point (example: 00.10).
Amount Paid	15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals. NOTE:  Importing and exporting currency amounts
Category	15 characters, alphanumeric

*Required Field:  When importing, this field must have a valid matching import field.