IPD SC2 Screw Connector 50 Piece Jar

Product Code: SC2

Print to PDF

==== PRODUCT FIELDS START ====
Empty: (LIST)
UomList: 
IsPriceDeterminedOnWeb: True
IsBusinessCard: False
IsNew: True
BoostSourceValue: 0
MostPopularAdditionalLinkData: 
BaynoteFields: (LIST)
BNRank: 
BNReq: 
BNGuide: 
BNURL: 
BNVariant: 
BaynoteCategoryAttributes: <attribute name="CategoryCode1" value="SX09"></attribute>
<attribute name="CategoryCode2" value="SX0901"></attribute>
<attribute name="CategoryCode3" value="SX090105"></attribute>

BaynoteCategoryList: SX09,SX0901,SX090105
BaynoteCustomerProducts: (LIST)
PriceBreakQuantities: (LIST)
PriceBreaks: (LIST)
PriceBreaksEx: (LIST)
PriceBreaksInc: (LIST)
PriceBreakText: 
PriceBreakTextInc: 
UseContractFunctions: False
OverrideContractFunctions: False
ContractItemsOnly: False
NonContractItemsOnly: False
ContractItemsFirst: False
RestrictedProductFilter: All
ExcludeFromCatalogueProduction: False
ContractItemsWhereRestriction: 
ContractItemsFromRestriction: 
IsDangerousGoods: False
IsFreeFreight: False
IsEmailDelivery: False
IsTailgateRequired: False
ShowPriceAsPOA: False
AttributedProducts: (LIST)
   - BusinessObjects.Product
ValidProducts: (LIST)
   - BusinessObjects.Product
CustomProductService: 
Cache: BusinessObjects.PriceCache
Attributes: 
user: (LIST)
   - BusinessObjects.User
CurrentOrderForProduct: (LIST)
   - BusinessObjects.ProntoSalesOrder
sys: (LIST)
   - BusinessObjects.SystemControl
SoOrderNo: 0
SoBoSuffix: 
SolLineSeq: 0
SolLine: 
CampaignCodeProduct: 
IsKitProductForLine: False
IncTaxPrice: True
FutureDateInEffect: False
PriceDate: 16/12/2025 12:00:00 AM
PriceOverride: False
CustomerCode: WEBCASH
Customer: (LIST)
   - BusinessObjects.Customer
ProductCode: SC2
ProductIdentity: 273252
ERPProductID: 
CustomerProductCode: SC2
DescriptionDB: IPD SC2 Screw Connector 50 Piece Jar
Description: IPD SC2 Screw Connector 50 Piece Jar
TitleDB: IPD SC2 Screw Connector 50 Piece Jar
Title: IPD SC2 Screw Connector 50 Piece Jar
CategoryCode: SX090105
CatalogueCategoryCode: 
StockGroup: 808B
SEOUrl: /sc2
PrintLabelDescription: 
ActualUrl: /sc2
SEOUrlOverridden: False
PackWeight: 0.0000
PackVolume: 0.00
EstAvail: 
WarrantyChargeType: 
WarrantyChargeTypeDescription: 
WarrantyChargeTypes_AppCache: (LIST)
TaxRateCode: 1
TaxRateCodeForProntoSalesOrderLine: 1
HasSubscriptions: False
IsGiftCard: False
IsPreFetched: False
IsMasterCode: False
IsObsolete: False
IsRefurbishedProduct: False
IsKit: False
AllowFinalDiscountAppliedToKits: False
IsConfigurableKit: False
ConfigurableKitComponentsPBoM: (LIST)
UniqueBomLineTypeConfigurableKitComponents: 
OptionalKitComponentsPBoM: (LIST)
PrimaryVariantKitComponentsPBoM: (LIST)
NoteLineKitComponentsPBoM: (LIST)
ConfigurableKitComponents: (LIST)
MandatoryKitComponents: (LIST)
NonConfigurableKitComponents: (LIST)
OptionalKitComponents: (LIST)
VariableQuantityKitComponents: (LIST)
PrimaryVariantKitComponents: (LIST)
NoteLineKitComponents: (LIST)
IsProductWithCompanionAsKitWithPrimaryVariantComponent: False
IsAttributedCode: False
ProductDescription: 
IsStamp: False
IsReplacementStamp: False
StampWidth: 100
StampHeight: 100
IsStampDieOnly: False
StampPadColours: (LIST)
   - 
