EDI Order Import Format

ASIAUD

x

Auditing Record

x

ASIAUD

String

1

6

n/a

x

Form Type "850 "

String

7

6

ST01

edi-xref.form-type

x

Standards Version

String

13

12

GS08

edi-xref.standard-version

x

EDI Standards Agency Code

String

25

1

GS07

x

Trade ID

String

26

35

ISA06

edi-partner.trade-id

x

Orig=00 Conf=06 Dup=07

Number

61

2

BEG01

(orig-dup)

Test/Production Flag

String

63

1

Import Date

Date (MM/DD/YYYY)

64

10

x

Store ID

String

74

20

oe-address.store-id

Archive ID

String

94

8

etm-archive-hdr.archive-id

ASIHDR

x

Header Record

x

ASIHDR

String

1

6

n/a

Customer Code

String

7

12

Purchase Order Date

Date (MM/DD/YYYY)

19

10

BEG05

oe-header.order-date

x

Purchase Order Number

String

29

20

BEG03

oe-header.cust-po-number

Purchase Order Type

String

49

8

BEG02

oe-header.order-class

Preferred Shipper

String

57

12

TD505

oe-header.preferred-shipper

Currency

String

69

3

CUR02

oe-header.entered-currency/oe-header.convert-to-currency

Ship Order By Date

Date (MM/DD/YYYY)

72

10

DTM02

oe-header.required-date

Cancel Order By Date

Date (MM/DD/YYYY)

82

10

DTM02

oe-trailer.cancel-after-date

Sales Contract

String

92

20

BEG06

oe-header.contract-key

Purchase Order Terms

String

112

12

TIA01

oe-header.internal-terms-key

Header Shipping Location

String

124

8

N104

oe-header.shipping-location-key

Header Selling Location

String

132

8

N104

oe-header.sales-location-key

Standard Carrier Alpha Code

String

140

12

Department Number

String

152

30

REF02

oe-header.dept-num

Internal Vendor Code (EDI)

String

182

20

REF02

oe-header.edi-internal-vendor

Order Placer

String

202

30

oe-header.order-placer

Order Placer Phone Number

String

232

12

oe-header.order-placer-phone

User Defined Field 1

String

244

8

oe-header.edi-spare-1

User Defined Field 2

String

252

8

oe-header.edi-spare-2

User Defined Field 3

String

260

8

oe-header.edi-spare-3

User Defined Field 4

String

268

8

oe-header.edi-spare-4

User Defined Field 5

String

276

8

oe-header.edi-spare-5

Supplier Code

String

284

15

supp-by-user.supplier-code

Sale Type

String

299

8

oe-header.sale-type

NOTE If this is blank, it defaults from the EDI trading partner associated with the order. If the order does not have an associated EDI trading partner or the trading partner does not have a default sales type, this defaults to the default sales type for your user ID (entered in User Extended Options).

User Defined Date Field 1

String

307

10

oe-header.user-date-1

User Defined Date Field 2

String

317

10

oe-header.user-date-2

User Defined Date Field 3

String

327

10

oe-header.user-date-3

User Defined Date Field 4

String

337

10

oe-header.user-date-4

User Defined Date Field 5

String

347

10

oe-header.user-date-5

User Defined Date Field 6

String

357

10

oe-header.user-date-6

User Defined Date Field 7

String

367

10

oe-header.user-date-7

User Defined Date Field 8

String

377

10

oe-header.user-date-8

User Defined Date Field 9

String

387

10

oe-header.user-date-9

User Defined Date Field 10

String

397

10

oe-header.user-date-10

Consignment-field

String

407

8

Assign to "Consign" to make the order a consignment order

Earliest Ship Date

Date (MM/DD/YYYY)

415

10

oe-header.earliest-ship-date

Latest Ship Date

Date (MM/DD/YYYY)

425

10

oe-header.latest-ship-date

FOB

String

435

8

fob.fob-code

Cancel Backorder

String

443

1

oe-trailer.cancel-backorder

Misc Data 1

String

444

60

oe-header.misc-data-1

Misc Data 2

String

504

60

oe-header.misc-data-2

Shipping Method

String

564

8

oe-header.shipping-method

Freight Collection Terms

String

572

20

oe-header.freight-collection-terms

VAT Taxable

String

592

1

oe-header.vat-taxable

