LS3471AW

General

Classclass

BATHROOM : Bathtubs : Freestanding Bathtubs : Two Piece : Two Piece Whirlpool

Createdcreateddate

1/23/2019 12:54 pm

Display namedisplayname

LS3471AW

Inactiveisinactive

No

Includechildrenincludechildren

Yes

Item name / numberitemid

LS3471AW

Item typeitemtype

Assembly

Last modifiedlastmodifieddate

5/27/2024 12:46 pm

Subsidiarysubsidiary

Spa World Corporation

Typetype

item

Departmentdepartment

—

Featureddescriptionfeatureddescription

—

Parentparent

—

Storedescriptionstoredescription

—

Storedetaileddescriptionstoredetaileddescription

—

UPCupccode

—

Inventory & stock

Autoleadtimeautoleadtime

No

Autopreferredstocklevelautopreferredstocklevel

No

Autoreorderpointautoreorderpoint

No

Baseunitbaseunit

EA

Binmapchangebinmapchange

No

Calculatedweightcalculatedweight

28.38

Consumptionunitconsumptionunit

Eaches

Islotitemislotitem

No

Isserialitemisserialitem

No

Maximumquantityunitsmaximumquantityunits

EAs

Minimumquantityminimumquantity

1

Minimumquantityunitsminimumquantityunits

EAs

Origbinactiveorigbinactive

No

Originalusebinsoriginalusebins

Yes

Overallquantitypricingtypeoverallquantitypricingtype

By Line Quantity

Purchaseunitpurchaseunit

Eaches

Quantityreorderunitsquantityreorderunits

Quantity On Hand, Reorder Point, Quantity On Order, and Quantity Committed are in EAs

Saleunitsaleunit

Eaches

Seasonaldemandseasonaldemand

No

Stock unitstockunit

Eaches

Stockdescriptionstockdescription

New

Supplyreplenishmentmethodsupplyreplenishmentmethod

Reorder Point

Total on handtotalquantityonhand

6.00

Totalquantityonhandunitstotalquantityonhandunits

EAs

Units typeunitstype

Each

Unitstypefracconvunitstypefracconv

No

Unitstypewarningdisplayedunitstypewarningdisplayed

Yes

Unitswarningdisplayedunitswarningdisplayed

No

Usebinsusebins

Yes

Weightweight

182.00

Weightconversionweightconversion

1

Weightunitweightunit

lb

Weightunitsweightunits

per EA

Alternatedemandsourceitemalternatedemandsourceitem

—

Demandmodifierdemandmodifier

—

Hazmatitemunitshazmatitemunits

—

Hazmatitemunitsqtyhazmatitemunitsqty

—

Leadtimeleadtime

—

Locationlocation

—

Maximumquantitymaximumquantity

—

Preferred stock levelpreferredstocklevel

—

Preferredlocationpreferredlocation

—

Preferredstockleveldayspreferredstockleveldays

—

Purchaseorderquantitypurchaseorderquantity

—

Purchaseorderquantitydiffpurchaseorderquantitydiff

—

Quantitypricingschedulequantitypricingschedule

—

Receiptquantityreceiptquantity

—

Receiptquantitydiffreceiptquantitydiff

—

Reorder pointreorderpoint

—

Reordermultiplereordermultiple

—

Safetystockleveldayssafetystockleveldays

—

Costing & pricing

Asset accountassetaccount

12030 Total Inventory : Finished Goods Manufacturing

Average costaveragecost

452.54

Averagecostunitsaveragecostunits

per EA

Billpricevarianceacctbillpricevarianceacct

51090 Cost of Goods Other : Purchase Price Variance

Billqtyvarianceacctbillqtyvarianceacct

51040 Cost of Goods Other : Cost of Goods Transferred Orders FBA

Cogsaccountcogsaccount

50010 Cost of Goods Sold : Cost of Goods Sold Manufacturing

Consumptionconversionrateconsumptionconversionrate

1.00

Costcost

751.73

Costcategorycostcategory

Default

Costestimatecostestimate

150.00

Costestimatetypecostestimatetype

Item Defined Cost

Costestimateunitscostestimateunits

per EA

Costing methodcostingmethod

STANDARD

Costingmethoddisplaycostingmethoddisplay

Standard

Costunitscostunits

per EA

Currencycurrency

US Dollar

Custreturnvarianceaccountcustreturnvarianceaccount

51060 Cost of Goods Other : COGS on Customer Returns

Dontshowpricedontshowprice

No

Dropshipexpenseaccountdropshipexpenseaccount

50040 Cost of Goods Sold : Cost of Goods Sold Dropship

Exchange rateexchangerate

1

Froogleproductfeedfroogleproductfeed

No

Gainlossaccountgainlossaccount

51040 Cost of Goods Other : Cost of Goods Transferred Orders FBA

Incomeaccountincomeaccount