StockType: S
ConditionCode: 
IssueControlCode: 
PriceWarehouse: ZPJW
PriceMatrix: 
PricingSummary: 
PricingDetails: 
PriceUOM: BUCK
PriceUOMConversionFactor: -1
PriceQty: -1
UnitDesc: BUCK
UnitDescRaw: BUCK
UnitDescriptionRaw: BUCK
UnitDescription: BUCK
UnitDescriptionPlural: BUCKs
AltUnitDescription: Unspecified
AltUnitPrice: 90.4100000000
AltUnitDesc: 
UOMOnlyDisplayAltUnit: False
DisplayOnlyAlternateUom: False
Category: (LIST)
   - BusinessObjects.ProductCategory
Reviews: (LIST)
AddReviewButton: <input type='submit' value='Add Review' name='ProductAddReview_SC2' />
IsUsingAlternateUnit: False
UnitConversionFactor: 1.00000000
Alternates: (LIST)
Accessories: (LIST)
AlternatesAvailable: False
AccessoriesAvailable: False
AlternatesCount: 0
AvailableAlternatesCount: 0
AccessoriesCount: 0
Companions: (LIST)
CompanionCount: 0
ProntoPriceRecord: (LIST)
   - BusinessObjects.ProntoStockPrice
ProntoStockWarehouseRecordForCustomer: (LIST)
ProntoStockWarehouseRecord: (LIST)
   - BusinessObjects.ProntoStockWarehouse
   - BusinessObjects.ProntoStockWarehouse
   - BusinessObjects.ProntoStockWarehouse
   - BusinessObjects.ProntoStockWarehouse
   - BusinessObjects.ProntoStockWarehouse
RestrictWarehousesForProduct: 
IsPromotionPriceWithNoPriceLevel0: False
PromEndDateMessage: 
ViewReference: <a href="ProductDisplay.aspx?popup=1&Product=SC2&ProdDesc=IPD+SC2+Screw+Connector+50+Piece+Jar">
ResourceViewReference: <A href="ProductDisplay.aspx?popup=1&Template=&Product=SC2">
ClusterViewReference: <A href="ProductDisplay.aspx?popup=1&Product=SC2">
KitViewReference: <A href="ProductDisplay.aspx?popup=1&Product=SC2">
IsConfigurableKitHeaderWithZeroBasePrice: False
KitComponents: (LIST)
AvailableQtyAllWhses: 2116.0000
AvailableQtyIncCurrentLines: 2116.0000
AvailableQtyNotIncCurrentLines: 2116.0000
AvailableQtyNotIncCurrentLinesString: 2116
IsNonDepletingStockType: False
AvailableQty: 2116.0000
AvailablePackQuantity: 2116.0000
WarehousesForProduct: (LIST)
   - BusinessObjects.ProntoStockWarehouse
   - BusinessObjects.ProntoStockWarehouse
   - BusinessObjects.ProntoStockWarehouse
   - BusinessObjects.ProntoStockWarehouse
   - BusinessObjects.ProntoStockWarehouse
AllWarehousesAvailabilityForProducts: (LIST)
   - BusinessObjects.WarehouseAvailability
   - BusinessObjects.WarehouseAvailability
   - BusinessObjects.WarehouseAvailability
   - BusinessObjects.WarehouseAvailability
   - BusinessObjects.WarehouseAvailability
WarehouseCodes: (LIST)
   - CL10
   - GEN1
   - GEN4
   - SA01
   - WA01
