CSV import: Purchasing transactions

#

Any row that starts with # is ignored during import.

Field Name:

TYPE

UI Field Name:

Type

Type:

Character

Length:

30

Default Value:

None

Valid Values:

Alphanumeric and underscore

Dependencies:

Refers to a valid template name

Required:

Yes

Editable:

No

Note:

The transaction type field refers to the name of the transaction definition template. In this instance, transaction type is the same as transaction definition template name.

You can view a list of transaction definition template names by going to Purchasing > Setup > Transaction definitions.

Field Name:

DATE

UI Field Name:

Date

Type:

Date

Length:

Default Value:

None

Valid Values:

Date

Dependencies:

None

Required:

Yes

Editable:

No

Field Name:

GLPOSTINGDATE

UI Field Name:

GL Posting Date

Type:

Date

Length:

Default Value:

None

Valid Values:

Date

Dependencies:

None

Required:

Yes, if you have enabled override of GL posting date during entry on the Configure Accounts Payable page.

Editable:

Yes

Field Name:

DOCUMENTNO

UI Field Name:

Document Number

Type:

Alphanumeric

Length:

45

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

None

Required:

Yes, if you don't have auto-numbering enabled in your transaction definition

Editable

No

Field Name:

VENDOR_ID

UI Field Name:

Supplier

Type:

Alphanumeric

Length:

21

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

Refers to a valid supplier

Required:

Yes

Editable:

No

Field Name:

TERMNAME

UI Field Name:

Payment Terms

Type:

Alphanumeric

Length:

40

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

Must already exist

Required:

No

Editable:

No

Field Name:

DATEDUE

UI Field Name:

Date Due

Type:

Date

Length:

Default Value:

None

Valid Values:

Date

Dependencies:

None

Required:

Yes

Editable:

Yes

Field Name:

REFERENCENO

UI Field Name:

Reference Number

Type:

Alphanumeric

Length:

100

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

None

Required:

No

Editable:

Yes

Field Name:

MESSAGE

UI Field Name:

Message

Type:

Alphanumeric

Length:

1000

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

None

Required:

No

Editable:

No

Field Name:

SHIPPINGMETHOD

UI Field Name:

Shipping method

Type:

Character

Length:

40

Default Value:

None

Valid Values:

Alphanumeric and underscore

Dependencies:

Refers to a valid shipping method.

Required:

No

Editable:

Yes

Field Name:

UI Field Name:

Type:

Character

Length:

40

Default Value:

None

Valid Values:

Alphanumeric and underscore

Dependencies:

Refers to a valid Pay to.

Required:

No

Editable:

Yes

UI Field Name:

Type:

Character

Length:

40

Default Value:

None

Valid Values:

Alphanumeric and underscore

Dependencies:

Refers to a valid Return to.

Required:

No

Editable:

Yes

UI Field Name:

Type:

Character

Length:

40

Default Value:

None

Valid Values:

Alphanumeric and underscore

Dependencies:

Refers to a valid Deliver to.

Required:

No

Editable:

Yes

Field Name:

CURRENCY

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.

Field Name:

BASECURR

UI Field Name:

Base Currency

Type:

Character

Length:

3

Default Value:

None

Valid Values:

Any defined, three-letter ISO-4127 currency code, such as USD or EUR

Dependencies:

Must reference a previously-defined currency. Locations in line items must use the same base currency.

Required:

No, except for shared multi-entity companies with multiple base currencies.

Editable:

No

Notes:

Applies only to shared multi-entity companies with multiple base currencies. This field defines the transaction base currency. Verify that locations in line items use the same base currency.

Field Name:

EXCHRATEDATE

UI Field Name:

Exchange Rate Date

Type:

Date

Length:

10

Default Value:

Today

Valid Values:

Any valid date format

Dependencies:

None

Required:

Yes, unless you provide the EXCHANGE_RATE

Editable:

Yes

Notes:

Use only in multi-currency companies. This field determines the exchange rate as of this date.

Field Name:

EXCHRATETYPE

UI Field Name:

Exchange Rate Type

Type:

Character

Length:

40

Default Value:

Intacct Daily Rate, unless a custom exchange rate is defined as the default

Valid Values:

Alphanumeric and underscore

Dependencies:

Must reference a previously-defined exchange rate type

Required:

No

Editable:

Yes

Notes:

