EDI Purchase Order Export Format

ASIAUD

x

Auditing Record

x

ASIAUD

String

1

6

Hardcoded

x

Trade ID

String

7

35

ISA06

Uses edi-form.outbound-id unless it is blank, then uses edi-partner.trade-id

x

Form Type "850   "

String

42

6

ST01

edi-partner.form-type

x

Application Name

String

48

7

Hardcode "APPRISE"

x

EDI Standards Agency Code

String

55

1

GS07

Hardcode "X"

x

Transmission Control Number

Number

56

6

seq-upd(editrans-num)

x

Orig=00 Conf=06 Dup=07

Number

62

2

BEG01

If edi-po-header.transmit-count = 0, uses "00" to signal Original. If not, uses "07" to signal Duplicate.

x

Test Document

String

64

1

Hardcode "T"

x

Production Document

String

65

1

Hardcode "P"

x

Trade ID Inbound

String

66

35

edi-partner.trade-id

x

Store ID

String

101

20

This is not used for outbound 850's.

ASIHDR

x

Header Record

x

ASIHDR

String

1

6

n/a

x

Supplier Code

String

7

12

suppname.supplier-key

x

Purchase Order Date

Date (MMDDYYYY)

19

10

BEG05

po-header.po-date

x

Purchase Order Number

String

29

20

BEG03

po-header.po-num

Purchase Order Type

String

49

8

BEG02

po-header.po-type

Preferred Shipper

String

57

12

TD505

po-header.ship-via (XREF)

Currency

String

69

3

CUR02

po-header.entered-currency

Ship Order By Date

Date (MMDDYYYY)

72

10

DTM02

po-header.required-date

Cancel Order By Date

Date (MMDDYYYY)

82

10

DTM02

po-header.required-date

Contract Number

String

92

20

BEG06

This is not used for outbound 850's.

Purchase Order Terms

String

112

12

TIA01

po-header.terms-key (XREF)

Header Ship To Location

String

124

8

N104

po-header.ship-to-loc-key

Header Bill To Location

String

132

8

N104

po-header.bill-to-loc-key

Standard Carrier Alpha Code

String

140

12

This is not used for outbound 850's.

Department Number

String

152

30

REF02

edi-partner.dept-num

Internal Vendor Code (EDI)

String

182

20

REF02

edi-partner.edi-internal-vendor

Order Placer

String

202

30

po-header.originator

Order Placer Phone Number

String

232

12

This is not used for outbound 850's.

User Defined Field 1

String

244

8

edi-partner.edi-spare-1

User Defined Field 2

String

252

8

edi-partner.edi-spare-2

User Defined Field 3

String

260

8

edi-partner.edi-spare-3

User Defined Field 4

String

268

8

edi-partner.edi-spare-4

User Defined Field 5

String

276

8

edi-partner.edi-spare-5

Supplier Code

String

284

15

suppname.supplier-code

Sale Type

String

299

8

This is not used for outbound 850's.

User Defined Date Field 1

String

307

10

po-header.user-date-1

User Defined Date Field 2

String

317

10

po-header.user-date-2

User Defined Date Field 3

String

327

10

po-header.user-date-3

User Defined Date Field 4

String

337

10

po-header.user-date-4

User Defined Date Field 5

String

347

10

po-header.user-date-5

User Defined Date Field 6

String

357

10

po-header.user-date-6

User Defined Date Field 7

String

367

10

po-header.user-date-7

User Defined Date Field 8

String

377

10

po-header.user-date-8

User Defined Date Field 9

String

387

10

po-header.user-date-9

User Defined Date Field 10

String

397

10

po-header.user-date-10

Consignment-field

String

407

8

This is not used for outbound 850's.

Earliest Ship Date

String

415

10

This is not used for outbound 850's.

Latest Ship Date

String

425

10

This is not used for outbound 850's.

FOB

String

435

8

XREF CODE if defined, otherwise fob.fob-code

Cancel Backorder

String

443

1

This is not used for outbound 850's.

Misc Data 1

String

444

60

This is not used for outbound 850's.

Misc Data 2

String

504

60

This is not used for outbound 850's.

Shipping Method

String

564

8

This is not used for outbound 850's.

Freight Collection Terms

String

572

20

