856CPT/DESADV-CPT Export Format

ASIAUD

x

Auditing Record

x

ASIAUD

String

1

6

n/a

x

Trade ID

String

7

35

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

x

Form Type "856 "

String

42

6

edi-form.form-type

x

Application Name

String

48

7

"APPRISE"

x

EDI Standards Agency Code

String

55

1

"X"

x

Transmission Control #

Number

56

6

seq-upd(editrans-num)

x

Orig=00 Conf=06 Dup=07

Number

62

2

BSN01

"00"

x

Test Document

String

64

1

"T"

x

Production Document

String

65

1

"P"

x

Shipment Number-Audit

String

66

30

BSN02

oe-pick-ticket-hdr.shipment-num/bol-hdr.bol-num

x

Trade ID Inbound

String

96

35

edi-partner.trade-id

Ship Date

Date (MM/DD/YYYY)

131

10

Uses oe-pick-ticket-hdr.confirmed-date-time for a shipment ASN, or bol-hdr.completed-date for a bill of lading

Invoice Number

String

141

12

Uses oe-pick-ticket-hdr.shipment-num for the first pick demand

x

ASN Sequence Number

Number

153

20

This sequential number is generated automatically by the system. It starts at 1 and increases incrementally for each ASN sent.   For the same shipment, the sequence number will not increase if an ASN is regenerated.

x

ASN Count

Number

173

20

This is the number of times a specific ASN was sent. It is stored in the pick demand and bill of lading records.

Purpose Code

String

193

12

BSN01

edi-856-ctl.purpose-code or edi-856-ctl.purpose-code-revised

ASISHP

x

Shipment Record

x

ASISHP

String

1

6

n/a

Hierarchical Parent

Number

7

12

HL02

1

x

Hierarchical Child

Number

19

12

HL01

1

x

Hierarchical Type

String

31

2

HL03

S

x

Shipment Number-Ship

String

33

30

REF02

oe-pick-ticket-hdr.shipment-num/bol-hdr.bol-num

Invoice Number

String

63

12

oe-pick-ticket-hdr.shipment-num

Invoice Date

Date(MMDDYYYY)

75

10

OUTPUT DATE/arinvhdr.ref-date

Invoice Time

String

85

8

OUTPUT TIME

x

Shipper ID

String

93

12

TD502

shipper.shipper-id

Shipper ID Xref (Short)

String

105

16

XREF CODE

x

Shipper Name

String

121

25

TD505

shipper.name

Shipper ID Other

String

146

12

shipper.other-id

Standard Carrier Alpha Code

String

158

12

Uses shipper.scac-code unless it is blank, then uses bol-hdr.scac-code

x

Supplier's Duns Number

String

170

20

N104

customer-ar.db-code

Bill To Code

String

190

16

XREF CODE

Bill To Name

String

206

35

oe-address.name

x

Ship To Code

String

241

16

N104

XREF CODE

x

Ship To Name

String

257

35

N102

Uses edi-address.name unless record is unavailable, then uses oe-address.name

Total Ship Units

Number

292

10

calculated field

Total Ship Cartons

Number

302

7

TD102

calculated field

Total Ship Weight

Number

309

8

TD107

calculated field

Total Ship Weight UOM

String

317

2

TD108

XREF CODE

Internal Vendor Code (EDI)

String

319

20

REF02

Uses oe-header.edi-internal-vendor unless it is blank, then uses edi-partner.edi-internal-vendor

Tracking or Trailer Number

String

339

15

TD303

Uses oe-pick-ticket-pkg.tracking-num unless it is a Bill of Lading, then uses bol-hdr.pro-num

Duns Number Shipment

String

354

20

system-file.db-code

Header Status Code

String

374

2

BP - ship partial, backorder to follow, CC - ship complete, CP - Partial ship, no back orders

Full Tracking Number

Number

376

30

TD303

bol-hdr.bol-num

Bill of Lading Address 1

String

406

35

Uses edi-address.address1 unless record is unavailable, then uses oe-address.address1

Bill of Lading Address 2

String

441

35

Uses edi-address.address2 unless record is unavailable, then uses oe-address.address2

Bill of Lading Address 3

String

476

35

Uses edi-address.address3 unless record is unavailable, then uses oe-address.address3

