XML as input Parameter in SP

Question

XML as input Parameter in SP

vsoneta

SSC Rookie

Points: 32
More actions
June 7, 2012 at 1:25 pm

#262473

Hello I have input xml come as
<Root xmlns="http://Supervalu.JonesNewInvoiceFlatFileSchema">
<Header xmlns="">
<Body>201212403113INVOICE 061SV01986</Body>
</Header>
<Detail xmlns="">
<Body>0610605042912201212319500000000000001000J001221650}00000000000000000000012216N0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000000220121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000012216N000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061060504291220121233959999999990000012216N0000000{0000012216N00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010002201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000012216N00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610605042912201212319500000000000001000J000066310}00000000000000000000000663J0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000000320121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000000663J000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061060504291220121233959999999990000000663J0000000{0000000663J00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010003201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000663J00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610605928940201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000000120121230000000000019289400000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061060592894020121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010001201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610605930229201212321200863709700012000J000014400{00001100000000000000000133Q0000110}000084603600172000J0000000000070% ISOP ALCOHOL 2GOOD SENSI00120100006100100002012123000014400001609775 16OZY1000141E0026F0000{0003D00000161C0000000161L0000000161L000{000010B00000{00000{00000{00000{ 000 000000E000000D000003B000001D000004{000005F000006G000004B000000F000002E735706900000000000000000802243</Body>
</Detail>
<Detail xmlns="">
<Body>061060593022920121233129999999990000000161L0000000{0000000161L00000J0000110}00000{00000{00000{00000{00000{000000000{0000000000000000000001-01-01I0012010000610010000201212300026O0000010000000144000000141N000026O000000{000003M0000000171N0000000161L00000010K0000000{0000000{0000000{00000000{000003M00000000000N000000M000003K000001M000004}000005O000006P000004K000000O0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610606042912201212319500000000000001000J001502020}00000000000000000000015020K0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000000520121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000015020K000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061060604291220121233959999999990000015020K0000000{0000015020K00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010005201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000015020K00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610606042912201212319500000000000001000J000084190}00000000000000000000000841R0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000000620121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000000841R000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061060604291220121233959999999990000000841R0000000{0000000841R00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010006201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000841R00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610606927528201212320600752294400012000L000034680{00000675000000000000001040M0000202N000002100063899000L00000393000SHR FOUR CHS MEX 2KRAFT# I00060000006100100002012123000034680001607598 8OZY1000339H0000{0022I0002F00000365C0000001095R0000001095R000{000000{00000{00000{00005J00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000007{032490514000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061060692752820121233069999999990000001095R0000005A0000001090Q00000L0000202N00000{00000{00000{00000{00000{000001414Q0000000000000000000001-01-01I0006000000610010000201212300068P0000010000001040400001019M000000{000068P000007Q0000001095R0000001090Q00000000{0000000{0000000{0000005J00000000{000007Q00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610606928941201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000000420121230000000000019289410000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061060692894120121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010004201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610607042912201212319500000000000001000J000886730}00000000000000000000008867L0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000000820121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000008867L000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061060704291220121233959999999990000008867L0000000{0000008867L00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010008201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000008867L00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610607042912201212319500000000000001000J000054380}00000000000000000000000543Q0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000000920121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000000543Q000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061060704291220121233959999999990000000543Q0000000{0000000543Q00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010009201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000543Q00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610607927529201212322500666308900012000J000052560{00000788000000000000000525O0000078Q000007242500005000J00000001000TERIYAKI SALMON 2MARINA I00030000006100100002012123000052560001604389 5.25OZN1000000{0000{0000{0000{00000000{0000000000{0000000525O000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{753886004000000000000289808868</Body>
</Detail>
<Detail xmlns="">
<Body>0610607927529201212322500669289000040000J000025200{00001000000000000000000252}0000100}000089784800109000J00000001000ROCKFISH 2OCEAN ECLI00030000006100100002012123000025200001604389 4 OZN1000000{0000{0000{0000{00000000{0000000000{0000000252}000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{740005400000000000000139808868</Body>
</Detail>
<Detail xmlns="">
<Body>0610607927529201212322500669289100040000L000028800{00001000000000000000000864}0000300}000097848000107000L00000001000TILAPIA 2OCEAN ECLI000300000061001000020121230000288000016043894 OZN1000000{0000{0000{0000{00000000{0000000000{0000000864}000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{740005400000000000000474808868</Body>
</Detail>
<Detail xmlns="">
<Body>0610607927529201212322500669623800040000J000024400{00000800000000000000000244}0000080}000089784800162000J00000001000SALMON BURGERS 2OCEAN ECLI00030000006100100002012123000024400001604389 4 OZN1000000{0000{0000{0000{00000000{0000000000{0000000244}000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{740005400000000000000134808868</Body>
</Detail>
<Detail xmlns="">
<Body>0610607927529201212322500669860600040000J000026000{00000006000000000000000260}0000000O000089784800108000J00000001000OCEAN ECLIPSE CATF2OCEAN ECLI00030000006100100002012123000026000001604389 4OZN1000000{0000{0000{0000{00000000{0000000000{0000000260}000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{740005400000000000000143808868</Body>
</Detail>
<Detail xmlns="">
<Body>0610607927529201212322500670992700006000K000053280{00000900000000000000001065O0000180}000007479146234000K00000001000SHRIMP SKWR 5CT 2XCELLENT I000300000061001000020121230000532800016043891.5 LBN1000000{0000{0000{0000{00000000{0000000000{0000001065O000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{737682801000000000000586808868</Body>
</Detail>
<Detail xmlns="">
<Body>0610607927529201212322500671580500040000L000026000{00001000000000000000000780}0000300}000089784800154000L00000001000SKNL BNLS COD PORT2OCEAN ECLI00030000006100100002012123000026000001604389 4OZN1000000{0000{0000{0000{00000000{0000000000{0000000780}000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{740005400000000000000429808868</Body>
</Detail>
<Detail xmlns="">
<Body>0610607927529201212322500671855200040000L000026000{00001000000000000000000780}0000300}000089784800111000L00000001000TILAPIA LEMON PEPR2OCEAN ECLI00030000006100100002012123000026000001604389 4 OZN1000000{0000{0000{0000{00000000{0000000000{0000000780}000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{740005400000000000000429808868</Body>
</Detail>
<Detail xmlns="">
<Body>0610607927529201212322500671859600040000M000026000{00001000000000000000001040}0000400}000009784800104000M00000001000FLOUNDER FILLET 2OCEAN ECLI00030000006100100002012123000026000001604389 4OZN1000000{0000{0000{0000{00000000{0000000000{0000001040}000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{740005400000000000000572808868</Body>
</Detail>
<Detail xmlns="">
<Body>0610607927529201212322500671868600040000M000037000{00001000000000000000001480}0000400}000089784800102000M00000001000SALMON PORTION 2OCEAN ECLI00030000006100100002012123000037000001604389 4OZN1000000{0000{0000{0000{00000000{0000000000{0000001480}000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{740005400000000000000816808868</Body>
</Detail>
<Detail xmlns="">
<Body>0610607927529201212322500671868700040000J000030500{00001000000000000000000305}0000100}000009784800149000J00000001000LMN/BTR SALMON POR2OCEAN ECLI00030000006100100002012123000030500001604389 4OZN1000000{0000{0000{0000{00000000{0000000000{0000000305}000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{740005400000000000000168808868</Body>
</Detail>
<Detail xmlns="">
<Body>0610607927529201212322500680906200048000L000025000{00000900000000000000000750}0000270}000001102900043000L00000001000BULK CRAB CAKES 2KANIMI I00030000006100100002012123000025000001604389 3OZN1000000{0000{0000{0000{00000000{0000000000{0000000750}000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{513760902000000000000414808868</Body>
</Detail>
<Detail xmlns="">
<Body>061060792752920121233259999999990000008346K0000459L0000008805N00002P0002509M00000{00000{00000{00000{00000{000000100Q0000000000000000000001-01-01I0003000000610010000201212300459L0000010000008346200000000{000000{000000{000000{0000000000{0000008805N00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610607928942201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000000720121230000000000019289420000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061060792894220121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010007201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610608042912201212319500000000000001000J001108300}00000000000000000000011083}0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000001120121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000011083}000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061060804291220121233959999999990000011083}0000000{0000011083}00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010011201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000011083}00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610608042912201212319500000000000001000J000064630}00000000000000000000000646L0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000001220121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000000646L000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061060804291220121233959999999990000000646L0000000{0000000646L00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010012201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000646L00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610608928943201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000001020121230000000000019289430000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061060892894320121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010010201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610609042912201212319500000000000001000J001386920}00000000000000000000013869K0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000001420121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000013869K000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061060904291220121233959999999990000013869K0000000{0000013869K00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010014201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000013869K00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610609042912201212319500000000000001000J000083500}00000000000000000000000835}0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000001520121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000000835}000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061060904291220121233959999999990000000835}0000000{0000000835}00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010015201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000835}00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610609927530201212320100000000000001000J000020000{00000000000000000000000200}0000000{000000000000000000J00000000000 I00011000006100100002012123000020000001602762 Y1000200{0000{0000{0000{00000200{0000000200}0000000200}000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000808865</Body>
</Detail>
<Detail xmlns="">
<Body>061060992753020121233019999999990000000200}0000000{0000000200}00000J0000000{00000{00000{00000{00000{00200}000000000{0000000000000000000001-01-01I0001000000610010000201212300000{0000010000000200000000200}000000{000000{000000{0000000200}0000000200}00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610609927531201212320100000000000001000J000020000{00000000000000000000000200}0000000{000000000000000000J00000000000 I00011000006100100002012123000020000001602764 Y1000200{0000{0000{0000{00000200{0000000200}0000000200}000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000808427</Body>
</Detail>
<Detail xmlns="">
<Body>061060992753120121233019999999990000000200}0000000{0000000200}00000J0000000{00000{00000{00000{00000{00200}000000000{0000000000000000000001-01-01I0001000000610010000201212300000{0000010000000200000000200}000000{000000{000000{0000000200}0000000200}00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610609928944201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000001320121230000000000019289440000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061060992894420121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010013201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610610042912201212319500000000000001000J000842550}00000000000000000000008425N0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000001720121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000008425N000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061004291220121233959999999990000008425N0000000{0000008425N00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010017201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000008425N00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610610042912201212319500000000000001000J000053000}00000000000000000000000530}0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000001820121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000000530}000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061004291220121233959999999990000000530}0000000{0000000530}00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010018201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000530}00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610610927532201212320100402094300008000J000012180{00000513000000000000000121Q0000051L000001780010968000J00000189000PREP MEAL TURKEY 2BENEFUL%*I0001000000610010000201212300001218000160115410 OZY1000119D0009A0002H0001D00000132G0000000132P0000000132P000{000000{00000{00000{00000K00000{ 000 000000H000000C000001E000000F000003E000000H000001I000002{000000E000002D071100202000000000000000810310</Body>
</Detail>
<Detail xmlns="">
<Body>0610610927532201212320100402105900024000J000015840{00000600000000000000000158M0000060}000002310002451000J00000079000PRTRHSE STK FLAVOR2CESAR* I00010000006100100002012123000015840001601154 3.5OZY1000154H0010H0002E0001D00000169E0000000169N0000000169N000{000000{00000{00000{00000P00000{ 000 000001C000000D000001D000000E000003E000001{000002{000002G000000E000003F044223600000000000000000810310</Body>
</Detail>
<Detail xmlns="">
<Body>0610610927532201212320100402330200024000J000011760{00000863000000000000000117O0000086L000002310001398000J00000069000LTL CHMP BFW/GRV 2PEDIGREE*I00010000006100100002012123000011760001601154 5.3OZY1000114I0010B0002E0001G00000129C0000000129L0000000129L000{000000{00000{00000{00000N00000{ 000 000001{000000I000001I000000F000003B000000H000001I000001I000000E000002G044223600000000000000000810310</Body>
</Detail>
<Detail xmlns="">
<Body>0610610927532201212320100402416300012000J000012740{00001113000000000000000127M0000111L000001780012604000J00000139000ONE WT TKY&BRLY DG2PURINA* I00010000006100100002012123000012740001601154 13OZY1000124H0008D0002H0001E00000137E0000000137N0000000137N000{000000{00000{00000{00000L00000{ 000 000000C000000H000001{000000C000003F000000H000001I000002{000000E000002F071100202000000000000000810310</Body>
</Detail>
<Detail xmlns="">
<Body>0610610927532201212320100402605000001000K000014630{00001600000000000000000292O0000320}000001780013468000K00001807000HEALTHY RADIANCE 2@BENEFUL I00010000006100100002012123000014630001601154 15.5LBY1000143C0010C0002H0004C00000160G0000000321M0000000321M000{000000{00000{00000{00001L00000{ 000 000000D000000B000002A000000E000003G000001B000002{000002E000000E000003{071100201000000000000000810310</Body>
</Detail>
<Detail xmlns="">
<Body>0610610927532201212320100402605100001000K000014630{00001600000000000000000292O0000320}000001780013459000K00001807000HEALTHY WEIGHT 2@BENEFUL I00010000006100100002012123000014630001601154 15.5LBY1000143D0010{0002H0004C00000160E0000000321}0000000321}000{000000{00000{00000{00001L00000{ 000 000000D000000A000001I000000E000003G000001B000002{000002E000000E000002I071100201000000000000000810310</Body>
</Detail>
<Detail xmlns="">
<Body>0610610927532201212320100402959900001000K000018140{00003431000000000000000362Q0000686K000001780012934000K00002139000ONE DGFD BEEF&RICE2@PURINA I00010000006100100002012123000018140001601154 18LBY1000177H0012B0002H0008A00000200I0000000401Q0000000401Q000{000000{00000{00000{00001O00000{ 000 000000D000000D000002E000000D000003I000001I000002{000003{000000E000003F071100201000000000000000810310</Body>
</Detail>
<Detail xmlns="">
<Body>061061092753220121233019999999990000001613K0000005I0000001607L00001}0001635K00000{00000{00000{00000{00000{000001823Q0000000000000000000001-01-01I0001000000610010000201212300130R0000010000001473200001442R000103N000027M000039M0000001613K0000001607L00000000{0000000{0000000{0000005R00000000{000039M00000000005Q000003Q000018Q000004Q000036M000012}000019P000024O000005}0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610610928945201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000001620121230000000000019289450000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061092894520121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010016201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610611042912201212319500000000000001000J001042050}00000000000000000000010420N0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000002020121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000010420N000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061104291220121233959999999990000010420N0000000{0000010420N00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010020201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000010420N00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610611042912201212319500000000000001000J000060560}00000000000000000000000605O0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000002120121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000000605O000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061104291220121233959999999990000000605O0000000{0000000605O00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010021201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000605O00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610611927533201212320500711787400012000J000021720{00001013000000000000000217K0000101L000001380010340000J00000263000MACARONI & CHEESE 2@STOUFER#I00050000006100100002012123000021720001608894 12OZY1000212H0019G0003H0001I00000238B0000000238K0000000238K000{000000{00000{00000{00000N00000{ 000 000001F000000C000003B000001E000006D000002G000002D000005A000000C000004D014507801000000000000000810325</Body>
</Detail>
<Detail xmlns="">
<Body>061061192753320121233059999999990000000238K0000000E0000000237P00000J0000101L00000{00000{00000{00000{00000{000000315O0000000000000000000001-01-01I0005000000610010000201212300023N0000010000000217200000212Q000019P000003Q000001R0000000238K0000000237P00000000{0000000{0000000{0000000N00000000{000001R00000000001O000000L000003K000001N000006M000002P000002M000005J000000L0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610611928946201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000001920121230000000000019289460000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061192894620121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010019201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610612042912201212319500000000000001000J001340890}00000000000000000000013408R0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000002320121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000013408R000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061204291220121233959999999990000013408R0000000{0000013408R00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010023201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000013408R00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610612042912201212319500000000000001000J000086560}00000000000000000000000865O0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000002420121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000000865O000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061204291220121233959999999990000000865O0000000{0000000865O00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010024201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000865O00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610612928947201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000002220121230000000000019289470000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061292894720121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010022201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610612937405201212322000627759500006000J000052800{00001000000000000000000528}0000100}000002005921260000J00000000000EXPRESIONS 2BOUQUET I00020000006100100002012123000052800001610297 1EAN1000000{0000{0000{0000{00000000{0000000000{0000000528}000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{713666600000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610612937405201212322000627759500006000A000035200{00001000000000000000000352{0000100{000002005921260000A00000000000EXPRESIONS 2BOUQUET I00021000006100100002012123000035200001610297 1EAN1000000{0000{0000{0000{00000000{0000000000{0000000352{000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{713666600000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610612937405201212322000627760600015000J000066000{00001000000000000000000660}0000100}000002005921259000J00000000000YOU'RE SPECIAL 2BOUQUET I00020000006100100002012123000066000001610297 1EAN1000000{0000{0000{0000{00000000{0000000000{0000000660}000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{713666600000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610612937405201212322000627760600015000A000044000{00001000000000000000000440{0000100{000002005921259000A00000000000YOU'RE SPECIAL 2BOUQUET I00021000006100100002012123000044000001610297 1EAN1000000{0000{0000{0000{00000000{0000000000{0000000440{000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{713666600000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610612937405201212322000627761100010000J000055370{00001000000000000000000553P0000100}000002005910111000J00000000000ROSE MIX 2BOUQUET I00020000006100100002012123000055370001610297 1EAN1000000{0000{0000{0000{00000000{0000000000{0000000553P000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{713666600000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610612937405201212322000627761100010000A000027690{00001000000000000000000276I0000100{000002005910111000A00000000000ROSE MIX 2BOUQUET I00021000006100100002012123000027690001610297 1EAN1000000{0000{0000{0000{00000000{0000000000{0000000276I000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{713666600000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610612937405201212322000627786600015000J000033350{00001500000000000000000333N0000150}000002005917313000J00000000000GERBERA CB 2BUNCH I00020000006100100002012123000033350001610297 1EAN1000000{0000{0000{0000{00000000{0000000000{0000000333N000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{597444900000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610612937405201212322000627786600015000A000020010{00001500000000000000000200A0000150{000002005917313000A00000000000GERBERA CB 2BUNCH I00021000006100100002012123000020010001610297 1EAN1000000{0000{0000{0000{00000000{0000000000{0000000200A000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{597444900000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061293740520121233209999999990000000806K0000000{0000000806K00000{0000000{00000{00000{00000{00000{00806K000000000{0000000000000000000001-01-01I0002000000610010000201212300000{0000010000000806200000000{000000{000000{000000{0000000000{0000000806K00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610613042912201212319500000000000001000J001458280}00000000000000000000014582Q0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000002620121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000014582Q000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061304291220121233959999999990000014582Q0000000{0000014582Q00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010026201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000014582Q00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610613042912201212319500000000000001000J000088690}00000000000000000000000886R0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000002720121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000000886R000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061304291220121233959999999990000000886R0000000{0000000886R00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010027201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000886R00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610613927534201212320100000000000001000K000020000{00000000000000000000000400}0000000{000000000000000000K00000000000 I00011000006100100002012123000020000001608816 Y1000200{0000{0000{0000{00000200{0000000400}0000000400}000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000810324</Body>
</Detail>
<Detail xmlns="">
<Body>061061392753420121233019999999990000000400}0000000{0000000400}00000K0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000001-01-01I0001000000610010000201212300000{0000010000000400000000400}000000{000000{000000{0000000400}0000000400}00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610613927535201212320100310019600012000J000019080{00001331000000000000000190Q0000133J000001600040981000J00000179000SM WHITE CAKE MIX 2B CROCKERI0001000000610010000201212300001908000160972916.25OZY1000186B0015G0003A0003{00000208{0000000208}0000000208}000{000000{00000{00000{00000P00000{ 000 000003F000000E000002{000001E000004B000001B000002A000003B000000E000004F032526604000000000000000808474</Body>
</Detail>
<Detail xmlns="">
<Body>0610613927535201212320100310019600012000A000010400{00001331000000000000000104{0000133A000001600040981000A00000179000SM WHITE CAKE MIX 2B CROCKERI0001100000610010000201212300001040000160972916.25OZY1000104{0000{0000{0000{00000104{0000000104{0000000104{000{000000{00000{00000{00000D00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{032526604000000000000000808474</Body>
</Detail>
<Detail xmlns="">
<Body>061061392753520121233019999999990000000104}0000000C0000000103P00000{0000000{00000{00000{00000{00000{00003A000000000{0000000000000000000001-01-01I0001000000610010000201212300018Q0000010000000086800000082K000015P000003J000003}0000000104}0000000103P00000000{0000000{0000000{0000000L00000000{000003}00000000003O000000N000002}000001N000004K000001K000002J000003K000000N0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610613928948201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000002520121230000000000019289480000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061392894820121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010025201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610614042912201212319500000000000001000J001526470}00000000000000000000015264P0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000002920121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000015264P000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061404291220121233959999999990000015264P0000000{0000015264P00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010029201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000015264P00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610614042912201212319500000000000001000J000100440}00000000000000000000001004M0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000003020121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000001004M000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061404291220121233959999999990000001004M0000000{0000001004M00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010030201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000001004M00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610614928949201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000002820121230000000000019289490000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061492894920121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010028201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610614930230201212321200941442500004000J000026810{00000650000000000000000268J0000065}000007173600122000J00001147000NO KNEES FLR SCRUB2LIBMAN I00120500006100100002012123000026810001564641 1EAY1000268A0032A0000{0010A00000310C0000000310L0000000310L000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000C000000{000000F000000{000000{000000{049341100000000000000000809157</Body>
</Detail>
<Detail xmlns="">
<Body>061061493023020121233129999999990000000310L0000000{0000000310L00000J0000065}00000{00000{00000{00000{00000{000000458Q0000000000000000000001-01-01I0012050000610010000201212300032J0000010000000268100000268J000032J000000{000010J0000000310L0000000310L00000000{0000000{0000000{0000000{00000000{000010J00000000000{000000{000000{000000{000000L000000{000000O000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610616042912201212319500000000000001000J001350500}00000000000000000000013505}0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000003220121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000013505}000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061604291220121233959999999990000013505}0000000{0000013505}00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010032201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000013505}00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610616042912201212319500000000000001000J000079250}00000000000000000000000792N0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000003320121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000000792N000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061604291220121233959999999990000000792N0000000{0000000792N00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010033201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000792N00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610616928950201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000003120121230000000000019289500000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061692895020121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010031201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610616930231201212321200868700200006000J000014870{00000450000000000000000148P0000045}000074837800322000J00000333000BUBBLE GUM 2PINHEAD I001201000061001000020121230000148700016055938 OZY1000129H0026A0000{0001C00000157B0000000157K0000000157K000{000000{00000{00000{00000{00000{ 000 000002F000002{000002E000001B000004A000003F000005E000004C000000C000018I753603214000000000000000809352</Body>
</Detail>
<Detail xmlns="">
<Body>0610616930231201212321200880035500004000J000030260{00001500000000000000000266O0000150}000004167967466000J00000885000VANILLA DRINK 6 PK2BOOST I00120100006100100002012123000030260001605593 48FZY1000281A0037D0000{0002B00000284G0000000284P0000000284P000{000036{00000{00000{00000{00000{ 000 000002A000000A000004H000001B000005F000006I000007B000009B000000C000021E014507810000000000000000809352</Body>
</Detail>
<Detail xmlns="">
<Body>0610616930231201212321200880107900004000J000037830{00001450000000000000000378L0000145}000007007451787000J00001059000PLUS BUTRPECAN BTL2ENSURE I00120100006100100002012123000037830001605593 6PKY1000341{0041F0000{0002F00000385B0000000385K0000000385K000{000000{00000{00000{00000{00000{ 000 000001B000000B000005F000001{000006B000008A000007G000011C000000C000037C073879902000000000000000809352</Body>
</Detail>
<Detail xmlns="">
<Body>061061693023120121233129999999990000000827J0000000{0000000827J00000L0000340}00000{00000{00000{00000{00000{000000977M0000000000000000000001-01-01I0012010000610010000201212300105J0000010000000829600000751R000105J000000{000006J0000000863J0000000827J00000036}0000000{0000000{0000000{00000000{000006J00000000005R000002L000012R000003M000015R000018O000020M000024Q000000R0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610617042912201212319500000000000001000J001933660}00000000000000000000019336O0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000003520121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000019336O000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061704291220121233959999999990000019336O0000000{0000019336O00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010035201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000019336O00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610617042912201212319500000000000001000J000119440}00000000000000000000001194M0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000003620121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000001194M000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061704291220121233959999999990000001194M0000000{0000001194M00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010036201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000001194M00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610617927536201212320500714745500008000J000015040{00000550000000000000000150M0000055}000004369508305000J00000269000PEPPERNI PIZZA 2PK2@LN PCKT#I00050000006100100002012123000015040001599945 9OZY1000147C0016{0003A0002D00000168H0000000168Q0000000168Q000{000000{00000{00000{00000L00000{ 000 000001D000000B000002G000002{000004I000001H000002C000003F000000B000003A014507811000000000000000806101</Body>
</Detail>
<Detail xmlns="">
<Body>061061792753620121233059999999990000000168Q0000000C0000000168N00000J0000055}00000{00000{00000{00000{00000{000000215K0000000000000000000001-01-01I0005000000610010000201212300019J0000010000000150400000147L000016}000003J000002M0000000168Q0000000168N00000000{0000000{0000000{0000000L00000000{000002M00000000001M000000K000002P000002}000004R000001Q000002L000003O000000K0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610617928951201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000003420121230000000000019289510000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061792895120121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010034201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610617930232201212321200861039900008000J000019260{00001219000000000000000192O0000121R000004116346998000J00000297000BABY WIPES TUB FF 2B BASICS I0012010000610010000201212300001926000161048572 CTY1000138H0035C0000{0005A00000179B0000000179K0000000179K000{000000{00000{00000{00000{00000{ 000 000000C000000A000006B000001D000004A000008{000010D000004D000000D000053H038006301000000000000000801033</Body>
</Detail>
<Detail xmlns="">
<Body>0610617930232201212321200861039900008000A000013440{00001219000000000000000134D0000121I000004116346998000A00000297000BABY WIPES TUB FF 2B BASICS I0012110000610010000201212300001344000161048572 CTY1000134D0000{0000{0000{00000134D0000000134D0000000134D000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{038006301000000000000000801033</Body>
</Detail>
<Detail xmlns="">
<Body>061061793023220121233129999999990000000044Q0000000{0000000044Q00000{0000000{00000{00000{00000{00000{00004M000000000{0000000000000000000001-01-01I0012010000610010000201212300035L0000010000000058200000004M000035L000000{000005J0000000044Q0000000044Q00000000{0000000{0000000{0000000{00000000{000005J00000000000L000000J000006K000001M000004J000008}000010M000004M000000M0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610618042912201212319500000000000001000J002264800}00000000000000000000022648}0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000003820121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000022648}000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061804291220121233959999999990000022648}0000000{0000022648}00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010038201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000022648}00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610618042912201212319500000000000001000J000128690}00000000000000000000001286R0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000003920121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000001286R000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061804291220121233959999999990000001286R0000000{0000001286R00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010039201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000001286R00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610618928952201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000003720121230000000000019289520000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061892895220121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010037201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610619042912201212319500000000000001000J001970550}00000000000000000000019705N0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000004120121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000019705N000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061904291220121233959999999990000019705N0000000{0000019705N00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010041201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000019705N00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610619042912201212319500000000000001000J000121630}00000000000000000000001216L0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000004220121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000001216L000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061904291220121233959999999990000001216L0000000{0000001216L00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010042201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000001216L00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610619928953201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000004020121230000000000019289530000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061992895320121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010040201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610619930233201212321200880109400003000J000027460{00001319000000000000000274O0000131R000007007450514000J00001073000HIPRTN CHC SHK 4PK2ENSURE I00120100006100100002012123000027460001554616 56FZY1000232E0031H0000{0003{00000267C0000000267L0000000267L000{000000{00000{00000{00000{00000{ 000 000001C000000B000004I000001A000005B000003G000007A000008A000000B000042A073879902000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061993023320121233129999999990000000267L0000000{0000000267L00000J0000131R00000{00000{00000{00000{00000{000000321R0000000000000000000001-01-01I0012010000610010000201212300031Q0000010000000274600000232N000031Q000000{000003}0000000267L0000000267L00000000{0000000{0000000{0000000{00000000{000003}00000000001L000000K000004R000001J000005K000003P000007J000008J000000K0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610619930234201212321200851250700048000J000132350{00006325000000000000001323N0000632N000060308400000000J00000329000S/C SIDECAP 2FRUCTIS I00120400106100100002012123000132350001554641 13OZY1001173E0105I0000{0027A00001306E0000001306N0000001306N000{000000{00000{00000{00003J00000{S000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000150{695666804000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061061993023420121233129999999990000001306N0000003A0000001303M00000J0000632N00000{00000{00000{00000{00000{000001579K0000000000000000000001-01-01I0012040000610010000201212300105R0000010000001323500001173N000105R000000{000027J0000001306N0000001303M00000000{0000000{0000000{0000003J00000000{000027J00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610621042912201212319500000000000001000J002020910}00000000000000000000020209J0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000004420121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000020209J000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062104291220121233959999999990000020209J0000000{0000020209J00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010044201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000020209J00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610621042912201212319500000000000001000J000128250}00000000000000000000001282N0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000004520121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000001282N000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062104291220121233959999999990000001282N0000000{0000001282N00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010045201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000001282N00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610621928954201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000004320121230000000000019289540000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062192895420121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010043201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610622042912201212319500000000000001000J001628260}00000000000000000000016282O0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000004720121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000016282O000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062204291220121233959999999990000016282O0000000{0000016282O00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010047201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000016282O00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610622042912201212319500000000000001000J000104560}00000000000000000000001045O0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000004820121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000001045O000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062204291220121233959999999990000001045O0000000{0000001045O00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010048201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000001045O00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610622927537201212320300682525400018000J000001790{00002335000000000000000418{0000233N100004420069506000J00000001000HAM SLCD SMKD SHNK2COOKS# I0003020010610VW00002012123000001790001598353 1.6LBN1000000{0000{0000{0000{00000000{0000000000{0000000418{000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{085151901000000000000230810388</Body>
</Detail>
<Detail xmlns="">
<Body>061062292753720121233039999999990000000418{0000859}0000000441}00000J0000233E00000{00000{00000{00000{00000{000000002L0000000000000000000001-01-01I0003020000610010000201212300023}0000010000000417900000000{000000{000000{000000{0000000000{0000000441}00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610622928955201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000004620121230000000000019289550000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062292895520121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010046201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610622930235201212321200866095600006000J000030110{00000600000000000000000245P0000060}000007940019412000J00000653000COOL SPT MINT SH 2CLEAR I0012010000610010000201212300003011000161012712.9 FZY1000274E0043C0000{0001F00000264{0000000264}0000000264}000{000055D00000{00000{00000N00000{ 000 000001G000000E000015G000000D000005E000005B000004I000009A000000C000026F049035903000000000000000809407</Body>
</Detail>
<Detail xmlns="">
<Body>061062293023520121233129999999990000000264}0000000E0000000263N00000J0000060}00000{00000{00000{00000{00000{000000391Q0000000000000000000001-01-01I0012010000610010000201212300043L0000010000000301100000274N000043L000000{000001O0000000319M0000000263N00000055M0000000{0000000{0000000N00000000{000001O00000000001P000000N000015P000000M000005N000005K000004R000009J000000L0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610623042912201212319500000000000001000J001480640}00000000000000000000014806M0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000005020121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000014806M000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062304291220121233959999999990000014806M0000000{0000014806M00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010050201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000014806M00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610623042912201212319500000000000001000J000099880}00000000000000000000000998Q0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000005120121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000000998Q000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062304291220121233959999999990000000998Q0000000{0000000998Q00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010051201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000998Q00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610623927538201212320500714743700008000J000015040{00000563000000000000000150M0000056L000004369508306000J00000269000CHKN FAJTA LN PCKT2LEAN PKT#I00050000006100100002012123000015040001610522 9OZY1000147C0016D0003{0001I00000168F0000000168O0000000168O000{000000{00000{00000{00000L00000{ 000 000001B000000I000002I000001G000004H000001H000002C000003F000000B000003A014507811000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062392753820121233059999999990000000168O0000000C0000000168L00000J0000056L00000{00000{00000{00000{00000{000000215K0000000000000000000001-01-01I0005000000610010000201212300019M0000010000000150400000147L000016M000003}000001R0000000168O0000000168L00000000{0000000{0000000{0000000L00000000{000001R00000000001K000000R000002R000001P000004Q000001Q000002L000003O000000K0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610623928956201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000004920121230000000000019289560000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062392895620121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010049201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610625042912201212319500000000000001000J001697140}00000000000000000000016971M0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000005320121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000016971M000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062504291220121233959999999990000016971M0000000{0000016971M00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010053201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000016971M00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610625042912201212319500000000000001000J000107060}00000000000000000000001070O0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000005420121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000001070O000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062504291220121233959999999990000001070O0000000{0000001070O00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010054201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000001070O00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610625928957201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000005220121230000000000019289570000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062592895720121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010052201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610625930236201212321200892480000006000J000014130{00000338000000000000000141L0000033Q000007385200939000J00000335000PUMP ALOE 2PURELL I00120100006100100002012123000014130001610418 8OZY1000128H0019A0000{0000H00000148G0000000148P0000000148P000{000000{00000{00000{00000{00000{ 000 000000{000000E000002G000000E000004E000002F000003H000004C000000B000012E659203400000000000000000799608</Body>
</Detail>
<Detail xmlns="">
<Body>061062593023620121233129999999990000000148P0000000{0000000148P00000J0000033Q00000{00000{00000{00000{00000{000000201}0000000000000000000001-01-01I0012010000610010000201212300019J0000010000000141300000128Q000019J000000{000000Q0000000148P0000000148P00000000{0000000{0000000{0000000{00000000{000000Q00000000000{000000N000002P000000N000004N000002O000003Q000004L000000K0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610626042912201212319500000000000001000J000882030}00000000000000000000008820L0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000005720121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000008820L000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062604291220121233959999999990000008820L0000000{0000008820L00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010057201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000008820L00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610626042912201212319500000000000001000J000052560}00000000000000000000000525O0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000005820121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000000525O000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062604291220121233959999999990000000525O0000000{0000000525O00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010058201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000525O00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610626927487201212310100000000000001000J000007120}00000000000000000000000071K0000000{000000000000000000J00000000000CIGARETTE RETURN 0000000000S2401000 0061000005520121230000000000019274870000000N0000000{0000{0000{0000{00000000{0000000000{0000000071K000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062692748720121233019999999990000000071K0000000{0000000071K00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2401000000610010055201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000071K00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610626928958201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000005620121230000000000019289580000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062692895820121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010056201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610627042912201212319500000000000001000J000947190}00000000000000000000009471R0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000006020121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000009471R000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062704291220121233959999999990000009471R0000000{0000009471R00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010060201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000009471R00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610627042912201212319500000000000001000J000058250}00000000000000000000000582N0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000006120121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000000582N000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062704291220121233959999999990000000582N0000000{0000000582N00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010061201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000582N00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610627928959201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000005920121230000000000019289590000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062792895920121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010059201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610627930237201212321200881840600003000K000043180{00000350000000000000000863O0000070}000003076833750000K00001949000FISH OIL 1000 MG 2SUNDOWN I00120100006100100002012123000043180001554668 300CTY1000305A0000{0000{0000{00000305A0000000610K0000000610K000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000126G731718902000000000000000802292</Body>
</Detail>
<Detail xmlns="">
<Body>061062793023720121233129999999990000000610K0000000{0000000610K00000K0000070}00000{00000{00000{00000{00000{000001169M0000000000000000000001-01-01I0012010000610010000201212300000{0000010000000863600000610K000000{000000{000000{0000000610K0000000610K00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610627930238201212321200877148600006000J000054920{00000088000000000000000549K0000008Q000031284353640000J00001075000LW DOSE 81MG ASPRN2BAYER I00120100006100100002012123000054920001565996 200CTY1000494C0043D0000{0000F00000538C0000000538L0000000538L000{000000{00000{00000{00003K00000{ 000 000002D000000C000005E000000F000008A000005E000004E000016B000000C000054I054957601000000000000000809428</Body>
</Detail>
<Detail xmlns="">
<Body>061062793023820121233129999999990000000538L0000003B0000000535J00000J0000008Q00000{00000{00000{00000{00000{000000645}0000000000000000000001-01-01I0012010000610010000201212300043M0000010000000549200000494L000043M000000{000000O0000000538L0000000535J00000000{0000000{0000000{0000003K00000000{000000O00000000002M000000L000005N000000O000008J000005N000004N000016K000000L0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610627930239201212321200868251000006000J000026670{00000600000000000000000266P0000060}000003404412659000J00000000000SUPER HOLD UNSCTED2SALN GRFXI0012010000610010000201212300002667000161045312.5 OZY1000235B0041B0000{0001A00000277E0000000277N0000000277N000{000000{00000{00000{00000{00000{ 000 000000O000015{000003G000001{000005A000003A000005I000007G000000C000031E732588601000000000000000801036</Body>
</Detail>
<Detail xmlns="">
<Body>061062793023920121233129999999990000000277N0000000{0000000277N00000J0000060}00000{00000{00000{00000{00235K000000000{0000000000000000000001-01-01I0012010000610010000201212300041K0000010000000266700000235K000041K000000{000001J0000000277N0000000277N00000000{0000000{0000000{0000000{00000000{000001J00000000000F000015}000003P000001}000005J000003J000005R000007P000000L0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610627937406201212322000628709200014000L000006230{00000137000000000000000186R0000041J010089901304366000L00000001000PREM DZ ROSE CB 2BUNCH I00020000006100100002012123000006230001610544 1EAN1000000{0000{0000{0000{00000000{0000000000{0000000186R000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{7522496000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062793740620121233209999999990000000186R0000000{0000000186R00000L0000041L00000{00000{00000{00000{00186R000000004K0000000000000000000001-01-01I0002000000610010000201212300000{0000010000000186900000000{000000{000000{000000{0000000000{0000000186R00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610628042912201212319500000000000001000J001743190}00000000000000000000017431R0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000006320121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000017431R000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062804291220121233959999999990000017431R0000000{0000017431R00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010063201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000017431R00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610628042912201212319500000000000001000J000102940}00000000000000000000001029M0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000006420121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000001029M000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062804291220121233959999999990000001029M0000000{0000001029M00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010064201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000001029M00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610628928960201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000006220121230000000000019289600000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062892896020121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010062201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610628930240201212321200920290500006000J000006600{00000050000000000000000066}0000005}000007245680580000J00000189000POTHOLDER SMOKE 2EXCELLO I00120500006100100002012123000006600001555807 1CTY1000066{0008{0000{0000F00000074F0000000074O0000000074O000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000A000000{000000B000000{000000{000000{678466400000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062893024020121233129999999990000000074O0000000{0000000074O00000J0000005}00000{00000{00000{00000{00000{000000113M0000000000000000000001-01-01I0012050000610010000201212300008}0000010000000066000000066}000008}000000{000000O0000000074O0000000074O00000000{0000000{0000000{0000000{00000000{000000O00000000000{000000{000000{000000{000000J000000{000000K000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610629042912201212319500000000000001000J002052240}00000000000000000000020522M0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000006620121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000020522M000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062904291220121233959999999990000020522M0000000{0000020522M00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010066201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000020522M00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610629042912201212319500000000000001000J000123690}00000000000000000000001236R0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000006720121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000001236R000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062904291220121233959999999990000001236R0000000{0000001236R00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010067201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000001236R00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610629928961201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000006520121230000000000019289610000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061062992896120121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010065201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610630042912201212319500000000000001000J001398990}00000000000000000000013989R0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000007020121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000013989R000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061063004291220121233959999999990000013989R0000000{0000013989R00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010070201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000013989R00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610630042912201212319500000000000001000J000090560}00000000000000000000000905O0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000007120121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000000905O000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061063004291220121233959999999990000000905O0000000{0000000905O00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9299000000610010071201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000905O00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610630927488201212310100000000000001000J000131660}00000000000000000000001316O0000000{000000000000000000J00000000000CIGARETTE RETURN 0000000000S2401000 0061000006820121230000000000019274880000000N0000000{0000{0000{0000{00000000{0000000000{0000001316O000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061063092748820121233019999999990000001316O0000000{0000001316O00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2401000000610010068201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000001316O00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610630928962201212319700000000000001000A000007750{00000000000000000000000077E0000000{000000000000000000A0000000000019 PRICE MGMT 0000000000S2499000 0061000006920121230000000000019289620000000N0000000{0000{0000{0000{00000000{0000000000{0000000077E000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061063092896220121233979999999990000000077E0000000{0000000077E00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010069201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000077E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610631183959201212310100000000000001000A004375500{00000000000000000000043755{0000000{000000000000000000A0000000000016-DIERBERGS REP 0000000000S9201000 0061000007620121230000000000011839590000000N0000000{0000{0000{0000{00000000{0000000000{0000043755{000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061063118395920121233019999999990000043755{0000000{0000043755{00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9201000000610010076201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000043755{00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610631188925201212310100000000000001000A001026200{00000000000000000000010262{0000000{000000000000000000A0000000000016-DIERBERGS REP 0000000000S9201000 0061000007720121230000000000011889250000000N0000000{0000{0000{0000{00000000{0000000000{0000010262{000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061063118892520121233019999999990000010262{0000000{0000010262{00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S9201000000610010077201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000010262{00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610631927553201212320200640812000040091B000015150{00004150000000000000138168{0378480{000000000004011091B00000049000BANANAS GREEN 2CHIQUITA I00021000006101400002012123000015150001000000 1LBN1000000{0000{0000{0000{00000000{0000000000{0000138168{000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{50865740100000000000000079288</Body>
</Detail>
<Detail xmlns="">
<Body>0610631927553201212320200648114000040004H000019450{00004400000000000000009336{0021120{000007490494011004H00000117000ORGANIC YEL BANANA2CHIQUITA I00021000006101400002012123000019450001000000 1LBN1000000{0000{0000{0000{00000000{0000000000{0000009336{000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{50865740100000000000000079288</Body>
</Detail>
<Detail xmlns="">
<Body>061063192755320121233029999999990000147504{0000000{0000147504{00096{0399600{00000{00000{00000{00000{00000{000201216{0000000000000000002012-04-30I0002000000610010000201212300000{0000010000147504000000000{000000{000000{000000{0000000000{0000147504{00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610631927554201212320200640812000040095H000015150{00004150000000000000145137{0397570{000000000004011095H00000049000BANANAS GREEN 2CHIQUITA I00021000006101400002012123000015150001000000 1LBN1000000{0000{0000{0000{00000000{0000000000{0000145137{000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{50865740100000000000000079403</Body>
</Detail>
<Detail xmlns="">
<Body>061063192755420121233029999999990000145137{0000000{0000145137{00095H0397570{00000{00000{00000{00000{00000{000187768{0000000000000000002012-05-02I0002000000610010000201212300000{0000010000145137000000000{000000{000000{000000{0000000000{0000145137{00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610631927555201212320200642576200005145G000009750{00004300000000000000142057E0626510{000007490406002145G00000623000GOLD PINEAPPLES 2CHIQUITA I00021000006101400002012123000009750001000000 5CTN1000000{0000{0000{0000{00000000{0000000000{0000142057E000{000000{00000{00000{00000{00000{ 000 000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{73672420000000000000000079403</Body>
</Detail>
<Detail xmlns="">
<Body>061063192755520121233029999999990000142057E0000000{0000142057E00145G0626510{00000{00000{00000{00000{00000{000453855E0000000000000000002012-05-02I0002000000610010000201212300000{0000010000142057500000000{000000{000000{000000{0000000000{0000142057E00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610631928963201212319900000000000001000A000032000{00000000000000000000000320{0000000{000000000000000000A0000000000015SV HARBOR USER 0000000000S2499000 0061000007320121230000000000019289630000000N0000000{0000{0000{0000{00000000{0000000000{0000000320{000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061063192896320121233999999999990000000320{0000000{0000000320{00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010073201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000320{00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610631928964201212319900000000000001000A000197260{00000000000000000000001972F0000000{000000000000000000A0000000000015ISDM/SIL 0000000000S2499000 0061000007420121230000000000019289640000000N0000000{0000{0000{0000{00000000{0000000000{0000001972F000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061063192896420121233999999999990000001972F0000000{0000001972F00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010074201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000001972F00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610631928965201212319900000000000001000A000010000{00000000000000000000000100{0000000{000000000000000000A0000000000015SV HARBOR REV 0000000000S2499000 0061000007520121230000000000019289650000000N0000000{0000{0000{0000{00000000{0000000000{0000000100{000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061063192896520121233999999999990000000100{0000000{0000000100{00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2499000000610010075201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000000100{00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>0610631928966201212311200000000000001000J000564480}00000000000000000000005644Q0000000{000000000000000000J00000000000COLGATE CMAP 0000000000S2412000 0061000007220121230000000000019289660000000N0000000{0000{0000{0000{00000000{0000000000{0000005644Q000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>
</Detail>
<Detail xmlns="">
<Body>061063192896620121233129999999990000005644Q0000000{0000005644Q00000{0000000{00000{00000{00000{00000{00000{000000000{0000000000000000000000000000S2412000000610010072201212300000{0000010000000000000000000{000000{000000{000000{0000000000{0000005644Q00000000{0000000{0000000{0000000{00000000{000000{00000000000{000000{000000{000000{000000{000000{000000{000000{000000{0000000000000000000000000000000000000</Body>
</Detail>
<Trailing xmlns="">
<Body>000241</Body>
</Trailing>
</Root>
and I have a SP which needs to store the values in respective columns in a table,
how can I acheive this I have a SP but it doens' do anything...:
ALTER PROCEDURE [dbo].[uspLoadJonesInvoiceXML]
@XMLdata XML
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @XMlHeaderID int
-- Main Header Table
insert into tblJonesInvoiceHeaderXML (Header,Trailor)
SELECT t.Item.query('./Header/Body').value('.','NVARCHAR(MAX)') Header,
t.Item.query('./Trailing/Body').value('.','NVARCHAR(MAX)') Trailor
from @XMLdata.nodes('/Root') AS t(Item)
SELECT @XMlHeaderID = @@IDENTITY
insert into tblJonesInvoiceDetailXML (XMlHeaderID,Detail)
SELECT @XMlHeaderID ,
t.Item.query('./Detail /Body').value('.','NVARCHAR(MAX)') Detail
from @XMLdata.nodes('/Root') AS t(Item)
END
''' BUT I AM NOT GETTING ANYTHING.. PLEASE HELP...

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jesse Reich Hall of Fame Points: 3020 More actions · Answer 1

If I could make a couple suggestions for your posts in the future:

1. Try to keep the sample data small. You posted 725 lines of unreadable XML which was hiding a problem that many users on this forum have already solved.

2. All caps when asking for assistance is probably unnecessary. I think you will find plenty of help here by asking in a "regular" written voice.

That said, here is a condensed sample of your data:

<Root xmlns="http://Supervalu.JonesNewInvoiceFlatFileSchema">

<Header xmlns="">

<Body>201212403113INVOICE 061SV01986</Body>

</Header>

<Detail xmlns="">

<Body>0610605042912201212319500000000000001000J001221650}00000000000000000000012216N0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000000220121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000012216N000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>

</Detail>

<Trailing xmlns="">

<Body>000241</Body>

</Trailing>

</Root>

I think the problem is your T-SQL code is not referencing the namespace that is associated with the <Root> node.

I was able to put together a solution based on the example here:

http://msdn.microsoft.com/en-us/library/ms188282.aspx

DECLARE @XMLdata XML

SET @XMLdata = '

<Root xmlns="http://Supervalu.JonesNewInvoiceFlatFileSchema">

<Header xmlns="">

<Body>201212403113INVOICE 061SV01986</Body>

</Header>

<Detail xmlns="">

<Body>0610605042912201212319500000000000001000J001221650}00000000000000000000012216N0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000000220121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000012216N000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>

</Detail>

<Trailing xmlns="">

<Body>000241</Body>

</Trailing>

</Root>'

/**************************************************************

I've commented out your INSERT statements and the setting of

@@IDENTITY in order to have a simple example

**************************************************************/

-- insert into tblJonesInvoiceHeaderXML (Header,Trailor)

SELECT t.Item.query('./Header/Body').value('.','NVARCHAR(MAX)') Header,

t.Item.query('./Trailing/Body').value('.','NVARCHAR(MAX)') Trailor

from @XMLdata.nodes('declare namespace ns="http://Supervalu.JonesNewInvoiceFlatFileSchema"; ns:Root') AS t(Item)

--

-- See above: declaring the namespace as ns and then associating ns with Root

--

DECLARE @XMLHeaderID INT

-- SELECT @XMlHeaderID = @@IDENTITY

-- insert into tblJonesInvoiceDetailXML (XMlHeaderID,Detail)

SELECT @XMlHeaderID,

t.Item.query('./Detail /Body').value('.','NVARCHAR(MAX)') Detail

from @XMLdata.nodes('declare namespace ns="http://Supervalu.JonesNewInvoiceFlatFileSchema"; ns:Root') AS t(Item)

/**************************************************************

Results:

Header Trailor

---------------------------------------------- --------

201212403113INVOICE 061SV01986 000241

(1 row(s) affected)

Detail

----------- ----------------------------------------------------------

NULL 0610605042912201212319500000000000001000J001221650}000000...

(1 row(s) affected)

**************************************************************/

vsoneta SSC Rookie Points: 32 More actions · Answer 2

Thank you so much Jessy for your help.

But in detail table, i just get only 1 row(everything is in one record only)instead of many rows, if the input has many, how can i achieve this.

<Body>201212403113INVOICE 061SV01986</Body>

</Header>

<Body>0610605042912201212319500000000000001000J001221650}00000000000000000000012216N0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000000220121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000012216N000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>

</Detail>

<Body>0610605042912201212319500000000000001000J001221650}00000000000000000000012216N0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000000220121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000012216N000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>

</Detail>

</Trailing>

</Root>'

Jesse Reich Hall of Fame Points: 3020 More actions · Answer 3

There is quite a bit of explanation involved so I included it all in the comments within the code. Hope this helps:

DECLARE @XMLdata XML

SET @XMLdata = '

<Root xmlns="http://Supervalu.JonesNewInvoiceFlatFileSchema">

<Header xmlns="">

<Body>201212403113INVOICE 061SV01986</Body>

</Header>

<Detail xmlns="">

<Body>AAA0610605042912201212319500000000000001000J001221650}00000000000000000000012216N0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000000220121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000012216N000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>

</Detail>

<Detail xmlns="">

<Body>BBB0610605042912201212319500000000000001000J001221650}00000000000000000000012216N0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000000220121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000012216N000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>

</Detail>

<Trailing xmlns="">

<Body>000241</Body>

</Trailing>

</Root>'

/**************************************************************

The .nodes method returns a row of XML for every node in

the xml which matches the XQuery. In this case, the

XQuery is ns:Root, so it returns one row since there is only

one <Root> node in the XML.

***************************************************************/

SELECT t.Item.query('.') AS xml_value

FROM @XMLdata.nodes('declare namespace ns="http://Supervalu.JonesNewInvoiceFlatFileSchema"; ns:Root') AS t(Item)

/**************************************************************

Here is an example of .nodes returning two rows from a

different XQuery: ns:Root/Detail

***************************************************************/

SELECT t.Item.query('.') AS xml_value

FROM @XMLdata.nodes('declare namespace ns="http://Supervalu.JonesNewInvoiceFlatFileSchema"; ns:Root/Detail') AS t(Item)

/**************************************************************

The .query specifies an XQuery against an instanace of an

xml object. So if I use .nodes to return a match for all

nodes with <Root>, I will get one xml object returned.

Then I can query that xml object for the data in the body

node under the header node

***************************************************************/

SELECT t.Item.query('./Header/Body') AS xml_value

FROM @XMLdata.nodes('declare namespace ns="http://Supervalu.JonesNewInvoiceFlatFileSchema"; ns:Root') AS t(Item)

/**************************************************************

Now I have the data I want, but it's in xml, so I need to

convert it to the data type for my table. The .value method

performs an XQuery against the xml and returns it as a SQL

data type.

***************************************************************/

SELECT t.Item.query('./Header/Body').value('.','NVARCHAR(MAX)') AS Header

FROM @XMLdata.nodes('declare namespace ns="http://Supervalu.JonesNewInvoiceFlatFileSchema"; ns:Root') AS t(Item)

/**************************************************************

You can use this same process to also get the Trailer value.

But if you have multiple headers or trailers in a single <Root>

node then this is only going to return one value. It appears

that .query only gets the first instance of the match for the

XQuery.

***************************************************************/

SELECT

t.Item.query('./Header/Body').value('.','NVARCHAR(MAX)') AS Header,

t.Item.query('./Trailing/Body').value('.','NVARCHAR(MAX)') AS Trailer

FROM @XMLdata.nodes('declare namespace ns="http://Supervalu.JonesNewInvoiceFlatFileSchema"; ns:Root') AS t(Item)

/**************************************************************

This is why the original code was failing to return multiple

detail values. Our XQuery was looking for all nodes that matched

<Root> in the xml but there was only one. So we only got

the first query result for Detail returned from that one node.

We need to do an XQuery for all <Detail> nodes under <Root>

and then query the <Body> node in order to get the data.

***************************************************************/

SELECT

t.Item.query('Body').value('.','NVARCHAR(MAX)') Detail

FROM @XMLdata.nodes('declare namespace ns="http://Supervalu.JonesNewInvoiceFlatFileSchema"; ns:Root/Detail') AS t(Item)

vsoneta SSC Rookie Points: 32 More actions · Answer 4

Once again thank you so much Jesse for your detailed explanation, now I understood as to how the query works for different scenarios.

Thank you so much.

vsoneta SSC Rookie Points: 32 More actions · Answer 5

How about the query from table

ie I have the whole file in column of a table then how would the query look like

I have a table --tblXMLData which has XMLData xml datatype

which has the data --

<Body>201215203105INVOICE 061SV02014</Body>

</Header>

<Body>0610605052712201215119500000000000001000J001763080}00000000000000000000017630Q0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000000320121510000000000010527120000000N0000000{0000{0000{0000{00000000{0000000000{0000017630Q000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>

</Detail>

</Detail>

</Trailing>

</Root>

then how would the below query get from the table ?--

insert into tblJonesInvoiceHeaderXML (Header,Trailor,createddate)

SELECT t.Item.query('./Header/Body').value('.','NVARCHAR(MAX)') Header

,t.Item.query('./Trailing/Body').value('.','NVARCHAR(MAX)') Trailor

,GETDATE()

from @XMLdata.nodes('declare namespace ns="http://Supervalu.JonesNewInvoiceFlatFileSchema";ns:Root') AS t(Item)

SELECT @XMLHeaderID = @@IDENTITY

insert into tblJonesInvoiceDetailXML (XMLHeaderID,Detail)

SELECT @XMlHeaderID ,

t.Item.query('Body').value('.','NVARCHAR(MAX)') Detail

from @XMLdata.nodes('declare namespace ns="http://Supervalu.JonesNewInvoiceFlatFileSchema"; ns:Root/Detail') AS t(Item)

Jesse Reich Hall of Fame Points: 3020 More actions · Answer 6

Here is another sample which will allow you to get the header, trailer, and body data for each row of XML:

/*********************************************************************************

Set up XML data for two rows in a sample table

**********************************************************************************/

DECLARE

@xml1 XML,

@xml2 XML

SET @xml1 = '

<Root xmlns="http://Supervalu.JonesNewInvoiceFlatFileSchema">

<Header xmlns="">

<Body>201212403113INVOICE 061SV01986</Body>

</Header>

<Detail xmlns="">

<Body>AAA0610605042912201212319500000000000001000J001221650}00000000000000000000012216N0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000000220121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000012216N000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>

</Detail>

<Detail xmlns="">

<Body>BBB0610605042912201212319500000000000001000J001221650}00000000000000000000012216N0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000000220121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000012216N000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>

</Detail>

<Trailing xmlns="">

<Body>000241</Body>

</Trailing>

</Root>'

SET @xml2 = '

<Root xmlns="http://Supervalu.JonesNewInvoiceFlatFileSchema">

<Header xmlns="">

<Body>201212403114INVOICE 999ABC1234</Body>

</Header>

<Detail xmlns="">

<Body>YYY0610605042912201212319500000000000001000J001221650}00000000000000000000012216N0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000000220121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000012216N000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>

</Detail>

<Detail xmlns="">

<Body>ZZZ0610605042912201212319500000000000001000J001221650}00000000000000000000012216N0000000{000000000000000000J0000000000020-95 CREDIT COU 0000000000S9299000 0061000000220121230000000000010429120000000N0000000{0000{0000{0000{00000000{0000000000{0000012216N000{000000{00000{00000{00000{00000{00000000000000000000{000000{000000{000000{000000{000000{000000{000000{000000{000000{000000000000000000000000000000</Body>

</Detail>

<Trailing xmlns="">

<Body>000241</Body>

</Trailing>

</Root>'

/*********************************************************************************

Load the data

**********************************************************************************/

DECLARE @invoices TABLE (ID INT NOT NULL, Data XML)

INSERT @invoices

SELECT 1, @xml1 UNION ALL

SELECT 2, @xml2

/*********************************************************************************

Use the exact same technique as described earlier. The only difference is that

the XML extraction needs to be applied against every row instead of just a single

variable. Use the CROSS APPLY command to achieve this.

Since you will also need the associated Header and Trailer for each row of <Body>

data, use the '../' to go up a level and get the <Header> and <Trailing> XML

**********************************************************************************/

SELECT

t.Item.query('../Header/Body').value('.','NVARCHAR(MAX)') AS Header,

t.Item.query('../Trailing/Body').value('.','NVARCHAR(MAX)') AS Trailer,

t.Item.query('Body').value('.','NVARCHAR(MAX)') Detail

FROM @invoices i

CROSS APPLY i.Data.nodes('declare namespace ns="http://Supervalu.JonesNewInvoiceFlatFileSchema"; ns:Root/Detail') AS t(Item)

The one part I haven't included how to load this flattened data into a normalized table structure. That really depends on your own choice.

One example:

1. Load all your XML data into a staging table

2. Get the distinct headers and load them into your order header table

3. Use the OUTPUT command to capture all the identity values and headers that were inserted

4. Put that data in a temp table

5. Match up the headers in the temp table to the headers in the staging table

6. Use that match to determine the identity value for your <Body> data

7. Insert that into the order detail table.

But that's just my initial thought. You may come up with a more efficient way to approach it.