| # Dutch Tax Audit File The Create Tax Audit File (Dutch) (tfgld8200m000) session allows you to submit your financial data for audit in digital form and in the format specified by the Dutch tax authorities. The audit file is based on the data in the General Ledger module. Each line of the audit file contains the complete information of one transaction. ERP Enterprise generates a separate file for each financial period. For example, if you select a range of 3 financial periods, ERP Enterprise generates three audit files. In a multicompany structure, a separate file is generated for each financial company. Technical description of the Dutch tax audit file The audit file is an ASCII file in DOS format. The file name consists of up to 8 characters that reflect the fiscal year and period covered by the file. The file extension must be '.adf'. For example, an audit file for the first quarter of year 2012 has the filename: NL201201.adf. The lines are separated by the Carriage Return/Line Feed combination (013 010). The file consists of a header and lines. The following rules apply to the lists in this topic: Position = position in the audit file. ERP Enterprise table field = the table code and field name from which ERP Enterprise retrieves the data. Fields of the audit file that are not applicable to the ERP Enterprise data must contain spaces. Alphanumeric fields that contain a numeric code must have a fixed length. Use leading zeroes if necessary. Dates can be in the following formats: ddmmyyyy Use leading zeroes for days, months, and years. For example: 07112012, 13032012, 16122012 dd-mm-yyyy No leading zeroes needed Examples: 7-11-2012, 13-3-2012, 16-12-2012 Decimal values You can use . or , as the decimal sign. If the decimal sign is present, the decimals must also be present. In addition, you can use . or , as a thousands separator. Note: the Currency Rate value must have 6 decimal places. Examples of decimal values: 987.564 346,25 7756,10 32,346.25 10 Header The header contains the following fields: Audit file version Value: must be 'CLAIR1.00.00' ERP Enterprise table field: Not applicable Position: 1 Length: 12 Mandatory: Yes Type: Alphanumeric Financial application Value: ERP Enterprise 5.2 ERP Enterprise table field: Not applicable Position: 13 Length: 50 Mandatory: No Type: Alphanumeric Administration code Value: Spaces (not applicable) Position: 63 Length: 20 Mandatory: No Type: Alphanumeric Year/period Value: Fiscal Period and Fiscal Period ERP Enterprise table fields: tfgld106.fyer and tfgld106.fprd Position: 83 Length: 15 Mandatory: Yes Type: Alphanumeric Your company's fiscal number Value: Tax Number of the company's address entered in the Implemented Software Components (tccom0100s000) session. ERP Enterprise table field: tccom130.fovn Position: 98 Length: 15 Mandatory: No Type: Alphanumeric Company's name Value: Name ERP Enterprise table field: tccom000.nama Position: 113 Length: 50 Mandatory: Yes Type: Alphanumeric Company's address Value: Street and House Number of the address entered in the Implemented Software Components (tccom0100s000) session. ERP Enterprise table field: tccom130.namc, tccom130.hono Position: 163 Length: 30 Mandatory: No Type: Alphanumeric City of the company's address Value: The place name of the address entered in the Implemented Software Components (tccom0100s000) session. ERP Enterprise table field: tccom139.dsca Position: 193 Length: 30 Mandatory: No Type: Alphanumeric Number of transactions Value: Total number of transactions. ERP Enterprise table field: Not applicable Position: 223 Length: 10 Mandatory: No Type: Integer File creation date Value: The current date. ERP Enterprise table field: Not applicable Position: 233 Length: 10 Mandatory: No Type: Date Total debit value Value: Sum of the debit amounts in the local currency. ERP Enterprise table field: Not applicable Position: 243 Length: 16 Mandatory: No Type: Decimal Total credit value Value: Sum of the credit amounts in the local currency. ERP Enterprise table field: Not applicable Position: 259 Length: 16 Mandatory: No Type: Decimal Lines Each line of the tax audit file contains the following fields: Transaction Type Value: Transaction Type If numeric, use leading zeroes. ERP Enterprise table field: tfgld106.otyp Position: 1 Length: 20 Mandatory: No Type: Alphanumeric Transaction type description Value: Description ERP Enterprise table field: tfgld011.desc Position: 21 Length: 30 Mandatory: Yes, if the transaction type is present. Type: Alphanumeric Period Value: The fiscal period of the transaction. ERP Enterprise table field: tfgld106.fprd Position: 51 Length: 5 Mandatory: No Type: Alphanumeric Document number Value: Document Number ERP Enterprise table field: tfgld106.odoc Position: 56 Length: 10 Mandatory: No Type: Alphanumeric Note: The combination of document number, transaction type, and fiscal period uniquely identifies the transaction. The document number must be the same for all lines of one transaction. Line number Value: Line of the transaction line. ERP Enterprise table field: tfgld106.olin Position: 65 Length: 5 Mandatory: No Type: Integer Note: A unique number for each transaction line. Sequence Number Value: Sequence Number of the tax line. ERP Enterprise table field: tfgld106.osrl Position: 71 Length: 20 Mandatory: Yes, if more than one tax line exists. Type: Alphanumeric Finalization Date Value: Finalization Date ERP Enterprise table field: tfgld106.date Position: 91 Length: 10 Mandatory: No Type: Date Ledger Account Value: Ledger Account ERP Enterprise table field: tfgld106.leac Position: 101 Length: 15 Mandatory: No Type: Alphanumeric Note: If numeric, use leading zeroes. Ledger Account Type Value: Account Type ERP Enterprise table field: tfgld008.atyp Position: 116 Length: 5 Mandatory: No Type: Alphanumeric Examples: Balance, Profit and Loss Parent Ledger Account Value: Statutory Parent Account ERP Enterprise table field: tfgld008.plac Position: 121 Length: 15 Mandatory: No Type: Alphanumeric Note: The immediate parent ledger account if it exists. If numeric, use leading zeroes. Ledger Account description Value: Ledger Account Description of the transaction ledger account. ERP Enterprise table field: tfgld008.desc Position: 136 Length: 30 Mandatory: Yes Type: Alphanumeric Transaction Date Value: Date ERP Enterprise table field: tfgld106.dcdt Position: 166 Length: 10 Mandatory: Yes Type: Alphanumeric Transaction number Value: Spaces (not applicable). ERP Enterprise table field: Not applicable. Position: 176 Length: 15 Mandatory: No Type: Alphanumeric Kind of Transaction Value: Transaction Category ERP Enterprise table field: tfgld106.catg Position: 191 Length: 5 Mandatory: No Type: Alphanumeric Examples: Journal voucher, Purchase invoice. Other administration relationship Value: Spaces (not applicable). ERP Enterprise table field: Not applicable. Position: 196 Length: 15 Mandatory: No Type: Alphanumeric Cost Center Value: The dimension ERP Enterprise table field: tfgld106.dim1, tfgld106.dim2, tfgld106.dim3, tfgld106.dim4, tfgld106.dim5, tfgld106.dim6, tfgld106.dim7, tfgld106.dim8, tfgld106.dim9, tfgld106.dim10, tfgld106.dim11, or tfgld106.dim12. Position: 211 Length: 15 Mandatory: No Type: Alphanumeric Note: The dimension value from tfgld106.dim that corresponds to the dimension type entered in the Create Tax Audit File (Dutch) (tfgld8200m000) session. Cost Type Value: The dimension ERP Enterprise table field: tfgld106.dim1, tfgld106.dim2, tfgld106.dim3, tfgld106.dim4, tfgld106.dim5, tfgld106.dim6, tfgld106.dim7, tfgld106.dim8, tfgld106.dim9, tfgld106.dim10, tfgld106.dim11, or tfgld106.dim12. Position: 226 Length: 15 Mandatory: No Type: Alphanumeric Note: The dimension value from tfgld106.dim that corresponds to the dimension type entered in the Create Tax Audit File (Dutch) (tfgld8200m000) session. Product type Value: The dimension ERP Enterprise table field: tfgld106.dim1, tfgld106.dim2, tfgld106.dim3, tfgld106.dim4, tfgld106.dim5, tfgld106.dim6, tfgld106.dim7, tfgld106.dim8, tfgld106.dim9, tfgld106.dim10, tfgld106.dim11, or tfgld106.dim12. Position: 241 Length: 15 Mandatory: No Type: Alphanumeric Note: The dimension value from tfgld106.dim that corresponds to the dimension type entered in the Create Tax Audit File (Dutch) (tfgld8200m000) session. Description Value: Transaction Reference ERP Enterprise table field: tfgld106.refr Position: 256 Length: 30 Mandatory: Yes Type: Alphanumeric Note: A description of the transaction. Debit amount Value: Amount ERP Enterprise table field: tfgld106.amnt Position: 286 Length: 16 Mandatory: Yes Type: Decimal Note: The debit amount excluding the VAT amount, in the transaction currency. If the transaction amount is a credit amount, this field is zero. Credit amount Value: Amount ERP Enterprise table field: tfgld106.amnt Position: 302 Length: 16 Mandatory: Yes Type: Decimal Note: The credit amount excluding the VAT amount, in the transaction currency. If the transaction amount is a debit amount, this field is zero. Tax code Value: Tax Code ERP Enterprise table field: tfgld106.cvat Position: 318 Length: 5 Mandatory: No Type: Alphanumeric Note: The tax code that applies to the transaction. Only applies to tax lines. Currency Value: Currency ERP Enterprise table field: tfgld106.ccur Position: 323 Length: 10 Mandatory: No Type: Alphanumeric Currency rate Value: Rate of the transaction ERP Enterprise table field: tfgld106.rate Position: 333 Length: 13 Mandatory: No Type: Decimal value with 6 decimal places. Format: <nnnnnn.nnnnnn> Note: The rate between the transaction currency and the local currency. Business partner code Value: Business Partner. If numeric, use leading zeroes. ERP Enterprise table field: tfgld106.bpid Position: 346 Length: 15 Mandatory: No Type: Alphanumeric Note: The business partner code identifies the business partner across various administrations. Business partner type Value: D = customer (for a sales transaction). C = Supplier (for a purchase transaction). ERP Enterprise table field: Not applicable Position: 361 Length: 5 Mandatory: No Type: Alphanumeric Business partner's fiscal number Value: Tax Number ERP Enterprise table field: tccom100.fovn Position: 366 Length: 16 Mandatory: No Type: Alphanumeric Business partner's name Value: Tax Number ERP Enterprise table field: tccom100.nama Position: 382 Length: 30 Mandatory: Yes if a business partner is present. Type: Alphanumeric Business partner's address Value: Street and house number of the business partner's address. ERP Enterprise table fields: tccom130.namc and tccom130.hono Position: 412 Length: 30 Mandatory: Yes if a business partner is present. Type: Alphanumeric ZIP code Value: ZIP Code/Postal Code of the business partner's address. ERP Enterprise table field: tccom130.pstc Position: 442 Length: 10 Mandatory: No Type: Alphanumeric Place Value: The place name of the business partner's address. ERP Enterprise table field: tccom139.dsca Position: 452 Length: 30 Mandatory: Yes if a business partner is present. Type: Alphanumeric Country Value: Country of the business partner's address. ERP Enterprise table field: tcmcs010.desc Position: 482 Length: 15 Mandatory: No Type: Alphanumeric |