Skip to content

Air Consolidation

github-actions[bot] edited this page May 14, 2026 · 5 revisions

Air Consolidation

Air Consolidation groups multiple air shipments for consolidated carriage. It produces a Master Air Waybill and consolidates cargo from multiple Air Bookings/Shipments.

Industry practice: Consolidators combine shipments to achieve better rates and fill ULDs.

To access: Home > Air Freight > Air Consolidation

1. Prerequisites

2. How to Create

  1. Go to Air Consolidation list, click New.
  2. Select Flight, Flight Date, ETD, ETA.
  3. Add Packages from linked Air Shipments.
  4. Enter Master AWB number.
  5. Save and Submit.

Complete field reference

All fields from DocType Air Consolidation and nested child tables, in form order (including layout breaks). Columns: Label with technical field name in backticks, Type, and Description (from the DocType definition and standard freight/ERP semantics).

Label (Field name) Type Description
Dashboard (dashboard_tab) Tab Break Purpose: Organises the form into tabs so related fields are easier to scan and edit. What to enter: No data — click the tab to show or hide its fields.
Dashboard (dashboard_html) HTML Purpose: Shows calculated or static HTML (KPIs, dashboards, embedded help, milestone views). What to enter: Nothing to type — content is rendered by the system.
Details (details_tab) Tab Break Purpose: Organises the form into tabs so related fields are easier to scan and edit. What to enter: No data — click the tab to show or hide its fields.
Consolidation Information (consolidation_info_section) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Amended From (amended_from) Link Purpose: Creates a controlled reference to Air Consolidation so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Air Consolidation. Create the master first if it does not exist. Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Naming Series (naming_series) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: AFC.########.
Consolidation Date (consolidation_date) Date Purpose: Calendar date for the business event described by the label. What to enter: Choose the date from the picker; must reflect operational truth.
Consolidation Type (consolidation_type) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: Direct Consolidation, Transit Consolidation, Break-Bulk Consolidation, Multi-Country Consolidation.
column_break_1 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Status (status) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: Draft, Planning, In Progress, Ready for Departure, In Transit, Delivered, Cancelled.
Priority (priority) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: Low, Normal, High, Urgent.
Consolidation Agent (consolidation_agent) Link Purpose: Creates a controlled reference to Freight Agent so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Freight Agent. Create the master first if it does not exist.
Route Information (section_break_route) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Origin Airport (origin_airport) Link Purpose: Creates a controlled reference to UNLOCO so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing UNLOCO. Create the master first if it does not exist.
Destination Airport (destination_airport) Link Purpose: Creates a controlled reference to UNLOCO so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing UNLOCO. Create the master first if it does not exist.
Departure Date (departure_date) Datetime Purpose: Exact timestamp for events, SLAs, or audit (more precise than Date alone). What to enter: Pick date and time; use the time zone your process expects (often local site).
column_break_2 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Arrival Date (arrival_date) Datetime Purpose: Exact timestamp for events, SLAs, or audit (more precise than Date alone). What to enter: Pick date and time; use the time zone your process expects (often local site).
Airline (airline) Link Purpose: Creates a controlled reference to Airline so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Airline. Create the master first if it does not exist.
Flight Number (flight_number) Data Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks).
Cargo Summary (section_break_cargo) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Total Packages (total_packages) Int Purpose: Whole number (counts, packages, TEU count, integer quantities). What to enter: Digits only; no decimal point. Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Total Weight (total_weight) Float Purpose: Mass for rating, load planning, and DG limits. What to enter: Numeric weight; unit is implied by the label (often kg) — match company standard. Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Total Volume (total_volume) Float Purpose: Volume for chargeable calculations and vessel/air capacity. What to enter: Decimal cubic measure per your label (e.g. CBM). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Total Volume UOM (total_volume_uom) Link Purpose: Creates a controlled reference to UOM so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing UOM. Create the master first if it does not exist.
Total Weight UOM (total_weight_uom) Link Purpose: Creates a controlled reference to UOM so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing UOM. Create the master first if it does not exist.
column_break_3 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Chargeable Weight (chargeable_weight) Float Purpose: Mass for rating, load planning, and DG limits. What to enter: Numeric weight; unit is implied by the label (often kg) — match company standard. Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Chargeable Weight UOM (chargeable_weight_uom) Link Purpose: Creates a controlled reference to UOM so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing UOM. Create the master first if it does not exist.
Consolidation Ratio (consolidation_ratio) Percent Purpose: Percentage for margins, duty rates, or capacity use. What to enter: Numeric percent (often 0–100); confirm whether the form expects whole percent or fraction. Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Cost per kg (cost_per_kg) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Documents (section_break_documents) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Master AWB (master_awb) Link Purpose: Creates a controlled reference to Master Air Waybill so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Master Air Waybill. Create the master first if it does not exist.
House AWB Prefix (house_awb_prefix) Data Purpose: Carrier, customs, or commercial reference printed on transport or customs documents. What to enter: The exact identifier from the MAWB/HAWB, B/L, container interchange, or tax invoice.
column_break_4 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Customs Declaration (customs_declaration) Data Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks).
Export License (export_license) Data Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks).
Notes & Instructions (section_break_notes) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Consolidation Notes (consolidation_notes) Long Text Purpose: Long remarks: cargo description, marks & numbers, special instructions, legal text. What to enter: Enter the full operational or legal wording; paste from external docs if allowed by policy.
Special Instructions (special_instructions) Long Text Purpose: Long remarks: cargo description, marks & numbers, special instructions, legal text. What to enter: Enter the full operational or legal wording; paste from external docs if allowed by policy.
column_break_5 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Quality Control Notes (quality_control_notes) Long Text Purpose: Long remarks: cargo description, marks & numbers, special instructions, legal text. What to enter: Enter the full operational or legal wording; paste from external docs if allowed by policy.
Handling Requirements (handling_requirements) Long Text Purpose: Long remarks: cargo description, marks & numbers, special instructions, legal text. What to enter: Enter the full operational or legal wording; paste from external docs if allowed by policy.
Routes (tab_routes) Tab Break Purpose: Organises the form into tabs so related fields are easier to scan and edit. What to enter: No data — click the tab to show or hide its fields.
Consolidation Routes (consolidation_routes) Table Purpose: Stores repeating Air Consolidation Routes lines (child records) such as packages, charges, legs, or documents. What to enter: Use Add row, fill each line, and remove rows you do not need. Save the parent to persist child rows.
Shipments (tab_attached_jobs) Tab Break Purpose: Organises the form into tabs so related fields are easier to scan and edit. What to enter: No data — click the tab to show or hide its fields. The Shipments tab now hosts only the Planned shipments table (consolidation_planning_lines); the per-shipment list previously shown via "Attached shipments" is derived from consolidation_packages (one entry per distinct air_freight_job) and used directly by allocation and PI splitting.
Packages (tab_packages) Tab Break Purpose: Organises the form into tabs so related fields are easier to scan and edit. What to enter: No data — click the tab to show or hide its fields.
Consolidation Packages (consolidation_packages) Table Purpose: Stores repeating Air Consolidation Packages lines (child records) such as packages, charges, legs, or documents. What to enter: Use Add row, fill each line, and remove rows you do not need. Save the parent to persist child rows.
Charges (tab_charges) Tab Break Purpose: Organises the form into tabs so related fields are easier to scan and edit. What to enter: No data — click the tab to show or hide its fields.
Consolidation Charges (consolidation_charges) Table Purpose: Stores repeating Air Consolidation Charges lines (child records) such as packages, charges, legs, or documents. What to enter: Use Add row, fill each line, and remove rows you do not need. Save the parent to persist child rows.
Milestones (milestones_tab) Tab Break Purpose: Organises the form into tabs so related fields are easier to scan and edit. What to enter: No data — click the tab to show or hide its fields.
section_break_milestones Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Milestone View (milestone_html) HTML Purpose: Shows calculated or static HTML (KPIs, dashboards, embedded help, milestone views). What to enter: Nothing to type — content is rendered by the system.
Milestone Template (milestone_template) Link From definition: Optional. Leave blank to use default template for this product type. Purpose: Creates a controlled reference to Milestone Template so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Milestone Template. Create the master first if it does not exist.
Milestones (milestones) Table Purpose: Stores repeating Air Consolidation Milestone lines (child records) such as packages, charges, legs, or documents. What to enter: Use Add row, fill each line, and remove rows you do not need. Save the parent to persist child rows.
Documents (documents_tab) Tab Break Purpose: Organises the form into tabs so related fields are easier to scan and edit. What to enter: No data — click the tab to show or hide its fields.
Document Management (document_management_section) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Document Summary (documents_html) HTML Purpose: Shows calculated or static HTML (KPIs, dashboards, embedded help, milestone views). What to enter: Nothing to type — content is rendered by the system.
Document Template (document_list_template) Link From definition: Override default template. Leave empty to use product default. Purpose: Creates a controlled reference to Document List Template so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Document List Template. Create the master first if it does not exist.
Documents (documents) Table Purpose: Stores repeating Job Document lines (child records) such as packages, charges, legs, or documents. What to enter: Use Add row, fill each line, and remove rows you do not need. Save the parent to persist child rows.
Accounts (accounts_tab) Tab Break Purpose: Organises the form into tabs so related fields are easier to scan and edit. What to enter: No data — click the tab to show or hide its fields.
Company (company) Link Purpose: Creates a controlled reference to Company so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Company. Create the master first if it does not exist.
Branch (branch) Link Purpose: Creates a controlled reference to Branch so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Branch. Create the master first if it does not exist.
Cost Center (cost_center) Link Purpose: Creates a controlled reference to Cost Center so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Cost Center. Create the master first if it does not exist.
Profit Center (profit_center) Link Purpose: Creates a controlled reference to Profit Center so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Profit Center. Create the master first if it does not exist.
Job Number (job_number) Link From definition: This will be used when posting financial transactions to this job. Purpose: Creates a controlled reference to Job Number so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Job Number. Create the master first if it does not exist.

