arapXML 
Home  XML Schema OMG submission Use Cases Discussion  Requirements Research About arapXML
Overview of Radius, PLC's LedgerImport format for General Ledger Data

LedgerImport is a classic double entry (CDEA) header/rows structure.

    
BizTalk Framework� Schema Description

Schema Name: LedgerImport
2/9/2000 3:38:52 AM
Schema Description

This schema represents data to be imported into a General Ledger system. This is the proposed format of XML Ledger imports

Controlling Organization

Radius Computer Services,
http://www.radiusplc.co.uk
Plane Tree Crescent,
Feltham,
Middlesex,
TW13 7DT.

Contact Information

Steve Hocking, technical contact
[email protected] 

 

Field Dictionary

Field Name Field Type Valid Values/Description
Members of <Header> record
voucherType string A code representing the description of a balanced batch of transactions
voucherSource string A code representing where the batch of transactions originated
VoucherDate date The financial date for the batch of transactions
VoucherNarrative string A textual description for the batch of transactions
targetLedger string The ledger that the transactions should be entered into
Members of <Line> record
transactionType string A code representing the type of transaction
transactionSource string A code representing where the transaction was taken
TransactionDate date The date the transaction was for
TransactionNarrative string Description of the transaction
accountCode string A code representing the account to be updated 
additionalCode string An additional reference to be used if required (Eg. for reporting purposes)
TransactionAmount float The value of the transaction in local currency
ForeignAmount float If the transaction was paid for with foreign currency, the amount paid in the foreign currency
Currency string The currency in which the transaction was made
 
Schema:
 
<Schema name="LedgerImport" xmlns="urn:schemas-microsoft-com:xml-data" xmlns:dt="urn:schemas-microsoft-com:datatypes">
   <ElementType name="LedgerImport" content="eltOnly">
      <description>The main file structure, this ensures that there is one and one only header, and at least one line</description>
      <element type="Header" minOccurs="1" maxOccurs="1"/>
      <element type="Line" minOccurs="1" maxOccurs="*"/>
   </ElementType>
   <ElementType name="Header" content="eltOnly">
      <description>Summary of the data extracted for the ledger export</description>
      <element type="voucherType" minOccurs="1" maxOccurs="1"/>
      <element type="voucherSource" minOccurs="1" maxOccurs="1"/>
      <element type="VoucherDate" minOccurs="1" maxOccurs="1"/>
      <element type="VoucherNarrative" minOccurs="1" maxOccurs="1"/>
      <element type="targetLedger" minOccurs="1" maxOccurs="1"/>
   </ElementType>
   <ElementType name="Line" content="eltOnly">
      <description>A single line of information exported from RadiusICON, could be a Detail line, Summary line, Control line, or VAT line</description>
      <element type="transactionType" minOccurs="1" maxOccurs="1"/>
      <element type="transactionSource" minOccurs="1" maxOccurs="1"/>
      <element type="TransactionDate" minOccurs="1" maxOccurs="1"/>
      <element type="TransactionNarrative" minOccurs="1" maxOccurs="1"/>
      <element type="accountCode" minOccurs="1" maxOccurs="1"/>
      <element type="additionalCode" minOccurs="1" maxOccurs="1"/>
      <element type="TransactionAmount" minOccurs="1" maxOccurs="1"/>
      <element type="ForeignAmount" minOccurs="0" maxOccurs="1"/>
      <element type="Currency" minOccurs="0" maxOccurs="1"/>
   </ElementType>
   <ElementType name="voucherType" content="textOnly" dt:type="string"/>
   <ElementType name="voucherSource" content="textOnly" dt:type="string"/>
   <ElementType name="VoucherDate" content="textOnly" dt:type="date"/>
   <ElementType name="VoucherNarrative" content="textOnly" dt:type="string"/>
   <ElementType name="transactionType" content="textOnly" dt:type="string"/>
   <ElementType name="transactionSource" content="textOnly" dt:type="string"/>
   <ElementType name="TransactionDate" content="textOnly" dt:type="date"/>
   <ElementType name="TransactionNarrative" content="textOnly" dt:type="string"/>
   <ElementType name="targetLedger" content="textOnly" dt:type="string"/>
   <ElementType name="accountCode" content="textOnly" dt:type="string"/>
   <ElementType name="additionalCode" content="textOnly" dt:type="string"/>
   <ElementType name="TransactionAmount" content="textOnly" dt:type="float"/>
   <ElementType name="ForeignAmount" content="textOnly" dt:type="float"/>
   <ElementType name="Currency" content="textOnly" dt:type="string"/>
</Schema>
Sample:
<Body>
   <LedgerImport xmlns="x-schema:http://schemas.biztalk.org/radiusplc_co_uk/h1iga8wn.xml">
      <Header>
         <voucherType>Test</voucherType>
         <voucherSource>Steve</voucherSource>
         <VoucherDate>2000-01-13</VoucherDate>
         <VoucherNarrative>Test ledger voucher</VoucherNarrative>
         <targetLedger>Test</targetLedger>
      </Header>
      <Line>
         <transactionType>Test</transactionType>
         <transactionSource>Steve</transactionSource>
         <TransactionDate>2000-01-13</TransactionDate>
         <TransactionNarrative>Test transaction</TransactionNarrative>
         <accountCode>0123456789</accountCode>
         <additionalCode>0123456789</additionalCode>
         <TransactionAmount>100.00</TransactionAmount>
         <ForeignAmount>0.0</ForeignAmount>
         <Currency>NONE</Currency>
      </Line>
   </LedgerImport>
</Body>

Copyright and Trademark Information

BizTalk� and Biztalk Framework� are registered trademarks of Microsoft Corporation.
� 2000 Microsoft Corporation and Radius Computer Services Ltd.