Import file format

This table shows the format that is required for the CSV file. The file must contain a header row that contains the header names in the order that is shown in the table. The header names must be spelled correctly. If a line does not have a value for an element, the file must contain a placeholder, which is a comma, for that element. You can use a text editor, such as Notepad, or Excel to edit the CSV file.

Element number

Header name

Data

Required element

Example

1

lineNumber

Line number

Yes

1

2

poNumber

Purchase order number

Yes

1234-00

3

packList

Packing list number

No

1

4

recvAsComplete

Receive line as complete: yes = TRUE, no = FALSE

No

TRUE

5

recvDate

Receipt date and time. If blank, updated with import date and time.

No

2012-08-29 14:35:18.493

6

productNumber

ERP, Customer, or Vendor product number

Yes

1-001

7

receivedQuantity

Receipt quantity

Yes*

4

8

InspectionRequired

Is an inspection required: true or false

No

FALSE

9

unavailable

Is product unavailable: true or false

Yes

TRUE

10

unavailableReason Code

Unavailable reason code

No

d

11

warehouse

Warehouse ID

Yes

abc1

* If the product is a serial- or lot-controlled product with different units of measure (UOM) in Storeroom and Distribution SX.e, the Distribution SX.e UOM is used in the file.