InTransit: 0
BackOrders: 0
QtyOnBackOrderForCustomer: 0
AvailableQtyLivePricingOffline: 
IsInMyCatalogues: False
IsAllowedStockSecurity: False
ProductIsOrderRestricted: False
AllowEmail: False
AllowDownload: False
AllowShipping: True
AllowFax: False
IsElectronicAndNonDepleting: False
CanBeAddedToFavourites: True
DefaultDeliveryMethod: ship
DeliveryMethodIcons: <img src='/images/Controls/delivery_ship.gif' title='This item can be delivered by post or courier' alt='Delivery Icon' /><img src='/images/Controls/delivery_none.gif' alt='No Delivery Icon' /><img src='/images/Controls/delivery_none.gif' alt='No Delivery Icon' /><img src='/images/Controls/delivery_none.gif' alt='No Delivery Icon' />
DeliveryMethodAndSize: <img src='/images/Controls/delivery_ship.gif' title='This item can be delivered by post or courier' alt='Delivery Icon' /><img src='/images/Controls/delivery_none.gif' alt='No Delivery Icon' /><img src='/images/Controls/delivery_none.gif' alt='No Delivery Icon' /><img src='/images/Controls/delivery_none.gif' alt='No Delivery Icon' />
SalesTypeCode: AA
OverrideCategory: 
TemplateName: THEME_BPDTHEME01_Product Detail
PriceForMaxQty: 90.41
PriceForMaxQtyIncTax: 90.41
PriceForMaxQtyExTax: 82.19
NettPriceForMaxQty: 90.41
NettPriceForMaxQtyIncTax: 90.41
NettPriceForMaxQtyExTax: 82.19
PriceForPackQty: 90.41
PriceForPackQtyIncTax: 90.41
PriceForPackQtyExTax: 82.19
PackQty: 1.00
SubstituteProductForProducts: 
IsBulkProductSubstitutionsPreFetched: False
IsProductInstanceForOrderLine: False
WarehouseProductGroup: 
BonusStockForProduct: (LIST)
BonusCode: <error reading>
FreightCalculatorResults: 
CategoryProduct: (LIST)
   - BusinessObjects.CategoryProduct
PriceRRPFormatted: $90.41
PriceRRPUomFormatted: $90.41
PriceRRPIncUomFormatted: P.O.A.
PriceRRPExUomFormatted: $71.13
PriceRRP: 90.41
RRPPriceEx: 82.1900
RRPPriceInc: 90.41
DefaultRoleDefaultCustomer: (LIST)
   - BusinessObjects.Customer
