Trucking Billing Manifest (Change Requests)
From UG
(Difference between revisions)
(→Change Request) |
(→Change Request) |
||
Line 19: | Line 19: | ||
*** '''From''' | *** '''From''' | ||
**** Mapping: ''Company name'' from [[Ct#Export_Pick_Up]] If there is no info on [[Ct#Export_Pick_Up]], Map [[Ct#Shipper]] | **** Mapping: ''Company name'' from [[Ct#Export_Pick_Up]] If there is no info on [[Ct#Export_Pick_Up]], Map [[Ct#Shipper]] | ||
+ | **** Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet | ||
*** '''Origin City''' | *** '''Origin City''' | ||
**** Mapping: ''City'' from [[Ct#Export_Pick_Up]] If there is no info on [[Ct#Export_Pick_Up]], Map [[Ct#Shipper]] | **** Mapping: ''City'' from [[Ct#Export_Pick_Up]] If there is no info on [[Ct#Export_Pick_Up]], Map [[Ct#Shipper]] | ||
+ | **** Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet | ||
*** '''Origin State''' | *** '''Origin State''' | ||
**** Mapping: ''State'' from [[Ct#Export_Pick_Up]] If there is no info on [[Ct#Export_Pick_Up]], Map [[Ct#Shipper]] | **** Mapping: ''State'' from [[Ct#Export_Pick_Up]] If there is no info on [[Ct#Export_Pick_Up]], Map [[Ct#Shipper]] | ||
+ | **** Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet | ||
*** '''To''' | *** '''To''' | ||
**** Mapping: ''Company name'' from[[Ct#Export_Delivery_To]] If there is no info on [[Ct#Export_Delivery_To]], Map [[Ct#Consignee]] | **** Mapping: ''Company name'' from[[Ct#Export_Delivery_To]] If there is no info on [[Ct#Export_Delivery_To]], Map [[Ct#Consignee]] | ||
+ | **** Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet | ||
*** '''Destination City''' | *** '''Destination City''' | ||
**** Mapping: ''City'' from [[Ct#Export_Delivery_To]] If there is no info on [[Ct#Export_Delivery_To]], Map [[Ct#Consignee]] | **** Mapping: ''City'' from [[Ct#Export_Delivery_To]] If there is no info on [[Ct#Export_Delivery_To]], Map [[Ct#Consignee]] | ||
+ | **** Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet | ||
*** '''Destination State''' | *** '''Destination State''' | ||
**** Mapping: ''State'' from [[Ct#Export_Delivery_To]] If there is no info on [[Ct#Export_Delivery_To]], Map [[Ct#Consignee]] | **** Mapping: ''State'' from [[Ct#Export_Delivery_To]] If there is no info on [[Ct#Export_Delivery_To]], Map [[Ct#Consignee]] | ||
- | *** '''P.O.''' | + | **** Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet |
+ | *** '''P.O.''' | ||
+ | **** Mapping: [[Commodity#PO]] | ||
+ | *** '''SKU''' | ||
+ | **** Mapping: [[Commodity#SKU]] | ||
+ | * '''Origin Port''' | ||
+ | ::''City, State'' from [[CT#Export Pick Up]] | ||
+ | :: | ||
+ | * '''Dest. Port''' | ||
+ | ::''COMPANY-CITY-NOTE'' from [[CT#Export Delivery To]] | ||
+ | ::Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet | ||
+ | |||
+ | * '''Actual Pick Up Date''' | ||
+ | :: [[CT#Actual Export Pick Up Date]] | ||
+ | :: Note: for Truck-Ocean this date is on [[Container]]; and since each [[Commodity]] line is assigned to its own container - date would be shown for every spreadsheet line for such CT | ||
+ | |||
+ | * '''Actual Delivery Date''' | ||
+ | :: [[CT#Actual Delivery Date]] | ||
+ | :: Note: for Truck-Ocean this date is on [[Container]]; and since each [[Commodity]] line is assigned to its own container - date would be shown for every spreadsheet line for such CT | ||
+ | |||
+ | * Sorted by: CT# | ||
- | |||
- | |||
- | |||
- | |||
- | |||
Revision as of 15:23, 10 March 2010
Change Request
- Mantis 1844
- Template section: Add Maximum Rate under Minimum Rate
- Maximum Rate - text box, default is 0.00
- Addition Information
- Maximum Rate- datatype/format: Datatypes#decimal, max=100,000;2 digits after decimal, Required: N
- Spreadsheet:Manifest Section (Section 1)
- See Example on Figure 1.
- This is a table
- Horizontally:
- It consists of as many sections as there are CTs (originally selected by user)
- Each CT section has as many lines as there are in commod table for this CT
- Vertically it has a number of columns:
- CT#
- Mapping: Ct#CT_Num
- From
- Mapping: Company name from Ct#Export_Pick_Up If there is no info on Ct#Export_Pick_Up, Map Ct#Shipper
- Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
- Origin City
- Mapping: City from Ct#Export_Pick_Up If there is no info on Ct#Export_Pick_Up, Map Ct#Shipper
- Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
- Origin State
- Mapping: State from Ct#Export_Pick_Up If there is no info on Ct#Export_Pick_Up, Map Ct#Shipper
- Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
- To
- Mapping: Company name fromCt#Export_Delivery_To If there is no info on Ct#Export_Delivery_To, Map Ct#Consignee
- Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
- Destination City
- Mapping: City from Ct#Export_Delivery_To If there is no info on Ct#Export_Delivery_To, Map Ct#Consignee
- Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
- Destination State
- Mapping: State from Ct#Export_Delivery_To If there is no info on Ct#Export_Delivery_To, Map Ct#Consignee
- Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
- P.O.
- Mapping: Commodity#PO
- SKU
- Mapping: Commodity#SKU
- CT#
- Origin Port
- City, State from CT#Export Pick Up
- Dest. Port
- COMPANY-CITY-NOTE from CT#Export Delivery To
- Note: print once per CT on the first line if there are multiples lines per CT on a spreadsheet
- Actual Pick Up Date
- CT#Actual Export Pick Up Date
- Note: for Truck-Ocean this date is on Container; and since each Commodity line is assigned to its own container - date would be shown for every spreadsheet line for such CT
- Actual Delivery Date
- CT#Actual Delivery Date
- Note: for Truck-Ocean this date is on Container; and since each Commodity line is assigned to its own container - date would be shown for every spreadsheet line for such CT
- Sorted by: CT#
- Spreadsheet:Billing Section (Section 2)
- Insert Maximum Rate under Minimum Rate
- Formula for Freight Total will be:
- IF(gross weight/100*Rate < X) THEN X
- ELSE IF (gross weight/100*Rate > Y) THEN Y
- ELSE Gross Weight/100*Rate
- Bug: Reset Form Button
- Reset Form button should clear the data and uncheck the CTs from the Shipments table. Right now it deletes all the CTs in the shipment table. This is a bug!!! It must ONLY uncheck CTs, not DELETE CTs!