VAT Reason Code DNU

String

593

12

vat-reason.vat-reason-code

Alternate PO

String

605

60

oe-header.alternate-po

User Defined Import Warning

String

665

80

order-import-warning.warn-message

Acknowledgment Option

String

745

4

Assign to trigger order acknowledgment tasks

Original Customer PO

String

749

20

This is not used for inbound 850's.

Commission Billing Customer Code

String

769

12

Drop-ship commission billing customer code

Sales Order Customer Purchase Order Number

String

781

20

This is not used for inbound 850's.

Sales Order Customer Code

String

801

12

This is not used for inbound 850's.

Sales Order Customer Name

String

813

40

This is not used for inbound 850's.

Sales Order Billing Customer Code

String

853

12

This is not used for inbound 850's.

Sales Order Billing Customer Name

String

865

40

This is not used for inbound 850's.

Sales Order Created Date

Date (MM/DD/YYYY)

905

10

This is not used for inbound 850's.

Sales Order Order Date

Date (MM/DD/YYYY)

915

10

This is not used for inbound 850's.

Sales Order Required Date

Date (MM/DD/YYYY)

925

10

This is not used for inbound 850's.

Sales Order Trade ID

String

935

25

This is not used for inbound 850's.

Purchase Order Buyer

String

960

12

This is not used for inbound 850's.

Supplier Name

String

972

40

This is not used for inbound 850's.

Originating Country

String

1012

10

This is not used for inbound 850's.

Supplier's Confirming Order Number

String

1022

12

This is not used for inbound 850's.

Purchase Order Class

String

1034

10

This is not used for inbound 850's.

Purchase Order Ship Date

Date (MM/DD/YYYY)

1044

10

This is not used for inbound 850's.

Purchase Order Delivery Date

Date (MM/DD/YYYY)

1054

10

This is not used for inbound 850's.

Purchase Order Final Change Date

Date (MM/DD/YYYY)

1064

10

This is not used for inbound 850's.

Ship To EDI Address Code

String

1074

30

This is not used for inbound 850's.

Ship to Store Number

String

1104

20

This is not used for inbound 850's.

Bill To EDI Address Code

String

1124

30

Generate 870

String

1154

4

oe-header.generate-870

Freight Cap Percentage

String

1160

6

Used in calculation of freight

Shipper Account ID

String

1166

20

oe-address.ups-account-num

Excise ID

String

1186

30

oe-address.excise-id

VAT Reason Code

String

1216

20

vat-reason.vat-reason-code

Shipper ID

String

1236

50

TD505

oe-header.preferred-shipper

NOTE This gap in the field position is reserved for additional fields in future releases of Apprise.

User Defined 1

String

1300

100

oe-header.user-defined-1

User Defined 2

String

1400

100

oe-header.user-defined-2

User Defined 3

String

1500

100

oe-header.user-defined-3

User Defined 4

String

1600

100

oe-header.user-defined-4

User Defined 5

String

1700

100

oe-header.user-defined-5

User Defined 6

String

1800

100

oe-header.user-defined-6

User Defined 7

String

1900

100

oe-header.user-defined-7

User Defined 8

String

2000

100

oe-header.user-defined-8

User Defined 9

String

2100

100

oe-header.user-defined-9

User Defined 10

String

2200

100

oe-header.user-defined-10

User Defined 11

String

2300

100

oe-header.user-defined-11

User Defined 12

String

2400

100

oe-header.user-defined-12

User Defined 13

String

2500

100

oe-header.user-defined-13

User Defined 14

String

2600

100

oe-header.user-defined-14

User Defined 15

String

2700

100

oe-header.user-defined-15

User Defined 16

String

2800

100

oe-header.user-defined-16

User Defined 17

String

2900

100

oe-header.user-defined-17

User Defined 18

String

3000

100

oe-header.user-defined-18

User Defined 19

String

3100

100

oe-header.user-defined-19

User Defined 20

String

3200

100

oe-header.user-defined-20

Supplier User Defined 1

String

3300

100

This is not used for inbound 850's.

Supplier User Defined 2

String

3400

100

This is not used for inbound 850's.

Supplier User Defined 3

String

3500

100

This is not used for inbound 850's.

Supplier User Defined 4

String

3600

100

This is not used for inbound 850's.

Supplier User Defined 5