TextCategoryNavigation: Installation & Accessories > Cable Installation Accessories > LV Cable Connectors
CategoryDescription: LV Cable Connectors
CategoryHierarchy: Installation & Accessories/Cable Installation Accessories/LV Cable Connectors
AdditionalProductCharge: 0
CubicSize: 0
Break: 0
MaxOrderQty: 1
MinOrderQty: 0
MinOrderPackQty: 0
ProductDetailsDefaultQuantityWhenNotIncreasePackQtyNotAddMinQty: 1
ProductDetailsDefaultQuantityWhenIncreasePackQtyNotAddMinQty: 1
ProductDetailsDefaultQuantityWhenNotIncreasePackQtyAddMinQty: 1
ProductDetailsDefaultQuantityWhenIncreasePackQtyAddMinQty: 1
ProductType: 
PaintCareLevyAmountPerUnit: 
PaintCareLevyAmount: 0
NumOfLiters: 0
ProductCount: 0
ShelfLife: 0
CompanionProductType: NotSet
AllowEmailSupplierDeliveryOnly: False
ItemValid: True
IsDeleted: False
ItemLength: 0
CanCurrentUserOverridePrice: False
QuantityInUnsubmittedWebOrders__RequestCached: 0
IsBulkQuantityInUnsubmittedWebOrdersPrefetched: True
Picture2: 
Picture3: 
Picture4: 
Picture5: 
Notes1: <B> Length x Width   : </B> 200 x 4.8mm                   <BR> <B> Bundle Dia. (mm)   : </B> 55                   <BR> <B> Loop Tensile Strength (kg)   : </B> 22                   <BR> <BR>
Notes2:  
Notes3: Out of Stock
Notes4: 
Notes5: 
Colloquial: 
CampaignProductHeaderForPaging: 
HasQuantityBreaks: False
HasQuantityBreaksNettPrice: False
IsQuantityBreaksLiveOrDefaultSuppressed: False
QuantityBreaksLiveOrDefault: 
QuantityBreaks: 
QuantityBreaksExGST: 
QuantityBreaksIncGST: 
HasLiveQuantityBreaks: False
LiveQuantityBreaks: 
LiveQuantityBreakMessage: 
AllowOrderEntryForProduct: False
QtyBox: 
RequestedDeliveryDateBox: 
OrderLineNote: 
CostCentreCode: 
CostCentreCodeControl: 
NotesControlShouldBeRendered: False
NotesControl: 
AddToOrderButton: 
MyStampsApiProductDesignButton: 
AddToFavouritesButton: <input type='submit' value='Add To Favourites' name='ProductAddToFavourites_SC2' />
ConfigureKitButton: 
KitCode: 
PriceBreak0: <div class="PriceLevel"><label>1+</label><span>$90.41</span></div>
PriceBreak1: 
PriceBreak2: 
PriceBreak3: 
PriceBreak4: 
NettPriceBreak0: <div class="PriceLevel"><label>1+</label><span>$90.41</span></div>
NettPriceBreak1: 
NettPriceBreak2: 
NettPriceBreak3: 
NettPriceBreak4: 
NettPriceBreak0IncGST: <div class="PriceLevel"><label>1+</label><span>$90.41</span></div>
NettPriceBreak1IncGST: 
NettPriceBreak2IncGST: 
NettPriceBreak3IncGST: 
NettPriceBreak4IncGST: 
NettPriceBreak0ExGST: <div class="PriceLevel"><label>1+</label><span>$82.19</span></div>
NettPriceBreak1ExGST: 
NettPriceBreak2ExGST: 
NettPriceBreak3ExGST: 
NettPriceBreak4ExGST: 
PriceBreakPrice0: 90.41
PriceBreakQty0: 1
PriceBreakPrice1: 
PriceBreakQty1: 
PriceBreakPrice2: 
PriceBreakQty2: 
PriceBreakPrice3: 
PriceBreakQty3: 
PriceBreakPrice4: 
PriceBreakQty4: 
NettPriceBreakPrice0: 90.41
NettPriceBreakQty0: 1
NettPriceBreakPrice1: 
NettPriceBreakQty1: 
NettPriceBreakPrice2: 
NettPriceBreakQty2: 
NettPriceBreakPrice3: 
NettPriceBreakQty3: 
NettPriceBreakPrice4: 
NettPriceBreakQty4: 
NettPriceBreakPrice0IncGST: 90.41
NettPriceBreakPrice1IncGST: 
NettPriceBreakPrice2IncGST: 
NettPriceBreakPrice3IncGST: 
NettPriceBreakPrice4IncGST: 
NettPriceBreakPrice0ExGST: 82.19
NettPriceBreakPrice1ExGST: 
NettPriceBreakPrice2ExGST: 
NettPriceBreakPrice3ExGST: 
NettPriceBreakPrice4ExGST: 
PriceContract: 
PricePromotion: 
PriceBreak0IncGST: <div class="PriceLevel"><label>1+</label><span>$90.41</span></div>
PriceBreak1IncGST: 
PriceBreak2IncGST: 
PriceBreak3IncGST: 
PriceBreak4IncGST: 
PriceContractIncGST: 
PricePromotionIncGST: 
PriceBreak0ExGST: <div class="PriceLevel"><label>1+</label><span>$82.19</span></div>
PriceBreak1ExGST: 
PriceBreak2ExGST: 
PriceBreak3ExGST: 
PriceBreak4ExGST: 
PriceContractExGST: 
PricePromotionExGST: 
PriceFromFirst: $90.41
PriceFromDefault: $90.41
NettPriceFromFirst: $90.41
NettPriceFromFirstInc: $90.41
NettPriceFromFirstEx: $82.19
AlternateUOMNettPriceFromFirst: 
AlternateUOMNettPriceFromFirstInc: 
AlternateUOMNettPriceFromFirstEx: 
NettPriceFromDefault: $90.41
NettPriceFromDefaultInc: $90.41
NettPriceFromDefaultEx: $82.19
AlternateUOMNettPriceFromDefault: 
AlternateUOMNettPriceFromDefaultInc: 
AlternateUOMNettPriceFromDefaultEx: 
RRPPriceFromFirst: $90.41
RRPPriceFromFirstInc: $90.41
RRPPriceFromFirstEx: $82.19
RRPPriceFromDefault: $90.41
RRPPriceFromDefaultInc: $90.41
RRPPriceFromDefaultEx: $82.19
RRPPriceForOneInc: P.O.A.
RRPPriceForOneEx: $71.13
RRPPriceForOne: $90.41
PriceForOne: $90.41
PriceForOneNumeric: 90.41
PriceForOneAndPriceType: (LIST)
   - [price, $90.41]
   - [priceType, Inc]
