EDI Warehouse Shipping Order Export Format

The following table lists the export format that is used for EDI warehouse shipping orders created when printing pick demands in Pick Demand Create and Print.

Map Table

M

Description

Field Name

Apprise Table/Field

Data Type

Format

Notes

PICK_HEADER

x

Header Record

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Trade ID

customer_id

edi-partner.trade-id

Character

X(25)

 

 

 

Customer Code

customer_code

cust-by-user.cust-code

Character

X(15)

NOTE This field is blank for transfer orders.

 

 

Pick Demand Number

Pick_ticket_number

oe-pick-ticket-hdr.pick-ticket-num

Character

X(12)

 

 

 

PO Number

po_number

oe-header.cust-po-number

Character

X(20)

 

 

 

Ship from Code

ship_from_id_code

oe-pick-ticket-hdr.shipping-location-key

Character

X(8)

 

 

 

Ship From Name

ship_from_company_name

address.name

Character

X(40)

Address Type: "Physical"

 

 

Ship From Address 1

ship_from_address1

address.address1

Character

X(30)

Address Type: "Physical"

 

 

Ship From Address 2

ship_from_address2

address.address2

Character

X(30)

Address Type: "Physical"

 

 

Ship From City

ship_from_city

address.city

Character

X(20)

Address Type: "Physical"

 

 

Ship From State

ship_from_state

address.state

Character

X(3)

Address Type: "Physical"

 

 

Ship from Zip

ship_from_postal_code

address.postal-code

Character

X(12)

Address Type: "Physical"

 

 

Ship From Country

ship_from_country_code

address.country

Character

X(10)

Address Type: "Physical"

 

 

Ship To Code

ship_to_id_code

oe-address.edi-address-code

Character

X(30)

Address Type: "Ship To"

 

 

Ship To Name

ship_to_company_name

oe-address.name

Character

X(40)

Address Type: "Ship To"

 

 

Ship To Address 1

ship_to_address1

oe-address.address1

Character

X(60)

Address Type: "Ship To"

 

 

Ship To Address 2

ship_to_address2

oe-address.address2

Character

X(60)

Address Type: "Ship To"

 

 

Ship To City

ship_to_city

oe-address.city

Character

X(36)

Address Type: "Ship To"

 

 

Ship To State

ship_to_state

oe-address.state

Character

X(3)

Address Type: "Ship To"

 

 

Ship To Zip

ship_to_postal_code

oe-address.postal-code

Character

X(30)

Address Type: "Ship To"

 

 

Ship To Country

ship_to_country_code

oe-address.country

Character

X(20)

Address Type: "Ship To"

 

 

Customer Name

customer_name

cust-by-user.cust-name

Character

X(40)

NOTE This field is blank for transfer orders.

 

 

Ship Date

ship_date

oe-header.required-date

Date

99/99/9999

 

 

 

Freight Collection Terms

terms_type_code

freight-terms.bol-terms

Character

X(25)

3rd Party=TP, PrePaid=PP, Collect=CC, Else=PP

 

 

Transportation Method/Type Code

trans_method

T

 

 

 

 

 

SCAC Code

scac_code

shipper.scac-code

Character

X(12)

If shipper available for oe-pick-ticket-hdr.ship-via. Otherwise=N/A

 

 

BOL Number

bol_number

oe-pick-ticket-trl.default-bol-num

Character

X(30)

 

 

 

Master BOL Number

master_bol_number

bol-hdr.master-bol-num

Character

X(17)

Master bill of lading of the bol_number field above

 

 

Department Number

dept_num

oe-header.dept-num

Character

X(30)

 

 

 

Internal Vendor Number

internal_vendor

oe-header.edi-internal-vendor

Character

X(20)

 

 

 

EDI Spare 1

edi_spare_1

oe-header.edi-spare-1

Character

X(8)

 

 

 

EDI Spare 2

edi_spare_2

oe-header.edi-spare-2

Character

X(8)

 

 

 

EDI Spare 3

edi_spare_3

oe-header.edi-spare-3

Character

X(8)

 

 

 

EDI Spare 4

edi_spare_4

oe-header.edi-spare-4

Character

X(8)

 

 

 

EDI Spare 5

edi_spare_5

oe-header.edi-spare-5

Character

X(8)

 

 

 

Misc. Field 1

misc_fld_1

oe-header.misc-data-1

Character

X(60)

 

 

 

Misc. Field 2

misc_fld_2

oe-header.misc-data-2

Character

X(60)

 

 

 