Child table: Air Consolidation Routes (field consolidation_routes on parent)

Label (Field name) Type Description
Route Information (route_info_section) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Route Sequence (route_sequence) Int Purpose: Sort order or sequence number for lists and templates. What to enter: Whole number; lower usually appears first unless the form states otherwise.
Route Type (route_type) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: Direct, Transit, Multi-Stop, Charter.
Origin Airport (origin_airport) Link Purpose: Creates a controlled reference to UNLOCO so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing UNLOCO. Create the master first if it does not exist.
Destination Airport (destination_airport) Link Purpose: Creates a controlled reference to UNLOCO so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing UNLOCO. Create the master first if it does not exist.
column_break_1 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Airline (airline) Link Purpose: Creates a controlled reference to Airline so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Airline. Create the master first if it does not exist.
Flight Number (flight_number) Data Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks).
Aircraft Type (aircraft_type) Data Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks).
Timing Information (section_break_timing) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Departure Date (departure_date) Date Purpose: Calendar date for the business event described by the label. What to enter: Choose the date from the picker; must reflect operational truth.
Departure Time (departure_time) Time Purpose: Clock time for shifts, gate hours, or cut-off times without a full date. What to enter: Time only (HH:MM or per ERPNext control).
Arrival Date (arrival_date) Date Purpose: Calendar date for the business event described by the label. What to enter: Choose the date from the picker; must reflect operational truth.
column_break_2 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Arrival Time (arrival_time) Time Purpose: Clock time for shifts, gate hours, or cut-off times without a full date. What to enter: Time only (HH:MM or per ERPNext control).
Transit Time (Hours) (transit_time_hours) Float Purpose: Decimal quantity or measurement (weight, volume, count with decimals). What to enter: Enter a number using site decimal precision. Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Connection Time (Hours) (connection_time_hours) Float Purpose: Decimal quantity or measurement (weight, volume, count with decimals). What to enter: Enter a number using site decimal precision.
Capacity Information (section_break_capacity) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Cargo Capacity (kg) (cargo_capacity_kg) Float Purpose: Mass for rating, load planning, and DG limits. What to enter: Numeric weight; unit is implied by the label (often kg) — match company standard.
Cargo Capacity (m³) (cargo_capacity_volume) Float Purpose: Volume for chargeable calculations and vessel/air capacity. What to enter: Decimal cubic measure per your label (e.g. CBM).
column_break_3 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Utilization % (utilization_percentage) Percent Purpose: Percentage for margins, duty rates, or capacity use. What to enter: Numeric percent (often 0–100); confirm whether the form expects whole percent or fraction. Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Available Capacity (kg) (available_capacity_kg) Float Purpose: Mass for rating, load planning, and DG limits. What to enter: Numeric weight; unit is implied by the label (often kg) — match company standard. Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Available Capacity (m³) (available_capacity_volume) Float Purpose: Volume for chargeable calculations and vessel/air capacity. What to enter: Decimal cubic measure per your label (e.g. CBM). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Cost Information (section_break_costs) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Base Rate per kg (base_rate_per_kg) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default).
Fuel Surcharge Rate (fuel_surcharge_rate) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default).
Security Surcharge Rate (security_surcharge_rate) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default).
column_break_4 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
War Risk Surcharge (war_risk_surcharge) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default).
Terminal Handling Charges (terminal_handling_charges) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default).
Total Cost per kg (total_cost_per_kg) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Cargo Restrictions (section_break_restrictions) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Dangerous Goods Allowed (dangerous_goods_allowed) Check Purpose: Boolean flag that drives validation, billing, DG handling, or UI (depending on the field label). What to enter: Tick Yes / enabled, untick No / disabled.
Live Animals Allowed (live_animals_allowed) Check Purpose: Boolean flag that drives validation, billing, DG handling, or UI (depending on the field label). What to enter: Tick Yes / enabled, untick No / disabled.
column_break_5 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Refrigerated Cargo Allowed (refrigerated_cargo_allowed) Check Purpose: Boolean flag that drives validation, billing, DG handling, or UI (depending on the field label). What to enter: Tick Yes / enabled, untick No / disabled.
Oversized Cargo Allowed (oversized_cargo_allowed) Check Purpose: Boolean flag that drives validation, billing, DG handling, or UI (depending on the field label). What to enter: Tick Yes / enabled, untick No / disabled.
Status Information (section_break_status) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Route Status (route_status) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: Available, Booked, Confirmed, Cancelled, Completed.
Booking Status (booking_status) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: Pending, Confirmed, Cancelled, Completed.
column_break_6 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Confirmation Number (confirmation_number) Data Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks).
Remarks (remarks) Long Text Purpose: Long remarks: cargo description, marks & numbers, special instructions, legal text. What to enter: Enter the full operational or legal wording; paste from external docs if allowed by policy.

