Table: assemblyunbuild

InternalId custbody_sw_upsell_hold_ custbody_product_added_on_workorder item custbody_sw_assembly_description item_refid custbody_wrm_claimnumber custbody_wrm_claimnumber_refid class class_refid customform customform_refid trandate trandate_dt department department_refid externalid custbody_atlas_inspectedby custbody_atlas_inspectedby_refid custbody_atlas_inspectiondate custbody_atlas_inspectiondate_dt id location location_refid custbodymannycheckbox maxreloaddate_dt memo minreloaddate_dt ntype_refid oldtrandate_dt custbody_atlas_wo_planner custbody_atlas_wo_planner_refid postingperiod postingperiod_refid pp_e_dt pp_s_dt prevdate_dt custbody_sw_priority_item total built custbody_atlas_qtyfailed quantity tranid custbody_sw_related_so_number custbody_sw_related_so_number_refid revision revisionmemo revision_refid custbody_sales_order_line_count custbody_atlas_wo_seq custbody_atlas_wo_att1 custbody_atlas_wo_att1_refid custbody_atlas_wo_att2 custbody_atlas_wo_att2_refid custbody_atlas_wo_att3 custbody_atlas_wo_att3_refid custbody_ship_by custbody_ship_by_dt custbody_scpq_wo_parent_created_clean custbody_so_formula_ship_date custbody_so_formula_ship_date_dt custbodysw_so_number custbody26 custbody26_dt custbody_scpq_so_lineitem_description custbody_scpq_wo_parent_created_from custbody_scpq_trns_so_created_from custbody_scpq_wo_trans_solinenum subsidiary subsidiary_refid custbodytransferordercbwos transactionnumber units units_refid custbody_scpq_trns_so_created_clean custbody_wo_label_print_transaction custbodywork_order_location_trans_ custbodywork_order_location_trans__refid custbody_wo_count_total allownonglchanges auxdate baserecordtype binitem bulk componentquantitiesneedrecalculation costingmethod createddate currencyprecision customwhence dbstrantype effectivebomcontrol entityname entryformquerystring haslines inventorydetailavail inventorydetailreq inventorydetailuitype isnumbered isserial line linked linkedclosedperioddiscounts linkedrevrecje locationusesbins maxreloaddate minreloaddate nsbrowserenv ntype oldtrandate orderassemblyqty origquantity periodclosed pp_e pp_s ppsetbyuser ppsetbyuservalue prevdate quantityonchangeenabled rectype_159_1115_maxnkey rectype_400_3093_maxnkey selectedtab taxperiod templatestored trantypepermcheck type version voided lastmodifieddate
8000226 F F 2753WILWD-V1 2753WI LEFT FULLY LOADED 30152 Standard Assembly Unbuild 21 5/7/2021 5/7/2021 12:00:00 AM 8000226 Miami 1 F 12/31/9999 12:00:00 AM 1/1/1970 12:00:00 AM 35 May 2021 76 5/31/2021 12:00:00 AM 5/1/2021 12:00:00 AM 5/7/2021 12:00:00 AM F 11672.10 11.000000 11 ASSYUS03 Spa World Corporation 1 F UNBUILD3 Each 3 F assemblyunbuild T F AVG 5/7/2021 9:05 am 2 Unbuild EFFECTIVE_DATE e=T&id=8000226 T T T LOH_STRICT_VALIDATION_INVENTORY_NOT_AVAIL F F 0 F F F T 12/31/9999 1/1/1970 Assembly Unbuild 11.000000 11 5/31/2021 5/1/2021 F 5/7/2021 T 0 7 T unbuild 1 F 5/7/2021 9:05 am
20162538 F F FT-AZ132CH White Tub with Clawfeet in Chrome 52762 Standard Assembly Unbuild 21 4/5/2023 4/5/2023 12:00:00 AM 20162538 Miami 1 F 12/31/9999 12:00:00 AM 1/1/1970 12:00:00 AM 35 Apr 2023 110 4/30/2023 12:00:00 AM 4/1/2023 12:00:00 AM 4/5/2023 12:00:00 AM F 18982.60 178.000000 98 ASSYUS08 Spa World Corporation 1 F UNBUILD8 F assemblyunbuild T F AVG 4/5/2023 3:23 pm 2 Unbuild EFFECTIVE_DATE e=T&id=20162538 T T T LOH_STRICT_VALIDATION_INVENTORY_NOT_AVAIL F F 0 F F F T 12/31/9999 1/1/1970 Assembly Unbuild 98.000000 98 4/30/2023 4/1/2023 F 4/5/2023 T 0 7 T unbuild 1 F 4/5/2023 3:23 pm
20162541 F F FT-AZ132MB White Tub with Clawfeet in Matte Black 52760 Standard Assembly Unbuild 21 4/5/2023 4/5/2023 12:00:00 AM 20162541 Miami 1 F 12/31/9999 12:00:00 AM 1/1/1970 12:00:00 AM 35 Apr 2023 110 4/30/2023 12:00:00 AM 4/1/2023 12:00:00 AM 4/5/2023 12:00:00 AM F 5227.20 130.000000 121 ASSYUS09 Spa World Corporation 1 F UNBUILD9 F assemblyunbuild T F AVG 4/5/2023 3:26 pm 2 Unbuild EFFECTIVE_DATE e=T&id=20162541 T T T LOH_STRICT_VALIDATION_INVENTORY_NOT_AVAIL F F 0 F F F T 12/31/9999 1/1/1970 Assembly Unbuild 121.000000 121 4/30/2023 4/1/2023 F 4/5/2023 T 0 7 T unbuild 1 F 4/5/2023 3:26 pm
20162549 F F FT-AZ132CH White Tub with Clawfeet in Chrome 52762 Standard Assembly Unbuild 21 4/5/2023 4/5/2023 12:00:00 AM 20162549 Miami 1 F 12/31/9999 12:00:00 AM 1/1/1970 12:00:00 AM 35 Apr 2023 110 4/30/2023 12:00:00 AM 4/1/2023 12:00:00 AM 4/5/2023 12:00:00 AM F 18982.60 178.000000 98 ASSYUS10 Spa World Corporation 1 F UNBUILD10 F assemblyunbuild T F AVG 4/5/2023 3:29 pm 2 Unbuild EFFECTIVE_DATE e=T&id=20162549 T T T LOH_STRICT_VALIDATION_INVENTORY_NOT_AVAIL F F 0 F F F T 12/31/9999 1/1/1970 Assembly Unbuild 98.000000 98 4/30/2023 4/1/2023 F 4/5/2023 T 0 7 T unbuild 1 F 4/5/2023 3:29 pm
20162550 F F FT-AZ132MB White Tub with Clawfeet in Matte Black 52760 Standard Assembly Unbuild 21 4/5/2023 4/5/2023 12:00:00 AM 20162550 Miami 1 F 12/31/9999 12:00:00 AM 1/1/1970 12:00:00 AM 35 Apr 2023 110 4/30/2023 12:00:00 AM 4/1/2023 12:00:00 AM 4/5/2023 12:00:00 AM F 5227.20 130.000000 121 ASSYUS11 Spa World Corporation 1 F UNBUILD11 F assemblyunbuild T F AVG 4/5/2023 3:30 pm 2 Unbuild EFFECTIVE_DATE e=T&id=20162550 T T T LOH_STRICT_VALIDATION_INVENTORY_NOT_AVAIL F F 0 F F F T 12/31/9999 1/1/1970 Assembly Unbuild 121.000000 121 4/30/2023 4/1/2023 F 4/5/2023 T 0 7 T unbuild 1 F 4/5/2023 3:30 pm
24094576 F T 2646RWA 2646WI: Right: White: Air: PneumaticControl: Color Match Trim: Overflow 36405 Standard Assembly Unbuild 21 12/6/2023 12/6/2023 12:00:00 AM 24094576 Miami 1 F 12/31/9999 12:00:00 AM Add-on: AUTO DRAIN 2013-A-S-WTKIT & ATHK-WHT 1/1/1970 12:00:00 AM 35 Dec 2023 120 12/31/2023 12:00:00 AM 12/1/2023 12:00:00 AM 12/6/2023 12:00:00 AM F 1061.27 1.000000 1 ASSYUS15 Spa World Corporation 1 F UNBUILD15 F assemblyunbuild T F STANDARD 12/6/2023 3:19 pm 2 Unbuild EFFECTIVE_DATE e=T&id=24094576 T T T LOH_STRICT_VALIDATION_INVENTORY_NOT_AVAIL T T 0 F F F T 12/31/9999 1/1/1970 Assembly Unbuild 1.000000 1 12/31/2023 12/1/2023 F 12/6/2023 T 0 7 T unbuild 1 F 12/6/2023 3:19 pm
7754119 F F AUTO DRAIN 2013-D-H-CH Auto Drain for Dual & Hydro (Chrome Control & Trim) 5756 Standard Assembly Unbuild 21 4/23/2021 4/23/2021 12:00:00 AM 7754119 Miami 1 F 12/31/9999 12:00:00 AM 1/1/1970 12:00:00 AM 35 Apr 2021 75 4/30/2021 12:00:00 AM 4/1/2021 12:00:00 AM 4/23/2021 12:00:00 AM F 10.34 14.000000 1 ASSYUS02 Spa World Corporation 1 F UNBUILD2 Each 3 F assemblyunbuild T F STANDARD 4/23/2021 12:00 pm 2 Unbuild EFFECTIVE_DATE e=T&id=7754119 T T T LOH_STRICT_VALIDATION_INVENTORY_NOT_AVAIL F F 0 F F F T 12/31/9999 1/1/1970 Assembly Unbuild 1.000000 1 4/30/2021 4/1/2021 F 4/23/2021 T 0 7 T unbuild 2 F 7/16/2021 9:46 am
11812161 F F H3660LWDCD 3660WI: Left: White: Dual: Friction Heater: Chroma: Aroma: PneumaticControl: Chrome Trim: AutoDrain: Overflow: Faucet : HEATED PAD : WALL SURROUND FLAT TILE - GLOSSY WHITE : 3x 60x60" ACRYLIC SHEETS : 2x 60" CORNER CADDIES : 15x SILICONE TUBES : 6x ADHESIVE TAPE : 2x CAULKING TUBES 25361 Standard Assembly Unbuild 21 12/17/2021 12/17/2021 12:00:00 AM 11812161 Miami 1 F 12/31/9999 12:00:00 AM 1/1/1970 12:00:00 AM 35 Dec 2021 85 12/31/2021 12:00:00 AM 12/1/2021 12:00:00 AM 12/17/2021 12:00:00 AM F 843.71 1.000000 1 ASSYUS05 Spa World Corporation 1 F UNBUILD5 F assemblyunbuild T F STANDARD 12/17/2021 11:28 am 2 Unbuild EFFECTIVE_DATE e=T&id=11812161 T T T LOH_STRICT_VALIDATION_INVENTORY_NOT_AVAIL T T 0 F F F T 12/31/9999 1/1/1970 Assembly Unbuild 1.000000 1 12/31/2021 12/1/2021 F 12/17/2021 T 0 7 T unbuild 1 F 12/17/2021 11:28 am
13332100 F F HD3054LWD 3054WI: VShaped-Jets: Left: White: Dual: Friction Heater: Chroma: Aroma: PneumaticControl: Chrome Trim: AutoDrain: Overflow: Faucet 6754 Standard Assembly Unbuild 21 3/11/2022 3/11/2022 12:00:00 AM 13332100 Miami 1 F 12/31/9999 12:00:00 AM 1/1/1970 12:00:00 AM 35 Mar 2022 91 3/31/2022 12:00:00 AM 3/1/2022 12:00:00 AM 3/11/2022 12:00:00 AM F 698.42 1.000000 1 ASSYUS06 Spa World Corporation 1 F UNBUILD6 Each 3 F assemblyunbuild T F STANDARD 3/11/2022 9:27 am 2 Unbuild EFFECTIVE_DATE e=T&id=13332100 T T T LOH_STRICT_VALIDATION_INVENTORY_NOT_AVAIL T T 0 F F F T 12/31/9999 1/1/1970 Assembly Unbuild 1.000000 1 3/31/2022 3/1/2022 F 3/11/2022 T 0 7 T unbuild 1 F 3/11/2022 9:27 am
24915347 F T 4270PWL Petite 4270: Left: White: Hydro: PneumaticControl: Color Match Trim 35566 Standard Assembly Unbuild 21 1/16/2024 1/16/2024 12:00:00 AM 24915347 Miami 1 F 12/31/9999 12:00:00 AM 1/1/1970 12:00:00 AM 35 Jan 2024 124 1/31/2024 12:00:00 AM 1/1/2024 12:00:00 AM 1/16/2024 12:00:00 AM F 124.10 1.000000 1 ASSYUS16 1/19/2024 1/19/2024 12:00:00 AM Spa World Corporation 1 F UNBUILD16 F assemblyunbuild T F AVG 1/16/2024 1:40 pm 2 Unbuild EFFECTIVE_DATE e=T&id=24915347 T T T LOH_STRICT_VALIDATION_INVENTORY_NOT_AVAIL T T 0 F F F T 12/31/9999 1/1/1970 Assembly Unbuild 1.000000 1 1/31/2024 1/1/2024 F 1/16/2024 T 0 7 T unbuild 1 F 1/16/2024 1:40 pm
993629 F F SP-STMKIT-01 Steam Spa Generators Quick Instaltion 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) 4286 Standard Assembly Unbuild 21 6/11/2019 6/11/2019 12:00:00 AM 993629 Miami 1 F 12/31/9999 12:00:00 AM 1/1/1970 12:00:00 AM 35 Jun 2019 43 6/30/2019 12:00:00 AM 6/1/2019 12:00:00 AM 6/11/2019 12:00:00 AM F 1060.60 31.000000 30 ASSYUS01 Spa World Corporation 1 F UNBUILD1 Each 3 F assemblyunbuild T F STANDARD 6/11/2019 5:04 pm 2 Unbuild EFFECTIVE_DATE e=T&id=993629 T T T LOH_STRICT_VALIDATION_INVENTORY_NOT_AVAIL F F 0 F F F T 12/31/9999 1/1/1970 Assembly Unbuild 30.000000 30 6/30/2019 6/1/2019 F 6/11/2019 T 0 7 T unbuild 2 F 7/14/2021 12:38 pm
20817287 F F FT-AZ114-5973CH 59" Deck Mounted Faucet Free Standing Tub With Chrome Faucet 52886 Standard Assembly Unbuild 21 5/11/2023 5/11/2023 12:00:00 AM 20817287 Miami 1 F 12/31/9999 12:00:00 AM 1/1/1970 12:00:00 AM 35 May 2023 111 5/31/2023 12:00:00 AM 5/1/2023 12:00:00 AM 5/11/2023 12:00:00 AM F 22625.79 87.000000 69 ASSYUS12 Spa World Corporation 1 F UNBUILD12 F assemblyunbuild T F AVG 5/11/2023 9:22 am 2 Unbuild EFFECTIVE_DATE e=T&id=20817287 T T T LOH_STRICT_VALIDATION_INVENTORY_NOT_AVAIL F F 0 F F F T 12/31/9999 1/1/1970 Assembly Unbuild 69.000000 69 5/31/2023 5/1/2023 F 5/11/2023 T 0 7 T unbuild 1 F 5/11/2023 9:22 am
15817050 F F 786354 Costco Venetian 3672: VShaped-Jets: Right: White: Dual: Electric Heater: Chroma: Chrome ElectronicControl: Chrome Trim 15464 Standard Assembly Unbuild 21 7/26/2022 7/26/2022 12:00:00 AM 15817050 Miami 1 F 12/31/9999 12:00:00 AM 1/1/1970 12:00:00 AM 35 Jul 2022 97 7/31/2022 12:00:00 AM 7/1/2022 12:00:00 AM 7/26/2022 12:00:00 AM F 6022.44 11.000000 10 ASSYUS07 Spa World Corporation 1 F UNBUILD7 Each 3 F assemblyunbuild T F STANDARD 7/26/2022 1:31 pm 2 Unbuild EFFECTIVE_DATE e=T&id=15817050 T T T LOH_STRICT_VALIDATION_INVENTORY_NOT_AVAIL T T 0 F F F T 12/31/9999 1/1/1970 Assembly Unbuild 10.000000 10 7/31/2022 7/1/2022 F 7/26/2022 T 0 7 T unbuild 1 F 7/26/2022 1:31 pm
11137684 F F WF3140RWHCE 3140WI: Right: White: Hydro: Friction Heater: PneumaticControl: Chrome Trim: Overflow: Faucet : HEATED PAD : WALL SURROUND SQ 4" TILE - GLOSSY WHITE : 2x 60x60" ACRYLIC SHEETS : 2x 60" CORNER CADDIES : 10x SILICONE TUBES : 4x ADHESIVE TAPE : 2x CAULKING TUBES 39437 Standard Assembly Unbuild 21 11/5/2021 11/5/2021 12:00:00 AM 11137684 Miami 1 F 12/31/9999 12:00:00 AM 1/1/1970 12:00:00 AM 35 Nov 2021 84 11/30/2021 12:00:00 AM 11/1/2021 12:00:00 AM 11/5/2021 12:00:00 AM F 580.00 1.000000 1 ASSYUS04 Spa World Corporation 1 F UNBUILD4 T assemblyunbuild T F AVG 11/5/2021 6:01 pm 2 Unbuild EFFECTIVE_DATE e=T&id=11137684 T T T LOH_STRICT_VALIDATION_INVENTORY_NOT_AVAIL T T 0 F F F T 12/31/9999 1/1/1970 Assembly Unbuild 1.000000 1 11/30/2021 11/1/2021 F 11/5/2021 T 0 7 T unbuild 1 F 11/5/2021 6:01 pm
23704372 F F AMZ3060WIRWD 3060WI: VShaped-Jets: Right: White: Dual: Friction Heater: Chroma: Aroma: PneumaticControl: Chrome Trim: AutoDrain: Overflow: Faucet 54266 Standard Assembly Unbuild 21 11/16/2023 11/16/2023 12:00:00 AM 23704372 Miami 1 F 12/31/9999 12:00:00 AM 1/1/1970 12:00:00 AM 35 Nov 2023 119 11/30/2023 12:00:00 AM 11/1/2023 12:00:00 AM 11/16/2023 12:00:00 AM F 2280.00 4.000000 3 ASSYUS13 Spa World Corporation 1 F UNBUILD13 Each 3 F assemblyunbuild T F AVG 11/16/2023 12:50 pm 2 Unbuild EFFECTIVE_DATE e=T&id=23704372 T T T LOH_STRICT_VALIDATION_INVENTORY_NOT_AVAIL T T 0 F F F T 12/31/9999 1/1/1970 Assembly Unbuild 3.000000 3 11/30/2023 11/1/2023 F 11/16/2023 T 0 7 T unbuild 1 F 11/16/2023 12:50 pm
23705650 F F EXT1050BN-A 29755 Standard Assembly Unbuild 21 11/16/2023 11/16/2023 12:00:00 AM 23705650 Miami 1 F 12/31/9999 12:00:00 AM 1/1/1970 12:00:00 AM 35 Nov 2023 119 11/30/2023 12:00:00 AM 11/1/2023 12:00:00 AM 11/16/2023 12:00:00 AM F 522.54 5.000000 2 ASSYUS14 Spa World Corporation 1 F UNBUILD14 F assemblyunbuild T F AVG 11/16/2023 1:43 pm 2 Unbuild EFFECTIVE_DATE e=T&id=23705650 T T T LOH_STRICT_VALIDATION_INVENTORY_NOT_AVAIL F F 0 F F F T 12/31/9999 1/1/1970 Assembly Unbuild 2.000000 2 11/30/2023 11/1/2023 F 11/16/2023 T 0 7 T unbuild 1 F 11/16/2023 1:43 pm
28246893 F F SC-SS0014-GS 58115 Standard Assembly Unbuild 21 7/25/2024 7/25/2024 12:00:00 AM 28246893 Miami 1 F 12/31/9999 12:00:00 AM 1/1/1970 12:00:00 AM 35 Jul 2024 132 7/25/2024 12:00:00 AM F 10080.00 18.000000 18 ASSYUS17 Spa World Corporation 1 F UNBUILD17 F assemblyunbuild T F AVG 7/25/2024 4:17 pm 2 Unbuild EFFECTIVE_DATE e=T&id=28246893 T T T LOH_STRICT_VALIDATION_INVENTORY_NOT_AVAIL F F 0 F F F T 12/31/9999 1/1/1970 Assembly Unbuild 18.000000 18 F 7/25/2024 T 0 7 T unbuild 1 F 7/25/2024 4:17 pm
28246894 F F SC-SS0013-GS 58114 Standard Assembly Unbuild 21 7/25/2024 7/25/2024 12:00:00 AM 28246894 Miami 1 F 12/31/9999 12:00:00 AM 1/1/1970 12:00:00 AM 35 Jul 2024 132 7/25/2024 12:00:00 AM F 1503.00 3.000000 3 ASSYUS18 Spa World Corporation 1 F UNBUILD18 F assemblyunbuild T F AVG 7/25/2024 4:19 pm 2 Unbuild EFFECTIVE_DATE e=T&id=28246894 T T T LOH_STRICT_VALIDATION_INVENTORY_NOT_AVAIL F F 0 F F F T 12/31/9999 1/1/1970 Assembly Unbuild 3.000000 3 F 7/25/2024 T 0 7 T unbuild 1 F 7/25/2024 4:19 pm
Page 1