40010 Sales Revenue : Merchandise Revenue Manufacturing

Intercocogsaccountintercocogsaccount

- Use COGS Account -

Intercoincomeaccountintercoincomeaccount

- Use Income Account -

Last purchase pricelastpurchaseprice

678.81

Lastpurchasepriceunitslastpurchasepriceunits

per EA

Origcostorigcost

751.73

Origcostunitsorigcostunits

per EA

Origexchangerateorigexchangerate

1.00

Price1headerprice1header

price1quantity

Price1headercountprice1headercount

5

Price1matrixfieldsprice1matrixfields

price

Price1quantity1price1quantity1

0.00

Price1quantity2price1quantity2

1.00

Price2headerprice2header

price2quantity

Price2headercountprice2headercount

5

Price2matrixfieldsprice2matrixfields

price

Price2quantity1price2quantity1

0.00

Price2quantity2price2quantity2

1.00

Price3headerprice3header

price3quantity

Price3headercountprice3headercount

5

Price3matrixfieldsprice3matrixfields

price

Price3quantity1price3quantity1

0.00

Price3quantity2price3quantity2

1.00

Price4headerprice4header

price4quantity

Price4headercountprice4headercount

5

Price4matrixfieldsprice4matrixfields

price

Price4quantity1price4quantity1

0.00

Price4quantity2price4quantity2

1.00

Prodpricevarianceacctprodpricevarianceacct

51080 Cost of Goods Other : Production Price Variance

Prodqtyvarianceacctprodqtyvarianceacct

51070 Cost of Goods Other : Production Quantity Variance

Purchaseconversionratepurchaseconversionrate

1.00

Purchasepricevarianceacctpurchasepricevarianceacct

51090 Cost of Goods Other : Purchase Price Variance

Saleconversionratesaleconversionrate

1.00

Stockconversionratestockconversionrate

1.00

Taxscheduletaxschedule

Taxable

Total valuetotalvalue

2,715.23

Tracklandedcosttracklandedcost

No

Transferpriceunitstransferpriceunits

per EA

Unbuildvarianceaccountunbuildvarianceaccount

51130 Cost of Goods Other : Unbuild Variance Account

Usemarginalratesusemarginalrates

No

Vendreturnvarianceaccountvendreturnvarianceaccount

51050 Cost of Goods Other : VENDOR RETURN VARIANCE

Base pricebaseprice

—

Billexchratevarianceacctbillexchratevarianceacct

—

Expenseaccounthiddenexpenseaccounthidden

—

Nopricemessagenopricemessage

—

Onlinepriceonlineprice

—

Pricelevel1pricelevel1

—

Pricelevel10pricelevel10

—

Pricelevel11pricelevel11

—

Pricelevel12pricelevel12

—

Pricelevel13pricelevel13

—

Pricelevel14pricelevel14

—

Pricelevel15pricelevel15

—

Pricelevel16pricelevel16

—

Pricelevel2pricelevel2

—

Pricelevel3pricelevel3

—

Pricelevel4pricelevel4

—

Pricelevel5pricelevel5

—

Pricelevel6pricelevel6

—

Pricelevel7pricelevel7

—

Pricelevel8pricelevel8

—

Pricelevel9pricelevel9

—

Transferpricetransferprice

—

Wipvarianceacctwipvarianceacct

—

Sales & purchasing

Copydescriptioncopydescription

No

Descriptiondescription

Aquatica 3471: VShaped-Jets: CenterPumpRight: White: Hydro: Friction Heater: PneumaticControl: Color Match Trim

Isdropshipitemisdropshipitem

No

Isspecialorderitemisspecialorderitem

No

Isspecialworkorderitemisspecialworkorderitem

Yes

Purchasedescriptionpurchasedescription

Aquatica 3471: VShaped-Jets: CenterPumpRight: White: Hydro: Friction Heater: PneumaticControl: Color Match Trim

Vendormapchangevendormapchange

No

Hazmatshippingnamehazmatshippingname

—

Manufacturermanufacturer

—

Mpnmpn

—

Purchaseorderamountpurchaseorderamount

—

Relateditemsdescriptionrelateditemsdescription

—

Storedisplayimagestoredisplayimage

—

Storedisplaynamestoredisplayname

—

StoreDisplayNameOrigstoreDisplayNameOrig

—

Storedisplaythumbnailstoredisplaythumbnail

—

Vendor namevendorname

—

Vendormapcodechangevendormapcodechange

—

Dates

Custom first salecustitem_custom_first_sale_dt

—

Discontinue date itemcustitem_discontinue_date_item_dt

—

Ebay end datecustitem_ebay_end_date

—

Ebay start datecustitem_ebay_start_date

—

Last stock ck datecustitem_last_stock_ck_date_dt

—

Oos datecustitem_oos_date_dt

—

Temp item fixcustitem_temp_item_fix_dt