Child table: Air Consolidation Packages (field consolidation_packages on parent)

Label (Field name) Type Description
Package Information (package_info_section) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Package Reference (package_reference) Data Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks).
Air Shipment (air_freight_job) Link Purpose: Creates a controlled reference to Air Shipment so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Air Shipment. Create the master first if it does not exist.
Shipper (shipper) Link Purpose: Creates a controlled reference to Shipper so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Shipper. Create the master first if it does not exist.
Consignee (consignee) Link Purpose: Creates a controlled reference to Consignee so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Consignee. Create the master first if it does not exist.
column_break_1 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Package Type (package_type) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: Box, Pallet, Container, Bulk, Other.
Package Count (package_count) Int Purpose: Whole number (counts, packages, TEU count, integer quantities). What to enter: Digits only; no decimal point.
Package Weight (kg) (package_weight) Float Purpose: Mass for rating, load planning, and DG limits. What to enter: Numeric weight; unit is implied by the label (often kg) — match company standard.
Package Volume (m³) (package_volume) Float Purpose: Volume for chargeable calculations and vessel/air capacity. What to enter: Decimal cubic measure per your label (e.g. CBM).
Cargo Details (section_break_cargo) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Commodity (commodity) Link Purpose: Creates a controlled reference to Other Commodity Code so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Other Commodity Code. Create the master first if it does not exist.
Description (description) Long Text Purpose: Long remarks: cargo description, marks & numbers, special instructions, legal text. What to enter: Enter the full operational or legal wording; paste from external docs if allowed by policy.
Marks and Numbers (marks_and_numbers) Long Text Purpose: Long remarks: cargo description, marks & numbers, special instructions, legal text. What to enter: Enter the full operational or legal wording; paste from external docs if allowed by policy.
column_break_2 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Value (value) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default).
Currency (currency) Link Purpose: Creates a controlled reference to Currency so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Currency. Create the master first if it does not exist.
Insurance Required (insurance_required) Check Purpose: Boolean flag that drives validation, billing, DG handling, or UI (depending on the field label). What to enter: Tick Yes / enabled, untick No / disabled.
Dangerous Goods (section_break_dangerous_goods) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Contains Dangerous Goods (contains_dangerous_goods) Check Purpose: Boolean flag that drives validation, billing, DG handling, or UI (depending on the field label). What to enter: Tick Yes / enabled, untick No / disabled.
DG Class (dg_class) Data Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks).
UN Number (un_number) Data Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks).
column_break_3 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Proper Shipping Name (proper_shipping_name) Data Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks).
Packing Group (packing_group) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: I, II, III.
Emergency Contact (emergency_contact) Data Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks).
Handling Requirements (section_break_handling) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Handling Instructions (handling_instructions) Long Text Purpose: Long remarks: cargo description, marks & numbers, special instructions, legal text. What to enter: Enter the full operational or legal wording; paste from external docs if allowed by policy.
Special Requirements (special_requirements) Long Text Purpose: Long remarks: cargo description, marks & numbers, special instructions, legal text. What to enter: Enter the full operational or legal wording; paste from external docs if allowed by policy.
column_break_4 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Temperature Controlled (temperature_controlled) Check Purpose: Boolean flag that drives validation, billing, DG handling, or UI (depending on the field label). What to enter: Tick Yes / enabled, untick No / disabled.
Min Temperature (°C) (min_temperature) Float Purpose: Decimal quantity or measurement (weight, volume, count with decimals). What to enter: Enter a number using site decimal precision.
Max Temperature (°C) (max_temperature) Float Purpose: Decimal quantity or measurement (weight, volume, count with decimals). What to enter: Enter a number using site decimal precision.
Consolidation Status (section_break_status) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Consolidation Status (consolidation_status) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: Pending, Accepted, In Transit, Delivered, Exception.
Position in Consolidation (position_in_consolidation) Int Purpose: Whole number (counts, packages, TEU count, integer quantities). What to enter: Digits only; no decimal point.
column_break_5 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Check-in Time (check_in_time) Datetime Purpose: Exact timestamp for events, SLAs, or audit (more precise than Date alone). What to enter: Pick date and time; use the time zone your process expects (often local site).
Check-out Time (check_out_time) Datetime Purpose: Exact timestamp for events, SLAs, or audit (more precise than Date alone). What to enter: Pick date and time; use the time zone your process expects (often local site).
Charges (section_break_charges) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Base Charge (base_charge) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default).
Weight Charge (weight_charge) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default).
Volume Charge (volume_charge) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default).
column_break_6 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Surcharges (surcharges) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default).
Total Charge (total_charge) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Cost Allocation % (cost_allocation) Percent Purpose: Percentage for margins, duty rates, or capacity use. What to enter: Numeric percent (often 0–100); confirm whether the form expects whole percent or fraction.