PriceForOneString: $90.41
RRPInc: P.O.A.
RRPEx: $82.19
RRPOrMessage: $90.41
RRPIncOrMessage: P.O.A.
RRPExOrMessage: $82.19
PriceForOneEx: $82.19
PriceForOneInc: $90.41
DiscountForOne: &nbsp;
DiscountForOneString: 
NettTaxForOne: $8.22
NettPriceForOneInc: $90.41
NettPriceForOneEx: $82.19
NettPriceForOne: $90.41
AlternateUOMNettPriceForOne: 
AlternateUOMNettPriceForOneInc: 
AlternateUOMNettPriceForOneEx: 
NettPriceForOneString: $90.41
ItemCostEx: 
GPAmountEx: 
GPPercentageEx: 
AvailableForBot: &nbsp;
AvailableForOne: &nbsp;
AvailableForOneQty: 2116.0000
Availability: InStock
OutOfStockNotificationNotifyEmailAddress: 
OnContract: 
ItemsOnOrder: 
QuantityInCart: 
ImagePrefix: <img src="
ImageSuffix: " />
Picture1IsFromProductMedia: False
Picture1: controls/bit.gif
ProductListImageUri: BusinessObjects.Product+ProductListImageInfo
Picture1SmallImagePath: /images/controls/
Picture1ThumbnailImagePath: /images/controls/
Picture4ThumbnailImagePath: /images/controls/
Picture1Title: IPD SC2 Screw Connector 50 Piece Jar
Picture1Tags: 
Picture1TagsString: 
Picture1Image: <img src="/controls/bit.gif" />
Picture1SmallPath: /images/controls/bit.gif
Picture1Path: /controls/bit.gif
ProductMedia: 
ProductDocuments: <error reading>
ExternalUrl: https://ipdstagedev.commerce.vision/sc2
ExternalImageUrl: https://ipdstagedev.commerce.vision/controls/bit.gif
ProductMediaData: BusinessObjects.ProductMediaData
ProductAttributeEnabled: False
ProductMediaGoogleFeed: https://ipdstagedev.commerce.vision/images/controls/bit.gif
PriceCurrencySuffix: (inc GST)
AverageRating: Product has not been rated yet.
AverageReviewRating: 0
AverageRatingDescription: 
AverageRatingText: 
NumberOfReviews: 0
ReviewSummary: 
BonusStockForProductText: 
AttributedProductDropDownList: 
AlternatesAccessoriesText: 
ImageFileName: https://ipdstagedev.commerce.vision/images/controls/bit.gif
FileName: 
PriceBreakTextRenderMode: Default
AttributePriceBreakContainer: <div id='attributedProductQtyBreakInfo_SC2'></div>
QtyBoxStep: 1
MetaDataSummary: CONVERT TO AJAX BASED PRODUCT FEATURES
ProductPOA: P.O.A.
PricePer: 1
AddToOrCreateOwnRegistryListButton: 
RegistryListIDHiddenHtmlField: 
DeleteFromUserStocktakeButton: 
StocktakeQty: 
MetaKeywordTag: 
MetaDescriptionTag: 
MetaDescriptionTagOverridden: False
PageTitleTag: IPD SC2 Screw Connector 50 Piece Jar - LV Cable Connectors
PageTitleTagOverridden: True
MailingListSubscriptionLink: 
IsMasterProduct: False
RefreshMasterProductAlternatives: False
IsAttributeSelection: False
IsMasterProductWithAttributesNotForOrderLine: False
IsMasterProductWithAttributes: False
ProductAttributes: 
ItemWasValidBeforeAttributeSetup: False
ProductAttributeDisplayType: List
PriceForOneExOrMessage: $82.19
PriceForOneIncOrMessage: $90.41
PriceForOneOrMessage: $90.41
NettPriceForOneIncOrMessage: $90.41
NettPriceForOneExOrMessage: $82.19
NettPriceForOneOrMessage: $90.41
IsAttributedProduct: False
IsMasterProductWithAttributedProductWithSameProductCode: False
ProductAttributeProductCount: 0
DeliveryOverrideCustomField: 
AllProductCodesList: (LIST)
   - SC2
