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 |