This is not used for outbound 850's.

VAT Taxable

String

592

1

This is not used for outbound 850's.

VAT Reason Code DNU

String

593

12

This is not used for outbound 850's.

Alternate PO

String

605

60

This is not used for outbound 850's.

User Defined Import Warning

String

665

80

This is not used for outbound 850's.

Acknowledgment Option

String

745

4

This is not used for outbound 850's.

Original Customer PO

String

749

20

Original customer's purchase order number for a drop-ship order

Commission Billing Customer Code

String

769

12

Drop-ship commission billing customer code

Sales Order Customer Purchase Order Number

String

781

20

oe-header.cust-po-num

Sales Order Customer Code

String

801

12

custname.cust-code

Sales Order Customer Name

String

813

40

custname.cust-name

Sales Order Billing Customer Code

String

853

12

custname.cust-code (Billing)

Sales Order Billing Customer Name

String

865

40

custname.cust-name (Billing)

Sales Order Created Date

Date (MMDDYYYY)

905

10

oe-header.create-date

Sales Order Order Date

Date (MMDDYYYY)

915

10

oe-header.order-date

Sales Order Required Date

Date (MMDDYYYY)

925

10

oe-header.required-date

Sales Order Trade ID

String

935

25

edi-partner.trade-id

Purchase Order Buyer

String

960

12

po-header.buyer

Supplier Name

String

972

40

suppname.supplier-name

Originating Country

String

1012

10

po-header.country-code

Supplier's Confirming Order Number

String

1022

12

po-header.contract-order-num

Purchase Order Class

String

1034

10

po-header.po-class

Purchase Order Ship Date

Date (MMDDYYYY)

1044

10

po-header.sched-ship-date

Purchase Order Delivery Date

Date (MMDDYYYY)

1054

10

po-header.sched-delivery-date

Purchase Order Final Change Date

Date (MMDDYYYY)

1064

10

po-header.final-change-date

Ship To EDI Address Code

String

1074

30

oe-address.edi-address-code

Ship to Store Number

String

1104

20

oe-address.store-id

Bill To EDI Address Code

String

1124

30

oe-address.edi-address-code

Generate 870

String

1154

4

This is not used for outbound 850's.

Freight Cap Percentage

String

1160

6

This is not used for outbound 850's.

Shipper Account ID

String

1166

20

This is not used for outbound 850's.

Excise ID

String

1186

30

This is not used for outbound 850's.

VAT Reason Code

String

1216

20

This is not used for outbound 850's.

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

User Defined 1

String

1300

100

po-header.user-defined-1

User Defined 2

String

1400

100

po-header.user-defined-2

User Defined 3

String

1500

100

po-header.user-defined-3

User Defined 4

String

1600

100

po-header.user-defined-4

User Defined 5

String

1700

100

po-header.user-defined-5

User Defined 6

String

1800

100

po-header.user-defined-6

User Defined 7

String

1900

100

po-header.user-defined-7

User Defined 8

String

2000

100

po-header.user-defined-8

User Defined 9

String

2100

100

po-header.user-defined-9

User Defined 10

String

2200

100

po-header.user-defined-10

User Defined 11

String

2300

100

po-header.user-defined-11

User Defined 12

String

2400

100

po-header.user-defined-12

User Defined 13

String

2500

100

po-header.user-defined-13

User Defined 14

String

2600

100

po-header.user-defined-14

User Defined 15

String

2700

100

po-header.user-defined-15

User Defined 16

String

2800

100

po-header.user-defined-16

User Defined 17

String

2900

100

po-header.user-defined-17

User Defined 18

String

3000

100

po-header.user-defined-18

User Defined 19

String

3100

100

po-header.user-defined-19

User Defined 20

String

3200

100

po-header.user-defined-20

Supplier User Defined 1

String

3300

100

suppname.usr-def-fld-1

Supplier User Defined 2

String

3400

100

suppname.usr-def-fld-2

Supplier User Defined 3

String

3500

100

suppname.usr-def-fld-3

Supplier User Defined 4

String

3600

100

suppname.usr-def-fld-4

Supplier User Defined 5

String

3700

100

suppname.usr-def-fld-5

Supplier User Defined 6

String

3800

100

suppname.usr-def-fld-6