Use only in multi-currency companies. Defines an optional custom exchange rate type. If no rate is defined here, the Intacct Daily Rate is used.

Field Name:

EXCHRATE

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 EXCH_RATE_DATE for the EXCH_RATE_TYPE

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, EXCH_RATE_DATE, and EXCH_RATE_TYPE.

Field Name:

STATE

UI Field Name:

Transaction Status

Type:

Character

Length:

Default Value:

Draft

Valid Values:

Draft, Submitted, Pending, and Closed

Dependencies:

None

Required:

Yes

Editable:

Yes

Field Name:

NEEDBYDATE

UI Field Name:

Need by date

Type:

Date

Length:

Default Value:

None

Valid Values:

Date

Dependencies:

None

Required:

No

Editable:

Yes

Notes:

Applicable only if 'Enable shipping dates in Purchasing and Order Entry' is set to true on the Configure Inventory Control page.

Field Name:

DONOTSHIPBEFOREDATE

UI Field Name:

Do not ship before date

Type:

Date

Length:

Default Value:

None

Valid Values:

Date

Dependencies:

None

Required:

No

Editable:

Yes

Notes:

Applicable only if 'Enable shipping dates in Purchasing and Order Entry' is set to true on the Configure Inventory Control page.

Field Name:

DONOTSHIPAFTERDATE

UI Field Name:

Do not ship after date

Type:

Date

Length:

Default Value:

None

Valid Values:

Date

Dependencies:

None

Required:

No

Editable:

Yes

Notes:

Applicable only if 'Enable shipping dates in Purchasing and Order Entry' is set to true on the Configure Inventory Control page.

Field Name:

PROMISEDDATE

UI Field Name:

Promised by date

Type:

Date

Length:

Default Value:

None

Valid Values:

Date

Dependencies:

None

Required:

No

Editable:

Yes

Notes:

Applicable only if 'Enable shipping dates in Purchasing and Order Entry' is set to true on the Configure Inventory Control page.

Field Name:

CONTRACTSTARTDATE

UI Field Name:

Contract start date

Type:

Date

Length:

Default Value:

None

Valid Values:

Date

Dependencies:

None

Required:

No

Editable:

Yes

Notes:

Applicable only if 'Enable shipping dates in Purchasing and Order Entry' is set to true on the Configure Inventory Control page.

Field Name:

CONTRACTENDDATE

UI Field Name:

Contract end date

Type:

Date

Length:

Default Value:

None

Valid Values:

Date

Dependencies:

None

Required:

No

Editable:

Yes

Notes:

Applicable only if 'Enable shipping dates in Purchasing and Order Entry' is set to true on the Configure Inventory Control page.

Field Name:

CANCLEAFTERDATE

UI Field Name:

Cancel after date

Type:

Date

Length:

Default Value:

None

Valid Values:

Date

Dependencies:

None

Required:

No

Editable:

Yes

Notes:

Applicable only if 'Enable shipping dates in Purchasing and Order Entry' is set to true on the Configure Inventory Control page.

Field Name:

LINE

UI Field Name:

Type:

Number

Length:

Default Value:

None

Valid Values:

Number

Dependencies:

None

Required:

Yes

Editable:

No

Field Name:

ITEM_ID

UI Field Name:

Item ID

Type:

Character

Length:

30

Default Value:

None

Valid Values:

Alphanumeric and underscore

Dependencies:

Refers to a valid item ID

Required:

Yes

Editable:

Yes

Field Name:

ITEMDESC

UI Field Name:

Item Description

Type:

Character

Length:

100

Default Value:

None

Valid Values:

Alphanumeric and underscore

Dependencies:

None

Required:

No

Editable:

Yes

Field Name:

ITEMALIASID

UI Field Name:

Cross-reference item ID

Type:

Character

Length:

30

Default Value:

None

Valid Values:

Alphanumeric and underscore

Dependencies:

Refers to a valid cross-reference item ID

Required:

No

Editable:

Yes

Field Name:

WAREHOUSEID

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 the item type is Inventory or Stockable Kit

Editable:

Yes

Field Name:

QUANTITY

UI Field Name:

Quantity

Type:

Numeric

Length:

8

Default Value:

None

Valid Values:

Integer

Dependencies:

None

Required:

Yes

Editable:

Yes

Field Name:

UNIT

UI Field Name:

Unit

Type:

Character

Length:

N/A

Default Value:

Count

Valid Values:

Count, Length, Time, Volume, Weight, etc.

Dependencies:

Valid unit

Required:

Yes

Editable:

Yes

Field Name:

PRICE

UI Field Name:

Price

Type:

Numeric

Length:

10,2

Default Value:

0

Valid Values:

Decimal

Dependencies:

None

Required:

No

Editable:

Yes

Field Name:

ENTRY_DELIVERTO

UI Field Name:

Deliver to

Type:

Character

Length:

N/A

Default Value:

None

Valid Values:

Alphanumeric and underscore

Dependencies:

None

Required:

No

Editable:

Yes

Field Name:

TAXABLE

UI Field Name:

Taxable

Type:

Character

Length:

N/A

Default Value:

Derived from ITEM

Valid Values:

T or F (for true or false respectively)

Dependencies:

None

Required:

No

Editable:

Yes

Field Name:

DEPARTMENTID

UI Field Name:

Department

Type:

Alphanumeric

Length:

20

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

None

Required:

No

Editable:

No

Field Name:

LOCATIONID

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, if the transaction is not partially or fully paid, or partially or fully converted.

Notes:

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

Field Name:

PODOCUMENTENTRY_CLASSID

UI Field Name:

Class

Type:

Alphanumeric

Length:

20

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

Refers to a valid class

Required:

No

Editable:

No

Field Name:

PODOCUMENTENTRY_PROJECTID

UI Field Name:

Project

Type:

Alphanumeric

Length:

20

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

Refers to a valid project

Required:

No

Editable

No

Field Name:

PODOCUMENTENTRY_CUSTOMERID

UI Field Name:

Customer

Type:

Alphanumeric

Length:

20

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

Refers to a valid customer

Required:

No

Editable

No

Field Name:

PODOCUMENTENTRY_EMPLOYEEID

UI Field Name:

Employee

Type:

Alphanumeric

Length:

20

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

Refers to a valid employee

Required:

No

Editable

No

Field Name:

PODOCUMENTENTRY_VENDORID

UI Field Name:

Supplier

Type:

Alphanumeric

Length:

20

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

Refers to a valid supplier

Required:

No

Editable:

No

Field Name:

SUB_LINE_NO

UI Field Name:

Type:

Number

Length:

Default Value:

None

Valid Values:

Number

Dependencies:

None

Required:

Yes, if you have subtotals for your transaction

Editable:

Yes

Field Name:

SUBDESC

UI Field Name:

Description

Type:

Alphanumeric and underscore

Note:

Must match the description available in your subtotals

Field Name:

ABSVAL

UI Field Name:

Transaction Value

Type:

Numeric

Length:

10,2

Default Value:

0

Valid Values:

Decimal

Dependencies:

None

Required:

No

Editable:

Yes

Field Name:

PERCENTVAL

UI Field Name:

Percent

Type:

Character

Length:

3.2

Default Value:

None

Valid Values:

Numbers

Dependencies:

None

Required:

No

Editable:

Yes

Field Name:

SUBLOCATIONID

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, if the AP supplier invoice is not partially or fully paid

Notes:

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

Field Name:

SUBDEPARTMENTID

UI Field Name:

Department

Type:

Alphanumeric

Length:

20

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

None

Required:

No

Editable

No

Field Name:

UI Field Name:

Class

Type:

Alphanumeric

Length:

20

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

Refers to a valid class

Required:

No

Editable:

No

Used to designate the Class ID on a purchase order.

Field Name:

PODOCUMENTSUBTOTALS_PROJECTID

UI Field Name:

Project

Type:

Alphanumeric

Length:

20

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

Refers to a valid project

Required:

No

Editable

No

Used to designate the Project ID on a purchase order.

Field Name:

PODOCUMENTSUBTOTALS_CUSTOMERID

UI Field Name:

Customer

Type:

Alphanumeric

Length:

20

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

Refers to a valid customer

Required:

No

Editable

No

Used to designate the Customer ID on a purchase order.

Field Name:

PODOCUMENTSUBTOTALS_EMPLOYEEID

UI Field Name:

Employee

Type:

Alphanumeric

Length:

20

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

Refers to a valid employee

Required:

No

Editable

No

Used to designate the Employee ID on a purchase order.

Field Name:

PODOCUMENTSUBTOTALS_VENDORID

