TurboCASH Accounting Software TurboCASH United Kingdom
Select your Country
OPEN SOURCE ACCOUNTING SOFTWARE
HomeFeatures & ScreenshotsShop onlineCompareFAQForumRegisterContact
Community
Free Downloads
Shop
Other Titles

Using TurboCASH

 







EXPORT DATA
EXPORT CREDITORS TO A XML FILE
  
The Creditors 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 Creditors tab and the XML File Type is selected. Once the data for Creditors 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 Creditors.

To access the XML 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 creditor 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.

Rowdata section of the file:

The individual creditor's details or data as entered in the Edit - Accounts - Creditors are defined in each row after the field name.

The respective fields are as follows:

General Information tab:



Remittance tab:



Accounting Information tab:



The detail for the columns is as follows:

Column Field Creditor Account - Tabs Values
A Account number General Information Alpha-numerical
B Name General Information Alpha-numerical
C Contact Person General Information Alpha-numerical
D Address 1 General Information Alpha-numerical
E Address 2 General Information Alpha-numerical
F Address 3 General Information Alpha-numerical
G Postal Code General Information Alpha-numerical
H Delivery Address 1 Remittance Alpha-numerical
I Delivery Address 2 Remittance Alpha-numerical
J Delivery Address 3 Remittance Alpha-numerical
K Phone 1 General Information Alpha-numerical
L Phone 2 General Information Alpha-numerical
M E-mail General Information Alpha-numerical
N Fax number General Information Alpha-numerical
O Credit Limit Accounting Information Amount
P Charge Amount Accounting Information Amount
Q Discount  

 

R Open Item Account Accounting Information True = Yes

False = No
S Remittance Message Remittance Alpha-numerical
T Default Selling Price  

 

U Last Activity  

Date
V Tax Reference Accounting Information Alpha-numerical
W Creditor Group 1 Accounting Information Alpha-numerical
X Creditor Group 2 Accounting Information Alpha-numerical