—

Wrm item warrantyexpirescustitem_wrm_item_warrantyexpires_dt

—

Custom fields

22custitem22

No

23custitem23

No

25custitem25

No

28custitem28

No

Ab1593custitem_ab1593

No

Amazon feed itemcustitem_amazon_feed_item

No

Ashley furniture feedcustitem_ashley_furniture_feed

No

Atlas approvedcustitem_atlas_approved

No

Atlas engineer completecustitem_atlas_engineer_complete

No

Atlas finance completecustitem_atlas_finance_complete

No

Atlas sales completecustitem_atlas_sales_complete

No

Avg daily revcustitem_avg_daily_rev

146.97

Avg qty sld 12custitem_avg_qty_sld_12

0

Bbb feed itemcustitem_bbb_feed_item

No

Bjs feed itemcustitem_bjs_feed_item

No

Bom laborcustitem_bom_labor

350.00

Bom updated itemcustitem_bom_updated_item

Yes

Brnd itemcustitem_brnd_item

ENDURANCE

Build feed itemcustitem_build_feed_item

No

Build qty availcustitem_build_qty_avail

124

Cat mgr itemcustitem_cat_mgr_item

Yes

Cat1custitem_cat1

No

Cat2custitem_cat2

No

Category itemcustitem_category_item

Drop-in Tub

Category mhcustitem_category_mh

Free Standing Tub

Certification mass apcustitem_certification_mass_ap

No

Certification prop65custitem_certification_prop65

No

Color finish mhcustitem_color_finish_mh

White

Core itmcustitem_core_itm

SHL3471A

Costco feed itemcustitem_costco_feed_item

No

Cupccustitem_cupc

No

Dims ver itemcustitem_dims_ver_item

No

Discontinuedcustitem_discontinued

No

Discounted do not purchasecustitem_discounted_do_not_purchase

No

Drain placementcustitem_drain_placement

Right

Ebay best offer enabledcustitem_ebay_best_offer_enabled

No

Ebay bold titlecustitem_ebay_bold_title

No

Ebay custom handling timecustitem_ebay_custom_handling_time

No

Ebay gallery pluscustitem_ebay_gallery_plus

No

Ebay get it fastcustitem_ebay_get_it_fast

No

Ebay itemcustitem_ebay_item

No

Ebay item exportedcustitem_ebay_item_exported

No

Ebay item vintagecustitem_ebay_item_vintage

No

Ebay photo displaycustitem_ebay_photo_display

No

Ebay use handling for instockcustitem_ebay_use_handling_for_instock

No

Exclusive customer namecustitem_exclusive_customer_name

Lowes

Feed inv itemcustitem_feed_inv_item

100

Finish cost itemcustitem_finish_cost_item

500.00

Ful chan itemcustitem_ful_chan_item

PRODUCTION

Guest orderable itemcustitem_guest_orderable_item

No

Hd cn feed itemcustitem_hd_cn_feed_item

No

Hd exclusivecustitem_hd_exclusive

Yes

Hd feed itemcustitem_hd_feed_item

No

Homemart feed itemcustitem_homemart_feed_item

No

Homemartbath com feedcustitem_homemartbath_com_feed

No

Houzz feed itemcustitem_houzz_feed_item

No

Import freight miacustitem_import_freight_mia

40.00

Item export to shopifycustitem_item_export_to_shopify

No

Item export to shopify anzzicustitem_item_export_to_shopify_anzzi

No

Item export to shopify1custitem_item_export_to_shopify1

No

Item export walmartcustitem_item_export_walmart

No

Item field divisioncustitemitem_field_division

Bathroom

Item for resale customcustitem_item_for_resale_custom

Yes

Item relisted in ebaycustitem_item_relisted_in_ebay

No

Item sea jennycustitem_item_sea_jenny

No

Item type mhcustitem_item_type_mh

Drop-in

Item warranty termcustitem_item_warranty_term

10 Year Shell Defect \ 1 Year Parts \ 90 Day Labor

Landed cost allcustitem_landed_cost_all

801.84

Landed cost assembly kitcustitem_landed_cost_assembly_kit

150.00

Leadfreecustitem_leadfree

No

Leo skucustitem_leo_sku

No

Lowes feed itemcustitem_lowes_feed_item

Yes

Lucy skucustitem_lucy_sku

No

Madetoordertubs qty50custitem_madetoordertubs_qty50

No

Manny skucustitem_manny_sku

No

Mch upcustitem_mch_up

No

Mchscl category itemcustitem_mchscl_category_item

Manufactured Tub

Meditub inventoryitemcustitem_meditub_inventoryitem_

No

Menards feed itemcustitem_menards_feed_item

No

Model number itemcustitem_model_number_item

3471AW

Nick skucustitem_nick_sku

No

Nsfcustitem_nsf

No