PageProductCodesList: 
PagingAwareProductCodesList: (LIST)
   - SC2
AllProductCodesThatAreNotKitsList: (LIST)
   - SC2
GetProductAttributeProductsJsonString: 
AllProductAttributeCombinationsForProduct: (LIST)
AllProductAttributeCombinationsForProductAsProduct: <error reading>
AttributeList: (LIST)
PriceRRPInc: 0.00
PriceRRPEx: 71.13
IntegratedPrice: 71.13
StandardCost: 0.0000
ReplacementCost: 0.0000
AnalysisCode1: 
AnalysisCode3: 
APN: 9322017232931
IsInUserFavourites: False
UserFavouritesProductDisplayIcon: 
CustomerFavouritesProductDisplayIcon: 
AddProductToComparisonListToken: <div data-product-code='SC2' data-description='IPD SC2 Screw Connector 50 Piece Jar' data-role='productcomparebutton'><div data-view='true'><input type='checkbox' data-bind='click: configureProductInComparisonList, checked: isSelected, attr: {title: title}'></input> <span data-bind='text: label, attr: {title: title}'></span></div>
</div>
ProductComparisonData: (LIST)
   - Framework.Recordset
   - Framework.Recordset
   - Framework.Recordset
   - Framework.Recordset
ProductFeatures: (LIST)
   - BusinessObjects.ProductFeatures
   - BusinessObjects.ProductFeatures
ProductFeaturesField: 
ProductFeaturesAll: (LIST)
   - BusinessObjects.ProductFeatures
   - BusinessObjects.ProductFeatures
   - BusinessObjects.ProductFeatures
   - BusinessObjects.ProductFeatures
ProductFeaturesTechSpecs: (LIST)
   - BusinessObjects.ProductFeatures
   - BusinessObjects.ProductFeatures
   - BusinessObjects.ProductFeatures
   - BusinessObjects.ProductFeatures
UserGroup1: 
UserGroup2: IR
ReorderBuyer: CP
SafeFilter: 
SafeRawSearch: 
SafeAdditionalFrom: 
IsSpecialDataSourceInjectFromInProductFeatures: False
LuceneSearchRedirectUrl: 
IsLuceneSearchResults: False
CustomerProductInfo: 
BrandCode: 
BrandText: 
RebatePercentage: 0
RebateAmount: 0
SeoUrlUpdated: 1/01/0001 12:00:00 AM
MailchimpUpdatedDate: 
DeliveryAndPickupOption: DeliveryAndPickup
AvailableQtyPickupClickAndCollect: 2116.0000
AvailableQtyDeliveryClickAndCollect: 2116.0000
PickupStore: 
IsCoreProduct: False
DisplayNearbyStoresAvailabilityForProduct: False
NearestStoresToCurrentPickupStore: 
RibbonFlag: 
RibbonStartDate: 
RibbonExpiryDate: 
RibbonFlagImageName: 
BpdRibbonImage: 
BpdRibbonFlagImage: 
BpdSupersededRibbonImage: <img class="product-ribbon-img" src="/Themes/BPDTHEME01/theme-client-updates/img/ribbons/ribbon-superseded.png" alt="" />
BpdContractRibbonImage: 
GetProductForProductData: (LIST)
   - BusinessObjects.Product
IsReturnable: True
ProductUnreturnableMessage: 
SearchID: 0
SearchPos: 0
SearchAnalyticsQueryString: 
IsGiveXGiftCard: False
IsSubscriptionProduct: False
SubscriptionProductValidityInfo: (False, False)
IsOrderRestricted: False
StockLevel: 
PageNumber: 
IsMixedModeTaxKit: False
TaxRateForMixedModeTaxKit: 0.0
DictionaryName: Product
GetSetPrivateStrFilter: Product.ItemValid = 1 AND Product.IsDeleted = 0  AND Product.SEOUrl = '/sc2'
GetSetPrivateStrInitFilter: Product.ItemValid = 1 AND Product.IsDeleted = 0  AND Product.SEOUrl = '/sc2'
KeyNames: (LIST)
   - ProductCode