String

3700

100

This is not used for inbound 850's.

Supplier User Defined 6

String

3800

100

This is not used for inbound 850's.

Supplier User Defined 7

String

3900

100

This is not used for inbound 850's.

Supplier User Defined 8

String

4000

100

This is not used for inbound 850's.

Supplier User Defined 9

String

4100

100

This is not used for inbound 850's.

Supplier User Defined 10

String

4200

100

This is not used for inbound 850's.

Supplier User Defined 11

String

4300

100

This is not used for inbound 850's.

Supplier User Defined 12

String

4400

100

This is not used for inbound 850's.

Supplier User Defined 13

String

4500

100

This is not used for inbound 850's.

Supplier User Defined 14

String

4600

100

This is not used for inbound 850's.

Supplier User Defined 15

String

4700

100

This is not used for inbound 850's.

Supplier User Defined 16

String

4800

100

This is not used for inbound 850's.

Supplier User Defined 17

String

4900

100

This is not used for inbound 850's.

Supplier User Defined 18

String

5000

100

This is not used for inbound 850's.

Supplier User Defined 19

String

5100

100

This is not used for inbound 850's.

Supplier User Defined 20

String

5200

100

This is not used for inbound 850's.

Residential Delivery

String

5300

6

oe-header.residential-delivery

Saturday Delivery

String

5306

6

oe-header.saturday-delivery

Call Before Delivery

String

5312

6

oe-header.call-before-delivery

Liftgate Delivery

String

5318

6

oe-header.liftgate-delivery

Inside Delivery

String

5324

6

oe-header.inside-delivery

Sign Required

String

5330

6

oe-header.sign-required

EDI Order Date

Date (MM/DD/YYYY)

5336

10

oe-header.edi-order-date

EDI Order Time

Time (HH:MM:SS)

5346

8

oe-header.edi-order-time

ASIBTA

Bill To Address Record

x

ASIBTA

String

1

6

n/a

Bill To Code

String

7

16

N101

oe-address.edi-address-code

Bill To Name

String

23

35

N102

oe-address.name

Bill To Address Line 1

String

58

30

N301

oe-address.address1

NOTE There is a five character gap after this field.

Bill To Address Line 2

String

93

30

N302

oe-address.address2

NOTE There is a five character gap after this field.

Bill To Address Line 3

String

128

30

oe-address.address3

NOTE There is a five character gap after this field.

Bill To City

String

163

30

N401

oe-address.city (imported data is limited to 25 characters)

Bill To State

String

193

2

N402

oe-address.state

Bill To Postal Code

String

195

12

N403

oe-address.postal-code

Bill To Country

String

207

20

N404

oe-address.country

Bill To Phone

String

227

12

PER04

oe-address.phone

Bill To Fax

String

239

12

PER06

oe-address.fax

Bill To Contact

String

251

30

PER02

oe-address.contact

Importer of Record Number

String

281

20

oe-address.importer-of-record-number

Bill To Name

String

301

40

N102

oe-address.name

Bill To Address Line 3

String

341

35

This is not used for inbound 850's.

Bill To Email

String

376

150

oe-address.email-address

ASISTA

Ship To Address Record

x

ASISTA

String

1

6

n/a

Ship To Code

String

7

16

N101

oe-address.edi-address-code

Ship To Name

String

23

35

N102

oe-address.name

Ship To Address Line 1

String

58

30

N301

oe-address.address1

NOTE There is a five character gap after this field.

Ship To Address Line 2

String

93

30

N302

oe-address.address2

NOTE There is a five character gap after this field.

Ship To Address Line 3

String

128

30

oe-address.address3

NOTE There is a five character gap after this field.

Ship To City

String

163

30

N401

oe-address.city

Ship To State

String

193

2

N402

oe-address.state

Ship To Postal Code

String

195

12

N403

oe-address.postal-code

Ship To Country

String

207

20

N404

oe-address.country

Ship To Phone

String

227

12

PER04

oe-address.phone

Ship To Fax

String

239

12

PER06

oe-address.fax

Ship To Contact

String

251

30

PER02

oe-address.contact

Fulfillment Ship To

String

281

1

Y or N to populate Ship To address on sales order with above

Tax Jurisdiction

String

282

12

oe-jurisdiction.jurisdiction