Supplier User Defined 7

String

3900

100

suppname.usr-def-fld-7

Supplier User Defined 8

String

4000

100

suppname.usr-def-fld-8

Supplier User Defined 9

String

4100

100

suppname.usr-def-fld-9

Supplier User Defined 10

String

4200

100

suppname.usr-def-fld-10

Supplier User Defined 11

String

4300

100

suppname.usr-def-fld-11

Supplier User Defined 12

String

4400

100

suppname.usr-def-fld-12

Supplier User Defined 13

String

4500

100

suppname.usr-def-fld-13

Supplier User Defined 14

String

4600

100

suppname.usr-def-fld-14

Supplier User Defined 15

String

4700

100

suppname.usr-def-fld-15

Supplier User Defined 16

String

4800

100

suppname.usr-def-fld-16

Supplier User Defined 17

String

4900

100

suppname.usr-def-fld-17

Supplier User Defined 18

String

5000

100

suppname.usr-def-fld-18

Supplier User Defined 19

String

5100

100

suppname.usr-def-fld-19

Supplier User Defined 20

String

5200

100

suppname.usr-def-fld-20

ASIBTA

x

Bill To Address Record

ASIBTA

String

1

6

n/a

Bill To Code

String

7

16

N101

Bill To Name

String

23

35

N102

po-address.name

Bill To Address Line 1

String

58

30

N301

po-address.address1

NOTE There is a five character gap after this field.

Bill To Address Line 2

String

93

30

N302

po-address.address2

NOTE There is a five character gap after this field.

Bill To Address Line 3

String

128

30

po-address.address3

NOTE There is a five character gap after this field.

Bill To City

String

163

30

N401

po-address.city

Bill To State

String

193

2

N402

po-address.state

Bill To Postal Code

String

195

12

N403

po-address.postal-code

Bill To Country

String

207

20

N404

po-address.country

Bill To Phone

String

227

12

PER04

po-address.phone

Bill To Fax

String

239

12

PER06

po-address.fax

Bill To Contact

String

251

30

PER02

po-address.contact

Importer of Record Number

String

281

20

This is not used for outbound 850's.

Bill To Name

String

301

40

N102

po-address.name

Bill To Address Line 3

String

341

35

This is not used for outbound 850's.

Bill To Email

String

376

150

po-address.email-address

ASISTA

x

Ship To Address Record

ASISTA

String

1

6

n/a

Ship To Code

String

7

16

N101

Ship To Name

String

23

35

N102

po-address.name

Ship To Address Line 1

String

58

30

N301

po-address.address1

NOTE There is a five character gap after this field.

Ship To Address Line 2

String

93

30

N302

po-address.address2

NOTE There is a five character gap after this field.

Ship To Address Line 3

String

128

30

po-address.address3

NOTE There is a five character gap after this field.

Ship To City

String

163

30

N401

po-address.city

Ship To State

String

193

2

N402

po-address.state

Ship To Postal Code

String

195

12

N403

po-address.postal-code

Ship To Country

String

207

20

N404

po-address.country

Ship To Phone

String

227

12

PER04

po-address.phone

Ship To Fax

String

239

12

PER06

po-address.fax

Ship To Contact

String

251

30

PER02

po-address.contact

Fulfillment Ship To

String

281

33

This is not used for outbound 850's.

Ship To Name

String

314

40

N102

po-address.name

Ship To Email

String

354

150

po-address.email-address

Ship To Excise ID

String

504

30

po-address.excise-id

ASISFA

x

Ship From Address Record

ASISFA

String

1

6

Hardcoded

Ship From Name

String

7

35

N102

po-address.name

Ship From Address Line 1

String

42

35

N301

po-address.address1

NOTE There is a five character gap after this field.

Ship From Address Line 2

String

77

35

N302

po-address.address2

NOTE There is a five character gap after this field.

Ship From Address Line 3

String

112

35

po-address.address3

NOTE There is a five character gap after this field.

Ship From  City

String

147

30

N401

po-address.city

Ship From State

String

177

2

N402

po-address.state

Ship From Postal Code

String

179

12

N403

po-address.postal-code

Ship From Country

String

191

20

N404

po-address.country

Ship From Phone

String

211

12

PER04

po-address.phone