Order Date

order_date

oe-header.required-date

Date

99/99/9999

 

 

 

User Date 1

user_date_1

oe-header.user-date-1

Date

99/99/9999

 

 

 

User Date 2

user_date_2

oe-header.user-date-2

Date

99/99/9999

 

 

 

User Date 3

user_date_3

oe-header.user-date-3

Date

99/99/9999

 

 

 

User Date 4

user_date_4

oe-header.user-date-4

Date

99/99/9999

 

 

 

User Date 5

user_date_5

oe-header.user-date-5

Date

99/99/9999

 

 

 

User Date 6

user_date_6

oe-header.user-date-6

Date

99/99/9999

 

 

 

User Date 7

user_date_7

oe-header.user-date-7

Date

99/99/9999

 

 

 

User Date 8

user_date_8

oe-header.user-date-8

Date

99/99/9999

 

 

 

User Date 9

user_date_9

oe-header.user-date-9

Date

99/99/9999

 

 

 

User Date 10

user_date_10

oe-header.user-date-10

Date

99/99/9999

 

 

 

PO Date

po_date

oe-header.order-date

Date

99/99/9999

 

 

 

Appointment Number

appt_num

bol-hdr.appointment-num

Character

X(30)

If a valid bill of lading exists

 

 

Load Number

load_num

bol-hdr.load-num

Character

X(25)

If a valid bill of lading exists

 

 

Trailer Number

trailer_num

bol-hdr.trailer-num

Character

X(25)

If a valid bill of lading exists

 

 

Zone

zone

oe-pick-ticket-hdr.zone-name

Character

X(20)

 

 

 

Billing Customer Code

billing_cust_code

custname.cust-code

Character

X(12)

Billing customer

NOTE This field is blank for transfer orders.

 

 

Billing Customer Name

billing_cust_name

custname.cust-name

Character

X(40)

Billing customer

NOTE This field is blank for transfer orders.

 

 

Store ID

store_id

oe-address.store-id

Character

X(20)

Address Type: "Ship To"

 

 

Shipper Name

shipper_name

shipper.name

Character

X(25)

If shipper available for oe-pick-ticket-hdr.ship-via. Otherwise=""

 

 

Cancel after Date

cancel_after_date

oe-trailer.cancel-after-date

Date

99/99/9999

First oe-trailer

 

 

Customer Trade Id

cust_trade_id

edi-partner.trade-id

Character

X(25)

edi-partner from oe-header

 

 

Order Origin

EDI_Order

oe-header.origin

Character

X(10)

 

 

 

Order Class

order_class

oe-header.order-class

Character

X(10)

 

 

 

Freight Free

freight_free

oe-header.freight-free

Logical

Yes/No

 

 

 

User Defined Field 1

user_def_1

oe-header.user-defined-01

Character

X(400)

 

 

 

User Defined Field 2

user_def_2

oe-header.user-defined-02

Character

X(400)

 

 

 

User Defined Field 3

user_def_3

oe-header.user-defined-03

Character

X(400)

 

 

 

User Defined Field 4

user_def_4

oe-header.user-defined-04

Character

X(400)

 

 

 

User Defined Field 5

user_def_5

oe-header.user-defined-05

Character

X(400)

 

 

 

User Defined Field 6

user_def_6

oe-header.user-defined-06

Character

X(400)

 

 

 

User Defined Field 7

user_def_7

oe-header.user-defined-07

Character

X(400)

 

 

 

User Defined Field 8

user_def_8

oe-header.user-defined-08

Character

X(400)

 

 

 

User Defined Field 9

user_def_9

oe-header.user-defined-09

Character

X(400)

 

 

 

User Defined Field 10

user_def_10

oe-header.user-defined-10

Character

X(400)

 

 

 

User Defined Field 11

user_def_11

oe-header.user-defined-11

Character

X(400)

 

 

 

User Defined Field 12

user_def_12

oe-header.user-defined-12

Character

X(400)

 

 

 

User Defined Field 13

user_def_13

oe-header.user-defined-13

Character

X(400)

 

 

 

User Defined Field 14

user_def_14

oe-header.user-defined-14

Character

X(400)

 

 

 

User Defined Field 15

user_def_15

oe-header.user-defined-15

Character

X(400)

 

 

 

User Defined Field 16

user_def_16

oe-header.user-defined-16

Character

X(400)

 

 

 

User Defined Field 17

user_def_17

oe-header.user-defined-17

Character

X(400)

 

 

 

User Defined Field 18

user_def_18

