expand| AWB liquidation report in excel | When you download the AWB liquidation report in .xlx format, additional information will appear compared to the PDF report.
| Report Explanation |
| - Vendor: The name of the vendor. |
| - AWB:Airway bill number. |
| - AWB Ship Date:Air waybill ship date. |
| - AWB Arrival Date:Air waybill arrival date. |
| - Port of Origin: Code of the origin. |
| - Location: Location Code (Only applies for multi-location companies). |
| - PO #: Thepuchaseorder number. |
| - Customer PO#: Customer Purchase Order number |
| - Vendor Inv #: Vendor invoice number. |
| - Product: Product description. |
| - Category: Product category. |
| - Color: Product color. |
| - Variety: Product variety. |
| - Grade: Product grade. |
| - Box Type: Box size. |
| - Pack: Units per box. |
| - Qty: Number of boxes. |
| - Total Units: Total units purchased. |
| - FBE: Full box equivalence. |
| - AWB Freight/FBE: Freight cost per FBE. |
| - AWB Freight/Unit: Freight cost per unit. |
| - AWB Freight: Total Freight Cost. |
| - AWB Freight Type: Real or estimated. |
| - Duties / Unit: Duties Cost per Unit. |
| - Duties: Duties cost. |
| - Truck Freight / Unit: Land freight cost per unit. |
| - Truck Freight: Total freight cost. |
| - Landed Cost / Unit: Landed cost per unit. |
| - Total Landed Cost: Total landed cost of the product. |
| - Unit Cost: Flower unit cost. |
| - Total Cost: Total flower cost. |
| - Credit: Product credit. |
| - Total Due: Balance due. |
| - Reference #: Reference number. |
| - Lot#: Lot number. |
| - Sales Price: Unit price. |
- Vendor Commission: The percentage to be paid to the vendor based on what is sold.
