Table: invoice_item

AutoId INVOICE_InternalId custcol_ful_chan_tran_line rateschedule olditemid custcol_bldcom_leadtime custcol_5892_eutriangulation custcol_wrm_reg_warrantyreg mandatorytaxcode binitem onorder price custcol_sw_better_replacement_item_display custcol_sw_good_replacement_item_display locationusesbins id price_display custcol_amazon_item_id custcol_ssp_data quantityonhand item costestimatetype sys_parentid custcol_country_of_origin_name custcol_sw_upsell_item_1_display isnoninventory custcol_scpq_so_wo_line_num initquantity billvariancestatus custcol_statistical_procedure_sale custcol_emirate costestimatetype_display custcol_wrm_reg_registration lineuniquekey custcol_sw_better_replacement_item pricelevels custcol_wrm_reg_hid_invdetail taxcode_display inventorydetailavail noprint isposting custcol_nature_of_transaction_codes custcol_sw_good_replacement_item custcol_wrm_reg_hid_registerflag quantityremaining custcol_item_type discline custcol_amz_sku costestimatetypelist custcol_country_of_origin_code isserial item_display custcol_wrm_reg_hid_terms excludefromraterequest custcol_9997_dd_file_format ddistrib custcol_formula_ship_date custreferralcode unitslist custcol_wrm_reg_hid_warrantybegin custcol_scm_customerpartnumber_display custcol_wrm_reg_hid_period custcol_2663_firstname custcol_sw_upsell_item_2_display custcol_ebay_itemid quantityavailable custcol_sii_exempt_line_details ingroup custcol_scpq_configuration custcol_statistical_procedure_sale_display custcol_amz_asin custcol_sw_best_replacement_item header_location_copy custcol_wrm_reg_hid_warrantyterms unitconversionrate freegiftpromotion custcol_shopify_order_line_item custcol_wrm_reg_warrantyterms custcol_scpq_item_col_config_data custcol_wrm_claimitem inventorydetailreq custcol_fin_dept custcol_statistical_value custcol_2663_isperson fulfillmentbin custcol_hj_po_linenum oqpbucket custcol_9572_cr_entitybank_format itemsubtype billvariancestatusallbook backordered includegroupwrapper custcol_sw_upsell_item_3_display custcol_wrm_reg_warrantyexpire orderdoc custcol_wrm_reg_hid_trackwarranty taxcode isnumbered custcol_sw_best_replacement_item_display linenumber custcol_9572_cr_entitybank_sub fulfillable line custcol_ebay_tranid custcol_atlas_rc_so description reorder units custcol_statistical_value_base_curr custcol_sw_upsell_item_1 itemlocationbinlist units_display custcol_sw_upsell_item_2 class_display revrecdeferred sys_id custcol_sw_upsell_item_3 rate custcol_wrm_reg_hid_warrantyexpire marginal custcol_2663_lastname custcol_scm_customerpartnumber custcol_tc_edi_item_reference groupsetup class costestimaterate minqty printitems amount quantity initoqpbucket custcol_scpq_item_col_buildwo custcol_9572_custref_file_format amounthasbeenset generatedinvdetail orderline itemtype custcol_wrm_reg_hid_termtype taxrate1 costestimate custcol_2663_companyname custcol_scpq_item_col_config account
1 24701289 1 28632 F T F 0 -1 T 24701289_1 Custom 28632 MEMBERDEFINED 12408468593333750 F 1 Derived From Member Items 47972322 7243865-1 -Not Taxable- F F T F 0.00 6 CUSTOMITEMDEFINEDMEMBERDEFINED F FT-CF131FAFT-CH F ERROR: Field 'item.custitem_shipping_lead_time' Not Found 27.00 1 F F 1 F 0 F 24678279 -8 F T 1 Feet For Claw foot tub BT-27B/26 0.00 12408468495338005 324.69 F 213.00 F 324.69 1.00 F F F 1 Kit 213.00 307
2 24701290 1 31347 3 F F T T 177 -1 T 24701290_1 Custom 122 31347 AVGCOST 12408470239344277 SP-AZ022 F 1 Average Cost 47972327 17243865-1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F SD-AZ17-01MB F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 1/4/2024 T1-AZ055 122.00 9105 1 9 1 9 F T F 0 F SB-AZ005WO 24675958 T -8 F SD-AZ17-01CH T 1 Don Series 60 in. x 62 in. Frameless Sliding Tub Door in Matte Black 175 3 0.00 8803 EA 18622 SHOWER : Tubs Doors : Tubs Doors Sliding 12408470149551927 9982 350.00 F 917 141.92 1 F 350.00 1.00 F F T 1 InvtPart 3 141.92 307
3 24701291 1 28832 F F T T 0 -1 T 24701291_1 Custom 0 28832 AVGCOST 12408471154965400 F 1 Average Cost 47972330 7243865-1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F TW-WM104CH F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 0.00 1 1 F T 02 F 1 F 24683144 F -8 F T 1 SOHO 10-Bar Wall Mounted Towel Warmer in Polished Chrome 183 3 0.00 EA 12408471052581207 96.00 F 1006376799 49.49 F 96.00 1.00 F F T 1 InvtPart 49.49 307
4 24701292 1 45770 F F T T 123 -1 T 24701292_1 Custom 0 45770 AVGCOST 12408472234736440 F 1 Average Cost 47972333 1724386145-1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F SB-AZ103L F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 0.00 1 1 F T 501 F 1 F 24678185 F -8 F T 1 N/A 131 3 0.00 EA 12408472135023550 134.92 F 1007911140 76.50 F 134.92 1.00 F F T 1 InvtPart 76.50 306
5 24701293 1 44016 F F T T 600 -1 T 24701293_1 Custom 0 44016 AVGCOST 12408473164759177 F 1 Average Cost 47972336 172438156165-1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F WH-AZ006-M1 F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 0.00 1 F T 01 F 0 F 24682544 F -8 F T 1 ENVO Ansen 6 kW Tankless Electric Water Heater 343 0.00 12408473066855796 89.20 F 1007842581 44.11 F 89.20 1.00 F F T 1 InvtPart 44.11 307
6 24701294 1 27904 F F T T 650 -1 T 24701294_1 Custom 0 27904 AVGCOST 12408474014559340 F 1 Average Cost 47972339 7243865-1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F SD-FRLS05701BN F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 0.00 1 1 F T 501 F 0 F 24684846 F -8 F T 1 76" x 48" Frameless Shower Door with Sliding - Brushed Nickel - XXX Series - ANZ 388 3 0.00 EA 12408473923446689 266.66 F 1006109734 82.92 F 266.66 1.00 F F T 1 InvtPart 82.92 307
7 24701295 1 32098 F F T T 1104 -1 T 24701295_1 Custom 431 32098 AVGCOST 12408474940308818 F 1 Average Cost 47972342 7243865-1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F TL-STFF950WH F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 426.00 1 1 F T 501 F 0 F 24682545 F -8 F T 1 Echo 1-Piece Dual Flush Elongated Smart Toilet and Bidet 1149 3 0.00 EA BATHROOM : Toilets : Toilets One Piece 12408474843401695 881.40 F 1006660714 906 400.00 F 881.40 1.00 F F T 1 InvtPart 400.00 307
8 24701400 1 2715 3 F T F 0 -1 T 24701400_1 Custom 2715 MEMBERDEFINED 12408475999461044 F 1 Derived From Member Items 47972606 17243865-1 -Not Taxable- F F T F 0.00 6 CUSTOMITEMDEFINEDMEMBERDEFINED F INT1050CH-A F ERROR: Field 'item.custitem_shipping_lead_time' Not Found 83.00 1 F F F 0 F 24667021 -8 F T 1 SteamSpa Indulgence 10.5 KW QuickStart Acu-Steam Bath Generator Package with Built-in Auto Drain in Polished Chrome 0.00 SHOWER : Saunas : Generator Unit 12408475917794614 941.85 F 856 264.81 F 941.85 1.00 F F F 1 Kit 264.81 307
9 24701500 2 5043 F T T 0 -1 T 24701500_1 Custom 8 5043 AVGCOST 12408477118028520 F 1 Average Cost 47972706 -1 FL_HILLSBOROUGH CO T F T F 0.00 5 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEMEMBERDEFINEDPREFVENDORRATEPURCHORDERRATEPURCHPRICE F TileFlange_3in.(NInst) F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 8.00 1 1 F T F 0 F 24451065 F -97 F T 1 Tile Flange Kit - Not Installed 3 0.00 EA 12408477017357523 100.00 F 5.97 F 100.00 1.00 F F T 1 Assembly 8.5% 5.97 307
10 24701502 3 40699 F T T 0 -1 T 24701502_1 Custom 166 40699 AVGCOST 12408478047357161 F 1 Average Cost 47972713 -1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F SP-BK-01-Chroma_28 F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 166.00 1 1 F T F 0 F 24669918 F -8 F T 1 SP-BK-01-Chroma _28_Extension_Cable ( Black Plug ) 11 3 0.00 EA PARTS 12408477935230785 65.00 F 1041 20.00 F 65.00 1.00 F F T 1 InvtPart 20.00 307
11 24701502 3 20628 F T T 0 -1 T 24701502_2 Custom 251 20628 AVGCOST 12408478047357161 F 2 Average Cost 47972714 -1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F SP-BK-01-CHROMA F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 251.00 1 1 F T F 0 F 24669918 F -8 F T 2 1 Black Series Chroma Light 29 3 0.00 EA PARTS 12408477935230786 191.00 F 1041 20.00 F 382.00 2.00 F F T 2 InvtPart 40.00 307
12 24701504 2 1249 F T T 96 -1 T 24701504_1 Custom 288.5 1249 AVGCOST 12408478833739709 F 1 Average Cost 47972719 -1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F CT100-A F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 285.50 1 1 F T F 0 F 24567879 F -8 F T 1 Electric Heater 229 3 0.00 EA 12408478817490845 300.00 F 30.91 F 300.00 1.00 F F T 1 InvtPart 30.91 306
13 24701504 2 1666 F T T 0 -1 T 24701504_2 Custom 33 1666 AVGCOST 12408478833739709 F 1 Average Cost 47972720 -1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F Water Pump 1.5 HP F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 33.00 1 1 F T F 0 F 24567879 F -8 F T 2 1.5 HP Water Pump 18 3 0.00 EA 12408478817490846 350.00 F 54.50 F 350.00 1.00 F F T 2 InvtPart 54.50 306
14 24701504 2 12024 F T T 0 -1 T 24701504_3 Custom 138 12024 AVGCOST 12408478833739709 F 1 Average Cost 47972721 -1 -Not Taxable- T F T F 0.00 5 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEMEMBERDEFINEDPREFVENDORRATEPURCHORDERRATEPURCHPRICE F 27OFLOWKIT-WHT F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 137.00 1 1 F T F 0 F 24567879 F -8 F T 3 27 in. Waste Overflow Kit, White 3 0.00 EA BATHROOM : Bathroom Hardware : Drain 12408478817490847 165.00 F 835 26.84 F 165.00 1.00 F F T 3 Assembly 26.84 306
15 24701504 2 5127 F T T 0 -1 T 24701504_6 Custom 7 5127 AVGCOST 12408478833739709 F 1 Average Cost 47972724 -1 -Not Taxable- T F T F 0.00 5 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEMEMBERDEFINEDPREFVENDORRATEPURCHORDERRATEPURCHPRICE F A29W F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 7.00 1 1 F T F 0 F 24567879 F -8 F T 6 29 Air Jet Kit, White 3 0.00 EA 12408478817490848 470.00 F 43.59 F 470.00 1.00 F F T 6 Assembly 43.59 306
16 24701504 3 5679 F T T 0 -1 T 24701504_10 Custom 4 5679 AVGCOST 12408478833739709 F 1 Average Cost 47972728 -1 -Not Taxable- T F T F 0.00 5 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEMEMBERDEFINEDPREFVENDORRATEPURCHORDERRATEPURCHPRICE F CHLT2011NONELECTRONIC F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 4.00 1 1 F T F 0 F 24567879 F -8 F T 10 Chromatherapy KIT (with power pack) 3 0.00 EA 12408478817490849 200.00 F 20.81 F 200.00 1.00 F F T 10 Assembly 20.81 306
17 24701504 15770 F T F 0 -1 T 24701504_14 Custom 15770 ITEMDEFINED 12408478833739709 F 1 Item Defined Cost 47972732 -1 -Not Taxable- F F T F 0.00 3 CUSTOMITEMDEFINED F 7424-EW-WI-GOLD-S F ERROR: Field 'item.custitem_shipping_lead_time' Not Found 1 F F Sale F 0 F 24567879 -8 F F 14 Gold Extended Service Plan for Walk-In Bath Tubs 0.00 12408478817490850 300.00 F 0.00 F 300.00 1.00 F F F 14 Service 0.00 310
18 24701506 2 12024 F T T 0 -1 T 24701506_1 Custom 138 12024 AVGCOST 12408479549467957 F 1 Average Cost 47972737 -1 -Not Taxable- T F T F 0.00 5 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEMEMBERDEFINEDPREFVENDORRATEPURCHORDERRATEPURCHPRICE F 27OFLOWKIT-WHT F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 137.00 1 1 F T F 0 F 24621976 F -8 F T 1 27 in. Waste Overflow Kit, White 3 0.00 EA BATHROOM : Bathroom Hardware : Drain 12408479534600020 165.00 F 835 26.84 F 165.00 1.00 F F T 1 Assembly 26.84 306
19 24701508 2 17472 F T T 0 -1 T 24701508_1 Custom 566 17472 AVGCOST 12408480299708971 F 1 Average Cost 47972744 -1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F X36 F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 566.00 1 1 F T F 0 F 24628377 F -8 F T 1 X36 Black tub neck pillow 170 3 0.00 EA PARTS 12408480285791796 80.00 F 1041 6.50 F 80.00 1.00 F F T 1 InvtPart 6.50 306
20 24701508 2 1666 F T T 0 -1 T 24701508_2 Custom 33 1666 AVGCOST 12408480299708971 F 1 Average Cost 47972745 -1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F Water Pump 1.5 HP F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 33.00 1 1 F T F 0 F 24628377 F -8 F T 2 1.5 HP Water Pump 18 3 0.00 EA 12408480285791797 350.00 F 54.50 F 350.00 1.00 F F T 2 InvtPart 54.50 306
21 24701510 3 5679 F T T 0 -1 T 24701510_1 Custom 4 5679 AVGCOST 12408481270120190 F 1 Average Cost 47972750 -1 -Not Taxable- T F T F 0.00 5 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEMEMBERDEFINEDPREFVENDORRATEPURCHORDERRATEPURCHPRICE F CHLT2011NONELECTRONIC F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 4.00 1 1 F T F 0 F 24651428 F -8 F T 1 Chromatherapy KIT (with power pack) 3 0.00 EA 12408481255954364 200.00 F 20.81 F 200.00 1.00 F F T 1 Assembly 20.81 306
22 24701510 2 17472 F T T 0 -1 T 24701510_5 Custom 566 17472 AVGCOST 12408481270120190 F 1 Average Cost 47972754 -1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F X36 F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 566.00 1 1 F T F 0 F 24651428 F -8 F T 5 X36 Black tub neck pillow 170 3 0.00 EA PARTS 12408481255954365 80.00 F 1041 6.50 F 80.00 1.00 F F T 5 InvtPart 6.50 306
23 24701510 15767 F T F 0 -1 T 24701510_6 Custom 15767 ITEMDEFINED 12408481270120190 F 1 Item Defined Cost 47972755 -1 -Not Taxable- F F T F 0.00 3 CUSTOMITEMDEFINED F 7424-EW-BT-DIAM-S F ERROR: Field 'item.custitem_shipping_lead_time' Not Found 1 F F Sale F 0 F 24651428 -8 F F 6 Diamond Extended Service Plan for Bathtub 0.00 12408481255954366 600.00 F 0.00 F 600.00 1.00 F F F 6 Service 0.00 306
24 24701512 2 12024 F T T 0 -1 T 24701512_1 Custom 138 12024 AVGCOST 12408481971927997 F 1 Average Cost 47972760 -1 -Not Taxable- T F T F 0.00 5 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEMEMBERDEFINEDPREFVENDORRATEPURCHORDERRATEPURCHPRICE F 27OFLOWKIT-WHT F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 137.00 1 1 F T F 0 F 24671337 F -8 F T 1 27 in. Waste Overflow Kit, White 3 0.00 EA BATHROOM : Bathroom Hardware : Drain 12408481957437154 165.00 F 835 26.84 F 165.00 1.00 F F T 1 Assembly 26.84 306
25 24701514 2 12024 F T T 0 -1 T 24701514_1 Custom 138 12024 AVGCOST 12408482661928677 F 1 Average Cost 47972767 -1 -Not Taxable- T F T F 0.00 5 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEMEMBERDEFINEDPREFVENDORRATEPURCHORDERRATEPURCHPRICE F 27OFLOWKIT-WHT F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 137.00 1 1 F T F 0 F 24696568 F -8 F T 1 27 in. Waste Overflow Kit, White 3 0.00 EA BATHROOM : Bathroom Hardware : Drain 12408482647627524 165.00 F 835 26.84 F 165.00 1.00 F F T 1 Assembly 26.84 306
26 24701517 1 27909 F F T T 104 -1 T 24701517_1 Custom 0 27909 AVGCOST 12408485814077903 F 1 Average Cost 47972777 7243865-1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F SD-FRLS05801BN F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 0.00 1 1 F T 01 F 0 F 24673123 F -8 F T 1 76" x 48" Frameless Shower Door, Double Sliding with horizontal handle - Brushed 70 3 0.00 EA 12408483315924313 405.00 F 4091241 96.01 F 405.00 1.00 F F T 1 InvtPart 96.01 307
27 24701518 1 44015 F F T T 900 -1 T 24701518_1 Custom 6 44015 AVGCOST 12408489105452881 F 1 Average Cost 47972780 7243865-1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F WH-AZ035-M1 F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 6.00 1 F T 01 F 0 F 24684746 F -8 F T 1 ENVO Ansen 3.5 kW Tankless Electric Water Heater 618 0.00 12408486653862345 112.44 F 5175708 44.20 F 112.44 1.00 F F T 1 InvtPart 44.20 307
28 24701519 1 28634 F T F 0 -1 T 24701519_1 Custom 28634 MEMBERDEFINED 12408490057498575 F 1 Derived From Member Items 47972783 7243865-1 -Not Taxable- F F T F 0.00 6 CUSTOMITEMDEFINEDMEMBERDEFINED F FT-CF130LXFT-CH F ERROR: Field 'item.custitem_shipping_lead_time' Not Found 230.00 1 F F 501 F 0 F 24685247 -8 F T 1 Feet For Claw foot tub BT-27B/26 0.00 12408489965527085 254.19 F 1005812464 213.00 F 254.19 1.00 F F F 1 Kit 213.00 307
29 24701520 1 45771 F F T T 117 -1 T 24701520_1 Custom 0 45771 AVGCOST 12408490884242454 F 2 Average Cost 47972788 1724386145-1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F SB-AZ103C F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 0.00 1 1 F T 01 F 0 F 24685244 F -8 F T 1 N/A 158 3 0.00 EA 12408490783526282 134.92 F 1007911148 71.025 F 269.84 2.00 F F T 1 InvtPart 142.05 306
30 24701521 1 45770 F F T T 123 -1 T 24701521_1 Custom 0 45770 AVGCOST 12408491699426354 F 1 Average Cost 47972791 1724386145-1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F SB-AZ103L F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 0.00 1 1 F T 501 F 1 F 24673569 F -8 F T 1 N/A 131 3 0.00 EA 12408491605956926 134.92 F 1007911140 76.50 F 134.92 1.00 F F T 1 InvtPart 76.50 306
31 24701522 1 45771 F F T T 117 -1 T 24701522_1 Custom 0 45771 AVGCOST 12408492605213201 F 1 Average Cost 47972794 1724386145-1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F SB-AZ103C F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 0.00 1 1 F T 501 F 0 F 24671955 F -8 F T 1 N/A 158 3 0.00 EA 12408492505866765 134.92 F 1007911148 71.02 F 134.92 1.00 F F T 1 InvtPart 71.02 306
32 24701523 1 44020 F F T T 300 -1 T 24701523_1 Custom 223 44020 AVGCOST 12408493590445377 F 1 Average Cost 47972798 172438156165-1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F WH-AZ018-M3 F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 223.00 1 F T 501 F 0 F 24682146 F -8 F T 1 ENVO Atami 18 kW Tankless Electric Water Heater 493 0.00 12408493491729406 183.65 F 1007834984 128.13 F 183.65 1.00 F F T 1 InvtPart 128.13 307
33 24701524 1 8623 3 F F T T 0 -1 K-AZ3219-1A K-AZ3219-1Ac T 24701524_1 Custom 0 8623 AVGCOST 12408494433522990 KF-AZ031BN F 1 Average Cost 47972799 1748 17243865-1 -Not Taxable- T F T 8624 F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F K-AZ3018-1AC F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 1/4/2024 KF-AZ151 0.00 2143 1 9 1 9 F T 01 F 0 F KF-AZ032BN 24672593 T -8 F K-AZ3018-1A T 1 30" Stainless Steel Undermount Kitchen Sink - Brushed - Aegis Series K-AZ3018-1A 6 3 0.00 1971 EA 8927 KITCHEN : Kitchen Sinks : Kitchen Sinks Under Mount 12408494342816890 1956 280.00 F 1003334601 871 56.07 1 F 280.00 1.00 F F T 1 InvtPart 3 56.07 307
34 24701525 1 45767 F F T T 140 -1 T 24701525_1 Custom 0 45767 AVGCOST 12408495259766572 F 1 Average Cost 47972803 1724386145-1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F SB-AZ101L F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 0.00 1 1 F T 501 F 0 F 24684845 F -8 F T 1 N/A 119 3 0.00 EA 12408495157918915 247.37 F 1007911147 77.92 F 247.37 1.00 F F T 1 InvtPart 77.92 306
35 24701526 1 9735 3 F F T T 0 -1 T 24701526_1 Custom 102 9735 AVGCOST 12408496110202259 F 1 Average Cost 47974859 17243865-1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F FS-AZ0047BK F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 1/4/2024 102.00 1 9 1 9 F T 03 F 0 F 24685446 T -8 F T 1 Freestanding Bathtub Faucet - Black - FS-AZ0047BK - ANZZI 121 3 0.00 EA BATHROOM : Faucets : Bathtub Faucets : Bathtub Faucets Freestanding 12408496018039538 283.10 F 1004118177 825 126.92 1 F 283.10 1.00 F F T 1 InvtPart 3 126.92 307
36 24701527 1 9016 3 F F T T 0 -1 L-AZ012ORB L-AZ104ORB T 24701527_1 Custom 0 9016 AVGCOST 12408496938834727 LS-AZ107 F 1 Average Cost 47974862 9010 17243865-1 -Not Taxable- T F T 15359 F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F L-AZ009ORB F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 1/4/2024 LS-AZ112 0.00 9004 1 9 1 9 F T 503 F 0 F LS-AZ027 24672915 T -8 F L-AZ011ORB T 1 Single Hole Single-Handle Bathroom Faucet - Oil Rubbed Bronze - Arc Series L-AZ0 6 3 0.00 9068 EA 9071 BATHROOM : Faucets : Bathroom Sink Faucets : Bathroom Faucets Single Hole 12408496835699451 1844 77.99 F 1001688257 817 33.08 1 F 77.99 1.00 F F T 1 InvtPart 3 33.08 307
37 24701528 1 19662 3 F T F 0 -1 T 24701528_1 Custom 19662 MEMBERDEFINED 12408497734992551 FT-AZ095 F 1 Derived From Member Items 47974865 17243865-1 -Not Taxable- F F T F 0.00 6 CUSTOMITEMDEFINEDMEMBERDEFINED F PAN-301 F ERROR: Field 'item.custitem_shipping_lead_time' Not Found SD-AZ13-02BN 1231.00 1 F F 502 F 0 F SP-AZ022 24676188 -8 F T 1 Stainless Steel Drain Pan for SteamSpa Generators - G-DPAN - STEAMSPA 0.00 1881 9086 PARTS 12408497642645809 8803 76.03 F 1001483649 1041 27.42 F 76.03 1.00 F F F 1 Kit 27.42 307
38 24701600 3 57223 F T T 0 -1 T 24701600_1 Custom 0 57223 AVGCOST 12408498696873824 F 1 Average Cost 47972807 -1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F KF-AZ258CH_Part_1 F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 0.00 1 1 F T F 0 F 24572412 F -8 F T 1 KF-AZ258CH_Part_1_Faucet 0 3 0.00 EA PARTS : Kitchen Faucet 12408498558330004 F 1242 0.00 F 0.00 1.00 F F T 1 InvtPart 0.00 307
39 24701600 20738 F T F 0 -1 T 24701600_2 Custom 20738 ITEMDEFINED 12408498696873824 F 1 Item Defined Cost 47972810 -1 -Not Taxable- F F T F 0.00 4 CUSTOMITEMDEFINED F Shipping and Handling on Sales Order F ERROR: Field 'item.custitem_shipping_lead_time' Not Found 1 F F Sale F 0 F 24572412 -8 F F 2 other charge for closing shipping charges 0.00 12408498558330005 F 0.00 F 20.00 1.00 F F F 2 OthCharge 0.00 309
40 24701601 3 40699 F T T 0 -1 T 24701601_1 Custom 166 40699 AVGCOST 12408499818378757 F 1 Average Cost 47972808 -1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F SP-BK-01-Chroma_28 F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 166.00 1 1 F T F 0 F 24673240 F -8 F T 1 SP-BK-01-Chroma _28_Extension_Cable ( Black Plug ) 11 3 0.00 EA PARTS 12408499690353941 F 1041 20.00 F 65.00 1.00 F F T 1 InvtPart 20.00 307
41 24701601 1 28666 F T T 0 -1 T 24701601_2 Custom 0 28666 AVGCOST 12408499818378757 F 1 Average Cost 47972809 -1 -Not Taxable- T F T F 0.00 5 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEMEMBERDEFINEDPREFVENDORRATEPURCHORDERRATEPURCHPRICE F STMKIT-02 F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 0.00 1 F T F 3 F 24673240 F -8 F T 2 Steam Spa Generators Quick Installation Kit with 3/8 X 20 FLEX LAV CONNECTOR (1), 1/2F X 3/8 CMO LF ANG VLV (1), Ever Flow Copper Fitting Union CxC 1/2" (1), 3/4 CXC WROT UNION (2), 1/2 CXF W ADAPTER (2), 3/4 CXF W ADAPTER (2), ELBOW, PRESSURE COPPER 3/4 X 3/4 90 DEGREE (2), Pressure Reduction Valve (1), and Pressure Gauge 3.5 (1), Housing Standard Clear 1/4"NPT 05" x 2.5" (1), 1/2" FNPT x 1/4" MNPT Brass Reducing Adapter (2), and 2.5 in x 5 in Melt Blown Sediment Filter 10 Micron (3) 3 0.00 12408499690353942 F 60.72 F 250.00 1.00 F F T 2 Assembly 60.72 307
42 24701604 3 52394 F T T 0 -1 T 24701604_1 Custom 7639 52394 AVGCOST 12408500758783550 F 1 Average Cost 47972828 -1 -Not Taxable- T F T F 0.00 5 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEMEMBERDEFINEDPREFVENDORRATEPURCHORDERRATEPURCHPRICE F MF-HJBLT040-CH F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 7635.00 1 F T F 0 F 24677230 F -8 F T 1 BULLET JET SINGLE HOLE 0.00 12408500637303978 0.00 F 0.86 F 0.00 1.00 F F T 1 Assembly 0.86 306
43 24701604 3 1320 F T T 0 -1 T 24701604_4 Custom 182336.57142857 1320 AVGCOST 12408500758783550 F 1 Average Cost 47972831 -1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F FLEXHOSE-0.5 F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 182336.43 1 7 F T F 0 F 24677230 F -8 F T 4 Flexhose 1/2'' Inches 52846 8 0.00 FT 12408500637303979 0.00 F 0.31 F 0.00 1.00 F F T 4 InvtPart 0.31 306
44 24701604 3 1321 F T T 0 -1 T 24701604_5 Custom 257588.72857143 1321 AVGCOST 12408500758783550 F 1 Average Cost 47972832 -1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F FLEXHOSE-1.0 F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 257588.69 1 7 F T F 0 F 24677230 F -8 F T 5 Flexhose 1'' Inch (Per Feet) 58470 8 0.00 FT 12408500637303980 0.00 F 0.49 F 0.00 1.00 F F T 5 InvtPart 0.49 306
45 24701604 3 989 F T T 0 -1 T 24701604_6 Custom 6083 989 AVGCOST 12408500758783550 F 1 Average Cost 47972833 -1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F 449-005 F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 6083.00 1 1 F T F 0 F 24677230 F -8 F T 6 1/2 inc plug 3168 3 0.00 EA 12408500637303981 0.00 F 0.20 F 0.00 1.00 F F T 6 InvtPart 0.20 306
46 24701604 3 15579 F T T 0 -1 T 24701604_7 Custom 112511 15579 AVGCOST 12408500758783550 F 1 Average Cost 47972834 -1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F 449-010 F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 112511.00 1 1 F T F 0 F 24677230 F -8 F T 7 1 Spg PVC 40 Plug 12 3 0.00 EA PARTS 12408500637303982 0.00 F 1041 0.42 F 0.00 1.00 F F T 7 InvtPart 0.42 306
47 24701604 3 985 F T T 0 -1 T 24701604_8 Custom 6218 985 AVGCOST 12408500758783550 F 2 Average Cost 47972835 -1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F 429-010 F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 6218.00 1 1 F T F 0 F 24677230 F -8 F T 8 1'' Inch PVC Coupling 841 3 0.00 EA 12408500637303983 0.00 F 0.18 F 0.00 2.00 F F T 8 InvtPart 0.36 306
48 24701604 3 984 F T T 0 -1 T 24701604_9 Custom 1197 984 AVGCOST 12408500758783550 F 2 Average Cost 47972836 -1 -Not Taxable- T F T F 0.00 1 AVGCOSTCUSTOMITEMDEFINEDLASTPURCHPRICEPREFVENDORRATEPURCHORDERRATEPURCHPRICE F 429-005 F 1/1/1970 ERROR: Field 'item.custitem_shipping_lead_time' Not Found 345678910 1197.00 1 1 F T F 0 F 24677230 F -8 F T 9 1/2'' Inch PVC Coupling 25 3 0.00 EA 12408500637303984 0.00 F 0.07 F 0.00 2.00 F F T 9 InvtPart 0.14 306
49 24701604 20738 F T F 0 -1 T 24701604_10 Custom 20738 ITEMDEFINED 12408500758783550 F 1 Item Defined Cost 47972837 -1 -Not Taxable- F F T F 0.00 4 CUSTOMITEMDEFINED F Shipping and Handling on Sales Order F ERROR: Field 'item.custitem_shipping_lead_time' Not Found 1 F F Sale F 0 F 24677230 -8 F F 10 other charge for closing shipping charges 0.00 12408500637303985 20.00 F 0.00 F 20.00 1.00 F F F 10 OthCharge 0.00 309
50 24701606 1 29481 F T F 0 -1 T 24701606_1 Custom 29481 MEMBERDEFINED 12408501634539744 F 1 Derived From Member Items 47972842 2465-1 -Not Taxable- F F T F 0.00 6 CUSTOMITEMDEFINEDMEMBERDEFINED F BKT1200MK-A F ERROR: Field 'item.custitem_shipping_lead_time' Not Found 175.00 1 F F 01 F 0 F 24678176 -8 F T 1 Black Series Bluetooth 12kW QuickStart Steam Bath Generator Package in Matte Black 0.00 12408501537937770 2041.99 F 1005653330 409.84 F 2041.99 1.00 F F F 1 Kit 409.84 307
Page 1 Next