Bill of Lading City

String

511

30

Uses edi-address.city unless record is unavailable, then uses oe-address.city

Bill of Lading State

String

541

2

Uses edi-address.state unless record is unavailable, then uses oe-address.state

Bill of Lading Postal Code

String

543

12

Uses edi-address.postal-code unless record is unavailable, then uses oe-address.postal-code

Bill of Lading Country

String

555

20

Uses edi-address.country unless record is unavailable, then uses oe-address.country

Bill of Lading consignment

String

575

8

If oe-header.order-type begins with "Consign", hardcode "Consign"

Shipper State

String

583

2

shipper.state

Shipper City

String

585

20

shipper.city

Freight Bill Method

String

605

12

If bol-hdr.prepaid-collect-third = 1 then hardcode "Prepaid", = 2 then hardcode "Collect", = 3 then hardcode "3rd Party"

Bill of Lading Appointment Number

String

617

30

bol-hdr.appointment-num

Bill of Lading Pro Num

String

647

25

bol-hdr.pro-num

Miscellaneous Data 1

String

672

60

oe-header.misc-data-1

Miscellaneous Data 2

String

732

60

oe-header.misc-data-2

Bill of Lading Trailer Number

String

792

25

bol-hdr.trailer-num

Sum of Package Cubes

Number

817

8

oe-pick-ticket-pkg.cube

Sum of Cubes Unit of Measure

String

825

2

XREF CODE

Bill of Lading Seal Number

String

827

25

bol-hdr.seal-num

Master Bill of Lading Number

String

852

17

bol-hdr.master-bol-num

Ship From Name

String

869

30

Shipment ASN uses address.name and BOL uses bol-prt-addr.name.  Both use the "physical" address type.

Ship From Address 1

String

899

35

Shipment ASN uses address.address1 and BOL uses bol-prt-addr.address1.

Ship From Address 2

String

934

35

Shipment ASN uses address.address2 and BOL uses bol-prt-addr.address2.

Ship From Address 3

String

969

35

Shipment ASN uses address.address3 and BOL uses bol-prt-addr.address3.  

Ship From City

String

1004

30

Shipment ASN uses address.city and BOL uses bol-prt-addr.city.

Ship From State

String

1034

2

Shipment ASN uses address.state and BOL uses bol-prt-addr.state.

Ship From Code

String

1036

12

Shipment ASN uses address.postal-code and BOL uses bol-prt-addr.postal-code.  

Ship From Country

String

1048

20

Shipment ASN uses address.country and BOL uses bol-prt-addr.country.  

Transportation Mode

String

1068

2

Shipper.transportation-mode

Store ID

String

1070

20

Uses oe-address.store-id unless blank, then uses custname.store-id.

Remit Db Code

String

1090

20

Uses ar-payment-remit.remit-to-id unless there is not record, then uses system-file.db-code

Ship Date

Date (MM/DD/YYYY)

1110

10

Shipment ASN uses oe-pick-ticket-hdr.confirmed-date-time and BOL uses bol-hdr.completed-date.

Load Number

String

1120

25

Shipment ASN uses oe-pick-ticket-hdr.load-number and BOL uses bol-hdr.load-num.

Container Seal Number

String

1145

20

po-container.seal-num

Shipper ID (Container)

String

1165

12

po-container.ship-via

Container Owner

String

1177

20

po-container.owner-code

Container Type

String

1197

20

container-type.cont-type-code

Shipment Number (Container)

String

1217

25

po-container.shipment-num

Container Bill of Lading Number

String

1242

20

po-container.container-bol

Shipment Number (Shipment)

String

1262

25

po-shipment.shipment-num

Shipper ID (Shipment)

String

1287

12

po-shipment.ship-via

Vessel Number

String

1299

40

po-shipment.vessel-num

Originating Country

String

1339

20

po-shipment.country

Scheduled Ship Date

Date (MM/DD/YYYY)

1359

10

po-shipment.sched-ship-date

Scheduled Delivery Date

Date (MM/DD/YYYY)

1369

10

po-shipment.sched-delivery-date

Shipment Status

String

1379

12

shipment-status.status-code

From Port

String

1391

15

port.port-code

To Port

String

1406

15

