|
<< Click to Display Table of Contents >> Navigation: Appendix > Bestcrete customizations |
These fields are used to store the data from the supplier invoice. The number indicates the order they should appear on Print Tickets in order to mimic the AWS Interact software input prompts.
item_description=Invoice number - 1
item_net=Cubic Yards - 4
item_rate=Net weight - 2
item_discount_pct=Moisture - 5
item_discount_unit_price=
item_sub_total=Bill weight - 3
item_taxes_payable=
item_tax_total=
item_total=item_net
C:\Users\Public\Documents\CanScale\Dispatch 3.2\FastReport\Custom\Bestcrete\Tonnage and Charge Summary.fr3
C:\Users\Public\Documents\CanScale\Dispatch 3.2\FastReport\Custom\Bestcrete\Tonnage and Charge Summary.ini
C:\Users\Public\Documents\CanScale\Dispatch 3.2\FastReport\Custom\Bestcrete\Variance Report Without Group Totals.fr3
C:\Users\Public\Documents\CanScale\Dispatch 3.2\FastReport\Custom\Bestcrete\Variance Report Without Group Totals.ini
C:\Users\Public\Documents\CanScale\Dispatch 3.2\FastReport\Custom\Bestcrete\Variance Report.fr3
C:\Users\Public\Documents\CanScale\Dispatch 3.2\FastReport\Custom\Bestcrete\Variance Report.ini
C:\Users\Public\Documents\CanScale\Dispatch 3.2\SQL\DMFastReport\Custom\FDMemTableFilterTable_Labels.ini
[Labels]
item_description=Supplier Ticket
item_net=yd3
item_rate=Supplier Net
item_discount_pct=DN Moisture
item_sub_total=Billed Weight
item_tax_total=Bestcrete Moisture
customer_name=Customer: Name
contract_item_description=Order Item: Description
carrier_name=Carrier: Name
C:\Users\Public\Documents\CanScale\Dispatch 3.2\SQL\DMFastReport\Custom\FDMemTableFilterTable_Settings.ini
[DisplayFormat]
item_rate=#0;(-#0)
item_sub_total=#0;(-#0)
item_tax_total=#,##0.00;(-#,##0.00)
[Visible]
carrier_id=true
company_id=false
contract_id=true
customer_id=false
destination=false
driver=false
gross=false
invoice_number=false
item_cost_code=false
item_description=true
item_discount_pct=true
item_net=true
item_rate=true
item_sub_total=true
item_tax_total=true
item=true
material_code=false
net_3=false
net=false
placed_at=false
purchase_order=false
serial_number=false
source_generator=false
source=false
station=false
tare=false
ticket_date_date=true
ticket_date=false
ticket_number=true
ticket_unit=false
truck_id=true
vehicle_type=false
zone=false
"C:\Users\Public\Documents\CanScale\Dispatch 3.2\SQL\DMFastReport\FDQueryVariance.sql"
SELECT
t1.serial_number,
t1.ticket_number,
t1.ticket_date,
t1.ticket_date_date,
t1.truck_id,
t1.carrier_id,
t1.vehicle_type,
t1.trailer_1,
t1.carrier_id_trailer_1,
t1.customer_id,
t1.contract_id,
t1.item,
t1.material_code,
t1."source",
t1.placed_at,
t1.station,
t1.company_id,
t1.manual_gross,
t1.manual_tare,
t1.purchase_order,
t1."zone",
t1.item_cost_code,
t1.note,
t1.gross,
t1.total_tare,
t1.net,
t1.net_3,
t1.tare,
t1.trailer_1_tare,
t1.ticket_tare,
t1.ticket_trailer_1_tare,
t1.weighed_by,
t101.unit_label_2,
t1.time_in,
t1.item_description,
t1.item_rate,
t1.item_sub_total,
t1.item_net,
t1.item_discount_pct,
t1.item_tax_total,
t2.name AS customer_name,
t11.description AS contract_item_description,
t99.name AS carrier_name
FROM
{IF ASA}"dba".{FI}{IF MSSQL}"dba".{FI}"&table_name" t1
LEFT OUTER JOIN {IF ASA}"dba".{FI}{IF MSSQL}"dba".{FI}dsptch30_truck t98 ON t1.truck_id = t98.truck_id
LEFT OUTER JOIN {IF ASA}"dba".{FI}{IF MSSQL}"dba".{FI}dsptch30_carrier t99 ON t1.carrier_id = t99.carrier_id
LEFT OUTER JOIN {IF ASA}"dba".{FI}{IF MSSQL}"dba".{FI}dsptch30_customer t2 ON (t1.customer_id = t2.customer_id)
LEFT OUTER JOIN {IF ASA}"dba".{FI}{IF MSSQL}"dba".{FI}dsptch30_contract t10 ON (t1.customer_id = t10.customer_id AND t1.contract_id = t10.contract_id)
LEFT OUTER JOIN {IF ASA}"dba".{FI}{IF MSSQL}"dba".{FI}dsptch30_contract_item t11 ON (t10.row_id = t11.contract_row_id AND t1.item = t11.item)
LEFT OUTER JOIN {IF ASA}"dba".{FI}{IF MSSQL}"dba".{FI}dsptch30_measurement_unit t100 ON t1.item_uom = t100.unit_id
LEFT OUTER JOIN {IF ASA}"dba".{FI}{IF MSSQL}"dba".{FI}dsptch30_measurement_unit t101 ON t1.ticket_unit = t101.unit_id
&where_clause
&order_by