Sales Order ASCII Import File Format

Show/Hide All

The following tables illustrate the ASCII import file formats for Sales Order transactions.

For Invoice Data Entry

Field Description

Start

Length

Transaction Type (hardcode "S")

1

1

Ship Date (YYMMDD)

2

6

Sales Order Number (Alpha-Numeric Entry) pad with 0's

8

7

Item Code

15

30

Line Index Number ##### Fix$(Lineidx,0,-5) fill with spaces

45

6

Ship Quantity (######.###) Fix $(Qty,3,-10)

51

10

Lot/Serial Number - fill with spaces

61

15

Weight fix (0,.5) Numeric, NO fractions

76

5

Freight Charge (######.##) Fix (Freight .2, -9)

81

9

For Shipping Data Entry

Field Description

Start

Length

Transaction Type - "P"

1

1

Ship Date (YYMMDD)

2

6

Sales Order Number

8

7

Item Code

15

30

Line Index Number

45

6

Ship Quantity

51

10

Lot/Serial Number

61

15

Shipper ID

76

3

Package Number

79

4

For more information, see Handheld Computer File Layouts.

Field Description	Start	Length
Transaction Type (hardcode "S")	1	1
Ship Date (YYMMDD)	2	6
Sales Order Number (Alpha-Numeric Entry) pad with 0's	8	7
Item Code	15	30
Line Index Number ##### Fix$(Lineidx,0,-5) fill with spaces	45	6
Ship Quantity (######.###) Fix $(Qty,3,-10)	51	10
Lot/Serial Number - fill with spaces	61	15
Weight fix (0,.5) Numeric, NO fractions	76	5
Freight Charge (######.##) Fix (Freight .2, -9)	81	9