Out of stock days itemcustitem_out_of_stock_days_item

0

Overstock feed itemcustitem_overstock_feed_item

No

Pacejet commodity namecustitem_pacejet_commodity_name

BT300

Pacejet item autopackcustitem_pacejet_item_autopack

No

Pacejet item heightcustitem_pacejet_item_height

31

Pacejet item lengthcustitem_pacejet_item_length

76

Pacejet item widthcustitem_pacejet_item_width

46

Palletized dims itemcustitem_palletized_dims_item

Yes

Perc for commissioncustitem_perc_for_commission

1.00

Peter skucustitem_peter_sku

No

Priya skucustitem_priya_sku

No

Product materialcustitem_product_material

Acrylic

Product shapecustitem_product_shape

Rectangle

Product sizecustitem_product_size

34"x71"

Product therapy typecustitem_product_therapy_type

Hydro

Qty available miacustitem_qty_available_mia

4

Qty ret itemcustitem_qty_ret_item

0

Qty sld last 30 dayscustitem_qty_sld_last_30_days

0

Qty sld mtdcustitem_qty_sld_mtd

1

Qty sold 12 mthscustitemqty_sold_12_mths

0

Salsifycustitem_salsify_

No

Send item houzzcustitem_send_item_houzz

No

Sendtoebaycustitem_sendtoebay

No

Shipping lead timecustitem_shipping_lead_time

5

Ships ltlcustitem_ships_ltl

Yes

Shop anzzi itemcustitem_shop_anzzi_item

No

Ssd feed itemcustitem_ssd_feed_item

No

Stock itemcustitem_stock_item

No

Style mhcustitem_style_mh

N/A

Sub categorycustitemsub_category

Hydro

Sw inventory feed itemcustitem_sw_inventory_feed_item

No

Sw priority itemcustitem_sw_priority_item

No

Thermoforming itemcustitem_thermoforming_item

Yes

Tub shellcustitem_tub_shell

FTS3471: Aquatica

Unitcustitem_unit

Finished Good

Upsell holdcustitem_upsell_hold

No

Walmart feed itemcustitem_walmart_feed_item

No

Walmart itemcustitem_walmart_item

No

Watchlistcustitem_watchlist

Yes

Watersensecustitemwatersense

No

Wayfair drop tupecustitem_wayfair_drop_tupe

No

Wayfair feed itemcustitem_wayfair_feed_item

No

Wms usetallyscancustitem_wms_usetallyscan

No

Wmsse mix itemcustitem_wmsse_mix_item

Yes

Wmsse mix lotcustitem_wmsse_mix_lot

Yes

Wrm item trackwarrantycustitem_wrm_item_trackwarranty

No

Zoro feed itemcustitem_zoro_feed_item

No

2custitem2

—

26custitem26

—

Amz main imagecustitem_amz_main_image

—

Amz sub image1custitem_amz_sub_image1

—

Amz sub image2custitem_amz_sub_image2

—

Amz sub image3custitem_amz_sub_image3

—

Atlas engineer complete bycustitem_atlas_engineer_complete_by

—

Atlas finance assignedcustitem_atlas_finance_assigned

—

Atlas item imagecustitem_atlas_item_image

—

Atlas item plannercustitem_atlas_item_planner

—

Atlas sales assignedcustitem_atlas_sales_assigned

—

Atlas wo att1custitem_atlas_wo_att1

—

Atlas wo att2custitem_atlas_wo_att2

—

Atlas wo att3custitem_atlas_wo_att3

—

Average invoiceamountcustitem_average_invoiceamount

—

Brandcustitem_brand

—

Buildcom leadtimecustitem_buildcom_leadtime

—

Commodity codecustitem_commodity_code

—

Customdutycustitem_customduty

—

Custompickpackmiacustitem_custompickpackmia

—

Discontinued reasoncustitem_discontinued_reason

—

Domestic handiling costcustitem_domestic_handiling_cost

—

Ebay error msgcustitem_ebay_error_msg

—

Ebay handling timecustitem_ebay_handling_time

—

Ebay inventory feed quantitycustitem_ebay_inventory_feed_quantity

—

Ebay item brandcustitem_ebay_item_brand

—

Ebay item categorycustitem_ebay_item_category

—

Ebay item category2custitem_ebay_item_category2

—

Ebay item conditioncustitem_ebay_item_condition

—

Ebay item condition descriptcustitem_ebay_item_condition_descript

—

Ebay item descriptioncustitem_ebay_item_description

—

Ebay listing durationcustitem_ebay_listing_duration

—

Ebay listing linkcustitem_ebay_listing_link

—

Ebay parent imagecustitem_ebay_parent_image

—

Ebay skucustitem_ebay_sku

—

Ebay store category1custitem_ebay_store_category1

—

Ebay store category2custitem_ebay_store_category2

—

Ebay titlecustitem_ebay_title