oe-header.user-defined-18

Character

X(400)

 

 

 

User Defined Field 19

user_def_19

oe-header.user-defined-19

Character

X(400)

 

 

 

User Defined Field 20

user_def_20

oe-header.user-defined-20

Character

X(400)

 

 

 

Ship To Address 3

ship_to_address3

oe-address.address3

Character

X(30)

Address Type: "Ship To"

 

 

Ship From Address 3

ship_from_address3

address.address3

Character

X(30)

Address Type: "Physical"

 

 

Ship Status

ship_status

ship-status.status-code

Character

X(2)

BP - ship partial, backorder to follow, CC - ship complete

 

 

Customer Email

Customer_Email

contact.email-address

Character

X(254)

Email address of the primary contact of the customer for the pick demand

 

 

Shipping Account ID

shipping_account_id

oe-address.ups-account-num

Character

X(20)

 

 

 

Shipping Mode

shipping_mode

cust-shipto.preferred-ship-mode

Character

X(8)

 

 

 

Ship To Phone

ship_to_phone

oe-address.phone

Character

X(16)

Address Type: "Ship To"

 

 

Freight Terms Code

freight_collection_terms

oe-header.freight-collection-terms

Character

X(25)

 

 

 

Ship To Fax

ship_to_fax

oe-address.fax

Character

X(16)

Address Type: "Ship To"

 

 

Ship From Phone

ship_from_phone

address.phone

Character

X(16)

Address Type: "Physical"

 

 

Ship From Fax

ship_from_fax

address.fax

Character

X(16)

Address Type: "Physical"

 

 

Billing Customer Postal Code

billing_postal_code

custname.postal-code

Character

X(11)

 

 

 

 

 

 

 

 

 

PICK_NOTES

 

Note Record

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Trade ID

customer_id

edi-partner.trade-id

Character

X(25)

 

 

 

Pick Demand Number

Pick_ticket_number

oe-pick-ticket-hdr.pick-ticket-num

Character

X(12)

 

 

 

Note

note

remarks.remark-data

Character

X(10000)

Remarks from the customer, location, route, and system

 

 

 

 

 

 

 

 

PICK_DETAIL

 

Detail Record

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Trade ID

customer_id

edi-partner.trade-id

Character

X(25)

 

 

 

Pick Demand Number

Pick_ticket_number

oe-pick-ticket-hdr.pick-ticket-num

Character

X(12)

 

 

 

Line Number

line_number

Calculated

Integer

99999999

Pick demand line, starts at 1, increments for each line

 

 

Qty Ordered

quantity_ordered

oe-trailer.qty-ordered

Decimal

->>>,>>>,>>9.99<<

 

 

 

Unit of Measure (Order)

uom_code

um.um-code

Character

X(8)

From oe-trailer.um-key, possible XREF

 

 

Customer Item Number

Cust_item_number

oe-cust-prod.customer-product-id

Character

X(40)

NOTE This field is blank for transfer orders.

 

 

Product UPC Code

prod_upc_code

oe-cust-prod.cust-upc-code

Character

X(20)

May be overridden with product-um.upc if one exists

 

 

Product Code

prod_code

product.product-code

Character

X(40)

 

 

 

Product Weight

prod_wt

oe-trailer.unit-weight

Decimal

>>>,>>>,>>9.99

oe-trailer.unit-weight * oe-pick-ticket-trl.recommended-qty

 

 

Item Name

item_name

oe-trailer.line-item-name

Character

x(40)

Assigned at the time of line item creation from product.product-name

 

 

Item Description

item_description

product.description

Character

X(30)

 

 

 

Sequence Number

original_seq

oe-pick-ticket-trl.original-sequence

Integer

99999999

 

 

 

Bin

Bin

oe-pick-ticket-trl.recommended-bin-name

Character

X(20)

If not "%NONE%" in Apprise

 

 

Lot

Lot

oe-pick-ticket-trl.recommended-lot

Character

X(20)

If not "%NONE%" in Apprise

 

 

EDI Spare 1

edi_spare_1

oe-trailer.edi-spare-1

Character

X(12)

 

 

 

EDI Spare 2

edi_spare_2

oe-trailer.edi-spare-2

Character

X(12)

 

 

 

EDI Spare 3

edi_spare_3

oe-trailer.edi-spare-3

Character

X(12)

 

 

 

EDI Spare 4

edi_spare_4

oe-trailer.edi-spare-4

Character

X(12)

 

 

 

EDI Spare 5

edi_spare_5

