The following table lists the format for exporting in EDI Return Merchandise Authorization Export.
|
Map Table |
M |
Description |
Field Name |
Apprise Table/Field |
Data Type |
Format |
Notes |
|
RMA_HEADER |
|
Header Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trading Partner |
customer_id |
edi-partner.trade-id |
Character |
X(25) |
|
|
|
|
Pick Demand Number |
ticket_num |
oe-pick-ticket-hdr.pick-ticket-num |
Character |
X(12) |
|
|
|
|
Order Number |
order_num |
oe-pick-ticket-order.order-num |
Character |
X(12) |
|
|
|
|
RA # |
ra_num |
oe-header.ra-num |
Character |
X(12) |
|
|
|
|
Internal Vendor Number |
internal_vendor_number |
edi-partner.edi-internal-vendor |
Character |
X(20) |
|
|
|
|
Department Number |
dept_num |
edi-partner.dept-num |
Character |
X(30) |
|
|
|
|
Date Returned |
return_date |
oe-pick-ticket-hdr.created-date |
Date |
99/99/9999 |
|
|
|
|
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) |
|
|
|
|
PO Number |
po_number |
oe-header.cust-po-number |
Character |
X(20) |
|
|
|
|
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) |
|
|
|
|
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) |
|
|
|
|
|
|
|
|
|
|
|
RMA_DETAIL |
|
Detail Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trade ID |
customer_id |
edi-partner.trade-id |
Character |
X(25) |
|
|
|
|
Pick Demand Number |
ticket_num |
oe-pick-ticket-hdr.pick-ticket-num |
Character |
X(12) |
|
|
|
|
Sequence |
sequence |
oe-pick-ticket-trl.sequence |
Integer |
999999999 |
|
|
|
|
Reference Number |
ref_num |
|
|
|
Not output to |
|
|
|
Product Code |
prod_code |
product.product-code |
Character |
X(40) |
|
|
|
|
Customer Product Code |
prod_code_xref |
oe-cust-prod.customer-product-id |
Character |
X(40) |
If no oe-cust-prod, uses EDI Xref |
|
|
|
Product Name |
prod_name |
product.product-name |
Character |
X(40) |
|
|
|
|
Customer Product Name |
prod_name_xref |
oe-cust-prod.customer-product-name |
Character |
X(40) |
If no oe-cust-prod, uses EDI Xref |
|
|
|
Unit of Measure |
uom_code |
um.um-code |
Character |
X(8) |
|
|
|
|
Customer Unit of Measure |
uom_code_xref |
um.um-code |
Character |
X(8) |
EDI Xref |
|
|
|
UPC Code |
upc_code |
|
|
|
Not output to |
|
|
|
Customer UPC Code |
upc_code_xref |
oe-cust-prod.cust-upc-code |
Character |
X(20) |
|
|
|
|
Quantity Returned |
qty_returned |
oe-pick-ticket-trl.picked-qty |
Decimal |
->>>,>>>,>>9.99<< |
Sum of picked quantity across oe-pick-ticket-trailers |
|
|
|
Return Price |
unit_return_price |
oe-pick-ticket-trl.return-unit-price |
Decimal |
->>>,>>>,>>9.99<< |
|
|
|
|
Return Code |
return_code |
oe-trailer.return-code |
Character |
X(10) |
|
|
|
|
Customer Return Code |
return_code_xref |
edi-xref.partner-code |
Character |
X(16) |
|
|
|
|
PO Number |
po_number |
oe-header.cust-po-number |
Character |
X(20) |
|
|
|
|
PO Date |
po_date |
oe-header.order-date |
Date |
99/99/9999 |
|
|
|
|
PO Line |
po_line |
arinvitm.order-line-num |
Integer |
>>>9 |
|
|
|
|
EDI Spare 1 |
edi_spare_1 |
oe-trailer.edi-spare-1 |
Character |
X(8) |
|
|
|
|
EDI Spare 2 |
edi_spare_2 |
oe-trailer.edi-spare-2 |
Character |
X(8) |
|
|
|
|
EDI Spare 3 |
edi_spare_3 |
oe-trailer.edi-spare-3 |
Character |
X(8) |
|
|
|
|
EDI Spare 4 |
edi_spare_4 |
oe-trailer.edi-spare-4 |
Character |
X(8) |
|
|
|
|
EDI Spare 5 |
edi_spare_5 |
oe-trailer.edi-spare-5 |
Character |
X(8) |
|
|
|
|
Country of Origin |
country_of_origin |
product.country-of-origin |
Character |
X(10) |
|
|
|
|
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) |
|
|
|
|
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) |
|
|
|
|
|
|
|
|
|
|
|
RMA_SUMMARY |
|
Summary Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trade ID |
customer_id |
edi-partner.trade-id |
Character |
X(25) |
Or outbound ID |
|
|
|
Pick Demand Number |
ticket_num |
oe-pick-ticket-hdr.pick-ticket-num |
Character |
X(12) |
|
|
|
|
Product Count |
prod_count |
N/A |
Integer |
>>>9 |
Count of products in detail records |