NOTE If the system is integrated with AvaTax, leave this field blank. The system automatically sets the value for this field as None.

Ship To Store ID

String

294

20

oe-address.store-id

Ship To Name

String

314

40

N102

oe-address.name

Ship To Email

String

354

150

oe-address.email-address

Ship To Excise ID

String

504

30

This is not used for inbound orders.

Ship To VAT Group

String

534

20

oe-address.reserved-standard

Tax Exemption

String

554

1

oe-address.tax-exempt

State/Province Tax Exempt Number

String

555

20

oe-address.tax-id

Entity Use Code

String

575

25

oe-address.entity-use-code

ASIHPL

Order Pack List Information Record

x

ASHPL

String

1

6

Hardcoded

Order Date

String

7

10

oe-pack-list-hdr.order-date

Order Number

String

17

50

oe-pack-list-hdr.cust-order-num

Sales Division

String

67

30

oe-pack-list-hdr.sales-division

Customer Name

String

97

50

oe-pack-list-hdr.cust-name

Customer Number

String

147

50

oe-pack-list-hdr.cust-num

Shipping Method

String

197

60

oe-pack-list-hdr.shipping-method

Payment Method

String

257

50

oe-pack-list-hdr.payment-method

Credit Type

String

307

50

oe-pack-list-hdr.credit-type

CC last X

String

357

20

oe-pack-list-hdr.cc-last-x

Tax Type

String

377

50

oe-pack-list-hdr.tax-type

Return Code

String

427

50

oe-pack-list-hdr.return-code

Receipt ID

String

477

50

oe-pack-list-hdr.receipt-id

Warehouse ID

String

527

50

oe-pack-list-hdr.warehouse-id

Contract Code

String

577

50

oe-pack-list-hdr.contract-code

Transaction Code

String

627

50

oe-pack-list-hdr.transaction-code

Store Number

String

677

50

oe-pack-list-hdr.store-num

Registry Number

String

727

50

oe-pack-list-hdr.registry-num

Reservation Number

String

777

50

oe-pack-list-hdr.reservation-num

Buyer's Catalog Number

String

827

50

oe-pack-list-hdr.buyer-catalog-num

Phone Number

String

877

30

oe-pack-list-hdr.phone

Email Address

String

907

300

oe-pack-list-hdr.email-address

Web Site

String

1207

100

oe-pack-list-hdr.web-site

Work Hours

String

1307

100

oe-pack-list-hdr.work-hours

Sold-to Name

String

1407

40

oe-address.name(address-type = Sold To)

Sold-to Company

String

1447

40

oe-address.company(address-type = Sold To)

Sold-to Address 1

String

1487

60

oe-address.address1(address-type = Sold To)

Sold-to Address 2

String

1547

60

oe-address.address2(address-type = Sold To)

Sold-to Address 3

String

1607

60

oe-address.address3(address-type = Sold To)

Sold-to City

String

1667

40

oe-address.city(address-type = Sold To)

Sold-to State

String

1707

30

oe-address.state(address-type = Sold To)

Sold-to Postal Code

String

1737

30

oe-address.postal-code(address-type = Sold To)

Sold-to Country

String

1767

30

oe-address.country(address-type = Sold To)

Sold-to Phone

String

1797

30

oe-address.phone(address-type = Sold To)

Ship-to Company

String

1827

40

oe-address.company(address-type = Ship To)

Shipping and Handling

Number

1867

20

oe-pack-list-hdr.shipping-handling

Shipping Fee

Number

1887

20

oe-pack-list-hdr.shipping-fee

Tax Amount

Number

1907

20

oe-pack-list-hdr.tax-amount

Discount Amount

Number

1927

20

oe-pack-list-hdr.discount-amount

Gift Box

Number

1947

20

oe-pack-list-hdr.gift-box

Merchandise Cost

Number

1967

20

oe-pack-list-hdr.merch-cost

Order Total Amount

Number

1987

20

oe-pack-list-hdr.order-total-amount

Gift Message

String

2007

1000

oe-pack-list-hdr.gift-message

Pack List Message

String

3007

1000

oe-pack-list-hdr.pack-list-message

Order Message1

String

4007

1000

oe-pack-list-hdr.order-message1

Order Message2

String

5007

1000

oe-pack-list-hdr.order-message2

Order Message3

String

6007

1000

oe-pack-list-hdr.order-message3