Child table: Air Consolidation Charges (field consolidation_charges on parent)

Label (Field name) Type Description
Charge Information (charge_info_section) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Charge Type (charge_type) Select Purpose: Classifies the charge for margin, revenue, cost, or disbursement handling (aligned with other air freight charge lines). What to enter: Pick exactly one value: Margin, Disbursement, Revenue, or Cost.
Charge Category (charge_category) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: Transportation, Surcharges, Handling, Documentation, Insurance, Storage, Customs, Other.
Description (description) Long Text Purpose: Long remarks: cargo description, marks & numbers, special instructions, legal text. What to enter: Enter the full operational or legal wording; paste from external docs if allowed by policy.
column_break_1 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Revenue Calculation Method (revenue_calculation_method) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: Per Unit, Flat Rate, Percentage.
Unit Type (unit_type) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: Weight, Chargeable Weight, Volume, Package, Piece.
Rate (rate) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default).
Currency (currency) Link Purpose: Creates a controlled reference to Currency so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Currency. Create the master first if it does not exist.
Calculation Details (section_break_calculation) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Quantity (quantity) Float Purpose: Decimal quantity or measurement (weight, volume, count with decimals). What to enter: Enter a number using site decimal precision.
Unit of Measure (unit_of_measure) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: kg, m³, package, shipment, hour, day.
column_break_2 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Discount % (discount_percentage) Percent Purpose: Percentage for margins, duty rates, or capacity use. What to enter: Numeric percent (often 0–100); confirm whether the form expects whole percent or fraction.
Amount Details (section_break_amounts) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Base Amount (base_amount) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Discount Amount (discount_amount) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Tax Amount (tax_amount) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
column_break_3 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Surcharge Amount (surcharge_amount) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Total Amount (total_amount) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Cost Allocation (section_break_allocation) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Allocation Method (allocation_method) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: Equal, Weight-based, Volume-based, Value-based, Custom.
Allocation % (allocation_percentage) Percent Purpose: Percentage for margins, duty rates, or capacity use. What to enter: Numeric percent (often 0–100); confirm whether the form expects whole percent or fraction.
column_break_4 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Allocated Amount (allocated_amount) Currency Purpose: Money amount in the document’s commercial context (freight, duty, insured value). What to enter: Amount in the currency indicated by field currency on this form (or company default). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Status Information (section_break_status) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Charge Status (charge_status) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: Draft, Calculated, Approved, Billed, Paid, Cancelled.
Billing Status (billing_status) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: Pending, Billed, Paid, Overdue, Cancelled.
column_break_5 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Invoice Reference (invoice_reference) Data Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks).
Payment Status (payment_status) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: Pending, Paid, Overdue, Cancelled.