Ship From Fax

String

223

12

PER06

po-address.fax

Ship From Email

String

235

60

PER06

po-address.email-address

Ship From County

String

295

20

PER06

po-address.county

Ship From Excise ID

String

315

30

po-address.excise-id

Ship From VAT ID

String

345

30

po-header.vat-id

ASINTE

x

Header Comments

ASINTE

String

1

6

Hardcoded

Remark Type

String

7

3

NTE01

"HDR"

Remark

String

10

100

NTE02

remarks.remark-data

Documents to Print in Apprise

String

110

200

Document List (from remark-document-tbl.document-name)

ASILIN

x

Line Item Record

x

ASILIN

String

1

6

n/a

x

Purchase Order Number

String

7

12

PO101

po-trailer.po-num

x

Product Code

String

19

40

PO107

po-trailer.product-code

Product Description

String

59

30

PID05

po-trailer.product-name

x

Qty Ordered

Number

89

15

PO102

po-trailer.qty-ordered

Unit Of Measure

String

104

4

PO103

um.um (from po-trailer U/M)

Unit Price

Number

108

15

PO104

po-trailer.unit-cost

Commodity Code

String

123

8

TC202

Line Item Shipping Location

String

131

8

SDQ03

po-trailer.ship-to-loc-key

Ship Order By Date

Date (MMDDYYYY)

139

10

DTM02

po-trailer.required-date

Cancel Order By Date

Date (MMDDYYYY)

149

10

DTM02

po-trailer.required-date

User Defined Field 1

String

159

8

edi-partner.edi-spare-1

User Defined Field 2

String

167

8

edi-partner.edi-spare-2

User Defined Field 3

String

175

8

edi-partner.edi-spare-3

User Defined Field 4

String

183

8

edi-partner.edi-spare-4

User Defined Field 5

String

191

8

edi-partner.edi-spare-5

Drop Ship Flag

String

199

1

This is not used for outbound 850's.

Drop Ship Supplier ID

String

200

15

This is not used for outbound 850's.

Unit of Measure Code

String

215

8

PO103

um-code (XREF)

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

This is not used for outbound 850's.

SDQ line item ship-to

String

344

4

This is not used for outbound 850's.

Direct Ship

String

348

1

This is not used for outbound 850's.

VAT Taxable

String

349

1

This is not used for outbound 850's.

VAT Reason Code DNU

String

350

12

This is not used for outbound 850's.

Price Includes VAT

String

362

1

This is not used for outbound 850's.

Contract Code

String

363

20

This is not used for outbound 850's.

Purchase Order Line Number

String

383

20

po-traiiler.line-num

Customer Product Code

String

403

40

oe-cust-prod.customer-product-id

Customer Product Name

String

443

40

oe-cust-prod.customer-product-name

Customer Product UPC

String

483

20

oe-cust-prod.cust-upc-code

UPC

String

503

25

product.upc-code

GTIN

String

528

14

product.gtin

Purchase Order Ship Date

Date (MMDDYYYY)

542

10

po-trailer.sched-ship-date

Purchase Order Delivery Date

Date (MMDDYYYY)

552

10

po-trailer.sched-delivery-date

Purchase Order Required Date

Date (MMDDYYYY)

562

10

po-trailer.required-date

Ship Via

String

572

12

po-trailer.ship-via (XREF)

Country of Origin

String

584

10

po-trailer.country-of-origin

Supplier Product Code

String

606

40

po-trailer.supp-prod-code

Supplier Product Name

String

646

30

supp-prod.supplier-prod-name

Sales Order Mark For Store ID

String

676

20

oe-address.store-id

Sales Order Mark For Customer Name

String

696

40

custname.cust-name

Sales Order Mark For Address 1

String

736

60

custname.address-1

Sales Order Mark For Address 2

String

796

60

custname.address-2

Sales Order Mark For Address 3

String

856

60

custname.address-3

Sales Order Mark For City

String

916

36

custname.city

Sales Order Mark For State

String

952

3

custname.state

Sales Order Mark For Postal Code

String

955

30

custname.postal-code

Sales Order Mark For Country

String

985

20

custname.country

Sales Order Mark For Phone

String

1005

16

custname.phone

Sales Order Mark For Fax

String

1021

16

