Understanding the Data Extraction Programs (Release 9.2 Update)

Most tax-relevant data resides in the F0911, F0411, F03B11, and F0018 tables. When you run the extraction programs for these tables, the system generates a text file that it writes to the Export folder of the installation directory. The system does not generate a report when you run these programs. The text files are semi-colon (;) delimited with double quote (") text encapsulation.

Information about transactions that might be subject to review by the tax authority might be written to more than one table. For example, the taxable amount of a transaction (data item ATXA) might be written to both the F0411 and the F0018 tables. The system extracts all data in a table, even when that data is duplicated in another table.

Note: If data requested by the tax authority does not reside in the F0911, F0411, F03B11, or F0018 tables, you must create custom table conversion programs to extract the additional data and modify the Index.XML file to describe the additional data.