Table: inventoryadjustment_inventory

AutoId INVENTORYADJUSTMENT_InternalId custcol_sw_reason_code labelcurrency unitcost exchangerate line description memo unitconversionrate units units_display class_display currentvalue sys_id isserial binitem inventorydetailreq labelfxunitcost custcol_fin_dept invtdiffvalue locationusesbins item_display currency department class newquantity quantityonhand item costingmethod unitcostoverridden label department_display location_display foreigncurrencyunitcost displayname location adjustqtyby inventorydetailavail adjustqtybytype avgunitcost isnumbered
1 17274697 0.00 1 1 Soho 3060: LEFT: White: Soaker 1 0.00 12241670241340763 T T T Distribution 0.00 T 3060-SohoSOAKER LEFT 0 -1 52034 AVG F Miami 1 1 T MOH_STRICT_VALIDATION 66.98 T
2 17303383 56.99 1 1 36" x 36" Double Threshold Shower Base - White - Titan Series SB-AZ009WC - ANZZI 1 3 EAs SHOWER : Shower Bases : Double Threshold -0.01 12241673468635929 F T T Distribution 1196.79 T SB-AZ009WC 1034 17 0 8794 AVG F Miami SB-AZ009WC 1 21 T MOH_STRICT_VALIDATION 53.80 F
3 17303383 56.99 1 2 36" x 36" Double Threshold Shower Base - White - Titan Series SB-AZ009WC - ANZZI 1 3 EAs SHOWER : Shower Bases : Double Threshold -0.01 12241673468635930 F T T Distribution -227.96 T SB-AZ009WC 1034 17 0 8794 AVG F Miami SB-AZ009WC 1 -4 T LOH_NEGATIVE_QUANITY_INPUT 53.80 F
4 17304491 16.50 1 1 T1-AZ065 Toilet Tank in White 1 BATHROOM : Toilets : Toilets One Piece 132.00 12241674112601433 F T T Distribution -132.00 T T1-AZ065-00TANK 906 0 8 18454 STANDARD F Miami : Miami Returns Location T1-AZ065-00TANK 3 -8 T LOH_NEGATIVE_QUANITY_INPUT 16.50 F
5 17306934 0.00 1 1 SD-FRLS05902BN_Part_6_Outer Wheels 1 3 EAs 0.00 12241675172221003 F T T Distribution 0.00 T SD-FRLS05902BN_Part_6 0 -2 40566 AVG F Miami SD-FRLS05902BN_Part_6_Outer Wheels 1 2 T MOH_STRICT_VALIDATION 0.00 F
6 17306934 0.00 1 2 SD-FRLS05901MB_Part_13_Wall Bracket (L&R) 1 3 EAs 0.00 12241675172221004 F T T Distribution 0.00 T SD-FRLS05901MB_Part_13 0 -1 51325 AVG F Miami SD-FRLS05901MB_Part_13_Wall Bracket (L&R) 1 1 T MOH_STRICT_VALIDATION 0.00 F
7 17306934 0.00 1 3 SD-AZ09-01MB_Part 4_Hinge 1 3 EAs PARTS : Shower Door 0.00 12241675172221005 F T T Distribution 0.00 T SD-AZ09-01MB_Part_ 4 1244 2 0 45207 AVG F Miami SD-AZ09-01MB_Part 4_Hinge 1 2 T MOH_STRICT_VALIDATION 0.00 F
8 17306934 0.00 1 4 SD-AZ09-01MB_Part_2_Handle ( Length 7.87") 1 3 EAs PARTS : Shower Door 0.00 12241675172221006 F T T Distribution 0.00 T SD-AZ09-01MB_Part_2 1244 1 0 46206 AVG F Miami SD-AZ09-01MB_Part_2_Handle 1 1 T MOH_STRICT_VALIDATION 10.00 F
9 17311738 44.11 1 1 ENVO Ansen 6 kW Tankless Electric Water Heater 1 88.22 12241675500874094 F T T Distribution 132.33 T WH-AZ006-M1 5 2 44016 AVG F Miami WH-AZ006-M1 1 3 T MOH_STRICT_VALIDATION 44.11 F
10 17311752 0.00 1 1 SD-AZ053-01**Part_7 Door Panel 1 3 EAs 0.00 12241675710968769 F T F Distribution 0.00 T SD-AZ053-01**Part_7 0 -1 31467 AVG F Miami SD-AZ053-01**Part_7 Door Panel 1 1 T MOH_STRICT_VALIDATION 0.00 F
11 2163041 6 512.00 1 1 SHL2853LB 1 3 EAs BATHROOM : Bathtubs : Walk-In Bathtubs : Walk-In Bathtubs Soaker 12800.00 12241676865389967 F T T -512.00 T SHL2853LB 942 24 25 1490 STANDARD F Miami SHL2853LB 1 -1 T LOH_NEGATIVE_QUANITY_INPUT 512.00 F
12 2163041 6 0.00 1 2 OB-Special 1 3 EAs 0.00 12241676865389968 T T T 0.00 T OB-Special 15 14 15282 STANDARD F Miami OB-Special 1 1 T MOH_STRICT_VALIDATION 0.00 T
13 2163298 101.18 1 1 2-Handle Freestanding Bathtub Faucet - Polished Chrome - Kros Series FS-AZ0047CH 1 3 EAs BATHROOM : Faucets : Bathtub Faucets : Bathtub Faucets Freestanding 3035.28 12241677258158306 F T T Distribution 101.18 T FS-AZ0047CH 825 31 30 8711 AVG F Miami FS-AZ0047CH 1 1 T MOH_STRICT_VALIDATION 75.53 F
14 2163960 0.00 1 1 Shower Head for 3238 faucet 1 3 EAs BATHROOM : Faucets : Bathtub Faucets : Bathtub Faucets Deck Mounted 0.00 12241677402480554 F T T 0.00 T F3238_ShowerHead 824 0 -1 1313 STANDARD F Miami F3238_ShowerHead 1 1 T MOH_STRICT_VALIDATION 24.75 F
15 2164165 0.00 1 1 F3238_Showerhead Escutcheon 1 3 EAs PARTS 0.00 12241677540184630 F T T 0.00 T F3238_Showerhead Escutcheon 1041 0 -1 15544 STANDARD F Miami F3238_Showerhead Escutcheon 1 1 T MOH_STRICT_VALIDATION 5.00 F
16 2164165 0.00 1 2 F3238- Chrome Tub Filler 1 3 EAs BATHROOM : Faucets : Bathtub Faucets : Bathtub Faucets Deck Mounted 0.00 12241677540184631 F T T 0.00 T F3238_Chrome Filler 824 0 -1 1311 STANDARD F Miami F3238_Chrome Filler 1 1 T MOH_STRICT_VALIDATION 8.25 F
17 2164212 0.00 1 1 2.5 in x 5 in Melt Blown Sediment Filter 10 Micron 1 3 EAs SHOWER : Sauna Hardware : Filter 0.00 12241677866079807 F T T Distribution 0.00 T G-STEAMFILT-Car 1032 168 162 18445 STANDARD F Miami Filter Cartridges 1 6 T MOH_STRICT_VALIDATION 7.00 F
18 2164213 6 0.00 1 1 OB-Special 1 3 EAs 0.00 12241678036903854 T T T 0.00 T OB-Special 15 16 15282 STANDARD F Miami OB-Special 1 -1 T LOH_NEGATIVE_QUANITY_INPUT 0.00 T
19 2164213 512.00 1 2 SHL2853RB 1 3 EAs BATHROOM : Bathtubs : Walk-In Bathtubs : Walk-In Bathtubs Soaker 26624.00 12241678036903855 F T T 512.00 T SHL2853RB 942 53 52 1492 STANDARD F Miami SHL2853RB 1 1 T MOH_STRICT_VALIDATION 512.00 F
20 2164352 44.31 1 1 7-Bar Wall Mounted Towel Warmer - Brushed Nickel - Gown TW-AZ027BN - ANZZI 1 3 EAs BATHROOM : Towel Warmers : Towel Warmers Wall Mounted 1963.61 12241678228844209 F T T Distribution 664.65 T TW-AZ027BN 914 54 39 8866 AVG F Miami TW-AZ027BN 1 15 T MOH_STRICT_VALIDATION 78.18 F
21 2164352 81.52 1 2 7-Bar Wall Mounted Towel Warmer - Oil Rubbed Bronze - Gown TW-AZ027ORB - ANZZI 1 3 EAs BATHROOM : Towel Warmers : Towel Warmers Wall Mounted 164.64 12241678228844210 F T T Distribution 815.20 T TW-AZ027ORB 914 12 2 9480 AVG F Miami TW-AZ027ORB 1 10 T MOH_STRICT_VALIDATION 84.24 F
22 2164352 48.17 1 3 6-Bar Floor Mounted Towel Warmer - Polished Chrome - Riposte TW-AZ102CH - ANZZI 1 3 EAs BATHROOM : Towel Warmers : Towel Warmers Floor Mounted 4220.44 12241678228844211 F T T Distribution 433.53 T TW-AZ102CH 913 78 69 8824 AVG F Miami TW-AZ102CH 1 9 T MOH_STRICT_VALIDATION 81.21 F
23 2164359 23.70 1 1 Tempered Glass Vessel Sink - Lustrous Blue - Clavier Series LS-AZ027 - ANZZI 1 3 EAs BATHROOM : Sinks : Vessel : Vessel Tempered Glass 213.30 12241678389670021 F T T Distribution 284.40 T LS-AZ027 938 21 9 1844 STANDARD F Miami LS-AZ027 1 12 T MOH_STRICT_VALIDATION 16.14 F
24 2165625 0.00 1 1 Basket Strainer for K-AZ262 1 3 EAs KITCHEN : Kitchen Sinks : Kitchen Sinks Under Mount 0.00 12241679945647539 F T T Distribution 0.00 T K-AZ262_BasketStrainer 871 2 0 15659 STANDARD F Miami K-AZ262_BasketStrainer 1 2 T MOH_STRICT_VALIDATION 15.00 F
25 2165629 0.00 1 1 L-AZ006ORB-ColdWater 1 3 EAs PARTS 0.00 12241680090560317 F T T Distribution 0.00 T L-AZ006ORB-ColdWaterValve 1041 2 1 23087 AVG F Miami L-AZ006ORB-ColdWaterValve 1 1 T MOH_STRICT_VALIDATION 15.00 F
26 2165630 0.00 1 1 L-AZ015_PART7_WATERVALVEASSEMBLY 1 3 EAs 0.00 12241680229919370 F T T Distribution 0.00 T L-AZ015_PT7_WATERVALVEASSEMBLY 1 0 18439 STANDARD F Miami L-AZ015_PT7_WATERVALVEASSEMBLY 1 1 T MOH_STRICT_VALIDATION 0.00 F
27 2165632 0.00 1 1 L-AZ015_PART7_WATERVALVEASSEMBLY 1 3 EAs 0.00 12241680375635019 F T T Distribution 0.00 T L-AZ015_PT7_WATERVALVEASSEMBLY 1 0 18439 STANDARD F Miami L-AZ015_PT7_WATERVALVEASSEMBLY 1 1 T MOH_STRICT_VALIDATION 0.00 F
28 2165639 0.00 1 1 L-AZ015_PART7_WATERVALVEASSEMBLY 1 3 EAs 0.00 12241680514414353 F T T Distribution 0.00 T L-AZ015_PT7_WATERVALVEASSEMBLY 1 0 18439 STANDARD F Miami L-AZ015_PT7_WATERVALVEASSEMBLY 1 1 T MOH_STRICT_VALIDATION 0.00 F
29 2165984 0.00 1 1 2.5 in x 5 in Melt Blown Sediment Filter 10 Micron 1 3 EAs SHOWER : Sauna Hardware : Filter 0.00 12241680834110060 F T T Distribution 0.00 T G-STEAMFILT-Car 1032 168 167 18445 STANDARD F Miami Filter Cartridges 1 1 T MOH_STRICT_VALIDATION 7.00 F
30 2165991 0.00 1 1 L-AZ006ORB-ColdWater 1 3 EAs PARTS 0.00 12241681087150818 F T T Distribution 0.00 T L-AZ006ORB-ColdWaterValve 1041 2 0 23087 AVG F Miami L-AZ006ORB-ColdWaterValve 1 2 T MOH_STRICT_VALIDATION 15.00 F
31 2165991 0.00 1 2 Basket Strainer for K-AZ262 1 3 EAs KITCHEN : Kitchen Sinks : Kitchen Sinks Under Mount 0.00 12241681087150819 F T T Distribution 0.00 T K-AZ262_BasketStrainer 871 2 0 15659 STANDARD F Miami K-AZ262_BasketStrainer 1 2 T MOH_STRICT_VALIDATION 15.00 F
32 2170774 15.00 1 1 Drain and Overflow 42 inch For Aquatica/Embrace (3471A) 1 3 EAs BATHROOM : Bathroom Hardware : Drain 150.00 12241681269257306 F T T Distribution 5670.00 T 42DrainOverflowAquatica-CH 835 388 10 987 STANDARD F Miami Drain and Overflow 42 inch For Aquatica/Embrace (3471A) 1 378 T MOH_STRICT_VALIDATION 15.00 F
33 2170878 34.43 1 1 Tempered Glass Vessel Sink - Blue - Cobalt Series LS-AZ035 - ANZZI 1 3 EAs BATHROOM : Sinks : Vessel : Vessel Tempered Glass 585.30 12241681429109593 F T T Distribution 68.86 T LS-AZ035 938 19 17 8903 AVG F Miami LS-AZ035 1 2 T MOH_STRICT_VALIDATION 25.97 F
34 2170878 0.00 1 2 freestanding faucet 1 3 EAs BATHROOM : Faucets : Bathtub Faucets : Bathtub Faucets Freestanding 0.00 12241681429109594 F T T Distribution 0.00 T FS-AZ0047BN 825 8 7 15741 STANDARD F Miami FS-AZ0047BN 1 1 T MOH_STRICT_VALIDATION 122.20 F
35 2171479 6 0.00 1 1 OB-Special 1 3 EAs 0.00 12241681602337227 T T T 0.00 T OB-Special 16 15 15282 STANDARD F Miami OB-Special 1 1 T MOH_STRICT_VALIDATION 0.00 T
36 2172945 16.66 1 1 4-Bar Wall Mounted Towel Warmer - Brushed Nickel - Glow TW-AZ018BN - ANZZI 1 3 EAs BATHROOM : Towel Warmers : Towel Warmers Wall Mounted 4746.28 12241681808135301 F T T Distribution 116.62 T TW-AZ018BN 914 172 165 8862 AVG F Miami TW-AZ018BN 1 7 T MOH_STRICT_VALIDATION 58.64 F
37 2172945 59.54 1 2 4-Bar Wall Mounted Towel Warmer - Oil Rubbed Bronze - Glow TW-AZ018ORB - ANZZI 1 3 EAs BATHROOM : Towel Warmers : Towel Warmers Wall Mounted 774.02 12241681808135302 F T T Distribution 238.16 T TW-AZ018ORB 914 17 13 9221 AVG F Miami TW-AZ018ORB 1 4 T MOH_STRICT_VALIDATION 59.54 F
38 2173063 0.00 1 1 2.5 in x 5 in Melt Blown Sediment Filter 10 Micron 1 3 EAs SHOWER : Sauna Hardware : Filter 0.00 12241682145702744 F T T Distribution 0.00 T G-STEAMFILT-Car 1032 205 164 18445 STANDARD F Miami Filter Cartridges 1 -9 T LOH_NEGATIVE_QUANITY_INPUT 7.00 F
39 2173063 0.00 1 2 2.5 in x 5 in Melt Blown Sediment Filter 10 Micron 1 3 EAs SHOWER : Sauna Hardware : Filter 0.00 12241682145702745 F T T Distribution 0.00 T G-STEAMFILT-Car 1032 205 164 18445 STANDARD F Miami Filter Cartridges 1 50 T MOH_STRICT_VALIDATION 7.00 F
40 2173063 0.00 1 3 Housing, Standard Clear 1/4"NPT 05" x 2.5" 1 0.00 12241682145702746 F T T Distribution 0.00 T 3-25SHC0514 63 13 22098 STANDARD F Miami 3-25SHC0514 Stemspa Housing, Standard Clear 1/4"NPT 05" x 2.5" 1 50 T MOH_STRICT_VALIDATION 5.32 F
41 2173514 29.50 1 1 7-Bar Wall Mounted Towel Warmer - Polished Chrome - Gown TW-AZ027CH - ANZZI 1 3 EAs BATHROOM : Towel Warmers : Towel Warmers Wall Mounted 1622.34 12241682364390274 F T T Distribution 118.00 T TW-AZ027CH 914 59 55 8867 AVG F Miami TW-AZ027CH 1 4 T MOH_STRICT_VALIDATION 82.28 F
42 2173514 38.26 1 2 6-Bar Wall Mounted Towel Warmer - Polished Chrome - Starling Series TW-AZ025CH - 1 3 EAs BATHROOM : Towel Warmers : Towel Warmers Wall Mounted 3318.16 12241682364390275 F T T Distribution 382.60 T TW-AZ025CH 914 87 77 9133 AVG F Miami TW-AZ025CH 1 10 T MOH_STRICT_VALIDATION 59.10 F
43 2174442 5 1.00 1 1 Test 1 3 EAs 1.00 12241682517432636 F T T Distribution 10.00 T Test-1 11 1 1630 STANDARD F Miami Test-1 1 10 T MOH_STRICT_VALIDATION 1.00 F
44 2181910 0.00 1 1 freestanding faucet 1 3 EAs BATHROOM : Faucets : Bathtub Faucets : Bathtub Faucets Freestanding 0.00 12241683686472445 F T T Distribution 0.00 T FS-AZ0047BN 825 13 8 15741 STANDARD F Miami FS-AZ0047BN 1 5 T MOH_STRICT_VALIDATION 122.20 F
45 2181910 102.44 1 2 2-Handle Freestanding Bathtub Faucet - Polished Chrome - Kros Series FS-AZ0047CH 1 3 EAs BATHROOM : Faucets : Bathtub Faucets : Bathtub Faucets Freestanding 13112.66 12241683686472446 F T T Distribution 102.44 T FS-AZ0047CH 825 129 128 8711 AVG F Miami FS-AZ0047CH 1 1 T MOH_STRICT_VALIDATION 75.53 F
46 2182309 0.00 1 1 69" Flat Bottom Acrylic Freestanding Bathtub - Locket Gold - Queen Series FT-AZ5 1 3 EAs BATHROOM : Bathtubs : Freestanding Bathtubs : One Piece : One Piece Acrylic 0.00 12241683836924500 F T T Distribution 0.00 T FT-AZ537 875 0 1 9065 AVG F Miami FT-AZ537 1 -1 T LOH_NEGATIVE_QUANITY_INPUT 689.00 F
47 2186226 6.90416667 1 1 Ceramic Vessel Sink - Glossy White - Vitruvius Series LS-AZ116 - ANZZI 1 3 EAs BATHROOM : Sinks : Vessel : Vessel Ceramic 1477.49 12241685397441851 F T T Distribution -414.25 T LS-AZ116 933 154 214 9075 AVG F Miami LS-AZ116 1 -60 T LOH_NEGATIVE_QUANITY_INPUT 28.50 F
48 2186226 5.172 1 2 Ceramic Vessel Sink - Glossy White - Vitruvius Series LS-AZ129 - ANZZI 1 3 EAs BATHROOM : Sinks : Vessel : Vessel Ceramic 377.55 12241685397441852 F T T Distribution -155.16 T LS-AZ129 933 43 73 9074 AVG F Miami LS-AZ129 1 -30 T LOH_NEGATIVE_QUANITY_INPUT 11.04 F
49 2191141 0.00 1 1 MT-BLACKFEET 1 3 EAs PARTS 0.00 12241685561622601 F T T Distribution 0.00 T MT-BLACKFEET 1041 0 -3 23163 AVG F Miami MT-BLACKFEET 1 3 T MOH_STRICT_VALIDATION 2.00 F
50 2191145 0.00 1 1 SCREWS TO HOLD ON END CAP Color White 1 3 EAs PARTS 0.00 12241686976541747 F T T Distribution 0.00 T WI_ENDCAP_SCREW (White) 1041 0 -1 23214 AVG F Miami WI_ENDCAP_SCREW (White) 1 1 T MOH_STRICT_VALIDATION 2.50 F
Page 1 Next