|
| Hi everybody
the problem is that i cant figure out how to use the table loop fuctoid. And
i cant find any examples that look like my scenario so if anyone can help me
i would be very appriciated
i have looked at mike's blog
http://dallas.sark.com/SarkBlog/mho.../03/15/965.aspx
and looked at a sample project
http://geekswithblogs.net/sthomas/a...0/28/13982.aspx
I have this source doc:
There is a row for each variantEan, notice that MasterEan is the same in
item index 2 and 3
- <ns2:StockMovementInternal
xmlns:ns1="http://PartnerLink.Artifacts.StockMovement.Schemas.StockMovement"
xmlns:ns0="http://PartnerLink.Artifacts.StockMovement.Schemas.PartnerLinkHeader"
xmlns:ns2="http://PartnerLink.Artifacts.StockMovement.Schemas.StockMovementInternal"
xmlns:ns3="http://PartnerLink.Artifacts.StockMovement.Schemas.StoreInformation">
- <ns0:PartnerLinkHeader>
<BAMActivityInstance />
<MessageType>CRD</MessageType>
<Reference>0035</Reference>
<Version>1</Version>
- <EndPoints>
- <Sender>
- <ns3:StoreInformation>
<CountryID>1</CountryID>
<ShopSystem>NCRBT</ShopSystem>
<RegNumber>2</RegNumber>
</ns3:StoreInformation>
</Sender>
- <Receiver>
- <ns3:StoreInformation>
<CountryID>2</CountryID>
<RegNumber>1</RegNumber>
</ns3:StoreInformation>
</Receiver>
</EndPoints>
</ns0:PartnerLinkHeader>
- <ns1:StockMovement>
<ReceivingCompanyRegNumber>1</ReceivingCompanyRegNumber>
<InvoiceType>0035</InvoiceType>
<InvoiceNumber>1</InvoiceNumber>
<Version>1</Version>
<Date>20060431</Date>
<CountryID>2</CountryID>
<ReceiverCurrencyISOCode>1</ReceiverCurrencyISOCode>
<InvoiceDate>20060431</InvoiceDate>
- <Items>
- <Item>
<ItemIndex>1</ItemIndex>
<InvoiceLineNumber>1</InvoiceLineNumber>
<DessinNumber>1</DessinNumber>
<VariantEAN>1111</VariantEAN>
<Subdepartment>1</Subdepartment>
<MasterEAN>5790034</MasterEAN>
<Category>1</Category>
<ItemText>Description bla</ItemText>
<DeliveryDate>1900-01-01</DeliveryDate>
<NetFreightValue>0</NetFreightValue>
<NetUnitPrice>0</NetUnitPrice>
<Quantity>10</Quantity>
<CostPriceExclVAT>100</CostPriceExclVAT>
<SalesPriceInclVAT>1000</SalesPriceInclVAT>
<CostOther>0</CostOther>
</Item>
- <Item>
<ItemIndex>2</ItemIndex>
<InvoiceLineNumber>2</InvoiceLineNumber>
<DessinNumber>2</DessinNumber>
<VariantEAN>2222</VariantEAN>
<Subdepartment>1</Subdepartment>
<MasterEAN>23423432</MasterEAN>
<Category>1</Category>
<ItemText>sdsdf</ItemText>
<DeliveryDate>1900-01-01</DeliveryDate>
<NetFreightValue>0</NetFreightValue>
<NetUnitPrice>0</NetUnitPrice>
<Quantity>5</Quantity>
<CostPriceExclVAT>1000</CostPriceExclVAT>
<SalesPriceInclVAT>10000</SalesPriceInclVAT>
<CostOther>0</CostOther>
</Item>
- <Item>
<ItemIndex>3</ItemIndex>
<InvoiceLineNumber>2</InvoiceLineNumber>
<DessinNumber>2</DessinNumber>
<VariantEAN>3333</VariantEAN>
<Subdepartment>1</Subdepartment>
<MasterEAN>23423432</MasterEAN>
<Category>1</Category>
<ItemText>sdsdf</ItemText>
<DeliveryDate>1900-01-01</DeliveryDate>
<NetFreightValue>0</NetFreightValue>
<NetUnitPrice>0</NetUnitPrice>
<Quantity>5</Quantity>
<CostPriceExclVAT>1000</CostPriceExclVAT>
<SalesPriceInclVAT>10000</SalesPriceInclVAT>
<CostOther>0</CostOther>
</Item>
</Items>
</ns1:StockMovement>
</ns2:StockMovementInternal>
destination doc should look like this:
please observe that a master ean can have many varainat eans.
- <Delivery
xmlns="http://PartnerLink.Artifacts.StockMovement.Schemas.StockMovement_BTSQL">
<DeliveryID>1</DeliveryID>
<DeliveryType>0035</DeliveryType>
<DeliveryDate>20060431</DeliveryDate>
<DeliveryInfo>bla bla</DeliveryInfo>
<ReceiveStore>1</ReceiveStore>
<ReceiveCountry>1</ReceiveCountry>
<ReceiveCurrency>1</ReceiveCurrency>
<SenderStore>2</SenderStore>
<SenderCountry>2</SenderCountry>
<SenderCurrency>2</SenderCurrency>
<Status>1</Status>
<Direction>O</Direction>
<GUID>FDEAE181-992D-46B0-9F1A-E97DCD78BBBE</GUID>
- <Style>
<StyleTableDeliveryID>1</StyleTableDeliveryID>
<StyleLineNumber>1</StyleLineNumber>
<StyleID>1</StyleID>
<MasterEAN>5790034</MasterEAN>
<Category>1</Category>
<Department>1</Department>
<Description>Description bla</Description>
<StyleQty>10</StyleQty>
<CostPrice>100</CostPrice>
<SalesPrice>1000</SalesPrice>
<VatCode>25</VatCode>
<InfoTextReference>1</InfoTextReference>
- <Variant>
<VariantTableDeliveryID>1</VariantTableDeliveryID>
<VariantTableLineNumber>1</VariantTableLineNumber>
<VariantEAN>1111</VariantEAN>
<VariantQty>10</VariantQty>
<Color>red</Color>
<Length>343</Length>
<Size>342</Size>
</Variant>
</Style>
- <Style>
<StyleTableDeliveryID>1</StyleTableDeliveryID>
<StyleLineNumber>2</StyleLineNumber>
<StyleID>2</StyleID>
<MasterEAN>23423432</MasterEAN>
<Category>1</Category>
<Department>1</Department>
<Description>sdsdf</Description>
<StyleQty>10</StyleQty>
<CostPrice>1000</CostPrice>
<SalesPrice>10000</SalesPrice>
<VatCode>19</VatCode>
<InfoTextReference>1</InfoTextReference>
- <Variant>
<VariantTableDeliveryID>1</VariantTableDeliveryID>
<VariantTableLineNumber>2</VariantTableLineNumber>
<VariantEAN>2222</VariantEAN>
<VariantQty>5</VariantQty>
<Color>Purple</Color>
<Length>3423</Length>
<Size>122</Size>
</Variant>
- <Variant>
<VariantTableDeliveryID>1</VariantTableDeliveryID>
<VariantTableLineNumber>2</VariantTableLineNumber>
<VariantEAN>3333</VariantEAN>
<VariantQty>5</VariantQty>
<Color>Purple</Color>
<Length>3423</Length>
<Size>122</Size>
</Variant>
</Style>
</Delivery>
|
|