—

Ebay variation item img1custitem_ebay_variation_item_img1

—

Ebay variation item img2custitem_ebay_variation_item_img2

—

Ebay variation item img3custitem_ebay_variation_item_img3

—

Ebay variationscustitem_ebay_variations

—

Ebayitemid 2custitem_ebayitemid_2

—

Fba feecustitem_fba_fee

—

Gtincustitem_gtin

—

Hd cn omsid itemcustitem_hd_cn_omsid_item

—

Hd description itemcustitem_hd_description_item

—

Hj tc autopackquantitycustitem_hj_tc_autopackquantity

—

Houz item idcustitem_houz_item_id

—

Houzz item descriptioncustitem_houzz_item_description

—

Houzz leadtime mincustitem_houzz_leadtime_min

—

Houzz maxcustitem_houzz_max

—

Houzz mincustitem_houzz_min

—

Houzz prod idcustitem_houzz_prod_id

—

Hts code tariffcustitem_hts_code_tariff

—

Hts2 itemcustitem_hts2_item

—

International handling costcustitem_international_handling_cost

—

Inventory item idcustitem_inventory_item_id

—

Inventory item id anzzicustitem_inventory_item_id_anzzi

—

Inventory item id1custitem_inventory_item_id1

—

Inventory item id2custitem_inventory_item_id2

—

Inventory item id3custitem_inventory_item_id3

—

Inventory item id4custitem_inventory_item_id4

—

Item desc tmpl ebaycustitem_item_desc_tmpl_ebay

—

Item disco notescustitem_item_disco_notes

—

Item landing costcustitem_item_landing_cost

—

Length mmcustitem_length_mm

—

Lowes numcustitem_lowes_num

—

Made to ordercustitem_made_to_order

—

Manuf lead timecustitem_manuf_lead_time

—

Manuf ship timecustitem_manuf_ship_time

—

Mapcustitem_map

—

Maysamm prepaid discountcustitem_maysamm_prepaid_discount

—

Menard ship codecustitem_menard_ship_code

—

Menards sku itemcustitem_menards_sku_item

—

Msrpcustitem_msrp

—

Mysamm am cat mkt sharecustitem_mysamm_am_cat_mkt_share

—

Mysamm am primary catcustitem_mysamm_am_primary_cat

—

Mysamm am rankcustitem_mysamm_am_rank

—

Mysamm am reviews avgcustitem_mysamm_am_reviews_avg

—

Mysamm am reviews countcustitem_mysamm_am_reviews_count

—

Mysamm cat statuscustitem_mysamm_cat_status

—

Mysamm collect discountcustitem_mysamm_collect_discount

—

Mysamm flash sale discountcustitem_mysamm_flash_sale_discount

—

Mysamm hd cat mkt sharecustitem_mysamm_hd_cat_mkt_share

—

Mysamm hd primary catcustitem_mysamm_hd_primary_cat

—

Mysamm hd rankcustitem_mysamm_hd_rank

—

Mysamm hd reviews avgcustitem_mysamm_hd_reviews_avg

—

Mysamm hd reviews countcustitem_mysamm_hd_reviews_count

—

Mysamm lowes cat mkt sharecustitem_mysamm_lowes_cat_mkt_share

—

Mysamm lowes primary catcustitem_mysamm_lowes_primary_cat

—

Mysamm lowes rankcustitem_mysamm_lowes_rank

—

Mysamm lowes reviews avgcustitem_mysamm_lowes_reviews_avg

—

Mysamm lowes reviews countcustitem_mysamm_lowes_reviews_count

—

Mysamm walmart cat mkt sharecustitem_mysamm_walmart_cat_mkt_share

—

Mysamm walmart primary catcustitem_mysamm_walmart_primary_cat

—

Mysamm walmart rankcustitem_mysamm_walmart_rank

—

Mysamm walmart reviews avgcustitem_mysamm_walmart_reviews_avg

—

Mysamm walmart reviews countcustitem_mysamm_walmart_reviews_count

—

Mysamm wayfair cat mkt sharecustitem_mysamm_wayfair_cat_mkt_share

—

Mysamm wayfair primary catcustitem_mysamm_wayfair_primary_cat

—

Mysamm wayfair rankcustitem_mysamm_wayfair_rank

—

Mysamm wayfair reviews avgcustitem_mysamm_wayfair_reviews_avg

—

Mysamm wayfair reviews countcustitem_mysamm_wayfair_reviews_count

—

Mysamm wholesale discountcustitem_mysamm_wholesale_discount

—

Nature of transaction codescustitem_nature_of_transaction_codes

—

Ns ebay skucustitem_ns_ebay_sku

—

Ns os item skucustitem_ns_os_item_sku

—

Nsts ep item categorycustitem_nsts_ep_item_category

—

Number of months o hcustitem_number_of_months_o_h

—

