xquery version "3.0"; let $pm := doc( '/db/bagco/refdata/PrintMethods.xml' )/PrintMethods/PrintMethod[@PrintMethodID='24'] return element PrintMethod { element PrintMethodID { '24' }, element PrintMethodName { data( $pm/PrintMethodName ) }, element SetupName { data( $pm/DisplayName ) }, element DefaultComment { data( $pm/DefaultComment ) }, element SagePrintCode { data( $pm/SagePrintCode ) }, element SageSetupCode { data( $pm/SageSetupCode ) }, element SageNominalCode { data( $pm/SageNominalCode ) }, element StandardSizes { for $pc in $pm/PrintCharges return element PrintCharges { element SetupCharge { data( $pc/SetupCharge ) }, element RepeatCharge { data( $pc/RepeatCharge ) }, for $ss in $pc/StandardSizes/StandardSize order by xs:int( $ss/@StandardSizeID ) return element StandardSize { element StandardSizeID { data( $ss/@StandardSizeID ) }, element Description { data( $ss/Description ) }, element MinimumCharge { data( $ss/MinimumCharge ) }, element PrintPrices { for $pp in $ss/PrintPrices/PrintPrice order by xs:int( $pp/@FromQuantity) return element PrintPrice { element FromQuantity { data( $pp/@FromQuantity ) }, element ToQuantity { data( $pp/@ToQuantity ) }, element Value { data( $pp ) } } } } } } } TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9xquery version "3.0"; let $pm := doc( '/db/bagco/refdata/PrintMethods.xml' )/PrintMethods/PrintMethod[@PrintMethodID='24'] return element PrintMethod { element PrintMethodID { '24' }, element PrintMethodName { data( $pm/PrintMethodName ) }, element SetupName { data( $pm/DisplayName ) }, element DefaultComment { data( $pm/DefaultComment ) }, element SagePrintCode { data( $pm/SagePrintCode ) }, element SageSetupCode { data( $pm/SageSetupCode ) }, element SageNominalCode { data( $pm/SageNominalCode ) }, element StandardSizes { for $pc in $pm/PrintCharges return element PrintCharges { element SetupCharge { data( $pc/SetupCharge ) }, element RepeatCharge { data( $pc/RepeatCharge ) }, for $ss in $pc/StandardSizes/StandardSize order by xs:int( $ss/@StandardSizeID ) return element StandardSize { element StandardSizeID { data( $ss/@StandardSizeID ) }, element Description { data( $ss/Description ) }, element MinimumCharge { data( $ss/MinimumCharge ) }, element PrintPrices { for $pp in $ss/PrintPrices/PrintPrice order by xs:int( $pp/@FromQuantity) return element PrintPrice { element FromQuantity { data( $pp/@FromQuantity ) }, element ToQuantity { data( $pp/@ToQuantity ) }, element Value { data( $pp ) } } } } } } } TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9xquery version "3.0"; let $pm := doc( '/db/bagco/refdata/PrintMethods.xml' )/PrintMethods/PrintMethod[@PrintMethodID='24'] return element PrintMethod { element PrintMethodID { '24' }, element PrintMethodName { data( $pm/PrintMethodName ) }, element SetupName { data( $pm/DisplayName ) }, element DefaultComment { data( $pm/DefaultComment ) }, element SagePrintCode { data( $pm/SagePrintCode ) }, element SageSetupCode { data( $pm/SageSetupCode ) }, element SageNominalCode { data( $pm/SageNominalCode ) }, element StandardSizes { for $pc in $pm/PrintCharges return element PrintCharges { element SetupCharge { data( $pc/SetupCharge ) }, element RepeatCharge { data( $pc/RepeatCharge ) }, for $ss in $pc/StandardSizes/StandardSize order by xs:int( $ss/@StandardSizeID ) return element StandardSize { element StandardSizeID { data( $ss/@StandardSizeID ) }, element Description { data( $ss/Description ) }, element MinimumCharge { data( $ss/MinimumCharge ) }, element PrintPrices { for $pp in $ss/PrintPrices/PrintPrice order by xs:int( $pp/@FromQuantity) return element PrintPrice { element FromQuantity { data( $pp/@FromQuantity ) }, element ToQuantity { data( $pp/@ToQuantity ) }, element Value { data( $pp ) } } } } } } } TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9xquery version "3.0"; let $pm := doc( '/db/bagco/refdata/PrintMethods.xml' )/PrintMethods/PrintMethod[@PrintMethodID='24'] return element PrintMethod { element PrintMethodID { '24' }, element PrintMethodName { data( $pm/PrintMethodName ) }, element SetupName { data( $pm/DisplayName ) }, element DefaultComment { data( $pm/DefaultComment ) }, element SagePrintCode { data( $pm/SagePrintCode ) }, element SageSetupCode { data( $pm/SageSetupCode ) }, element SageNominalCode { data( $pm/SageNominalCode ) }, element StandardSizes { for $pc in $pm/PrintCharges return element PrintCharges { element SetupCharge { data( $pc/SetupCharge ) }, element RepeatCharge { data( $pc/RepeatCharge ) }, for $ss in $pc/StandardSizes/StandardSize order by xs:int( $ss/@StandardSizeID ) return element StandardSize { element StandardSizeID { data( $ss/@StandardSizeID ) }, element Description { data( $ss/Description ) }, element MinimumCharge { data( $ss/MinimumCharge ) }, element PrintPrices { for $pp in $ss/PrintPrices/PrintPrice order by xs:int( $pp/@FromQuantity) return element PrintPrice { element FromQuantity { data( $pp/@FromQuantity ) }, element ToQuantity { data( $pp/@ToQuantity ) }, element Value { data( $pp ) } } } } } } } TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9xquery version "3.0"; let $pm := doc( '/db/bagco/refdata/PrintMethods.xml' )/PrintMethods/PrintMethod[@PrintMethodID='24'] return element PrintMethod { element PrintMethodID { '24' }, element PrintMethodName { data( $pm/PrintMethodName ) }, element SetupName { data( $pm/DisplayName ) }, element DefaultComment { data( $pm/DefaultComment ) }, element SagePrintCode { data( $pm/SagePrintCode ) }, element SageSetupCode { data( $pm/SageSetupCode ) }, element SageNominalCode { data( $pm/SageNominalCode ) }, element StandardSizes { for $pc in $pm/PrintCharges return element PrintCharges { element SetupCharge { data( $pc/SetupCharge ) }, element RepeatCharge { data( $pc/RepeatCharge ) }, for $ss in $pc/StandardSizes/StandardSize order by xs:int( $ss/@StandardSizeID ) return element StandardSize { element StandardSizeID { data( $ss/@StandardSizeID ) }, element Description { data( $ss/Description ) }, element MinimumCharge { data( $ss/MinimumCharge ) }, element PrintPrices { for $pp in $ss/PrintPrices/PrintPrice order by xs:int( $pp/@FromQuantity) return element PrintPrice { element FromQuantity { data( $pp/@FromQuantity ) }, element ToQuantity { data( $pp/@ToQuantity ) }, element Value { data( $pp ) } } } } } } } TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9 TFRN applies Transfer Size Medium Price 1.3 TFRN applies Transfer Size Medium Price 1.1 TFRN applies Transfer Size Medium Price 1 TFRN applies Transfer Size Medium Price 0.95 TFRN applies Transfer Size Medium Price 0.9xquery version "3.0"; let $pm := doc( '/db/bagco/refdata/PrintMethods.xml' )/PrintMethods/PrintMethod[@PrintMethodID='24'] return element PrintMethod { element PrintMethodID { '24' }, element PrintMethodName { data( $pm/PrintMethodName ) }, element SetupName { data( $pm/DisplayName ) }, element DefaultComment { data( $pm/DefaultComment ) }, element SagePrintCode { data( $pm/SagePrintCode ) }, element SageSetupCode { data( $pm/SageSetupCode ) }, element SageNominalCode { data( $pm/SageNominalCode ) }, element StandardSizes { for $pc in $pm/PrintCharges return element PrintCharges { element SetupCharge { data( $pc/SetupCharge ) }, element RepeatCharge { data( $pc/RepeatCharge ) }, for $ss in $pc/StandardSizes/StandardSize order by xs:int( $ss/@StandardSizeID ) return element StandardSize { element StandardSizeID { data( $ss/@StandardSizeID ) }, element Description { data( $ss/Description ) }, element MinimumCharge { data( $ss/MinimumCharge ) }, element PrintPrices { for $pp in $ss/PrintPrices/PrintPrice order by xs:int( $pp/@FromQuantity) return element PrintPrice { element FromQuantity { data( $pp/@FromQuantity ) }, element ToQuantity { data( $pp/@ToQuantity ) }, element Value { data( $pp ) } } } } } } } SimpleXMLElement Object ( [FromQuantity] => 1 [ToQuantity] => 99 [Value] => 1.80 ) xquery version "3.0"; let $pm := doc( '/db/bagco/refdata/PrintMethods.xml' )/PrintMethods/PrintMethod[@PrintMethodID='24'] return element PrintMethod { element PrintMethodID { '24' }, element PrintMethodName { data( $pm/PrintMethodName ) }, element SetupName { data( $pm/DisplayName ) }, element DefaultComment { data( $pm/DefaultComment ) }, element SagePrintCode { data( $pm/SagePrintCode ) }, element SageSetupCode { data( $pm/SageSetupCode ) }, element SageNominalCode { data( $pm/SageNominalCode ) }, element StandardSizes { for $pc in $pm/PrintCharges return element PrintCharges { element SetupCharge { data( $pc/SetupCharge ) }, element RepeatCharge { data( $pc/RepeatCharge ) }, for $ss in $pc/StandardSizes/StandardSize order by xs:int( $ss/@StandardSizeID ) return element StandardSize { element StandardSizeID { data( $ss/@StandardSizeID ) }, element Description { data( $ss/Description ) }, element MinimumCharge { data( $ss/MinimumCharge ) }, element PrintPrices { for $pp in $ss/PrintPrices/PrintPrice order by xs:int( $pp/@FromQuantity) return element PrintPrice { element FromQuantity { data( $pp/@FromQuantity ) }, element ToQuantity { data( $pp/@ToQuantity ) }, element Value { data( $pp ) } } } } } } } SimpleXMLElement Object ( [FromQuantity] => 1 [ToQuantity] => 99 [Value] => 1.80 )