custname.fax

Sales Order Mark For Attention

String

1037

36

custname.attention

Sales Order Mark For County

String

1073

36

custname.county

Sales Contract Line

String

1109

4

This is not used for outbound 850's.

Combo Price Class

String

1113

20

This is not used for outbound 850's.

Container Code

String

1133

12

po-container.container-code

Container Type

String

1145

20

container-type.cont-type-code

From Port Code

String

1165

15

port.port-code

From Port Name

String

1180

30

port.port-name

To Port Code

String

1210

15

port.port-code

To Port Name

String

1225

30

port.port-name

Commission Cost Charge Type

String

1255

12

This is not used for outbound 850's.

VAT Reason Code

String

1267

20

This is not used for outbound 850's.

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

User Defined 1

String

1300

100

po-trailer.user-defined-1

User Defined 2

String

1400

100

po-trailer.user-defined-2

User Defined 3

String

1500

100

po-trailer.user-defined-3

User Defined 4

String

1600

100

po-trailer.user-defined-4

User Defined 5

String

1700

100

po-trailer.user-defined-5

User Defined 6

String

1800

100

po-trailer.user-defined-6

User Defined 7

String

1900

100

po-trailer.user-defined-7

User Defined 8

String

2000

100

po-trailer.user-defined-8

User Defined 9

String

2100

100

po-trailer.user-defined-9

User Defined 10

String

2200

100

po-trailer.user-defined-10

User Defined 11

String

2300

100

po-trailer.user-defined-11

User Defined 12

String

2400

100

po-trailer.user-defined-12

User Defined 13

String

2500

100

po-trailer.user-defined-13

User Defined 14

String

2600

100

po-trailer.user-defined-14

User Defined 15

String

2700

100

po-trailer.user-defined-15

User Defined 16

String

2800

100

po-trailer.user-defined-16

User Defined 17

String

2900

100

po-trailer.user-defined-17

User Defined 18

String

3000

100

po-trailer.user-defined-18

User Defined 19

String

3100

100

po-trailer.user-defined-19

User Defined 20

String

3200

100

po-trailer.user-defined-20

Harmonization Code

String

3300

20

product.harmonization-code

ASISDQ

Destination Quantity Record

NOTE This is only used for SDQ maps.

x

ASISDQ

String

1

6

Hardcoded

x

Unit of Measure

String

7

4

SDQ01

XREF CODE if defined otherwise um (from po-trailer U/M)

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

SDQ010

Ship To Code

String

135

16

SDQ011

Ship To Quantity

Number

151

15

SDQ012

Ship To Code

String

166

16

SDQ013

Ship To Quantity

Number

182

15

SDQ014

Ship To Code

String

197

16

SDQ015

Ship To Quantity

Number

213

15

SDQ016

Ship To Code

String

228

16

SDQ017

Ship To Quantity

Number

244

15

SDQ018

Ship To Code

String

259

16

SDQ019

Ship To Quantity

Number

275

15

SDQ020

Ship To Code

String

290

16

SDQ021

Ship To Quantity

Number

306

15

SDQ022

ASICHG

Additional Charges Record

x

ASICHG

String

1

6

n/a

Charge Description

String

7

30

ITA13

po-charge-def.description

Charge Amount

Number

37

17

ITA07

po-add-charge.amount

Charge Percent

Number

54

15

ITA09

Charge Type C or A

String

69

1

ITA01

Charge Code

String

70

4

ITA14

Method Of Handling

Note You must enter 02 if you are importing.

String

74

2

ITA04

Charge Unit Of Measure

String

76

2

ITA11

Charge Rate Per Each Unit

Number

78

9

ITA06

ASINTE

Line Comments

x

ASINTE

String

1

6

Hardcoded

Remark Type

String

7

3

NTE01

"TRL"

Remark

String

10

100

NTE02

remarks.remark-data

Documents To Print In Apprise

String

110

200

Document List (from remark-document-tbl.document-name)

ASIEND

x

Ending Record

x

ASIEND

String

1

6

n/a

x

Total Line Items

Number

7

6

CTT01

Total Lines

Total Weight

Number

13

10

CTT03

po-header.total-weight

x

Total Monetary Amount

Number

23

15

AMT02

po-header.total-amount