Number of months o ocustitem_number_of_months_o_o

—

Omsidcustitem_omsid

—

Overstock idcustitem_overstock_id

—

Pacejet producer numbercustitem_pacejet_producer_number

—

Pacejet upc codecustitem_pacejet_upc_code

—

Product imagecustitem_product_image

—

Product image linecustitem_product_image_line

—

Product labelcustitem_product_label

—

Product tax codecustitem_product_tax_code

—

Productidcustitem_productid

—

Productidtypecustitem_productidtype

—

Productsecondaryimageurlcustitem_productsecondaryimageurl

—

Promo infocustitem_promo_info

—

Qty on order miacustitem_qty_on_order_mia

—

Qty rec 4custitem_qty_rec_4

—

Qty rec f mcustitem_qty_rec_f_m

—

Qty rec fmcustitem_qty_rec_fm

—

Qty rec n mcustitem_qty_rec_n_m

—

Qty rec nmcustitem_qty_rec_nm

—

Qty rec t mcustitem_qty_rec_t_m

—

Qty rec tmcustitem_qty_rec_tm

—

Sc change temcustitem_sc_change_tem

—

Scpq item configuratorcustitem_scpq_item_configurator

—

Shopify product idcustitem_shopify_product_id

—

Shopify product id anziicustitem_shopify_product_id_anzii

—

Shopify product id1custitem_shopify_product_id1

—

Shopify product id2custitem_shopify_product_id2

—

Shopify product id3custitem_shopify_product_id3

—

Shopify product id4custitem_shopify_product_id4

—

Shopify variant idcustitem_shopify_variant_id

—

Shopify variant id anzzicustitem_shopify_variant_id_anzzi

—

Shopify variant id1custitem_shopify_variant_id1

—

Shopify variant id2custitem_shopify_variant_id2

—

Shopify variant id3custitem_shopify_variant_id3

—

Shopify variant id4custitem_shopify_variant_id4

—

Sw best replacement itemcustitem_sw_best_replacement_item

—

Sw better replacement itemcustitem_sw_better_replacement_item

—

Sw good replacement itemcustitem_sw_good_replacement_item

—

Sw upsell item 1custitem_sw_upsell_item_1

—

Sw upsell item 2custitem_sw_upsell_item_2

—

Sw upsell item 3custitem_sw_upsell_item_3

—

Variant opition1custitem_variant_opition1

—

Variant opition2custitem_variant_opition2

—

Variant opition3custitem_variant_opition3

—

Walmart brandcustitem_walmart_brand

—

Walmart categorycustitem_walmart_category

—

Walmart shortdescriptioncustitem_walmart_shortdescription

—

Walmart skucustitem_walmart_sku

—

Walmart sub categorycustitem_walmart_sub_category

—

Warehousecostmiacustitem_warehousecostmia

—

Wayfair idcustitem_wayfair_id

—

Wf part numbercustitem_wf_part_number

—

Wm mainimageurlcustitem_wm_mainimageurl

—

Wms thumbnail imagecustitem_wms_thumbnail_image

—

Wmsse abcvelocitycustitem_wmsse_abcvelocity

—

Wmsse itemfamilycustitem_wmsse_itemfamily

—

Wmsse itemgroupcustitem_wmsse_itemgroup

—

Wmsse replen maxqtycustitem_wmsse_replen_maxqty

—

Wmsse replen minqtycustitem_wmsse_replen_minqty

—

Wmsse shelflifecustitem_wmsse_shelflife

—

Wrm item repaireditemcustitem_wrm_item_repaireditem

—

Wrm item warrantytermscustitem_wrm_item_warrantyterms

—

Others

Accchangeaccchange

No

Atpmethodatpmethod

Cumulative ATP with Look Ahead

Baserecordtypebaserecordtype

assemblyitem

Bassemblychildbassemblychild

false

Buildentireassemblybuildentireassembly

No

Customformcustomform

SW - Assembly Item Form

Effectivebomcontroleffectivebomcontrol

Effective Date

Enforceminqtyinternallyenforceminqtyinternally

Yes

Excludefromsitemapexcludefromsitemap

No

Haschildrenhaschildren

No

Hasparenthasparent

No

Isdonationitemisdonationitem

No

Isgcocompliantisgcocompliant

No

Ishazmatitemishazmatitem

No

Isonlineisonline

No

Isphantomisphantom

No

Itemidorigitemidorig

LS3471AW

Itemtypenameitemtypename

Assembly/Bill of Materials

Keywordschangekeywordschange

No

Matchbilltoreceiptmatchbilltoreceipt

No

Modifiableitemidmodifiableitemid

LS3471AW

Nextagproductfeednextagproductfeed

No

Offersupportoffersupport

Yes

Printitemsprintitems

No

Rectype 1224 10000 maxnkeyrectype_1224_10000_maxnkey

676

