arapXML | ||||||||
|
|
BizTalk
Framework� Schema Description
Schema Name: LedgerImport 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, Contact Information Steve Hocking, technical contact |
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>
BizTalk� and Biztalk Framework� are
registered trademarks of Microsoft Corporation.
� 2000 Microsoft Corporation and Radius Computer Services Ltd.