Order Message4

String

7007

1000

oe-pack-list-hdr.order-message4

Order Message5

String

8007

1000

oe-pack-list-hdr.order-message5

Packing List URL

String

9007

1000

oe-pack-list-hdr.pack-list-url

ASILIN

x

Line Item Record

x

ASILIN

String

1

6

n/a

x

Purchase Order Number

String

7

12

PO101

used to be oe-trailer.po-num

x

Product Code

String

19

40

PO107

oe-trailer.product-code

Product Description

String

59

30

PID05

oe-trailer.line-item-name

x

Qty Ordered

Number

89

15

PO102

oe-trailer.qty-ordered

Unit Of Measure

String

104

4

PO103

oe-trailer.um

Unit Price

Number

108

15

PO104

oe-trailer.unit-price

Commodity Code

String

123

8

TC202

oe-trailer.commodity-code

Line Item Shipping Location

String

131

8

SDQ03

oe-trailer.shipping-location-key

Ship Order By Date

Date (MM/DD/YYYY)

139

10

DTM02

This field is not used. The order required date is used for all line items.

Cancel Order By Date

Date (MM/DD/YYYY)

149

10

DTM02

oe-trailer.cancel-after-date (if different than header level)

User Defined Field 1

String

159

8

oe-trailer.edi-spare-1

User Defined Field 2

String

167

8

oe-trailer.edi-spare-2

User Defined Field 3

String

175

8

oe-trailer.edi-spare-3

User Defined Field 4

String

183

8

oe-trailer.edi-spare-4

User Defined Field 5

String

191

8

oe-trailer.edi-spare-5

Drop Ship Flag

String

199

1

oe-trailer.drop-ship

Drop Ship Supplier ID

String

200

15

oe-trailer.drop-ship-supp-code

Unit of Measure Code

String

215

8

um.um-code (first validate the short unit of measure in position 104, then this unit of measure)

Miscellaneous Data 1

String

223

60

oe-trailer.misc-data-1

Miscellaneous Data 2

String

283

60

oe-trailer.misc-data-2

Cancel Backorder

String

343

1

oe-trailer.cancel-backorder

SDQ line item ship-to

String

344

4

Not stored in Apprise

Direct Ship

String

348

1

oe-trailer.direct-ship

VAT Taxable

String

349

1

oe-trailer.vat-taxable

VAT Reason Code DNU

String

350

12

oe-trailer.vat-reason-key

Price Includes VAT

String

362

1

oe-trailer.entered-price-vat-inclusive

Sales Contract

String

363

20

oe-trailer.contract-key

Purchase Order Line Number

String

383

20

oe-trailer.edi-order-line-num

Customer Product Code

String

403

40

This is not used for inbound 850's.

Customer Product Name

String

443

40

This is not used for inbound 850's.

Customer Product UPC

String

483

20

This is not used for inbound 850's.

UPC

String

503

25

This is not used for inbound 850's.

GTIN

String

528

14

This is not used for inbound 850's.

Purchase Order Ship Date

Date (MM/DD/YYYY)

542

10

This is not used for inbound 850's.

Purchase Order Delivery Date

Date (MM/DD/YYYY)

552

10

This is not used for inbound 850's.

Purchase Order Required Date

Date (MM/DD/YYYY)

562

10

This is not used for inbound 850's.

Ship Via

String

572

12

This is not used for inbound 850's.

Country of Origin

String

584

10

This is not used for inbound 850's.

Supplier Product Code

String

606

40

This is not used for inbound 850's.

Supplier Product Name

String

646

30

This is not used for inbound 850's.

Sales Order Mark For Store ID

String

676

20

This is not used for inbound 850's.

Sales Order Mark For Customer Name

String

696

40

This is not used for inbound 850's.

Sales Order Mark For Address 1

String

736

60

This is not used for inbound 850's.

Sales Order Mark For Address 2

String

796

60

This is not used for inbound 850's.

Sales Order Mark For Address 3

String

856

60

This is not used for inbound 850's.

Sales Order Mark For City

String

916

36

This is not used for inbound 850's.

Sales Order Mark For State

String

952

3

This is not used for inbound 850's.

Sales Order Mark For Postal Code

String

955

30

This is not used for inbound 850's.

Sales Order Mark For Country

String

985

20