port.port-code

EDI Spare 1

String

1421

8

oe-header.edi-spare-1

EDI Spare 2

String

1429

8

oe-header.edi-spare-2

EDI Spare 3

String

1437

8

oe-header.edi-spare-3

EDI Spare 4

String

1445

8

oe-header.edi-spare-4

EDI Spare 5

String

1453

8

oe-header.edi-spare-5

CID Number

String

1461

12

Uses edi-address.cid-num if available.

Package Tracking Number

String

1473

30

oe-pick-ticket-pkg.tracking-num from the first package on the shipment

Freight Bill Method

String

1503

25

If the order is not on a bill of lading, then oe-header.freight-collection-term; if it is on a bill of lading, then if bol-hdr.prepaid-collect-third = 1 then hardcode "Prepaid", = 2 then hardcode "Collect", = 3 then hardcode "3rd Party"

Ordered by Name

String

1528

30

cust-shipto.shipto-name / custname.cust-name

Ordered by Address 1

String

1558

35

cust-shipto.address-1 / custname.address-1

Ordered by Address 2

String

1593

35

cust-shipto.address-2 / custname.address-2

Ordered by Address 3

String

1628

35

cust-shipto.address-3 / custname.address-3

Ordered by City

String

1663

30

cust-shipto.city / custname.city

Ordered by State

String

1693

2

cust-shipto.state / custname.state

Ordered by Postal Code

String

1695

12

cust-shipto.postal-code / custname.postal-code

Ordered by Country

String

1707

20

cust-shipto.country / custname.country

Small Package Carrier

Logical

1727

1

shipper.sm-pkg-carrier (Y/N)

Bill To Name

String

1728

40

oe-address.name

x

Ship To Name

String

1768

40

N102

Uses edi-address.name unless it is unavailable, then uses oe-address.name

Ship From Contact

String

1808

30

for small parcel: address.contact (Location Maintenance); for bill of lading: bol-prt-addr.contact (Bill of Lading Process)

Ship From Email

String

1838

60

for small parcel: address.email-address (Location Maintenance); for bill of lading: bol-prt-addr.email-address (Bill of Lading Process)

User-Defined Field 1

String

1898

400

bol-hdr-udf.user-defined-01

User-Defined Field 2

String

2298

400

bol-hdr-udf.user-defined-02

User-Defined Field 3

String

2698

400

bol-hdr-udf.user-defined-03

User-Defined Field 4

String

3098

400

bol-hdr-udf.user-defined-04

User-Defined Field 5

String

3498

400

bol-hdr-udf.user-defined-05

User-Defined Field 6

String

3898

400

bol-hdr-udf.user-defined-06

User-Defined Field 7

String

4298

400

bol-hdr-udf.user-defined-07

User-Defined Field 8

String

4698

400

bol-hdr-udf.user-defined-08

User-Defined Field 9

String

5098

400

bol-hdr-udf.user-defined-09

User-Defined Field 10

String

5498

400

bol-hdr-udf.user-defined-10

User-Defined Field 11

String

5898

400

bol-hdr-udf.user-defined-11

User-Defined Field 12

String

6298

400

bol-hdr-udf.user-defined-12

User-Defined Field 13

String

6698

400

bol-hdr-udf.user-defined-13

User-Defined Field 14

String

7098

400

bol-hdr-udf.user-defined-14

User-Defined Field 15

String

7498

400

bol-hdr-udf.user-defined-15

User-Defined Field 16

String

7898

400

bol-hdr-udf.user-defined-16

User-Defined Field 17

String

8298

400

bol-hdr-udf.user-defined-17

User-Defined Field 18

String

8698

400

bol-hdr-udf.user-defined-18

User-Defined Field 19

String

9098

400

bol-hdr-udf.user-defined-19

User-Defined Field 20

String

9498

400

bol-hdr-udf.user-defined-20

Shipper ID Xref

String

9898

50

XREF CODE

ASIORD

x

Order Record

x

ASIORD

String

1

6

n/a

x

Hierarchical Parent

Number

7

12

HL02

x

Hierarchical Child

Number

19

12

HL01

x

Hierarchical Type

String

31

2

HL03

O

Order Number

String

33

12

oe-pick-ticket-order.order-num

x

