Importing/Exporting - Purchases Fields

Purchases Fields - Miscellaneous

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.

Journal Number

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.

Memo

255 characters, alphanumeric.

Description

255 characters, alphanumeric

*Account Number

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 AccountEdge appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.

Job

5 characters, alphanumeric. Must match a preexisting job number in your MYOB software company file.

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

Purchase Status

1 alphanumeric character. O indicates an order. Q indicates a quote. Any other character or blank indicates the purchase is a bill.

Currency Code

3 characters, alpha. One code per sale/purchase. Must match customer/vendor currency code. (If blank, currency code on customer/vendor card substituted.)

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.


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.
Journal Number	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.

Memo	255 characters, alphanumeric.
Description	255 characters, alphanumeric
*Account Number	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 AccountEdge appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.

Job	5 characters, alphanumeric. Must match a preexisting job number in your MYOB software company file.
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

Purchase Status	1 alphanumeric character. O indicates an order. Q indicates a quote. Any other character or blank indicates the purchase is a bill.
Currency Code	3 characters, alpha. One code per sale/purchase. Must match customer/vendor currency code. (If blank, currency code on customer/vendor card substituted.)
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