Importing/Exporting - Sales Fields

Sales Fields - Time Billing

To 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 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 to 4) cannot exceed 255 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.

Customer PO

20 characters, alphanumeric

**Ship Via

20 characters, alphanumeric

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.

*Activity ID

30 characters, alphanumeric

Hours/Units

11 characters, numeric (may be negative or blank)

Note

255 characters, alphanumeric

Rate

11 characters, numeric

Amount

15 characters (including currency sign, comma and negative sign). If no decimal entered, MYOB software appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.

Job

15 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

**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.

Sale Status

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

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.

- % Monthly Charge

2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.

Salesperson Last Name

31 characters, alphanumeric. Must match the name of an employee card in the MYOB software company file.

Salesperson First Name

30 characters, alphanumeric.

Referral Source

20 characters, alphanumeric

Amount Paid

15 characters (including currency 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.

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 type is entered.

Card Number

25 characters, alphanumeric. Available only if a credit card or debit card payment method type is entered.

Expiration Date

10 characters, alphanumeric. Available only if a credit card or debit card payment method type is entered.

Authorization Code

255 characters, alphanumeric. Available only if a credit card or debit card payment method type is entered.

Check Number

8 characters, alphanumeric. Available only if a check payment method type is entered.

Category

15 characters, alphanumeric

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

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

** This field appears only if you mark the I Include Items on Time Billing Invoices preference.

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 to 4) cannot exceed 255 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.
Customer PO	20 characters, alphanumeric
**Ship Via	20 characters, alphanumeric
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.
*Activity ID	30 characters, alphanumeric
Hours/Units	11 characters, numeric (may be negative or blank)
Note	255 characters, alphanumeric
Rate	11 characters, numeric
Amount	15 characters (including currency sign, comma and negative sign). If no decimal entered, MYOB software appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.
Job	15 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
**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.
Sale Status	1 alphanumeric character. O indicates an order. Q indicates a quote. Any other character or blank indicates the sale is an invoice.
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.
- % Monthly Charge	2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.
Salesperson Last Name	31 characters, alphanumeric. Must match the name of an employee card in the MYOB software company file.
Salesperson First Name	30 characters, alphanumeric.
Referral Source	20 characters, alphanumeric
Amount Paid	15 characters (including currency 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.
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 type is entered.
Card Number	25 characters, alphanumeric. Available only if a credit card or debit card payment method type is entered.
Expiration Date	10 characters, alphanumeric. Available only if a credit card or debit card payment method type is entered.
Authorization Code	255 characters, alphanumeric. Available only if a credit card or debit card payment method type is entered.
Check Number	8 characters, alphanumeric. Available only if a check payment method type is entered.
Category	15 characters, alphanumeric
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