Back to Collection Items
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @iTmp0 int
-- Important: Do not use nvarchar(max). See the warning about using nvarchar(max).
DECLARE @sTmp0 nvarchar(4000)
-- This example assumes the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
DECLARE @http int
-- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
-- Use this online tool to generate code from sample XML: Generate Code to Create XML
-- The following XML is sent in the request body.
-- <?xml version="1.0" encoding="utf-8"?>
-- <submission>
-- <documents>
-- <document>
-- <issuer>
-- <type>B</type>
-- <id>113317713</id>
-- <name>الشركة المصدرة</name>
-- <address>
-- <buildingNumber>عمارة 40</buildingNumber>
-- <room>123</room>
-- <floor>16</floor>
-- <street>15 احمد فخرى</street>
-- <landmark>مستشفى حسبو</landmark>
-- <additionalInformation>بجانب مستشفى حسبو</additionalInformation>
-- <governate>القاهرة</governate>
-- <regionCity>مدينة نصر</regionCity>
-- <postalCode>098607</postalCode>
-- <country>EG</country>
-- <branchID>1</branchID>
-- </address>
-- </issuer>
-- <receiver>
-- <type>B</type>
-- <id>730913562</id>
-- <name>المستلم</name>
-- <address>
-- <buildingNumber>عمارة 15</buildingNumber>
-- <room>110</room>
-- <floor>8</floor>
-- <street>16 حوش عيسى</street>
-- <landmark>جامع الرحمة</landmark>
-- <additionalInformation>بجانب جامع الرحمة</additionalInformation>
-- <governate>البحيرة</governate>
-- <regionCity>دمنهور</regionCity>
-- <postalCode>098661</postalCode>
-- <country>EG</country>
-- </address>
-- </receiver>
-- <documentType>D</documentType>
-- <documentTypeVersion>0.9</documentTypeVersion>
-- <dateTimeIssued>2020-10-29T17:30:22Z</dateTimeIssued>
-- <taxpayerActivityCode>4620</taxpayerActivityCode>
-- <internalID>IID0</internalID>
-- <purchaseOrderReference>1230</purchaseOrderReference>
-- <purchaseOrderDescription>وصف طلب الدفع</purchaseOrderDescription>
-- <salesOrderReference>1452</salesOrderReference>
-- <salesOrderDescription>وصف بيع الطلب</salesOrderDescription>
-- <proformaInvoiceNumber>1485</proformaInvoiceNumber>
-- <references>
-- <reference>439W9MSDRECAS6HXA9W4PXNE10</reference>
-- </references>
-- <payment>
-- <bankName>البنك الاهلى</bankName>
-- <bankAddress>15 شارع النصر</bankAddress>
-- <bankAccountNo>1234567</bankAccountNo>
-- <bankAccountIBAN/>
-- <swiftCode/>
-- <terms>لا يمكن التزوير</terms>
-- </payment>
-- <delivery>
-- <approach>جوى</approach>
-- <packaging>تغليف</packaging>
-- <dateValidity>2020-06-22T17:30:22Z</dateValidity>
-- <exportPort>ميناء اسكندرية</exportPort>
-- <countryOfOrigin>LS</countryOfOrigin>
-- <grossWeight>123.45</grossWeight>
-- <netWeight>122.87</netWeight>
-- <terms>لا يمكن الفتح</terms>
-- </delivery>
-- <invoiceLines>
-- <invoiceLine>
-- <description>حاسب الى</description>
-- <itemType>GS1</itemType>
-- <itemCode>10003752</itemCode>
-- <unitType>EA</unitType>
-- <quantity>5</quantity>
-- <unitValue>
-- <currencySold>EUR</currencySold>
-- <amountSold>10.00</amountSold>
-- <amountEGP>189.40</amountEGP>
-- <currencyExchangeRate>18.94</currencyExchangeRate>
-- </unitValue>
-- <salesTotal>947.00</salesTotal>
-- <discount>
-- <rate>7</rate>
-- <amount>66.29</amount>
-- </discount>
-- <taxableItems>
-- <taxableItem>
-- <taxType>T1</taxType>
-- <amount>272.07</amount>
-- <subType>V001</subType>
-- <rate>14</rate>
-- </taxableItem>
-- <taxableItem>
-- <taxType>T2</taxType>
-- <amount>208.22</amount>
-- <subType>T2-Sub</subType>
-- <rate>12</rate>
-- </taxableItem>
-- <taxableItem>
-- <taxType>T3</taxType>
-- <amount>30.00</amount>
-- <subType>T3-Sub</subType>
-- <rate>0</rate>
-- </taxableItem>
-- <taxableItem>
-- <taxType>T4</taxType>
-- <amount>43.79</amount>
-- <subType>W001</subType>
-- <rate>5</rate>
-- </taxableItem>
-- <taxableItem>
-- <taxType>T5</taxType>
-- <amount>123.30</amount>
-- <subType>T5-Sub</subType>
-- <rate>14</rate>
-- </taxableItem>
-- <taxableItem>
-- <taxType>T6</taxType>
-- <amount>60.00</amount>
-- <subType>T6-Sub</subType>
-- <rate>0</rate>
-- </taxableItem>
-- <taxableItem>
-- <taxType>T7</taxType>
-- <amount>88.07</amount>
-- <subType>T7-Sub</subType>
-- <rate>10</rate>
-- </taxableItem>
-- <taxableItem>
-- <taxType>T8</taxType>
-- <amount>123.30</amount>
-- <subType>T8-Sub</subType>
-- <rate>14</rate>
-- </taxableItem>
-- <taxableItem>
-- <taxType>T9</taxType>
-- <amount>105.69</amount>
-- <subType>T9-Sub</subType>
-- <rate>12</rate>
-- </taxableItem>
-- <taxableItem>
-- <taxType>T10</taxType>
-- <amount>88.07</amount>
-- <subType>T10-Sub</subType>
-- <rate>10</rate>
-- </taxableItem>
-- <taxableItem>
-- <taxType>T11</taxType>
-- <amount>123.30</amount>
-- <subType>T11-Sub</subType>
-- <rate>14</rate>
-- </taxableItem>
-- <taxableItem>
-- <taxType>T12</taxType>
-- <amount>105.69</amount>
-- <subType>T12-Sub</subType>
-- <rate>12</rate>
-- </taxableItem>
-- <taxableItem>
-- <taxType>T13</taxType>
-- <amount>88.07</amount>
-- <subType>T13-Sub</subType>
-- <rate>10</rate>
-- </taxableItem>
-- <taxableItem>
-- <taxType>T14</taxType>
-- <amount>123.30</amount>
-- <subType>T14-Sub</subType>
-- <rate>14</rate>
-- </taxableItem>
-- <taxableItem>
-- <taxType>T15</taxType>
-- <amount>105.69</amount>
-- <subType>T15-Sub</subType>
-- <rate>12</rate>
-- </taxableItem>
-- <taxableItem>
-- <taxType>T16</taxType>
-- <amount>88.07</amount>
-- <subType>T16-Sub</subType>
-- <rate>10</rate>
-- </taxableItem>
-- <taxableItem>
-- <taxType>T17</taxType>
-- <amount>88.07</amount>
-- <subType>T17-Sub</subType>
-- <rate>10</rate>
-- </taxableItem>
-- <taxableItem>
-- <taxType>T18</taxType>
-- <amount>123.30</amount>
-- <subType>T18-Sub</subType>
-- <rate>14</rate>
-- </taxableItem>
-- <taxableItem>
-- <taxType>T19</taxType>
-- <amount>105.69</amount>
-- <subType>T19-Sub</subType>
-- <rate>12</rate>
-- </taxableItem>
-- <taxableItem>
-- <taxType>T20</taxType>
-- <amount>88.07</amount>
-- <subType>T20-Sub</subType>
-- <rate>10</rate>
-- </taxableItem>
-- </taxableItems>
-- <internalCode>IC0</internalCode>
-- <itemsDiscount>5.00</itemsDiscount>
-- <netTotal>880.71</netTotal>
-- <totalTaxableFees>817.42</totalTaxableFees>
-- <valueDifference>7.00</valueDifference>
-- <total>2969.89</total>
-- </invoiceLine>
-- </invoiceLines>
-- <totalSalesAmount>947.00</totalSalesAmount>
-- <totalDiscountAmount>66.29</totalDiscountAmount>
-- <netAmount>880.71</netAmount>
-- <taxTotals>
-- <taxTotal>
-- <taxType>T1</taxType>
-- <amount>272.07</amount>
-- </taxTotal>
-- <taxTotal>
-- <taxType>T2</taxType>
-- <amount>208.22</amount>
-- </taxTotal>
-- <taxTotal>
-- <taxType>T3</taxType>
-- <amount>30.00</amount>
-- </taxTotal>
-- <taxTotal>
-- <taxType>T4</taxType>
-- <amount>43.79</amount>
-- </taxTotal>
-- <taxTotal>
-- <taxType>T5</taxType>
-- <amount>123.30</amount>
-- </taxTotal>
-- <taxTotal>
-- <taxType>T6</taxType>
-- <amount>60.00</amount>
-- </taxTotal>
-- <taxTotal>
-- <taxType>T7</taxType>
-- <amount>88.07</amount>
-- </taxTotal>
-- <taxTotal>
-- <taxType>T8</taxType>
-- <amount>123.30</amount>
-- </taxTotal>
-- <taxTotal>
-- <taxType>T9</taxType>
-- <amount>105.69</amount>
-- </taxTotal>
-- <taxTotal>
-- <taxType>T10</taxType>
-- <amount>88.07</amount>
-- </taxTotal>
-- <taxTotal>
-- <taxType>T11</taxType>
-- <amount>123.30</amount>
-- </taxTotal>
-- <taxTotal>
-- <taxType>T12</taxType>
-- <amount>105.69</amount>
-- </taxTotal>
-- <taxTotal>
-- <taxType>T13</taxType>
-- <amount>88.07</amount>
-- </taxTotal>
-- <taxTotal>
-- <taxType>T14</taxType>
-- <amount>123.30</amount>
-- </taxTotal>
-- <taxTotal>
-- <taxType>T15</taxType>
-- <amount>105.69</amount>
-- </taxTotal>
-- <taxTotal>
-- <taxType>T16</taxType>
-- <amount>88.07</amount>
-- </taxTotal>
-- <taxTotal>
-- <taxType>T17</taxType>
-- <amount>88.07</amount>
-- </taxTotal>
-- <taxTotal>
-- <taxType>T18</taxType>
-- <amount>123.30</amount>
-- </taxTotal>
-- <taxTotal>
-- <taxType>T19</taxType>
-- <amount>105.69</amount>
-- </taxTotal>
-- <taxTotal>
-- <taxType>T20</taxType>
-- <amount>88.07</amount>
-- </taxTotal>
-- </taxTotals>
-- <totalAmount>2964.89</totalAmount>
-- <totalItemsDiscountAmount>5.00</totalItemsDiscountAmount>
-- <extraDiscountAmount>5.00</extraDiscountAmount>
-- <signatures>
-- <signature>
-- <signatureType>I</signatureType>
-- <value>MIIGywYJKoZIhvcNAQcCoIIGvDCCBrgCAQMxDTALBglghkgBZQMEAgEwCwYJKoZIhvcNAQcFoIID/zCCA/swggLjoAMCAQICEEFkOqRVlVar0F0n3FZOLiIwDQYJKoZIhvcNAQELBQAwSTELMAkGA1UEBhMCRUcxFDASBgNVBAoTC0VneXB0IFRydXN0MSQwIgYDVQQDExtFZ3lwdCBUcnVzdCBDb3Jwb3JhdGUgQ0EgRzIwHhcNMjAwMzMxMDAwMDAwWhcNMjEwMzMwMjM1OTU5WjBgMRUwEwYDVQQKFAxFZ3lwdCBUcnVzdCAxGDAWBgNVBGEUD1ZBVEVHLTExMzMxNzcxMzELMAkGA1UEBhMCRUcxIDAeBgNVBAMMF1Rlc3QgU2VhbGluZyBEZW1vIHVzZXIyMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEApmVGVJtpImeq+tIJiVWSkIEEOTIcnG1XNYQOYtf5+Dg9eF5H5x1wkgR2G7dvWVXrTsdNv2Q+gvml9SdfWxlYxaljg2AuBrsHFjYVEAQFI37EW2K7tbMT7bfxwT1M5tbjxnkTTK12cgwxPr2LBNhHpfXp8SNyWCxpk6eyJb87DveVwCLbAGGXO9mhDj62glVTrCFit7mHC6bZ6MOMAp013B8No9c8xnrKQiOb4Tm2GxBYHFwEcfYUGZNltGZNdVUtu6ty+NTrSRRC/dILeGHgz6/2pgQPk5OFYRTRHRNVNo+jG+nurUYkSWxA4I9CmsVt2FdeBeuvRFs/U1I+ieKg1wIDAQABo4HHMIHEMAkGA1UdEwQCMAAwVAYDVR0fBE0wSzBJoEegRYZDaHR0cDovL21wa2ljcmwuZWd5cHR0cnVzdC5jb20vRWd5cHRUcnVzdENvcnBvcmF0ZUNBRzIvTGF0ZXN0Q1JMLmNybDAdBgNVHQ4EFgQUqzFDImtytsUbghbmtnl2/k4d5jEwEQYJYIZIAYb4QgEBBAQDAgeAMB8GA1UdIwQYMBaAFCInP8ziUIPmu86XJUWXspKN3LsFMA4GA1UdDwEB/wQEAwIGwDANBgkqhkiG9w0BAQsFAAOCAQEAxE3KpyYlPy/e3+6jfz5RqlLhRLppWpRlKYUvH1uIhCNRuWaYYRchw1xe3jn7bLKbNrUmey+MRwp1hZptkxFMYKTIEnNjOKCrLmVIuPFcfLXAQFq5vgLDSbnUhG/r5D+50ndPucyUPhX3gw8gFlA1R+tdNEoeKqYSo9v3p5qNANq12OuZbkhPg6sAD4dojWoNdlkc8J2ML0eq4a5AQvb4yZVb+ezqJyqKj83RekRZi0kMxoIm8l82CN8I/Bmp6VVNJRhQKhSeb7ShpdkZcMwcfKdDw6LW02/XcmzVl8NBBbLjKSJ/jxdL1RxPPza7RbGqSx9pfyav5+AxO9sXnXXc5jGCApIwggKOAgEBMF0wSTELMAkGA1UEBhMCRUcxFDASBgNVBAoTC0VneXB0IFRydXN0MSQwIgYDVQQDExtFZ3lwdCBUcnVzdCBDb3Jwb3JhdGUgQ0EgRzICEEFkOqRVlVar0F0n3FZOLiIwCwYJYIZIAWUDBAIBoIIBCjAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcFMBwGCSqGSIb3DQEJBTEPFw0yMDEwMzAxOTM3MjRaMC8GCSqGSIb3DQEJBDEiBCAF4PleCHptDdixMf7LI2cdwDvU75hcsW7zvr4mj4xaxzCBngYLKoZIhvcNAQkQAi8xgY4wgYswgYgwgYUEIAJA8uO/ek3l9i3ZOgRtPhGWwwFYljbeJ7yAgEnyYNCWMGEwTaBLMEkxCzAJBgNVBAYTAkVHMRQwEgYDVQQKEwtFZ3lwdCBUcnVzdDEkMCIGA1UEAxMbRWd5cHQgVHJ1c3QgQ29ycG9yYXRlIENBIEcyAhBBZDqkVZVWq9BdJ9xWTi4iMAsGCSqGSIb3DQEBAQSCAQCl8p4kZzD5PHMrMa+ZsKU2S+Ifl6mC1vFnxA0H+TWiCFDKoLCKsShLsgSWr65tkle5uiTS3GlAqJC24w1cjbjKLrMiZkDdDNXrZjY7TuUMLtf9sGA/Zaf8p5XJoPqlqnHUi3yB1A+IaWow86A7wCg9JjB/XEovQWAQ2cr0/WnwOZLx9yhksfxymK4Ne186hDTIGlUu5F2WkfT18YLHD3iLiTGSSINkXohCw/W8FKpNDDY5zPHd63dWABgA73BauaN3YEf7AdA6fItPaZC17Fr4aOiyyIJfZglvXCzmICxf2reGcd0rIA+0IU/7icKhXQrq/cimz8cpaxXoM1hAVqEf</value>
-- </signature>
-- </signatures>
-- </document>
-- </documents>
-- </submission>
--
DECLARE @xml int
-- Use "Chilkat_9_5_0.Xml" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.Xml', @xml OUT
EXEC sp_OASetProperty @xml, 'Tag', 'submission'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|issuer|type', 'B'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|issuer|id', 113317713
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|issuer|name', 'الشركة المصدرة'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|issuer|address|buildingNumber', 'عمارة 40'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|issuer|address|room', 123
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|issuer|address|floor', 16
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|issuer|address|street', '15 احمد فخرى'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|issuer|address|landmark', 'مستشفى حسبو'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|issuer|address|additionalInformation', 'بجانب مستشفى حسبو'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|issuer|address|governate', 'القاهرة'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|issuer|address|regionCity', 'مدينة نصر'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|issuer|address|postalCode', 098607
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|issuer|address|country', 'EG'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|issuer|address|branchID', 1
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|receiver|type', 'B'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|receiver|id', 730913562
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|receiver|name', 'المستلم'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|receiver|address|buildingNumber', 'عمارة 15'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|receiver|address|room', 110
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|receiver|address|floor', 8
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|receiver|address|street', '16 حوش عيسى'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|receiver|address|landmark', 'جامع الرحمة'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|receiver|address|additionalInformation', 'بجانب جامع الرحمة'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|receiver|address|governate', 'البحيرة'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|receiver|address|regionCity', 'دمنهور'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|receiver|address|postalCode', 098661
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|receiver|address|country', 'EG'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|documentType', 'D'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|documentTypeVersion', '0.9'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|dateTimeIssued', '2020-10-29T17:30:22Z'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|taxpayerActivityCode', 4620
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|internalID', 'IID0'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|purchaseOrderReference', 1230
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|purchaseOrderDescription', 'وصف طلب الدفع'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|salesOrderReference', 1452
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|salesOrderDescription', 'وصف بيع الطلب'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|proformaInvoiceNumber', 1485
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|references|reference', '439W9MSDRECAS6HXA9W4PXNE10'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|payment|bankName', 'البنك الاهلى'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|payment|bankAddress', '15 شارع النصر'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|payment|bankAccountNo', 1234567
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|payment|bankAccountIBAN', ''
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|payment|swiftCode', ''
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|payment|terms', 'لا يمكن التزوير'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|delivery|approach', 'جوى'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|delivery|packaging', 'تغليف'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|delivery|dateValidity', '2020-06-22T17:30:22Z'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|delivery|exportPort', 'ميناء اسكندرية'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|delivery|countryOfOrigin', 'LS'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|delivery|grossWeight', '123.45'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|delivery|netWeight', '122.87'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|delivery|terms', 'لا يمكن الفتح'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|description', 'حاسب الى'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|itemType', 'GS1'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|itemCode', 10003752
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|unitType', 'EA'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|quantity', 5
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|unitValue|currencySold', 'EUR'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|unitValue|amountSold', '10.00'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|unitValue|amountEGP', '189.40'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|unitValue|currencyExchangeRate', '18.94'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|salesTotal', '947.00'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|discount|rate', 7
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|discount|amount', '66.29'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem|taxType', 'T1'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem|amount', '272.07'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem|subType', 'V001'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem|rate', 14
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[1]|taxType', 'T2'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[1]|amount', '208.22'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[1]|subType', 'T2-Sub'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[1]|rate', 12
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[2]|taxType', 'T3'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[2]|amount', '30.00'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[2]|subType', 'T3-Sub'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[2]|rate', 0
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[3]|taxType', 'T4'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[3]|amount', '43.79'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[3]|subType', 'W001'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[3]|rate', 5
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[4]|taxType', 'T5'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[4]|amount', '123.30'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[4]|subType', 'T5-Sub'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[4]|rate', 14
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[5]|taxType', 'T6'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[5]|amount', '60.00'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[5]|subType', 'T6-Sub'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[5]|rate', 0
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[6]|taxType', 'T7'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[6]|amount', '88.07'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[6]|subType', 'T7-Sub'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[6]|rate', 10
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[7]|taxType', 'T8'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[7]|amount', '123.30'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[7]|subType', 'T8-Sub'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[7]|rate', 14
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[8]|taxType', 'T9'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[8]|amount', '105.69'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[8]|subType', 'T9-Sub'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[8]|rate', 12
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[9]|taxType', 'T10'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[9]|amount', '88.07'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[9]|subType', 'T10-Sub'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[9]|rate', 10
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[10]|taxType', 'T11'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[10]|amount', '123.30'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[10]|subType', 'T11-Sub'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[10]|rate', 14
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[11]|taxType', 'T12'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[11]|amount', '105.69'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[11]|subType', 'T12-Sub'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[11]|rate', 12
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[12]|taxType', 'T13'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[12]|amount', '88.07'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[12]|subType', 'T13-Sub'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[12]|rate', 10
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[13]|taxType', 'T14'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[13]|amount', '123.30'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[13]|subType', 'T14-Sub'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[13]|rate', 14
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[14]|taxType', 'T15'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[14]|amount', '105.69'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[14]|subType', 'T15-Sub'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[14]|rate', 12
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[15]|taxType', 'T16'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[15]|amount', '88.07'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[15]|subType', 'T16-Sub'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[15]|rate', 10
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[16]|taxType', 'T17'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[16]|amount', '88.07'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[16]|subType', 'T17-Sub'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[16]|rate', 10
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[17]|taxType', 'T18'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[17]|amount', '123.30'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[17]|subType', 'T18-Sub'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[17]|rate', 14
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[18]|taxType', 'T19'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[18]|amount', '105.69'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[18]|subType', 'T19-Sub'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[18]|rate', 12
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[19]|taxType', 'T20'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[19]|amount', '88.07'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[19]|subType', 'T20-Sub'
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, 'documents|document|invoiceLines|invoiceLine|taxableItems|taxableItem[19]|rate', 10
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|internalCode', 'IC0'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|itemsDiscount', '5.00'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|netTotal', '880.71'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|totalTaxableFees', '817.42'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|valueDifference', '7.00'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|invoiceLines|invoiceLine|total', '2969.89'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|totalSalesAmount', '947.00'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|totalDiscountAmount', '66.29'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|netAmount', '880.71'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal|taxType', 'T1'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal|amount', '272.07'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[1]|taxType', 'T2'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[1]|amount', '208.22'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[2]|taxType', 'T3'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[2]|amount', '30.00'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[3]|taxType', 'T4'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[3]|amount', '43.79'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[4]|taxType', 'T5'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[4]|amount', '123.30'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[5]|taxType', 'T6'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[5]|amount', '60.00'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[6]|taxType', 'T7'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[6]|amount', '88.07'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[7]|taxType', 'T8'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[7]|amount', '123.30'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[8]|taxType', 'T9'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[8]|amount', '105.69'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[9]|taxType', 'T10'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[9]|amount', '88.07'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[10]|taxType', 'T11'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[10]|amount', '123.30'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[11]|taxType', 'T12'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[11]|amount', '105.69'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[12]|taxType', 'T13'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[12]|amount', '88.07'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[13]|taxType', 'T14'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[13]|amount', '123.30'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[14]|taxType', 'T15'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[14]|amount', '105.69'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[15]|taxType', 'T16'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[15]|amount', '88.07'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[16]|taxType', 'T17'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[16]|amount', '88.07'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[17]|taxType', 'T18'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[17]|amount', '123.30'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[18]|taxType', 'T19'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[18]|amount', '105.69'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[19]|taxType', 'T20'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|taxTotals|taxTotal[19]|amount', '88.07'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|totalAmount', '2964.89'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|totalItemsDiscountAmount', '5.00'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|extraDiscountAmount', '5.00'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|signatures|signature|signatureType', 'I'
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, 'documents|document|signatures|signature|value', 'MIIGywYJKoZIhvcNAQcCoIIGvDCCBrgCAQMxDTALBglghkgBZQMEAgEwCwYJKoZIhvcNAQcFoIID/zCCA/swggLjoAMCAQICEEFkOqRVlVar0F0n3FZOLiIwDQYJKoZIhvcNAQELBQAwSTELMAkGA1UEBhMCRUcxFDASBgNVBAoTC0VneXB0IFRydXN0MSQwIgYDVQQDExtFZ3lwdCBUcnVzdCBDb3Jwb3JhdGUgQ0EgRzIwHhcNMjAwMzMxMDAwMDAwWhcNMjEwMzMwMjM1OTU5WjBgMRUwEwYDVQQKFAxFZ3lwdCBUcnVzdCAxGDAWBgNVBGEUD1ZBVEVHLTExMzMxNzcxMzELMAkGA1UEBhMCRUcxIDAeBgNVBAMMF1Rlc3QgU2VhbGluZyBEZW1vIHVzZXIyMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEApmVGVJtpImeq+tIJiVWSkIEEOTIcnG1XNYQOYtf5+Dg9eF5H5x1wkgR2G7dvWVXrTsdNv2Q+gvml9SdfWxlYxaljg2AuBrsHFjYVEAQFI37EW2K7tbMT7bfxwT1M5tbjxnkTTK12cgwxPr2LBNhHpfXp8SNyWCxpk6eyJb87DveVwCLbAGGXO9mhDj62glVTrCFit7mHC6bZ6MOMAp013B8No9c8xnrKQiOb4Tm2GxBYHFwEcfYUGZNltGZNdVUtu6ty+NTrSRRC/dILeGHgz6/2pgQPk5OFYRTRHRNVNo+jG+nurUYkSWxA4I9CmsVt2FdeBeuvRFs/U1I+ieKg1wIDAQABo4HHMIHEMAkGA1UdEwQCMAAwVAYDVR0fBE0wSzBJoEegRYZDaHR0cDovL21wa2ljcmwuZWd5cHR0cnVzdC5jb20vRWd5cHRUcnVzdENvcnBvcmF0ZUNBRzIvTGF0ZXN0Q1JMLmNybDAdBgNVHQ4EFgQUqzFDImtytsUbghbmtnl2/k4d5jEwEQYJYIZIAYb4QgEBBAQDAgeAMB8GA1UdIwQYMBaAFCInP8ziUIPmu86XJUWXspKN3LsFMA4GA1UdDwEB/wQEAwIGwDANBgkqhkiG9w0BAQsFAAOCAQEAxE3KpyYlPy/e3+6jfz5RqlLhRLppWpRlKYUvH1uIhCNRuWaYYRchw1xe3jn7bLKbNrUmey+MRwp1hZptkxFMYKTIEnNjOKCrLmVIuPFcfLXAQFq5vgLDSbnUhG/r5D+50ndPucyUPhX3gw8gFlA1R+tdNEoeKqYSo9v3p5qNANq12OuZbkhPg6sAD4dojWoNdlkc8J2ML0eq4a5AQvb4yZVb+ezqJyqKj83RekRZi0kMxoIm8l82CN8I/Bmp6VVNJRhQKhSeb7ShpdkZcMwcfKdDw6LW02/XcmzVl8NBBbLjKSJ/jxdL1RxPPza7RbGqSx9pfyav5+AxO9sXnXXc5jGCApIwggKOAgEBMF0wSTELMAkGA1UEBhMCRUcxFDASBgNVBAoTC0VneXB0IFRydXN0MSQwIgYDVQQDExtFZ3lwdCBUcnVzdCBDb3Jwb3JhdGUgQ0EgRzICEEFkOqRVlVar0F0n3FZOLiIwCwYJYIZIAWUDBAIBoIIBCjAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcFMBwGCSqGSIb3DQEJBTEPFw0yMDEwMzAxOTM3MjRaMC8GCSqGSIb3DQEJBDEiBCAF4PleCHptDdixMf7LI2cdwDvU75hcsW7zvr4mj4xaxzCBngYLKoZIhvcNAQkQAi8xgY4wgYswgYgwgYUEIAJA8uO/ek3l9i3ZOgRtPhGWwwFYljbeJ7yAgEnyYNCWMGEwTaBLMEkxCzAJBgNVBAYTAkVHMRQwEgYDVQQKEwtFZ3lwdCBUcnVzdDEkMCIGA1UEAxMbRWd5cHQgVHJ1c3QgQ29ycG9yYXRlIENBIEcyAhBBZDqkVZVWq9BdJ9xWTi4iMAsGCSqGSIb3DQEBAQSCAQCl8p4kZzD5PHMrMa+ZsKU2S+Ifl6mC1vFnxA0H+TWiCFDKoLCKsShLsgSWr65tkle5uiTS3GlAqJC24w1cjbjKLrMiZkDdDNXrZjY7TuUMLtf9sGA/Zaf8p5XJoPqlqnHUi3yB1A+IaWow86A7wCg9JjB/XEovQWAQ2cr0/WnwOZLx9yhksfxymK4Ne186hDTIGlUu5F2WkfT18YLHD3iLiTGSSINkXohCw/W8FKpNDDY5zPHd63dWABgA73BauaN3YEf7AdA6fItPaZC17Fr4aOiyyIJfZglvXCzmICxf2reGcd0rIA+0IU/7icKhXQrq/cimz8cpaxXoM1hAVqEf'
-- Adds the "Authorization: Bearer <access_token>" header.
EXEC sp_OASetProperty @http, 'AuthToken', '<access_token>'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Content-Type', 'application/xml'
DECLARE @sbRequestBody int
-- Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbRequestBody OUT
EXEC sp_OAMethod @xml, 'GetXmlSb', @success OUT, @sbRequestBody
DECLARE @resp int
EXEC sp_OAMethod @http, 'PTextSb', @resp OUT, 'POST', 'https://domain.com/api/v1/documentsubmissions', @sbRequestBody, 'utf-8', 'application/xml', 0, 0
EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
IF @iTmp0 = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @xml
EXEC @hr = sp_OADestroy @sbRequestBody
RETURN
END
EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
PRINT @iTmp0
EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @xml
EXEC @hr = sp_OADestroy @sbRequestBody
END
GO
Curl Command
curl -X POST
-H "Authorization: Bearer <access_token>"
-H "Content-Type: application/xml"
-d '<submission>
<documents>
<document>
<issuer>
<type>B</type>
<id>113317713</id>
<name>الشركة المصدرة</name>
<address>
<buildingNumber>عمارة 40</buildingNumber>
<room>123</room>
<floor>16</floor>
<street>15 احمد فخرى</street>
<landmark>مستشفى حسبو</landmark>
<additionalInformation>بجانب مستشفى حسبو</additionalInformation>
<governate>القاهرة</governate>
<regionCity>مدينة نصر</regionCity>
<postalCode>098607</postalCode>
<country>EG</country>
<branchID>1</branchID>
</address>
</issuer>
<receiver>
<type>B</type>
<id>730913562</id>
<name>المستلم</name>
<address>
<buildingNumber>عمارة 15</buildingNumber>
<room>110</room>
<floor>8</floor>
<street>16 حوش عيسى</street>
<landmark>جامع الرحمة</landmark>
<additionalInformation>بجانب جامع الرحمة</additionalInformation>
<governate>البحيرة</governate>
<regionCity>دمنهور</regionCity>
<postalCode>098661</postalCode>
<country>EG</country>
</address>
</receiver>
<documentType>D</documentType>
<documentTypeVersion>0.9</documentTypeVersion>
<dateTimeIssued>2020-10-29T17:30:22Z</dateTimeIssued>
<taxpayerActivityCode>4620</taxpayerActivityCode>
<internalID>IID0</internalID>
<purchaseOrderReference>1230</purchaseOrderReference>
<purchaseOrderDescription>وصف طلب الدفع</purchaseOrderDescription>
<salesOrderReference>1452</salesOrderReference>
<salesOrderDescription>وصف بيع الطلب</salesOrderDescription>
<proformaInvoiceNumber>1485</proformaInvoiceNumber>
<references>
<reference>439W9MSDRECAS6HXA9W4PXNE10</reference>
</references>
<payment>
<bankName>البنك الاهلى</bankName>
<bankAddress>15 شارع النصر</bankAddress>
<bankAccountNo>1234567</bankAccountNo>
<bankAccountIBAN />
<swiftCode />
<terms>لا يمكن التزوير</terms>
</payment>
<delivery>
<approach>جوى</approach>
<packaging>تغليف</packaging>
<dateValidity>2020-06-22T17:30:22Z</dateValidity>
<exportPort>ميناء اسكندرية</exportPort>
<countryOfOrigin>LS</countryOfOrigin>
<grossWeight>123.45</grossWeight>
<netWeight>122.87</netWeight>
<terms>لا يمكن الفتح</terms>
</delivery>
<invoiceLines>
<invoiceLine>
<description>حاسب الى</description>
<itemType>GS1</itemType>
<itemCode>10003752</itemCode>
<unitType>EA</unitType>
<quantity>5</quantity>
<unitValue>
<currencySold>EUR</currencySold>
<amountSold>10.00</amountSold>
<amountEGP>189.40</amountEGP>
<currencyExchangeRate>18.94</currencyExchangeRate>
</unitValue>
<salesTotal>947.00</salesTotal>
<discount>
<rate>7</rate>
<amount>66.29</amount>
</discount>
<taxableItems>
<taxableItem>
<taxType>T1</taxType>
<amount>272.07</amount>
<subType>V001</subType>
<rate>14</rate>
</taxableItem>
<taxableItem>
<taxType>T2</taxType>
<amount>208.22</amount>
<subType>T2-Sub</subType>
<rate>12</rate>
</taxableItem>
<taxableItem>
<taxType>T3</taxType>
<amount>30.00</amount>
<subType>T3-Sub</subType>
<rate>0</rate>
</taxableItem>
<taxableItem>
<taxType>T4</taxType>
<amount>43.79</amount>
<subType>W001</subType>
<rate>5</rate>
</taxableItem>
<taxableItem>
<taxType>T5</taxType>
<amount>123.30</amount>
<subType>T5-Sub</subType>
<rate>14</rate>
</taxableItem>
<taxableItem>
<taxType>T6</taxType>
<amount>60.00</amount>
<subType>T6-Sub</subType>
<rate>0</rate>
</taxableItem>
<taxableItem>
<taxType>T7</taxType>
<amount>88.07</amount>
<subType>T7-Sub</subType>
<rate>10</rate>
</taxableItem>
<taxableItem>
<taxType>T8</taxType>
<amount>123.30</amount>
<subType>T8-Sub</subType>
<rate>14</rate>
</taxableItem>
<taxableItem>
<taxType>T9</taxType>
<amount>105.69</amount>
<subType>T9-Sub</subType>
<rate>12</rate>
</taxableItem>
<taxableItem>
<taxType>T10</taxType>
<amount>88.07</amount>
<subType>T10-Sub</subType>
<rate>10</rate>
</taxableItem>
<taxableItem>
<taxType>T11</taxType>
<amount>123.30</amount>
<subType>T11-Sub</subType>
<rate>14</rate>
</taxableItem>
<taxableItem>
<taxType>T12</taxType>
<amount>105.69</amount>
<subType>T12-Sub</subType>
<rate>12</rate>
</taxableItem>
<taxableItem>
<taxType>T13</taxType>
<amount>88.07</amount>
<subType>T13-Sub</subType>
<rate>10</rate>
</taxableItem>
<taxableItem>
<taxType>T14</taxType>
<amount>123.30</amount>
<subType>T14-Sub</subType>
<rate>14</rate>
</taxableItem>
<taxableItem>
<taxType>T15</taxType>
<amount>105.69</amount>
<subType>T15-Sub</subType>
<rate>12</rate>
</taxableItem>
<taxableItem>
<taxType>T16</taxType>
<amount>88.07</amount>
<subType>T16-Sub</subType>
<rate>10</rate>
</taxableItem>
<taxableItem>
<taxType>T17</taxType>
<amount>88.07</amount>
<subType>T17-Sub</subType>
<rate>10</rate>
</taxableItem>
<taxableItem>
<taxType>T18</taxType>
<amount>123.30</amount>
<subType>T18-Sub</subType>
<rate>14</rate>
</taxableItem>
<taxableItem>
<taxType>T19</taxType>
<amount>105.69</amount>
<subType>T19-Sub</subType>
<rate>12</rate>
</taxableItem>
<taxableItem>
<taxType>T20</taxType>
<amount>88.07</amount>
<subType>T20-Sub</subType>
<rate>10</rate>
</taxableItem>
</taxableItems>
<internalCode>IC0</internalCode>
<itemsDiscount>5.00</itemsDiscount>
<netTotal>880.71</netTotal>
<totalTaxableFees>817.42</totalTaxableFees>
<valueDifference>7.00</valueDifference>
<total>2969.89</total>
</invoiceLine>
</invoiceLines>
<totalSalesAmount>947.00</totalSalesAmount>
<totalDiscountAmount>66.29</totalDiscountAmount>
<netAmount>880.71</netAmount>
<taxTotals>
<taxTotal>
<taxType>T1</taxType>
<amount>272.07</amount>
</taxTotal>
<taxTotal>
<taxType>T2</taxType>
<amount>208.22</amount>
</taxTotal>
<taxTotal>
<taxType>T3</taxType>
<amount>30.00</amount>
</taxTotal>
<taxTotal>
<taxType>T4</taxType>
<amount>43.79</amount>
</taxTotal>
<taxTotal>
<taxType>T5</taxType>
<amount>123.30</amount>
</taxTotal>
<taxTotal>
<taxType>T6</taxType>
<amount>60.00</amount>
</taxTotal>
<taxTotal>
<taxType>T7</taxType>
<amount>88.07</amount>
</taxTotal>
<taxTotal>
<taxType>T8</taxType>
<amount>123.30</amount>
</taxTotal>
<taxTotal>
<taxType>T9</taxType>
<amount>105.69</amount>
</taxTotal>
<taxTotal>
<taxType>T10</taxType>
<amount>88.07</amount>
</taxTotal>
<taxTotal>
<taxType>T11</taxType>
<amount>123.30</amount>
</taxTotal>
<taxTotal>
<taxType>T12</taxType>
<amount>105.69</amount>
</taxTotal>
<taxTotal>
<taxType>T13</taxType>
<amount>88.07</amount>
</taxTotal>
<taxTotal>
<taxType>T14</taxType>
<amount>123.30</amount>
</taxTotal>
<taxTotal>
<taxType>T15</taxType>
<amount>105.69</amount>
</taxTotal>
<taxTotal>
<taxType>T16</taxType>
<amount>88.07</amount>
</taxTotal>
<taxTotal>
<taxType>T17</taxType>
<amount>88.07</amount>
</taxTotal>
<taxTotal>
<taxType>T18</taxType>
<amount>123.30</amount>
</taxTotal>
<taxTotal>
<taxType>T19</taxType>
<amount>105.69</amount>
</taxTotal>
<taxTotal>
<taxType>T20</taxType>
<amount>88.07</amount>
</taxTotal>
</taxTotals>
<totalAmount>2964.89</totalAmount>
<totalItemsDiscountAmount>5.00</totalItemsDiscountAmount>
<extraDiscountAmount>5.00</extraDiscountAmount>
<signatures>
<signature>
<signatureType>I</signatureType>
<value>MIIGywYJKoZIhvcNAQcCoIIGvDCCBrgCAQMxDTALBglghkgBZQMEAgEwCwYJKoZIhvcNAQcFoIID/zCCA/swggLjoAMCAQICEEFkOqRVlVar0F0n3FZOLiIwDQYJKoZIhvcNAQELBQAwSTELMAkGA1UEBhMCRUcxFDASBgNVBAoTC0VneXB0IFRydXN0MSQwIgYDVQQDExtFZ3lwdCBUcnVzdCBDb3Jwb3JhdGUgQ0EgRzIwHhcNMjAwMzMxMDAwMDAwWhcNMjEwMzMwMjM1OTU5WjBgMRUwEwYDVQQKFAxFZ3lwdCBUcnVzdCAxGDAWBgNVBGEUD1ZBVEVHLTExMzMxNzcxMzELMAkGA1UEBhMCRUcxIDAeBgNVBAMMF1Rlc3QgU2VhbGluZyBEZW1vIHVzZXIyMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEApmVGVJtpImeq+tIJiVWSkIEEOTIcnG1XNYQOYtf5+Dg9eF5H5x1wkgR2G7dvWVXrTsdNv2Q+gvml9SdfWxlYxaljg2AuBrsHFjYVEAQFI37EW2K7tbMT7bfxwT1M5tbjxnkTTK12cgwxPr2LBNhHpfXp8SNyWCxpk6eyJb87DveVwCLbAGGXO9mhDj62glVTrCFit7mHC6bZ6MOMAp013B8No9c8xnrKQiOb4Tm2GxBYHFwEcfYUGZNltGZNdVUtu6ty+NTrSRRC/dILeGHgz6/2pgQPk5OFYRTRHRNVNo+jG+nurUYkSWxA4I9CmsVt2FdeBeuvRFs/U1I+ieKg1wIDAQABo4HHMIHEMAkGA1UdEwQCMAAwVAYDVR0fBE0wSzBJoEegRYZDaHR0cDovL21wa2ljcmwuZWd5cHR0cnVzdC5jb20vRWd5cHRUcnVzdENvcnBvcmF0ZUNBRzIvTGF0ZXN0Q1JMLmNybDAdBgNVHQ4EFgQUqzFDImtytsUbghbmtnl2/k4d5jEwEQYJYIZIAYb4QgEBBAQDAgeAMB8GA1UdIwQYMBaAFCInP8ziUIPmu86XJUWXspKN3LsFMA4GA1UdDwEB/wQEAwIGwDANBgkqhkiG9w0BAQsFAAOCAQEAxE3KpyYlPy/e3+6jfz5RqlLhRLppWpRlKYUvH1uIhCNRuWaYYRchw1xe3jn7bLKbNrUmey+MRwp1hZptkxFMYKTIEnNjOKCrLmVIuPFcfLXAQFq5vgLDSbnUhG/r5D+50ndPucyUPhX3gw8gFlA1R+tdNEoeKqYSo9v3p5qNANq12OuZbkhPg6sAD4dojWoNdlkc8J2ML0eq4a5AQvb4yZVb+ezqJyqKj83RekRZi0kMxoIm8l82CN8I/Bmp6VVNJRhQKhSeb7ShpdkZcMwcfKdDw6LW02/XcmzVl8NBBbLjKSJ/jxdL1RxPPza7RbGqSx9pfyav5+AxO9sXnXXc5jGCApIwggKOAgEBMF0wSTELMAkGA1UEBhMCRUcxFDASBgNVBAoTC0VneXB0IFRydXN0MSQwIgYDVQQDExtFZ3lwdCBUcnVzdCBDb3Jwb3JhdGUgQ0EgRzICEEFkOqRVlVar0F0n3FZOLiIwCwYJYIZIAWUDBAIBoIIBCjAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcFMBwGCSqGSIb3DQEJBTEPFw0yMDEwMzAxOTM3MjRaMC8GCSqGSIb3DQEJBDEiBCAF4PleCHptDdixMf7LI2cdwDvU75hcsW7zvr4mj4xaxzCBngYLKoZIhvcNAQkQAi8xgY4wgYswgYgwgYUEIAJA8uO/ek3l9i3ZOgRtPhGWwwFYljbeJ7yAgEnyYNCWMGEwTaBLMEkxCzAJBgNVBAYTAkVHMRQwEgYDVQQKEwtFZ3lwdCBUcnVzdDEkMCIGA1UEAxMbRWd5cHQgVHJ1c3QgQ29ycG9yYXRlIENBIEcyAhBBZDqkVZVWq9BdJ9xWTi4iMAsGCSqGSIb3DQEBAQSCAQCl8p4kZzD5PHMrMa+ZsKU2S+Ifl6mC1vFnxA0H+TWiCFDKoLCKsShLsgSWr65tkle5uiTS3GlAqJC24w1cjbjKLrMiZkDdDNXrZjY7TuUMLtf9sGA/Zaf8p5XJoPqlqnHUi3yB1A+IaWow86A7wCg9JjB/XEovQWAQ2cr0/WnwOZLx9yhksfxymK4Ne186hDTIGlUu5F2WkfT18YLHD3iLiTGSSINkXohCw/W8FKpNDDY5zPHd63dWABgA73BauaN3YEf7AdA6fItPaZC17Fr4aOiyyIJfZglvXCzmICxf2reGcd0rIA+0IU/7icKhXQrq/cimz8cpaxXoM1hAVqEf</value>
</signature>
</signatures>
</document>
</documents>
</submission>'
https://domain.com/api/v1/documentsubmissions
Postman Collection Item JSON
{
"name": "1.2 Submit Documents (XML) Debit",
"request": {
"auth": {
"type": "bearer",
"bearer": [
{
"key": "token",
"value": "{{generatedAccessToken}}",
"type": "string"
}
]
},
"method": "POST",
"header": [
{
"key": "Content-Type",
"value": "application/xml"
}
],
"body": {
"mode": "raw",
"raw": "<submission>\r\n <documents>\r\n <document>\r\n <issuer>\r\n <type>B</type>\r\n <id>113317713</id>\r\n <name>الشركة المصدرة</name>\r\n <address>\r\n <buildingNumber>عمارة 40</buildingNumber>\r\n <room>123</room>\r\n <floor>16</floor>\r\n <street>15 احمد فخرى</street>\r\n <landmark>مستشفى حسبو</landmark>\r\n <additionalInformation>بجانب مستشفى حسبو</additionalInformation>\r\n <governate>القاهرة</governate>\r\n <regionCity>مدينة نصر</regionCity>\r\n <postalCode>098607</postalCode>\r\n <country>EG</country>\r\n <branchID>1</branchID>\r\n </address>\r\n </issuer>\r\n <receiver>\r\n <type>B</type>\r\n <id>730913562</id>\r\n <name>المستلم</name>\r\n <address>\r\n <buildingNumber>عمارة 15</buildingNumber>\r\n <room>110</room>\r\n <floor>8</floor>\r\n <street>16 حوش عيسى</street>\r\n <landmark>جامع الرحمة</landmark>\r\n <additionalInformation>بجانب جامع الرحمة</additionalInformation>\r\n <governate>البحيرة</governate>\r\n <regionCity>دمنهور</regionCity>\r\n <postalCode>098661</postalCode>\r\n <country>EG</country>\r\n </address>\r\n </receiver>\r\n <documentType>D</documentType>\r\n <documentTypeVersion>0.9</documentTypeVersion>\r\n <dateTimeIssued>2020-10-29T17:30:22Z</dateTimeIssued>\r\n <taxpayerActivityCode>4620</taxpayerActivityCode>\r\n <internalID>IID0</internalID>\r\n <purchaseOrderReference>1230</purchaseOrderReference>\r\n <purchaseOrderDescription>وصف طلب الدفع</purchaseOrderDescription>\r\n <salesOrderReference>1452</salesOrderReference>\r\n <salesOrderDescription>وصف بيع الطلب</salesOrderDescription>\r\n <proformaInvoiceNumber>1485</proformaInvoiceNumber>\r\n <references>\r\n <reference>439W9MSDRECAS6HXA9W4PXNE10</reference>\r\n </references>\r\n <payment>\r\n <bankName>البنك الاهلى</bankName>\r\n <bankAddress>15 شارع النصر</bankAddress>\r\n <bankAccountNo>1234567</bankAccountNo>\r\n <bankAccountIBAN />\r\n <swiftCode />\r\n <terms>لا يمكن التزوير</terms>\r\n </payment>\r\n <delivery>\r\n <approach>جوى</approach>\r\n <packaging>تغليف</packaging>\r\n <dateValidity>2020-06-22T17:30:22Z</dateValidity>\r\n <exportPort>ميناء اسكندرية</exportPort>\r\n <countryOfOrigin>LS</countryOfOrigin>\r\n <grossWeight>123.45</grossWeight>\r\n <netWeight>122.87</netWeight>\r\n <terms>لا يمكن الفتح</terms>\r\n </delivery>\r\n <invoiceLines>\r\n <invoiceLine>\r\n <description>حاسب الى</description>\r\n <itemType>GS1</itemType>\r\n <itemCode>10003752</itemCode>\r\n <unitType>EA</unitType>\r\n <quantity>5</quantity>\r\n <unitValue>\r\n <currencySold>EUR</currencySold>\r\n <amountSold>10.00</amountSold>\r\n <amountEGP>189.40</amountEGP>\r\n <currencyExchangeRate>18.94</currencyExchangeRate>\r\n </unitValue>\r\n <salesTotal>947.00</salesTotal>\r\n <discount>\r\n <rate>7</rate>\r\n <amount>66.29</amount>\r\n </discount>\r\n <taxableItems>\r\n <taxableItem>\r\n <taxType>T1</taxType>\r\n <amount>272.07</amount>\r\n <subType>V001</subType>\r\n <rate>14</rate>\r\n </taxableItem>\r\n <taxableItem>\r\n <taxType>T2</taxType>\r\n <amount>208.22</amount>\r\n <subType>T2-Sub</subType>\r\n <rate>12</rate>\r\n </taxableItem>\r\n <taxableItem>\r\n <taxType>T3</taxType>\r\n <amount>30.00</amount>\r\n <subType>T3-Sub</subType>\r\n <rate>0</rate>\r\n </taxableItem>\r\n <taxableItem>\r\n <taxType>T4</taxType>\r\n <amount>43.79</amount>\r\n <subType>W001</subType>\r\n <rate>5</rate>\r\n </taxableItem>\r\n <taxableItem>\r\n <taxType>T5</taxType>\r\n <amount>123.30</amount>\r\n <subType>T5-Sub</subType>\r\n <rate>14</rate>\r\n </taxableItem>\r\n <taxableItem>\r\n <taxType>T6</taxType>\r\n <amount>60.00</amount>\r\n <subType>T6-Sub</subType>\r\n <rate>0</rate>\r\n </taxableItem>\r\n <taxableItem>\r\n <taxType>T7</taxType>\r\n <amount>88.07</amount>\r\n <subType>T7-Sub</subType>\r\n <rate>10</rate>\r\n </taxableItem>\r\n <taxableItem>\r\n <taxType>T8</taxType>\r\n <amount>123.30</amount>\r\n <subType>T8-Sub</subType>\r\n <rate>14</rate>\r\n </taxableItem>\r\n <taxableItem>\r\n <taxType>T9</taxType>\r\n <amount>105.69</amount>\r\n <subType>T9-Sub</subType>\r\n <rate>12</rate>\r\n </taxableItem>\r\n <taxableItem>\r\n <taxType>T10</taxType>\r\n <amount>88.07</amount>\r\n <subType>T10-Sub</subType>\r\n <rate>10</rate>\r\n </taxableItem>\r\n <taxableItem>\r\n <taxType>T11</taxType>\r\n <amount>123.30</amount>\r\n <subType>T11-Sub</subType>\r\n <rate>14</rate>\r\n </taxableItem>\r\n <taxableItem>\r\n <taxType>T12</taxType>\r\n <amount>105.69</amount>\r\n <subType>T12-Sub</subType>\r\n <rate>12</rate>\r\n </taxableItem>\r\n <taxableItem>\r\n <taxType>T13</taxType>\r\n <amount>88.07</amount>\r\n <subType>T13-Sub</subType>\r\n <rate>10</rate>\r\n </taxableItem>\r\n <taxableItem>\r\n <taxType>T14</taxType>\r\n <amount>123.30</amount>\r\n <subType>T14-Sub</subType>\r\n <rate>14</rate>\r\n </taxableItem>\r\n <taxableItem>\r\n <taxType>T15</taxType>\r\n <amount>105.69</amount>\r\n <subType>T15-Sub</subType>\r\n <rate>12</rate>\r\n </taxableItem>\r\n <taxableItem>\r\n <taxType>T16</taxType>\r\n <amount>88.07</amount>\r\n <subType>T16-Sub</subType>\r\n <rate>10</rate>\r\n </taxableItem>\r\n <taxableItem>\r\n <taxType>T17</taxType>\r\n <amount>88.07</amount>\r\n <subType>T17-Sub</subType>\r\n <rate>10</rate>\r\n </taxableItem>\r\n <taxableItem>\r\n <taxType>T18</taxType>\r\n <amount>123.30</amount>\r\n <subType>T18-Sub</subType>\r\n <rate>14</rate>\r\n </taxableItem>\r\n <taxableItem>\r\n <taxType>T19</taxType>\r\n <amount>105.69</amount>\r\n <subType>T19-Sub</subType>\r\n <rate>12</rate>\r\n </taxableItem>\r\n <taxableItem>\r\n <taxType>T20</taxType>\r\n <amount>88.07</amount>\r\n <subType>T20-Sub</subType>\r\n <rate>10</rate>\r\n </taxableItem>\r\n </taxableItems>\r\n <internalCode>IC0</internalCode>\r\n <itemsDiscount>5.00</itemsDiscount>\r\n <netTotal>880.71</netTotal>\r\n <totalTaxableFees>817.42</totalTaxableFees>\r\n <valueDifference>7.00</valueDifference>\r\n <total>2969.89</total>\r\n </invoiceLine>\r\n </invoiceLines>\r\n <totalSalesAmount>947.00</totalSalesAmount>\r\n <totalDiscountAmount>66.29</totalDiscountAmount>\r\n <netAmount>880.71</netAmount>\r\n <taxTotals>\r\n <taxTotal>\r\n <taxType>T1</taxType>\r\n <amount>272.07</amount>\r\n </taxTotal>\r\n <taxTotal>\r\n <taxType>T2</taxType>\r\n <amount>208.22</amount>\r\n </taxTotal>\r\n <taxTotal>\r\n <taxType>T3</taxType>\r\n <amount>30.00</amount>\r\n </taxTotal>\r\n <taxTotal>\r\n <taxType>T4</taxType>\r\n <amount>43.79</amount>\r\n </taxTotal>\r\n <taxTotal>\r\n <taxType>T5</taxType>\r\n <amount>123.30</amount>\r\n </taxTotal>\r\n <taxTotal>\r\n <taxType>T6</taxType>\r\n <amount>60.00</amount>\r\n </taxTotal>\r\n <taxTotal>\r\n <taxType>T7</taxType>\r\n <amount>88.07</amount>\r\n </taxTotal>\r\n <taxTotal>\r\n <taxType>T8</taxType>\r\n <amount>123.30</amount>\r\n </taxTotal>\r\n <taxTotal>\r\n <taxType>T9</taxType>\r\n <amount>105.69</amount>\r\n </taxTotal>\r\n <taxTotal>\r\n <taxType>T10</taxType>\r\n <amount>88.07</amount>\r\n </taxTotal>\r\n <taxTotal>\r\n <taxType>T11</taxType>\r\n <amount>123.30</amount>\r\n </taxTotal>\r\n <taxTotal>\r\n <taxType>T12</taxType>\r\n <amount>105.69</amount>\r\n </taxTotal>\r\n <taxTotal>\r\n <taxType>T13</taxType>\r\n <amount>88.07</amount>\r\n </taxTotal>\r\n <taxTotal>\r\n <taxType>T14</taxType>\r\n <amount>123.30</amount>\r\n </taxTotal>\r\n <taxTotal>\r\n <taxType>T15</taxType>\r\n <amount>105.69</amount>\r\n </taxTotal>\r\n <taxTotal>\r\n <taxType>T16</taxType>\r\n <amount>88.07</amount>\r\n </taxTotal>\r\n <taxTotal>\r\n <taxType>T17</taxType>\r\n <amount>88.07</amount>\r\n </taxTotal>\r\n <taxTotal>\r\n <taxType>T18</taxType>\r\n <amount>123.30</amount>\r\n </taxTotal>\r\n <taxTotal>\r\n <taxType>T19</taxType>\r\n <amount>105.69</amount>\r\n </taxTotal>\r\n <taxTotal>\r\n <taxType>T20</taxType>\r\n <amount>88.07</amount>\r\n </taxTotal>\r\n </taxTotals>\r\n <totalAmount>2964.89</totalAmount>\r\n <totalItemsDiscountAmount>5.00</totalItemsDiscountAmount>\r\n <extraDiscountAmount>5.00</extraDiscountAmount>\r\n <signatures>\r\n <signature>\r\n <signatureType>I</signatureType>\r\n <value>MIIGywYJKoZIhvcNAQcCoIIGvDCCBrgCAQMxDTALBglghkgBZQMEAgEwCwYJKoZIhvcNAQcFoIID/zCCA/swggLjoAMCAQICEEFkOqRVlVar0F0n3FZOLiIwDQYJKoZIhvcNAQELBQAwSTELMAkGA1UEBhMCRUcxFDASBgNVBAoTC0VneXB0IFRydXN0MSQwIgYDVQQDExtFZ3lwdCBUcnVzdCBDb3Jwb3JhdGUgQ0EgRzIwHhcNMjAwMzMxMDAwMDAwWhcNMjEwMzMwMjM1OTU5WjBgMRUwEwYDVQQKFAxFZ3lwdCBUcnVzdCAxGDAWBgNVBGEUD1ZBVEVHLTExMzMxNzcxMzELMAkGA1UEBhMCRUcxIDAeBgNVBAMMF1Rlc3QgU2VhbGluZyBEZW1vIHVzZXIyMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEApmVGVJtpImeq+tIJiVWSkIEEOTIcnG1XNYQOYtf5+Dg9eF5H5x1wkgR2G7dvWVXrTsdNv2Q+gvml9SdfWxlYxaljg2AuBrsHFjYVEAQFI37EW2K7tbMT7bfxwT1M5tbjxnkTTK12cgwxPr2LBNhHpfXp8SNyWCxpk6eyJb87DveVwCLbAGGXO9mhDj62glVTrCFit7mHC6bZ6MOMAp013B8No9c8xnrKQiOb4Tm2GxBYHFwEcfYUGZNltGZNdVUtu6ty+NTrSRRC/dILeGHgz6/2pgQPk5OFYRTRHRNVNo+jG+nurUYkSWxA4I9CmsVt2FdeBeuvRFs/U1I+ieKg1wIDAQABo4HHMIHEMAkGA1UdEwQCMAAwVAYDVR0fBE0wSzBJoEegRYZDaHR0cDovL21wa2ljcmwuZWd5cHR0cnVzdC5jb20vRWd5cHRUcnVzdENvcnBvcmF0ZUNBRzIvTGF0ZXN0Q1JMLmNybDAdBgNVHQ4EFgQUqzFDImtytsUbghbmtnl2/k4d5jEwEQYJYIZIAYb4QgEBBAQDAgeAMB8GA1UdIwQYMBaAFCInP8ziUIPmu86XJUWXspKN3LsFMA4GA1UdDwEB/wQEAwIGwDANBgkqhkiG9w0BAQsFAAOCAQEAxE3KpyYlPy/e3+6jfz5RqlLhRLppWpRlKYUvH1uIhCNRuWaYYRchw1xe3jn7bLKbNrUmey+MRwp1hZptkxFMYKTIEnNjOKCrLmVIuPFcfLXAQFq5vgLDSbnUhG/r5D+50ndPucyUPhX3gw8gFlA1R+tdNEoeKqYSo9v3p5qNANq12OuZbkhPg6sAD4dojWoNdlkc8J2ML0eq4a5AQvb4yZVb+ezqJyqKj83RekRZi0kMxoIm8l82CN8I/Bmp6VVNJRhQKhSeb7ShpdkZcMwcfKdDw6LW02/XcmzVl8NBBbLjKSJ/jxdL1RxPPza7RbGqSx9pfyav5+AxO9sXnXXc5jGCApIwggKOAgEBMF0wSTELMAkGA1UEBhMCRUcxFDASBgNVBAoTC0VneXB0IFRydXN0MSQwIgYDVQQDExtFZ3lwdCBUcnVzdCBDb3Jwb3JhdGUgQ0EgRzICEEFkOqRVlVar0F0n3FZOLiIwCwYJYIZIAWUDBAIBoIIBCjAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcFMBwGCSqGSIb3DQEJBTEPFw0yMDEwMzAxOTM3MjRaMC8GCSqGSIb3DQEJBDEiBCAF4PleCHptDdixMf7LI2cdwDvU75hcsW7zvr4mj4xaxzCBngYLKoZIhvcNAQkQAi8xgY4wgYswgYgwgYUEIAJA8uO/ek3l9i3ZOgRtPhGWwwFYljbeJ7yAgEnyYNCWMGEwTaBLMEkxCzAJBgNVBAYTAkVHMRQwEgYDVQQKEwtFZ3lwdCBUcnVzdDEkMCIGA1UEAxMbRWd5cHQgVHJ1c3QgQ29ycG9yYXRlIENBIEcyAhBBZDqkVZVWq9BdJ9xWTi4iMAsGCSqGSIb3DQEBAQSCAQCl8p4kZzD5PHMrMa+ZsKU2S+Ifl6mC1vFnxA0H+TWiCFDKoLCKsShLsgSWr65tkle5uiTS3GlAqJC24w1cjbjKLrMiZkDdDNXrZjY7TuUMLtf9sGA/Zaf8p5XJoPqlqnHUi3yB1A+IaWow86A7wCg9JjB/XEovQWAQ2cr0/WnwOZLx9yhksfxymK4Ne186hDTIGlUu5F2WkfT18YLHD3iLiTGSSINkXohCw/W8FKpNDDY5zPHd63dWABgA73BauaN3YEf7AdA6fItPaZC17Fr4aOiyyIJfZglvXCzmICxf2reGcd0rIA+0IU/7icKhXQrq/cimz8cpaxXoM1hAVqEf</value>\r\n </signature>\r\n </signatures>\r\n </document>\r\n </documents>\r\n</submission>"
},
"url": {
"raw": "{{apiBaseUrl}}/api/v1/documentsubmissions",
"host": [
"{{apiBaseUrl}}"
],
"path": [
"api",
"v1",
"documentsubmissions"
]
}
},
"response": [
]
}