UI Field Name:

Supplier

Type:

Alphanumeric

Length:

20

Default Value:

None

Valid Values:

Alphanumeric

Dependencies:

Refers to a valid supplier

Required:

No

Editable:

No

Used to designate the Supplier ID on a purchase order.

UI Field Name:

Type:

Length:

Required:

UI Field Name:

Type:

Length:

Required:

UI Field Name:

Type:

Length:

Required:

UI Field Name:

Type:

Default Value:

Valid Values:

T (True), F (False)

Required:

UI Field Name:

Type:

Default Value:

Valid Values:

T (True), F (False)

Required:

UI Field Name:

Type:

Default Value:

Valid Values:

Required:

Notes:

UI Field Name:

Type:

Length:

Valid Values:

Required:

Notes:

Field Name:

Lot tracking can have multiple units in a given lot. Use the TRACK_QUANTITY column to define the quantity.

For example: The total quantity of the line is 10 units, but 6 units are in LOTNO Apple and 4 units are in LOTNO Banana. The 6 and 4 are defined in the TRACK_QUANTITY field.

Field Name:

Field Name:

Field Name:

Field Name:

Field Name:

Field Name:

Field Name:

Required:

Field Name:

PODOCUMENTENTRY_NEEDBYDATE

UI Field Name:

Need by date

Type:

Date

Length:

Default Value:

None

Valid Values:

Date

Dependencies:

None

Required:

No

Editable:

Yes

Notes:

Applicable only if 'Enable shipping dates in Purchasing and Order Entry' is set to true on the Configure Inventory Control page.

Field Name:

PODOCUMENTENTRY_DONOTSHIPBEFOREDATE

UI Field Name:

Do not ship before date

Type:

Date

Length:

Default Value:

None

Valid Values:

Date

Dependencies:

None

Required:

No

Editable:

Yes

Notes:

Applicable only if 'Enable shipping dates in Purchasing and Order Entry' is set to true on the Configure Inventory Control page.

Field Name:

PODOCUMENTENTRY_DONOTSHIPAFTERDATE

UI Field Name:

Do not ship after date

Type:

Date

Length:

Default Value:

None

Valid Values:

Date

Dependencies:

None

Required:

No

Editable:

Yes

Notes:

Applicable only if 'Enable shipping dates in Purchasing and Order Entry' is set to true on the Configure Inventory Control page.

Field Name:

PODOCUMENTENTRY_PROMISEDDATE

UI Field Name:

Promised by date

Type:

Date

Length:

Default Value:

None

Valid Values:

Date

Dependencies:

None

Required:

No

Editable:

Yes

Notes:

Applicable only if 'Enable shipping dates in Purchasing and Order Entry' is set to true on the Configure Inventory Control page.

Field Name:

PODOCUMENTENTRY_DATECONFIRMED

UI Field Name:

Date confirmed

Type:

Date

Length:

Default Value:

None

Valid Values:

Date

Dependencies:

None

Required:

No

Editable:

Yes

Notes:

Applicable only if 'Enable shipping dates in Purchasing and Order Entry' is set to true on the Configure Inventory Control page.

Field Name:

PODOCUMENTENTRY_CANCLEAFTERDATE

UI Field Name:

Cancel after date

Type:

Date

Length:

Default Value:

None

Valid Values:

Date

Dependencies:

None

Required:

No

Editable:

Yes

Notes:

Applicable only if 'Enable shipping dates in Purchasing and Order Entry' is set to true on the Configure Inventory Control page.

Field Name:

PODOCUMENTENTRY_DATESHIPTOSUPPLIER

UI Field Name:

Date shipped to supplier

Type:

Date

Length:

Default Value:

None

Valid Values:

Date

Dependencies:

None

Required:

No

Editable:

Yes

Notes:

Applicable only if 'Enable shipping dates in Purchasing and Order Entry' is set to true on the Configure Inventory Control page.

UI Field Name:

Asset creation

Type:

Character

Length:

1

Default Value:

S

Valid Values:

S, M, N (S = Create fixed asset, M = Create multiple fixed assets, N = Do not create asset)

Dependencies:

None

Required:

No

Editable:

No

UI Field Name:

Number of assets

Type:

Number

Length:

10

Default Value:

None

Valid Values:

Digits 0-9

Dependencies:

None

Required:

No

Editable:

No