oe-trailer.edi-spare-5

Character

X(12)

 

 

 

Misc. Field 1

misc_fld_1

oe-trailer.misc-data-1

Character

X(60)

 

 

 

Misc. Field 2

misc_fld_2

oe-trailer.misc-data-2

Character

X(60)

 

 

 

Unit of Measure (Pick Demand)

uom_code2

oe-pick-ticket-trl.recommended-um

Character

X(8)

Possible XREF

 

 

Product UPC Code (XRef)

prod_upc_code_xref

oe-cust-prod.cust-upc-code

Character

X(20)

NOTE This field is blank for transfer orders.

 

 

Master Carton U/M

master_carton

um-rates.conversion-factor

Decimal

->>>,>>>,>>9.99<<<<<<<<

Conversion factor from the master carton unit of measure to the inner pack unit of measure

 

 

Inner Pack U/M

inner_pack

um-rates.conversion-factor

Decimal

->>>,>>>,>>9.99<<<<<<<<

Conversion factor from the inner pack unit of measure to the product unit of measure

 

 

Serial

serial

oe-pick-ticket-trl.recommended-serial

Character

X(40)

If not "%NONE%" in Apprise

 

 

Order Number

order_num

oe-trailer.order-num

Character

X(12)

 

 

 

GTIN (Product)

product_GTIN

product.gtin

Character

X XXXXXXX XXXXX X

 

 

 

GTIN (Pick Demand U/M)

pick_um_GTIN

product-um.gtin

Character

X XXXXXXX XXXXX X

Product-um record of oe-pick-ticket-trl.recommended-um

 

 

Qty Picked

quantity_picked

oe-pick-ticket-trl.recommended-qty

Decimal

->>>,>>>,>>9.99<<

Converted from the product unit of measure to the recommended unit of measure

 

 

EDI Order Line Number

edi_order_line_num

oe-trailer.edi-order-line-num

Character

X(20)

If blank, use oe-trailer.line-num

 

 

Warehouse Product Code

wh_prod_code

oe-prod-location.wh-prod-code

Character

X(40)

 

 

 

Warehouse Product Name

wh_prod_name

oe-prod-location.wh-prod-name

Character

X(40)

 

 

 

User Defined Field 1

user_def_1

oe-trailer.user-defined-01

Character

X(400)

 

 

 

User Defined Field 2

user_def_2

oe-trailer.user-defined-02

Character

X(400)

 

 

 

User Defined Field 3

user_def_3

oe-trailer.user-defined-03

Character

X(400)

 

 

 

User Defined Field 4

user_def_4

oe-trailer.user-defined-04

Character

X(400)

 

 

 

User Defined Field 5

user_def_5

oe-trailer.user-defined-05

Character

X(400)

 

 

 

User Defined Field 6

user_def_6

oe-trailer.user-defined-06

Character

X(400)

 

 

 

User Defined Field 7

user_def_7

oe-trailer.user-defined-07

Character

X(400)

 

 

 

User Defined Field 8

user_def_8

oe-trailer.user-defined-08

Character

X(400)

 

 

 

User Defined Field 9

user_def_9

oe-trailer.user-defined-09

Character

X(400)

 

 

 

User Defined Field 10

user_def_10

oe-trailer.user-defined-10

Character

X(400)

 

 

 

User Defined Field 11

user_def_11

oe-trailer.user-defined-11

Character

X(400)

 

 

 

User Defined Field 12

user_def_12

oe-trailer.user-defined-12

Character

X(400)

 

 

 

User Defined Field 13

user_def_13

oe-trailer.user-defined-13

Character

X(400)

 

 

 

User Defined Field 14

user_def_14

oe-trailer.user-defined-14

Character

X(400)

 

 

 

User Defined Field 15

user_def_15

oe-trailer.user-defined-15

Character

X(400)

 

 

 

User Defined Field 16

user_def_16

oe-trailer.user-defined-16

Character

X(400)

 

 

 

User Defined Field 17

user_def_17

oe-trailer.user-defined-17

Character

X(400)

 

 

 

User Defined Field 18

user_def_18

oe-trailer.user-defined-18

Character

X(400)

 

 

 

User Defined Field 19

user_def_19

oe-trailer.user-defined-19

Character

X(400)

 

 

 

User Defined Field 20

user_def_20

oe-trailer.user-defined-20

Character

X(400)

 

 

 

Ship Status

ship_status

ship-status.status-code

Character

X(2)

BP - ship partial, backorder to follow, CC - ship complete