Child table: Air Consolidation Milestone (field milestones on parent)

Label (Field name) Type Description
Milestone (milestone) Link Purpose: Creates a controlled reference to Logistics Milestone so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Logistics Milestone. Create the master first if it does not exist.
Status (status) Select From definition: Set by system: Started when Actual Start is set, Completed when Actual End is set. Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: Planned, Started, Completed, Delayed.
column_break_1 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Planned Start (planned_start) Datetime Purpose: Exact timestamp for events, SLAs, or audit (more precise than Date alone). What to enter: Pick date and time; use the time zone your process expects (often local site).
Planned End (planned_end) Datetime Purpose: Exact timestamp for events, SLAs, or audit (more precise than Date alone). What to enter: Pick date and time; use the time zone your process expects (often local site).
column_break_2 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Actual Start (actual_start) Datetime Purpose: Exact timestamp for events, SLAs, or audit (more precise than Date alone). What to enter: Pick date and time; use the time zone your process expects (often local site).
Actual End (actual_end) Datetime Purpose: Exact timestamp for events, SLAs, or audit (more precise than Date alone). What to enter: Pick date and time; use the time zone your process expects (often local site).
column_break_3 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Source (source) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: Manual, Fetched. Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Fetched At (fetched_at) Datetime Purpose: Exact timestamp for events, SLAs, or audit (more precise than Date alone). What to enter: Pick date and time; use the time zone your process expects (often local site). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Created At (created_at) Datetime Purpose: Exact timestamp for events, SLAs, or audit (more precise than Date alone). What to enter: Pick date and time; use the time zone your process expects (often local site). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Automation (section_break_automation) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Planned Date Basis (automation_planned_date_basis) Data From definition: From Milestone Template: basis for planned_end Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Update Trigger (automation_update_trigger_type) Data From definition: From template: None / Date Based / Field Based Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Sync Parent Date Field (automation_sync_parent_date_field) Data From definition: Date Based: parent field synced with actual_end Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Sync Direction (automation_sync_direction) Data Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Trigger Field (automation_trigger_field) Data From definition: Field Based: parent field for condition Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Trigger Condition (automation_trigger_condition) Data Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Trigger Value (automation_trigger_value) Data Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Trigger Action (automation_trigger_action) Data Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks). Behaviour: Read-only here — value comes from calculation, another field, or workflow.

