The following table lists the format for exporting in EDI Price/Sales Catalog Export.
Map Table |
M |
Description |
Field Name |
Apprise Table/Field |
Data Type |
Format |
Notes |
CAT_HEADER |
x |
Header Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trade ID |
customer_id |
edi-partner.trade-id |
Character |
X(25) |
Or outbound ID |
|
|
Catalog Number |
ref_num |
String(TIME) |
Character |
|
A unique number |
|
|
Description |
cat_desc |
Hardcoded value "N/A" |
|
|
|
|
|
Action Code |
action_code |
Hardcoded value "02" |
|
|
|
|
|
Date of Change |
date_change |
Today's date |
Date |
DD/MM/YYYY |
|
|
|
Vendor Number |
vend_no |
edi-partner.edi-internal-vendor |
Character |
X(20) |
|
|
|
Country |
origin |
address.country |
Character |
X(20) |
System physical address |
|
|
Name |
vend_name |
address.name |
Character |
X(40) |
System physical address |
|
|
|
|
|
|
|
|
CAT_DETAIL |
x |
Detail Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trade ID |
customer_id |
edi-partner.trade-id |
Character |
X(25) |
Or outbound ID |
|
|
Catalog Number |
ref_num |
String(TIME) |
Character |
|
A unique number |
|
|
Line Number |
line_num |
Detail line num in order of process |
Integer |
|
|
|
|
Style With Color and Size |
style_1 |
color-code.nrf-color-code |
Integer |
>>9 |
Concatenation of all nrf-color-codes and size.size-codes, N/A if blank |
|
|
UPC Code |
upc_code |
product.upc-code |
Character |
X(25) |
|
|
|
Color Code |
color_code |
color-code.color-code |
Character |
X(8) |
|
|
|
Size Code |
size_code |
size-code.size-code |
Character |
X(8) |
N/A if blank |
|
|
Style Without Color and Size |
style_2 |
product-styles.product-style |
Character |
X(12) |
N/A if blank |
|
|
Product Code |
sku |
product.product-code |
Character |
X(40) |
|
|
|
Date of Change |
date_change |
Today's date |
Date |
DD/MM/YYYY |
|
|
|
Minimum Order Quantity |
min_qty |
oe-cust-prod.cust-order-min |
Decimal |
ZZZ,ZZ9.99 |
Else, product.order-min |
|
|
Product Description |
prod_desc |
oe-cust-prod.customer-product-name |
Character |
X(40) |
Else, product.description |
|
|
Reorder/Seasonal |
reorder |
season-class.season-class-code |
Character |
X(20) |
|
|
|
No of Packs |
numpacks |
Number of packs in package unit of measure |
Integer |
>>9 |
|
|
|
No of Inner Packs |
numinpacks |
Hardcoded value 1 |
Integer |
>>9 |
|
|
|
Volume |
vol |
product.cube |
Decimal |
ZZZ,ZZ9.9999 |
|
|
|
Volume UM |
vuom |
edi-code, or if it that is blank, um.um-code |
Character |
X(8) |
|
|
|
Unit Weight |
unitwt |
product.unit-weight |
Decimal |
ZZZ,ZZ9.9999 |
|
|
|
List Price 1 |
listp1 |
Current list price 1 of product |
Decimal |
->>>,>>>,>>9.99<< |
|
|
|
List Price 2 |
listp2 |
Current list price 2 of product |
Decimal |
->>>,>>>,>>9.99<< |
|
|
|
List Price 3 |
listp3 |
Current list price 3 of product |
Decimal |
->>>,>>>,>>9.99<< |
|
|
|
List Price 4 |
listp4 |
Current list price 4 of product |
Decimal |
->>>,>>>,>>9.99<< |
|
|
|
Unit Price U/M |
upuom |
edi-code, or if it that is blank, um.um-code |
Character |
X(8) |
|
|
|
Country of Origin |
country_of_origin |
product.country-of-origin |
Character |
X(10) |
|
|
|
Customer Product Code |
cust_prod_code |
oe-cust-prod.customer-product-id |
Character |
X(40) |
|
|
|
Customer Product Price |
cust_prod_price |
oe-cust-prod.retail-price |
Decimal |
->>>,>>>,>>9.99<< |
|
|
|
832 Status |
stat_832 |
oe-cust-prod.edi-832-status |
Character |
X(1) |
|
|
|
NRF Color Code |
nrf_color_code |
color-code.nrf-color-code |
Character |
X(3) |
|
|
|
NRF Size Code |
nrf_size_code |
size-code.nrf-size-code |
Character |
X(5) |
|
|
|
NRF Size Description |
nrf_size_desc |
size-code.nrf-size-description |
Character |
X(60) |
|
|
|
NRF Color Description |
nrf_color_desc |
color-code.nrf-color-description |
Character |
X(60) |
|
|
|
NMFC Number |
NMFC_Number |
NMFC-def.NMFC-Number |
Character |
X(16) |
|
|
|
NMFC Description |
NMFC_Description |
NMFC-def.Commodity-Description |
Character |
X(80) |
|
|
|
NMFC Class |
NMFC_Class |
NMFC-def.Freight-Class |
Character |
X(6) |
|
|
|
Multiple Order Quantity |
mult_qty |
oe-cust-prod.cust-order-multiple, or if that is blank, product.order-multiple |
Decimal |
ZZZ,ZZ9.99 |
|
|
|
Product Name |
prod_name |
product.product-name |
Character |
X(40) |
|
|
|
Package U/M |
puom |
edi-code, or if it that is blank, um.um-code |
Character |
X(8) |
|
|
|
|
|
|
|
|
|
INV_SUMMARY |
|
Summary Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trade ID |
customer_id |
edi-partner.trade-id |
Character |
X(25) |
Or outbound ID |
|
|
Catalog Number |
ref_num |
String(TIME) |
Character |
|
A unique number |
|
|
Total Line Items |
total_lines |
Number of products in catalog |
Integer |
|
|
|
|
Total Weight |
total_weight |
Total weight of products in catalog |
Decimal |
ZZZ,ZZ9.9999 |
|
|
|
Total Volume |
total_volume |
Total volume of products in catalog |
Decimal |
ZZZ,ZZ9.9999 |
|
|
|
Weight UM |
Weight_um |
Unit of measure of above weight |
Character |
X(8) |
|
|
|
Volume UM |
Volume_um |
Unit of measure of above volume |
Character |
X(8) |
|