This is not used for inbound 850's.

Sales Order Mark For Phone

String

1005

16

This is not used for inbound 850's.

Sales Order Mark For Fax

String

1021

16

This is not used for inbound 850's.

Sales Order Mark For Attention

String

1037

36

This is not used for inbound 850's.

Sales Order Mark For County

String

1073

36

This is not used for inbound 850's.

Sales Contract Line

String

1109

4

oe-trailer.contract-line-num

Combo Price Class

String

1113

20

oe-price-class.price-class-name

Container Code

String

1133

12

This is not used for inbound 850's.

Container Type

String

1145

20

This is not used for inbound 850's.

From Port Code

String

1165

15

This is not used for inbound 850's.

From Port Name

String

1180

30

This is not used for inbound 850's.

To Port Code

String

1210

15

This is not used for inbound 850's.

To Port Name

String

1225

30

This is not used for inbound 850's.

Commission Cost Charge Type

String

1255

12

oe-trailer.comm-cost-chrg-type

NOTE If this is blank in the import file, it defaults from the product/location.

VAT Reason Code

String

1267

20

oe-trailer.vat-reason-key

NOTE This gap in the field position is reserved for additional fields in future releases of Apprise.

User Defined 1

String

1300

100

oe-trailer.user-defined-1

User Defined 2

String

1400

100

oe-trailer.user-defined-2

User Defined 3

String

1500

100

oe-trailer.user-defined-3

User Defined 4

String

1600

100

oe-trailer.user-defined-4

User Defined 5

String

1700

100

oe-trailer.user-defined-5

User Defined 6

String

1800

100

oe-trailer.user-defined-6

User Defined 7

String

1900

100

oe-trailer.user-defined-7

User Defined 8

String

2000

100

oe-trailer.user-defined-8

User Defined 9

String

2100

100

oe-trailer.user-defined-9

User Defined 10

String

2200

100

oe-trailer.user-defined-10

User Defined 11

String

2300

100

oe-trailer.user-defined-11

User Defined 12

String

2400

100

oe-trailer.user-defined-12

User Defined 13

String

2500

100

oe-trailer.user-defined-13

User Defined 14

String

2600

100

oe-trailer.user-defined-14

User Defined 15

String

2700

100

oe-trailer.user-defined-15

User Defined 16

String

2800

100

oe-trailer.user-defined-16

User Defined 17

String

2900

100

oe-trailer.user-defined-17

User Defined 18

String

3000

100

oe-trailer.user-defined-18

User Defined 19

String

3100

100

oe-trailer.user-defined-19

User Defined 20

String

3200

100

oe-trailer.user-defined-20

Harmonization Code

String

3300

20

This is not used for inbound 850's.

ASISDQ

Destination Quantity Record

NOTE You can have up to 500 ASISDQ segments per ASILIN segment. This is only used for SDQ maps.

x

ASISDQ

String

1

6

n/a

x

Unit Of Measure

String

7

4

SDQ01

Ship To Code

String

11

16

SDQ03

Ship To Quantity

Number

27

15

SDQ04

Ship To Code

String

42

16

SDQ05

Ship To Quantity

Number

58

15

SDQ06

Ship To Code

String

73

16

SDQ07

Ship To Quantity

Number

89

15

SDQ08

Ship To Code

String

104

16

SDQ09

Ship To Quantity

Number

120

15

SDQ10

Ship To Code

String

135

16

SDQ11

Ship To Quantity

Number

151

15

SDQ12

Ship To Code

String

166

16

SDQ13

Ship To Quantity

Number

182

15

SDQ14

Ship To Code

String

197

16

SDQ15

Ship To Quantity

Number

213

15

SDQ16

Ship To Code

String

228

16

SDQ17

Ship To Quantity

Number

244

15

SDQ18

Ship To Code

String

259

16

SDQ19

Ship To Quantity

Number

275

15

SDQ20

Ship To Code

String

290

16

SDQ21

Ship To Quantity

Number

306

15

SDQ22

ASICHG

Additional Charges Record

x

ASICHG

String

1

6

n/a

Charge Description

String

7

30

ITA13

oe-additional-charges.chg-description

Charge Amount

Number

37

17

ITA07

oe-additional-charges.charge-amount

Charge Percent

Number

54

15

ITA09

oe-additional-charges.percentage

