The following table lists the format for exporting in EDI Order Acknowledgment Export.
|
Map Table |
M |
Description |
Field Name |
Apprise Table/Field |
Data Type |
Format |
Notes |
|
POACK_HEADER |
x |
Header Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trade ID |
customer_id |
edi-partner.trade-id |
Character |
X(25) |
Or outbound ID |
|
|
|
PO Type |
po_type |
oe-header.order-type |
Character |
X(12) |
|
|
|
|
PO Number |
po_number |
oe-header.cust-po-number |
Character |
X(20) |
|
|
|
|
Contract Number |
po_contract_num |
oe-contract.contract-code |
Character |
X(20) |
|
|
|
|
Created Date |
create_date |
oe-header.created-date |
Date |
99/99/9999 |
|
|
|
|
Entered Currency |
ent_curr |
oe-header.entered-currency |
Character |
X(8) |
|
|
|
|
Department Number |
dept_num |
oe-header.dept-num |
Character |
X(30) |
|
|
|
|
Internal Vendor Number |
internal_vendor |
oe-header.edi-internal-vendor |
Character |
X(20) |
|
|
|
|
Store ID |
store_id |
This is the first store ID found in the following sequence:
|
|
|
|
|
|
|
EDI Spare 1 |
edi_spare_1 |
oe-header.edi-spare-1 |
Character |
X(8) |
See *** below |
|
|
|
EDI Spare 2 |
edi_spare_2 |
oe-header.edi-spare-2 |
Character |
X(8) |
See *** below |
|
|
|
EDI Spare 3 |
edi_spare_3 |
oe-header.edi-spare-3 |
Character |
X(8) |
See *** below |
|
|
|
EDI Spare 4 |
edi_spare_4 |
oe-header.edi-spare-4 |
Character |
X(8) |
See *** below |
|
|
|
EDI Spare 5 |
edi_spare_5 |
oe-header.edi-spare-5 |
Character |
X(8) |
See *** below |
|
|
|
ShipTo Contact Name |
shipto_contact_name |
oe-address.contact |
Character |
X(30) |
|
|
|
|
ShipTo Phone |
shipto_phone |
oe-address.phone |
Character |
X(30) |
|
|
|
|
ShipTo Fax |
shipto_fax |
oe-address.fax |
Character |
X(30) |
|
|
|
|
FOB |
shipment_method_of_payment |
fob.fob-code |
Character |
X(12) |
|
|
|
|
Backorder Flag |
backorder_flag |
oe-header.backordered |
Logical |
Yes/No |
|
|
|
|
Payment Terms Code |
pay_terms_code |
payment-terms.terms-code |
Character |
X(12) |
See *** below |
|
|
|
Required Date |
required_date |
oe-header.required-date |
Date |
99/99/9999 |
See *** below |
|
|
|
Cancel Date |
cancel_date |
oe-trailer.cancel-after-date |
Date |
99/99/9999 |
Cancel-after date of the first oe-trailer record. See *** Below |
|
|
|
Order User Date 1 |
user_date_1 |
oe-header.user-date-1 |
Date |
99/99/9999 |
See *** below |
|
|
|
Order User Date 2 |
user_date_2 |
oe-header.user-date-2 |
Date |
99/99/9999 |
See *** below |
|
|
|
Order User Date 3 |
user_date_3 |
oe-header.user-date-3 |
Date |
99/99/9999 |
See *** below |
|
|
|
Order User Date 4 |
user_date_4 |
oe-header.user-date-4 |
Date |
99/99/9999 |
See *** below |
|
|
|
Order User Date 5 |
user_date_5 |
oe-header.user-date-5 |
Date |
99/99/9999 |
See *** below |
|
|
|
Order User Date 6 |
user_date_6 |
oe-header.user-date-6 |
Date |
99/99/9999 |
See *** below |
|
|
|
Order User Date 7 |
user_date_7 |
oe-header.user-date-7 |
Date |
99/99/9999 |
See *** below |
|
|
|
Order User Date 8 |
user_date_8 |
oe-header.user-date-8 |
Date |
99/99/9999 |
See *** below |
|
|
|
Order User Date 9 |
user_date_9 |
oe-header.user-date-9 |
Date |
99/99/9999 |
See *** below |
|
|
|
Order User Date 10 |
user_date_10 |
oe-header.user-date-10 |
Date |
99/99/9999 |
See *** below |
|
|
|
Shipper Code |
shipper_code |
oe-header.preferred-shipper |
Character |
X(12) |
|
|
|
|
Shipper Name |
shipper_text |
shipper.name |
|
|
|
|
|
|
Shipping Method |
transportation_method |
oe-header.shipping-method |
|
|
|
|
|
|
Order Number |
po_reference |
oe-header.order-num |
Character |
X(12) |
|
|
|
|
Ship To Code |
ship_to_id_code |
oe-address.edi-address-code |
Character |
X(30) |
|
|
|
|
Ship To Company Name |
ship_to_company_name |
oe-address.name |
Character |
X(40) |
|
|
|
|
Ship To Additional Name |
ship_to_additional_name |
|
|
|
Not output to |
|
|
|
Ship To Address 1 |
ship_to_address1 |
oe-address.address1 |
Character |
X(60) |
|
|
|
|
Ship To Address 2 |
ship_to_address2 |
oe-address.address2 |
Character |
X(60) |
|
|
|
|
Ship to City |
ship_to_city |
oe-address.city |
Character |
X(36) |
|
|
|
|
Ship to State |
ship_to_state |
oe-address.state |
Character |
X(3) |
|
|
|
|
Ship to Postal Code |
ship_to_postal_code |
oe-address.postal-code |
Character |
X(30) |
|
|
|
|
Ship to Country Code |
ship_to_country_code |
oe-address.country |
Character |
X(20) |
|
|
|
|
Bill To Code |
bill_to_id_code |
oe-address.edi-address-code |
Character |
X(30) |
|
|
|
|
Bill To Company Name |
bill_to_company_name |
oe-address.name |
Character |
X(40) |
|
|
|
|
Bill To Additional Name |
bill_to_additional_name |
|
|
|
Not output to |
|
|
|
Bill To Address 1 |
bill_to_address1 |
oe-address.address1 |
Character |
X(60) |
|
|
|
|
Bill To Address 2 |
bill_to_address2 |
oe-address.address2 |
Character |
X(60) |
|
|
|
|
Bill To City |
bill_to_city |
oe-address.city |
Character |
X(36) |
|
|
|
|
Bill To State |
bill_to_state |
oe-address.state |
Character |
X(3) |
|
|
|
|
Bill To Zip |
bill_to_postal_code |
oe-address.postal-code |
Character |
X(30) |
|
|
|
|
Bill To Country |
bill_to_country_code |
oe-address.country |
Character |
X(20) |
|
|
|
|
Misc. Field 1 |
misc_fld_1 |
oe-header.misc-data-1 |
Character |
X(60) |
See *** below |
|
|
|
Misc. Field 2 |
misc_fld_2 |
oe-header.misc-data-2 |
Character |
X(60) |
See *** below |
|
|
|
Task Id |
task_id |
edi-855-task-hdr.task-id |
Character |
X(12) |
|
|
|
|
Freight Collection Terms |
freight_terms |
oe-header.freight-collection-terms |
Character |
X(20) |
See *** below |
|
|
|
Earliest Ship Date |
earliest_ship_date |
oe-header.earliest-ship-date |
Date |
99/99/9999 |
See *** below |
|
|
|
Latest Ship Date |
latest_ship_date |
oe-header.latest-ship-date |
Date |
99/99/9999 |
See *** below |
|
|
|
Acknowledgment Status |
ack_status |
edi-855-task-hdr.ack-status |
Character |
X(8) |
|
|
|
|
Acknowledgment Count |
edi_count |
edi-855-task-hdr.edi-855-count |
Integer |
>>,>>>,>>9 |
This is the number of times a specific 855 task was processed. |
|
|
|
Purchase Order Acknowledgment Type |
include_detail |
edi-ord-ack-ctl.po-ack-type |
Character |
X(20) |
|
|
|
|
Includes Changes |
include_change |
edi-855-task-trl.include-in-export |
Logical |
Yes/No |
|
|
|
|
Order Date |
order_date |
oe-header.order-date |
Date |
99/99/9999 |
|
|
|
|
Freight Terms Code XREF |
freight_terms_xrf |
oe-header.freight-collection-terms EDI xref |
Character |
X(20) |
|
|
|
|
PO 855 Count |
po_855_count |
oe-header.edi-855-count |
Integer |
|
This is the number of times a distinct 855 task was generated for a specific order. |
|
|
|
Released for Shipment |
released_for_shipment |
|
Logical |
|
|
|
|
|
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) |
|
|
|
|
|
|
|
|
|
|
|
POACK_DETAIL |
x |
Detail Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trade ID |
customer_id |
edi-partner.trade-id |
Character |
X(25) |
Or outbound ID |
|
|
|
PO Number |
po_number |
oe-header.cust-po-number |
Character |
X(20) |
|
|
|
|
Line Number |
line_number |
oe-trailer.line-num or oe-trailer.edi-order-line-num |
Integer or Character |
>>>9 or X(20) |
The field used depends on whether edi-line-num exists (the customer's line number is different from the line number in Apprise). |
|
|
|
Current Quantity |
quantity_ordered |
oe-trailer.qty-ordered |
Decimal |
->>>,>>>,>>9.99<< |
|
|
|
|
UOM Code |
uom_code |
um.um-code |
Character |
X(8) |
|
|
|
|
UOM Code XREF |
uom_code_xrf |
um.um-code EDI xref |
Character |
X(8) |
|
|
|
|
Extended Unit Price |
unit_price |
oe-trailer.unit-price + oe-trailer.price-adjustment |
Character |
->,>>>,>>9.99 |
|
|
|
|
Product Code |
product_code |
oe-trailer.product-code |
Character |
X(40) |
|
|
|
|
Customer Product Code |
cust_product_code |
oe-cust-prod.customer-product-id |
Character |
X(40) |
|
|
|
|
UPC Code |
upc_code |
product.upc-code |
Character |
X(25) |
|
|
|
|
Unit Price |
item_price |
oe-trailer.unit-price |
|
|
|
|
|
|
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. |
|
|
|
Item Description |
item_description |
oe-trailer.line-item-name |
Character |
X(40) |
|
|
|
|
EDI Spare 1 |
edi_spare_1 |
oe-trailer.edi-spare-1 |
Character |
X(12) |
See *** below |
|
|
|
EDI Spare 2 |
edi_spare_2 |
oe-trailer.edi-spare-2 |
Character |
X(12) |
See *** below |
|
|
|
EDI Spare 3 |
edi_spare_3 |
oe-trailer.edi-spare-3 |
Character |
X(12) |
See *** below |
|
|
|
EDI Spare 4 |
edi_spare_4 |
oe-trailer.edi-spare-4 |
Character |
X(12) |
See *** below |
|
|
|
EDI Spare 5 |
edi_spare_5 |
oe-trailer.edi-spare-5 |
Character |
X(12) |
See *** below |
|
|
|
Product User Defined Field 1 |
prod_usr_def_fld_1 |
product.usr-def-fld-1 |
Character |
X(400) |
|
|
|
|
Product User Defined Field 2 |
prod_usr_def_fld_2 |
product.usr-def-fld-2 |
Character |
X(400) |
|
|
|
|
Product User Defined Field 3 |
prod_usr_def_fld_3 |
product.usr-def-fld-3 |
Character |
X(400) |
|
|
|
|
Product User Defined Field 4 |
prod_usr_def_fld_4 |
product.usr-def-fld-4 |
Character |
X(400) |
|
|
|
|
Product User Defined Field 5 |
prod_usr_def_fld_5 |
product.usr-def-fld-5 |
Character |
X(400) |
|
|
|
|
Product User Defined Field 6 |
prod_usr_def_fld_6 |
product.usr-def-fld-6 |
Character |
X(400) |
|
|
|
|
Product User Defined Field 7 |
prod_usr_def_fld_7 |
product.usr-def-fld-7 |
Character |
X(400) |
|
|
|
|
Product User Defined Field 8 |
prod_usr_def_fld_8 |
product.usr-def-fld-8 |
Character |
X(400) |
|
|
|
|
Product User Defined Field 9 |
prod_usr_def_fld_9 |
product.usr-def-fld-9 |
Character |
X(400) |
|
|
|
|
Product User Defined Field 10 |
prod_usr_def_fld_10 |
product.usr-def-fld-10 |
Character |
X(400) |
|
|
|
|
Product User Defined Field 11 |
prod_usr_def_fld_11 |
product.usr-def-fld-11 |
Character |
X(400) |
|
|
|
|
Product User Defined Field 12 |
prod_usr_def_fld_12 |
product.usr-def-fld-12 |
Character |
X(400) |
|
|
|
|
Product User Defined Field 13 |
prod_usr_def_fld_13 |
product.usr-def-fld-13 |
Character |
X(400) |
|
|
|
|
Product User Defined Field 14 |
prod_usr_def_fld_14 |
product.usr-def-fld-14 |
Character |
X(400) |
|
|
|
|
Product User Defined Field 15 |
prod_usr_def_fld_15 |
product.usr-def-fld-15 |
Character |
X(400) |
|
|
|
|
Product User Defined Field 16 |
prod_usr_def_fld_16 |
product.usr-def-fld-16 |
Character |
X(400) |
|
|
|
|
Product User Defined Field 17 |
prod_usr_def_fld_17 |
product.usr-def-fld-17 |
Character |
X(400) |
|
|
|
|
Product User Defined Field 18 |
prod_usr_def_fld_18 |
product.usr-def-fld-18 |
Character |
X(400) |
|
|
|
|
Product User Defined Field 19 |
prod_usr_def_fld_19 |
product.usr-def-fld-19 |
Character |
X(400) |
|
|
|
|
Product User Defined Field 20 |
prod_usr_def_fld_20 |
product.usr-def-fld-20 |
Character |
X(400) |
|
|
|
|
Conversion Factor 1 |
conversion_factor_1 |
um-rates.conversion-factor |
Decimal |
->>>,>>>,>>9.99<<<<<<<< |
Inner pack unit of measure to product unit of measure |
|
|
|
Conversion Factor 2 |
conversion_factor_2 |
um-rates.conversion-factor |
Decimal |
->>>,>>>,>>9.99<<<<<<<< |
Master carton unit of measure to inner pack unit of measure |
|
|
|
Cube |
cube |
product-um.cube |
Decimal |
>>>,>>9.9999 |
|
|
|
|
Length |
length |
product-um.length |
Decimal |
>>>,>>9.9999 |
Master carton unit of measure |
|
|
|
Width |
width |
product-um.width |
Decimal |
>>>,>>9.9999 |
Master carton unit of measure |
|
|
|
Height |
height |
product-um.height |
Decimal |
>>>,>>9.9999 |
Master carton unit of measure |
|
|
|
Net Weight |
net_weight |
product-um.net-weight |
Decimal |
>>>,>>9.9999 |
Master carton unit of measure |
|
|
|
Gross Weight |
gross_weight |
product-um.gross-pkgd-weight |
Decimal |
>>>,>>9.9999 |
Master carton unit of measure |
|
|
|
Unit VAT |
unit_vat |
oe-trailer.vat-amount |
Decimal |
->>,>>9.9999 |
|
|
|
|
VAT Rate |
vat_rate |
oe-trailer.vat-rate |
Decimal |
->>,>>9.99 |
|
|
|
|
Extended VAT |
extended_vat |
oe-trailer.extended-vat |
Decimal |
->>,>>9.9999 |
|
|
|
|
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) |
See *** below |
|
|
|
Misc. Field 2 |
misc_fld_2 |
oe-trailer.misc-data-2 |
Character |
X(60) |
See *** below |
|
|
|
UPC Code *** |
cust_prod_UPC |
oe-cust-prod.cust-upc-code |
Character |
X(20) |
|
|
|
|
Backorder Flag |
backorder_flag |
oe-trailer.on-backorder |
Logical |
Yes/No |
|
|
|
|
Task Id |
task_id |
edi-855-task-hdr.task-id |
Character |
X(12) |
|
|
|
|
EDI Order Line Number |
edi_order_line_num |
oe-trailer.edi-order-line-num |
Character |
X(20) |
If blank, uses oe-trailer.line-num |
|
|
|
Kit Product |
kit_item |
product.kit-item |
Logical |
Yes/No |
|
|
|
|
Promise Date |
promise_date |
oe-trailer.promise-date |
Date |
99/99/9999 |
|
|
|
|
Price Change |
price_change |
edi-855-task-trl.include-in-export |
Logical |
Yes/No |
The edi-855-task-trl must exist with event-name = "price" and include-in-export = YES |
|
|
|
Original Unit Price |
origin_unit_price |
oe-trailer.orig-unit-extended-price |
Decimal |
->>>,>>>,>>9.9999 |
|
|
|
|
Quantity Change |
qty_change |
edi-855-task-trl.include-in-export |
Logical |
Yes/No |
The edi-855-task-trl must exist with event-name = "quantity" and include-in-export = YES |
|
|
|
Original Quantity |
origin_qty |
oe-trailer.orig-qty-ordered |
Decimal |
->>>,>>>,>>9.99<< |
|
|
|
|
Cancelled |
line_cancelled |
edi-855-task-trl.include-in-export |
Logical |
Yes/No |
The edi-855-task-trl must exist with event-name = "line cancellation" and include-in-export = YES |
|
|
|
Cancelled Quantity |
cancelled_qty |
(oe-trailer.qty-ordered - oe-trailer.qty-picked-to-date) - oe-pick-ticket-trl.recommended-qty for all open pick tickets |
Decimal |
->>>,>>>,>>9.99<< |
|
|
|
|
Uncanceled Quantity |
uncancelled_qty |
oe-trailer.qty-ordered - cancelled_qty |
Decimal |
->>>,>>>,>>9.99<< |
|
|
|
|
On Backorder |
on_backorder |
edi-855-task-trl.include-in-export |
Logical |
Yes/No |
The edi-855-task-trl must exist with event-name = "backordered" and include-in-export = YES |
|
|
|
Backordered Quantity |
backorder_qty |
oe-trailer.qty-ordered - oe-trailer.qalloc - oe-trailer.qty-picked-to-date - oe-trailer.qfuture |
Decimal |
->>>,>>>,>>9.99<< |
|
|
|
|
Cancel Backorder |
cancel_backorder |
oe-trailer.cancel-backorder |
Logical |
Yes/No |
|
|
|
|
Invalid Product |
invalid_product |
edi-855-task-trl.include-in-export |
Logical |
Yes/No |
The edi-855-task-trl must exist with event-name = "invalid product upon import" and include-in-export = YES |
|
|
|
Discontinued Product |
discontinued_product |
edi-855-task-trl.include-in-export |
Logical |
Yes/No |
The edi-855-task-trl must exist with event-name = "discontinued product upon import" and include-in-export = YES |
|
|
|
Order Line Number |
order_line_num |
oe-trailer.line-num |
Integer |
>>>9 |
Always oe-trailer.line-num regardless of edi-line-num |
|
|
|
Cancelled Reason |
cancelled_reason |
edi-855-task-trl.cancelled-reason |
Character |
X(12) |
|
|
|
|
Cancelled Reason XREF |
cancelled_reason_xref |
edi-855-task-trl.cancelled-reason EDI Xref |
Character |
X(12) |
|
|
|
|
Includes Changes |
include_change |
edi-855-task-trl.include-in-export |
Logical |
Yes/No |
|
|
|
|
Invalid Product Code |
invalid_product_code |
edi-855-task-trl.old-value or oe-trailer.product-code |
Character |
|
This is the product code sent from the trading partner on the 850, which does not exist in Apprise. |
|
|
|
Qty Allocated |
qty_allocated |
oe-trailer.qalloc |
Decimal |
->>>,>>9.99<< |
|
|
|
|
Trigger Event |
trigger_event |
|
Logical |
|
|
|
|
|
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) |
|
|
|
|
Extended Unit Price (decimal) |
unit_price_decimal |
oe-trailer.unit-price + oe-trailer.price-adjustment |
Decimal |
->,>>>,>>9.9999 |
|
|
|
|
|
|
|
|
|
|
|
POACK_DETAIL_SDQ |
|
SDQ Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trade ID |
customer_id |
edi-partner.trade-id |
Character |
X(25) |
Or outbound ID |
|
|
|
PO Number |
po_number |
oe-header.cust-po-number |
Character |
X(20) |
|
|
|
|
Line Number |
line_number |
oe-trailer.line-num or oe-trailer.edi-order-line-num |
Integer or Character |
>>>9 or X(20) |
The field used depends on whether edi-line-num exists (the customer's line number is different from the line number in Apprise). |
|
|
|
Store UM |
store_uom |
um.um-code |
Character |
X(8) |
|
|
|
|
Store UM Xref |
store_uom_xrf |
um.um-code EDI xref |
Character |
X(8) |
|
|
|
|
Store ID |
store_id |
oe-address.store-id |
Character |
X(20) |
This is the store ID of the store for the specific oe-header record. |
|
|
|
Store Qty |
store_qty |
oe-trailer.qty-ordered |
Decimal |
->>>,>>>,>>9.99<< |
|
|
|
|
Task Id |
task_id |
edi-855-task-hdr.task-id |
Character |
X(12) |
|
|
|
|
|
|
|
|
|
|
|
POACK_SUMMARY |
|
Summary Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trade ID |
customer_id |
edi-partner.trade-id |
Character |
X(25) |
Or outbound ID |
|
|
|
PO Number |
po_number |
oe-header.cust-po-number |
Character |
X(20) |
|
|
|
|
Total Line Items |
total_line_items |
Count of the number of detail records |
Integer |
>>>9 |
|
|
|
|
Total Weight |
total_weight |
Sum of oe-trailer.unit-weight |
Decimal |
>>>,>>>,>>9.99 |
|
|
|
|
Weight UM Code |
weight_uom_code |
Unit of measure from oe-header.order-weight-um-key |
Character |
X(8) |
|
|
|
|
Total Volume |
total_volume |
Sum of oe-trailer.unit-cube |
Decimal |
>>>,>>9.9999 |
|
|
|
|
Volume UM |
volume_uom_code |
Unit of measure from oe-header.order-cube-um-key |
Character |
X(8) |
|
|
|
|
Total Transaction Amount |
total_transaction_amount |
Sum of oe-header.order-total |
Decimal |
->>>,>>>,>>9.99 |
|
|
|
|
Task Id |
task_id |
edi-855-task-hdr.task-id |
Character |
X(12) |
|
*** If an edi-855-task-trl exists for this field due to it being changed, the software obtains edi-855-task-trl.new-value for the map.