taken from the
The Document records or data are saved in a XML (Extended
Mark-up Language) file when the data is exported in the Tools - Export menu
option on the Documents tab and the XML File Type is selected. Once the data for
Documents have been saved to a file, you may access the file by locating it in
the specific location and file name where you have saved this file on your
system. You may use this XML file to store or to Import Documents. If Documents are
exported, two files are created, i.e.
Locate the file on your system. You may use the Windows
Explorer 
.
Double-click on the 
icon with the name
you have saved the specific data for the exported Stock Item file. The selected
file will be displayed.
The exported data consists of 2 sections in the XML file, i.e. Metadata and Rowdata sections.
Metadata section of the file:
The data fields and their properties are defined in the Metadata section of the file. This is similar to that of row 1 (Headings) in an exported spreadsheet file.
Rowdata section of the file:
The individual details or data as entered in the Edit - Stock Items menu option are defined in each row after the field name starts with the tag "<" and ends with the tag ">". Each field for a transaction (e.g. Description, etc.) are displayed in a bold font type and is displayed between an identifier ("), (e.g. SDocNo="OR000001").
The respective fields are as follows:
The data fields of the XML file is displayed on the screens in TurboCASH as follows:
To access the XML Lines file:
Locate the file on your system. You may use the Windows
Explorer .
Double-click on the icon with the name
you have saved the specific data for the exported Documents file. The selected
file will be displayed.
The exported data consists of 2 sections in the XML file, i.e. Metadata and Rowdata sections.
Metadata section of the file:
The data fields and their properties are defined in the Metadata section of the file. This is similar to that of row 1 (Headings) in an exported spreadsheet file.
Rowdata section of the file:
The individual details or data as entered in the Edit - Stock Items menu option are defined in each row after the field name starts with the tag "<" and ends with the tag ">". Each field for a transaction (e.g. Description, etc.) are displayed in a bold font type and is displayed between an identifier ("), (e.g. SDescription="Drill Press").
The respective fields are as follows:
The data fields of the XML file is displayed on the screens in TurboCASH as follows:
-
Header File - contains the information generated,
selected and entered on the Document Entry Header screen. This information
includes an unique ID number created for each document, document type
(Invoice, Credit Note, Purchase, Goods Returned document, Quotes and Orders),
as well as the Total amount of the Document Inclusive of VAT, the VAT amount
and the status of the document (printed and posted or not), etc.
- Lines File - contains information regarding the transactions and comments selected and entered on the Document Entry Details screen.
Locate the file on your system. You may use the Windows
Explorer . Double-click on the icon with the name
you have saved the specific data for the exported Stock Item file. The selected
file will be displayed.
The exported data consists of 2 sections in the XML file, i.e. Metadata and Rowdata sections.
Metadata section of the file:
The data fields and their properties are defined in the Metadata section of the file. This is similar to that of row 1 (Headings) in an exported spreadsheet file.
Rowdata section of the file:
The individual details or data as entered in the Edit - Stock Items menu option are defined in each row after the field name starts with the tag "<" and ends with the tag ">". Each field for a transaction (e.g. Description, etc.) are displayed in a bold font type and is displayed between an identifier ("), (e.g. SDocNo="OR000001").
The respective fields are as follows:
The data fields of the XML file is displayed on the screens in TurboCASH as follows:
| Col. | Field | Details | Value |
| A | WDocID | TurboCASH generates a unique Document identification number for each document created. | Numeric |
| B | WTypeID |
Invoice=10 Credit Note=11 Purchase=12 Goods Returned=13 Quotes=14 Orders=15 |
Numeric |
| C | DDate | Date when document is created. | Date |
| D | DAllocatedDate | Allocated Date. | Date |
| E | SDocNo | Document number generated by TurboCASH | Alpha-numeric |
| F | SReference | Reference as entered in the Your Reference field. | Alpha-numeric |
| G | BPrinted | Printed=True or Unprinted=False | True/False |
| H | BPosted | Posted=True or Unposted=False | True/False |
| I | BExclusive | Exclusive=True or Inclusive=False mode. | True/False |
| J | FInvoiceDiscount | Full Invoice Discount amount | Amount |
| K | FDocAmount | Full Document amount | Amount |
| L | FTaxAmount | Full Tax amount | Amount |
| M | WAccountID | Account ID for Debtors / Creditors accounts | Numeric |
| N | WPaymentTypeID | Payment Type ID | |
| O | WPaymentGroupID | Payment Group ID | |
| P | BRepeating | Repeating Invoice | True |
| Q | SAccountCode | Debtor account or Creditor account number. | Alpha-numeric |
| R | WAccountTypeID | Account Type ID - 1=Debtor and 2=Creditor | 1 or 2 |
| S | SPost1 | Postal Address line 1 | Alpha-numeric |
| T | SPost2 | Postal Address line 2 | Alpha-numeric |
| U | SPost3 | Postal Address line 3 | Alpha-numeric |
| V | SPostCode | Postal Address Postal Code | Alpha-numeric |
| W | SMsg 1 | Message line 1 | Alpha-numeric |
| X | SMsg 2 | Message line 2 | Alpha-numeric |
| Y | SMsg 3 | Message line 3 | Alpha-numeric |
| Z | SSalesperson | Selected for Invoices, Credit Notes and Quotes only. | Alpha-numeric |
| AA | SDel1 | Delivery Address line 1 | Alpha-numeric |
| AB | SDel2 | Delivery Address line 2 | Alpha-numeric |
| AC | SDel3 | Delivery Address line 3 | Alpha-numeric |
| AD | SDelCode | Delivery Address Postal Code | Alpha-numeric |
| AE | SGroup1 | Document Group 1 | Alpha-numeric |
| AF | SGroup2 | Document Group 2 | Alpha-numeric |
| AG | SCurrency | Currency | Alpha-numeric |
| AH | SUserName | User Name if users were created. | Alpha-numeric |
To access the XML Lines file:
Locate the file on your system. You may use the Windows
Explorer . Double-click on the icon with the name
you have saved the specific data for the exported Documents file. The selected
file will be displayed.The exported data consists of 2 sections in the XML file, i.e. Metadata and Rowdata sections.
Metadata section of the file:
The data fields and their properties are defined in the Metadata section of the file. This is similar to that of row 1 (Headings) in an exported spreadsheet file.
Rowdata section of the file:
The individual details or data as entered in the Edit - Stock Items menu option are defined in each row after the field name starts with the tag "<" and ends with the tag ">". Each field for a transaction (e.g. Description, etc.) are displayed in a bold font type and is displayed between an identifier ("), (e.g. SDescription="Drill Press").
The respective fields are as follows:
The data fields of the XML file is displayed on the screens in TurboCASH as follows:
| Col. | Field | Details | Value |
| A | WDocID | TurboCASH generates a unique Document identification number for each document created. | Numeric |
| B | WLineTypeID |
Transaction=90 Comment=91 |
Numeric |
| C | WLineID | Line number for each transaction in documents. | Numeric |
| D | WStockID | Numeric ID created by TurboCASH for each Stock Item in the Stock Item code file. | Numeric |
| E | FQtyOrder | Quantity entered in the Order column. | Alpha-numeric |
| F | FQtyShipped | Quantity entered in the Shipped column. | Alpha-numeric |
| G | FSellingPrice | Selected or edited selling price | Amount |
| H | FItemDiscount | Amount of Discount for the transaction / line. | Amount |
| I | WTaxID | VAT or Tax account ID number. | Numeric |
| J | FInclusiveAmt | Invoice Discount amount | Amount |
| K | FExclusiveAmt | Full Document amount | Amount |
| L | FTaxAmount | Full Tax amount | Amount |
| M | SDescription | Stock Item description or name. | Alpha-numeric |
| N | SAccountCode | Tax account code | Alpha-numeric |
| O | SStockCode | Stock Item code | Alpha-numeric |