Charge Type C or A

String

69

1

ITA01

edi-additional-charges.chg-indicator

Charge Code

String

70

4

ITA14

edi-additional-charges.chg-code

Method Of Handling

Note You must enter 02 if you are importing.

String

74

2

ITA04

edi-additional-charges.chg-method

Charge Unit Of Measure

String

76

2

ITA11

edi-additional-charges.chg-uom

Charge Rate Per Each Unit

Number

78

9

ITA06

edi-additional-charges.chg-rate

VAT Taxable

String

87

1

oe-additional-charges.vat-taxable

VAT Reason Code

String

88

20

vat-reason.vat-reason-code

Charge Amount Includes VAT

String

108

1

oe-additional-charges.entered-amount-vat-inclusive

ASINTE

Order & Line Comments

x

ASINTE

String

1

6

n/a

Note Code "R" or "N"

String

7

3

NTE01

edi-partner.default-notes-import

Note/Remark

String

10

100

NTE02

notes-appr.note-data/remarks.remark-data

Documents To Print In Apprise

String

110

200

remark-document-tbl.document-name; Used for Remarks Only

If you enter more than one document, use commas as delimiters between the documents. You can enter the following documents:

• BOL All Children

• BOL Child

• BOL Master

• Drop Ship PO

• Drop Ship PO Release

• Invoice

• Order Acknowl.

• Pack List

• Pick Demand - Paper

• Pick Demand - Wireless

• Pick Demand

ASILPL

Line Pack List Information Record

x

ASIIPL

String

1

6

Hardcoded

Product Code

String

7

200

oe-pack-list-trl.product-code

Product Description

String

207

1000

oe-pack-list-trl.product-description

UPC

String

1207

25

oe-pack-list-trl.upc-code

Style Code

String

1232

100

oe-pack-list-trl.style-code

Color Code

String

1332

50

oe-pack-list-trl.color-code

Size Code

String

1382

50

oe-pack-list-trl.size-code

Size and Color

String

1432

100

oe-pack-list-trl.size-color

Vendor SKU

String

1532

50

oe-pack-list-trl.vendor-sku

Merchant SKU

String

1582

50

oe-pack-list-trl.merchant-sku

Shopping Cart SKU

String

1632

50

oe-pack-list-trl.shopping-cart-sku

Manufacturer SKU

String

1682

50

oe-pack-list-trl.manufacturer-sku

Return Method

String

1732

50

oe-pack-list-trl.return-method

Return Permit

String

1782

30

oe-pack-list-trl.return-permit

Return Service Postal Code

String

1812

30

oe-pack-list-trl.return-postal-code

Return To Partner Sort Code

String

1842

30

oe-pack-list-trl.return-partner-sort-code

USPS Delivery Confirmation Number

String

1872

50

oe-pack-list-trl.usps-confirmation-num

Label Tracking Number

String

1922

100

oe-pack-list-trl.label-tracking-num

Tax Type

String

2022

50

oe-pack-list-trl.tax-type

Gift Wrap

String

2072

10

oe-pack-list-trl.gift-wrap

Gift Registry Number

String

2082

50

oe-pack-list-trl.registry-num

Personalization Data

String

2132

1000

oe-pack-list-trl.personalization-data

Unit Price

Number

3132

20

oe-pack-list-trl.unit-price

Extended Price

Number

3152

20

oe-pack-list-trl.extended-price

Shipping and Handling

Number

3172

20

oe-pack-list-trl.shipping-handling

Handling Fee

Number

3192

20

oe-pack-list-trl.handling-fee

Shipping Fee

Number

3212

20

oe-pack-list-trl.shipping-fee

Label Shipping Fee

Number

3232

20

oe-pack-list-trl.label-shipping-fee

Tax Amount

Number

3252

20

oe-pack-list-trl.tax-amount

Credit Amount

Number

3272

20

oe-pack-list-trl.credit

Pack List Message

String

3292

1000

oe-pack-list-trl.pack-list-message

Gift Message

String

4292

1000

oe-pack-list-trl.gift-message

ASIEND

x

Ending Record

x

ASIEND

String

1

6

n/a

x

Total Line Items

Number

7

6

CTT01

calculated field

Total Weight

Number

13

10

CTT03

calculated field

x

Total Monetary Amount

Number

23

15

AMT02

calculated field