Child table: Job Document (field documents on parent)

Label (Field name) Type Description
Document Type (document_type) Link Purpose: Creates a controlled reference to Logistics Document Type so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing Logistics Document Type. Create the master first if it does not exist.
Document Name (document_name) Data Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks). Behaviour: Auto-filled from document_type.document_name when the link/source changes — verify after edits.
Document Number (document_number) Data Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks).
Status (status) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: Pending, Uploaded, Done, Received, Verified, Overdue, Expired, Rejected. Behaviour: Read-only here — value comes from calculation, another field, or workflow.
column_break_1 Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Date Required (date_required) Date Purpose: Calendar date for the business event described by the label. What to enter: Choose the date from the picker; must reflect operational truth.
Date Received (date_received) Date Purpose: Calendar date for the business event described by the label. What to enter: Choose the date from the picker; must reflect operational truth.
Date Verified (date_verified) Date Purpose: Calendar date for the business event described by the label. What to enter: Choose the date from the picker; must reflect operational truth.
Expiry Date (expiry_date) Date Purpose: Calendar date for the business event described by the label. What to enter: Choose the date from the picker; must reflect operational truth.
Attachment (attachment_section) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Attachment (attachment) Attach Purpose: Stores evidence: B/L, AWB, permits, POD scans, certificates. What to enter: Upload PDF/image from disk or drag-and-drop; use clear filenames; respect max size limits.
column_break_attachment Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Required (is_required) Check Purpose: Boolean flag that drives validation, billing, DG handling, or UI (depending on the field label). What to enter: Tick Yes / enabled, untick No / disabled.
Verified (is_verified) Check Purpose: Boolean flag that drives validation, billing, DG handling, or UI (depending on the field label). What to enter: Tick Yes / enabled, untick No / disabled.
Verified By (verified_by) Link Purpose: Creates a controlled reference to User so party, place, item, or document data stays consistent for reporting and integrations. What to enter: Type to search or click the link icon; select an existing User. Create the master first if it does not exist. Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Issued By (issued_by) Data Purpose: Short free-text for codes, references, or labels that are not master-linked. What to enter: Type the value as it should appear on print/PDF (no line breaks).
Overdue Days (overdue_days) Int Purpose: Whole-day offset or SLA duration (e.g. days before ETD, processing days). What to enter: Integer only (no decimals); sign follows your process (negative = before event). Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Notes (notes_section) Section Break Purpose: Visual grouping and optional heading for the fields that follow (improves long freight forms). What to enter: No data — informational layout only.
Notes (notes) Small Text Purpose: Short note or identifier where a full Text field is not needed. What to enter: One line of text; keep it brief for list views.
column_break_meta Column Break Purpose: Continues the current row in a second column (standard ERP two-column layout). What to enter: No data — layout only.
Source (source) Select Purpose: Constrains input to predefined values (compliance, mode, status, or internal classification). What to enter: Pick exactly one value from the list: Manual, Fetched. Behaviour: Read-only here — value comes from calculation, another field, or workflow.
Created At (created_at) Datetime Purpose: Exact timestamp for events, SLAs, or audit (more precise than Date alone). What to enter: Pick date and time; use the time zone your process expects (often local site). Behaviour: Read-only here — value comes from calculation, another field, or workflow.

3. Related Topics

Getting Started

Setup and Settings

Sea Freight

Air Freight

Transport

Customs

Warehousing

Pricing Center

Job Management

Sustainability

Intercompany

Special Projects

Pages

Features

Reports

Glossary

Clone this wiki locally