[go: up one dir, main page]
Scribd
Upload
45 views5 pages

Table Name Table Name Pls - Carriers Pls - Quote - Data - History: Column Names

This document describes the mapping between tables in the pls and qd databases. It lists the table names and columns in each database. The key mappings are: - The qd_scac column maps to the carrier_id column in pls.carriers to get carrier data like name, address. - Other carrier contact and equipment columns map similarly across the two databases. - Shipment data like load id, origin/destination details map from qd tables to the corresponding pls tables for quotes, load tracking, and confirmations. This allows quotation and load tracking data to be integrated between the two databases for a unified view of carrier and shipment information.

Uploaded by

Sakthivel P
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
45 views5 pages

Table Name Table Name Pls - Carriers Pls - Quote - Data - History: Column Names

This document describes the mapping between tables in the pls and qd databases. It lists the table names and columns in each database. The key mappings are: - The qd_scac column maps to the carrier_id column in pls.carriers to get carrier data like name, address. - Other carrier contact and equipment columns map similarly across the two databases. - Shipment data like load id, origin/destination details map from qd tables to the corresponding pls tables for quotes, load tracking, and confirmations. This allows quotation and load tracking data to be integrated between the two databases for a unified view of carrier and shipment information.

Uploaded by

Sakthivel P
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 5

Table Name Table Name

pls.carriers pls.quote_data_history:
Column Names
carrier_name
dot pls.carriers
certification pls.carriers
physical_city pls.carriers
physical_state pls.carriers
physical_country pls.carriers
physical_zip_latitude pls.carriers
physical_zip_longitude pls.carriers
carrier_id pls.carriers

pls.carrier_contacts

contact_name
contact_phone
contact_email_id
carrier_contact_id

pls.carrier_equipments

carrier_equipment_name

pls.carrier_delivery_confirm

delivery_date

pls.carrier_pickup_confirm

pickup_date

pls.carrier_profile_equipment

carrier_id

pls.load_origin_destination

destination_latitude
destination_longitud

pls.load_carrier
load_id

pls.equipments::

equipment_id

Mapping

qd_scac column map with pls carrier scac and get remaing datas
Column Names
qd_carrier_name
dot
certification
physical_city
physical_state
physical_country
physical_zip_latitude
physical_zip_longitude
carrier_id

carrier_contact_name
carrier_contact_phone
carrier_contact_email
qd_carrier_person_id

qd_carrier_name

shipdate

dest_longitude
dest_latitude
qd_load_id

qd_container_type
pls.quote_data_history (
qd_load_id numeric NULL,
qd_mileage numeric NULL,
qd_weight numeric(10) NULL,
qd_orig_city varchar(30) NULL,
qd_orig_state varchar(6) NULL,
qd_orig_zip varchar(10) NULL,
qd_dest_city varchar(30) NULL,
qd_dest_state varchar(6) NULL,
qd_dest_zip varchar(10) NULL,
qd_container_type varchar(100) NULL,
qd_orig_departure timestamp NULL,
qd_scac varchar(4) NULL,
qd_carrier_person_id numeric NULL,
qd_carrier_name varchar(240) NULL,
qd_network_code varchar(3) NULL,
qd_linehaul numeric NULL,
qd_fuel_rate numeric NULL,
qd_fuel_min numeric NULL,
qd_fuel_uom varchar(10) NULL,
qd_fuel_surcharge numeric NULL,
orig_longitude float8 NULL,
orig_latitude float8 NULL,
dest_longitude float8 NULL,
dest_latitude float8 NULL,
totalcarriercost numeric(10,2) NULL,
totalshippercost numeric(10,2) NULL,
shipdate timestamp NULL,
carrier_contact_name varchar(61) NULL,
carrier_contact_email varchar(100) NULL,
carrier_contact_phone varchar(20) NULL
)

You might also like