Department Number

String

45

30

REF02

Uses oe-header.dept-num unless it is blank, then uses edi-partner.dept-num

Internal Vendor Code (EDI)

String

75

20

REF02

Uses oe-header.edi-internal-vendor unless it is blank, then uses edi-partner.edi-internal-vendor

x

Purchase Order Number

String

95

20

PRF01

oe-header.cust-po-number

x

Purchase Order Date

Date (MMDDYYYY)

115

10

PRF04

oe-header.order-date

Pick Demand Number

String

125

12

REF02

oe-pick-ticket-tag.pick-ticket-num/oe-pick-ticket-order.pick-ticket-num/oe-pick-ticket-hdr.pick-ticket-num

Total Order Units

Number

137

10

TD102

calculated field

Total Order Cartons

Number

147

7

calculated field

Total Order Weight

Number

154

8

TD107

calculated field

Total Order Weight UOM

String

162

2

XREF CODE

Bill To Code

String

164

16

oe-address.edi-address-code

Bill To Name

String

180

35

oe-address.name

x

Ship To Code

String

215

16

N104

oe-address.edi-address-code

x

Ship To Name

String

231

35

N102

oe-address.name

Partners Application Code

String

266

30

REF

edi-partner.app-id

Mark For Tag

String

296

10

REF

oe-header.cust-po-number

Mark For PO Tag

String

306

20

REF

oe-header.cust-po-number

Order Header Required Date

Date (MMDDYYYY)

326

10

oe-header.required-date

Order Class

String

336

10

oe-header.order-class

User Defined Field 1

String

346

8

oe-header.edi-spare-1

User Defined Field 2

String

354

8

oe-header.edi-spare-2

User Defined Field 3

String

362

8

oe-header.edi-spare-3

User Defined Field 4

String

370

8

oe-header.edi-spare-4

User Defined Field 5

String

378

8

oe-header.edi-spare-5

x

Store ID

String

386

20

Uses oe-address.store-id unless blank, then uses custname.store-id.

Order Shipment Number

String

406

13

oe-pick-ticket-hdr.shipment-num

Distribution Center Number

String

419

25

oe-header.edi-distribution-center-id

Miscellaneous Data 1

String

444

60

oe-header.misc-data-1

Miscellaneous Data 2

String

504

60

oe-header.misc-data-2

Sum of Package Cubes

Number

564

8

oe-pick-ticket-pkg.cube

Sum of Cubes UM

String

572

2

um.um-code

Order Status Code

String

574

2

BP - ship partial, backorder to follow, CC - ship complete, CP - Partial ship, no back orders

Invoice Due Date

Date (MMDDYYYY)

576

10

arinvitm.due-date

Invoice Total

Number

586

15

calculated field

Invoice Number

String

601

12

oe-pick-ticket-hdr.shipment-num

FOB

String

613

12

fob.fob-code

Alternate PO

String

625

60

oe-header.alternate-po

Contract Code

String

685

25

contract.contract-code

Invoice Number (formatted)

String

710

12

oe-pick-ticket-hdr.shipment-num

User Date 1

Date (MM/DD/YYYY)

722

10

oe-header.user-date-1

User Date 2

Date (MM/DD/YYYY)

732

10

oe-header.user-date-2

User Date 3

Date (MM/DD/YYYY)

742

10

oe-header.user-date-3

User Date 4

Date (MM/DD/YYYY)

752

10

oe-header.user-date-4

User Date 5

Date (MM/DD/YYYY)

762

10

oe-header.user-date-5

User Date 6

Date (MM/DD/YYYY)

772

10

oe-header.user-date-6

User Date 7

Date (MM/DD/YYYY)

782

10

oe-header.user-date-7

User Date 8

Date (MM/DD/YYYY)

792

10

oe-header.user-date-8

User Date 9

Date (MM/DD/YYYY)

802

10

oe-header.user-date-9

User Date 10

Date (MM/DD/YYYY)

812

10

oe-header.user-date-10

Bill To Name

String

822

40

oe-address.name

x

Ship To Name

String

862

40

N102

oe-address.name

Full Pick Demand Number

String

902

12

oe-pick-ticket-tag.pick-ticket-num/oe-pick-ticket-order.pick-ticket-num/oe-pick-ticket-hdr.pick-ticket-num

