|
|
(12 intermediate revisions not shown) |
Line 1: |
Line 1: |
- | [[Category:OpsPdfsTruck]] | + | #REDIRECT [[Trucking Billing Manifest (Developer Guide)]] |
- | [[File:Select_CTs_from_Groups.JPG|thumb|400px|File:Select_CTs_from_Groups.JPG]]
| + | |
- | == Business Requirements ==
| + | |
- | * Operators need xls spreadsheet for Trucking MOT that has:
| + | |
- | ** Manifest section:
| + | |
- | *** commodity info (PO, SKU, etc)
| + | |
- | *** general CT info (Shipper, etc)
| + | |
- | ** Billing section:
| + | |
- | *** per CT
| + | |
- | *** has commodity totals (Gross weight, etc)
| + | |
- | *** has fields that contain formulas
| + | |
| | | |
- | == Suggested Design ==
| |
| | | |
- | [[File:Trucking_Billing_Manifest_Template.JPG|thumb|500px|Trucking_Billing_Manifest_Template.JPG]] | + | [[Category:XArc]] |
- | === Home and Select Groups or CTs panel ===
| + | |
- | * It is suggested to have this option available on Doc Center Tab in Master
| + | |
- | * On "generate template" system would present pop-up panel that gives a choice to the user of what CTs to include into the document - see Select_CTs_from_Groups.JPG
| + | |
- | | + | |
- | === Template ===
| + | |
- | * See File:Trucking_Billing_Manifest_Template.JPG
| + | |
- | * Mapping:
| + | |
- | ** Date // today's date
| + | |
- | ** Client // GenTab.E0
| + | |
- | ** Author By // Gen Tab
| + | |
- | ** Rate // float; default=0.00
| + | |
- | ** Min Rate // float; default=0.00
| + | |
- | ** Fuel // float; default=0.000
| + | |
- |
| + | |
- | | + | |
- | === xls Manifest Section ===
| + | |
- | * This is a table.
| + | |
- | * See example here: ....
| + | |
- | * 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# //
| + | |
- | ** Vendor // Gen Tab 2. Shipper T1
| + | |
- | ** P.O. // ContTab
| + | |
- | ** Item // SKU, ContTab
| + | |
- | ** Origin Port // City, State from Gen Tab 5 Export Pick up T4
| + | |
- | ** Dest. Port // "COMPANY-CITY NOTE" - 6. Export Delivery to (T5):
| + | |
- | ** Actual Pick Up Date // Actual Export Pick-Up Date (mode logic)
| + | |
- | ** Actual Delivery Date // Actual Delivery Date (mode logic)
| + | |
- | | + | |
- | === xls Billing Section ===
| + | |