API tools faq
paste
toodahlou

ToExcel_JobMaterials CSV

toodahlou
Jul 11th, 2022
132
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.12 KB | None | 0 0
raw download clone embed print report
  1. "BOM Seq" "Material" "Material Description" "Qty" "DXF #" "Operation" "WC Description" "Item" "Job" "Job Suffix" "Seq" "Revision" "Status" "Released" "WC" "Alternate" "Manufacturer" "Description" "C(ManNameStatic)" "Manufacturer Item" "C(ManitemDescriptionStatic)" "Type" "Kit" "Lot Quantity" "U/M" "Cost" "Scrap Factor" "Backflush" "Backflush Location" "Quantity" "Type" "Ref Num" "Ref Line" "Fixed Matl Ovhd Rate" "Variable Matl Ovhd Rate" "Material Cost" "Labor Cost" "Fix Ovhd Cost" "Var Ovhd Cost" "Outside Cost" "Qty Issued" "Total Fixed Overhead" "Total Variable Overhead" "Last Pick List" "Material Cost" "Labor Cost" "Fix Ovhd Cost" "Var Ovhd Cost" "Outside Cost" "Actual Cost" "Formula Material Weight %" "Shared" "Material is Paper" "Cad Link" "Selected Qty" "Generate Qty" "Lot Prefix"
  2. 2 "P015112" "HOPPER & COVERS (MS21)" 1.00 "" 10 "APPLICATOR ASSEMBLY" "MS" "W000121445" 0000 1 "A" "Complete" 1.00 "AAAL01" 0 "" "MS CONFIGURATOR" "" "" "" "Material" 0 "Unit" "EA" " 4,817.17" 0.0000 0 "" 0.00 "Job" "W000121445" 13 0.000 0.000 " 4,766.59" 50.58 0.00 0.00 0.00 2.00 0.00 0.00 "" " 5,432.20" " 1,688.61" 0.00 0.00 0.00 " 7,120.81" 0.000 0 0 "" 0 0 ""
  3. 1 "P011347" "TRAILER (MS21)" 1.00 "" 10 "APPLICATOR ASSEMBLY" "MS" "W000121445" 0000 2 "0" "Complete" 1.00 "AAAL01" 0 "" "MS CONFIGURATOR" "" "" "" "Material" 0 "Unit" "EA" " 27,370.00" 0.0000 0 "" 0.00 "Job" "W000121445" 8 0.000 0.000 " 27,370.00" 0.00 0.00 0.00 0.00 1.00 0.00 0.00 "" " 34,000.00" 1.53 0.00 0.00 0.00 " 34,001.53" 0.000 0 0 "" 0 0 ""
  4. 9 "P010995" "LIGHTS (MS)" 1.00 "" 20 "APPLICATOR ASSEMBLY" "MS" "W000121445" 0000 1 "B" "Complete" 1.00 "AAAL01" 0 "" "MS CONFIGURATOR" "" "" "" "Material" 0 "Unit" "EA" 81.14 0.0000 0 "" 0.00 "Job" "W000121445" 5 0.000 0.000 81.14 0.00 0.00 0.00 0.00 1.00 0.00 0.00 "" 94.06 15.28 0.00 0.00 0.00 109.34 0.000 0 0 "" 0 0 ""
  5. 5 "P015107" "HYDRAULICS (MS21)" 1.00 "" 20 "APPLICATOR ASSEMBLY" "MS" "W000121445" 0000 3 "E" "Complete" 1.00 "AAAL01" 0 "" "MS CONFIGURATOR" "" "" "" "Material" 0 "Unit" "EA" " 1,092.87" 0.0000 0 "" 0.00 "Job" "W000121445" 12 0.000 0.000 " 1,092.87" 0.00 0.00 0.00 0.00 1.00 0.00 0.00 "" " 4,043.93" 500.90 0.00 0.00 0.00 " 4,544.83" 0.000 0 0 "" 0 0 ""
  6. 11 "P014075" "DECALS-HAZARD (MS21)" 1.00 "" 20 "APPLICATOR ASSEMBLY" "MS" "W000121445" 0000 4 "A" "Complete" 1.00 "AAAL01" 0 "" "MS CONFIGURATOR" "" "" "" "Material" 0 "Unit" "EA" 179.21 0.0000 0 "" 0.00 "Job" "W000121445" 9 0.000 0.000 179.21 0.00 0.00 0.00 0.00 1.00 0.00 0.00 "" 174.51 1.53 0.00 0.00 0.00 176.04 0.000 0 0 "" 0 0 ""
  7. 3 "P015098" "REAR CONV FRAME (MS21)" 1.00 "" 20 "APPLICATOR ASSEMBLY" "MS" "W000121445" 0000 5 "B" "Complete" 1.00 "AAAL01" 0 "" "MS CONFIGURATOR" "" "" "" "Material" 0 "Unit" "EA" " 1,033.37" 0.0000 0 "" 0.00 "Job" "W000121445" 10 0.000 0.000 873.01 160.36 0.00 0.00 0.00 1.00 0.00 0.00 "" " 1,208.92" 670.75 0.00 0.00 0.00 " 1,879.67" 0.000 0 0 "" 0 0 ""
  8. 8 "P010988" "GATE-AIR SYSTEM (MS)" 1.00 "" 20 "APPLICATOR ASSEMBLY" "MS" "W000121445" 0000 7 "B" "Complete" 1.00 "AAAL01" 0 "" "MS CONFIGURATOR" "" "" "" "Material" 0 "Unit" "EA" 237.06 0.0000 0 "" 0.00 "Job" "W000121445" 3 0.000 0.000 237.06 0.00 0.00 0.00 0.00 1.00 0.00 0.00 "" 283.17 133.63 0.00 0.00 0.00 416.80 0.000 0 0 "" 0 0 ""
  9. 7 "P009054" "TANK & PLMB-EMUL (MS26TM-21YD)" 1.00 "" 20 "APPLICATOR ASSEMBLY" "MS" "W000121445" 0000 8 "D" "Complete" 1.00 "AAAL01" 0 "" "MS CONFIGURATOR" "" "" "" "Material" 0 "Unit" "EA" " 5,259.21" 0.0000 0 "" 0.00 "Job" "W000121445" 2 0.000 0.000 " 5,259.21" 0.00 0.00 0.00 0.00 1.00 0.00 0.00 "" " 7,333.06" 142.93 0.00 0.00 0.00 " 7,475.99" 0.000 0 0 "" 0 0 ""
  10. 12 "P010991" "DECALS-BRAND-BLACK" 1.00 "" 20 "APPLICATOR ASSEMBLY" "MS" "W000121445" 0000 9 "A" "Complete" 1.00 "AAAL01" 0 "" "MS CONFIGURATOR" "" "" "" "Material" 0 "Unit" "EA" 26.90 0.0000 0 "" 0.00 "Job" "W000121445" 4 0.000 0.000 26.90 0.00 0.00 0.00 0.00 1.00 0.00 0.00 "" 26.90 1.53 0.00 0.00 0.00 28.43 0.000 0 0 "" 0 0 ""
  11. 10 "P011024" "FRAME TRAILER MOUNTING (MS21)" 1.00 "" 20 "APPLICATOR ASSEMBLY" "MS" "W000121445" 0000 10 "B" "Complete" 1.00 "AAAL01" 0 "" "MS CONFIGURATOR" "" "" "" "Material" 0 "Unit" "EA" 2.01 0.0000 0 "" 0.00 "Job" "W000121445" 6 0.000 0.000 2.01 0.00 0.00 0.00 0.00 1.00 0.00 0.00 "" 0.00 1.53 0.00 0.00 0.00 1.53 0.000 0 0 "" 0 0 ""
  12. 13 "P011032" "SLIDING BOW TARP (MS21)" 1.00 "" 20 "APPLICATOR ASSEMBLY" "MS" "W000121445" 0000 11 "A" "Complete" 1.00 "AAAL01" 0 "" "MS CONFIGURATOR" "" "" "" "Material" 0 "Unit" "EA" " 2,351.56" 0.0000 0 "" 0.00 "Job" "W000121445" 7 0.000 0.000 " 2,351.56" 0.00 0.00 0.00 0.00 1.00 0.00 0.00 "" " 3,127.74" 1.53 0.00 0.00 0.00 " 3,129.27" 0.000 0 0 "" 0 0 ""
  13. 6 "P009053" "TANK & PLMB-WATER (MS26TM-21YD" 1.00 "" 20 "APPLICATOR ASSEMBLY" "MS" "W000121445" 0000 12 "C" "Complete" 1.00 "AAAL01" 0 "" "MS CONFIGURATOR" "" "" "" "Material" 0 "Unit" "EA" " 2,281.09" 0.0000 0 "" 0.00 "Job" "W000121445" 1 0.000 0.000 " 2,281.09" 0.00 0.00 0.00 0.00 1.00 0.00 0.00 "" " 3,730.37" " 1,463.02" 0.00 0.00 0.00 " 5,193.39" 0.000 0 0 "" 0 0 ""
  14. 14 "P015210" "TECHNICAL DOCUMENTS (MS21-CA)" 1.00 "" 20 "APPLICATOR ASSEMBLY" "MS" "W000121445" 0000 14 "A" "Complete" 1.00 "AAAL01" 0 "" "MS CONFIGURATOR" "" "" "" "Material" 0 "Unit" "EA" 0.00 0.0000 0 "" 0.00 "Inventory" "" 0 0.000 0.000 0.00 0.00 0.00 0.00 0.00 1.00 0.00 0.00 "" 0.00 0.00 0.00 0.00 0.00 0.00 0.000 0 0 "" 0 0 ""
  15.  
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!