Rectype 146 977 maxnkeyrectype_146_977_maxnkey

19

Rectype 898 7446 maxnkeyrectype_898_7446_maxnkey

1414

Roundupascomponentroundupascomponent

No

Scrapacctscrapacct

51120 Cost of Goods Other : Total Loss Inventory

Shoppingproductfeedshoppingproductfeed

No

Shopzillaproductfeedshopzillaproductfeed

No

Showdefaultdonationamountshowdefaultdonationamount

No

Templatestoredtemplatestored

No

Usecomponentyieldusecomponentyield

No

Wipacctwipacct

12020 Total Inventory : Work In Progress Manufacturing

Yahooproductfeedyahooproductfeed

No

Billingwarnbillingwarn

—

Countryofmanufacturecountryofmanufacture

—

Defaultrevisiondefaultrevision

—

Emptyempty

—

Hazmathazardclasshazmathazardclass

—

Hazmatidhazmatid

—

Hazmatpackinggrouphazmatpackinggroup

—

Itemprocessfamilyitemprocessfamily

—

Itemprocessgroupitemprocessgroup

—

Maxdonationamountmaxdonationamount

—

Metataghtmlmetataghtml

—

Nextagcategorynextagcategory

—

Origparentorigparent

—

Pricinggrouppricinggroup

—

Productfeedproductfeed

—

Receiptamountreceiptamount

—

Relateditemscategoryrelateditemscategory

—

Rotationtyperotationtype

—

Schedulebnumberschedulebnumber

—

Searchkeywordssearchkeywords

—

Shoppingdotcomcategoryshoppingdotcomcategory

—

Shopzillacategoryidshopzillacategoryid

—

Sitemapprioritysitemappriority

—

Storeitemtemplatestoreitemtemplate

—

Vendbillmatchkeyvendbillmatchkey

—

System & IDs

Assetaccount refidassetaccount_refid

227

Atpmethod refidatpmethod_refid

CUMULATIVE_ATP_WITH_LOOK_AHEAD

Baseunit refidbaseunit_refid

3

Billpricevarianceacct refidbillpricevarianceacct_refid

327

Billqtyvarianceacct refidbillqtyvarianceacct_refid

328

Brnd item refidcustitem_brnd_item_refid

2

Category item refidcustitem_category_item_refid

3

Category mh refidcustitem_category_mh_refid

14

Class refidclass_refid

922

Cogsaccount refidcogsaccount_refid

214

Color finish mh refidcustitem_color_finish_mh_refid

15

Consumptionunit refidconsumptionunit_refid

3

Costcategory refidcostcategory_refid

4

Costestimatetype refidcostestimatetype_refid

ITEMDEFINED

Currency refidcurrency_refid

1

Customform refidcustomform_refid

120

Custpage wrm item warrantyterm accesscustpage_wrm_item_warrantyterm_access

Yes

Custreturnvarianceaccount refidcustreturnvarianceaccount_refid

725

Drain placement refidcustitem_drain_placement_refid

3

Dropshipexpenseaccount refiddropshipexpenseaccount_refid

535

Effectivebomcontrol refideffectivebomcontrol_refid

EFFECTIVE_DATE

Entryformquerystringentryformquerystring

itemtype=Assembly&e=T&id=12726

Exclusive customer name refidcustitem_exclusive_customer_name_refid

2

Externalidexternalid

LS3471AW

Ful chan item refidcustitem_ful_chan_item_refid

2

Gainlossaccount refidgainlossaccount_refid

328

Idid

12726

Incomeaccount refidincomeaccount_refid

306

InternalIdInternalId

12726

Item field division refidcustitemitem_field_division_refid

1

Item type mh refidcustitem_item_type_mh_refid

31

Item warranty term refidcustitem_item_warranty_term_refid

15

Mchscl category item refidcustitem_mchscl_category_item_refid

22

Prodpricevarianceacct refidprodpricevarianceacct_refid

727

Prodqtyvarianceacct refidprodqtyvarianceacct_refid

726

Product material refidcustitem_product_material_refid

1

Product shape refidcustitem_product_shape_refid

2

Product size refidcustitem_product_size_refid

54

Product therapy type refidcustitem_product_therapy_type_refid

4

Purchasepricevarianceacct refidpurchasepricevarianceacct_refid

327

Purchaseunit refidpurchaseunit_refid

3

Saleunit refidsaleunit_refid

3

Scrapacct refidscrapacct_refid

730

Stockunit refidstockunit_refid

3

Style mh refidcustitem_style_mh_refid

34

Sub category refidcustitemsub_category_refid

34

Supplyreplenishmentmethod refidsupplyreplenishmentmethod_refid

REORDER_POINT

Taxschedule refidtaxschedule_refid

2

Unbuildvarianceaccount refidunbuildvarianceaccount_refid

740

Unit refidcustitem_unit_refid

