CSV import: Order Entry recurring templates

#

Any row that starts with # is ignored during import.

UI Field Name:

Document type

Type:

Character

Length:

30

Default Value:

None

Valid Values:

Any active transaction definition. This should match the Template Name of the transaction definition.

Dependencies:

Should already exist

Required:

Yes

Editable:

No

UI Field Name:

Customer ID

Type:

Character

Length:

21

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

Should already exist

Required:

Yes

Editable:

No

UI Field Name:

Reference number

Type:

Character

Length:

100

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

None

Required:

No

Editable:

Yes

UI Field Name:

Payment terms

Type:

Character

Length:

40

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

Should already exist

Required:

No

Editable:

Yes

UI Field Name:

Message

Type:

Character

Length:

1000

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

None

Required:

No

Editable:

Yes

UI Field Name:

Contract ID

Type:

Character

Length:

20

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

None

Required:

No

Editable:

Yes

UI Field Name:

Contract description

Type:

Character

Length:

80

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

None

Required:

No

Editable:

Yes

UI Field Name:

Shipping method

Type:

Character

Length:

40

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

Should already exist

Required:

No

Editable:

Yes

UI Field Name:

Ship to

Type:

Character

Length:

200

Default Value:

None

Valid Values:

Valid contact name. (This is the contact's Suggested Contact Name, which is unique across Intacct.)

Dependencies:

Should already exist

Required:

No. If none is specified, Intacct will take the default ship to contact setup in the customer record.

Editable:

Yes

UI Field Name:

Bill to

Type:

Character

Length:

200

Default Value:

None

Valid Values:

Valid contact name. (This is the contact's Suggested Contact Name, which is unique across Intacct.)

Dependencies:

Should already exist

Required:

No. If none is specified, Intacct will take the default bill to contact setup in the customer record.

Editable:

Yes

UI Field Name:

Supporting document ID

Type:

Character

Length:

20

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

Should already exist

Required:

No

Editable:

Yes

UI Field Name:

Currency

Type:

Character

Length:

3

Default Value:

Base Currency

Valid Values:

Any defined currency, such as USD or EUR; blank denotes base currency

Dependencies:

Must reference a previously defined currency

Required:

No

Editable:

Yes

Notes:

Use only in multi-currency companies. This field defines the transaction currency. If no field is defined here, the base currency is used.

UI Field Name:

Base currency

Type:

Character

Length:

3

Default Value:

None

Valid Values:

Base currency setup in Entity setup page (Company > Records > Entities)

Dependencies:

Must match the Entity's base currency.

Required:

Yes

Editable:

No

Notes:

Use only in multi-currency SHARED environments. This field defines the transaction's base currency. The Entity specified in column AE defines the base currency in this column.

UI Field Name:

Exchange ratedate

Type:

Character

Length:

40

Default Value:

None

Valid Values:

Alphanumeric and underscore

Dependencies:

Must reference a previously defined exchange rate type

Required:

Yes

Editable:

Yes

Notes:

Use only in multi-currency companies. Define an optional custom exchange rate type or Intacct can derive the exchange rate if Intacct Daily Rate is selected here.

UI Field Name:

Exchange rate type

Type:

Character

Length:

40

Default Value:

None

Valid Values:

Alphanumeric and underscore

Dependencies:

Must reference a previously defined exchange rate type

Required:

Yes

Editable:

Yes

Notes:

Use only in multi-currency companies. Define an optional custom exchange rate type or Intacct can derive the exchange rate if Intacct Daily Rate is selected here.

UI Field Name:

Exchange rate

Type:

Number

Length:

17, not including decimal point

Default Value:

Defaults to the exchange rate of the CURRENCY on the EXCHRATEDATE for the EXCHRATETYPE

Valid Values:

Positive integers

Dependencies:

None

Required:

No

Editable:

Yes

Notes:

Use only in multi-currency companies. Overrides the default exchange rate, which is the product of the CURRENCY, EXCHRATEDATE, and EXCHRATETYPE.

UI Field Name:

(Schedule) Start date

Type:

Date

Length:

10

Default Value:

None

Valid Values:

DD/MM/YYYY

Dependencies:

None

Required:

Yes

Editable:

Only if schedule has not executed any transactions

UI Field Name:

After a number of occurrences

Type:

Number

Length:

3

Default Value:

1

Valid Values:

positive integer

Dependencies:

OCCURRENCES overrides ENDDATE if both are specified.

Required:

Not required if REPEAT is set to None or ENDDATE is specified

Editable:

Yes

UI Field Name:

(Schedule) End date

Type:

Date

Length:

10

Default Value:

None

Valid Values:

DD/MM/YYYY

Dependencies:

OCCURRENCES overrides ENDDATE if both are specified

Required:

No

Editable:

Yes

UI Field Name:

Repeats

Type:

Character

Length:

6

Default Value:

Months

Valid Values:

None, Days, Weeks, Months, Years

Dependencies:

Used if OCCURENCES or ENDDATE are specified

Required:

Not required if value is set to None

Editable:

Yes

UI Field Name:

Repeat

Type:

Character

Length:

3

Default Value:

1

Valid Values:

positive integer

Dependencies:

REPEAT value

Required:

Not required if value is set to None

Editable:

Yes

UI Field Name:

End of Month

Type:

checkbox

Length:

N/A

False

Valid Values:

T = True or F = False

Dependencies:

Only used if REPEAT value is set to Months

Required:

No

Editable:

Yes

UI Field Name:

(Schedule) Status

Type:

Character

Length:

8

Default Value:

Active

Valid Values:

Active or Inactive

Dependencies:

None

Required:

No

Editable:

Yes

UI Field Name:

Line number

Type:

Number

Length:

30

Default Value:

None

Valid Values:

positive integer

Dependencies:

None

Required:

Yes

Editable:

No

Note:

Represents the entry number in the Entries section located in the Line Items tab of the recurring transaction page. For example, if the recurring transaction has three items, enter the line entry number 1,2, or 3 which represents this item in the transaction. The value assigned determine the placement of this item within the transaction. The line numbering re-starts for each new transaction.

UI Field Name:

Item ID

Type:

Character

Length:

30

Default Value:

None

Valid Values:

Alphanumeric and underscore

Dependencies:

None

Required:

Yes

Editable:

Yes

UI Field Name:

Description

Type:

Character

Length:

400

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

None

Required:

No, left blank if no value is given

Editable:

Yes

UI Field Name:

Warehouse

Type:

Character

Length:

30

Default Value:

None

Valid Values:

Alphanumeric and underscore

Dependencies:

Must refer to a valid warehouse

Required:

Yes, if item type is Inventory

Editable:

Yes

UI Field Name:

Quantity

Type:

Numeric

Length:

10

Default Value:

None

Valid Values:

Integer

Dependencies:

None

Required:

Yes

Editable:

Yes

UI Field Name:

Unit

Type:

Character

Length:

30

Default Value:

None

Valid Values:

Alphanumeric and underscore

Dependencies:

Refers to a valid unit of measure

Required:

Yes

Editable:

Yes

UI Field Name:

Price

Type:

Number

Length:

40

Default Value:

None

Valid Values:

Integer

Dependencies:

None

Required:

Yes

Editable:

Yes

UI Field Name:

Location

Type:

Character

Length:

20

Default Value:

None

Valid Values:

An existing valid location

Dependencies:

None, except in shared multi-entity companies with multiple base currencies, the LOCATION_ID must use the same currency as the BASECURR field.

Required:

No

Editable:

Yes

Notes:

In shared multi-entity companies with multiple base currencies, LOCATIONID must be in an entity that uses the same base currency as BASECURR.

UI Field Name:

Department

Type:

Alphanumeric

Length:

20

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

None

Required:

No

Editable:

Yes

UI Field Name:

Memo

Type:

Character

Length:

400

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

None

Required:

No

Editable:

Yes

UI Field Name:

Rev rec template

Type:

Alphanumeric

Length:

40

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

Refers to an existing template.

Required:

Yes, if the line is to be deferred.

Editable:

Yes

UI Field Name:

(Rev Rec) Start date

Type:

Date

Length:

10

Default Value:

None

Valid Values:

DD/MM/YYYY

Dependencies:

None

Required:

No

Editable:

Yes

UI Field Name:

(Rev Rec) End date

Type:

Date

Length:

10

Default Value:

None

Valid Values:

DD/MM/YYYY

Dependencies:

None

Required:

No

Editable:

Yes

UI Field Name:

Project (Dimensions)

Type:

Character

Length:

20

Default Value:

None

Valid Values:

Alphanumeric and underscore

Dependencies:

Should already exist

Required:

No

Editable:

Yes

UI Field Name:

Task (Dimensions)

Type:

Character

Length:

20

Default Value:

None

Valid Values:

Alphanumeric and underscore

Dependencies:

Should already exist

Required:

No

Editable:

Yes

UI Field Name:

Customer (Dimensions)

Type:

Character

Length:

20

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

Should already exist

Required:

No

Editable:

Yes

UI Field Name:

Supplier (Dimensions)

Type:

Character

Length:

21

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

Should already exist

Required:

No

Editable:

Yes

UI Field Name:

Employee (Dimensions)

Type:

Character

Length:

20

Default Value:

None

Valid Values:

Alphanumeric and underscore

Dependencies:

Refers to a valid employee

Required:

No

Editable:

Yes

UI Field Name:

Class (Dimensions)

Type:

Character

Length:

20

Default Value:

None

Valid Values:

Alphanumeric and underscore

Dependencies:

Should already exist

Required:

No

Editable:

Yes

UI Field Name:

Subtotal line number

Type:

Number

Length:

Default Value:

None

Valid Values:

positive integer

Dependencies:

None

Required:

Yes

Editable:

No

Note

Represents the subtotal entry number in the Subtotals section located at the bottom of the Line Items tab of the recurring transaction page. For example, if the recurring transaction has two subtotals, enter the line entry number 1 or 2 which represents this subtotal in the transaction. The line numbering re-starts for each new transaction.

UI Field Name:

(Subtotal) Description

Type:

Character

Length:

100

Default Value:

None

Valid Values:

Must match subtotal description setup in the transaction definition

Dependencies:

None

Required:

No

Editable:

No

UI Field Name:

(Subtotal) Value

Type:

Number

Length:

12

Default Value:

None

Valid Values:

Numeric

Dependencies:

Used when subtotal value type selected in transaction definition is Amount

Required:

No

Editable:

Yes

UI Field Name:

(Subtotal) Percent

Type:

Number

Length:

12

Default Value:

None

Valid Values:

Numeric

Dependencies:

Used when subtotal value type selected in transaction definition is Percent

Required:

No

Editable:

Yes

UI Field Name:

(Subtotal) Location

Type:

Character

Length:

20

Default Value:

None

Valid Values:

An existing valid location

Dependencies:

None, except in shared multi-entity companies with multiple base currencies, the LOCATION_ID must use the same currency as the BASECURR field.

Required:

No

Editable:

Yes

Notes:

In shared multi-entity companies with multiple base currencies, LOCATIONID must be in an entity that uses the same base currency as BASECURR.

UI Field Name:

(Subtotal) Department

Type:

Alphanumeric

Length:

20

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

None

Required:

No

Editable:

Yes

UI Field Name:

Taxable

Type:

Character

Length:

N/A

Default Value:

Derived from ITEM

Valid Values:

T = True or F = False

Dependencies:

None

Required:

No

Editable:

Yes

UI Field Name:

Payment method

Type:

Character

Length:

N/A

Default Value:

None

Valid Values:

None, Cheque, Credit Card, Record Transfer, Cash, Online ACH Debit, Online Credit Card

Dependencies:

None

Required:

No

Note:

Online ACH Debit and Online Credit Card are only valid if your company is subscribed to Payment Services.

UI Field Name:

Payment in full

Type:

Character

Length:

4

Default Value:

T (true)

Valid Values:

T = true or F = false

Dependencies:

None

Required:

Yes

Editable:

Yes

Note:

If Payment Method does not equal None, you must indicate true or false for Payment in Full.

UI Field Name:

Payment amount

Type:

Float

Length:

N/A

Default Value:

None

Valid Values:

None

Dependencies:

None

Required:

No

Editable:

Yes

Note:

If Payment in Full is false, the Payment Amount is required.

UI Field Name:

Account type

Type:

Float

Length:

N/A

Default Value:

None

Valid Values:

Bank, Undeposited Funds Account

Dependencies:

None

Required:

No

Editable:

Yes

UI Field Name:

Bank account

Type:

Character

Length:

N/A

Default Value:

None

Valid Values:

None

Dependencies:

None

Required:

No

Editable:

Yes

UI Field Name:

Credit card

Type:

Character

Length:

N/A

Default Value:

None

Valid Values:

None

Dependencies:

None

Required:

No

Editable:

Yes

UI Field Name:

Customer bank account

Type:

Character

Length:

N/A

Default Value:

None

Valid Values:

None

Dependencies:

None

Required:

No

Editable:

Yes

UI Field Name:

Undeposited funds account

Type:

Character

Length:

N/A

Default Value:

None

Valid Values:

None

Dependencies:

None

Required:

Yes

Editable:

Yes

Note:

If Account Type equals Undeposited Funds Account, the Undeposited Funds Account is required.

UI Field Name:

Card type

Type:

Character

Length:

N/A

Default Value:

None

Valid Values:

Visa, Mastercard, Discover, American Express, Diners Club

Dependencies:

None

Required:

No

Editable:

Yes