User Defined Field 1

String

914

400

oe-header.user-defined-01

User Defined Field 2

String

1314

400

oe-header.user-defined-02

User Defined Field 3

String

1714

400

oe-header.user-defined-03

User Defined Field 4

String

2114

400

oe-header.user-defined-04

User Defined Field 5

String

2514

400

oe-header.user-defined-05

User Defined Field 6

String

2914

400

oe-header.user-defined-06

User Defined Field 7

String

3314

400

oe-header.user-defined-07

User Defined Field 8

String

3714

400

oe-header.user-defined-08

User Defined Field 9

String

4114

400

oe-header.user-defined-09

User Defined Field 10

String

4514

400

oe-header.user-defined-10

User Defined Field 11

String

4914

400

oe-header.user-defined-11

User Defined Field 12

String

5314

400

oe-header.user-defined-12

User Defined Field 13

String

5714

400

oe-header.user-defined-13

User Defined Field 14

String

6114

400

oe-header.user-defined-14

User Defined Field 15

String

6514

400

oe-header.user-defined-15

User Defined Field 16

String

6914

400

oe-header.user-defined-16

User Defined Field 17

String

7314

400

oe-header.user-defined-17

User Defined Field 18

String

7714

400

oe-header.user-defined-18

User Defined Field 19

String

8114

400

oe-header.user-defined-19

User Defined Field 20

String

8514

400

oe-header.user-defined-20

ASIITM

x

Item Record

ASIITM

String

1

6

n/a

Hierarchical Parent

Number

7

12

HL02

Hierarchical Child

Number

19

12

HL01

Hierarchical Type

String

31

2

HL03

I

Quantity Shipped

Number

33

10

SN102

arinvitm.qty

Quantity UM Internal

String

43

2

SN103

um.um-code

Quantity UM External

String

45

2

XREF CODE

UPC Code Internal

String

47

14

LIN03

Uses product-um.upc (for the pack unit of measure for the product and shipping location) unless it is blank, then uses product-um.upc (for the pack unit of measure for the product) unless it is blank, then uses product.upc-code

UPC Code External

String

61

14

oe-cust-prod.cust-upc-code

Item Number Internal

String

75

40

product.product-code

Item Number External

String

115

40

Uses oe-cust-prod.customer-product-id unless edi-partner.use-supp-prod is true, then uses supp-prod.supplier-prod-code

Order Line Number

String

155

9

oe-trailer.line-num

Unit Price

Number

164

14

oe-trailer.unit-price + oe-trailer.price-adjustment

Line Status Code

String

178

2

BP - ship partial, backorder to follow, CC - ship complete, CP - Partial ship, no back orders

Quantity Ordered

Number

180

10

oe-trailer.qty-ordered

Quantity Ordered UM Internal

String

190

2

um.um-code

Quantity Ordered UM External

String

192

2

XREF CODE

Purchase Order Line Number

String

194

20

oe-trailer.po-num

User Defined Field 1

String

214

8

oe-trailer.edi-spare-1

User Defined Field 2

String

222

8

oe-trailer.edi-spare-2

User Defined Field 3

String

230

8

oe-trailer.edi-spare-3

User Defined Field 4

String

238

8

oe-trailer.edi-spare-4

User Defined Field 5

String

246

8

oe-trailer.edi-spare-5

Quantity Shipped In Order UM

Number

254

10

calculated field

GTIN

String

264

14

Uses product-um.gtin (for the pack unit of measure for the product and shipping location) unless it is blank, then uses product-um.gtin (for the pack unit of measure for the product) unless it is blank, then uses product.gtin

Product Name

String

278

30

product.product-name

Full UM Code

String

308

8

um.um-code

Miscellaneous Data 1

String

316

60

oe-trailer.misc-data-1

Miscellaneous Data 2

String

376

60

oe-trailer.misc-data-2

Conversion Factor 1

String

436

20

um-rates.conversion-factor (from inner pack unit of measure to product unit of measure)

Conversion Factor 2

String

456

20

um-rates.conversion-factor (from master carton unit of measure to inner pack unit of measure)

Master Carton UM Cube

String

476

11

product-um.cube

Master Carton UM Length

