The following table lists the format for exporting in EDI Bill of Lading Export.
|
Map Table |
M |
Description |
Field Name |
Apprise Table/Field |
Data Type |
Format |
Notes |
|
BL_HEADER |
|
Header Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trading Partner |
customer_id |
edi-partner.trade-id |
Character |
X(25) |
|
|
|
|
BOL Number |
BOL_umber |
bol-hdr.bol-num |
Character |
X(17) |
|
|
|
|
SCAC Code |
scac_code |
shipper.scac-code |
Character |
X(12) |
Will be N/A if the SCAC Is blank |
|
|
|
Payment Method |
payment_method |
Constant value |
Character |
X(2) |
uses bol-hdr.prepaid-collect-third. 1 = PP, 2 = CC, 3 = PC |
|
|
|
BOL Date |
bol_date |
bol-hdr.bol-date |
Date |
99/99/9999 |
|
|
|
|
PRO Number |
pro_number |
bol-hdr.pro-num |
Character |
X(25) |
|
|
|
|
Master BOL Number |
mbol_number |
bol-hdr.master-bol-num |
Character |
X(17) |
|
|
|
|
Pickup Date |
pickup_date |
bol-hdr.pickup-date |
Date |
99/99/9999 |
|
|
|
|
Store ID |
store_id |
bol-prt-addr.edi-address-code |
Character |
X(30) |
Physical address |
|
|
|
Bill To Address |
BT_Name |
|
|
|
Not output, commented out in code |
|
|
|
Bill To Address |
BT_Address |
|
|
|
|
|
|
|
Bill To City |
BT_city |
|
|
|
|
|
|
|
Bill To City |
bt_State |
|
|
|
|
|
|
|
Bill To Zip |
bt_zip |
|
|
|
|
|
|
|
Bill To Country |
BT_Country |
|
|
|
|
|
|
|
Consignee Name |
cn_name |
bol-prt-addr.name |
Character |
X(40) |
Ship To |
|
|
|
Consignee Address |
CN_address |
bol-prt-addr.address1 |
Character |
X(30) |
Ship To |
|
|
|
Consignee City |
CN_city |
bol-prt-addr.city |
Character |
X(25) |
Ship To |
|
|
|
Consignee Zip |
CN_Zip |
bol-prt-addr.postal-code |
Character |
X(12) |
Ship To |
|
|
|
Consignee Country |
CN_Country |
bol-prt-addr.country |
Character |
X(20) |
Ship To |
|
|
|
Shipper Name |
sh_name |
bol-prt-addr.name |
Character |
X(40) |
Physical address |
|
|
|
Shipper Address |
SH_Address |
bol-prt-addr.address1 |
Character |
X(30) |
Physical address |
|
|
|
Shipper City |
SH_city |
bol-prt-addr.city |
Character |
X(25) |
Physical address |
|
|
|
Shipper Name |
sh_zip |
bol-prt-addr.postal-code |
Character |
X(12) |
Physical address |
|
|
|
Shipper Country |
SH_Country |
bol-prt-addr.country |
Character |
X(20) |
Physical address |
|
|
|
Shipper State |
SH_state |
bol-prt-addr.state |
Character |
X(3) |
Physical address |
|
|
|
Consignee State |
CN_state |
bol-prt-addr.state |
Character |
X(3) |
Ship To |
|
|
|
|
|
|
|
|
|
|
BL_DETAIL |
|
Detail Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trade ID |
customer_id |
edi-partner.trade-id |
Character |
X(25) |
|
|
|
|
BOL Number |
BOL_Number |
bol-prt-carrier.bol-num |
Character |
X(17) |
|
|
|
|
Line Number |
Line_number |
N/A |
Integer |
9999 |
Current detail line |
|
|
|
Description |
itm_desc |
bol-prt-carrier.commodity-desc |
Character |
X(80) |
|
|
|
|
Quantity |
qty |
bol-prt-carrier.handling-qty |
Integer |
->,>>>,>>9 |
|
|
|
|
Unit of Measure |
UOM |
Constant value |
Character |
X(3) |
CTN |
|
|
|
Weight |
Weight |
bol-prt-carrier.handling-weight |
Decimal |
->>>,>>>,>>9.99 |
|
|
|
|
Packaging Quantity |
Pkg_qty |
bol-prt-carrier.num-packages |
Integer |
->,>>>,>>9 |
|
|
|
|
Packaging Code |
Pkg_code |
Constant value |
Character |
X(3) |
CTN |
|
|
|
NMFC Number |
NMFC |
bol-prt-carrier.nmfc-num |
Character |
X(3) |
|
|
|
|
Freight Class |
Freight |
bol-prt-carrier.ltl-class |
Character |
X(12) |
|
|
|
|
Hazard UOM |
HAZ_uom |
N/A |
|
|
Not used |
|
|
|
Hazard Qty |
HAZ_qty |
N/A |
|
|
Not used |
|
|
|
|
|
|
|
|
|
|
BL_ORDER |
|
Order Record |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Trade ID |
Customer_ID |
edi-partner.trade-id |
Character |
X(25) |
|
|
|
|
BOL Number |
BOL_Number |
bol-prt-cust-po.bol-num |
Character |
X(17) |
|
|
|
|
Line Number |
line_Number |
N/A |
Integer |
9999 |
Current order detail line |
|
|
|
PO Number |
po_number |
bol-prt-cust-po.cust-po-number |
Character |
X(20) |
|
|
|
|
Unit of Measure |
UOM |
Constant value |
Character |
X(2) |
CT |
|
|
|
Quantity |
po_qty |
bol-prt-cust-po.num-packages |
Integer |
->,>>>,>>9 |
|
|
|
|
Weight |
PO_weight |
bol-prt-cust-po.weight |
Decimal |
->>>,>>,>>9.99 |
|