KeyValues: (LIST)
   - SC2
SearchKeyValues: (LIST)
   - 
KeyCount: 1
SearchOrderBy: 
DefaultView: (LIST)
   - System.Data.DataRowView
SearchView: 
Item: <error reading>
SingleRecordFilter: 
SingleRecordCache: 
IsSingleRecordCached: False
Item: <error reading>
EOF: False
BOF: False
Filter: Product.ItemValid = 1 AND Product.IsDeleted = 0  AND Product.SEOUrl = '/sc2'
InitialFilter: Product.ItemValid = 1 AND Product.IsDeleted = 0  AND Product.SEOUrl = '/sc2'
AppendAfterOrderBy: 
AppendToBeginning: 
OrderBy: 
Count: 1
Current: True
From: Product 
Fields: (LIST)
   - IsOrderRestricted
   - ProductCode
   - CUS_TechnicalSpecifications
   - CUS_AdditionalInformation
   - Description
   - CategoryCode
   - CUS_DocumentsAndDownloads
   - CUS_ProductVideos
   - TopLevelCategory
   - CUS_DocManual
   - DescriptionLine2
   - DescriptionLine3
   - CUS_DocDiagram
   - CUS_DocMSDS
   - Picture3
   - Picture4
   - CUS_DocSizing
   - Picture1
   - CUS_EngineManual
   - Picture2
   - Picture5
   - CUS_DocApplication
   - Notes1
   - Notes2
   - CUS_DocQuickStart
   - CUS_BrandImage
   - Notes3
   - Notes4
   - CUS_Picture1Backup
   - CUS_customProductVideo
   - Notes5
   - CUS_ProductFeatures
   - StockType
   - CUS_ProductImageLastModified
   - UnitDesc
   - CUS_DatasheetInformation
   - ItemValid
   - CUS_featured_product
   - StockGroup
   - SalesTypeCode
   - UserGroup1
   - UserGroup2
   - ProductTemplateCode
   - Updated
   - ProductIdentity
   - PackQuantity
   - PackWeight
   - packVolume
   - APN
   - StandardCost
   - ReplacementCost
   - SalesCost
   - AltUnitDesc
   - ExiseQuantity
   - ShelfLife
   - ConditionCode
   - Notes6
   - IssueControlCode
   - TopTemplate
   - BottomTemplate
   - PricePer
   - AnalysisCode1
   - AttributeSet1
   - AttributeSet2
   - AttributeSet3
   - AttributePrompt1
   - AttributePrompt2
   - AttributePrompt3
   - DefaultDeliveryMethod
   - EmailDiscount
   - DownloadDiscount
   - FileSize
   - EmailTemplate
   - FileName
   - AllowEmail
   - AllowDownload
   - AllowShipping
   - FileDateStamp
   - DeliveryAndPickupOption
   - Picture1Version
   - Picture2Version
   - Picture3Version
   - Picture4Version
   - Picture5Version
   - UseMailerFreight
   - SpareAnalysisCode
   - SIZE
   - SELL
   - SUPPCODE
   - CAPACITY
   - CTN
   - COLOUR
   - PKT
   - PAGES
   - LINES
   - PLY
   - POWER
   - DOORS
   - WEIGHT
   - WATT
   - SHAF
   - COVERS
   - SPECS
   - AMP
   - MATERIAL
   - DEPTH
   - BLADES
   - GUAGE
   - DIAMETER
   - HEIGHT
   - COMPARTMENTS
   - MDDESC
   - RIBS
   - QTY
   - HANDLE
   - OVERALL
   - PRODUCTIVITY
   - STYLE
   - PAPERSIZE
   - SHELF
   - CONSTRUCTION
   - SEARCHDESC
   - HasSubscriptions
   - ItemWidth
   - ItemLength
   - ItemDepth
   - ItemWeight
   - ItemFolds
   - MaxOrderQty
   - AllowFax
   - FaxDiscount
   - AllowPOD
   - PreviousCode
   - PODStaticDocument
   - PODAllowColour
   - PODAllowSingleSide
   - Picture1Height
   - Picture1Width
   - Picture2Height
   - Picture2Width
   - Picture3Height
   - Picture3Width
   - Picture4Height
   - Picture4Width
   - Picture5Height
   - Picture5Width
   - ConversionFactor
   - IsStamp
   - StampHeight
   - StampWidth
   - UNSPSCCode
   - Price
   - TaxCodeList
   - MinOrderQty
   - StorageTypeFlag
   - StkDateCreated
   - ImageRef
   - ReorderPolicy
   - ReorderBuyer
   - ExpectedSalesQty
   - AverageReviewRating
   - EstAvail
   - ProductThumbnail
   - Title
   - ParentProductCodeForAtrributedProduct
   - AdditionalProductCharge
   - MetaKewordTag
   - MetaDescriptionTag
   - PageTitleTag
   - CubicSize
   - Break
   - IsMasterProduct
   - ProductAttributes
   - ItemWasValidBeforeAttributeSetup
   - CompanionProductType
   - SEOUrl
   - AllowEmailSupplierDeliveryOnly
   - AnalysisCode2
   - ExcludeFromCatalogueProduction
   - IsBusinessCard
   - Colloquial
   - BoostSourceValue
   - BrandCode
   - AnalysisCode3
   - AvailNSW
   - AvailWA
   - PriceRRPInc
   - PriceRRPEx
   - AvailVIC
   - AvailNT
   - IntegratedPrice
   - PostageAndHandling
   - AvailSA
   - AvailQLD
   - ProductDescription
   - ProductFeatures
   - AvailNQ
   - AvailTAS
   - RibbonFlag
   - SubTitle
   - Warranty
   - IsNew
   - ProductMedia
   - IsReplacementStamp
   - MetaDescriptionTagOverridden
   - PageTitleTagOverridden
   - SEOUrlOverridden
   - SeoUrlUpdated
   - IsStampDieOnly
   - StampPadColours
   - StockSortAnalysisCode
   - RibbonExpiryDate
   - IsDangerousGoods
   - ProductAttributeDisplayType
   - ShowPriceAsPOA
   - SortAnalysisCode
   - WarrantyChargeType
   - WarrantyChargeTypeDescription
   - IsFreeFreight
   - InstructionManualLink
   - SpecificationLink
   - IsTailgateRequired
   - IsReturnable
   - TechnicalBulletinLink
   - InstallationManualLink
   - PrintLabelDescription
   - RibbonStartDate
   - IsDeleted
   - ItemDiscGroup
   - AllowInvoiceDisc
   - Blocked
   - SalesBlocked
   - GenProdPostingGroup
   - TaxPostingGroup
   - PriceIncludesTAX
   - MailchimpUpdatedDate
   - RefreshMasterProductAlternatives
   - IsEmailDelivery
   - IsGiftCard
   - IsSubscriptionProduct
   - ERPProductID
   - PIMStatus
   - ABCClass
   - QtyOnHandGEN1
   - TotalInStock
   - TopPriority
   - EstimatedPrice
   - UnitManufactoringCost
   - UnitFreightCost
   - WarehouseStorageCost
   - AdvertisingCosts
   - OtherCosts
   - TargetUnitsQuantity
   - AdvertisingCostsType
   - OtherCostsType
DisplayFields: 
AdditionalSearchFields: 
Connection: Framework.Connection
TableName: PRODUCT
SecondarySearchTableNames: 
Index: 0
SearchIndex: -1
RecordState: Normal
Table: TABLE
PagingStartIndex: 0
PagingEndIndex: 0
PageRecordStart: 1
PageRecordEnd: 1
PageCount: 1
PageTotal: 1
InnerTable: TABLE
SearchTable: 
IdentityColumn: ProductIdentity
Copying: False
HasFullTextSearch: False
PreloadRelated: False
KeepInitFilter: False
KeepInitOrderBy: False
ParseAllRecords: False
UseNumericClientIndex: False
ExcludeFromRows: False
IsDataSource: False
fwUpdated: 15/12/2025 6:16:06 PM
fwCreated: 21/05/2018 6:47:00 PM
LastModifiedDate: 15/12/2025 6:16:06 PM
Locked: False
ViewInsertFields: 
ForceUniqueRecords: False
AllowFieldCheckByKeyValuePair: False
AllowFieldCheckExtraValue: False
ExtraFieldCheckValues: 
==== PRODUCT FIELDS END ====