String

487

11

product-um.length

Master Carton UM Width

String

498

11

product-um.width

Master Carton UM Height

String

509

11

product-um.height

Master Carton UM Net Weight

String

520

11

product-um.net-weight

Master Carton UM Gross Weight

String

531

11

product-um.gross-pkgd-weight

Country of Origin

String

542

10

product.country-of-origin

UCC 128 Code

String

552

40

oe-pick-ticket-pkg.ucc128-num

Package Tracking Number

String

592

30

oe-pick-ticket-pkg.tracking-num

RFID Number

String

622

40

oe-pick-ticket-pkg.rfid-num

SGTIN

String

662

40

oe-pick-ticket-pkg.sgtin

Pack Length

Number

702

12

product-um.length

Pack Width

Number

714

12

product-um.width

Pack Height

Number

726

12

product-um.height

Pack Weight

Number

738

12

oe-pick-ticket-pkg.weight

EDI Order Line Number

String

750

20

oe-trailer.edi-order-line-num

Quantity Backordered

Number

770

10

calculated field (oe-trailer.qty-ordered - oe-trailer.qalloc - oe-trailer.qty-picked - oe-trailer.qfuture)

Backorder Flag

Logical

780

1

oe-trailer.on-backorder

Cancel Backorder Flag

Logical

781

1

oe-trailer.backorder-cancelled

Cancelled Flag

Logical

782

1

oe-trailer.cancelled

Qty Cancelled

Number

783

10

calculated field (oe-trailer.qty-ordered - oe-trailer.qty-picked-to-date - sum of (oe-pick-ticket-trl.recommended-qty) )

User Defined Field 1

String

793

400

oe-trailer.user-defined-01

User Defined Field 2

String

1193

400

oe-trailer.user-defined-02

User Defined Field 3

String

1593

400

oe-trailer.user-defined-03

User Defined Field 4

String

1993

400

oe-trailer.user-defined-04

User Defined Field 5

String

2393

400

oe-trailer.user-defined-05

User Defined Field 6

String

2793

400

oe-trailer.user-defined-06

User Defined Field 7

String

3193

400

oe-trailer.user-defined-07

User Defined Field 8

String

3593

400

oe-trailer.user-defined-08

User Defined Field 9

String

3993

400

oe-trailer.user-defined-09

User Defined Field 10

String

4393

400

oe-trailer.user-defined-10

User Defined Field 11

String

4793

400

oe-trailer.user-defined-11

User Defined Field 12

String

5193

400

oe-trailer.user-defined-12

User Defined Field 13

String

5593

400

oe-trailer.user-defined-13

User Defined Field 14

String

5993

400

oe-trailer.user-defined-14

User Defined Field 15

String

6393

400

oe-trailer.user-defined-15

User Defined Field 16

String

6793

400

oe-trailer.user-defined-16

User Defined Field 17

String

7193

400

oe-trailer.user-defined-17

User Defined Field 18

String

7593

400

oe-trailer.user-defined-18

User Defined Field 19

String

7993

400

oe-trailer.user-defined-19

User Defined Field 20

String

8393

400

oe-trailer.user-defined-20

EarliestExpiringLot

String

8793

40

oe-pick-ticket-trl.level-key-6

EarliestExpiringLotExpirationDate

Date

8833

10

oe-pick-ticket-trl.expiration-date

Package Volume

Number

8843

12

oe-pick-ticket-pkg.cube

Order Number

String

8855

12

oe-trailer.order-num

Return Tracking Number

String

8867

30

oe-pick-ticket-pkg-label.return-tracking-number

ASITAR

x

Tare Record

x

ASITAR

String

1

6

n/a

x

Hierarchical Parent

Number

7

12

HL02

x

Hierarchical Child

Number

19

12

HL01

x

Hierarchical Type

String

31

2

HL03

T

Shipment Number

String

33

30

HL03

Uses oe-pick-ticket-hdr.shipment-num unless is a Bill of Lading, then uses bol-hdr.bol-num

x

UCC 128 Code

String

63

40

MAN02

oe-pick-ticket-pkg.ucc128-num

UCC 128 Shipment Code

String

103

40

MAN02

shipment.tag-num

RFID Number

String

143

40