1

Unitstype refidunitstype_refid

2

Vendreturnvarianceaccount refidvendreturnvarianceaccount_refid

724

Versionversion

157

Weightunit refidweightunit_refid

1

Wipacct refidwipacct_refid

226

Alternatedemandsourceitem refidalternatedemandsourceitem_refid

—

Amz main image refidcustitem_amz_main_image_refid

—

Amz sub image1 refidcustitem_amz_sub_image1_refid

—

Amz sub image2 refidcustitem_amz_sub_image2_refid

—

Amz sub image3 refidcustitem_amz_sub_image3_refid

—

Atlas engineer complete by refidcustitem_atlas_engineer_complete_by_refid

—

Atlas finance assigned refidcustitem_atlas_finance_assigned_refid

—

Atlas item image refidcustitem_atlas_item_image_refid

—

Atlas item planner refidcustitem_atlas_item_planner_refid

—

Atlas sales assigned refidcustitem_atlas_sales_assigned_refid

—

Atlas wo att1 refidcustitem_atlas_wo_att1_refid

—

Atlas wo att2 refidcustitem_atlas_wo_att2_refid

—

Atlas wo att3 refidcustitem_atlas_wo_att3_refid

—

Billexchratevarianceacct refidbillexchratevarianceacct_refid

—

Countryofmanufacture refidcountryofmanufacture_refid

—

Customwhencecustomwhence

—

Department refiddepartment_refid

—

Discontinued reason refidcustitem_discontinued_reason_refid

—

Ebay item category refidcustitem_ebay_item_category_refid

—

Ebay item category2 refidcustitem_ebay_item_category2_refid

—

Ebay item condition refidcustitem_ebay_item_condition_refid

—

Ebay listing duration refidcustitem_ebay_listing_duration_refid

—

Ebay parent image refidcustitem_ebay_parent_image_refid

—

Ebay store category1 refidcustitem_ebay_store_category1_refid

—

Ebay store category2 refidcustitem_ebay_store_category2_refid

—

Ebay variation item img1 refidcustitem_ebay_variation_item_img1_refid

—

Ebay variation item img2 refidcustitem_ebay_variation_item_img2_refid

—

Ebay variation item img3 refidcustitem_ebay_variation_item_img3_refid

—

Hazmatpackinggroup refidhazmatpackinggroup_refid

—

Intercocogsaccount refidintercocogsaccount_refid

—

Intercoincomeaccount refidintercoincomeaccount_refid

—

Item desc tmpl ebay refidcustitem_item_desc_tmpl_ebay_refid

—

Itemprocessfamily refiditemprocessfamily_refid

—

Itemprocessgroup refiditemprocessgroup_refid

—

Location refidlocation_refid

—

Mysamm cat status refidcustitem_mysamm_cat_status_refid

—

Nature of transaction codes refidcustitem_nature_of_transaction_codes_refid

—

Nsbrowserenvnsbrowserenv

—

Overallquantitypricingtype refidoverallquantitypricingtype_refid

—

Parent refidparent_refid

—

Preferredlocation refidpreferredlocation_refid

—

Pricinggroup refidpricinggroup_refid

—

Product label refidcustitem_product_label_refid

—

Productidtype refidcustitem_productidtype_refid

—

Quantitypricingschedule refidquantitypricingschedule_refid

—

Rotationtype refidrotationtype_refid

—

Sc change tem refidcustitem_sc_change_tem_refid

—

Scpq item configurator refidcustitem_scpq_item_configurator_refid

—

Selectedtabselectedtab

—

Sitemappriority refidsitemappriority_refid

—

Storedisplayimage refidstoredisplayimage_refid

—

Storedisplaythumbnail refidstoredisplaythumbnail_refid

—

Storeitemtemplate refidstoreitemtemplate_refid

—

Sw best replacement item refidcustitem_sw_best_replacement_item_refid

—

Sw better replacement item refidcustitem_sw_better_replacement_item_refid

—

Sw good replacement item refidcustitem_sw_good_replacement_item_refid

—

Sw upsell item 1 refidcustitem_sw_upsell_item_1_refid

—

Sw upsell item 2 refidcustitem_sw_upsell_item_2_refid

—

Sw upsell item 3 refidcustitem_sw_upsell_item_3_refid

—

Wipvarianceacct refidwipvarianceacct_refid

—

Wms thumbnail image refidcustitem_wms_thumbnail_image_refid

—

Wmsse abcvelocity refidcustitem_wmsse_abcvelocity_refid

—

Wmsse itemfamily refidcustitem_wmsse_itemfamily_refid

—

Wmsse itemgroup refidcustitem_wmsse_itemgroup_refid

—

Wrm item repaireditem refidcustitem_wrm_item_repaireditem_refid

—

Wrm item warrantyterms refidcustitem_wrm_item_warrantyterms_refid

—