The following table lists the format when exporting in EDI Inventory Inquiry/Advice Export.
Map Table |
M |
Description |
Field Name |
Apprise Table/Field |
Data Type |
Format |
Notes |
INV_HEADER |
x |
Header Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Customer Code |
customer_id |
edi-partner.trade-id |
Character |
X(25) |
Or outbound ID |
|
|
Internal Vendor Number |
internal_vendor_number |
edi-partner.edi-internal-vendor |
Character |
X(20) |
|
|
|
Reference Number |
ref_num |
STRING(TODAY) + "-" + STRING(TIME) |
Character |
X(14) |
|
|
|
|
|
|
|
|
|
INV_DETAIL |
x |
Detail Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Country of Origin |
country_of_origin |
product.country-of-origin |
Character |
X(10) |
|
|
|
Customer Code |
customer_id |
edi-partner.trade-id |
Character |
X(25) |
Or outbound ID |
|
|
Customer Product Code |
prod_code_xref |
oe-cust-prod.customer-product-id |
Character |
X(40) |
|
|
|
Customer Product Name |
prod_name_xref |
oe-cust-prod.customer-product-name |
Character |
X(40) |
|
|
|
Department Number |
dept_num |
edi-partner.dept-num |
Character |
X(20) |
|
|
|
Discontinued |
discontinued_flag |
oe-cust-prod/product/oe-prod-location.discontinued |
Logical |
YES/NO |
Each level is checked in this order. Product and oe-prod-location levels are only checked if a specific location is used (rather than all locations) |
|
|
Discontinued Date |
discontinued_date |
oe-cust-prod/product/oe-prod-location.discontinued-date |
Date |
YYYYMMDD |
|
|
|
Expected Quantity |
expect_qty |
edi-846-ctl.expect-qty |
Decimal |
->>,>>>,>>9.99 |
Only if an edi-846-ctl record is present for the product |
|
|
GTIN |
gtin |
product.gtin |
Character |
X(17) |
Format: X XXXXXXX XXXXX X |
|
|
Inventory Advice Management Quantity |
inv_advice_qty |
round-up(edi-846-ctl.inv-advice-qty) |
Decimal |
->>,>>>,>>9.99 |
Only if an edi-846-ctl record is present for the product |
|
|
List Price 1 |
list_price_1 |
product-price.price |
Decimal |
ZZZ,ZZZ,ZZ9.9999 |
For list-price-sequence = 1. The location is based on oe-prod-location of the default sales location. Otherwise, %NONE% is used |
|
|
List Price 2 |
list_price_2 |
product-price.price |
Decimal |
ZZZ,ZZZ,ZZ9.9999 |
For list-price-sequence = 2. The location is based on oe-prod-location of the default sales location. Otherwise, %NONE% is used |
|
|
List Price 3 |
list_price_3 |
product-price.price |
Decimal |
ZZZ,ZZZ,ZZ9.9999 |
For list-price-sequence = 3. The location is based on oe-prod-location of the default sales location. Otherwise, %NONE% is used |
|
|
List Price 4 |
list_price_4 |
product-price.price |
Decimal |
ZZZ,ZZZ,ZZ9.9999 |
For list-price-sequence = 4. The location is based on oe-prod-location of the default sales location. Otherwise, %NONE% is used |
|
|
Location Name |
location_name |
location.location-name |
Character |
X(20) |
This is the location name selected for the export, or All when selecting all locations. |
|
|
Location Prefix |
location_prefix |
location.location-prefix |
Character |
X(3) |
This is the location prefix selected for the export, or All when selecting all locations. |
|
|
Misc. Field 1 |
misc_user_1 |
oe-cust-prod.misc-user-1 |
Character |
X(30) |
|
|
|
Misc. Field 2 |
misc_user_2 |
oe-cust-prod.misc-user-2 |
Character |
X(30) |
|
|
|
Product Code |
prod_code |
product.product-code |
Character |
X(40) |
|
|
|
Product Name |
prod_name |
product.product-name |
Character |
X(40) |
|
|
|
Promise Date for All Locations |
promise_date_all_locations |
edi-846-ctl.promise-date |
Date |
YYYYMMDD |
If an edi-846-ctl record is not present or contains a blank date, the software checks all shipping locations for the product's delivery date. The shipping locations are prioritized in the following sequence: the selected shipping location, the trading partner shipping location, the customer shipping location, the earliest delivery date from all other shipping locations. If no delivery date is found, then no value is used. |
|
|
Promise Date for Shipping Location |
promise_date |
edi-846-ctl.promise-date |
Date |
YYYYMMDD |
If an edi-846-ctl record is not present, or contains a blank date, uses the product's delivery date for the selected shipping location. If all shipping locations were selected, the trading partner's shipping location is used. If the trading partner's shipping location is blank, the customer's shipping location is used instead. If the customer shipping location is also blank, then no value is used. If no delivery date is found for the shipping location, then no value is used. |
|
|
Quantity Available |
qty_avail |
Sum of inventory.qoh with other quantities subtracted out |
Decimal |
->>,>>>,>>9.99 |
Sums quantity available for the given shipping location |
|
|
Quantity Available - All Locations |
qty_avail_all |
Sum of inventory.qoh with other quantities subtracted out |
Decimal |
->>,>>>,>>9.99 |
Sum quantity available for all locations |
|
|
Quantity Available - Default Location |
qty_avail_dflt |
Sum of inventory.qoh with other quantities subtracted out |
Decimal |
->>,>>>,>>9.99 |
Sum quantity available for the default shipping location for the edi-partner |
|
|
Quantity On Hand |
qty_oh |
Sum of inventory.qoh |
Decimal |
->>,>>>,>>9.99 |
Sums quantity on hand for the given shipping location |
|
|
Quantity On Hand - All Locations |
qty_oh_all |
Sum of inventory.qoh |
Decimal |
->>,>>>,>>9.99 |
Sum quantity on hand for all locations |
|
|
Quantity On Hand - Default Location |
qty_oh_dflt |
Sum of inventory.qoh |
Decimal |
->>,>>>,>>9.99 |
Sum quantity on hand for the default shipping location on the edi-partner |
|
|
Quantity on Order |
qty_oo |
Sum of inventory.qoo |
Decimal |
->>,>>>,>>9.99 |
Sums quantity on order for the given shipping location |
|
|
Quantity on Order - All Locations |
qty_oo_all |
Sum of inventory.qoo |
Decimal |
->>,>>>,>>9.99 |
Sum quantity on order for all locations |
|
|
Quantity on Order - Default Location |
qty_oo_dflt |
Sum of inventory.qoo |
Decimal |
->>,>>>,>>9.99 |
Sum quantity on order for the default shipping location on the edi-partner |
|
|
Quantity Reserved |
qty_reserved |
Sum of oe-cust-alloc.qalloc |
Decimal |
->>,>>>,>>9.99 |
Sums only allocations for the given shipping location |
|
|
Quantity Reserved - All Locations |
qty_reserved_all |
Sum of oe-cust-alloc.qalloc |
Decimal |
->>,>>>,>>9.99 |
Uses EACH oe-prod-location to find allocations |
|
|
Quantity Reserved - Default Location |
qty_reserved_dflt |
Sum of oe-cust-alloc.qalloc |
Decimal |
->>,>>>,>>9.99 |
Sums only allocations for the default shipping location |
|
|
Quantity Restricted |
qty_restricted |
oe-sls-rsrv.qty-rsrvd - oe-sls-rsrv.qty-used |
Decimal |
->>,>>>,>>9.99 |
Searches sales reservations to determine this amount |
|
|
Reference Number |
ref_num |
STRING(TODAY) + "-" + STRING(TIME) |
Character |
X(14) |
|
|
|
Sales Reservations |
sales_reservations |
|
Logical |
|
This is Yes if the product is set up for sales reservations. |
|
|
U/M Code |
uom_code |
um.um-code |
Character |
X(8) |
Selling unit of measure |
|
|
U/M Code Xref |
uom_code_xref |
EDI xref for uom_code |
Character |
X(8) |
|
|
|
Unit Price |
unit_price |
Current unit price from price matrix |
Decimal |
>>,>>>,>>9.99 |
|
|
|
UPC Code |
upc_code |
product.upc-code |
Character |
X(25) |
|
|
|
UPC Code Xref |
upc_code_xref |
oe-cust-prod.cust-upc-code |
Character |
X(20) |
|
|
|
|
|
|
|
|
|
INV_LOCATION_DETAIL |
|
Location Detail Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Customer Code |
customer_id |
edi-partner.trade-id |
Character |
X(25) |
|
|
|
Location Name |
location_name |
location.location-name |
Character |
X(20) |
|
|
|
Location Prefix |
location_prefix |
location.location-prefix |
Character |
X(3) |
|
|
|
Product Code |
prod_code |
product.product-code |
Character |
X(40) |
|
|
|
Quantity Available |
qty_avail |
Sum of inventory.qoh with other quantities subtracted out |
Decimal |
->>,>>>,>>9.99 |
|
|
|
Quantity On Hand |
qty_oh |
Sum of inventory.qoh |
Decimal |
->>,>>>,>>9.99 |
|
|
|
Quantity on Order |
qty_oo |
Sum of inventory.qoo |
Decimal |
->>,>>>,>>9.99 |
|
|
|
Quantity Reserved |
qty_reserved |
Sum of oe-cust-alloc.qalloc |
Decimal |
->>,>>>,>>9.99 |
|
|
|
Reference Number |
ref_num |
STRING(TODAY) + "-" + STRING(TIME) |
Character |
X(14) |
|
|
|
|
|
|
|
|
|
INV_SUMMARY |
|
Summary Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Customer Code |
customer_id |
edi-partner.trade-id |
Character |
X(25) |
Or outbound ID |
|
|
Product Count |
prod_count |
Count of number of products in this 846 export |
Integer |
|
|
|
|
Reference Number |
ref_num |
STRING(TODAY) + "-" + STRING(TIME) |
Character |
X(14) |
|