pallet-def.rfid-num/oe-pick-ticket-pkg.rfid-num

x

Number of Packages Placed on Tare

Number

183

10

Sum of oe-pick-ticket-pkg

Pallet ID

String

193

30

pallet-def.palled-id

UCC 128 Pallet Tag Number

String

223

30

pallet-def.pallet-tag-num

EarliestExpiringLot

String

253

40

oe-pick-ticket-trl.level-key-6

EarliestExpiringLotExpirationDate

Date

293

10

oe-pick-ticket-trl.expiration-date

ASIPAK

x

Pack Record

x

ASIPAK

String

1

6

n/a

x

Hierarchical Parent

Number

7

12

HL02

x

Hierarchical Child

Number

19

12

HL01

x

Hierarchical Type

String

31

2

HL03

P

Shipment Number

String

33

30

HL03

Uses oe-pick-ticket-hdr.shipment-num unless it is a Bill of Lading, then uses bol-hdr.bol-num

x

UCC 128 Code

String

63

40

MAN02

oe-pick-ticket-pkg.ucc128-num

UCC 128 Shipment Code

String

103

40

MAN02

shipment.tag-num

Qty shipped at the pack level

Number

143

10

calculated field

Qty shipped UM Internal

String

153

2

um.um-code

Qty shipped UM External

String

155

2

XREF CODE

Package Tracking Number

String

157

30

oe-pick-ticket-pkg.tracking-num

RFID Number

String

187

40

oe-pick-ticket-pkg.rfid-num

SGTIN

String

227

40

oe-pick-ticket-pkg.sgtin

GTIN

String

267

14

Uses product-um.gtin unless it is blank, then uses product.gtin

Pack Length

String

281

12

carton.length if available, otherwise product-um.length

Pack Width

String

293

12

carton.width if available, otherwise product-um.width

Pack Height

String

305

12

carton.height if available, otherwise product-um.height

Pack Weight

String

317

12

oe-pick-ticket-pkg.weight

Picked Qty (Base U/M)

String

329

12

oe-pick-ticket-tag.picked-qty

Conversion Factor 1

Number

341

20

oe-cust-prod.ip-um-key TO product.um-key

Conversion Factor 2

Number

361

20

oe-cust-prod.mc-um-key TO oe-cust-prod.ip-um-key

Pack Volume

Number

381

12

product-um.length * product-um.height* product-um.width

EarliestExpiringLot

String

393

40

oe-pick-ticket-trl.level-key-6

EarliestExpiringLotExpirationDate

Date

433

10

oe-pick-ticket-trl.expiration-date

Return Tracking Number

String

443

30

oe-pick-ticket-pkg-label.return-tracking-number

ASICHG

Additional Charge Record

ASICHG

String

1

6

"ASICHG"

HL Line

Number

13

5

ASIORD, ASIPAK, ASIITM - HL Child

Charge Description

String

33

40

oe-charge-def.description

Charge Code Internal

String

73

10

oe-charge-def.type

Charge Code External

String

83

15

XREF CODE

Charge Amount

Number

98

15

calculated field

Charge Type C or A

String

113

1

If oe-pick-ticket-chrg.charge-amount is less than zero, uses "A". If not, uses "C".

Method Of Handling

String

114

2

"02"=off invoice

Charge Unit Of Measure

String

116

2

"EA"=eaches

Charge Tax Amount

Number

118

10

calculated field

Charge VAT Amount

Number

128

10

calculated field

Charge Percent

Number

138

10

Calculates the percentage as oe-pick-ticket-chrg.charge-amount / Item Extend Price if the percentage field is not populated. Otherwise, arinvmsc.percentage.

Charge Amount (No Decimal)

Integer

148

15

arinvmsc.misc-amt

Charge Tax Amount (No Decimal)

Integer

163

10

calculated field

Charge VAT Amount (No Decimal)

Integer

173

10

calculated field

ASIEND

x

Ending Record

ASIEND

String

1

6

n/a

Total Hierarchical Segments

Number

7

6

CTT01

Total Shipment Cartons

Number

13

7

calculated field

Total Order Cartons

Number

20

7

calculated field

Total Pack Levels

Number

27

7

calculated field

Valid Carton Counts

Logical

34

7

calculated field